Skip to content

WARNING: there is no transaction in progress without Examples #851

@ccppprogrammer

Description

@ccppprogrammer

On my pgbadger installation I see regression between pgbadger 9.2 and 13.1.
In "Most Frequent Errors/Events" section for "WARNING: there is no transaction in progress" in 9.2 I have examples, but in 13.1 pgbadger generates without it.

The command to run pgbadger is:

/usr/bin/pgbadger --tempdir /var/lib/pgbadger/tmp/xxx --pid-dir /var/lib/pgbadger/tmp/xxx --pid-file /var/lib/pgbadger/tmp/xxx/xxx.pid --timezone +3 --jobs 4 -q --disable-query --prefix '#%m [%p]: [%l-1] { user=%u,db=%d,c=%c,e=%e,x=%x,a=%a,r=%r,i=%i,v=%v } ' -o /var/lib/pgbadger/www/htdocs/xxx/xxx.html /var/lib/backup/pg_logs/xxx/xxx/xxx-*.log

PostgreSQL log line:

#2025-06-20 07:00:05.153 [38815]: [3372-1] { user=xxx,db=xxx,c=6854dc3c.979f,e=25P01,x=0,a=xxx(xxx):///x,r=x.x.x.x(45634),i=ROLLBACK,v=127/2414475 } WARNING:  there is no transaction in progress

pgbadger 9.2:

Image

pgbadger 13.1:

Image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions