LOG: failed to commit transaction_isolation

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Michael Fuhr

    LOG: failed to commit transaction_isolation

    PostgreSQL 8.0.0beta2 (CVS)
    Solaris 9

    I've noticed the following message in the server's logs:

    LOG: failed to commit transaction_iso lation

    The log message appears if I issue a SET TRANSACTION ISOLATION LEVEL
    and later do a ROLLBACK. For example:

    BEGIN;
    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; -- or READ COMMITTED
    SELECT VERSION();
    ROLLBACK;

    Why the log message? Is this by design or is it a bug?

    --
    Michael Fuhr


    ---------------------------(end of broadcast)---------------------------
    TIP 3: if posting/reading through Usenet, please send an appropriate
    subscribe-nomail command to majordomo@postg resql.org so that your
    message can get through to the mailing list cleanly

  • Tom Lane

    #2
    Re: LOG: failed to commit transaction_iso lation

    Michael Fuhr <mike@fuhr.or g> writes:[color=blue]
    > I've noticed the following message in the server's logs:
    > LOG: failed to commit transaction_iso lation
    > Why the log message? Is this by design or is it a bug?[/color]

    It's a bug. Fixed --- thanks for the test case.

    regards, tom lane

    ---------------------------(end of broadcast)---------------------------
    TIP 5: Have you checked our extensive FAQ?



    Comment

    Working...