升级系统后媒体索引不能运行

[phisky]

/var/log/pgsql/pgsql.log中报错：

2024-09-22 17:18:37.504 CST [30041] ERROR: insert or update on table "acl_list" violates foreign key constraint "acl_list_username_fkey"
2024-09-22 17:18:37.504 CST [30041] DETAIL: Key (username)=(admin) is not present in table "user_table".
2024-09-22 17:18:37.504 CST [30041] STATEMENT: INSERT INTO "acl_list" ("access","folder_id","hash","object_id","username") VALUES ($1,$2,$3,$4,$5)
2024-09-22 17:18:37.521 CST [30041] ERROR: insert or update on table "acl_list" violates foreign key constraint "acl_list_username_fkey"
2024-09-22 17:18:37.521 CST [30041] DETAIL: Key (username)=(media) is not present in table "user_table".
2024-09-22 17:18:37.521 CST [30041] STATEMENT: INSERT INTO "acl_list" ("access","folder_id","hash","object_id","username") VALUES ($1,$2,$3,$4,$5)

[TMnight]

请截图看看媒体索引数据库的日志 /var/log/mediadb/media.log

[phisky]

2024-08-01 16:33:03.269 CST [4163] LOG: starting PostgreSQL 13.2 on x86_64-buildroot-linux-gnu, compiled by x86_64-tnas-linux-gnu-gcc.br_real (Buildroot 2017.11.2) 7.2.0, 64-bit
2024-08-01 16:33:03.270 CST [4163] LOG: listening on IPv4 address "127.0.0.1", port 5432
2024-08-01 16:33:03.273 CST [4163] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
2024-08-01 16:33:03.300 CST [4164] LOG: database system was interrupted; last known up at 2024-07-31 04:14:33 CST
2024-08-01 16:33:05.369 CST [4164] LOG: database system was not properly shut down; automatic recovery in progress
2024-08-01 16:33:05.375 CST [4164] LOG: redo starts at 0/2033898
2024-08-01 16:33:05.375 CST [4164] LOG: invalid record length at 0/20338D0: wanted 24, got 0
2024-08-01 16:33:05.375 CST [4164] LOG: redo done at 0/2033898
2024-08-01 16:33:05.403 CST [4163] LOG: database system is ready to accept connections
2024-08-01 16:33:05.926 CST [4461] FATAL: lock file "postmaster.pid" already exists
2024-08-01 16:33:05.926 CST [4461] HINT: Is another postmaster (PID 4163) running in data directory "/Volume1/@system/media/pgsql"?
2024-08-01 16:33:12.584 CST [5575] ERROR: relation "video" does not exist
2024-08-01 16:33:12.584 CST [5575] STATEMENT: ALTER TABLE VIDEO ADD COLUMN IF NOT EXISTS collect INTEGER DEFAULT 0;
2024-08-01 16:33:12.601 CST [5575] ERROR: relation "photo" does not exist at character 28
2024-08-01 16:33:12.601 CST [5575] STATEMENT: select id, type, path from photo where thumbnail_path is null;
2024-08-01 16:33:12.754 CST [5584] ERROR: relation "photo" does not exist at character 31
2024-08-01 16:33:12.754 CST [5584] STATEMENT: select id, path, gpsinfo from photo where type = 0 and gpsinfo != '' and path not in (select path from photo_geo_classfy)
2024-08-09 09:25:54.536 CST [5276] ERROR: relation "photo" does not exist at character 8
2024-08-09 09:25:54.536 CST [5276] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/83dad7ef5e81e2ba4f0bab61fb2fda34/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_3586.HEIC'
2024-08-26 14:44:53.367 CST [21586] ERROR: relation "photo" does not exist at character 8
2024-08-26 14:44:53.367 CST [21586] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume2/@thumbnail/ab557c6366aeee55774f6c4f6c987442/300_300_20.webp' WHERE path = '/Volume2/data/qBittorrent/.ts/Free.Guy.2021.1080p.BluRay.H264.AAC-RARBG.mkv.jpg'
2024-08-26 14:44:53.410 CST [21586] ERROR: relation "photo" does not exist at character 8
2024-08-26 14:44:53.410 CST [21586] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume2/@thumbnail/ab30f441b0c4909c2189daad100c0562/300_300_20.webp' WHERE path = '/Volume2/data/qBittorrent/.ts/千万别抬头.1080p.国英双语.HD中英双字[66影视www.66Ys.Co].mp4.jpg'
2024-08-26 14:44:53.473 CST [21586] ERROR: relation "photo" does not exist at character 8
2024-08-26 14:44:53.473 CST [21586] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume2/@thumbnail/74ee2a57838231fb3cf1dc68f07a05ec/300_300_20.webp' WHERE path = '/Volume2/data/qBittorrent/.ts/[杀破狼].S.P.L.2005.BDRip.1080p.x264.DTSHD.DualAudio-CHD.D1.Chs.mkv.jpg'
2024-09-22 16:08:04.869 CST [16355] ERROR: relation "photo" does not exist at character 8
2024-09-22 16:08:04.869 CST [16355] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/ad401a798ceb6591fbe645ee8fc3fdf3/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_5599.HEIC'
2024-09-22 16:08:05.649 CST [16355] ERROR: relation "photo" does not exist at character 8
2024-09-22 16:08:05.649 CST [16355] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/23aff449ee4074ef96a786473214e59c/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_5619.PNG'
2024-09-22 16:08:07.486 CST [16355] ERROR: relation "photo" does not exist at character 8
2024-09-22 16:08:07.486 CST [16355] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/e7ed187441aea7354d48ef183ce5c124/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_5600.HEIC'
2024-09-22 16:08:07.794 CST [16355] ERROR: relation "photo" does not exist at character 8
2024-09-22 16:08:07.794 CST [16355] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/2421c5ff689e01d8055efacc598c20c3/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_5602.PNG'
2024-09-22 16:08:08.887 CST [16355] ERROR: relation "photo" does not exist at character 8
2024-09-22 16:08:08.887 CST [16355] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/b8dfabc2e6ca337259d377ca47a8ffeb/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_5620.HEIC'
2024-09-22 16:08:09.045 CST [16355] ERROR: relation "photo" does not exist at character 8
2024-09-22 16:08:09.045 CST [16355] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/380e21376f68f4f306392aea18777820/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_5621.JPG'
2024-09-22 16:08:09.138 CST [16355] ERROR: relation "photo" does not exist at character 8
2024-09-22 16:08:09.138 CST [16355] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/2f21ebcedcadba0a4cb7f23edb421983/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_5597.JPG'
2024-09-22 16:08:09.669 CST [16355] ERROR: relation "photo" does not exist at character 8
2024-09-22 16:08:09.669 CST [16355] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/657d3b1bd7834b223bd14b35a6ba420f/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_5593.PNG'
2024-09-22 16:08:09.780 CST [16355] ERROR: relation "photo" does not exist at character 8
2024-09-22 16:08:09.780 CST [16355] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/b54f7a3ea9f56ab51a589e5cbc060d80/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_5596.JPG'
2024-09-22 16:08:09.883 CST [16355] ERROR: relation "photo" does not exist at character 8
2024-09-22 16:08:09.883 CST [16355] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/b55bb0d8f2b459ec3e7589db99c4b5fe/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_5595.JPG'
2024-09-22 16:08:10.265 CST [16355] ERROR: relation "photo" does not exist at character 8
2024-09-22 16:08:10.265 CST [16355] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/9dc5a15665dff5d3c35a02f28e470c32/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_5594.PNG'
2024-09-22 16:08:10.533 CST [16355] ERROR: relation "photo" does not exist at character 8
2024-09-22 16:08:10.533 CST [16355] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/c23b5bd829c838e599bd82116e9a98ef/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_5592.PNG'
2024-09-22 16:08:10.886 CST [16355] ERROR: relation "photo" does not exist at character 8
2024-09-22 16:08:10.886 CST [16355] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/790c76b9f6d36a1067fd0de30e5fd67e/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_5591.PNG'
2024-09-22 16:08:11.314 CST [16355] ERROR: relation "photo" does not exist at character 8
2024-09-22 16:08:11.314 CST [16355] STATEMENT: UPDATE "photo" SET "thumbnail_path"= '/Volume1/@thumbnail/2805e3d28ebfc382550e93ad52b3a9c3/300_300_20.webp' WHERE path = '/home/phisky/Album backup_phisky_iPhone/IMG_5590.PNG'
2024-09-22 20:51:17.682 CST [4107] ERROR: relation "photo" does not exist at character 22
2024-09-22 20:51:17.682 CST [4107] STATEMENT: SELECT count(*) FROM "photo" WHERE type = 0
2024-09-22 20:51:17.979 CST [4107] ERROR: relation "photo" does not exist at character 22
2024-09-22 20:51:17.979 CST [4107] STATEMENT: SELECT count(*) FROM "photo" WHERE type = 0
2024-09-22 20:51:17.980 CST [4107] ERROR: relation "photo" does not exist at character 33
2024-09-22 20:51:17.980 CST [4107] STATEMENT: select distinct(photo_dir) from photo where folder_type = 1 and home_username = 'phisky' and type = 0;
2024-09-22 20:51:17.984 CST [4107] ERROR: relation "photo" does not exist at character 33
2024-09-22 20:51:17.984 CST [4107] STATEMENT: SELECT distinct(photo_dir) FROM "photo" WHERE folder_type = 1 and home_username = 'phisky' and type = 0
2024-09-22 21:01:22.267 CST [26341] FATAL: role "phisky" does not exist
2024-09-22 21:04:58.034 CST [29407] FATAL: role "phisky" does not exist
2024-09-22 21:13:46.124 CST [4305] ERROR: relation "photo" does not exist at character 22
2024-09-22 21:13:46.124 CST [4305] STATEMENT: SELECT count(*) FROM "photo" WHERE type = 0
2024-09-22 21:13:46.477 CST [4305] ERROR: relation "photo" does not exist at character 33
2024-09-22 21:13:46.477 CST [4305] STATEMENT: select distinct(photo_dir) from photo where folder_type = 1 and home_username = 'phisky' and type = 0;
2024-09-22 21:13:46.487 CST [4305] ERROR: relation "photo" does not exist at character 22
2024-09-22 21:13:46.487 CST [4305] STATEMENT: SELECT count(*) FROM "photo" WHERE type = 0
2024-09-22 21:13:46.490 CST [4305] ERROR: relation "photo" does not exist at character 33
2024-09-22 21:13:46.490 CST [4305] STATEMENT: SELECT distinct(photo_dir) FROM "photo" WHERE folder_type = 1 and home_username = 'phisky' and type = 0

