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

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

pgsql-bugs by date

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

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