Projects tigase _server tigase-pubsub Issues #132
SQLSyntaxErrorException: PROCEDURE tigasedb.TigPubSubQueryItemPosition does not exist (#132)
wojciech.kapcia@tigase.net opened 2 years ago
[2022-06-24 07:26:12:343] [SEVERE  ] [           in_0-pubsub ] StanzaProcessor.processPacket()  : tigase.db.TigaseDBException: Cound not retrieve items when processing from=s2s@ip-172-31-20-109.us-west-2.compute.internal, to=pubsub@ip-172-31-20-109.us-west-2.compute.internal, serverAuthorisedStanzaFrom=Optional.empty, DATA=<iq xml:lang="en" xmlns="jabber:client" id="C5C6C99B-500B-409D-BB23-5DE241DDA16F" to="…@tigase.im" from="…@….de/Monal-iOS.…" type="get"><pubsub xmlns="http://jabber.org/protocol/pubsub"><items node="eu.siacs.conversations.axolotl.bundles:…"/><set xmlns="http://jabber.org/protocol/rsm"><after>…</after></set></pubsub></iq>, SIZE=375, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=get, STABLE_ID=null
java.lang.RuntimeException: tigase.db.TigaseDBException: Cound not retrieve items
	at tigase.pubsub.modules.RetrieveItemsModule.process(RetrieveItemsModule.java:148)
	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.pubsub.PubSubComponent.processPacket(PubSubComponent.java:191)
	at tigase.pubsub.cluster.PubSubComponentClustered.processPacket(SourceFile:183)
	at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessageReceiver.java:1398)
Caused by: tigase.db.TigaseDBException: Cound not retrieve items
	at tigase.pubsub.repository.PubSubDAOJDBC.getItems(PubSubDAOJDBC.java:531)
	at jdk.internal.reflect.GeneratedMethodAccessor67.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:75)
	at jdk.proxy2/jdk.proxy2.$Proxy51.getItems(Unknown Source)
	at tigase.pubsub.repository.PubSubDAOPool.getItems(PubSubDAOPool.java:206)
	at tigase.pubsub.repository.cached.CachedPubSubRepository.getNodeItems(CachedPubSubRepository.java:311)
	at tigase.pubsub.modules.RetrieveItemsModule.process(RetrieveItemsModule.java:117)
	... 7 more
Caused by: java.sql.SQLSyntaxErrorException: PROCEDURE tigasedb.TigPubSubQueryItemPosition does not exist
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1009)
	at com.mysql.cj.jdbc.CallableStatement.executeQuery(CallableStatement.java:891)
	at jdk.internal.reflect.GeneratedMethodAccessor8.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.pubsub.repository.PubSubDAOJDBC.getItems(PubSubDAOJDBC.java:460)
	... 15 more
wojciech.kapcia@tigase.net commented 2 years ago

Seems to be issue with wrong procedure name (TigPubSubMamQueryItemPosition / TigPubSubQueryItemPosition) in mysql-issue #5.1.0.sql

Andrzej Wójcik (Tigase) commented 2 years ago
issue 1 of 1
Type
Bug
Priority
Normal
Assignee
Version
tigase-server-8.3.0
Spent time
30m
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/tigase-pubsub#132
Please wait...
Page is in error, reload to recover