[Akonadi] [Bug 394839] New: pimitemtable.remoteid Column Too Small For Exchange Calendar Via davmail

[Garry Williams]

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

            Bug ID: 394839
           Summary: pimitemtable.remoteid Column Too Small For Exchange
                    Calendar Via davmail
           Product: Akonadi
           Version: 5.7.2
          Platform: Other
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: DAV Resource
          Assignee: kdepim-bugs at kde.org
          Reporter: gtwilliams at gmail.com
  Target Milestone: ---

I was unable to configure an Exchange calendar via the davmail proxy because
the item ID was longer than the column length for the pimitemtable.remoteid
column (255).

The error resulted in log messages like this:

    DATABASE ERROR:
      Error code: "1406"
      DB error:  "Data too long for column 'remoteId' at row 1"
      Error text: "Data too long for column 'remoteId' at row 1 QMYSQL3: Unable
to execute statement"
      Query: "INSERT INTO PimItemTable (rev, remoteId, remoteRevision, gid,
collectionId, mimeTypeId, datetime, atime, dirty, size) VALUES (:0, :1, :2, :3,
:4, :5, :6, :7, :8, :9)"

I turned on general_log in mysql to catch the error.

The fix was:

    alter table pimitemtable modify column remoteId varchar(1024);

(I imagine that 1024 is larger than what is strictly needed, but it costs
nothing to specify it.)

The problem data looks like this:

   
http://localhost:1080/users/garry_williams2@comcast.com/calendar/AAMkADE0ZTY4YjY0LTM3ZmUtNGQ3Yy1hMzdjLTdlNTZlYjgzMTNkZgBGAAAAAABv2lgKJBYZRoOfK2MzkdgNBwCAS5PvJdbcTKxWQLEnWOAHAAAAAAENAACAS5PvJdbcTKxWQLEnWOAHAAAaQl7dAAA%3D.EML#040000008200E00074C5B7101A82E00800000000A059FC7E8054D20100000000000000001000000067BF664FED94F14D8772488D96A9E4E92017-01-17T19:30:00+00:00

My pimitemtable now has this:

    MariaDB [akonadi]> select length(remoteid) from pimitemtable where
length(remoteid) > 255;
    +------------------+
    | length(remoteid) |
    +------------------+
    |              361 |
    |              361 |
    |              361 |
    |              361 |
    |              361 |
    |              361 |
    |              361 |
    |              363 |
    |              363 |
    +------------------+
    9 rows in set (0.01 sec)

    MariaDB [akonadi]>

And the calendar is finally working.

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