# HELP SERVOY ...Cant Connect to The App Server **URL:** \ **Category:** Classic Servoy\ **Created:** [March 11, 2009, 5:35pm UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404 "2009-03-11T17:35:23Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [March 11, 2009, 5:35pm UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/1 "2009-03-11T17:35:23Z")
Appreciate some Servoy feedback as this is a show stopper at the moment. This is getting to be monotonous isn’t it… Sorry Guys feel like I’m rehashing same old stuff here but I’m not sure where to go for a solution with this! Thought it’d be dirt easy to install 4.1.1F on a new clean PC with MySQL. Installed OK, MySQL running fine (checked it using Navicat), used a SQL Dump to populate the Db’s from my other dev machine, and ran Servoy. Of course after creating the Db Servers Servoy wants to upgrade the repository - and though I’m a single development environment of course I say yes to this. Variously getting the ‘Application server does not accept client connections’ / ‘Cannot create/upgrade the repository’ errors. Seems the application server has not started. The last time I had this sort of challenge it was because the Team setting in the admin page was set to false - this time its true. Obviously I cant import my solution since I cant get to it through the admin page (not started). Here is what I’ve tried: Kill all Virus checking, kill the firewall (all local host though anyway), PC is completely open. Start the app server from the servoy\_server.bat - it doesn’t. Start the app server from the windows services page (after closing developer) - but that failed to start too - tries to start and then fails woth a 1067 error. Start Server with servoy\_server.bat -upgraderepository - no change. Re-installing Servoy - no change. Deleting tables in the servoy\_repository (in the hope they would be re-created when the repository was rebuilt). Is it possible to upgrade the repository by hand somehow? What should I now test for to get the (developer) app server running? Here are the Logs - that I’d appreciate some feedback on: .metadata !SESSION 2009-03-11 18:02:48.500 ----------------------------------------------- eclipse.buildId=M20071023-1652 java.version=1.6.0\_11 java.vendor=Sun Microsystems Inc. BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en\_GB Framework arguments: --launcher.XXMaxPermSize 256M Command-line arguments: -os win32 -ws win32 -arch x86 --launcher.XXMaxPermSize 256M !ENTRY com.servoy.eclipse.core 1 0 2009-03-11 18:02:53.640 !MESSAGE Cannot find any valid solution to activate. !ENTRY org.eclipse.ui.workbench 2 0 2009-03-11 18:02:54.546 !MESSAGE A handler conflict occurred. This may disable some commands. !SUBENTRY 1 org.eclipse.ui.workbench 2 0 2009-03-11 18:02:54.546 !MESSAGE Conflict for ‘AUTOGEN:::org.eclipse.ui.cheatsheets.actionSet/org.eclipse.ui.cheatsheets.actions.CheatSheetHelpMenuAction’: HandlerActivation(commandId=AUTOGEN:::org.eclipse.ui.cheatsheets.actionSet/org.eclipse.ui.cheatsheets.actions.CheatSheetHelpMenuAction, handler=ActionDelegateHandlerProxy(null,org.eclipse.ui.cheatsheets.CheatSheetExtensionFactory:helpMenuAction), expression=AndExpression(ActionSetExpression(org.eclipse.ui.cheatsheets.actionSet,org.eclipse.ui.internal.WorkbenchWindow@1d4f355),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@1d4f355)),sourcePriority=16640) HandlerActivation(commandId=AUTOGEN:::org.eclipse.ui.cheatsheets.actionSet/org.eclipse.ui.cheatsheets.actions.CheatSheetHelpMenuAction, handler=ActionDelegateHandlerProxy(null,org.eclipse.ui.cheatsheets.CheatSheetExtensionFactory:helpMenuAction), expression=AndExpression(ActionSetExpression(org.eclipse.ui.cheatsheets.actionSet,org.eclipse.ui.internal.WorkbenchWindow@1d4f355),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@1d4f355)),sourcePriority=16640) !ENTRY com.servoy.eclipse.core 4 0 2009-03-11 18:03:06.093 !MESSAGE Failed to create/upgrade repository. !STACK 0 com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘servoy\_content\_spec’ already exists at com.servoy.j2db.persistence.RepositoryUpdater.createRepositoryTables(RepositoryUpdater.java:1307) at com.servoy.j2db.persistence.Server.createActualRepositoryTables(Server.java:530) at com.servoy.j2db.persistence.Server.createRepositoryTables(Server.java:622) at com.servoy.eclipse.team.ServoyTeamProvider$6.run(ServoyTeamProvider.java:4) at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:129) at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3659) at org.eclipse.swt.widgets.Display.msgFilterProc(Display.java:3041) at org.eclipse.swt.internal.win32.OS.TrackPopupMenu(Native Method) at org.eclipse.swt.widgets.Menu.\_setVisible(Menu.java:228) at org.eclipse.swt.widgets.Display.runPopups(Display.java:3708) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3287) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447) at org.eclipse.equinox.launcher.Main.run(Main.java:1173) Caused by: com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘servoy\_content\_spec’ already exists at com.servoy.j2db.persistence.Server.syncTableObjWithDB(Server.java:411) at com.servoy.j2db.persistence.RepositoryUpdater.createRepositoryTables(RepositoryUpdater.java:636) … 31 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘servoy\_content\_spec’ already exists at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.servoy.j2db.persistence.datasource.Ze.invoke(Ze.java:5) at $Proxy0.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183) at com.servoy.j2db.persistence.Server.syncTableObjWithDB(Server.java:1456) … 32 more !ENTRY com.servoy.eclipse.core 4 0 2009-03-11 18:04:41.484 !MESSAGE Cannot get solutions from repository !STACK 0 com.servoy.eclipse.team.Zb: Application server does not accept client connections. at com.servoy.eclipse.team.RepositoryAccessPoint.Za(RepositoryAccessPoint.java:113) at com.servoy.eclipse.team.ui.NewSolutionWizard$4.runInWorkspace(NewSolutionWizard.java:14) at org.eclipse.core.internal.resources.InternalWorkspaceJob.run(InternalWorkspaceJob.java:38) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55) servoy\_log 2009-03-11 18:02:51,796 ERROR [Thread-3] com.servoy.j2db.util.Debug - Throwable com.servoy.j2db.persistence.RepositoryException: Old repository found in the database. Repository version: 0, software version: 35. Upgrade the repository first. at com.servoy.j2db.persistence.Repository.testIfValid(Repository.java:1625) at com.servoy.j2db.persistence.Repository.(Repository.java:178) at com.servoy.j2db.persistence.Repository.(Repository.java:1641) at com.servoy.j2db.persistence.Server.getRepository(Server.java:730) at com.servoy.j2db.server.ApplicationServer.initFromSerclipse(ApplicationServer.java:353) at com.servoy.eclipse.core.ServoyModel.startAppServer(ServoyModel.java:182) at com.servoy.eclipse.core.util.SplashHandler$1.run(SplashHandler.java:2) at java.lang.Thread.run(Unknown Source) (I Truncated the log) ---
**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\ **Post date:** [March 12, 2009, 9:43am UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/2 "2009-03-12T09:43:15Z")
> Thought it’d be dirt easy to install 4.1.1F on a new clean PC with MySQL. Installed OK, MySQL running fine (checked it using Navicat), used a SQL Dump to populate the Db’s from my other dev machine, and ran Servoy. Of course after creating the Db Servers Servoy wants to upgrade the repository - and though I’m a single development environment of course I say yes to this. Variously getting the ‘Application server does not accept client connections’ / ‘Cannot create/upgrade the repository’ errors. Maybe it is me ( read: possibly ![:)]( "Smile") ) but why do you do this? When you are going to do a clean install isn’t it easier to create an export with sample data and set the amount of exported rows to unlimited. Or do I miss something? ---
**Author:** ![Andrei\_Costescu](https://avatars.discourse-cdn.com/v4/letter/a/e36b37/32.png) [@Andrei\_Costescu](https://forum.servoy.com/u/Andrei_Costescu)\ **Post date:** [March 12, 2009, 9:50am UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/3 "2009-03-12T09:50:58Z")
> Deleting tables in the servoy\_repository (in the hope they would be re-created when the repository was rebuilt). I think this should have solved your problem. It looks like some tables in the repository server exist (like “servoy\_content\_spec”) but the repository you created using SQL Dump is not valid (it reports old version 0). Could you try again to delete all tables in servoy\_repository then restart Servoy Developer? If, after you create a blank repository all works fine then there is probably something wrong with the content of the old repository DB. In this case you can try to backup then use directly the old repository database (that you know is working in previous release) and see if you are able to upgrade that one using 4.1.1. ---
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [March 12, 2009, 10:18am UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/4 "2009-03-12T10:18:12Z")
> Andrei Costescu: > > > Deleting tables in the servoy\_repository (in the hope they would be re-created when the repository was rebuilt). > > I think this should have solved your problem. > It looks like some tables in the repository server exist (like “servoy\_content\_spec”) but the repository you created using SQL Dump is not valid (it reports old version 0). > > Could you try again to delete all tables in servoy\_repository then restart Servoy Developer? > If, after you create a blank repository all works fine then there is probably something wrong with the content of the old repository DB. In this case you can try to backup then use directly the old repository database (that you know is working in previous release) and see if you are able to upgrade that one using 4.1.1. I think I was’nt clear - my SQL dump / restore was on my database only not the repository. This did not work Andrei - to try and resolve the problem I have tried a completely new install. Deleted all the tables in repository server (servoy\_repository) and restarted developer - and made no connections to any other Db’s. When asked to upgrade the repository it appears the repository tables are recreated but I get the Cant Create / Upgrade Repository error. If I then go to Solutions Checkout I get the Application Server does not accept client connections error. This is totally clean now there is no legacy stuff at all - but still I cant start the system? Here are the logs for this clean attempt to upgrade the repository. New Logs: !SESSION 2009-03-12 11:11:17.343 ----------------------------------------------- eclipse.buildId=M20071023-1652 java.version=1.6.0\_11 java.vendor=Sun Microsystems Inc. BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en\_GB Framework arguments: --launcher.XXMaxPermSize 256M Command-line arguments: -os win32 -ws win32 -arch x86 --launcher.XXMaxPermSize 256M !ENTRY com.servoy.eclipse.core 1 0 2009-03-12 11:11:22.250 !MESSAGE Cannot find any valid solution to activate. !ENTRY org.eclipse.ui.workbench 2 0 2009-03-12 11:11:23.000 !MESSAGE A handler conflict occurred. This may disable some commands. !SUBENTRY 1 org.eclipse.ui.workbench 2 0 2009-03-12 11:11:23.000 !MESSAGE Conflict for ‘AUTOGEN:::org.eclipse.ui.cheatsheets.actionSet/org.eclipse.ui.cheatsheets.actions.CheatSheetHelpMenuAction’: HandlerActivation(commandId=AUTOGEN:::org.eclipse.ui.cheatsheets.actionSet/org.eclipse.ui.cheatsheets.actions.CheatSheetHelpMenuAction, handler=ActionDelegateHandlerProxy(null,org.eclipse.ui.cheatsheets.CheatSheetExtensionFactory:helpMenuAction), expression=AndExpression(ActionSetExpression(org.eclipse.ui.cheatsheets.actionSet,org.eclipse.ui.internal.WorkbenchWindow@1f35e30),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@1f35e30)),sourcePriority=16640) HandlerActivation(commandId=AUTOGEN:::org.eclipse.ui.cheatsheets.actionSet/org.eclipse.ui.cheatsheets.actions.CheatSheetHelpMenuAction, handler=ActionDelegateHandlerProxy(null,org.eclipse.ui.cheatsheets.CheatSheetExtensionFactory:helpMenuAction), expression=AndExpression(ActionSetExpression(org.eclipse.ui.cheatsheets.actionSet,org.eclipse.ui.internal.WorkbenchWindow@1f35e30),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@1f35e30)),sourcePriority=16640) !ENTRY com.servoy.eclipse.core 4 0 2009-03-12 11:12:12.515 !MESSAGE Failed to create/upgrade repository. !STACK 0 com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs at com.servoy.j2db.persistence.RepositoryUpdater.createRepositoryTables(RepositoryUpdater.java:1307) at com.servoy.j2db.persistence.Server.createActualRepositoryTables(Server.java:530) at com.servoy.j2db.persistence.Server.createRepositoryTables(Server.java:622) at com.servoy.eclipse.team.ServoyTeamProvider$6.run(ServoyTeamProvider.java:4) at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:129) at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3659) at org.eclipse.swt.widgets.Display.msgFilterProc(Display.java:3041) at org.eclipse.swt.internal.win32.OS.TrackPopupMenu(Native Method) at org.eclipse.swt.widgets.Menu.\_setVisible(Menu.java:228) at org.eclipse.swt.widgets.Display.runPopups(Display.java:3708) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3287) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447) at org.eclipse.equinox.launcher.Main.run(Main.java:1173) Caused by: com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs at com.servoy.j2db.persistence.Server.syncTableObjWithDB(Server.java:411) at com.servoy.j2db.persistence.RepositoryUpdater.recreateServoyColumnInfo(RepositoryUpdater.java:268) at com.servoy.j2db.persistence.RepositoryUpdater.createRepositoryTables(RepositoryUpdater.java:1442) … 31 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.servoy.j2db.persistence.datasource.Ze.invoke(Ze.java:5) at $Proxy0.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183) at com.servoy.j2db.persistence.Server.syncTableObjWithDB(Server.java:1456) … 33 more servoy 2009-03-12 11:11:20,703 ERROR [Thread-3] com.servoy.j2db.util.Debug - Throwable com.servoy.j2db.persistence.RepositoryException: No repository found in the database. at com.servoy.j2db.persistence.Repository.testIfValid(Repository.java:39) at com.servoy.j2db.persistence.Repository.(Repository.java:178) at com.servoy.j2db.persistence.Repository.(Repository.java:1641) at com.servoy.j2db.persistence.Server.getRepository(Server.java:730) at com.servoy.j2db.server.ApplicationServer.initFromSerclipse(ApplicationServer.java:353) at com.servoy.eclipse.core.ServoyModel.startAppServer(ServoyModel.java:182) at com.servoy.eclipse.core.util.SplashHandler$1.run(SplashHandler.java:2) at java.lang.Thread.run(Unknown Source) ---
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [March 12, 2009, 11:16am UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/5 "2009-03-12T11:16:55Z")
Really appreciate some feedback on this urgently please Guys - I’ve lost 2 days of a very tight development schedule now, and I need to understand why this system is not working? ---
**Author:** ![Andrei\_Costescu](https://avatars.discourse-cdn.com/v4/letter/a/e36b37/32.png) [@Andrei\_Costescu](https://forum.servoy.com/u/Andrei_Costescu)\ **Post date:** [March 12, 2009, 11:21am UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/6 "2009-03-12T11:21:18Z")
We are looking into it. Hope to give you feedback soon. ---
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [March 12, 2009, 3:01pm UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/7 "2009-03-12T15:01:39Z")
> Andrei Costescu: > We are looking into it. Hope to give you feedback soon. Any further feedback on this issue Andrei ? Should I call it quits for today or are you close to a solution / workaround / suggestion ? ---
**Author:** ![Andrei\_Costescu](https://avatars.discourse-cdn.com/v4/letter/a/e36b37/32.png) [@Andrei\_Costescu](https://forum.servoy.com/u/Andrei_Costescu)\ **Post date:** [March 12, 2009, 3:27pm UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/8 "2009-03-12T15:27:53Z")
I don’t think I’ll have more info today. It must have something to do with “Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs” - but didn’t find the cause for that yet. ---
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [March 12, 2009, 3:47pm UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/9 "2009-03-12T15:47:29Z")
> Andrei Costescu: > I don’t think I’ll have more info today. It must have something to do with “Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs” - but didn’t find the cause for that yet. OK Thanks Andrei - I figured that would be responsible but since the only rows added are by the Servoy repository upgrade I was assuming it was a wrongly described error! Please keep me posted. ---
**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\ **Post date:** [March 12, 2009, 9:04pm UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/10 "2009-03-12T21:04:32Z")
Kahuna, Which version of Mysql are you running? Make sure you are using the jdbc driver that matches the db version. Note that as part of our internal test setup we test creation of repository tables in different databases daily, MySql5 being one of them. Rob ---
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [March 12, 2009, 10:07pm UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/11 "2009-03-12T22:07:59Z")
> rgansevles: > Kahuna, > > Which version of Mysql are you running? > Make sure you are using the jdbc driver that matches the db version. > > Note that as part of our internal test setup we test creation of repository tables in different databases daily, MySql5 being one of them. > > Rob Rob this is MySQL 5.1 and the correct connector. This is the same version and connector I was using on my dev environment earlier this week in my other office. I upgraded using the servoy updater jar with that environment - and it works fine. Seems like its only when its a new installation I get this problem. ---
**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\ **Post date:** [March 12, 2009, 11:03pm UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/12 "2009-03-12T23:03:22Z")
Kahuna, Try enabling tracing for the Server class, it should produce the create table statement in the log file (usually servoy\_log.txt) by adding this line in your servoy.properties file: ```auto log4j.logger.com.servoy.j2db.persistence.Server=TRACE ``` Steps: - stop developer - drop all servoy\_\* tables in your mysql repository - add the log4j line - start developer and get it to create the repository again. Rob ---
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [March 13, 2009, 8:13am UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/13 "2009-03-13T08:13:55Z")
Rob - here is the log info from that run (using your instructions): 2009-03-13 09:08:31,687 DEBUG [Thread-3] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:31,687 DEBUG [Thread-3] com.servoy.j2db.persistence.Server - server: repository\_server, url=jdbc:mysql://localhost/servoy\_repository 2009-03-13 09:08:32,343 DEBUG [Thread-3] com.servoy.j2db.persistence.Server - Loaded the get connection for server repository\_server in 1 times 2009-03-13 09:08:32,343 DEBUG [Thread-3] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=Thread-3 2009-03-13 09:08:32,375 DEBUG [Thread-3] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:32,375 DEBUG [Thread-3] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=Thread-3 2009-03-13 09:08:32,390 ERROR [Thread-3] com.servoy.j2db.util.Debug - Throwable com.servoy.j2db.persistence.RepositoryException: No repository found in the database. at com.servoy.j2db.persistence.Repository.testIfValid(Repository.java:39) at com.servoy.j2db.persistence.Repository.(Repository.java:178) at com.servoy.j2db.persistence.Repository.(Repository.java:1641) at com.servoy.j2db.persistence.Server.getRepository(Server.java:730) at com.servoy.j2db.server.ApplicationServer.initFromSerclipse(ApplicationServer.java:353) at com.servoy.eclipse.core.ServoyModel.startAppServer(ServoyModel.java:182) at com.servoy.eclipse.core.util.SplashHandler$1.run(SplashHandler.java:2) at java.lang.Thread.run(Unknown Source) 2009-03-13 09:08:32,421 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:32,421 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - Loaded the get connection for server repository\_server in 1 times 2009-03-13 09:08:32,421 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=TaskExecuter[0] 2009-03-13 09:08:32,421 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:32,421 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - Database name MySQL 2009-03-13 09:08:32,421 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=TaskExecuter[0] 2009-03-13 09:08:32,421 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:32,421 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - Loaded the get connection for server repository\_server in 1 times 2009-03-13 09:08:32,421 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=TaskExecuter[0] 2009-03-13 09:08:32,421 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:32,421 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - Database name MySQL 2009-03-13 09:08:32,437 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=TaskExecuter[0] 2009-03-13 09:08:32,437 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:32,437 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - Database name MySQL 2009-03-13 09:08:32,437 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=TaskExecuter[0] 2009-03-13 09:08:32,437 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:32,437 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - Database name MySQL 2009-03-13 09:08:32,437 DEBUG [TaskExecuter[0]] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=TaskExecuter[0] 2009-03-13 09:08:48,015 DEBUG [Worker-4] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:48,015 DEBUG [Worker-4] com.servoy.j2db.persistence.Server - Loaded the get connection for server repository\_server in 1 times 2009-03-13 09:08:48,015 DEBUG [Worker-4] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=Worker-4 2009-03-13 09:08:48,015 DEBUG [Worker-4] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:48,015 DEBUG [Worker-4] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=Worker-4 2009-03-13 09:08:51,718 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:51,718 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:51,718 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=main 2009-03-13 09:08:51,718 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:51,718 DEBUG [main] com.servoy.j2db.persistence.Server - Database name MySQL 2009-03-13 09:08:51,718 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=main 2009-03-13 09:08:52,062 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: getting unmanaged connection 2009-03-13 09:08:52,312 DEBUG [main] com.servoy.j2db.persistence.Server - create table servoy\_content\_spec (content\_id integer not null, object\_type\_id integer not null, property\_name varchar(50) not null, type\_id integer not null, display\_seq integer default null, default\_textual\_classvalue varchar(200) default null, is\_metadata integer default null, primary key (content\_id)) 2009-03-13 09:08:52,453 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:52,453 DEBUG [main] com.servoy.j2db.persistence.Server - Column name content\_id type 4 lenght 10 nullable false 2009-03-13 09:08:52,453 DEBUG [main] com.servoy.j2db.persistence.Server - Column name object\_type\_id type 4 lenght 10 nullable false 2009-03-13 09:08:52,453 DEBUG [main] com.servoy.j2db.persistence.Server - Column name property\_name type 12 lenght 50 nullable false 2009-03-13 09:08:52,453 DEBUG [main] com.servoy.j2db.persistence.Server - Column name type\_id type 4 lenght 10 nullable false 2009-03-13 09:08:52,453 DEBUG [main] com.servoy.j2db.persistence.Server - Column name display\_seq type 4 lenght 10 nullable true 2009-03-13 09:08:52,453 DEBUG [main] com.servoy.j2db.persistence.Server - Column name default\_textual\_classvalue type 12 lenght 200 nullable true 2009-03-13 09:08:52,453 DEBUG [main] com.servoy.j2db.persistence.Server - Column name is\_metadata type 4 lenght 10 nullable true 2009-03-13 09:08:52,468 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=main 2009-03-13 09:08:52,468 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:52,468 DEBUG [main] com.servoy.j2db.persistence.Server - Database name MySQL 2009-03-13 09:08:52,468 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_content\_spec tableType TABLE 2009-03-13 09:08:52,468 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=main 2009-03-13 09:08:52,468 DEBUG [main] com.servoy.j2db.persistence.Server - create table servoy\_element\_properties (element\_property\_id integer not null, element\_id integer not null, content\_id integer not null, property\_value varchar(4000) not null, revision integer not null, sequence integer not null, primary key (element\_property\_id)) 2009-03-13 09:08:52,562 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:52,562 DEBUG [main] com.servoy.j2db.persistence.Server - Column name element\_property\_id type 4 lenght 10 nullable false 2009-03-13 09:08:52,562 DEBUG [main] com.servoy.j2db.persistence.Server - Column name element\_id type 4 lenght 10 nullable false 2009-03-13 09:08:52,562 DEBUG [main] com.servoy.j2db.persistence.Server - Column name content\_id type 4 lenght 10 nullable false 2009-03-13 09:08:52,562 DEBUG [main] com.servoy.j2db.persistence.Server - Column name property\_value type 12 lenght 4000 nullable false 2009-03-13 09:08:52,562 DEBUG [main] com.servoy.j2db.persistence.Server - Column name revision type 4 lenght 10 nullable false 2009-03-13 09:08:52,562 DEBUG [main] com.servoy.j2db.persistence.Server - Column name sequence type 4 lenght 10 nullable false 2009-03-13 09:08:52,562 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=main 2009-03-13 09:08:52,562 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:52,562 DEBUG [main] com.servoy.j2db.persistence.Server - Database name MySQL 2009-03-13 09:08:52,562 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_content\_spec tableType TABLE 2009-03-13 09:08:52,562 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_element\_properties tableType TABLE 2009-03-13 09:08:52,562 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=main 2009-03-13 09:08:52,562 DEBUG [main] com.servoy.j2db.persistence.Server - create table servoy\_object\_types (object\_type\_id integer not null, next\_seq integer not null, seq\_cache\_size integer not null, client\_id\_lock varchar(50) default null, name varchar(100) default null, description varchar(200) default null, java\_class varchar(200) default null, primary key (object\_type\_id)) 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - Column name object\_type\_id type 4 lenght 10 nullable false 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - Column name next\_seq type 4 lenght 10 nullable false 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - Column name seq\_cache\_size type 4 lenght 10 nullable false 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - Column name client\_id\_lock type 12 lenght 50 nullable true 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - Column name name type 12 lenght 100 nullable true 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - Column name description type 12 lenght 200 nullable true 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - Column name java\_class type 12 lenght 200 nullable true 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=main 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - Database name MySQL 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_content\_spec tableType TABLE 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_element\_properties tableType TABLE 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_object\_types tableType TABLE 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=main 2009-03-13 09:08:52,656 DEBUG [main] com.servoy.j2db.persistence.Server - create table servoy\_releases (pk\_id integer not null, release\_number integer not null, root\_element\_id integer not null, element\_id integer not null, revision integer not null, creation\_date datetime default null, primary key (pk\_id)) 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - Column name pk\_id type 4 lenght 10 nullable false 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - Column name release\_number type 4 lenght 10 nullable false 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - Column name root\_element\_id type 4 lenght 10 nullable false 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - Column name element\_id type 4 lenght 10 nullable false 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - Column name revision type 4 lenght 10 nullable false 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - Column name creation\_date type 93 lenght 19 nullable true 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=main 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - Database name MySQL 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_content\_spec tableType TABLE 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_element\_properties tableType TABLE 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_object\_types tableType TABLE 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_releases tableType TABLE 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=main 2009-03-13 09:08:52,750 DEBUG [main] com.servoy.j2db.persistence.Server - create table servoy\_user\_properties (user\_property\_id integer not null, user\_id integer not null, name varchar(100) not null, property\_value varchar(4000) not null, primary key (user\_property\_id)) 2009-03-13 09:08:52,843 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - Column name user\_property\_id type 4 lenght 10 nullable false 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - Column name user\_id type 4 lenght 10 nullable false 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - Column name name type 12 lenght 100 nullable false 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - Column name property\_value type 12 lenght 4000 nullable false 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=main 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: getting managed connection 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - Database name MySQL 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_content\_spec tableType TABLE 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_element\_properties tableType TABLE 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_object\_types tableType TABLE 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_releases tableType TABLE 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - Table Name servoy\_user\_properties tableType TABLE 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=main 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - create table servoy\_columninfo (connection\_name varchar(50) not null, tablename varchar(50) not null, columnname varchar(50) not null, columninfo\_id integer not null, auto\_enter\_type integer not null, system\_value integer default null, pre\_sequence\_chars varchar(50) default null, post\_sequence\_chars varchar(50) default null, next\_seq bigint default null, sequence\_stepsize integer default null, client\_id\_lock varchar(50) default null, default\_value varchar(4000) default null, lookup\_value varchar(4000) default null, foreign\_type varchar(150) default null, validator\_name varchar(200) default null, validator\_properties varchar(4000) default null, converter\_name varchar(200) default null, converter\_properties varchar(4000) default null, title\_text varchar(200) default null, default\_format varchar(200) default null, description varchar(4000) default null, is\_row\_ident integer default null, db\_sequence\_name varchar(50) default null, element\_template\_properties varchar(4000) default null, primary key (columnname, connection\_name, tablename)) 2009-03-13 09:08:52,875 DEBUG [main] com.servoy.j2db.persistence.Server - repository\_server: Closed connection, thread=main Workspace Log !SESSION 2009-03-13 09:08:15.296 ----------------------------------------------- eclipse.buildId=M20071023-1652 java.version=1.6.0\_11 java.vendor=Sun Microsystems Inc. BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en\_GB Framework arguments: --launcher.XXMaxPermSize 256M Command-line arguments: -os win32 -ws win32 -arch x86 --launcher.XXMaxPermSize 256M !ENTRY com.servoy.eclipse.core 1 0 2009-03-13 09:08:40.125 !MESSAGE Cannot find any valid solution to activate. !ENTRY org.eclipse.ui.workbench 2 0 2009-03-13 09:08:42.437 !MESSAGE A handler conflict occurred. This may disable some commands. !SUBENTRY 1 org.eclipse.ui.workbench 2 0 2009-03-13 09:08:42.437 !MESSAGE Conflict for ‘AUTOGEN:::org.eclipse.ui.cheatsheets.actionSet/org.eclipse.ui.cheatsheets.actions.CheatSheetHelpMenuAction’: HandlerActivation(commandId=AUTOGEN:::org.eclipse.ui.cheatsheets.actionSet/org.eclipse.ui.cheatsheets.actions.CheatSheetHelpMenuAction, handler=ActionDelegateHandlerProxy(null,org.eclipse.ui.cheatsheets.CheatSheetExtensionFactory:helpMenuAction), expression=AndExpression(ActionSetExpression(org.eclipse.ui.cheatsheets.actionSet,org.eclipse.ui.internal.WorkbenchWindow@13ec758),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@13ec758)),sourcePriority=16640) HandlerActivation(commandId=AUTOGEN:::org.eclipse.ui.cheatsheets.actionSet/org.eclipse.ui.cheatsheets.actions.CheatSheetHelpMenuAction, handler=ActionDelegateHandlerProxy(null,org.eclipse.ui.cheatsheets.CheatSheetExtensionFactory:helpMenuAction), expression=AndExpression(ActionSetExpression(org.eclipse.ui.cheatsheets.actionSet,org.eclipse.ui.internal.WorkbenchWindow@13ec758),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@13ec758)),sourcePriority=16640) !ENTRY com.servoy.eclipse.core 4 0 2009-03-13 09:08:55.328 !MESSAGE Failed to create/upgrade repository. !STACK 0 com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs at com.servoy.j2db.persistence.RepositoryUpdater.createRepositoryTables(RepositoryUpdater.java:1307) at com.servoy.j2db.persistence.Server.createActualRepositoryTables(Server.java:530) at com.servoy.j2db.persistence.Server.createRepositoryTables(Server.java:622) at com.servoy.eclipse.team.ServoyTeamProvider$6.run(ServoyTeamProvider.java:4) at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:129) at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3659) at org.eclipse.swt.widgets.Display.msgFilterProc(Display.java:3041) at org.eclipse.swt.internal.win32.OS.TrackPopupMenu(Native Method) at org.eclipse.swt.widgets.Menu.\_setVisible(Menu.java:228) at org.eclipse.swt.widgets.Display.runPopups(Display.java:3708) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3287) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447) at org.eclipse.equinox.launcher.Main.run(Main.java:1173) Caused by: com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs at com.servoy.j2db.persistence.Server.syncTableObjWithDB(Server.java:411) at com.servoy.j2db.persistence.RepositoryUpdater.recreateServoyColumnInfo(RepositoryUpdater.java:268) at com.servoy.j2db.persistence.RepositoryUpdater.createRepositoryTables(RepositoryUpdater.java:1442) … 31 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.servoy.j2db.persistence.datasource.Ze.invoke(Ze.java:5) at $Proxy0.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183) at com.servoy.j2db.persistence.Server.syncTableObjWithDB(Server.java:1456) … 33 more ---
**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\ **Post date:** [March 13, 2009, 8:30am UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/14 "2009-03-13T08:30:34Z")
Well, this is the statement your database is choking on: ```auto create table servoy_columninfo ( connection_name varchar(50) not null, tablename varchar(50) not null, columnname varchar(50) not null, columninfo_id integer not null, auto_enter_type integer not null, system_value integer default null, pre_sequence_chars varchar(50) default null, post_sequence_chars varchar(50) default null, next_seq bigint default null, sequence_stepsize integer default null, client_id_lock varchar(50) default null, default_value varchar(4000) default null, lookup_value varchar(4000) default null, foreign_type varchar(150) default null, validator_name varchar(200) default null, validator_properties varchar(4000) default null, converter_name varchar(200) default null, converter_properties varchar(4000) default null, title_text varchar(200) default null, default_format varchar(200) default null, description varchar(4000) default null, is_row_ident integer default null, db_sequence_name varchar(50) default null, element_template_properties varchar(4000) default null, primary key (columnname, connection_name, tablename) ) ``` Why is it complaining? the total size is approx 25k, less than half the max size. Now you can try configuring your database to accept this create statement. Rob ---
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [March 13, 2009, 8:40am UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/15 "2009-03-13T08:40:12Z")
> rgansevles: > Well, this is the statement your database is choking on: > > ```auto > create table servoy_columninfo > > ``` ( connection\_name varchar(50) not null, tablename varchar(50) not null, columnname varchar(50) not null, columninfo\_id integer not null, auto\_enter\_type integer not null, system\_value integer default null, pre\_sequence\_chars varchar(50) default null, post\_sequence\_chars varchar(50) default null, next\_seq bigint default null, sequence\_stepsize integer default null, client\_id\_lock varchar(50) default null, default\_value varchar(4000) default null, lookup\_value varchar(4000) default null, foreign\_type varchar(150) default null, validator\_name varchar(200) default null, validator\_properties varchar(4000) default null, converter\_name varchar(200) default null, converter\_properties varchar(4000) default null, title\_text varchar(200) default null, default\_format varchar(200) default null, description varchar(4000) default null, is\_row\_ident integer default null, db\_sequence\_name varchar(50) default null, element\_template\_properties varchar(4000) default null, ``` primary key (columnname, connection_name, tablename) ``` ) > ```auto > > Why is it complaining? the total size is approx 25k, less than half the max size. > > Now you can try configuring your database to accept this create statement. > > Rob > > ``` So, Rob, what you’re saying is that a brand new installation of MySQL 5.1 wont allow Servoy to create a table of the required attributes / size? Is that Right??? Not sure what should I reconfigure here Rob.? Go into the currently created servoy repository structure create the table, and set the column attributes to the same as the code above? ---
**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\ **Post date:** [March 13, 2009, 9:21am UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/16 "2009-03-13T09:21:57Z")
Kahuna, What I mean, there is something special with your mysql setup. It complains that the row size is too large, but that does not seem to make sense if you add up the column sizes. Rob ---
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [March 13, 2009, 9:25am UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/17 "2009-03-13T09:25:48Z")
Rob - I agree this looks like less than 25k but MySQL is reporting it as over 65k - even using Navicat to generate the table - it gives a row too large error. Obviously something in that create that looks like 65k to MySQL - cant see anything in the ini file that I can modify to make it more acceptable either. (InnoDb as the default table type). Help appreciated Ian ---
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [March 13, 2009, 9:45am UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/18 "2009-03-13T09:45:01Z")
Follow up - I tried to create this table by hand and it still reports a row too big error. If I take out one of the 4000 varchars it’s allowed??? Can I increase the max row size acceptable in MySQL? ---
**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\ **Post date:** [March 13, 2009, 1:24pm UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/19 "2009-03-13T13:24:38Z")
Investigation showed that the issue was probably related to the encoding applied in the mysql db. Mysql reserves 3 bytes per character when encoding is set to utf8 and the max row size is 65k. One of the servoy repository tables uses 6 columns of 4000 characters. In next release this number is decreased to prevent this issue. Rob ---
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [March 13, 2009, 1:35pm UTC](https://forum.servoy.com/t/help-servoy-cant-connect-to-the-app-server/10404/20 "2009-03-13T13:35:38Z")
> rgansevles: > Investigation showed that the issue was probably related to the encoding applied in the mysql db. > Mysql reserves 3 bytes per character when encoding is set to utf8 and the max row size is 65k. > One of the servoy repository tables uses 6 columns of 4000 characters. > > In next release this number is decreased to prevent this issue. > > Rob Deleted