How can we get rid of old/deleted column info ?

Classic Servoy
1

Hi all,

Recently investigating on a very strange bug involving calculations, column and tables renaming and/or deletion, we noticed that servoy was keeping a bunch of unwanted references to columns there were erased/renamed/moved a long time ago (1-2 years) from our solutions.

Setting log to verbose, we noticed the following error messages (extract):

Mar 12 12:08:17 droopy [0x0-0x223f23d].SRVY[10042]: 2008-03-12 12:08:17,908 INFO [TaskExecuter[0]] com.servoy.j2db.util.Debug - Found info old/deleted(?) column for a column named: 'f0000'
Mar 12 12:08:18 droopy [0x0-0x223f23d].SRVY[10042]: 2008-03-12 12:08:18,302 INFO [TaskExecuter[0]] com.servoy.j2db.util.Debug - Found info old/deleted(?) column for a column named: 'f0013'
Mar 12 12:08:18 droopy [0x0-0x223f23d].SRVY[10042]: 2008-03-12 12:08:18,302 INFO [TaskExecuter[0]] com.servoy.j2db.util.Debug - Found info old/deleted(?) column for a column named: 'f0014'
Mar 12 12:08:18 droopy [0x0-0x223f23d].SRVY[10042]: 2008-03-12 12:08:18,302 INFO [TaskExecuter[0]] com.servoy.j2db.util.Debug - Found info old/deleted(?) column for a column named: 'f0015'
Mar 12 12:08:18 droopy [0x0-0x223f23d].SRVY[10042]: 2008-03-12 12:08:18,302 INFO [TaskExecuter[0]] com.servoy.j2db.util.Debug - Found info old/deleted(?) column for a column named: 'f0016'
Mar 12 12:08:18 droopy [0x0-0x223f23d].SRVY[10042]: 2008-03-12 12:08:18,302 INFO [TaskExecuter[0]] com.servoy.j2db.util.Debug - Found info old/deleted(?) column for a column named: 'f0017'

Does anybody know a method to get rid of those references?

2

This to add some complementary information.

This issue is almost silent until you import the solution in a brand new repository without creating the tables before import (what we usually do). But we also think it may be involved in sometime preventing records to be saved to back end.

When doing this, servoy (re-)creates columns which do not exist anymore on main (development) server.

Does anybody experiment such a behaviour?

3

Please note that is an old problem, the latest version of Servoy deletes all calculations, events, etc related to a table when you drop a table.

Rob

4

Old columninfo does not lead to columns being created when deploying your solutions, old columninfo can/will not cause any trouble. it only contains additional data to a column (but does not hold column type for example)
We cannot explain the column creation you are reporting, but for sure its not due to “hanging” columninfo