Server crashing

Поиск
Список
Период
Сортировка
От Don Drake
Тема Server crashing
Дата
Msg-id 6c21003b05041020166d32111c@mail.gmail.com
обсуждение исходный текст
Ответы Re: Server crashing
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: 4 way JOIN using aliases
Следующее
От: Jarosław Pałka
Дата:
Сообщение: Never ending delete story