cloudreve
关于v4最新版略缩图bug问题
就是我使用本地存储策略 视频和图片封面都可以正常生成 使用腾讯对象存储cos后只有图片封面正常 视频封面不生成 我也开启了代理生成功能和数据万象依然无法生成 查看日志发现貌似是发送请求的时候传递的生成参数是图片略缩图的参数 导致cos返回了400拒绝 处理 希望尽快解决！
[Info] 2025-10-11 23:19:33 [/home/vsts/work/1/s/application/dependency/dependency.go:267] Logger initialized with LogLevel="debug".
/ \ | ___ _ _ | | __ _____ _____ / / | |/ _ | | | |/ _ | '/ _ \ \ / / _ \ / /| | () | || | (| | | | _/\ V / / _/||_/ _,|_,|_| _| _/ ___|
V4.8.0 Commit #7d97237 Pro=false
[Inf
[4f7-db85f9c56c56] [Incoming] 200 | 3.011997ms | 223.104.68.181 | GET "/api/v4/site/config/explorer"
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 57a47e22-24c7-4e49-b374-06d0401bb648] driver.Query: query=SELECT users.id, users.created_at, users.updated_at, users.deleted_at, users.email, users.nick, users.password, users.status, users.storage, users.two_factor_secret, users.avatar, users.settings, users.group_users FROM users WHERE (users.id = ? AND users.status = ?) AND users.deleted_at IS NULL LIMIT 1 args=[1 active] time=693.982µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 57a47e22-24c7-4e49-b374-06d0401bb648] driver.Query: query=SELECT groups.id, groups.created_at, groups.updated_at, groups.deleted_at, groups.name, groups.max_storage, groups.speed_limit, groups.permissions, groups.settings, groups.storage_policy_id FROM groups WHERE groups.id IN (?) AND groups.deleted_at IS NULL args=[1] time=438.534µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 57a47e22-24c7-4e49-b374-06d0401bb648] driver.Query: query=SELECT users.id, users.created_at, users.updated_at, users.deleted_at, users.email, users.nick, users.password, users.status, users.storage, users.two_factor_secret, users.avatar, users.settings, users.group_users FROM users WHERE users.id = ? AND users.deleted_at IS NULL LIMIT 1 args=[1] time=421.05µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 57a47e22-24c7-4e49-b374-06d0401bb648] driver.Query: query=SELECT groups.id, groups.created_at, groups.updated_at, groups.deleted_at, groups.name, groups.max_storage, groups.speed_limit, groups.permissions, groups.settings, groups.storage_policy_id FROM groups WHERE groups.id IN (?) AND groups.deleted_at IS NULL args=[1] time=361.204µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 57a47e22-24c7-4e49-b374-06d0401bb648] driver.Query: query=SELECT DISTINCT files.id, files.created_at, files.updated_at, files.type, files.name, files.owner_id, files.size, files.primary_entity, files.file_children, files.is_symbolic, files.props, files.storage_policy_files FROM files WHERE (owner_id = ? AND (NOT (files.file_children IS NOT NULL))) AND files.name = ? LIMIT 1 args=[1 ] time=467.901µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 57a47e22-24c7-4e49-b374-06d0401bb648] driver.Query: query=SELECT DISTINCT files.id, files.created_at, files.updated_at, files.type, files.name, files.owner_id, files.size, files.primary_entity, files.file_children, files.is_symbolic, files.props, files.storage_policy_files FROM files WHERE file_children = ? AND files.type = ? ORDER BY files.id LIMIT 101 args=[1 1] time=480.866µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 57a47e22-24c7-4e49-b374-06d0401bb648] driver.Query: query=SELECT metadata.id, metadata.created_at, metadata.updated_at, metadata.deleted_at, metadata.name, metadata.value, metadata.file_id, metadata.is_public FROM metadata WHERE (metadata.is_public AND metadata.file_id IN (?)) AND metadata.deleted_at IS NULL args=[31] time=459.415µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 57a47e22-24c7-4e49-b374-06d0401bb648] driver.Query: query=SELECT shares.id, shares.created_at, shares.updated_at, shares.deleted_at, shares.password, shares.views, shares.downloads, shares.expires, shares.remain_downloads, shares.props, shares.file_shares, shares.user_shares FROM shares WHERE shares.file_shares IN (?) AND shares.deleted_at IS NULL args=[31] time=427.095µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 57a47e22-24c7-4e49-b374-06d0401bb648] driver.Query: query=SELECT DISTINCT files.id, files.created_at, files.updated_at, files.type, files.name, files.owner_id, files.size, files.primary_entity, files.file_children, files.is_symbolic, files.props, files.storage_policy_files FROM files WHERE file_children = ? AND files.type = ? ORDER BY files.id LIMIT 100 args=[1 0] time=526.036µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 57a47e22-24c7-4e49-b374-06d0401bb648] driver.Query: query=SELECT metadata.id, metadata.created_at, metadata.updated_at, metadata.deleted_at, metadata.name, metadata.value, metadata.file_id, metadata.is_public FROM metadata WHERE (metadata.is_public AND metadata.file_id IN (?, ?, ?)) AND metadata.deleted_at IS NULL args=[40 43 47] time=418.503µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 57a47e22-24c7-4e49-b374-06d0401bb648] driver.Query: query=SELECT shares.id, shares.created_at, shares.updated_at, shares.deleted_at, shares.password, shares.views, shares.downloads, shares.expires, shares.remain_downloads, shares.props, shares.file_shares, shares.user_shares FROM shares WHERE shares.file_shares IN (?, ?, ?) AND shares.deleted_at IS NULL args=[40 43 47] time=380.52µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 57a47e22-24c7-4e49-b374-06d0401bb648] driver.Query: query=SELECT DISTINCT storage_policies.id, storage_policies.created_at, storage_policies.updated_at, storage_policies.deleted_at, storage_policies.name, storage_policies.type, storage_policies.server, storage_policies.bucket_name, storage_policies.is_private, storage_policies.access_key, storage_policies.secret_key, storage_policies.max_size, storage_policies.dir_name_rule, storage_policies.file_name_rule, storage_policies.settings, storage_policies.node_id FROM storage_policies JOIN (SELECT storage_policy_id FROM groups WHERE id = ?) AS t1 ON storage_policies.id = t1.storage_policy_id WHERE storage_policies.deleted_at IS NULL LIMIT 1 args=[1] time=483.1µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 57a47e22-24c7-4e49-b374-06d0401bb648] driver.Query: query=SELECT nodes.id, nodes.created_at, nodes.updated_at, nodes.deleted_at, nodes.status, nodes.name, nodes.type, nodes.server, nodes.slave_key, nodes.capabilities, nodes.settings, nodes.weight FROM nodes WHERE nodes.id IN (?) AND nodes.deleted_at IS NULL args=[0] time=361.88µs
[Info] 2025-10-11 23:23:57 [/home/vsts/work/1/s/pkg/logging/logger.go:193] [Cid: 57a47e22-24c7-4e49-b374-06d0401bb648] [Incoming] 200 | 10.167775ms | 223.104.68.181 | GET "/api/v4/file?uri=cloudreve:%2F%2Fmy"
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 7d7aafbb-6c25-41ea-a3b2-6d34bb16d3d6] driver.Query: query=SELECT users.id, users.created_at, users.updated_at, users.deleted_at, users.email, users.nick, users.password, users.status, users.storage, users.two_factor_secret, users.avatar, users.settings, users.group_users FROM users WHERE (users.id = ? AND users.status = ?) AND users.deleted_at IS NULL LIMIT 1 args=[1 active] time=716.138µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 7d7aafbb-6c25-41ea-a3b2-6d34bb16d3d6] driver.Query: query=SELECT groups.id, groups.created_at, groups.updated_at, groups.deleted_at, groups.name, groups.max_storage, groups.speed_limit, groups.permissions, groups.settings, groups.storage_policy_id FROM groups WHERE groups.id IN (?) AND groups.deleted_at IS NULL args=[1] time=402.073µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 7d7aafbb-6c25-41ea-a3b2-6d34bb16d3d6] driver.Query: query=SELECT users.id, users.created_at, users.updated_at, users.deleted_at, users.email, users.nick, users.password, users.status, users.storage, users.two_factor_secret, users.avatar, users.settings, users.group_users FROM users WHERE users.id = ? AND users.deleted_at IS NULL LIMIT 1 args=[1] time=441.686µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 7d7aafbb-6c25-41ea-a3b2-6d34bb16d3d6] driver.Query: query=SELECT groups.id, groups.created_at, groups.updated_at, groups.deleted_at, groups.name, groups.max_storage, groups.speed_limit, groups.permissions, groups.settings, groups.storage_policy_id FROM groups WHERE groups.id IN (?) AND groups.deleted_at IS NULL args=[1] time=370.86µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 7d7aafbb-6c25-41ea-a3b2-6d34bb16d3d6] driver.Query: query=SELECT DISTINCT files.id, files.created_at, files.updated_at, files.type, files.name, files.owner_id, files.size, files.primary_entity, files.file_children, files.is_symbolic, files.props, files.storage_policy_files FROM files WHERE (owner_id = ? AND (NOT (files.file_children IS NOT NULL))) AND files.name = ? LIMIT 1 args=[1 ] time=476.497µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 7d7aafbb-6c25-41ea-a3b2-6d34bb16d3d6] driver.Query: query=SELECT DISTINCT files.id, files.created_at, files.updated_at, files.type, files.name, files.owner_id, files.size, files.primary_entity, files.file_children, files.is_symbolic, files.props, files.storage_policy_files FROM files WHERE file_children = ? AND files.name = ? LIMIT 1 args=[1 3f54f8c1becd4994db9c05465a3d1877.jpeg] time=422.535µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 7d7aafbb-6c25-41ea-a3b2-6d34bb16d3d6] driver.Query: query=SELECT metadata.id, metadata.created_at, metadata.updated_at, metadata.deleted_at, metadata.name, metadata.value, metadata.file_id, metadata.is_public FROM metadata WHERE (metadata.is_public AND metadata.file_id IN (?)) AND metadata.deleted_at IS NULL args=[40] time=421.207µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 7d7aafbb-6c25-41ea-a3b2-6d34bb16d3d6] driver.Query: query=SELECT t1.file_id, entities.id, entities.created_at, entities.updated_at, entities.deleted_at, entities.type, entities.source, entities.size, entities.reference_count, entities.storage_policy_entities, entities.created_by, entities.upload_session_id, entities.recycle_options FROM entities JOIN file_entities AS t1 ON entities.id = t1.entity_id WHERE t1.file_id IN (?) AND entities.deleted_at IS NULL ORDER BY entities.id DESC args=[40] time=602.262µs
[Info] 2025-10-11 23:23:57 [/home/vsts/work/1/s/pkg/logging/logger.go:193] [Cid: 7d7aafbb-6c25-41ea-a3b2-6d34bb16d3d6] [Incoming] 200 | 8.373326ms | 223.104.68.181 | GET "/api/v4/file/thumb?uri=cloudreve:%2F%2Fmy%2F3f54f8c1becd4994db9c05465a3d1877.jpeg"
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 3495137c-1fbf-4187-bd51-14f60c6688eb] driver.Query: query=SELECT users.id, users.created_at, users.updated_at, users.deleted_at, users.email, users.nick, users.password, users.status, users.storage, users.two_factor_secret, users.avatar, users.settings, users.group_users FROM users WHERE (users.id = ? AND users.status = ?) AND users.deleted_at IS NULL LIMIT 1 args=[1 active] time=453.137µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 3495137c-1fbf-4187-bd51-14f60c6688eb] driver.Query: query=SELECT groups.id, groups.created_at, groups.updated_at, groups.deleted_at, groups.name, groups.max_storage, groups.speed_limit, groups.permissions, groups.settings, groups.storage_policy_id FROM groups WHERE groups.id IN (?) AND groups.deleted_at IS NULL args=[1] time=386.903µs
[Info] 2025-10-11 23:23:57 [/home/vsts/work/1/s/pkg/filemanager/fs/dbfs/dbfs.go:731] [Cid: 3495137c-1fbf-4187-bd51-14f60c6688eb] Navigator "my/GPsG/1" restored state ("e9c8e13f-d1b8-430a-b91a-debfa0680f8e") successfully
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 3495137c-1fbf-4187-bd51-14f60c6688eb] driver.Query: query=SELECT DISTINCT files.id, files.created_at, files.updated_at, files.type, files.name, files.owner_id, files.size, files.primary_entity, files.file_children, files.is_symbolic, files.props, files.storage_policy_files FROM files WHERE file_children = ? AND files.name = ? LIMIT 1 args=[1 v.mp4] time=392.679µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 3495137c-1fbf-4187-bd51-14f60c6688eb] driver.Query: query=SELECT metadata.id, metadata.created_at, metadata.updated_at, metadata.deleted_at, metadata.name, metadata.value, metadata.file_id, metadata.is_public FROM metadata WHERE (metadata.is_public AND metadata.file_id IN (?)) AND metadata.deleted_at IS NULL args=[47] time=424.896µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 3495137c-1fbf-4187-bd51-14f60c6688eb] driver.Query: query=SELECT t1.file_id, entities.id, entities.created_at, entities.updated_at, entities.deleted_at, entities.type, entities.source, entities.size, entities.reference_count, entities.storage_policy_entities, entities.created_by, entities.upload_session_id, entities.recycle_options FROM entities JOIN file_entities AS t1 ON entities.id = t1.entity_id WHERE t1.file_id IN (?) AND entities.deleted_at IS NULL ORDER BY entities.id DESC args=[47] time=658.027µs
[Info] 2025-10-11 23:23:57 [/home/vsts/work/1/s/pkg/logging/logger.go:193] [Cid: 3495137c-1fbf-4187-bd51-14f60c6688eb] [Incoming] 200 | 6.231881ms | 223.104.68.181 | GET "/api/v4/file/thumb?uri=cloudreve:%2F%2Fmy%2Fv.mp4"
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: a6261ed7-435a-4e90-8a1c-4a48cfbe1d21] driver.Query: query=SELECT groups.id, groups.created_at, groups.updated_at, groups.deleted_at, groups.name, groups.max_storage, groups.speed_limit, groups.permissions, groups.settings, groups.storage_policy_id FROM groups WHERE groups.id = ? AND groups.deleted_at IS NULL LIMIT 1 args=[3] time=760.926µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: a6261ed7-435a-4e90-8a1c-4a48cfbe1d21] driver.Query: query=SELECT entities.id, entities.created_at, entities.updated_at, entities.deleted_at, entities.type, entities.source, entities.size, entities.reference_count, entities.storage_policy_entities, entities.created_by, entities.upload_session_id, entities.recycle_options FROM entities WHERE entities.id IN (?) AND entities.deleted_at IS NULL args=[46] time=457.97µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 161270aa-e8c3-48e8-893d-bcebde898d59] driver.Query: query=SELECT groups.id, groups.created_at, groups.updated_at, groups.deleted_at, groups.name, groups.max_storage, groups.speed_limit, groups.permissions, groups.settings, groups.storage_policy_id FROM groups WHERE groups.id = ? AND groups.deleted_at IS NULL LIMIT 1 args=[3] time=513.561µs
[Debug] 2025-10-11 23:23:57 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 161270aa-e8c3-48e8-893d-bcebde898d59] driver.Query: query=SELECT entities.id, entities.created_at, entities.updated_at, entities.deleted_at, entities.type, entities.source, entities.size, entities.reference_count, entities.storage_policy_entities, entities.created_by, entities.upload_session_id, entities.recycle_options FROM entities WHERE entities.id IN (?) AND entities.deleted_at IS NULL args=[52] time=412.149µs
[Info] 2025-10-11 23:23:57 [/home/vsts/work/1/s/pkg/logging/logger.go:193] [Cid: a6261ed7-435a-4e90-8a1c-4a48cfbe1d21] [Outgoing] 200 | 124.847329ms | localhost | GET "https://yxwp.aaimtop.com/uploads/1/fcc3cecd-ed08-492b-bc30-bee4c0dfce9d_3f54f8c1becd4994db9c05465a3d1877.jpeg?imageMogr2%2Fthumbnail%2F400x300%2Fformat%2Fpng=&q-ak=AKID4GF1aBfvsdBYig6OTO8h5UdaJqCLG2bw&q-header-list=&q-key-time=1760196237%3B1760199837&q-sign-algorithm=sha1&q-sign-time=1760196237%3B1760199837&q-signature=0215ce3c7c09cab4e5f89b7a3b93dae37275c4e0&q-url-param-list="
[Info] 2025-10-11 23:23:57 [/home/vsts/work/1/s/pkg/logging/logger.go:193] [Cid: a6261ed7-435a-4e90-8a1c-4a48cfbe1d21] [Incoming] 200 | 136.184992ms | 223.104.68.181 | GET "/api/v4/file/content/WBoCb/0/3f54f8c1becd4994db9c05465a3d1877.jpeg?sign=-W2tyq_g2aW9cJ1oCp7-EnG7AKJheoN8FOhGJxsxb8A%3D%3A1760199837&thumb=true"
[Info] 2025-10-11 23:23:58 [/home/vsts/work/1/s/pkg/logging/logger.go:193] [Cid: 161270aa-e8c3-48e8-893d-bcebde898d59] [Outgoing] 400 | 323.627427ms | localhost | GET "https://yxwp.aaimtop.com/uploads/1/c77661dd-bd8c-423d-8909-f4a308e94699_v.mp4?imageMogr2%2Fthumbnail%2F400x300%2Fformat%2Fpng=&q-ak=AKID4GF1aBfvsdBYig6OTO8h5UdaJqCLG2bw&q-header-list=&q-key-time=1760196237%3B1760199837&q-sign-algorithm=sha1&q-sign-time=1760196237%3B1760199837&q-signature=cfc294cf784e93c076ec7f070abb5dc91c6a88c8&q-url-param-list="
[Info] 2025-10-11 23:23:58 [/home/vsts/work/1/s/pkg/logging/logger.go:193] [Cid: 161270aa-e8c3-48e8-893d-bcebde898d59] [Incoming] 400 | 326.796195ms | 223.104.68.181 | GET "/api/v4/file/content/1Getz/0/v.mp4?sign=hJOwEsy8NX0w-UqiKizz6LIdBcGtorpHt70V6ss_FyU%3D%3A1760199837&thumb=true"
[Info] 2025-10-11 23:23:59 [/home/vsts/work/1/s/pkg/logging/logger.go:193] [Cid: efcac7f8-b0ed-4f6b-98da-0fc7128ad126] [Incoming] 200 | 762.084µs | 223.104.68.181 | GET "/sw.js"
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] driver.Query: query=SELECT users.id, users.created_at, users.updated_at, users.deleted_at, users.email, users.nick, users.password, users.status, users.storage, users.two_factor_secret, users.avatar, users.settings, users.group_users FROM users WHERE (users.id = ? AND users.status = ?) AND users.deleted_at IS NULL LIMIT 1 args=[1 active] time=675.343µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] driver.Query: query=SELECT groups.id, groups.created_at, groups.updated_at, groups.deleted_at, groups.name, groups.max_storage, groups.speed_limit, groups.permissions, groups.settings, groups.storage_policy_id FROM groups WHERE groups.id IN (?) AND groups.deleted_at IS NULL args=[1] time=453.309µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] driver.Query: query=SELECT users.id, users.created_at, users.updated_at, users.deleted_at, users.email, users.nick, users.password, users.status, users.storage, users.two_factor_secret, users.avatar, users.settings, users.group_users FROM users WHERE users.id = ? AND users.deleted_at IS NULL LIMIT 1 args=[1] time=465.689µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] driver.Query: query=SELECT groups.id, groups.created_at, groups.updated_at, groups.deleted_at, groups.name, groups.max_storage, groups.speed_limit, groups.permissions, groups.settings, groups.storage_policy_id FROM groups WHERE groups.id IN (?) AND groups.deleted_at IS NULL args=[1] time=388.619µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] driver.Query: query=SELECT DISTINCT files.id, files.created_at, files.updated_at, files.type, files.name, files.owner_id, files.size, files.primary_entity, files.file_children, files.is_symbolic, files.props, files.storage_policy_files FROM files WHERE (owner_id = ? AND (NOT (files.file_children IS NOT NULL))) AND files.name = ? LIMIT 1 args=[1 ] time=421.542µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] driver.Query: query=SELECT DISTINCT files.id, files.created_at, files.updated_at, files.type, files.name, files.owner_id, files.size, files.primary_entity, files.file_children, files.is_symbolic, files.props, files.storage_policy_files FROM files WHERE file_children = ? AND files.name = ? LIMIT 1 args=[1 v.mp4] time=421.438µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] driver.Query: query=SELECT t1.file_id, entities.id, entities.created_at, entities.updated_at, entities.deleted_at, entities.type, entities.source, entities.size, entities.reference_count, entities.storage_policy_entities, entities.created_by, entities.upload_session_id, entities.recycle_options FROM entities JOIN file_entities AS t1 ON entities.id = t1.entity_id WHERE t1.file_id IN (?) AND entities.deleted_at IS NULL ORDER BY entities.id DESC args=[47] time=622.894µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/pkg/filemanager/lock/memlock.go:156] Memlock create: NS:GPsG/my, Root: /v.mp4, Duration: -1ns, ZeroDepth: false
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] driver.Query: query=SELECT files.id, files.created_at, files.updated_at, files.type, files.name, files.owner_id, files.size, files.primary_entity, files.file_children, files.is_symbolic, files.props, files.storage_policy_files FROM files WHERE files.id IN (?, ?) args=[47 1] time=418.928µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] driver.Query: query=SELECT t1.file_id, entities.id, entities.created_at, entities.updated_at, entities.deleted_at, entities.type, entities.source, entities.size, entities.reference_count, entities.storage_policy_entities, entities.created_by, entities.upload_session_id, entities.recycle_options FROM entities JOIN file_entities AS t1 ON entities.id = t1.entity_id WHERE t1.file_id IN (?, ?) AND entities.deleted_at IS NULL ORDER BY entities.id DESC args=[1 47] time=527.572µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] driver.Tx(334591bc-21e6-4cc7-94b8-86f3d520930d): started
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] Tx(334591bc-21e6-4cc7-94b8-86f3d520930d).Exec: query=UPDATE entities SET updated_at = ?, reference_count = COALESCE(entities.reference_count, 0) + ? WHERE entities.id IN (?) args=[2025-10-11 23:24:01.793430668 +0800 CST m=+268.575772030 -1 52] time=400.488µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] Tx(334591bc-21e6-4cc7-94b8-86f3d520930d).Query: query=SELECT entities.id, entities.created_at, entities.updated_at, entities.deleted_at, entities.type, entities.source, entities.size, entities.reference_count, entities.storage_policy_entities, entities.created_by, entities.upload_session_id, entities.recycle_options FROM entities WHERE (entities.id IN (?) AND entities.reference_count <= ?) AND entities.deleted_at IS NULL args=[52 0] time=345.888µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] Tx(334591bc-21e6-4cc7-94b8-86f3d520930d).Exec: query=UPDATE entities SET updated_at = ?, recycle_options = ? WHERE entities.id IN (?) args=[2025-10-11 23:24:01.794349119 +0800 CST m=+268.576690481 [110 117 108 108] 52] time=357.317µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] Tx(334591bc-21e6-4cc7-94b8-86f3d520930d).Exec: query=UPDATE shares SET updated_at = ?, deleted_at = ? WHERE shares.file_shares IN (SELECT files.id FROM files WHERE files.id IN (?)) AND shares.deleted_at IS NULL args=[2025-10-11 23:24:01.794783518 +0800 CST m=+268.577124857 2025-10-11 23:24:01.794779234 +0800 CST m=+268.577120596 47] time=499.198µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] Tx(334591bc-21e6-4cc7-94b8-86f3d520930d).Exec: query=DELETE FROM metadata WHERE metadata.file_id IN (?) args=[47] time=374.612µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] Tx(334591bc-21e6-4cc7-94b8-86f3d520930d).Exec: query=DELETE FROM direct_links WHERE direct_links.file_id IN (?) args=[47] time=350.605µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] Tx(334591bc-21e6-4cc7-94b8-86f3d520930d).Exec: query=DELETE FROM files WHERE files.id IN (?) args=[47] time=472.341µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] Tx(334591bc-21e6-4cc7-94b8-86f3d520930d): committed
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] driver.Exec: query=UPDATE users SET updated_at = ?, storage = COALESCE(users.storage, 0) + ? WHERE users.id = ? args=[2025-10-11 23:24:01.798781464 +0800 CST m=+268.581122824 -2252655 1] time=2.05707ms
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/pkg/filemanager/manager/operation.go:167] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] New stale entities: [0xc006572090]
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] driver.Exec: query=INSERT INTO tasks (created_at, updated_at, type, status, public_state, private_state, correlation_id, user_tasks) VALUES (?, ?, ?, ?, ?, ?, ?, ?) args=[2025-10-11 23:24:01.800954591 +0800 CST m=+268.583295953 2025-10-11 23:24:01.800954765 +0800 CST m=+268.583296105 explicit_entity_recycle queued [123 34 114 101 115 117 109 101 95 116 105 109 101 34 58 49 55 54 48 49 57 54 50 52 48 125] {"entity_ids":[52]} e9efd055-9ab6-4fef-bbb3-d988349fc7f0 1] time=2.170802ms
[Info] 2025-10-11 23:24:01 [/home/vsts/work/1/s/pkg/queue/queue.go:360] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] Task 273 status changed from "" to "queued".
[Info] 2025-10-11 23:24:01 [/home/vsts/work/1/s/pkg/queue/queue.go:202] New Task with type "explicit_entity_recycle" submitted to queue "EntityRecycleQueue" by "[email protected]"
[Info] 2025-10-11 23:24:01 [/home/vsts/work/1/s/pkg/logging/logger.go:193] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0] [Incoming] 200 | 17.510877ms | 223.104.68.181 | DELETE "/api/v4/file"
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 71c69086-07b9-4b11-ad10-98e2dde85a9b] driver.Query: query=SELECT users.id, users.created_at, users.updated_at, users.deleted_at, users.email, users.nick, users.password, users.status, users.storage, users.two_factor_secret, users.avatar, users.settings, users.group_users FROM users WHERE (users.id = ? AND users.status = ?) AND users.deleted_at IS NULL LIMIT 1 args=[1 active] time=673.736µs
[Debug] 2025-10-11 23:24:01 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: 71c69086-07b9-4b11-ad10-98e2dde85a9b] driver.Query: query=SELECT groups.id, groups.created_at, groups.updated_at, groups.deleted_at, groups.name, groups.max_storage, groups.speed_limit, groups.permissions, groups.settings, groups.storage_policy_id FROM groups WHERE groups.id IN (?) AND groups.deleted_at IS NULL args=[1] time=371.744µs
[Info] 2025-10-11 23:24:01 [/home/vsts/work/1/s/pkg/logging/logger.go:193] [Cid: 71c69086-07b9-4b11-ad10-98e2dde85a9b] [Incoming] 200 | 1.56693ms | 223.104.68.181 | GET "/api/v4/user/capacity"
[Debug] 2025-10-11 23:24:03 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] driver.Tx(d314fd77-3841-4c23-ba69-9be4d624162b): started
[Debug] 2025-10-11 23:24:03 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Tx(d314fd77-3841-4c23-ba69-9be4d624162b).Exec: query=UPDATE tasks SET updated_at = ?, status = ?, public_state = ?, private_state = ? WHERE id = ? args=[2025-10-11 23:24:03.341476631 +0800 CST m=+270.123817989 processing [123 34 114 101 115 117 109 101 95 116 105 109 101 34 58 49 55 54 48 49 57 54 50 52 48 125] {"entity_ids":[52]} 273] time=673.444µs
[Debug] 2025-10-11 23:24:03 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Tx(d314fd77-3841-4c23-ba69-9be4d624162b).Query: query=SELECT id, created_at, updated_at, deleted_at, type, status, public_state, private_state, correlation_id, user_tasks FROM tasks WHERE id = ? args=[273] time=4.615008ms
[Debug] 2025-10-11 23:24:03 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Tx(d314fd77-3841-4c23-ba69-9be4d624162b): committed
[Info] 2025-10-11 23:24:03 [/home/vsts/work/1/s/pkg/queue/queue.go:360] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Task 273 status changed from "queued" to "processing".
[Debug] 2025-10-11 23:24:03 [/home/vsts/work/1/s/pkg/queue/queue.go:291] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Iteration started.
[Debug] 2025-10-11 23:24:03 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] driver.Query: query=SELECT entities.id, entities.created_at, entities.updated_at, entities.deleted_at, entities.type, entities.source, entities.size, entities.reference_count, entities.storage_policy_entities, entities.created_by, entities.upload_session_id, entities.recycle_options FROM entities WHERE entities.id IN (?) AND entities.deleted_at IS NULL args=[52] time=1.200993ms
[Info] 2025-10-11 23:24:03 [/home/vsts/work/1/s/pkg/filemanager/manager/recycle.go:206] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Recycling 1 entities in 1 batches
[Info] 2025-10-11 23:24:03 [/home/vsts/work/1/s/pkg/filemanager/manager/recycle.go:209] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Start to recycle batch #0, 1 entities
[Debug] 2025-10-11 23:24:03 [/home/vsts/work/1/s/pkg/filemanager/driver/cos/cos.go:323] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Process delete group #0: [uploads/1/c77661dd-bd8c-423d-8909-f4a308e94699_v.mp4]
[Debug] 2025-10-11 23:24:03 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] driver.Tx(4eb93ae3-e24a-4d29-9b65-13067567c72a): started
[Debug] 2025-10-11 23:24:03 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Tx(4eb93ae3-e24a-4d29-9b65-13067567c72a).Query: query=SELECT entities.id, entities.created_at, entities.updated_at, entities.deleted_at, entities.type, entities.source, entities.size, entities.reference_count, entities.storage_policy_entities, entities.created_by, entities.upload_session_id, entities.recycle_options FROM entities WHERE entities.id IN (?) AND entities.reference_count > ? args=[52 0] time=524.985µs
[Debug] 2025-10-11 23:24:03 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Tx(4eb93ae3-e24a-4d29-9b65-13067567c72a).Exec: query=DELETE FROM entities WHERE entities.id IN (?) args=[52] time=672.522µs
[Debug] 2025-10-11 23:24:03 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Tx(4eb93ae3-e24a-4d29-9b65-13067567c72a): committed
[Debug] 2025-10-11 23:24:03 [/home/vsts/work/1/s/pkg/queue/queue.go:293] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Iteration ended with err=%!s(tasks SET updated_at = ?, status = ?, public_state = ?, private_state = ? WHERE id = ? args=[2025-10-11 23:24:03.417891304 +0800 CST m=+270.200232667 completed [123 34 101 120 101 99 117 116 101 100 95 100 117 114 97 116 105 111 110 34 58 54 53 56 48 52 52 57 57 44 34 114 101 115 117 109 101 95 116 105 109 101 34 58 49 55 54 48 49 57 54 50 52 48 125] {"entity_ids":[52]} 273] time=585.99µs
[Debug] 2025-10-11 23:24:03 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Tx(def3b376-4aee-4714-bf90-96b1ddc741cd).Query: query=SELECT id, created_at, updated_at, deleted_at, type, status, public_state, private_state, correlation_id, user_tasks FROM tasks WHERE id = ? args=[273] time=397.142µs
[Debug] 2025-10-11 23:24:03 [/home/vsts/work/1/s/inventory/client.go:132] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Tx(def3b376-4aee-4714-bf90-96b1ddc741cd): committed
[Info] 2025-10-11 23:24:03 [/home/vsts/work/1/s/pkg/queue/queue.go:360] [Cid: e9efd055-9ab6-4fef-bbb3-d988349fc7f0 TaskID: 273 Queue: EntityRecycleQueue] Task 273 status changed from "processing" to "completed".
[Info] 2025-10-11 23:24:08 [/home/vsts/work/1/s/cmd/server.go:57] Signal hangup received, shutting down server...
[Info] 2025-10-11 23:24:08 [/home/vsts/work/1/s/application/application.go:168] Shutting down database connection...
[Info] 2025-10-11 23:24:08 [/home/vsts/work/1/s/pkg/queue/queue.go:134] Shutting down queue "RemoteDownloadQueue"...
[Info] 2025-10-11 23:24:08 [/home/vsts/work/1/s/pkg/email/smtp.go:149] Email queue closing...
[Info] 2025-10-11 23:24:08 [/home/vsts/work/1/s/pkg/queue/queue.go:134] Shutting down queue "MediaMetadataQueue"...
[Info] 2025-10-11 23:24:08 [/home/vsts/work/1/s/pkg/queue/queue.go:134] Shutting down queue "ThumbQueue"...
[Info] 2025-10-11 23:24:08 [/home/vsts/work/1/s/pkg/queue/queue.go:134] Shutting down queue "IoIntenseQueue"...
[Info] 2025-10-11 23:24:08 [/home/vsts/work/1/s/pkg/queue/queue.go:134] Shutting down queue "EntityRecycleQueue"...
