jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marco Di Sabatino Di Diodoro <marco.disabat...@tirasa.net>
Subject Slave Node read only
Date Thu, 20 Sep 2012 14:29:00 GMT
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





Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message