Menu
▾
▴
Re: [Pagekit-users] Postgres hanging on sessions?
|
From: David C. <da...@co...> - 2002-03-26 16:20:20
|
Ben, thanks - I will try your setting. To answer your first question, I
have never had the session table in the same database, but I will give that
a try also. I am using Postgres v7.2 and Apache::DBI.
Thanks again,
David
On 3/26/02 11:05 AM, "Ben Ausden" <Ben...@na...> wrote:
> David,
>
> My session hash looks like this:
>
> my %session_setup = (
> session_store_class => 'Postgres',
> session_lock_class => 'Null',
> session_serialize_class => 'Base64',
> session_args => {
> Handle => $dbh,
> IDLength => 32,
> Commit => 1
> }
> );
>
> I'm using 1.08 with Apache::SessionX, but I've been using Postgres with
> PageKit since v0.97 and never had any issues with it.
>
> Do you experience the same problem if you put the session table in whatever
> database $model->dbh references (rather than using a separate db
> connection)?
>
> What version of Postgres are you using? Have you got Apache::DBI in your
> startup.pl?
>
>
> cheers,
> ben
>
>
>
>> -----Original Message-----
>> From: David Christian [mailto:da...@co...]
>> Sent: 26 March 2002 15:29
>> To: pagekit users
>> Subject: [Pagekit-users] Postgres hanging on sessions?
>>
>>
>> Is anyone having a problem with Postgres hanging with Apache::Session?
>>
>> Here is my session setup:
>>
>> my %session_setup = (
>> session_store_class => 'Postgres',
>> session_lock_class => 'Null',
>> session_args => {
>> DataSource => dbi:Pg:dbname=session,
>> UserName => 'user',
>> Password => 'pass',
>> Serialize => 'Base64',
>> Commit => 1
>> }
>> );
>>
>> After a lot of use, especially multiple simultaneous use,
>> Postgres hangs and
>> will only shutdown with 'pg_ctl shutdown -m immediate'.
>>
>> When looking at processes, I see a lot of this:
>>
>> postgres: pgsql session [local] idle
>> postgres: pgsql session [local] SELECT waiting
>> postgres: pgsql session [local] idle
>> postgres: pgsql session [local] idle in transaction
>> postgres: pgsql session [local] idle
>> postgres: pgsql session [local] idle in transaction
>> postgres: pgsql session [local] idle
>> postgres: pgsql session [local] idle in transaction
>> postgres: pgsql session [local] idle
>> postgres: pgsql session [local] idle in transaction
>> postgres: pgsql session [local] idle
>> postgres: pgsql session [local] idle in transaction
>> postgres: pgsql session [local] idle
>> postgres: pgsql session [local] idle in transaction
>> postgres: pgsql session [local] idle
>> postgres: pgsql session [local] SELECT waiting
>> postgres: pgsql session [local] idle
>> postgres: pgsql session [local] SELECT waiting
>> postgres: pgsql session [local] idle
>> postgres: pgsql session [local] SELECT waiting
>> postgres: pgsql session [local] idle
>> postgres: pgsql session [local] SELECT waiting
>> postgres: pgsql session [local] idle
>> postgres: pgsql session [local] SELECT waiting
>> postgres: pgsql session [local] idle
>> postgres: pgsql session [local] SELECT waiting
>>
>>
>> When Postgres hangs, I cannot connect to it, even through psgl.
>>
>> I've seen some postings online about this problem, especially
>> regarding the
>> 'idle in transaction part'. In particular, this link has
>> some information
>> with regard to HTML::Embperl
>>
>> http://www.ecos.de/~mailarc/embperl/2001-06/msg00096.html
>>
>> but I don't know if any of that would apply to Apache-PageKit. ?
>>
>> I thought I may be doing something wrong with my
>> %session_setup. Does it
>> look okay? I haven't noticed this problem before, I think because I
>> haven't had heavy usage until now. I'm using PageKit v1.07.
>>
>> Any advice would be appreciated. Let me know if any other
>> details would be
>> helpful. Meanwhile, I will plan to move my session database
>> to MySQL. I
>> will also test PageKit v1.08 on another machine shortly.
>>
>> Thanks,
>> David
>>
>>
>>
>> _______________________________________________
>> Pagekit-users mailing list
>> Pag...@li...
>> https://lists.sourceforge.net/lists/listinfo/pagekit-users
>>
>
|