Re: Updating multiple bool values crashes backend - Mailing list pgsql-bugs

From Sean Kelly
Subject Re: Updating multiple bool values crashes backend
Date
Msg-id 20001025122049.EE50A556F@random.ncl.ac.uk
Whole thread Raw
In response to Re: Updating multiple bool values crashes backend  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List pgsql-bugs
Here is a debug (level 2) output - does this help any
more?...  If not, what should I provide for you in terms of
debugging?...


FindExec: found "/usr/local/postgres/bin/postgres" using argv[0]
binding ShmemCreate(key=52e2c1, size=1104896)
DEBUG:    Data Base System is starting up at Wed Oct 25 13:15:17 2000
DEBUG:    Data Base System was shut down at Wed Oct 25 13:14:49 2000
DEBUG:    Data Base System is in production state at Wed Oct 25
13:15:17 2000
proc_exit(0)
shmem_exit(0)
exit(0)
/usr/local/postgres/bin/postmaster: reaping dead processes...
/usr/local/postgres/bin/postmaster: ServerLoop:     handling
reading 5
/usr/local/postgres/bin/postmaster: ServerLoop:     handling
reading 5
/usr/local/postgres/bin/postmaster: ServerLoop:     handling
writing 5
/usr/local/postgres/bin/postmaster: BackendStartup: pid 28428 user
sean db users socket 5
/usr/local/postgres/bin/postmaster child[28428]: starting with
(/usr/local/postgres/bin/postgres -d2 -v131072 -p users )
FindExec: found "/usr/local/postgres/bin/postgres" using argv[0]
started: host=localhost user=sean database=users
InitPostgres
StartTransactionCommand
query: SELECT usesuper FROM pg_user WHERE usename = 'sean'
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: delete from dialup_tbl where username='sib';
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: delete from users_tbl where username='sib';
ProcessQuery
query: SELECT oid FROM "dialup_tbl" WHERE "username" = $1 FOR UPDATE
OF "dialup_tbl"
/usr/local/postgres/bin/postmaster: reaping dead processes...
/usr/local/postgres/bin/postmaster: CleanupProc: pid 28428 exited
with status 11
Server process (pid 28428) exited with status 11 at Wed Oct 25
13:15:35 2000
Terminating any active server processes...
Server processes were terminated at Wed Oct 25 13:15:35 2000
Reinitializing shared memory and semaphores
shmem_exit(0)
binding ShmemCreate(key=52e325, size=1104896)
/usr/local/postgres/bin/postmaster: ServerLoop:     handling
reading 5
/usr/local/postgres/bin/postmaster: ServerLoop:     handling
reading 5
DEBUG:    Data Base System is starting up at Wed Oct 25 13:15:35 2000
DEBUG:    Data Base System was interrupted being in production at Wed
Oct 25 13:15:17 2000
/usr/local/postgres/bin/postmaster: ServerLoop:     handling
writing 5
The Data Base System is starting up
/usr/local/postgres/bin/postmaster: ServerLoop:     handling
writing 5
DEBUG:    Data Base System is in production state at Wed Oct 25
13:15:35 2000
proc_exit(0)
shmem_exit(0)
exit(0)
/usr/local/postgres/bin/postmaster: reaping dead processes...

    Thanks,

--
Sean Kelly <S.Kelly@ncl.ac.uk>
"If 99% is good enough, then gravity will not work for 14 minutes
 every day."

pgsql-bugs by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Updating multiple bool values crashes backend
Next
From: Thomas Lockhart
Date:
Subject: Re: Updating multiple bool values crashes backend