Strictly speaking, this is a MySQL error, but I can make some suggestions.
First off, if you google "MySQL server has gone away", you will get a link to MySQL resources on this error. They have plenty of information about the error.
The first thing I would recommend doing in TeleFlow is making it so that your application disconnects from the database just before returning to Wait for Call, and then does a DB Connect just after answering a call to get a new connection for each call.
MySQL does have timeouts for connections, so if you connect only when your application starts, this may be what is happening.
If you are using dbretry to retry queries, another thing you could do is have DBRetry disconnect and then reconnect to the database prior to retrying your query. (It might be wise to only try this once, such as when the db retry counter is at its maximum)
|