Project

General

Profile

No response from server when requesting archived messages

Sarah Tibell
Added almost 5 years ago

I've been able to enable message archiving and I can see the messages in the DB table. However, when I try to request the messages I get no response from the server. I attach my Tigase log file.

As you can see in the log I successfully send following stanza to the server:

<iq id="cccc" type="get">
   <list xmlns="urn:xmpp:archive">
      <set xmlns="http://jabber.org/protocol/rsm">
         <max>50</max>
      </set>
   </list>
</iq>

I've also tried with a <retrieve/> element with same result (i.e. no result).

I'm using Smack library and for enabling the auto message archiving I wrote a packetExtension like this:

public class EnableMessageArchiveExtension implements PacketExtension {

    @Override
    public String getElementName() {
        return "iq";
    }

    @Override
    public String getNamespace() {
        return "urn:xmpp:archive";
    }

    @Override
    public String toXML() {
        return new String(
                "<iq type='set' id='auto1'>" +
                    "<auto save='true' xmlns='urn:xmpp:archive'/>" +
                "</iq>"
        );
    }
}

My packetExtension for requesting message archive looks like this:

public class RequestMessageArchiveExtension implements PacketExtension {

    @Override
    public String getElementName() {
        return "iq";
    }

    @Override
    public String getNamespace() {
        return "urn:xmpp:archive";
    }

    @Override
    public String toXML() {
        return new String(
                "<iq id='cccc' type='get'>" +
                    "<list xmlns='urn:xmpp:archive'>" +
                        "<set xmlns='http://jabber.org/protocol/rsm'>" +
                            "<max>50</max>" +
                        "</set>" +
                    "</list>" +
                "</iq>"
        );
    }
}

What have I missed?

Thanks!


Replies (10)

Added by Sarah Tibell almost 5 years ago

Ok it looks like something was wrong with my packages/how they where handled. When I changed the code to:

final IQ iq = new IQ() {
    @Override
    public String getChildElementXML() {
        return "<list xmlns='urn:xmpp:archive'><set xmlns='http://jabber.org/protocol/rsm'><max>10</max></set></list>";
    }
};
iq.setType(IQ.Type.GET);
iq.setPacketID("request");
connection.sendPacket(iq);

I instead got the same error as a previous post on this forum:

2014-04-15 08:54:29.962 [in_0-message-archive]  AbstractMessageReceiver$QueueListener.run()  SEVERE: [in_0-message-archive] Exception during packet processing: from=sess-man@fe-dell3010-1.flexite.local, to=message-archive@fe-dell3010-1.flexite.local, DATA=<iq id="request" type="get" from="anna@fe-dell3010-1.flexite.local/Smack" xmlns="jabber:client"><list xmlns="urn:xmpp:archive"><set xmlns="http://jabber.org/protocol/rsm"><max>10</max></set></list></iq>, SIZE=202, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=AUTH, TYPE=get
java.lang.NullPointerException
    at tigase.archive.MessageArchiveDB.getCollectionsCount(MessageArchiveDB.java:670)
    at tigase.archive.MessageArchiveDB.getCollections(MessageArchiveDB.java:481)
    at tigase.archive.MessageArchiveComponent.listCollections(MessageArchiveComponent.java:264)
    at tigase.archive.MessageArchiveComponent.processActionPacket(MessageArchiveComponent.java:214)
    at tigase.archive.MessageArchiveComponent.processPacket(MessageArchiveComponent.java:107)
    at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessageReceiver.java:1475)

I have the latest files from your repository https://projects.tigase.org/projects/message-archiving/repository. Where can I find the new snapshot build/why do I get the same error when fixed? You mentioned a new snapshot here: https://projects.tigase.org/boards/19/topics/1730.

Thanks for your help!

Added by Sarah Tibell almost 5 years ago

Found a snapshot in http://build.xmpp-test.net/maven/tigase/tigase-message-archiving/1.0.1-SNAPSHOT/. Took the latest jar (tigase-message-archiving-1.0.1-20140415.045140-66.jar).

I keep getting same error as before:

