Scary errors in the log

ngervasi · June 21, 2007, 11:01am

This morning while checking a production server I noticed these errors in the log:

2007-06-21 10:02	RMI TCP Connection(1960)-10.10.15.73	ERROR	com.servoy.j2db.util.Debug	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= d.element_id and b.content_id = 15 and c.content_id = 24 and d.content_id = 28' at line 1
2007-06-21 10:02	RMI TCP Connection(1960)-10.10.15.73	ERROR	com.servoy.j2db.util.Debug	select b.property_value, c.property_value, b.element_id, d.property_value from servoy_elements a, servoy_element_properties b, servoy_element_properties c, servoy_element_properties d where a.object_type_id = 4 and a.element_id = b.element_id and a.element_id = c.element_id and a.element_id *= d.element_id and b.content_id = 15 and c.content_id = 24 and d.content_id = 28 and a.solution_id is null and a.parent_element_id is null and b.property_value NOT LIKE ? order by d.property_value, b.element_id
2007-06-21 10:02	RMI TCP Connection(1960)-10.10.15.73	ERROR	com.servoy.j2db.util.Debug	Unknown column 'solution_id' in 'where clause'
2007-06-21 10:02	RMI TCP Connection(1960)-10.10.15.73	ERROR	com.servoy.j2db.util.Debug	select a.element_id, a.property_value from servoy_element_properties a where a.content_id = 37 and a.revision = (select revision from servoy_releases where solution_id is null and release_number = ? and element_id = a.element_id) and a.property_value = ? order by a.property_value
2007-06-21 10:02	RMI TCP Connection(1960)-10.10.15.73	ERROR	com.servoy.j2db.util.Debug	Table 'servoy31_repository.servoy_solutions' doesn't exist
2007-06-21 10:02	RMI TCP Connection(1960)-10.10.15.73	ERROR	com.servoy.j2db.util.Debug	select solution_id from servoy_solutions where solution_name = ?

I’ve not received any complaints from the client so I supposed they didn’t notice any problem.
Looks like there are some problems with servoy repository, anyone have an idea of what is happening?

Server Information
Servoy version 3.1.6-build 410, repository version 29 
Current time: Thu Jun 21 13:02:30 CEST 2007 
Uptime: 1 day 17 hours 15 minutes 46 seconds 

JDK Information
java.vm.name=Java HotSpot(TM) Server VM
java.vm.version=1.5.0_11-b03
java.vm.info=mixed mode
java.vm.vendor=Sun Microsystems Inc. 

Operating System Information
os.name=Linux
os.version=2.6.15-1.2054_FC5smp
os.arch=i386 

System Information
runtime.allocatedMemory=85184K
runtime.usedMemory=52906K

IT2Be · June 21, 2007, 11:13am

Wild guess, have you been working on this db with a higher version.

ngervasi · June 21, 2007, 11:14am

Strange… that table is not in Servoy 3.1 repository but it was on servoy 2.2.
I’m checking the client DB and report back.

ngervasi · June 21, 2007, 11:24am

Really weird…

These are the tables on the Repo DB:

mysql> use servoy31_repository
Database changed
mysql> show tables;
+-------------------------------+
| Tables_in_servoy31_repository |
+-------------------------------+
| servoy_client_stats           | 
| servoy_columninfo             | 
| servoy_content_spec           | 
| servoy_element_properties     | 
| servoy_elements               | 
| servoy_group_elements         | 
| servoy_groups                 | 
| servoy_media                  | 
| servoy_object_types           | 
| servoy_releases               | 
| servoy_revision_history       | 
| servoy_root_elements          | 
| servoy_user_groups            | 
| servoy_user_properties        | 
| servoy_users                  | 
+-------------------------------+
15 rows in set (0.00 sec)

And that “servoy_solutions” table is not there (as expected).
It was used in the old Servoy 2.2 but now is deprecated.

