VCS Database Timeout

[Phil (OmnisList)]

Hi Jeff,

Since over the internet you may lose connections, you probably want to 
set the MySQL property kMySqlOptReconnect to 1 in the 3rd tab specific 
for MySQL database connections...

You will still get disconnect errors, but it will then reconnect, and 
continue...

Probably only happens when you are not using the connection for the 
timeout period...

So during a build etc. you will not have these issues.

regards
Phil Potter
Based in Chester in the UK.

On 23/06/2020 19:06, Jeff Gibson wrote:
> So I have created a MySQL database running on Hostgator that we are using to
> start testing VCS Source Control.
>
>   
>
> We fully intend on using this as a sandbox for now.  So if we break
> anything, we can blow the database away and start over.
>
>   
>
> Anyway, I've managed to successfully push our source code up into our MySQL
> database running on Hostgator.
>
>   
>
> Everything connects with no issues.  Still trying to work my way around
> learning how this VCS environment works in conjunction with the library
> file.
>
>   
>
> After about 10 or 15 minutes, I start getting the following messages.
>
>   
>
> SQL Error - kStatementNotPrepared - The statement must be prepared.   Lost
> connection to MySQL server during query
>
>   
>
> Followed by
>
>   
>
> SQL Error - kStatementNotPrepared - The statement must be prepared.   MySQL
> server has gone away (this displays 6 times)
>
>   
>
> This obviously feels like some kind of timeout issue.  Where we're losing
> our connection to the VCS database.
>
>   
>
> I have found the following settings in the VCS_SESSION object.
>
>   
>
> On the Advanced Tab
>
> $logontimeout  (set to 15)  I don't know if that's seconds or minutes.  I'll
> assume minutes.
>
>   
>
> On the MySQL Tab
>
> kMySqlOptConnectTimeout
>
> kMySqlOptReadTimeout
>
> kMySqlOptWriteTimeout
>
>   
>
> Any suggestions on what can be done to turn off the Timeout option all
> together?
>
>   
>
> Thanks!
>
>   
>
> Jeff Gibson
>
> Oversite Online
>
> Nashville, TN
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com