2014-04-15 09:49:45.411 [pool-12-thread-8]  ClientConnectionManager.processSocketData()  FINEST: Processing socket data: from=null, to=null, DATA=<iq id="request" type="get"><list xmlns="urn:xmpp:archive"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=134, XMLNS=null, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=get from connection: c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53288
2014-04-15 09:49:45.411 [pool-12-thread-8]  ClientConnectionManager.processSocketData()  FINEST: XMLNS set for packet: from=null, to=null, DATA=<iq xmlns="jabber:client" id="request" type="get"><list xmlns="urn:xmpp:archive"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=156, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=get from connection: c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53288
2014-04-15 09:49:45.413 [in_14-message-router]  MessageRouter.processPacket()  FINEST:  Processing packet: from=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53288, to=sess-man@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" id="request" type="get"><list xmlns="urn:xmpp:archive"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=156, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=get
2014-04-15 09:49:45.413 [in_14-message-router]  MessageRouter.getLocalComponent()  FINEST: Called for : sess-man@fe-dell3010-1.flexite.local
2014-04-15 09:49:45.413 [in_14-message-router]  MessageRouter.processPacket()  FINEST:  1. Packet will be processed by: sess-man@fe-dell3010-1.flexite.local, from=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53288, to=sess-man@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" id="request" type="get"><list xmlns="urn:xmpp:archive"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=156, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=get
2014-04-15 09:49:45.414 [in_30-sess-man]   SessionManager.processPacket()     FINEST:   processing packet: from=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53288, to=sess-man@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" id="request" type="get"><list xmlns="urn:xmpp:archive"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=156, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=get, connection: user_jid=anna@fe-dell3010-1.flexite.local/Smack, packets=14, connectioId=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53288, domain=fe-dell3010-1.flexite.local, authState=AUTHORIZED, isAnon=false, isTmp=false
2014-04-15 09:49:45.414 [in_30-sess-man]   PacketDefaultHandler.preprocess()  FINEST:   Setting correct from attribute: anna@fe-dell3010-1.flexite.local/Smack
2014-04-15 09:49:45.415 [in_30-sess-man]   SessionManager.walk()              FINEST:   XMPPProcessorIfc: MessageArchivePlugin (message-archive-xep-0136)Request: from=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53288, to=sess-man@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" id="request" type="get" from="anna@fe-dell3010-1.flexite.local/Smack"><list xmlns="urn:xmpp:archive"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=202, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=get, conn: user_jid=anna@fe-dell3010-1.flexite.local/Smack, packets=15, connectioId=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53288, domain=fe-dell3010-1.flexite.local, authState=AUTHORIZED, isAnon=false, isTmp=false
2014-04-15 09:49:45.416 [in_30-sess-man]   SessionManager.processPacket()     FINEST:   Packet processed by: [message-archive-xep-0136]
2014-04-15 09:49:45.418 [in_2-message-router]  MessageRouter.processPacket()  FINEST:   Processing packet: from=sess-man@fe-dell3010-1.flexite.local, to=message-archive@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" id="request" type="get" from="anna@fe-dell3010-1.flexite.local/Smack"><list xmlns="urn:xmpp:archive"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=202, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=AUTH, TYPE=get
2014-04-15 09:49:45.418 [in_2-message-router]  MessageRouter.getLocalComponent()  FINEST: Called for : message-archive@fe-dell3010-1.flexite.local
2014-04-15 09:49:45.418 [in_2-message-router]  MessageRouter.processPacket()  FINEST:   1. Packet will be processed by: message-archive@fe-dell3010-1.flexite.local, from=sess-man@fe-dell3010-1.flexite.local, to=message-archive@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" id="request" type="get" from="anna@fe-dell3010-1.flexite.local/Smack"><list xmlns="urn:xmpp:archive"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=202, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=AUTH, TYPE=get
2014-04-15 09:49:45.446 [in_0-message-archive]  AbstractMessageReceiver$QueueListener.run()  SEVERE: [in_0-message-archive] Exception during packet processing: from=sess-man@fe-dell3010-1.flexite.local, to=message-archive@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" id="request" type="get" from="anna@fe-dell3010-1.flexite.local/Smack"><list xmlns="urn:xmpp:archive"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=202, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=AUTH, TYPE=get
java.lang.NullPointerException
    at tigase.archive.MessageArchiveDB.getCollectionsCount(MessageArchiveDB.java:670)
    at tigase.archive.MessageArchiveDB.getCollections(MessageArchiveDB.java:481)
    at tigase.archive.MessageArchiveComponent.listCollections(MessageArchiveComponent.java:264)
    at tigase.archive.MessageArchiveComponent.processActionPacket(MessageArchiveComponent.java:214)
    at tigase.archive.MessageArchiveComponent.processPacket(MessageArchiveComponent.java:107)
    at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessageReceiver.java:1475)

