Servoy refusing to connect or freezing

Classic Servoy
1

Hi all,

I have a strange problem where both Servoy client and developer will freeze before showing the select project dialog, or, soon after starting to use the solution.

Setup:

Servoy:
2.2 Server running on Mac OS X 10.3.9
Client on Mac OS X 10.3.8
I’m accessing externally with Developer from Mac OS X 10.4.2

Databases:
MySQL 4.0.25 running on Linux at a web host.
PostgreSQL 9 running locally on the same Mac as Servoy Server.
Repository in PostgreSQL 9.

Everything has been running fine until a couple of weeks ago.
I can still access the databases from Aqua Data Studio, and CocoaMySQL without any problems…

Any ideas?

2

Just tried logging on using Developer, got a “Cannot Load Solution”:

java.sql.SQLException: Lost connection to server during query Lost connection to server during query

3

Hi Christian

I guess it’s only Banks that have time off on a UK Bank Holiday …

A good place to look for clues is Applications/Servoy/sybase_db/sybase_log.txt. On Mac you can also use Applications/Utilities/Console - this logs a lot of useful info.

Another thought - have you been using Servoy Runtime? In the past this did have nasty habit of changing the servoy.properties file - not sure if fixed.

HTH

Graham Greensall
Worxinfo Ltd

4

Hi Graham,

I know it is a bank holiday ;-), just catching up with things after some days on the beach…

The problem seem to be linked to my mySQL database. I connect and use all the modules and projects which do not use the mySQL connection. I set up query validation on the server, so now Servoy displays an error message about the lost connection instead of just dying…

I will see if I can access the mySQL log.

5

This seems to be a problem related to the mySQL access host list…

6

The access hosts was a red herring…

It has frozen again…

7

I have now upgraded to 2.2.1rc2.

  • I have set Query Validation with “SELECT 1” on all my mySQL connections on Servoy Server.

AND

since I’m on a Mac and I’m using multiple copies of Servoy Developer accessing different copies of servoy.properties, I have set up query validation in each one of this as well…

and so far it looks like this has improved things.