Re: Updating multiple bool values crashes backend

From: Sean Kelly <S(dot)Kelly(at)ncl(dot)ac(dot)uk>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Updating multiple bool values crashes backend
Date: 2000-10-25 13:20:45
Message-ID: 20001025122049.EE50A556F@random.ncl.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)Kelly(at)ncl(dot)ac(dot)uk>
"If 99% is good enough, then gravity will not work for 14 minutes
every day."

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Lockhart 2000-10-25 13:53:20 Re: Updating multiple bool values crashes backend
Previous Message Kovacs Zoltan Sandor 2000-10-25 12:10:07 bug in views/aggregates