debug logs: query: rollback
(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@biome.ac.uk
------------------------------------------------------------------
Technical Manager: Biome http://biome.ac.uk/
Greenfield Medical Library,
Queens Medical Centre,
Nottingham. 0115 9249924 x 42059
------------------------------------------------------------------
We are stardust
Bob Parkinson <rwp@biome.ac.uk> wrote:
query: rollback
does this mean that a transaction has failed?
Indeed.
I'm not seeing any other error messages
A rollback need not be the result of the backend raising an error. It can
also be triggered deliberately by your code that talks to the backend.
(mind you, I need to check my scripts and see what they are loggingas
errors).
And check that their transaction behaviour is what you intended. E.g. for
Perl's DBI, note what DBI(3pm) says about this:
:The transaction behavior of the `disconnect' method is, sadly,
:undefined. Some database systems (such as Oracle and Ingres) will
:automatically commit any out� standing changes, but others (such as
:Informix) will rollback any outstanding changes. Applications not using
:`AutoCommit' should explicitly call `commit' or `rollback' before calling
:`disconnect'.
HTH,
Ray
--
No longer will we mistake music for a noun, as its containers have tempted
us to do for a century. We will realize once more that music is a verb, a
relationship, a constantly evolving life form.
John Perry Barlow in http://technocrat.net/958163435/index_html