Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

Re^3: Dancer app losing DB connection

by sundialsvc4 (Abbot)
on Aug 16, 2014 at 11:23 UTC ( #1097668=note: print w/replies, xml ) Need Help??

in reply to Re^2: Dancer app losing DB connection
in thread Dancer app losing DB connection

Exactly ... and this is the step that you have to intervene:   if the connection-handle is bad, it basically means that the connection has dropped on one side or the other.   The plugin will attempt to re-establish the connection and you must see to it that it does so correctly.   If the credentials are still known-good, it’s not actually “for authentication reasons,” even though it may present itself that way.   A check of both the database and the web-server logs would be a good place to start sleuthing.   Even if for whatever reason (SQL server down, etc.) the connection truly can’t be re-established now, your Dancer app still must manage to do the right thing, or at least a graceful thing.

This is a common issue with long-running persistent processing of any sort, and the symptoms presented definitely can be red-herrings.   Since you know that the credentials you have available to you are good, then you know that the message ... isn’.t.   If you chase the wrong presumption, you’re chasing a rabbit.   (Been there, etc.)

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1097668]
[LanX]: I told you the story about the “new" currency trading system of Dresdner Bank
[LanX]: ?
[Corion]: No, or I don't remember the story ;)
LanX my favourite don't tell me the proof of concept is good enough for production anecdote
[ambrus]: ah, it's one of thos
[Eily]: what, there's a difference between proof of concept and production?
[LanX]: 20 years ago traders were complaining about the latency of the trading system...
[ambrus]: I'm currently in the process of rewriting my proof of concept programs. They sort of developped organically as I was experimenting, so now I've got an ugly mess of multiple programs and one-liners held together by nothing. I'll have to rewrite them to som
[ambrus]: ething that's both cleanly organized and mostly automated.
LanX in train, bad connection

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (12)
As of 2017-03-29 11:45 GMT
Find Nodes?
    Voting Booth?
    Should Pluto Get Its Planethood Back?

    Results (350 votes). Check out past polls.