Error when including a 'start' attribute in the list element:

final IQ iq = new IQ() {
    @Override
    public String getChildElementXML() {
        return "<list xmlns='urn:xmpp:archive' start='2010-10-10T10:10:10.001+0000'><set xmlns='http://jabber.org/protocol/rsm'><max>50</max></set></list>";
    }
};
iq.setType(IQ.Type.GET);
iq.setPacketID("request");
connection.sendPacket(iq);

Tigase log:

2014-04-15 09:44:47.265 [pool-12-thread-11]  ClientConnectionManager.processSocketData()  FINEST: Processing socket data: from=null, to=null, DATA=<iq id="request" type="get"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=171, XMLNS=null, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=get from connection: c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190
2014-04-15 09:44:47.265 [pool-12-thread-11]  ClientConnectionManager.processSocketData()  FINEST: XMLNS set for packet: from=null, to=null, DATA=<iq xmlns="jabber:client" id="request" type="get"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=193, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=get from connection: c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190
2014-04-15 09:44:47.265 [in_4-message-router]  MessageRouter.processPacket()  FINEST:   Processing packet: from=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, to=sess-man@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" id="request" type="get"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=193, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=get
2014-04-15 09:44:47.266 [in_4-message-router]  MessageRouter.getLocalComponent()  FINEST: Called for : sess-man@fe-dell3010-1.flexite.local
2014-04-15 09:44:47.266 [in_4-message-router]  MessageRouter.processPacket()  FINEST:   1. Packet will be processed by: sess-man@fe-dell3010-1.flexite.local, from=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, to=sess-man@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" id="request" type="get"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=193, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=get
2014-04-15 09:44:47.266 [in_20-sess-man]   SessionManager.processPacket()     FINEST:   processing packet: from=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, to=sess-man@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" id="request" type="get"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=193, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=get, connection: user_jid=anna@fe-dell3010-1.flexite.local/Smack, packets=14, connectioId=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, domain=fe-dell3010-1.flexite.local, authState=AUTHORIZED, isAnon=false, isTmp=false
2014-04-15 09:44:47.267 [in_20-sess-man]   PacketDefaultHandler.preprocess()  FINEST:   Setting correct from attribute: anna@fe-dell3010-1.flexite.local/Smack
2014-04-15 09:44:47.269 [in_20-sess-man]   SessionManager.walk()              FINEST:   XMPPProcessorIfc: MessageArchivePlugin (message-archive-xep-0136)Request: from=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, to=sess-man@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" id="request" type="get" from="anna@fe-dell3010-1.flexite.local/Smack"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=239, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=get, conn: user_jid=anna@fe-dell3010-1.flexite.local/Smack, packets=15, connectioId=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, domain=fe-dell3010-1.flexite.local, authState=AUTHORIZED, isAnon=false, isTmp=false
2014-04-15 09:44:47.269 [in_20-sess-man]   SessionManager.processPacket()     FINEST:   Packet processed by: [message-archive-xep-0136]
2014-04-15 09:44:47.270 [in_2-message-router]  MessageRouter.processPacket()  FINEST:   Processing packet: from=sess-man@fe-dell3010-1.flexite.local, to=message-archive@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" id="request" type="get" from="anna@fe-dell3010-1.flexite.local/Smack"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=239, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=AUTH, TYPE=get
2014-04-15 09:44:47.270 [in_2-message-router]  MessageRouter.getLocalComponent()  FINEST: Called for : message-archive@fe-dell3010-1.flexite.local
2014-04-15 09:44:47.270 [in_2-message-router]  MessageRouter.processPacket()  FINEST:   1. Packet will be processed by: message-archive@fe-dell3010-1.flexite.local, from=sess-man@fe-dell3010-1.flexite.local, to=message-archive@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" id="request" type="get" from="anna@fe-dell3010-1.flexite.local/Smack"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list></iq>, SIZE=239, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=AUTH, TYPE=get
2014-04-15 09:44:47.274 [in_0-message-archive]  MessageArchiveComponent.listCollections()  SEVERE: Error listing collections
com.microsoft.sqlserver.jdbc.SQLServerException: 'date' is not a recognized built-in function name.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283)
    at tigase.archive.MessageArchiveDB.getCollectionsCount(MessageArchiveDB.java:681)
    at tigase.archive.MessageArchiveDB.getCollections(MessageArchiveDB.java:481)
    at tigase.archive.MessageArchiveComponent.listCollections(MessageArchiveComponent.java:264)
    at tigase.archive.MessageArchiveComponent.processActionPacket(MessageArchiveComponent.java:214)
    at tigase.archive.MessageArchiveComponent.processPacket(MessageArchiveComponent.java:107)
    at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessageReceiver.java:1475)
