From: | "Daniele Bortoluzzi" <bortoluz(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4838: Database corruption after btree_gin index creation |
Date: | 2009-06-04 11:32:24 |
Message-ID: | 200906041132.n54BWOlj028781@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4838
Logged by: Daniele Bortoluzzi
Email address: bortoluz(at)gmail(dot)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...
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-06-04 14:06:15 | Re: BUG #4838: Database corruption after btree_gin index creation |
Previous Message | Jeremy Ford | 2009-06-04 05:43:41 | different results in to_date() |