On Wed, Oct 08, 2008 at 12:15:27PM +0200, Hartmaier Alexander wrote: > 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.
FWIW - I find postgres just a major PIA and he can just use the newer ACID complient data format with MYSQL Ruben > > -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] > -- http://www.mrbrklyn.com - Interesting Stuff http://www.nylxs.com - Leadership Development in Free Software So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://fairuse.nylxs.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 "Yeah - I write Free Software...so SUE ME" "The tremendous problem we face is that we are becoming sharecroppers to our own cultural heritage -- we need the ability to participate in our own society." "> I'm an engineer. I choose the best tool for the job, politics be damned.< You must be a stupid engineer then, because politcs and technology have been attached at the hip since the 1st dynasty in Ancient Egypt. I guess you missed that one." © Copyright for the Digital Millennium --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