2014-04-15 09:44:47.276 [in_1-message-router]  MessageRouter.processPacket()  FINEST:   Processing packet: from=message-archive@fe-dell3010-1.flexite.local, to=sess-man@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" to="anna@fe-dell3010-1.flexite.local/Smack" id="request" type="error"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list><error code="500" type="wait"><internal-server-error xmlns="urn:ietf:params:xml:ns:xmpp-stanzas"/><text xmlns="urn:ietf:params:xml:ns:xmpp-stanzas" xml:lang="en">Database error occured</text></error></iq>, SIZE=438, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=error
2014-04-15 09:44:47.277 [in_1-message-router]  MessageRouter.getLocalComponent()  FINEST: Called for : anna@fe-dell3010-1.flexite.local/Smack
2014-04-15 09:44:47.277 [in_1-message-router]  MessageRouter.getLocalComponent()  FINEST: None compId matches (fast lookup): anna@fe-dell3010-1.flexite.local/Smack, for map: {basic-conf@fe-dell3010-1.flexite.local=tigase.conf.Configurator@3393bd72, vhost-man@fe-dell3010-1.flexite.local=tigase.cluster.VHostManagerClustered@287aa1d2, s2s@fe-dell3010-1.flexite.local=tigase.cluster.S2SConnectionClustered@5cdd6a50, amp@fe-dell3010-1.flexite.local=tigase.server.amp.AmpComponent@327fad42, bosh@fe-dell3010-1.flexite.local=tigase.cluster.BoshConnectionClustered@1c8560f3, stats@fe-dell3010-1.flexite.local=tigase.stats.StatisticsCollector@6857f67, cl-comp@fe-dell3010-1.flexite.local=tigase.cluster.ClusterConnectionManager@43bfcdbd, c2s@fe-dell3010-1.flexite.local=tigase.cluster.ClientConnectionClustered@3f90d589, sess-man@fe-dell3010-1.flexite.local=tigase.cluster.SessionManagerClustered@1679fda7, ws2s@fe-dell3010-1.flexite.local=tigase.cluster.WebSocketClientConnectionClustered@5d852771, cluster-contr@fe-dell3010-1.flexite.local=tigase.cluster.ClusterController@211b3c6a, message-archive@fe-dell3010-1.flexite.local=tigase.archive.MessageArchiveComponent@7b2dffdf, monitor@fe-dell3010-1.flexite.local=tigase.cluster.MonitorClustered@edeaa44}
2014-04-15 09:44:47.278 [in_1-message-router]  MessageRouter.getLocalComponent()  FINEST: Still no comp name matches (VHost lookup): anna@fe-dell3010-1.flexite.local/Smack, for map: {cl-comp=tigase.cluster.ClusterConnectionManager@43bfcdbd, c2s=tigase.cluster.ClientConnectionClustered@3f90d589, basic-conf=tigase.conf.Configurator@3393bd72, s2s=tigase.cluster.S2SConnectionClustered@5cdd6a50, cluster-contr=tigase.cluster.ClusterController@211b3c6a, bosh=tigase.cluster.BoshConnectionClustered@1c8560f3, vhost-man=tigase.cluster.VHostManagerClustered@287aa1d2, sess-man=tigase.cluster.SessionManagerClustered@1679fda7, ws2s=tigase.cluster.WebSocketClientConnectionClustered@5d852771, message-router=tigase.server.MessageRouter@b15f6c1, stats=tigase.stats.StatisticsCollector@6857f67, message-archive=tigase.archive.MessageArchiveComponent@7b2dffdf, amp=tigase.server.amp.AmpComponent@327fad42, monitor=tigase.cluster.MonitorClustered@edeaa44}, for all VHosts: {3}
2014-04-15 09:44:47.278 [in_1-message-router]  MessageRouter.getLocalComponent()  FINEST: Component match failed: anna@fe-dell3010-1.flexite.local/Smack, for comp: {cl-comp=tigase.cluster.ClusterConnectionManager@43bfcdbd, c2s=tigase.cluster.ClientConnectionClustered@3f90d589, basic-conf=tigase.conf.Configurator@3393bd72, s2s=tigase.cluster.S2SConnectionClustered@5cdd6a50, cluster-contr=tigase.cluster.ClusterController@211b3c6a, bosh=tigase.cluster.BoshConnectionClustered@1c8560f3, vhost-man=tigase.cluster.VHostManagerClustered@287aa1d2, sess-man=tigase.cluster.SessionManagerClustered@1679fda7, ws2s=tigase.cluster.WebSocketClientConnectionClustered@5d852771, message-router=tigase.server.MessageRouter@b15f6c1, stats=tigase.stats.StatisticsCollector@6857f67, message-archive=tigase.archive.MessageArchiveComponent@7b2dffdf, amp=tigase.server.amp.AmpComponent@327fad42, monitor=tigase.cluster.MonitorClustered@edeaa44}, basename: flexite.local
2014-04-15 09:44:47.278 [in_1-message-router]  MessageRouter.getLocalComponent()  FINEST: Called for : sess-man@fe-dell3010-1.flexite.local
2014-04-15 09:44:47.278 [in_1-message-router]  MessageRouter.processPacket()  FINEST:   1. Packet will be processed by: sess-man@fe-dell3010-1.flexite.local, from=message-archive@fe-dell3010-1.flexite.local, to=sess-man@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" to="anna@fe-dell3010-1.flexite.local/Smack" id="request" type="error"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list><error code="500" type="wait"><internal-server-error xmlns="urn:ietf:params:xml:ns:xmpp-stanzas"/><text xmlns="urn:ietf:params:xml:ns:xmpp-stanzas" xml:lang="en">Database error occured</text></error></iq>, SIZE=438, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=error
2014-04-15 09:44:47.278 [in_27-sess-man]   SessionManager.getXMPPResourceConnection()  FINEST: Searching for resource connection for: anna@fe-dell3010-1.flexite.local/Smack
2014-04-15 09:44:47.279 [in_27-sess-man]   SessionManager.getResourceConnection()  FINEST: Session not null, searching session for jid: anna@fe-dell3010-1.flexite.local/Smack
2014-04-15 09:44:47.279 [in_27-sess-man]   SessionManager.getResourceConnection()  FINEST: Found session: user_jid=anna@fe-dell3010-1.flexite.local/Smack, packets=15, connectioId=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, domain=fe-dell3010-1.flexite.local, authState=AUTHORIZED, isAnon=false, isTmp=false, for jid: anna@fe-dell3010-1.flexite.local/Smack
2014-04-15 09:44:47.280 [in_27-sess-man]   SessionManager.processPacket()     FINEST:   processing packet: from=message-archive@fe-dell3010-1.flexite.local, to=sess-man@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" to="anna@fe-dell3010-1.flexite.local/Smack" id="request" type="error"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list><error code="500" type="wait"><internal-server-error xmlns="urn:ietf:params:xml:ns:xmpp-stanzas"/><text xmlns="urn:ietf:params:xml:ns:xmpp-stanzas" xml:lang="en">CData size: 22</text></error></iq>, SIZE=438, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=error, connection: user_jid=anna@fe-dell3010-1.flexite.local/Smack, packets=15, connectioId=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, domain=fe-dell3010-1.flexite.local, authState=AUTHORIZED, isAnon=false, isTmp=false
2014-04-15 09:44:47.281 [in_27-sess-man]   SessionManager.walk()              FINEST:   XMPPProcessorIfc: MessageArchivePlugin (message-archive-xep-0136)Request: from=message-archive@fe-dell3010-1.flexite.local, to=sess-man@fe-dell3010-1.flexite.local, DATA=<iq xmlns="jabber:client" to="anna@fe-dell3010-1.flexite.local/Smack" id="request" type="error"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list><error code="500" type="wait"><internal-server-error xmlns="urn:ietf:params:xml:ns:xmpp-stanzas"/><text xmlns="urn:ietf:params:xml:ns:xmpp-stanzas" xml:lang="en">Database error occured</text></error></iq>, SIZE=438, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=error, conn: user_jid=anna@fe-dell3010-1.flexite.local/Smack, packets=16, connectioId=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, domain=fe-dell3010-1.flexite.local, authState=AUTHORIZED, isAnon=false, isTmp=false
2014-04-15 09:44:47.281 [in_27-sess-man]   SessionManager.processPacket()     FINEST:   Packet processed by: [message-archive-xep-0136]
2014-04-15 09:44:47.282 [in_4-message-router]  MessageRouter.processPacket()  FINEST:   Processing packet: from=sess-man@fe-dell3010-1.flexite.local, to=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, DATA=<iq xmlns="jabber:client" to="anna@fe-dell3010-1.flexite.local/Smack" id="request" type="error"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list><error code="500" type="wait"><internal-server-error xmlns="urn:ietf:params:xml:ns:xmpp-stanzas"/><text xmlns="urn:ietf:params:xml:ns:xmpp-stanzas" xml:lang="en">Database error occured</text></error></iq>, SIZE=438, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=AUTH, TYPE=error
2014-04-15 09:44:47.282 [in_4-message-router]  MessageRouter.getLocalComponent()  FINEST: Called for : anna@fe-dell3010-1.flexite.local/Smack
2014-04-15 09:44:47.282 [in_4-message-router]  MessageRouter.getLocalComponent()  FINEST: None compId matches (fast lookup): anna@fe-dell3010-1.flexite.local/Smack, for map: {basic-conf@fe-dell3010-1.flexite.local=tigase.conf.Configurator@3393bd72, vhost-man@fe-dell3010-1.flexite.local=tigase.cluster.VHostManagerClustered@287aa1d2, s2s@fe-dell3010-1.flexite.local=tigase.cluster.S2SConnectionClustered@5cdd6a50, amp@fe-dell3010-1.flexite.local=tigase.server.amp.AmpComponent@327fad42, bosh@fe-dell3010-1.flexite.local=tigase.cluster.BoshConnectionClustered@1c8560f3, stats@fe-dell3010-1.flexite.local=tigase.stats.StatisticsCollector@6857f67, cl-comp@fe-dell3010-1.flexite.local=tigase.cluster.ClusterConnectionManager@43bfcdbd, c2s@fe-dell3010-1.flexite.local=tigase.cluster.ClientConnectionClustered@3f90d589, sess-man@fe-dell3010-1.flexite.local=tigase.cluster.SessionManagerClustered@1679fda7, ws2s@fe-dell3010-1.flexite.local=tigase.cluster.WebSocketClientConnectionClustered@5d852771, cluster-contr@fe-dell3010-1.flexite.local=tigase.cluster.ClusterController@211b3c6a, message-archive@fe-dell3010-1.flexite.local=tigase.archive.MessageArchiveComponent@7b2dffdf, monitor@fe-dell3010-1.flexite.local=tigase.cluster.MonitorClustered@edeaa44}
2014-04-15 09:44:47.282 [in_4-message-router]  MessageRouter.getLocalComponent()  FINEST: Still no comp name matches (VHost lookup): anna@fe-dell3010-1.flexite.local/Smack, for map: {cl-comp=tigase.cluster.ClusterConnectionManager@43bfcdbd, c2s=tigase.cluster.ClientConnectionClustered@3f90d589, basic-conf=tigase.conf.Configurator@3393bd72, s2s=tigase.cluster.S2SConnectionClustered@5cdd6a50, cluster-contr=tigase.cluster.ClusterController@211b3c6a, bosh=tigase.cluster.BoshConnectionClustered@1c8560f3, vhost-man=tigase.cluster.VHostManagerClustered@287aa1d2, sess-man=tigase.cluster.SessionManagerClustered@1679fda7, ws2s=tigase.cluster.WebSocketClientConnectionClustered@5d852771, message-router=tigase.server.MessageRouter@b15f6c1, stats=tigase.stats.StatisticsCollector@6857f67, message-archive=tigase.archive.MessageArchiveComponent@7b2dffdf, amp=tigase.server.amp.AmpComponent@327fad42, monitor=tigase.cluster.MonitorClustered@edeaa44}, for all VHosts: {3}
2014-04-15 09:44:47.282 [in_4-message-router]  MessageRouter.getLocalComponent()  FINEST: Component match failed: anna@fe-dell3010-1.flexite.local/Smack, for comp: {cl-comp=tigase.cluster.ClusterConnectionManager@43bfcdbd, c2s=tigase.cluster.ClientConnectionClustered@3f90d589, basic-conf=tigase.conf.Configurator@3393bd72, s2s=tigase.cluster.S2SConnectionClustered@5cdd6a50, cluster-contr=tigase.cluster.ClusterController@211b3c6a, bosh=tigase.cluster.BoshConnectionClustered@1c8560f3, vhost-man=tigase.cluster.VHostManagerClustered@287aa1d2, sess-man=tigase.cluster.SessionManagerClustered@1679fda7, ws2s=tigase.cluster.WebSocketClientConnectionClustered@5d852771, message-router=tigase.server.MessageRouter@b15f6c1, stats=tigase.stats.StatisticsCollector@6857f67, message-archive=tigase.archive.MessageArchiveComponent@7b2dffdf, amp=tigase.server.amp.AmpComponent@327fad42, monitor=tigase.cluster.MonitorClustered@edeaa44}, basename: flexite.local
2014-04-15 09:44:47.283 [in_4-message-router]  MessageRouter.getLocalComponent()  FINEST: Called for : c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190
2014-04-15 09:44:47.283 [in_4-message-router]  MessageRouter.getLocalComponent()  FINEST: None compId matches (fast lookup): c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, for map: {basic-conf@fe-dell3010-1.flexite.local=tigase.conf.Configurator@3393bd72, vhost-man@fe-dell3010-1.flexite.local=tigase.cluster.VHostManagerClustered@287aa1d2, s2s@fe-dell3010-1.flexite.local=tigase.cluster.S2SConnectionClustered@5cdd6a50, amp@fe-dell3010-1.flexite.local=tigase.server.amp.AmpComponent@327fad42, bosh@fe-dell3010-1.flexite.local=tigase.cluster.BoshConnectionClustered@1c8560f3, stats@fe-dell3010-1.flexite.local=tigase.stats.StatisticsCollector@6857f67, cl-comp@fe-dell3010-1.flexite.local=tigase.cluster.ClusterConnectionManager@43bfcdbd, c2s@fe-dell3010-1.flexite.local=tigase.cluster.ClientConnectionClustered@3f90d589, sess-man@fe-dell3010-1.flexite.local=tigase.cluster.SessionManagerClustered@1679fda7, ws2s@fe-dell3010-1.flexite.local=tigase.cluster.WebSocketClientConnectionClustered@5d852771, cluster-contr@fe-dell3010-1.flexite.local=tigase.cluster.ClusterController@211b3c6a, message-archive@fe-dell3010-1.flexite.local=tigase.archive.MessageArchiveComponent@7b2dffdf, monitor@fe-dell3010-1.flexite.local=tigase.cluster.MonitorClustered@edeaa44}
2014-04-15 09:44:47.283 [in_4-message-router]  MessageRouter.processPacket()  FINEST:   1. Packet will be processed by: c2s@fe-dell3010-1.flexite.local, from=sess-man@fe-dell3010-1.flexite.local, to=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, DATA=<iq xmlns="jabber:client" to="anna@fe-dell3010-1.flexite.local/Smack" id="request" type="error"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list><error code="500" type="wait"><internal-server-error xmlns="urn:ietf:params:xml:ns:xmpp-stanzas"/><text xmlns="urn:ietf:params:xml:ns:xmpp-stanzas" xml:lang="en">Database error occured</text></error></iq>, SIZE=438, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=AUTH, TYPE=error
2014-04-15 09:44:47.283 [in_4-c2s]         ClientConnectionManager.processPacket()  FINEST: Processing packet: from=sess-man@fe-dell3010-1.flexite.local, to=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, DATA=<iq xmlns="jabber:client" to="anna@fe-dell3010-1.flexite.local/Smack" id="request" type="error"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list><error code="500" type="wait"><internal-server-error xmlns="urn:ietf:params:xml:ns:xmpp-stanzas"/><text xmlns="urn:ietf:params:xml:ns:xmpp-stanzas" xml:lang="en">CData size: 22</text></error></iq>, SIZE=438, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=AUTH, TYPE=error
2014-04-15 09:44:47.283 [in_4-c2s]         ConnectionManager.writePacketToSocket()  FINEST: c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, type: accept, Socket: TLS: c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190 Socket[addr=/192.168.0.55,port=53190,localport=5222], jid: anna@fe-dell3010-1.flexite.local/Smack, Writing packet: from=sess-man@fe-dell3010-1.flexite.local, to=c2s@fe-dell3010-1.flexite.local/192.168.0.55_5222_192.168.0.55_53190, DATA=<iq xmlns="jabber:client" to="anna@fe-dell3010-1.flexite.local/Smack" id="request" type="error"><list xmlns="urn:xmpp:archive" start="2010-10-10T10:10:10.001+0000"><set xmlns="http://jabber.org/protocol/rsm"><max>50</max></set></list><error code="500" type="wait"><internal-server-error xmlns="urn:ietf:params:xml:ns:xmpp-stanzas"/><text xmlns="urn:ietf:params:xml:ns:xmpp-stanzas" xml:lang="en">Database error occured</text></error></iq>, SIZE=438, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=AUTH, TYPE=error

