Search the web
Sign In
New User? Sign Up
tvdinner
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Real people. Real stories. See how Yahoo! Groups impacts members worldwide.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
MYSQL trouble?   Message List  
Reply | Forward Message #97 of 121 |
Re: [tvdinner] MYSQL trouble?


On Sun, 14 Nov 2004, Pablo Martinez wrote:

> error: DBD::mysql::st execute failed: MySQL server has gone away
> at /usr/lib/perl5/site_perl/5.6.1/Apache/Session/Lock/MySQL.pm line
> 54.

> i actually have to login and restart the database and apache before
> it will decide to start working again. is there a reason/way around
> this? after ahwhile it gets a little tedious

Hmmm...looks like a problem with Apache::Session. Is your MySQL process
complete gone (from ps for example)?

I'll see what I can dig up.


Sean
--
\___/ Sean Keplinger
|o,o| skeplin AT one DOT net
\/ ) http://spookyworld.dnsalias.com
----mm-----------------------------------




Tue Nov 16, 2004 4:43 pm

keane_skeplin
Offline Offline
Send Email Send Email

Forward
Message #97 of 121 |
Expand Messages Author Sort by Date

for some reason, if i let tvdinner sit around ahwhile, when i finaly go to connect to it i get the following error: error: DBD::mysql::st execute failed:...
Pablo Martinez
valmasj
Offline Send Email
Nov 14, 2004
2:08 am

... Hmmm...looks like a problem with Apache::Session. Is your MySQL process complete gone (from ps for example)? I'll see what I can dig up. Sean -- \___/...
Sean Keplinger
keane_skeplin
Offline Send Email
Nov 16, 2004
4:44 pm

... process ... no, its never actually dropped out completly. sometimes i can refresh a billion times and it will come back to life, in a very unstable state...
Pablo Martinez
valmasj
Offline Send Email
Nov 17, 2004
2:56 pm

... I use MySQL for all of my websites (at least Apache::Session) so I think my database never sleeps. The only different thing I do to start is set the max...
Sean Keplinger
keane_skeplin
Offline Send Email
Nov 23, 2004
4:32 pm

not sure if it changes the scenario any, but i previously said that restarting mysql did the trick. which is true under the old version, restarting apache is...
Pablo Martinez
valmasj
Offline Send Email
Dec 6, 2004
4:24 am

... That points pretty much to Apache::Session::MySQL. I've noticed while coding and debugging that when a page crashes with a Mason error, I have to clear the...
Sean Keplinger
keane_skeplin
Offline Send Email
Dec 10, 2004
6:52 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help