igniterealtime/openfire-monitoring-plugin

MAM Before/After returns error

Opened this issue · 0 comments

When a query with before or after clause, the server returns ERROR response.
the code runs a SQL query with like condition pstmt.setString( 4, "%urn:xmpp:sid:%" );
but messages are stored without this xmlns.

023.09.28 01:48:17 �[36mDEBUG�[m [message-archive-handler-84]: org.jivesoftware.openfire.archive.ConversationManager - Looking for ID of the message with stable/unique stanza ID 5EF5C3F5-5C89-465E-8731-EABDB79D64C8
2023.09.28 01:48:17 �[36mDEBUG�[m [message-archive-handler-84]: org.jivesoftware.openfire.archive.ConversationManager - Unable to find ID of the message with stable/unique stanza ID 5EF5C3F5-5C89-465E-8731-EABDB79D64C8
2023.09.28 01:48:17 �[36mDEBUG�[m [message-archive-handler-84]: org.jivesoftware.openfire.archive.ConversationManager - Fallback mechanism: parse value as old database identifier: '5EF5C3F5-5C89-465E-8731-EABDB79D64C8'
2023.09.28 01:48:17 �[36mDEBUG�[m [message-archive-handler-84]: org.jivesoftware.openfire.archive.ConversationManager - Fallback failed: value cannot be parsed as the old database identifier.
2023.09.28 01:48:17 �[1;31mERROR�[m [message-archive-handler-84]: com.reucon.openfire.plugin.archive.xep0313.IQQueryHandler - An exception has occurred while retrieving messages:
java.lang.IllegalArgumentException: Unable to parse value '5EF5C3F5-5C89-465E-8731-EABDB79D64C8' as a database identifier.
at org.jivesoftware.openfire.archive.ConversationManager.getMessageIdForStableId(ConversationManager.java:1108) ~[?:?]
at com.reucon.openfire.plugin.archive.impl.JdbcPersistenceManager.findMessages(JdbcPersistenceManager.java:300) ~[?:?]
at com.reucon.openfire.plugin.archive.xep0313.IQQueryHandler.retrieveMessages(IQQueryHandler.java:464) ~[?:?]
at com.reucon.openfire.plugin.archive.xep0313.IQQueryHandler.lambda$handleIQ$2(IQQueryHandler.java:287) ~[?:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]
at java.lang.Thread.run(Thread.java:833) [?:?]