You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by Marco Di Sabatino Di Diodoro <ma...@tirasa.net> on 2012/09/20 16:29:00 UTC

Slave Node read only

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