Any chance that there is still some code pointing to that old table?

IT2Be · June 21, 2007, 11:28am

Strange, maybe it is because you are working in the past:

RMI TCP Connection(1960)

To be honest, I don’t know. What when you restart your server?

ngervasi · June 21, 2007, 11:35am

IT2Be:
Strange, maybe it is because you are working in the past:

RMI TCP Connection(1960)

To be honest, I don’t know. What when you restart your server?

Groovy!!!
The old sixties…

The server has been restarted 2 days ago:

Uptime: 1 day 17 hours 15 minutes 46 seconds

IT2Be · June 21, 2007, 11:38am

Yep, I noticed but are your errors also from that period or more recent.

Did you change anything?

ngervasi · June 21, 2007, 11:46am

IT2Be:
Yep, I noticed but are your errors also from that period or more recent.

Did you change anything?

It happened this morning and I never seen this before.
I didn’t change anything.
Servoy 3.1 was clean installed, the repository DB was created from scratch (you can notice the name servoy31_repository), servoy was painfully updated from 3.1.4 to 3.1.6 via intermediate builds and I never touched the repository directly.
Looks really weird, maybe it’s worth a Case in the Support System.

IT2Be · June 21, 2007, 11:50am

I think this looks like a case for support yes.
From what you describe this is really weird.
It could be some (harmless) legacy code in Servoy that should be removed.
Harmless in case the user doesn’t see any issue…

ngervasi · June 21, 2007, 11:54am

IT2Be:
Harmless in case the user doesn’t see any issue…

I hope the user didn’t see any issues because there WASN’T any issue…

I’ll file the case in the support system.

Thanks for your help Marcel!

IT2Be · June 21, 2007, 12:04pm

Always at your service, not always helpful unfortunately

rgansevles · June 27, 2007, 7:09am

Nicola,

I see 2 separate errors in the log

2007-06-21 10:02 RMI TCP Connection(1960)-10.10.15.73 ERROR com.servoy.j2db.util.Debug You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘= d.element_id and b.content_id = 15 and c.content_id = 24 and d.content_id = 28’ at line 1
2007-06-21 10:02 RMI TCP Connection(1960)-10.10.15.73 ERROR com.servoy.j2db.util.Debug select b.property_value, c.property_value, b.element_id, d.property_value from servoy_elements a, servoy_element_properties b, servoy_element_properties c, servoy_element_properties d where a.object_type_id = 4 and a.element_id = b.element_id and a.element_id = c.element_id and a.element_id *= d.element_id and b.content_id = 15 and c.content_id = 24 and d.content_id = 28 and a.solution_id is null and a.parent_element_id is null and b.property_value NOT LIKE ? order by d.property_value, b.element_id
2007-06-21 10:02 RMI TCP Connection(1960)-10.10.15.73 ERROR com.servoy.j2db.util.Debug Unknown column ‘solution_id’ in ‘where clause’
2007-06-21 10:02 RMI TCP Connection(1960)-10.10.15.73 ERROR com.servoy.j2db.util.Debug select a.element_id, a.property_value from servoy_element_properties a where a.content_id = 37 and a.revision = (select revision from servoy_releases where solution_id is null and release_number = ? and element_id = a.element_id) and a.property_value = ? order by a.property_value

The sql contains an outer-join clause, something we do not use in Servoy 3.1.
Is it possible that this is from a custom-query that selects repository-data?

2007-06-21 10:02 RMI TCP Connection(1960)-10.10.15.73 ERROR com.servoy.j2db.util.Debug Table ‘servoy31_repository.servoy_solutions’ doesn’t exist
2007-06-21 10:02 RMI TCP Connection(1960)-10.10.15.73 ERROR com.servoy.j2db.util.Debug select solution_id from servoy_solutions where solution_name = ?

Do you have an own-defined db server (servoy31_repository) that logs into the repository?
This looks like a message from an own-defined db server that logs into the repository database and is still expecting tables from version 2.2.

