Projects tigase _server tigase-muc Issues #155
PSQLException: ERROR: invalid input syntax for type uuid: "1592046656589" (#155)
Duplicate
wojciech.kapcia@tigase.net opened 1 year ago
[2023-04-03 07:04:02:405] [SEVERE  ] [              in_5-muc ] StanzaProcessor.processPacket()  : Error retrieving messages from database when processing from=s2s@ip-172-31-41-211.us-west-2.compute.internal, to=null, serverAuthorisedStanzaFrom=Optional.empty, DATA=<iq id="89f1430c-dd9a-4f93-887e-5903eb92cfc5" xml:lang="en" type="set" xmlns="jabber:client" from="ł@jabber.de/gajim.ł" to="tigase@muc.tigase.org"><query queryid="859c5239-5541-4dd9-a1b4-fcbfbf205ffb" xmlns="urn:xmpp:mam:2"><x xmlns="jabber:x:data" type="submit"><field type="hidden" var="FORM_TYPE"><value>urn:xmpp:mam:2</value></field></x><set xmlns="http://jabber.org/protocol/rsm"><max>70</max><after>1592046656589</after></set></query></iq>, SIZE=453, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=REMOTE, TYPE=set, STABLE_ID=null
java.lang.RuntimeException: Error retrieving messages from database
	at tigase.xmpp.mam.modules.QueryModule.process(QueryModule.java:86)
	at tigase.muc.modules.MAMQueryModule.process(MAMQueryModule.java:65)
	at tigase.component.modules.StanzaProcessor.execute(StanzaProcessor.java:219)
	at tigase.component.modules.StanzaProcessor.process(StanzaProcessor.java:206)
	at tigase.component.modules.StanzaProcessor.processPacket(StanzaProcessor.java:103)
	at tigase.component.AbstractKernelBasedComponent.processPacket(AbstractKernelBasedComponent.java:81)
	at tigase.muc.MUCComponent.processPacket(MUCComponent.java:122)
	at tigase.muc.cluster.MUCComponentClustered.processPacket(SourceFile:87)
	at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessageReceiver.java:1398)
Caused by: tigase.db.TigaseDBException: Can't find position for message with id 1592046656589 in archive for room tigase@muc.tigase.org
	at tigase.muc.history.JDBCHistoryProvider.getItemPosition(JDBCHistoryProvider.java:473)
	at tigase.muc.history.JDBCHistoryProvider.queryItems(JDBCHistoryProvider.java:279)
	at jdk.internal.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at tigase.stats.StatisticsInvocationHandler.invoke(StatisticsInvocationHandler.java:91)
	at jdk.proxy2/jdk.proxy2.$Proxy53.queryItems(Unknown Source)
	at tigase.muc.history.HistoryProviderMDBean.queryItems(HistoryProviderMDBean.java:151)
	at tigase.xmpp.mam.modules.QueryModule.process(QueryModule.java:84)
	... 8 more
Caused by: org.postgresql.util.PSQLException: ERROR: invalid input syntax for type uuid: "1592046656589"
  Where: PL/pgSQL function tig_muc_mam_getmessageposition(character varying,timestamp with time zone,timestamp with time zone,character varying,character varying) line 1 at RETURN QUERY
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:167)
	at org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:83)
	at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:119)
	at jdk.internal.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at tigase.db.jdbc.PreparedStatementInvocationHandler.invoke(PreparedStatementInvocationHandler.java:38)
	at jdk.proxy2/jdk.proxy2.$Proxy35.executeQuery(Unknown Source)
	at tigase.muc.history.JDBCHistoryProvider.getItemPosition(JDBCHistoryProvider.java:459)
	... 16 more
Andrzej Wójcik (Tigase) commented 1 year ago

We need to update tigase.org deployment with new version of Tigase XMPP Server.

wojciech.kapcia@tigase.net commented 1 year ago

I updated tigase.org

wojciech.kapcia@tigase.net batch edited 4 months ago
Name Previous Value Current Value
Iterations
empty
tigase-server-8.4.0
wojciech.kapcia@tigase.net batch edited 4 months ago
Name Previous Value Current Value
Iterations
tigase-server-8.4.0
tigase-server-8.5.0
Version
tigase-server-8.4.0
tigase-server-8.5.0
issue 1 of 1
Type
Bug
Priority
Normal
Assignee
Version
tigase-server-8.5.0
Iterations
Issue Votes (0)
Watchers (2)
Reference
tigase/_server/tigase-muc#155
Please wait...
Page is in error, reload to recover