Projects tigase _server tigase-http-api Issues #114
TigaseDBException: Could not allocate slot (#114)
Closed
wojciech.kapcia@tigase.net opened 3 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
wojciech.kapcia@tigase.net commented 3 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 3 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 3 years ago

Those changes are not merged.

issue 1 of 1
Type
Bug
Priority
Normal
Assignee
Version
tigase-server-8.2.0
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/tigase-http-api#114
Please wait...
Page is in error, reload to recover