pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedServer crashing
4+ messages / 3 participants
[nested] [flat]
* Server crashing
@ 2005-04-11 03:16 Don Drake <dondrake@gmail.com>
2005-04-11 06:29 ` Re: Server crashing Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Don Drake @ 2005-04-11 03:16 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Server crashing
2005-04-11 03:16 Server crashing Don Drake <dondrake@gmail.com>
@ 2005-04-11 06:29 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-04-11 14:24 ` Re: Server crashing Don Drake <dondrake@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2005-04-11 06:29 UTC (permalink / raw)
To: Don Drake <dondrake@gmail.com>; +Cc: pgsql-performance
Don Drake <dondrake@gmail.com> writes:
> My server is crashing on a delete statement.
> Here's the error message in the log file:
> LOG: 00000: received fast shutdown request
> LOCATION: pmdie, postmaster.c:1736
That says that something sent the postmaster a SIGINT signal.
I think it's highly unlikely that the DELETE statement did it.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Server crashing
2005-04-11 03:16 Server crashing Don Drake <dondrake@gmail.com>
2005-04-11 06:29 ` Re: Server crashing Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-04-11 14:24 ` Don Drake <dondrake@gmail.com>
2005-04-11 15:15 ` Re: Server crashing Gourish Singbal <gourish@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Don Drake @ 2005-04-11 14:24 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-performance
Well, a vacuum on the entire DB seemed to have cleaned things up.
No other user was logged into the server, and I certainly did not send
the signal.
I did clean up the serverlog file by truncating it ( > serverlog)
while the DB was running, I don't think it liked that since it crashed
the DB. I've done this on my Linux server many times and it never
complained. I won't be doing that again.
-Don
On Apr 11, 2005 1:29 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Don Drake <dondrake@gmail.com> writes:
> > My server is crashing on a delete statement.
> > Here's the error message in the log file:
>
> > LOG: 00000: received fast shutdown request
> > LOCATION: pmdie, postmaster.c:1736
>
> That says that something sent the postmaster a SIGINT signal.
> I think it's highly unlikely that the DELETE statement did it.
>
> regards, tom lane
>
--
Donald Drake
President
Drake Consulting
http://www.drakeconsult.com/
http://www.MailLaunder.com/
http://www.mobilemeridian.com/
312-560-1574
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Server crashing
2005-04-11 03:16 Server crashing Don Drake <dondrake@gmail.com>
2005-04-11 06:29 ` Re: Server crashing Tom Lane <tgl@sss.pgh.pa.us>
2005-04-11 14:24 ` Re: Server crashing Don Drake <dondrake@gmail.com>
@ 2005-04-11 15:15 ` Gourish Singbal <gourish@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Gourish Singbal @ 2005-04-11 15:15 UTC (permalink / raw)
To: Don Drake <dondrake@gmail.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-performance
by Truncating the serverlog do you mean the data_log (as in my case)
log file of the postgresql sever ?. If thats the file you truncated
than i think its not a good habit..since you might need it at some
point of time for some debugging purpose in production.
You could use something like assuming there is a dummy file of 0 bytes
in logs folder..
cp data_log data_log_$current_time
cat logs/dummy_file>data_log
gzip data_log_$current_time
mv data_log_$current_time.gz logs/data_log_$current_time.gz
Hope this helps
Best
Gourish Singbal
On Apr 11, 2005 7:54 PM, Don Drake <dondrake@gmail.com> wrote:
> Well, a vacuum on the entire DB seemed to have cleaned things up.
>
> No other user was logged into the server, and I certainly did not send
> the signal.
>
> I did clean up the serverlog file by truncating it ( > serverlog)
> while the DB was running, I don't think it liked that since it crashed
> the DB. I've done this on my Linux server many times and it never
> complained. I won't be doing that again.
>
> -Don
>
> On Apr 11, 2005 1:29 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > Don Drake <dondrake@gmail.com> writes:
> > > My server is crashing on a delete statement.
> > > Here's the error message in the log file:
> >
> > > LOG: 00000: received fast shutdown request
> > > LOCATION: pmdie, postmaster.c:1736
> >
> > That says that something sent the postmaster a SIGINT signal.
> > I think it's highly unlikely that the DELETE statement did it.
> >
> > regards, tom lane
> >
>
> --
> Donald Drake
> President
> Drake Consulting
> http://www.drakeconsult.com/
> http://www.MailLaunder.com/
> http://www.mobilemeridian.com/
> 312-560-1574
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
--
Best,
Gourish Singbal
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-04-11 15:15 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-11 03:16 Server crashing Don Drake <dondrake@gmail.com>
2005-04-11 06:29 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-04-11 14:24 ` Don Drake <dondrake@gmail.com>
2005-04-11 15:15 ` Gourish Singbal <gourish@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox