Unable to start Servoy Server on OSX Mavericks

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

Unable to start Servoy Server on OSX Mavericks

Postby prasadbabu.mfs » Tue Dec 24, 2013 1:08 am

Hello all,

I was unable to start Servoy Server on OSX Mavericks.
Installed Servoy 6.1.6 Application server and upgraded the repository. Also installed servoy server as a daemon.
Finally after starting the server through terminal using command " sudo /Applications/Servoy_Application_Server_6_1_6/application_server/service/ServoyServer start ", it throws the following error in log file

2013-12-23 21:56:47,635 ERROR [main] com.servoy.j2db.util.Debug - Error upgrading repository [ ]
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:232)
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:136)
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:1021)
at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:440)
Caused by: java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:824)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:667)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.servoy.j2db.datasource.Zg.invoke(Zg.java:14)
at com.sun.proxy.$Proxy0.execute(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:91)
... 3 more
2013-12-23 21:57:59,975 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-23 21:58:09,775 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-23 21:58:19,168 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-23 21:58:28,492 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-23 21:58:37,899 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-23 22:00:22,469 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-23 22:00:31,850 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-23 22:00:41,307 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-23 22:00:50,655 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-23 22:01:00,171 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-23 22:02:18,688 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-23 22:02:28,519 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-23 22:02:37,845 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-23 22:02:47,198 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-23 22:02:56,517 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]

My SQl Server Version 5.6.15

Please suggest some solution to resolve this error and start the server.

Thanks,
pb.
Prasad Babu
Servoy Developer
prasadbabu.mfs
 
Posts: 13
Joined: Mon Feb 13, 2012 4:53 pm

Re: Unable to start Servoy Server on OSX Mavericks

Postby ROCLASI » Tue Dec 24, 2013 2:01 am

Hi,

After looking around (i.e. using The Google ;) ) I found that this is due to a MySQL bug (MySQL Bug #40360)
I am pretty sure that Servoy uses the 'READ COMMITTED' transaction isolation level with MySQL, which currently only supports row-based binary logging. To fix this problem, you must configure MySQL's binary logging format to use 'row-based' binary logging.

1. Shutdown Servoy and MySQL.
2. Open the MySQL configuration file (my.cnf) in a text editor.
3. Locate the binlog_format property in this file in the [mysqld] section and ensure that its value is row, such that you end up with:
Code: Select all
binlog_format=row

4. Save your changes to this file.
5. Start MySQL and run the repository upgrade script again (servoy_server.sh -upgradeRepository).
6. Start Server server

Hope this helps.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Unable to start Servoy Server on OSX Mavericks

Postby prasadbabu.mfs » Tue Dec 24, 2013 11:30 am

Thanks ROCLASI for your prompt response.. :)
Prasad Babu
Servoy Developer
prasadbabu.mfs
 
Posts: 13
Joined: Mon Feb 13, 2012 4:53 pm

Re: Unable to start Servoy Server on OSX Mavericks

Postby ROCLASI » Wed Dec 25, 2013 2:25 am

Glad to help.
And please reply here if it worked or not so others can use this example.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium


Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 5 guests