yowfung Comments - Answer Overflow

yowfung

Posts Comments

IImmich

•Created by Sentry on 1/26/2025 in #help-desk-support

Bad Character with ascii 0x2d

Yes

11 replies

IImmich

•Created by Sentry on 1/26/2025 in #help-desk-support

Bad Character with ascii 0x2d

I checked the file permissions in the postgres container and it is normal.

root@bd2ad288ca6d:/var/lib/postgresql/data/base/80522# ls -alh | grep 91142_vm
-rw-r--r-- 1 postgres root     8.0K Jan 31 19:08 91142_vm

root@bd2ad288ca6d:/var/lib/postgresql/data/base/80522# ls -alh | grep 91142_vm
-rw-r--r-- 1 postgres root     8.0K Jan 31 19:08 91142_vm

11 replies

IImmich

•Created by Sentry on 1/26/2025 in #help-desk-support

Bad Character with ascii 0x2d

postgres log:

2025-01-31 19:27:15.648 CST [1] LOG:  database system is ready to accept connections                                                                                   
[2025-01-31T11:27:35Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/319490/segments/bf2f6b48-5a40-4ef8-a113-8b441a9f3a94".                           
2025-01-31 19:28:08.149 CST [45] ERROR:  pgvecto.rs: Bad literal.                                                                                                      
        INFORMATION: hint = Bad character with ascii 0x30.                                                                                                             
2025-01-31 19:28:08.149 CST [45] CONTEXT:  unnamed portal parameter $4 = '...'                                                                                         
2025-01-31 19:28:08.149 CST [45] STATEMENT:  select "assets".*, to_json("exif") as "exifInfo" from "assets" inner join "exif" on "assets"."id" = "exif"."assetId" inner join "smart_search" on "assets"."id" = "smart_search"."assetId" where "assets"."ownerId" = any($1::uuid[]) and "assets"."isVisible" = $2 and "assets"."isArchived" = $3 and "assets"."deletedAt" is null order by smart_search.embedding <=> $4 limit $5 offset $6                                                                           
                                                                                                                                                                       
2025-01-31 19:33:07.334 CST [42] LOG:  using stale statistics instead of current ones because stats collector is not responding

2025-01-31 19:27:15.648 CST [1] LOG:  database system is ready to accept connections                                                                                   
[2025-01-31T11:27:35Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/319490/segments/bf2f6b48-5a40-4ef8-a113-8b441a9f3a94".                           
2025-01-31 19:28:08.149 CST [45] ERROR:  pgvecto.rs: Bad literal.                                                                                                      
        INFORMATION: hint = Bad character with ascii 0x30.                                                                                                             
2025-01-31 19:28:08.149 CST [45] CONTEXT:  unnamed portal parameter $4 = '...'                                                                                         
2025-01-31 19:28:08.149 CST [45] STATEMENT:  select "assets".*, to_json("exif") as "exifInfo" from "assets" inner join "exif" on "assets"."id" = "exif"."assetId" inner join "smart_search" on "assets"."id" = "smart_search"."assetId" where "assets"."ownerId" = any($1::uuid[]) and "assets"."isVisible" = $2 and "assets"."isArchived" = $3 and "assets"."deletedAt" is null order by smart_search.embedding <=> $4 limit $5 offset $6                                                                           
                                                                                                                                                                       
2025-01-31 19:33:07.334 CST [42] LOG:  using stale statistics instead of current ones because stats collector is not responding

11 replies

IImmich

•Created by Sentry on 1/26/2025 in #help-desk-support

Bad Character with ascii 0x2d

11 replies

IImmich

•Created by Sentry on 1/26/2025 in #help-desk-support

Bad Character with ascii 0x2d

I have a similar problem, I checked through the log that it is due to "PostgresError: could not open file "base/80522/91142_vm": Permission denied", but I don't know how to solve this problem.

11 replies

Gaming

Programming