X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 242719DCAAF for ; Fri, 20 Jan 2006 10:27:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78423-10 for ; Fri, 20 Jan 2006 10:27:11 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.205]) by postgresql.org (Postfix) with ESMTP id C011D9DCA82 for ; Fri, 20 Jan 2006 10:27:04 -0400 (AST) Received: by uproxy.gmail.com with SMTP id s2so15354uge for ; Fri, 20 Jan 2006 06:27:08 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=fvShcbiOrrCz/yztYRgO176T9JhktnscFiMSwvpfzXt5/5be6ngCs75oUeRbOuMj3uXXkh5Ii/UGNEPjVbhQjSf073Us3/XBPOeFYcYCx6kvK+evwXUZwrQCM6T3up/PrVrhG/EvFabhXtytiyS6ZPxYPr72RDMkeTkyclsB1Uc= Received: by 10.48.48.3 with SMTP id v3mr145578nfv; Fri, 20 Jan 2006 06:27:08 -0800 (PST) Received: by 10.48.255.8 with HTTP; Fri, 20 Jan 2006 06:27:08 -0800 (PST) Message-ID: Date: Fri, 20 Jan 2006 15:27:08 +0100 From: Christian Sengstock To: pgsql-admin@postgresql.org Subject: problem with dead 'drop table' process MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8785_10024483.1137767228385" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=2.278 required=5 tests=[HTML_10_20=0.945, HTML_MESSAGE=0.001, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 2.278 X-Spam-Level: ** X-Archive-Number: 200601/236 X-Sequence-Number: 20324 ------=_Part_8785_10024483.1137767228385 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline hi, today i wanted to backup my entire database with a 'pg_dumpall'. during thi= s i got an error message that the copy of a certain table to stderr is not possible. i don't know the exact error message right know it was something like ... "failure: copy strside ( [columns] ) to stderr" and the dump was aborted. then i tried to copy the content of the faulty table to another table... # create table strside2 (like strside); # insert into strside2 select * from strside; during the insert process the connection to the postgres db was lost. the logfile showed following error message ... LOG: server process (PID 5540) was terminated by signal 11 LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. LOG: all server processes terminated; reinitializing LOG: database system was interrupted at 2006-01-20 07:56:30 PST .. following recovery start. to save the database on a filesystem basis i stopped the postgres server an= d tried to tar the entire pgdata directory. this process stopped with a "segmentation fault" during the tar process. after that i wanted to drop the faulty table, because i got another copy of it. however the "drop table strside" process did not stop. i tried a ctrl-c to abort, but it did not work. the server is running, and i can connect with another psql client, but the drop table process is still present. ps aux shows postgres 5548 0.0 0.8 16420 4548 ? D 07:58 0:00 postgres: postgres wlan [local] DROP TABLE i cannot kill it with kill -9, and also i'm not sure if i should. maybe the database is not running after it at all? anyone got any hints? thanx, chris -- Christian Sengstock - Tel: 06221 / 650 5889, Mob: 0178 / 38 79 671 ------=_Part_8785_10024483.1137767228385 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline hi,
today i wanted to backup my entire database with a 'pg_dumpall'. during this i got an error message that the copy of a certain table to stderr is not possible. i don't know the exact error message right know it was something like ...

"failure:  copy strside ( [columns] ) to stderr"
and the dump was aborted.

then i tried to copy the content of the faulty table to another table...
# create table strside2 (like strside);
# insert into strside2 select * from strside;

during the insert process the connection to the postgres db was lost. the l= ogfile showed following error message ...

LOG:  server process (PID 5540) was terminated by signal 11
LOG:  terminating any other active server processes
WARNING:  terminating connection because of crash of another server pr= ocess
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and= repeat your command.
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at 2006-01-20 07:56:30 PST
.. following recovery start.

to save the database on a filesystem basis i stopped the postgres server and tried to tar the entire pgdata directory. this process stopped with a "segmentation fault" during the tar process.

after that i wanted to drop the faulty table, because i got another copy of it. however the "drop table strside" process did not stop= . i tried a ctrl-c to abort, but it did not work.

the server is running, and i can connect with another psql client, but the = drop table process is still present. ps aux shows

postgres  5548  0.0  0.8 16420 4548 ?   D   07:58   0:00 postgres: postgres wlan [local] DROP TABLE

i cannot kill it with kill -9, and also i'm not sure if i should. maybe the= database is not running after it at all?

anyone got any hints?
thanx,
chris





--
Christian Sengstock - Tel: 06221 / 650 5889, Mob: 0178 / 38 79 6= 71 ------=_Part_8785_10024483.1137767228385--