Incorrect syntax near 'limit'. (#15)

Activities

wojciech.kapcia@tigase.net opened 10 years ago

2015-02-25 13:46:24.131 [in_0-message-archive]  MessageArchiveComponent.getMessages()  SEVERE: Error retrieving messages
tigase.db.TigaseDBException: Cound not retrieve items
        at tigase.archive.db.JDBCMessageArchiveRepository.getItems(JDBCMessageArchiveRepository.java:564)
        at tigase.archive.MessageArchiveComponent.getMessages(MessageArchiveComponent.java:425)
        at tigase.archive.MessageArchiveComponent.processActionPacket(MessageArchiveComponent.java:270)
        at tigase.archive.MessageArchiveComponent.processPacket(MessageArchiveComponent.java:111)
        at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessageReceiver.java:1424)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'limit'.
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
        at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
        at tigase.archive.db.JDBCMessageArchiveRepository.getItems(JDBCMessageArchiveRepository.java:714)
        at tigase.archive.db.JDBCMessageArchiveRepository.getItems(JDBCMessageArchiveRepository.java:553)
        at tigase.archive.MessageArchiveComponent.getMessages(MessageArchiveComponent.java:425)
        at tigase.archive.MessageArchiveComponent.processActionPacket(MessageArchiveComponent.java:270)
        at tigase.archive.MessageArchiveComponent.processPacket(MessageArchiveComponent.java:111)
        at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessageReceiver.java:1424)

Andrzej Wójcik (Tigase) commented 10 years ago

Need more details about build of Message Archiving component as this stacktrace do not match latest source code (number of lines with method invocations from stacktrace are pointing to different places is source code than it should).

I suppose this is older version of Message Archiving and JDBC storage support was changes since then so this might be fixed already. I would suggest to update installation to newest version if possible.

wojciech.kapcia@tigase.net commented 10 years ago

Thank you, it looks like the mentioned installation wasn't correctly deployed/updated as there is a version mismatch between server and MA.

componentInfo{Title=Tigase XMPP Server, Version=7.0.0-SNAPSHOT-b3799/45c26c0f (2015-02-19/01:13:39), Class=tigase.server.XMPPServer}
Loading component: message-archive :: componentInfo{Title=Tigase Message Archiving Component, Version=1.1.0-SNAPSHOT-b53/20e4c2c0, Class=tigase.archive.MessageArchiveComponent}

Type	Bug
Priority	Normal
Assignee	Artur Hefczyc
RedmineID	2794

Issue Votes (0)

Watchers (0)

Reference

tigase/_server/tigase-message-archiving#15