X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 527AD3A2190 for ; Mon, 17 Jan 2005 11:21:07 +0000 (GMT) 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 84485-01 for ; Mon, 17 Jan 2005 11:20:55 +0000 (GMT) Received: from mail.dbasetek.com (dbasetek.com [66.134.187.210]) by svr1.postgresql.org (Postfix) with ESMTP id 7FD6B3A1D12 for ; Mon, 17 Jan 2005 11:20:56 +0000 (GMT) Received: from [192.168.1.51] ([192.168.1.51]) by mail.dbasetek.com (8.12.11/8.12.11) with ESMTP id j0HBKt0c013434 for ; Mon, 17 Jan 2005 05:20:55 -0600 Message-ID: <41EB9F98.5040008@dbasetek.com> Date: Mon, 17 Jan 2005 05:20:56 -0600 From: Robert D Oden User-Agent: Mozilla Thunderbird 0.7.2 (Windows/20040707) X-Accept-Language: en-us, en MIME-Version: 1.0 To: PgSQL ADMIN Subject: closed connection unexpectedly Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/172 X-Sequence-Number: 16031 I am trying to execute the following SQL: create table rdo_tmp0 as select distinct * from rp_na_mm where acct_no like '1%' and acct_no >= '13873365' This is the result I get: DBD::Pg::db do failed: server closed the connection unexpectedly Postgres Log file: Jan 17 05:06:51 dbs01 postgres[3130]: [8-1] LOG: server process (PID 3332) was terminated by signal 11 Jan 17 05:06:51 dbs01 postgres[3130]: [9-1] LOG: terminating any other active server processes Jan 17 05:06:51 dbs01 postgres[3321]: [12-1] WARNING: terminating connection because of crash of another server process Jan 17 05:06:51 dbs01 postgres[3321]: [12-2] DETAIL: The postmaster has commanded this server process to roll back the current tran saction and exit, because another server Jan 17 05:06:51 dbs01 postgres[3331]: [8-1] WARNING: terminating connection because of crash of another server process Jan 17 05:06:51 dbs01 postgres[3321]: [12-3] process exited abnormally and possibly corrupted shared memory. Jan 17 05:06:51 dbs01 postgres[3321]: [12-4] HINT: In a moment you should be able to reconnect to the database and repeat your comm and. Jan 17 05:06:51 dbs01 postgres[3331]: [8-2] DETAIL: The postmaster has commanded this server process to roll back the current trans action and exit, because another server Jan 17 05:06:51 dbs01 postgres[3331]: [8-3] process exited abnormally and possibly corrupted shared memory. Jan 17 05:06:51 dbs01 postgres[3331]: [8-4] HINT: In a moment you should be able to reconnect to the database and repeat your comma nd. Jan 17 05:06:51 dbs01 postgres[3130]: [10-1] LOG: all server processes terminated; reinitializing Jan 17 05:06:51 dbs01 postgres[3333]: [11-1] LOG: database system was interrupted at 2005-01-17 05:05:31 CST Jan 17 05:06:51 dbs01 postgres[3333]: [12-1] LOG: checkpoint record is at 215/F6D9DCDC Jan 17 05:06:51 dbs01 postgres[3333]: [13-1] LOG: redo record is at 215/F6D189BC; undo record is at 0/0; shutdown FALSE Jan 17 05:06:51 dbs01 postgres[3333]: [14-1] LOG: next transaction ID: 198072882; next OID: 514344047 Jan 17 05:06:51 dbs01 postgres[3333]: [15-1] LOG: database system was not properly shut down; automatic recovery in progress Jan 17 05:06:51 dbs01 postgres[3333]: [16-1] LOG: redo starts at 215/F6D189BC Jan 17 05:06:52 dbs01 postgres[3333]: [17-1] LOG: unexpected pageaddr 215/E0980000 in log file 533, segment 247, offset 9961472 Jan 17 05:06:52 dbs01 postgres[3333]: [18-1] LOG: redo done at 215/F797FFBC Jan 17 05:06:54 dbs01 postgres[3333]: [19-1] LOG: database system is ready Thanks in advance Doug Oden