[TMnight]

根据报错信息显示，请尝试重建媒体索引。

[phisky]

根据报错信息显示，请尝试重建媒体索引。

硬盘删除分区后重新安装5.1.145
媒体索引仍然不工作。mediadb.log如下

2024-09-24 19:52:56.028 CST [4174] LOG: starting PostgreSQL 13.2 on x86_64-buildroot-linux-gnu, compiled by x86_64-tnas-linux-gnu-gcc.br_real (Buildroot 2017.11.2) 7.2.0, 64-bit
2024-09-24 19:52:56.028 CST [4174] LOG: listening on IPv4 address "0.0.0.0", port 5432
2024-09-24 19:52:56.028 CST [4174] LOG: listening on IPv6 address "::", port 5432
2024-09-24 19:52:56.033 CST [4174] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
2024-09-24 19:52:56.056 CST [4175] LOG: database system was interrupted; last known up at 2024-09-24 19:39:09 CST
2024-09-24 19:52:59.667 CST [4175] LOG: database system was not properly shut down; automatic recovery in progress
2024-09-24 19:52:59.678 CST [4175] LOG: redo starts at 0/3033738
2024-09-24 19:52:59.679 CST [4175] LOG: invalid record length at 0/3033820: wanted 24, got 0
2024-09-24 19:52:59.679 CST [4175] LOG: redo done at 0/30337E8
2024-09-24 19:52:59.764 CST [4174] LOG: database system is ready to accept connections
2024-09-24 19:53:00.083 CST [4831] FATAL: lock file "postmaster.pid" already exists
2024-09-24 19:53:00.083 CST [4831] HINT: Is another postmaster (PID 4174) running in data directory "/Volume1/@system/media/pgsql"?
2024-09-24 19:53:07.662 CST [5938] ERROR: relation "video" does not exist
2024-09-24 19:53:07.662 CST [5938] STATEMENT: ALTER TABLE VIDEO ADD COLUMN IF NOT EXISTS collect INTEGER DEFAULT 0;
2024-09-24 19:53:07.671 CST [5938] ERROR: relation "photo" does not exist at character 28
2024-09-24 19:53:07.671 CST [5938] STATEMENT: select id, type, path from photo where thumbnail_path is null;
2024-09-24 19:53:07.800 CST [5987] ERROR: relation "photo" does not exist at character 31
2024-09-24 19:53:07.800 CST [5987] STATEMENT: select id, path, gpsinfo from photo where type = 0 and gpsinfo != '' and path not in (select path from photo_geo_classfy)

[TMnight]

请联系官网在线客服预约工程师远程为您检查。