The following bug has been logged on the website:
Bug reference: 7600
Logged by: Database crash with data corruption
Email address: hankiew...@gmail.com
PostgreSQL version: 9.2.1
Operating system: Linux
Description:
We experienced database crash.
Our configuration:
Single postgres server instance with 17 databases installed on it. Postgres
server is installed in chroot on Linux Centos.
The list of steps to reproduce bug:
1) Create two database on single server instance (production and sandbox)
2) On production perform normal operations (we use Trac with over 50 active
users)
3) on the sandbox database start explain plan of query
4) while explain plan is executing drop sandbox database
5) after recovery was completed we have discovered that sequences on
production database had wrong values
Our log:
ERROR: database "sandbox" is being accessed by other users
DETAIL: There are 2 other sessions using the database.
STATEMENT: DROP DATABASE sandbox;
ERROR: database "sandbox" is being accessed by other users
DETAIL: There is 1 other session using the database.
STATEMENT: DROP DATABASE sandbox;
LOG: server process (PID 1482) was terminated by signal 2: Killed
DETAIL: Failed process was running: EXPLAIN (ANALYZE off, VERBOSE off,
COSTS on, BUFFERS off, TIMING off )select * from ticket_custom tcu join
(ticket ti left join
(select tcin.field,tcin.time as tc_time,
tcin.ticket, tcin.oldvalue
from ticket_change tcin
where tcin.field = 'status' and tcin.time =
(select max(tcmax.time) from
ticket_change tcmax where tcmax.field = 'status' and tcmax.ticket =
tcin.ticket)) tc
on ti.id = tc.ticket) con
on tcu.ticket = con.id
join ticket_custom tcu2 on tcu2.ticket = con.id
join ticket_custom tcu3 on tcu3.ticket = con.id
where
tcu.ticket = con.id and
tcu.name = 'scen' and
tcu2.name = 'err_type' and
tcu3.name = 'err_details' and
con.component not in ('', 'xxx ') and
-- tcu.value not in ('',' ') and
con.status <> 'closed' and
con.type = 'defect' and
con.owner <> 'TEST_TEAM'
order by 1 asc,5 asc
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.
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.
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.
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.
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.
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.
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
repe
