[Akonadi] [Bug 342866] New: Unable to set seen flag on huge IMAP folders with many unread messages

[Hans-Peter Jansen]

https://bugs.kde.org/show_bug.cgi?id=342866

            Bug ID: 342866
           Summary: Unable to set seen flag on huge IMAP folders with many
                    unread messages
           Product: Akonadi
           Version: unspecified
          Platform: openSUSE RPMs
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: IMAP resource
          Assignee: chrigi_1 at fastmail.fm
          Reporter: hpj at urpla.net
                CC: kdepim-bugs at kde.org, vkrause at kde.org

Bugzilla doesn't know about the current akonadi version: 4.14.3 in my case
(openSUSE 13.2/x86_64)

When trying to set many unread messages to "SEEN", akonadi throws an error in
the terminal, I've manually started it (akonadictl start). IMAP server is a
Cyrus 2.3.11 (also an older openSUSE release):

DATABASE ERROR:
Error code: 1064
DB error:  "You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near ':0
AND PimItem_id IN ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :'
at line 1"
Error text: "You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near ':0
AND PimItem_id IN ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :'
at line 1 QMYSQL: Unable to execute query"
Query: "SELECT PimItem_id FROM PimItemFlagRelation WHERE ( ( Flag_id = :0 AND
PimItem_id IN ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14,
:15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30,
:31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46,
:47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62,
:63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78,
:79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94,
:95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108,
:109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121,
:122, 
[...]
 :130749, :130750, :130751, :130752, :130753, :130754, :130755, :130756,
:130757, :130758, :130759, :130760, :130761, :130762, :130763, :130764,
:130765, :130766, :130767, :130768, :130769, :130770, :130771, :130772,
:130773, :130774 ) ) )
"
Failed to execute query: QSqlError(1064, "QMYSQL: Unable to execute query",
"You have an error in your SQL syntax; check the manual that corresponds to
your MariaDB server version for the right syntax to use near ':0 AND PimItem_id
IN ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :' at line 1") 
Store::addFlags: Unable to add new item flags 

Yes, we're talking about 128k mails here. Smaller operations work fine, of
course.
It smells like some buffer overflow in sql command processing, but I tried to
raise the buffer limits in .local/share/akonadi/mysql.conf already with no
better result.

Any idea, what's going wrong here.

-- 
You are receiving this mail because:
You are on the CC list for the bug.