Added by Andrzej Wójcik IoT 1 CloudTigaseTeam almost 5 years ago

It looks that there is an issue with generic query used to count messages on MSSQL server. I will look into this issue as it looks that. I created an issue for this in redmine see https://projects.tigase.org/issues/1922.

Added by Sarah Tibell almost 5 years ago

Thanks a lot, I'm eager to see the results and continue to implement my client using message archiving!

Added by Sarah Tibell over 4 years ago

Is it possible to estimate when this can be fixed? It doesn't seems to be a major issue, but if it's not possible for you to get it fixed soon I will have to try for myself or find another solution.

I know you must be busy, I really appriciate your support!

Avatar?id=6023&size=32x32

Added by Artur Hefczyc TigaseTeam over 4 years ago

Hi Sarah, It looks like the issue has been just fixed: #1922, could you please check this out and let us know if it works now?

Added by Android IT about 3 years ago

Hello, how are you. I would like to ask how to monitor/Listener the service return information(archive).

now ,I can send request IQ,but I do not know how to Listener Receiving infor ???

Please help me,3Q,3Q

Added by Wojciech Kapcia TigaseTeam about 3 years ago

This depends on the client that you use. Tigase XMPP Server returns stanza with responses normally to the client.

Added by Android IT about 3 years ago

First of all, thank you very much for your reply, thank you, thank you!!

Now,my client is Android .use jar is smack.jar(hird-part) ,And i download jaxmpp-xep0136.jar(url-->https://projects.tigase.org/projects/jaxmpp2/files) But i do not can use it(jaxmpp-xep0136.jar);

And now i use connection.addPacketListener(new PacketListener(),new PacketFilter()),this can Listener the change,but efficiency is too low,and is too unreasonable.

I hope you can give me some help.Such as listening Methods.(thank you !Looking forward to your reply。。。)

Added by Wojciech Kapcia TigaseTeam about 3 years ago

Android IT wrote:

First of all, thank you very much for your reply, thank you, thank you!!

Now,my client is Android .use jar is smack.jar(hird-part) ,And i download jaxmpp-xep0136.jar(url-->https://projects.tigase.org/projects/jaxmpp2/files) But i do not can use it(jaxmpp-xep0136.jar);

And now i use connection.addPacketListener(new PacketListener(),new PacketFilter()),this can Listener the change,but efficiency is too low,and is too unreasonable.

You cannot utilize jaxmpp-xep0136 with smack library - those are two different implementations. Your best options would be to either use smack implementation of xep0136 or user jaxmpp library altogether.

    (1-10/10)