wojciech.kapcia@tigase.net opened 3 years ago
|
|||||||
wojciech.kapcia@tigase.net changed state to 'Open' 2 months ago
|
|||||||
The issue wasn't fixed as I made a type-o and used |
|||||||
wojciech.kapcia@tigase.net changed fields 2 months ago
|
|||||||
wojciech.kapcia@tigase.net added to iteration "tigase-server-8.5.0" 2 months ago
|
|||||||
wojciech.kapcia@tigase.net added to iteration "tigase-server-8.2.0" 2 months ago
|
|||||||
@wojtek actually the problem was in both the stored procedures, so the problem was partially fixed but not totally fixed, as you find out |
|||||||
wojciech.kapcia@tigase.net added "Related" #1539 2 months ago
|
|||||||
Yes, there is also #1539 that uses |
Type |
Task
|
Priority |
Normal
|
Assignee | |
Version |
tigase-server-8.2.0, tigase-server-8.5.0
|
Spent time |
30m
|
Iterations
-
tigase-server-8.5.0 Open
-
tigase-server-8.2.0 Closed
Related
-
Customers/catapush-s-r-l#23 You are not authorized to access this issue
Issue Votes (0)
In
Tig_OfflineMessages_DeleteMessage()
we have a callselect row_count() as deleted_rows;
(https://github.com/tigase/tigase-server/blob/05fa90bfa40ad4b253819b4be7b897fd76b7c8b2/src/main/database/mysql-issue #8.0.0-sp.sql#L185-L185)but in
tigase.server.amp.db.JDBCMsgRepository#deleteMessage
(https://github.com/tigase/tigase-server/blob/05fa90bfa40ad4b253819b4be7b897fd76b7c8b2/src/main/java/tigase/server/amp/db/JDBCMsgRepository.java#L483-L483) we don't use it?We should change the SP to:
to avoid performance penalty.