Server crashing

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

Responses

Browse pgsql-performance by date

  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