[fatal] Attempt to update object did not result in a single row modification

95 views

Skip to first unread message

Chris Wilson

unread,

Oct 17, 2013, 7:20:38 PM10/17/13

to la...@googlegroups.com

Hi all,

I'm trying to use Larch to migrate from Cyrus to Dovecot. I get the following error every time I try to run Larch:

larch --from imap://localhost --from-user=secret --from-pass=secret --to imap://localhost:144 --to-user=secret --to-pass=secret --all -V debug

[00:16:46] [debug] [<] updating mailboxes

[00:16:46] [debug] [<] connecting...

[00:16:46] [info] [<] connected to localhost on port 143

[00:16:46] [debug] [<] authenticating using PLAIN

[00:16:47] [debug] [<] authenticated using PLAIN

[00:16:51] [debug] [>] connecting...

[00:16:51] [info] [>] connected to localhost on port 144

[00:16:51] [debug] [>] authenticating using LOGIN

[00:16:52] [debug] [>] authenticated using LOGIN

[00:16:52] [debug] [>] updating mailboxes

[00:16:55] [info] [>] creating mailbox: INBOX/Macaulay Walk/Elica

[00:16:55] [debug] [>] updating mailboxes

[00:16:55] [info] localhost/INBOX/Macaulay Walk/Elica -> localhost/INBOX/Macaulay Walk/Elica

[00:16:55] [debug] [<] INBOX/Macaulay Walk/Elica: getting mailbox status

[00:16:56] [fatal] Attempt to update object did not result in a single row modification (SQL: UPDATE `mailboxes` SET `uidvalidity` = 1373888271 WHERE (`id` = 30))

[00:16:56] [info] 0 message(s) copied, 0 failed, 0 deleted out of 0 total

[00:16:56] [debug] performing database maintenance

Each time it creates a different mailbox, and apparently succeeds, but fails with the same SQL error afterwards. This is Larch 1.1.2 on CentOS 6. Any ideas?

Cheers, Chris.

Chris Wilson

unread,

Nov 3, 2013, 3:36:03 PM11/3/13

to la...@googlegroups.com

Hi all,

On Friday, October 18, 2013 12:20:38 AM UTC+1, Chris Wilson wrote:

I'm trying to use Larch to migrate from Cyrus to Dovecot. I get the following error every time I try to run Larch:

larch --from imap://localhost --from-user=secret --from-pass=secret --to imap://localhost:144 --to-user=secret --to-pass=secret --all -V debug
[00:16:46] [debug] [<] updating mailboxes
[00:16:46] [debug] [<] connecting...
[00:16:46] [info] [<] connected to localhost on port 143
[00:16:46] [debug] [<] authenticating using PLAIN
[00:16:47] [debug] [<] authenticated using PLAIN
[00:16:51] [debug] [>] connecting...
[00:16:51] [info] [>] connected to localhost on port 144
[00:16:51] [debug] [>] authenticating using LOGIN
[00:16:52] [debug] [>] authenticated using LOGIN
[00:16:52] [debug] [>] updating mailboxes
[00:16:55] [info] [>] creating mailbox: INBOX/Macaulay Walk/Elica
[00:16:55] [debug] [>] updating mailboxes
[00:16:55] [info] localhost/INBOX/Macaulay Walk/Elica -> localhost/INBOX/Macaulay Walk/Elica
[00:16:55] [debug] [<] INBOX/Macaulay Walk/Elica: getting mailbox status
[00:16:56] [fatal] Attempt to update object did not result in a single row modification (SQL: UPDATE `mailboxes` SET `uidvalidity` = 1373888271 WHERE (`id` = 30))
[00:16:56] [info] 0 message(s) copied, 0 failed, 0 deleted out of 0 total
[00:16:56] [debug] performing database maintenance

This error is still stopping me from migrating from Cyrus to Dovecot, and I'd really like to fix it. Please could a kind soul help me?