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