Re: "ERROR: could not read block 6 ...: read only 0 of 8192 bytes" after autovacuum cancelled
| От | Alvaro Herrera |
|---|---|
| Тема | Re: "ERROR: could not read block 6 ...: read only 0 of 8192 bytes" after autovacuum cancelled |
| Дата | |
| Msg-id | 20091107001837.GK3840@alvh.no-ip.org обсуждение исходный текст |
| Ответ на | Re: "ERROR: could not read block 6 ...: read only 0 of 8192 bytes" after autovacuum cancelled (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: "ERROR: could not read block 6 ...: read only 0 of 8192 bytes" after autovacuum cancelled
|
| Список | pgsql-hackers |
Tom Lane wrote: > Alvaro Herrera <alvherre@commandprompt.com> writes: > > Tom Lane wrote: > >> I wonder whether we shouldn't extend this into VACUUM FULL too, to > >> prevent cancel once it's done that internal commit. It would fix > >> the "PANIC: can't abort a committed transaction" problem V.F. has. > > > Hmm, it seems to work. The attached is for 8.1. > > Looks OK, but please update the comment right before the > RecordTransactionCommit, along the lines of "We prevent cancel > interrupts after this point to mitigate the problem that you > can't abort the transaction now". BTW I'm thinking in backpatching this all the way back to 7.4 -- are we agreed on that? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
В списке pgsql-hackers по дате отправления: