BUG #4838: Database corruption after btree_gin index creation
От | Daniele Bortoluzzi |
---|---|
Тема | BUG #4838: Database corruption after btree_gin index creation |
Дата | |
Msg-id | 200906041132.n54BWOlj028781@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #4838: Database corruption after btree_gin index creation
Re: BUG #4838: Database corruption after btree_gin index creation |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 4838 Logged by: Daniele Bortoluzzi Email address: bortoluz@gmail.com PostgreSQL version: 8.4beta2 Operating system: Linux amd64 2.6.24 (Debian 4.0) Description: Database corruption after btree_gin index creation Details: I am testing this db I created a multicolumn GIN index with btree_gin functionality (fulltext column + timestamp). After creating the index the db segfaulted: LOG: server process (PID 14195) was terminated by signal 11: Segmentation fault LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. The WARNING-DETAIL-HINT messages repeated 4 times, then postgres restarted: LOG: all server processes terminated; reinitializing LOG: database system was interrupted; last known up at 2009-06-04 12:47:19 CEST LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 2/778687D0 LOG: record with zero length at 2/779392A8 LOG: redo done at 2/77938E20 LOG: last completed transaction was at log time 2009-06-04 12:47:35.55392+02 LOG: autovacuum launcher started LOG: database system is ready to accept connections but segfaulted 2 times more. Then I launched a VACUUM FULL ANALYZE, no segmentation faults, it completed succesfully, but now it throws this error: ERROR: tuple offset out of range: 48090 or ERROR: tuple offset out of range: 0 when doing fulltext queries. I was using postgres 8.4devel (SVN revision 28901) happily...
В списке pgsql-bugs по дате отправления: