X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E3BC75348F for ; Mon, 11 Apr 2005 00:16:43 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83687-01 for ; Mon, 11 Apr 2005 03:16:33 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.198]) by svr1.postgresql.org (Postfix) with ESMTP id 614DD5331E for ; Mon, 11 Apr 2005 00:16:32 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so2490000wra for ; Sun, 10 Apr 2005 20:16:32 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=HrcYlWNhNdPS7KqkoVxyQnFzy9YLrFilEGx4G2o/PY56HfSEKWuG+JBAnvxmfaq2SAJO3h4kvIydUmNh52H3nYv0Kjk9VVYIBo2xmm0nvr3fS7BNAPO000H+WoZInUmZ3gUB8hrJEZFE2mSkHxlbw1923GqPweJGtnygPut2clE= Received: by 10.54.21.37 with SMTP id 37mr1709205wru; Sun, 10 Apr 2005 20:16:32 -0700 (PDT) Received: by 10.54.97.13 with HTTP; Sun, 10 Apr 2005 20:16:30 -0700 (PDT) Message-ID: <6c21003b05041020166d32111c@mail.gmail.com> Date: Sun, 10 Apr 2005 22:16:30 -0500 From: Don Drake Reply-To: Don Drake To: pgsql-performance@postgresql.org Subject: Server crashing Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.211 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/198 X-Sequence-Number: 11595 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