We've had a similar problem with Catalyst on the mailing list and MyISAM caused the problem because it's not transaction safe. Maybe the sessionid holding column isn't long enough too. I advice to switch to a real db like postgresql.
-Alex -----Original Message----- From: Keven Murphy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2008 7:26 PM To: Hartmaier Alexander Cc: embperl@perl.apache.org Subject: RE: Problems with Apache and SessionX hanging Yes from the looks of it. Keven Murphy CISSP, GCIA, GCIH, GCFA, GCWN, GAWN CSC Lead Information Risk Manager (LIRM) [EMAIL PROTECTED] (586) 825-5035 Murphy's Law ((U+C+I)x(10-S))/20xAx1/(1-sin(F/10)) U = Urgency C = Complexity I = Importance S = Skill F = Frequency A = Aggravation On Tue, 7 Oct 2008, Hartmaier Alexander wrote: > Are you using MyISAM? > > -Alex > > -----Ursprüngliche Nachricht----- > Von: Keven Murphy [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 07. Oktober 2008 16:59 > An: embperl@perl.apache.org > Betreff: Problems with Apache and SessionX hanging > > Hello all, > > I am having a interesting issue my web server hanging. I have narrowed it > down to SessionX. I run multiple sites off of a single server. I have > recently change my session tracking from file to mysql. The file session > tracking didn't work correctly for one of the websites. Moving to mysql > has fixed the issue. However a new issue has cropped up. The websites will > work correctly for a couple of hours, then everything hangs. The web > server will just sit there for ever saying it is sending data. If I > restart the web server, everything works correctly again. > > I have tried adding a index to the sessions database on apache. That did > not seem to help either. > > Any suggestions? > > I am running Apache 2.2.9, mod_perl 2.0.4, Embperl 2.3.0, Apache::Session > 1.87, and Apache::SessionX 2.01. > > Thank you, > Keven Murphy > [EMAIL PROTECTED] > > Murphy's Law > ((U+C+I)x(10-S))/20xAx1/(1-sin(F/10)) > U = Urgency C = Complexity > I = Importance S = Skill > F = Frequency A = Aggravation > > > > This is an e-mail from General Dynamics Land Systems. It is for the intended > recipient only and may contain confidential and privileged information. No > one else may read, print, store, copy, forward or act in reliance on it or > its attachments. If you are not the intended recipient, please return this > message to the sender and delete the message and any attachments from your > computer. Your cooperation is appreciated. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* > T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien > Handelsgericht Wien, FN 79340b > *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* > Notice: This e-mail contains information that is confidential and may be > privileged. > If you are not the intended recipient, please notify the sender and then > delete this e-mail immediately. > *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > This is an e-mail from General Dynamics Land Systems. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
