Re: Updating multiple bool values crashes backend

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(dot)Kelly(at)ncl(dot)ac(dot)uk>
"If 99% is good enough, then gravity will not work for 14 minutes
every day."