Rob

ngervasi · June 27, 2007, 9:38am

rgansevles:
Is it possible that this is from a custom-query that selects repository-data?

Bingo!
I already checked my solution twice for something like that but didn’t find anything, now on the third check I’ve found the culprit: an old method in a small module used for data exports (and if I remember well taken from a forum post):

//pass in the form name 
var formName = arguments[0] 

//get solution ID 
//Get a dataset based on query 
var maxReturnedRows = 1 
var query = "select solution_id from servoy_solutions where solution_name = ?" 
var args = new Array(); 
args[0] = application.getSolutionName() 
var dataset = databaseManager.getDataSetByQuery('repository_server', query, args, maxReturnedRows); 

var solutionID = dataset.getValue(1,1) 
var releaseNum = application.getSolutionRelease() 

//get form ID 
maxReturnedRows = 1000 
query = 'select a.element_id, a.property_value ' + 
   'from servoy_element_properties a ' + 
   'where a.content_id = 37 ' + 
   'and a.revision = (select revision from servoy_releases where solution_id = ? and release_number = ? ' + 
   'and element_id = a.element_id) and a.property_value = ? ' + 
   'order by a.property_value' 

args = new Array(); 
args[0] = solutionID 
args[1] = releaseNum 
args[2] = formName 

dataset = databaseManager.getDataSetByQuery('repository_server', query, args, maxReturnedRows); 

var formID = dataset.getValue(1,1) 

//get all the dataproviders for the current form (with or without a name) 
query = 'select b.property_value, c.property_value, b.element_id, d.property_value ' + 
   'from servoy_elements a, servoy_element_properties b, servoy_element_properties c, servoy_element_properties d ' + 
   'where a.object_type_id = 4 ' + 
   '   and a.element_id = b.element_id ' + 
   '   and a.element_id = c.element_id ' + 
   '   and a.element_id *= d.element_id ' + 
   '   and b.content_id = 15 ' + 
   '   and c.content_id = 24 ' + 
   '   and d.content_id = 28 ' + 
   '   and a.solution_id = ? ' + 
   '   and a.parent_element_id = ? ' + 
   '   and b.property_value NOT LIKE ? ' + 
   'order by d.property_value, b.element_id' 

args = new Array(); 
args[0] = solutionID 
args[1] = formID 
args[2] = 'globals.%' 

dataset = databaseManager.getDataSetByQuery('repository_server', query, args, maxReturnedRows); 

var colNames = new Array() 

if(dataset.getMaxRowIndex() > 0) 
{ 
   colNames = dataset.getColumnAsArray(1) 
} 


return colNames

Thanks Rob!
I’m going to warn others that the method is not 3.1 compatible if I manage to find the old post in the forum.

rgansevles · June 27, 2007, 10:13am

Note that queries on the repository may break with every major upgrade, the repository is an internal interface only.
The 3.5 repo is incompatible with 3.1 and for release 4 we are even planning to move large parts of the repository to a version control system.

Rob

ngervasi · June 27, 2007, 10:21am

Thanks Rob, I know that.
The method was already deprecated in my solution, I just have to check how some user managed to trigger it and then remove it.
I also found where the method comes from: it’s part of Bob Cusick “ExcelMaker”, I checked the forum thread and there’s an update already posted to have the method work in 3.1.

Topic		Replies	Views
Solution works in Developer but not on server when deployed Classic Servoy	40	17595	March 3, 2010
3.5.7 import solution issue with MySQL 5.1 Repository Classic Servoy	7	4209	January 4, 2009
HELP SERVOY ...Cant Connect to The App Server Classic Servoy	19	16330	March 13, 2009
Cant Create Repository? (V4.0) Classic Servoy	19	11665	August 22, 2008
can't update a solution Classic Servoy	21	14194	April 25, 2008

Scary errors in the log

Related topics