Proglems with 7.2.1

From: "James Kelty" <jamesk(at)ashlandagency(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Proglems with 7.2.1
Date: 2002-08-08 22:23:56
Message-ID: LIEBJHJEFMPDEOMFHCAOGEELCJAA.jamesk@ashlandagency.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello.

We recently moved to PostgreSQL 7.2.1 and are now having a problem with just
normal inserts. The following query
INSERT INTO employee ("employeeid","sales_y_n","dataentry_y_n",
"firstname","lastname","systemname","password") values
('X','True','True','TEST','TEST','','X');

Produces the following debug information. Can anyone help me with this? The
signal 11 looks pretty bad.

DEBUG: server process (pid 23307) was terminated by signal 11
DEBUG: terminating any other active server processes
DEBUG: all server processes terminated; reinitializing shared memory and
semaphores
DEBUG: database system was interrupted at 2002-08-08 16:15:48 PDT
DEBUG: checkpoint record is at 2/C30A416C
DEBUG: redo record is at 2/C30A416C; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 38682; next oid: 69992620
DEBUG: database system was not properly shut down; automatic recovery in
progress
FATAL 1: The database system is starting up
DEBUG: redo starts at 2/C30A41AC
DEBUG: ReadRecord: record with zero length at 2/C30AC3CC
DEBUG: redo done at 2/C30AA374
DEBUG: database system is ready

Thanks!

-James

James Kelty
Director of Operations
Everbase Systems, LLC
624 A Street
Ashland, OR 97520
jamesk(at)everbase(dot)net
541.488.0801

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Randy Neumann 2002-08-09 13:36:26 Sql Functions
Previous Message Aurangzeb M. Agha 2002-08-08 22:00:14 Re: Proglems with 7.2.1