From: | Don Drake <dondrake(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Server crashing |
Date: | 2005-04-11 03:16:30 |
Message-ID: | 6c21003b05041020166d32111c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
My server is crashing on a delete statement.
Here's the error message in the log file:
LOCATION: ShutdownXLOG, xlog.c:3090
LOG: 00000: database system is shut down
LOCATION: ShutdownXLOG, xlog.c:3104
LOG: 00000: database system was shut down at 2005-04-10 21:54:34 CDT
LOCATION: StartupXLOG, xlog.c:2596
LOG: 00000: checkpoint record is at C/665D45E0
LOCATION: StartupXLOG, xlog.c:2628
LOG: 00000: redo record is at C/665D45E0; undo record is at 0/0; shutdown TRUE
LOCATION: StartupXLOG, xlog.c:2653
LOG: 00000: next transaction ID: 109177; next OID: 92547340
LOCATION: StartupXLOG, xlog.c:2656
LOG: 00000: database system is ready
LOCATION: StartupXLOG, xlog.c:2946
LOG: 00000: recycled transaction log file "0000000C00000063"
LOCATION: MoveOfflineLogs, xlog.c:1656
LOG: 00000: recycled transaction log file "0000000C00000064"
LOCATION: MoveOfflineLogs, xlog.c:1656
LOG: 00000: recycled transaction log file "0000000C00000065"
LOCATION: MoveOfflineLogs, xlog.c:1656
WARNING: 25P01: there is no transaction in progress
LOCATION: EndTransactionBlock, xact.c:1607
WARNING: 25P01: there is no transaction in progress
LOCATION: EndTransactionBlock, xact.c:1607
ERROR: 42601: syntax error at end of input at character 77
LOCATION: yyerror, scan.l:565
WARNING: 25P01: there is no transaction in progress
LOCATION: EndTransactionBlock, xact.c:1607
ERROR: 42601: syntax error at end of input at character 77
LOCATION: yyerror, scan.l:565
WARNING: 25P01: there is no transaction in progress
LOCATION: EndTransactionBlock, xact.c:1607
WARNING: 25001: there is already a transaction in progress
LOCATION: BeginTransactionBlock, xact.c:1545
ERROR: 42601: syntax error at end of input at character 77
LOCATION: yyerror, scan.l:565
WARNING: 25001: there is already a transaction in progress
LOCATION: BeginTransactionBlock, xact.c:1545
ERROR: 42601: syntax error at end of input at character 77
LOCATION: yyerror, scan.l:565
LOG: 00000: received fast shutdown request
LOCATION: pmdie, postmaster.c:1736
LOG: 00000: aborting any active transactions
LOCATION: pmdie, postmaster.c:1743
FATAL: 57P01: terminating connection due to administrator command
LOCATION: ProcessInterrupts, postgres.c:1955
FATAL: 57P01: terminating connection due to administrator command
LOCATION: ProcessInterrupts, postgres.c:1955
FATAL: 57P01: terminating connection due to administrator command
LOCATION: ProcessInterrupts, postgres.c:1955
FATAL: 57P01: terminating connection due to administrator command
LOCATION: ProcessInterrupts, postgres.c:1955
LOG: 00000: shutting down
LOCATION: ShutdownXLOG, xlog.c:3090
LOG: 00000: database system is shut down
LOCATION: ShutdownXLOG, xlog.c:3104
I just turned off SQL command logging, stopped and started the process
and now this command which worked just fine before is causing the DB
to crash. I'm running Postgres 7.4.7 on Solaris 9 with PostGIS 0.9.1.
The data I'm deleting is the parent table with many inherited child tables.
Any ideas?
-Don
--
Donald Drake
President
Drake Consulting
http://www.drakeconsult.com/
http://www.MailLaunder.com/
http://www.mobilemeridian.com/
312-560-1574
From | Date | Subject | |
---|---|---|---|
Next Message | John A Meinel | 2005-04-11 04:57:51 | Re: help on explain analyse |
Previous Message | Neil Conway | 2005-04-11 01:55:06 | Re: 4 way JOIN using aliases |