Servoy 3.5.x restoring deleted relationships...

Classic Servoy
1

Hi all,

I wonder if anyone else have come across the following bug:

One of my clients had to restart their Servoy server yesterday because of a Windows update. Afterwards, Servoy client displayed ‘Can not load form data’ on startup.

I looked at the repository using Developer. About 10 old, deleted relationships were listed. The mySQL server they related to has been deleted more than 6 months ago. The mySQL server is still listed in the server preferences, but is inactive.

I checked the latest release of each module using ‘Replace Table’ in the Repository window, and there were no references anywhere to the old mySQL server.

Then I deleted the 10 broken relationships and restarted and everything worked fine after I forced all the servoy clients to reload the new version of solution without the relationships.

This particular server has been running fine for months.

Servoy version 3.5.3-build 516, repository version 31
os.name=Windows 2003
os.version=5.2
os.arch=x86
java.vm.version=10.0-b19

The same thing happened a few weeks ago with another server on Mac OS X, possibly with Mac OS 10.4.x, Servoy 3.5.5 and Java 1.5.

2

We use database transactions for changes on the solution, and servoy cannot makeup things it is no longer aware of.
So it sounds like your database does find some supposed uncommitted log, which is applies again on restart of server.
What database are you using?

3

PostgreSQL.

The server has been restarted 2-3 times in the last 6 months.

The odd thing was that no references to the deleted server showed up when looking at the modules using ‘Replace Table’ in the repository. Only when opening the main module and editing relationships did they show up.

I thought I’d flag this issue in case others come across it. This is system in production and we had a 2 hours downtime because of the problem.