Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

bug: deadlock when dropping the extension #21

Open
kemingy opened this issue Dec 24, 2024 · 0 comments
Open

bug: deadlock when dropping the extension #21

kemingy opened this issue Dec 24, 2024 · 0 comments
Assignees

Comments

@kemingy
Copy link
Member

kemingy commented Dec 24, 2024

Client error:

psycopg.errors.DeadlockDetected: deadlock detected
DETAIL:  Process 793896 waits for AccessExclusiveLock on relation 2409596 of database 103663; blocked by process 793520.
Process 793520 waits for AccessShareLock on relation 2409581 of database 103663; blocked by process 793896.
HINT:  See server log for query details.

Server log:

2024-12-24 16:56:19.399 +08 [757787] LOG:  checkpoint starting: time
2024-12-24 16:59:04.464 +08 [757787] LOG:  checkpoint complete: wrote 3671 buffers (22.4%); 0 WAL file(s) added, 1 removed, 31 recycled; write=164.140 s, sync=0.344 s, total=165.065 s; sync files=31, longest=0.122 s, average=0.012 s; distance=538485 kB, estimate=540639 kB; lsn=8/27385FB0, redo lsn=8/7E1A758
2024-12-24 16:59:04.464 +08 [757787] LOG:  checkpoint starting: wal
2024-12-24 16:59:10.969 +08 [790919] LOG:  skipping vacuum of "corpus" --- lock not available
2024-12-24 17:00:10.121 +08 [792142] LOG:  skipping vacuum of "corpus" --- lock not available
2024-12-24 17:01:23.529 +08 [793520] ERROR:  canceling autovacuum task
2024-12-24 17:01:23.529 +08 [793520] CONTEXT:  while scanning block 49570 of relation "public.corpus"
	automatic vacuum of table "vchord_bm25.public.corpus"
2024-12-24 17:01:24.533 +08 [793896] ERROR:  deadlock detected
2024-12-24 17:01:24.533 +08 [793896] DETAIL:  Process 793896 waits for AccessExclusiveLock on relation 2409596 of database 103663; blocked by process 793520.
	Process 793520 waits for AccessShareLock on relation 2409581 of database 103663; blocked by process 793896.
	Process 793896: DROP EXTENSION IF EXISTS vchord_bm25 cascade;
	Process 793520: autovacuum: ANALYZE public.queries
2024-12-24 17:01:24.533 +08 [793896] HINT:  See server log for query details.
2024-12-24 17:01:24.533 +08 [793896] STATEMENT:  DROP EXTENSION IF EXISTS vchord_bm25 cascade;
2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants