freeside transaction idle states in postgresql
Stephen D. Bechard
steve at destek.net
Sun Apr 3 19:33:51 PDT 2005
Not sure if this is part of the normal environment for 1.5.0pre6?
Since installing freeside 1.5.0pre6 on my development server and
upgrading my production server, I see that certain parts of the
aspdocs web interface are leaving my postgresql server 7.4.7_3 in
an idle transaction state, which prevents me from running my
nightly vacuumdb script...
Here is what I see from a `ps aux`
pgsql 92589 0.0 0.8 16668 8032 ?? I Sat01PM 0:00.03
postmaster: freeside freeside ::1 idle in transaction (postgr
pgsql 92296 0.0 0.8 16688 8312 ?? I Sat09AM 0:00.03
postmaster: freeside freeside ::1 idle in transaction (postgr
pgsql 98222 0.6 0.8 16676 8640 ?? S 10:17PM 0:00.26
postmaster: freeside freeside ::1 idle in transaction (postgr
pgsql 98221 0.2 0.8 16672 8044 ?? I 10:17PM 0:00.48
postmaster: freeside freeside ::1 idle in transaction (postgr
pgsql 98192 0.0 1.1 16744 11668 ?? I 10:14PM 0:00.57
postmaster: freeside freeside ::1 idle in transaction (postgr
They never seem to go away unless I restart the apache webserver...
I was wondering if this was an issue with my installations or if there
was a way to prevent this, as now I have to restart my apache webserver
to free up all of the connections prior to my vacuuming the databases.
Thanks in Advance,
Steve
More information about the freeside-users
mailing list