debug logs: query: rollback

From: Bob Parkinson <rwp(at)biome(dot)ac(dot)uk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: debug logs: query: rollback
Date: 2001-04-26 09:54:07
Message-ID: Pine.OSF.4.33.0104261046330.7319-100000@omni.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

(With 7.0.3, going to 1.1 RSN'ish.)

I've just stared looking at logs and I'm getting lines in the log:

query: rollback

does this mean that a transaction has failed? I'm not seeing any other
error messages (mind you, I need to check my scripts and see what they
are loggingas errors).

usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 13874 exited with status 0
CommitTransactionCommand
StartTransactionCommand
query: rollback
ProcessUtility: rollback
CommitTransactionCommand
StartTransactionCommand
query: begin
ProcessUtility: begin
CommitTransactionCommand
StartTransactionCommand
query: rollback
ProcessUtility: rollback
CommitTransactionCommand
proc_exit(0)
shmem_exit(0)
exit(0)

Cheers

Bob Parkinson
rwp(at)biome(dot)ac(dot)uk
------------------------------------------------------------------
Technical Manager: Biome http://biome.ac.uk/

Greenfield Medical Library,
Queens Medical Centre,
Nottingham. 0115 9249924 x 42059
------------------------------------------------------------------
We are stardust

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hiroko 2001-04-26 11:10:56 using POSTGRES in a network
Previous Message Isiah Thomas 2001-04-26 09:41:33 I am now Linux and PostgreSQL user, have a question