TigaseDBException: Could not allocate slot (#114)

Wojciech Kapcia (Tigase) opened 4 years ago

[2021-07-03 18:58:31:765] [SEVERE  ] [           in_0-upload ] StanzaProcessor.processPacket()  : tigase.db.TigaseDBException: Could not allocate slot when processing from=sess-man@ip-172-31-0-99.us-west-2.compute.internal, to=null, DATA=<iq to="upload.tigase.im" from="…" id="F643BBC0-843F-4B1A-9062-FB00836D316D" xmlns="jabber:client" type="get"><request filename="F5551414-FEA7-46DE-A3A4-CA4A97A74E64.jpg" xmlns="urn:xmpp:http:upload:0" size="419901" content-type="image/jpeg"/></iq>, SIZE=284, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=AUTH, TYPE=get, STABLE_ID=null
java.lang.RuntimeException: tigase.db.TigaseDBException: Could not allocate slot
	at tigase.http.upload.logic.DefaultLogic.requestSlot(DefaultLogic.java:124)
	at tigase.http.upload.SlotRequestModule.process(SlotRequestModule.java:86)
	at tigase.component.modules.StanzaProcessor.execute(StanzaProcessor.java:214)
	at tigase.component.modules.StanzaProcessor.process(StanzaProcessor.java:201)
	at tigase.component.modules.StanzaProcessor.processPacket(StanzaProcessor.java:103)
	at tigase.component.AbstractKernelBasedComponent.processPacket(AbstractKernelBasedComponent.java:81)
	at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessageReceiver.java:1404)
Caused by: tigase.db.TigaseDBException: Could not allocate slot
	at tigase.http.upload.db.JDBCFileUploadRepository.allocateSlot(JDBCFileUploadRepository.java:115)
	at tigase.http.upload.db.FileUploadRepositoryPool.allocateSlot(FileUploadRepositoryPool.java:44)
	at tigase.http.upload.logic.DefaultLogic.requestSlot(DefaultLogic.java:121)
	... 6 more
Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\xA4\x98' for column '_res' at row 1
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:955)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1005)
	at com.mysql.cj.jdbc.CallableStatement.executeQuery(CallableStatement.java:886)
	at jdk.internal.reflect.GeneratedMethodAccessor21.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 com.sun.proxy.$Proxy40.executeQuery(Unknown Source)
	at tigase.http.upload.db.JDBCFileUploadRepository.allocateSlot(JDBCFileUploadRepository.java:105)
	... 8 more

Activities

Wojciech Kapcia (Tigase) commented 4 years ago

Payload:

[2021-07-03 18:58:31:765] [SEVERE  ] [           in_0-upload ] StanzaProcessor.processPacket()  : tigase.db.TigaseDBException: Could not allocate slot when processing from=sess-man@ip-172-31-0-99.us-west-2.compute.internal, to=null, DATA=<iq to="upload.tigase.im" from="marita@tigase.im/iPhone von Marita \uD83E\uDD18" id="F643BBC0-843F-4B1A-9062-FB00836D316D" xmlns="jabber:client" type="get"><request filename="F5551414-FEA7-46DE-A3A4-CA4A97A74E64.jpg" xmlns="urn:xmpp:http:upload:0" size="419901" content-type="image/jpeg"/></iq>, SIZE=284, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=AUTH, TYPE=get, STABLE_ID=null

Andrzej Wójcik (Tigase) commented 4 years ago

I've removed the code responsible for storing the resource part of the JID as it was not used anywhere.

For now, it will store an empty string as a resource and this field will be removed in the next major version of HTTP API (removal of old API methods is scheduled and old method is marked as deprecated).
Andrzej Wójcik (Tigase) commented 4 years ago

Those changes are not merged.
Login to comment

Type	Bug
Priority	Normal
Assignee	Wojciech Kapcia (Tigase)
Version	tigase-server-8.2.0

Issue Votes (0)

Watchers (0)

Reference

tigase/_server/tigase-http-api#114