in reply to DBI lost connection errors

Hi Marcello,

www.mysql.com is an excellent resource, try this link for more info on your error.

barrd

Replies are listed 'Best First'.
Re: Re: DBI lost connection errors
by Marcello (Hermit) on Jun 11, 2003 at 13:09 UTC
    Hi barrd,

    Thanks for your reply, I've already checked these links. I am almost sure it has something to do with the Perl code, since it only affects the main process and not its childs.

    If I take a look at the MySQL connections, the connection of the main process never changes, although the connection is lost quite often.

    Regards, Marcel
      Hi again Marcello,

      Hmmm, at a loss now, though maybe if you post some code that might help. I'm going to keep a close eye on this thread as I will be doing something similar in the next couple of months or so (which is why I knew the links at mysql.com). Hopefully after posting some code a more knowledgeable Monk might be able to shed some light.

      Sorry, I did try though... ;) Good luck.

      barrd

        Might there be a limit of connections per IP that is causing it to drop an older connection from your IP in favor of making the new one? I might not understand what you are asking but that's about the only think I could think of. maybe if you moved them into mutex threads, and used the same $dbh. Again that's just a very abstract idea. Hope it spurs your creativity.