Angus Lees wrote:
>
> On Wed, May 23, 2001 at 09:11:53PM +0200, Robert wrote:
> > Is anybody here using Apache::Session/Postgres combination without
> > problems? If so, could you be so kind as to post your configuration? If
> > not, how far did you get last time you tried? Is anybody interested in
> > using it at all?
>
> finally got around to looking at this myself..
Your comments prompted me to set this up myself and give it a better try
then last time. I'll be needing session management soon anyways.
> > Sorry if I sound a bit pessimistic - I applied patch Angus Lee posted
> > week ago on Embperl list and it almost works, but I still have some idle
> > postgres backend hanging around. It's getting really frustrating.
I just your patch from May 11, added the
Apache::Session::Store::Postgres::close function, and still postgres
backends that are hanging somewhere in the transaction.
> from what i can work out (and i have no clue about databases), its
> normal to have one postgres process per apache child process, since
> apache keeps the db connection open.
Isn't this only supposed to happen when using Apache::DBI? I'm not using
Apache::DBI, and still get a postgres process for each apache child
process.
> i notice that the postgres processes claim to be "idle in
> transaction". i have no idea what this transaction is (the above patch
> doesn't change it). i think it would be good to track this down at
> some point.
I get this behaviour when using %mdat by itself, when using %udat by
itself, and when using them both together.
It could be that its not commiting or rolling back properly. I am seeing
these errors in the apache error logs, which leads me to think its
something in the transaction is not going through properly, and hence
they are sitting there waiting to do something.
FATAL 1: This connection has been terminated by the administrator.
[Tue Jun 26 10:47:45 2001] [warn] [1534]ERR: 32: Line 4: Warning in
Perl code: DBD::Pg::db commit failed: commit
failed at /usr/local/share/perl/5.6.1/Apache/Session/Store/Postgres.pm
line 128.
FATAL 1: This connection has been terminated by the
administrator.
[Tue Jun 26 11:10:37 2001] [warn] [3077]ERR: 32: Line 11: Warning in
Perl code: DBD::Pg::db rollback failed: rollback failed at
/usr/local/share/perl/5.6.1/Apache/Session/Store/Postgres.pm line 128.
Hopefully this information will help someone...
BTW, here are my session settings from startup.pl:
BEGIN {
$ENV{EMBPERL_SESSION_CLASSES} = "Postgres Null Base64";
$ENV{EMBPERL_SESSION_ARGS} = "DataSource=dbi:Pg:dbname=sessions
UserName=postgres Transaction=1 Commit=1";
};
--
Regards,
Wim Kerkhoff, Software Engineer
Merilus, Inc. -|- http://www.merilus.com
Email: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
