Project

General

Profile

does tigase support mysql proxy?

tiger zhang
Added about 5 years ago

why my tigase support it unsuccessfully


Replies (4)

Avatar?id=6023&size=32x32

Added by Artur Hefczyc TigaseTeam about 5 years ago

I think, this is because you do not speak English and we cannot understand you. We do not know what you are asking about.

Added by tiger zhang about 5 years ago

sorry,I wrote it simplely.There are two mysql database servers in my system,One is master ,and another one is slave ,when i insert some records in master ,The master will copy these records to slave one . I install a software named mysql-proxy ,it provide a virtual database url ,Other systems can insert and update records in maser one and retrive records in slave one via this virtual mysql url.but tigase can not, why?

Added by tiger zhang about 5 years ago

MsgRepository.storeMessage() WARNING: Problem adding new entry to DB:

com.mysql.jdbc.exceptions.MySQLTimeoutException: Statement cancelled due to timeout or client request

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2968)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2834)

    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)

    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2441)

    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2366)

    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2350)

    at tigase.server.amp.MsgRepository.storeMessage(MsgRepository.java:465)

    at tigase.xmpp.impl.OfflineMessages.savePacketForOffLineUser(OfflineMessages.java:265)

    at tigase.xmpp.impl.MessageAmp.postProcess(MessageAmp.java:200)

    at tigase.server.xmppsession.SessionManager.processPacket(SessionManager.java:1587)

    at tigase.server.xmppsession.SessionManager.processPacket(SessionManager.java:592)

    at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessageReceiver.java:1337)
Avatar?id=6023&size=32x32

Added by Artur Hefczyc TigaseTeam about 5 years ago

We have never tested Tigase with this kind of database proxy, therefore I do not know it Tigase works with this correctly.

    (1-4/4)