Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group