VCS Database Timeout

[Doug Easterbrook]

hi there.

this is a *feature* of the omnis VCS.

if your database connections drops for any reason, the VCS has not been made smart enough to reconnect.   It assumes a permanent connection at all times.

We use postgres for our VCS that is some 2000 miles away in our cloud servers — over a VPN.

if the internet hiccups or the VPN drops, we will see this exact behaviour.


does it happen all the time?   no, it is somewhat infrequent.        it seems to happen when you don’t want it to and you have to hit ok to a bunch of messages, close the VCS session and re-establish it.


hope that helps.



and.. as a final note,  we’ve been using the VCS for about 15 years, since Studio 4 days and wouldn’t go without using it.     We are just about ready to transition out of it with Studio 10.1 and go with GIT.     The JSON export and pushing to a git repository has a number of advantages:

- a far better resilience to disconnections (ie doesn't’ really impact you)
- a more modern workflow — which means the ability to make changes to code with out checking it out and then just pushing the changes to your main git repository
- the ability to do branches, code compares, blame (see who actually made the last change to a specific line of code in any method)
- you can integrate git with workflow and build services like Jenkins or gitlab


if you are studio 10.1 — I’d consider git as an option.








Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978

> On June 23, 2020, at 11:06 AM, Jeff Gibson <jgibson at interceptsolutions.com> 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