Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MAM Before/After returns error #365

Open
munkhbayar-gtk opened this issue Sep 28, 2023 · 0 comments
Open

MAM Before/After returns error #365

munkhbayar-gtk opened this issue Sep 28, 2023 · 0 comments

Comments

@munkhbayar-gtk
Copy link

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) [?:?]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant