Project

General

Profile

Maximum offline message length ?

Alex Kobzar
Added 4 months ago

Hello! What is the maximum length for offline messages and how i can change it?
For example i want send to user some data in base64 format in offline. The length of data 10-15k symbols.

So, i have Tigase server error in this moment%

2017-07-17 08:42:17.248 [in_99-sess-man]   JDBCMsgRepository.storeMessage()   WARNING:  Problem adding new entry to DB:
org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4096)
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:622)
        at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:472)
        at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:429)
        at tigase.server.amp.JDBCMsgRepository.storeMessage(JDBCMsgRepository.java:813)
        at tigase.xmpp.impl.OfflineMessages.savePacketForOffLineUser(OfflineMessages.java:432)
        at tigase.xmpp.impl.MessageAmp.postProcess(MessageAmp.java:199)
        at tigase.server.xmppsession.SessionManager.processPacket(SessionManager.java:1889)
        at tigase.server.xmppsession.SessionManager.processPacket(SessionManager.java:481)
        at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessageReceiver.java:1570)
2017-07-17 08:42:17.249 [in_99-sess-man]   SessionManager.processPacket()     FINEST:   Packet processed by: [message-carbons, amp, message-archive-xep-0136, msgoffline]

==> logs/tigase-console.log <==
2017-07-17 08:42:17.248 [in_99-sess-man]   JDBCMsgRepository.storeMessage()   WARNING:  Problem adding new entry to DB:
org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4096)
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:622)
        at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:472)
        at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:429)
        at tigase.server.amp.JDBCMsgRepository.storeMessage(JDBCMsgRepository.java:813)
        at tigase.xmpp.impl.OfflineMessages.savePacketForOffLineUser(OfflineMessages.java:432)
        at tigase.xmpp.impl.MessageAmp.postProcess(MessageAmp.java:199)
        at tigase.server.xmppsession.SessionManager.processPacket(SessionManager.java:1889)
        at tigase.server.xmppsession.SessionManager.processPacket(SessionManager.java:481)
        at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessageReceiver.java:1570)

==> logs/tigase.log.0 <==

Maybe i need change field type to TEXT? Or use something another method for it?


Replies (1)

Added by Andrzej Wójcik 4 months ago

This is known issue which will be fixed in Tigase XMPP Server 7.2.0. It is already fixed in SNAPSHOT builds by altering field type to TEXT from VARCHAR as you suggested.

    (1-1/1)