Re: Dancer app losing DB connection

Actually, database connections can drop for any reason ... inactivity, server restarts, sunspots ...

So, what you need to be prepared to do, in your code, is to check the connection and to re-establish it at any time that you find it to have dropped. This is true for any presistent server of any sort.

Replies are listed 'Best First'.
Re^2: Dancer app losing DB connection by jeromek (Novice) on Aug 16, 2014 at 01:27 UTC
The problem is not that the connection dropped. In case of a bad connection handle, the database plugin tries to open a new connection. At this point it does a DBI connect which fails for authentication reasons.	[reply]
Re^3: Dancer app losing DB connection by locked_user sundialsvc4 (Abbot) on Aug 16, 2014 at 11:23 UTC
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.)