[Akonadi] [Bug 487497] New: remoteId isn't large enough to store long remote calendars URLs

[Matthieu L.]

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

            Bug ID: 487497
           Summary: remoteId isn't large enough to store long remote
                    calendars URLs
    Classification: Frameworks and Libraries
           Product: Akonadi
           Version: 6.0.2
          Platform: Other
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: DAV Resource
          Assignee: kdepim-bugs at kde.org
          Reporter: matthieu.laurent69 at proton.me
                CC: carl at carlschwan.eu
  Target Milestone: ---

SUMMARY
When trying to add a ical resource with a long remote url, it will fail with
the error 
org.kde.pim.akonadiserver:   DB error:  "Data too long for column 'remoteId' at
row 1"

This happens because the CollectionTable's remoteId field is a varbinary(255),
and in my case the url is 328 characters long.

STEPS TO REPRODUCE
1. From a akonadi client (Merkuro Calendar in my case), create a new "ical
calendar file" calendar resource, setting it's url to something really long
(for example
"https://example.com/mycal.ical?eHMwUHXeaNzcAyEgAHCmYuiQGNOoHUOLvrVJTqcyqIKKZqgROoPtdhBJJkqzxOvfljNfprzmrbdhdNThGVhKwUOXNArqrTmQYEZwaFxmfKWhzayWiuzDHVHNsokPVoNxvVlpqiExFShIZfqbJHmOmBQbSGUuiyIEAcCNeGGsyaZnFhRxSwvHnyCXHdKKcMNfugzwGnFSncEXKGTBDyMOUbqMkKzlsodXswfQgczcTFLzulwEVmpfNhZfMuLriYsLOztSpUNsfELRFOgSFvqYRERJHgiMWijPTAnqjYeIDONQ")
2. Observe the akondani server output

OBSERVED RESULT
The calendar isn't added, failing with the following errors:
>org.kde.pim.akonadiserver: DATABASE ERROR:
>org.kde.pim.akonadiserver:   Error code: "1406"
>org.kde.pim.akonadiserver:   DB error:  "Data too long for column 'remoteId' at row 1"
>org.kde.pim.akonadiserver:   Error text: "Data too long for column 'remoteId' at row 1 QMYSQL: Unable to execute statement"
>org.kde.pim.akonadiserver:   Values: QList(QVariant(QString, "https://example.com/mycal.ical?eHMwUHXeaNzcAyEgAHCmYuiQGNOoHUOLvrVJTqcyqIKKZqgROoPtdhBJJkqzxOvfljNfprzmrbdhdNThGVhKwUOXNArqrTmQYEZwaFxmfKWhzayWiuzDHVHNsokPVoNxvVlpqiExFShIZfqbJHmOmBQbSGUuiyIEAcCNeGGsyaZnFhRxSwvHnyCXHdKKcMNfugzwGnFSncEXKGTBDyMOUbqMkKzlsodXswfQgczcTFLzulwEVmpfNhZfMuLriYsLOztSpUNsfELRFOgSFvqYRERJHgiMWijPTAnqjYeIDONQ"), QVariant(QString, ""), QVariant(QString, "TESTCAL"), QVariant(qlonglong, 6), QVariant(bool, true), QVariant(int, 2), QVariant(int, 2), QVariant(int, 2), QVariant(bool, false), QVariant(int, 60), QVariant(int, -1), QVariant(bool, false), QVariant(QString, ""), QVariant(bool, false))
>org.kde.pim.akonadiserver:   Query: "INSERT INTO CollectionTable (remoteId, remoteRevision, name, resourceId, enabled, syncPref, displayPref, indexPref, cachePolicyInherit, cachePolicyCheckInterval, cachePolicyCacheTimeout, cachePolicySyncOnDemand, cachePolicyLocalParts, isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)"
>org.kde.pim.akonadiserver: Error during insertion into table "CollectionTable" "Data too long for column 'remoteId' at row 1 QMYSQL: Unable to execute statement"
>org.kde.pim.akonadiserver: Failed to append Collection "TESTCAL" in resource "akonadi_ical_resource_1"
>org.kde.pim.akonadiserver: Error while handling command CreateCollection on connection akonadi_ical_resource_1 (0x559d0ac45430)

EXPECTED RESULT
The calendar is added and works


SOFTWARE/OS VERSIONS
KDE Plasma Version: 6.0.4
KDE Frameworks Version: 6.1.0
Qt Version: 6.7.0

ADDITIONAL INFORMATION
This seems really similar to https://bugs.kde.org/show_bug.cgi?id=394839 ,
although with a different table

-- 
You are receiving this mail because:
You are the assignee for the bug.