Hi all,
I have a Mysql replication with a master(read / write) and two slave(read only).
When start the application server I have the following error:
java.sql.SQLException: The MySQL server is running with the --read-only option
so it cannot execute this statement
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
~[mysql-connector-java-5.1.18.jar:na]
...
at
com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
~[mysql-connector-java-5.1.18.jar:na]
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
~[na:na]
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
~[na:na]
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
~[na:na]
at
org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:474)
[jackrabbit-core-2.2.12-h1.jar:2.2.12-h1]
at
org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:303)
[jackrabbit-core-2.2.12-h1.jar:2.2.12-h1]
at
org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:285)
~[jackrabbit-core-2.2.12-h1.jar:2.2.12-h1]
at
org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:281)
~[jackrabbit-core-2.2.12-h1.jar:2.2.12-h1]
at
org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:494)
~[jackrabbit-core-2.2.12-h1.jar:2.2.12-h1]
at
org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:281)
[jackrabbit-core-2.2.12-h1.jar:2.2.12-h1]
at
org.apache.jackrabbit.core.fs.db.DatabaseFileSystem$2.close(DatabaseFileSystem.java:732)
[jackrabbit-core-2.2.12-h1.jar:2.2.12-h1]
at sun.nio.cs.StreamEncoder.implClose(StreamEncoder.java:301)
[na:1.6.0_34]
at sun.nio.cs.StreamEncoder.close(StreamEncoder.java:130) [na:1.6.0_34]
at java.io.OutputStreamWriter.close(OutputStreamWriter.java:216)
[na:1.6.0_34]
at java.io.BufferedWriter.close(BufferedWriter.java:248) [na:1.6.0_34]
at org.apache.commons.io.IOUtils.closeQuietly(IOUtils.java:303)
[commons-io-2.4.jar:2.4]
at org.apache.commons.io.IOUtils.closeQuietly(IOUtils.java:219)
[commons-io-2.4.jar:2.4]
at
org.apache.jackrabbit.core.lock.LockManagerImpl.save(LockManagerImpl.java:356)
[jackrabbit-core-2.2.12-h1.jar:2.2.12-h1]
at
org.apache.jackrabbit.core.lock.LockManagerImpl.externalUnlock(LockManagerImpl.java:1390)
[jackrabbit-core-2.2.12-h1.jar:2.2.12-h1]
...
...
How can I avoid writing on the two slave? From repository.xml?
Regards
M
--
Dott. Marco Di Sabatino Di Diodoro
Tel. +39 3939065570
Tirasa S.r.l.
Viale D'Annunzio 267 - 65127 Pescara
Tel +39 0859116307 / FAX +39 0859111173
http://www.tirasa.net
Apache Syncope PPMC Member
http://people.apache.org/~mdisabatino
