[Akonadi] [Bug 323844] Adding foldert to imap-account gives "Duplicate entry" sql error

[Erick Osorio]

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

Erick Osorio  changed:

   What|Removed |Added

 CC||evgom@gmail.com

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

[Akonadi] [Bug 323844] Adding foldert to imap-account gives "Duplicate entry" sql error

[Till Schäfer]

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

--- Comment #16 from Till Schäfer  ---
I have created a meta-bug " Akonadi IMAP Resource should handle Duplicate entry
in CollectionTable errors": Bug 375244

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

[Akonadi] [Bug 323844] Adding foldert to imap-account gives "Duplicate entry" sql error

[Till Schäfer]

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

Till Schäfer  changed:

   What|Removed |Added

 CC||till2.schaefer@uni-dortmund
   ||.de

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

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Dennis Schridde]

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

Dennis Schridde devuran...@gmx.net changed:

   What|Removed |Added

 CC||devuran...@gmx.net

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Dennis Schridde]

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

--- Comment #15 from Dennis Schridde devuran...@gmx.net ---
I renamed the folder with remoteId trash in collection id 6 / resourceId 5
from wastebin to trash using akonadiconsole. Now KMail starts again,
without showing the popup error described above.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Simon Andric]

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

Simon Andric simonandr...@gmail.com changed:

   What|Removed |Added

 CC||simonandr...@gmail.com

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Dennis Schridde]

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

--- Comment #14 from Dennis Schridde devuran...@gmx.net ---
P.S: This is Ubuntu 14.04 with KMail 4.14.2 from the Kubuntu PPA
(4:4.14.2-0ubuntu1~ubuntu14.04~ppa1).

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Dennis Schridde]

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

--- Comment #13 from Dennis Schridde devuran...@gmx.net ---
I have the same issue with a trash folder.

I get a popup dialogue saying:
```
The Email program encountered a fatal error and will terminate now.
The error was:
Could not create collection trash resourceId: 5
```

On the console Akonadi logs:
```
DATABASE ERROR:
Error code: 1062
DB error:  Duplicate entry '6-trash' for key
'CollectionTable_parentAndNameIndex'
Error text: Duplicate entry '6-trash' for key
'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement
Query: INSERT INTO CollectionTable (remoteId, remoteRevision, name, parentId,
resourceId, enabled, syncPref, displayPref, indexPref, cachePolicyInherit,
isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
Error during insertion into table CollectionTable Duplicate entry '6-trash'
for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute
statement 
```

Looking at the collectiontable in akonadiconsole shows me that the collection
with id 6 has resourceId 5, and that a collection with remoteId trash exists
with parentId 6.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Christian Mollekopf]

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

Christian Mollekopf mollek...@kolabsys.com changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|FIXED   |---

--- Comment #12 from Christian Mollekopf mollek...@kolabsys.com ---
I just hit this again in master:

akonadi_imap_resource_0(6071)/kdepimlibs (kimap)
RetrieveCollectionMetadataTask::doStart: /test7
akonadi_archivemail_agent(6063)/libakonadi
Akonadi::EntityTreeModelPrivate::monitoredCollectionChanged: 115
akonadi_notes_agent(6080)/libakonadi
Akonadi::EntityTreeModelPrivate::monitoredCollectionChanged: 115
akonadi_mailfilter_agent(6076)/libakonadi
Akonadi::EntityTreeModelPrivate::monitoredCollectionChanged: 115
akonadi_folderarchive_agent(6067)/libakonadi
Akonadi::EntityTreeModelPrivate::monitoredCollectionChanged: 115
akonadi_mailfilter_agent(6076)/libakonadi
Akonadi::EntityTreeModelPrivate::monitoredCollectionChanged: 115
akonadi_archivemail_agent(6063)/libakonadi
Akonadi::EntityTreeModelPrivate::monitoredCollectionChanged: 115
akonadi_notes_agent(6080)/libakonadi
Akonadi::EntityTreeModelPrivate::monitoredCollectionChanged: 115
akonadi_folderarchive_agent(6067)/libakonadi
Akonadi::EntityTreeModelPrivate::monitoredCollectionChanged: 115
Error during executing query INSERT INTO CollectionTable (remoteId,
remoteRevision, name, parentId, resourceId, cachePolicyInherit, isVirtual) V
ALUES (:0, :1, :2, :3, :4, :5, :6) :  Duplicate entry '57-test7' for key
'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statem
ent
Error during insertion into table CollectionTable Duplicate entry '57-test7'
for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to e
xecute statement 

As you can see I created the folder test7. Unfortunately this only happended
once and I couldn't reproduce it so far.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Christian Mollekopf]

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

Christian Mollekopf mollek...@kolabsys.com changed:

   What|Removed |Added

 Status|CONFIRMED   |RESOLVED
 CC||mollek...@kolabsys.com
 Resolution|--- |FIXED

--- Comment #11 from Christian Mollekopf mollek...@kolabsys.com ---
(In reply to comment #10)
 Creating imap-folders seems to work now, but I have to restart kmail to see
 them. Different Bug I assume?

That is indeed a different bug, thanks for the reports.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Johannes Hirte]

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

--- Comment #10 from Johannes Hirte johannes.hi...@fem.tu-ilmenau.de ---
Creating imap-folders seems to work now, but I have to restart kmail to see
them. Different Bug I assume?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Kevin Ottens]

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

Kevin Ottens er...@kde.org changed:

   What|Removed |Added

   Assignee|er...@kde.org   |chrig...@fastmail.fm

--- Comment #9 from Kevin Ottens er...@kde.org ---
The IMAP resource has a new maintainer, reassigning to him.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Daniel Vrátil]

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

--- Comment #8 from Daniel Vrátil dvra...@redhat.com ---
Looking through this again, it looks like there is a problem with separators
(the server apparently uses . as folder separator). This has been recently
fixed, please test against 4.11.2 if you can.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Daniel Vrátil]

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

Daniel Vrátil dvra...@redhat.com changed:

   What|Removed |Added

 CC||kdepim-bugs@kde.org,
   ||vkra...@kde.org
  Component|server  |IMAP resource
   Assignee|kdepim-bugs@kde.org |er...@kde.org

--- Comment #6 from Daniel Vrátil dvra...@redhat.com ---
Thanks, very useful!

Is it a well-known IMAP server (Dovecot, Cyrus,) or some proprietary
implementation?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Johannes Hirte]

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

--- Comment #7 from Johannes Hirte johannes.hi...@fem.tu-ilmenau.de ---
(In reply to comment #6)
 Thanks, very useful!
 
 Is it a well-known IMAP server (Dovecot, Cyrus,) or some proprietary
 implementation?

It's a dovecot 2.2.5 from Gentoo. As far as I see there is only pigeonhole
support added and no other patches.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Daniel Vrátil]

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

--- Comment #4 from Daniel Vrátil dvra...@redhat.com ---
@Geert, Akonadi by design does not allow having two subcollections with the
same name in the same parent collection - this can however happen with special
resources that handle various data types (like owncloud, which handles both
calendars and contacts). Please open a bug report against the owncloud resource
- the resource must make sure the name is unique within it's parent collection.
The name that is displayed to user can be stored to EntityDisplayAttribute, so
no worry that you would see one of your collections names like Kobalt_2 or
something like that.

@Johannes, can you please check in Akonadi Console - Db Browser -
collectiontable that no collection with the name you are trying to create
exists there, then try to create it and check again. If a new record with the
name and remoteId filled is there, then there's some weird bug that KMail or
the IMAP resource is trying to create the collections twice. Make sure you have
Debugger enabled when creating the collection. If you get the error again,
please provide entire output of the Debugger tab. Thanks

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Johannes Hirte]

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

--- Comment #5 from Johannes Hirte johannes.hi...@fem.tu-ilmenau.de ---
(In reply to comment #4)
 @Johannes, can you please check in Akonadi Console - Db Browser -
 collectiontable that no collection with the name you are trying to create
 exists there, then try to create it and check again. If a new record with
 the name and remoteId filled is there, then there's some weird bug that
 KMail or the IMAP resource is trying to create the collections twice.  Make
 sure you have Debugger enabled when creating the collection. If you get
 the error again, please provide entire output of the Debugger tab. Thanks

output from the Debugger tab:

kmail2-2005480717 (0x24c4e50) 11 CREATE debugkmail 46 ( REMOTEID 
REMOTEREVISION  VIRTUAL 0 CACHEPOLICY (INHERIT true)) 
kmail2-2005480717 (0x24c4e50) * 58 46 (NAME debugkmail MIMETYPE
(inode/directory) REMOTEID  REMOTEREVISION  RESOURCE
akonadi_imap_resource_5 VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ) 
kmail2-2005480717 (0x24c4e50) 11 OK CREATE completed 
MailFilter Kernel ETM (0x24c5230) 14 LSUB 58 0 () (STATISTICS true ANCESTORS
INF) 
Archive Mail Kernel ETM (0x24b4bb0) 14 LSUB 58 0 () (STATISTICS true ANCESTORS
INF) 
MailFilter Kernel ETM (0x24c5230) * 58 46 (NAME debugkmail MIMETYPE
(inode/directory) REMOTEID  REMOTEREVISION  RESOURCE
akonadi_imap_resource_5 VIRTUAL 0 MESSAGES 0 UNSEEN 0 SIZE 0 CACHEPOLICY
(INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS
(ENVELOPE HEAD)) ANCESTORS ((46
imap://kmailt...@datenkhaos.de@mail.datenkhaos.de/) (0 )) ) 
MailFilter Kernel ETM (0x24c5230) 14 OK List completed 
Archive Mail Kernel ETM (0x24b4bb0) * 58 46 (NAME debugkmail MIMETYPE
(inode/directory) REMOTEID  REMOTEREVISION  RESOURCE
akonadi_imap_resource_5 VIRTUAL 0 MESSAGES 0 UNSEEN 0 SIZE 0 CACHEPOLICY
(INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS
(ENVELOPE HEAD)) ANCESTORS ((46
imap://kmailt...@datenkhaos.de@mail.datenkhaos.de/) (0 )) ) 
Archive Mail Kernel ETM (0x24b4bb0) 14 OK List completed 
akonadi_newmailnotifier_agent (0x23e1680) 9 LSUB 58 0 () (ANCESTORS INF) 
akonadi_nepomuk_feeder (0x23de2d0) 9 LSUB 58 0 () () 
akonadi_newmailnotifier_agent (0x23e1680) * 58 46 (NAME debugkmail MIMETYPE
(inode/directory) REMOTEID  REMOTEREVISION  RESOURCE
akonadi_imap_resource_5 VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
imap://kmailt...@datenkhaos.de@mail.datenkhaos.de/) (0 )) ) 
akonadi_newmailnotifier_agent (0x23e1680) 9 OK List completed 
akonadi_nepomuk_feeder (0x23de2d0) * 58 46 (NAME debugkmail MIMETYPE
(inode/directory) REMOTEID  REMOTEREVISION  RESOURCE
akonadi_imap_resource_5 VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ) 
akonadi_nepomuk_feeder (0x23de2d0) 9 OK List completed 
akonadi_imap_resource_5 (0x23e03b0) 51 LSUB 46 0 () (STATISTICS true ANCESTORS
INF) 
akonadi_imap_resource_5 (0x23e03b0) * 46 0 (NAME kmailtest MIMETYPE
(inode/directory) REMOTEID imap://kmailt...@datenkhaos.de@mail.datenkhaos.de/
REMOTEREVISION  RESOURCE akonadi_imap_resource_5 VIRTUAL 0 MESSAGES 0
UNSEEN 0 SIZE 0 CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT 60
SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((0 )) noselect 1) 
akonadi_imap_resource_5 (0x23e03b0) 51 OK List completed 
akonadi_imap_resource_5 (0x23e03b0) 52 LSUB 58 0 () (STATISTICS true ANCESTORS
INF) 
akonadi_imap_resource_5 (0x23e03b0) * 58 46 (NAME debugkmail MIMETYPE
(inode/directory) REMOTEID  REMOTEREVISION  RESOURCE
akonadi_imap_resource_5 VIRTUAL 0 MESSAGES 0 UNSEEN 0 SIZE 0 CACHEPOLICY
(INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS
(ENVELOPE HEAD)) ANCESTORS ((46
imap://kmailt...@datenkhaos.de@mail.datenkhaos.de/) (0 )) ) 
akonadi_imap_resource_5 (0x23e03b0) 52 OK List completed 
ETMCalendar (0x23d8cb0) 13 LSUB 58 0 () (ANCESTORS INF) 
ETMCalendar (0x23d8cb0) * 58 46 (NAME debugkmail MIMETYPE (inode/directory)
REMOTEID  REMOTEREVISION  RESOURCE akonadi_imap_resource_5 VIRTUAL 0
CACHEPOLICY (INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true
LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
imap://kmailt...@datenkhaos.de@mail.datenkhaos.de/) (0 )) ) 
ETMCalendar (0x23d8cb0) 13 OK List completed 
ETMCalendar (0x2407660) 13 LSUB 58 0 () (ANCESTORS INF) 
ETMCalendar (0x2407660) * 58 46 (NAME debugkmail MIMETYPE (inode/directory)
REMOTEID  REMOTEREVISION  RESOURCE akonadi_imap_resource_5 VIRTUAL 0
CACHEPOLICY (INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true
LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
imap://kmailt...@datenkhaos.de@mail.datenkhaos.de/) (0 )) ) 
ETMCalendar (0x2407660) 13 OK List completed 
KMail Kernel ETM (0x23ecc80) 21 LSUB 58 0 () (STATISTICS true ANCESTORS INF) 
KMail Kernel ETM (0x23ecc80) * 58 46 (NAME debugkmail MIMETYPE
(inode/directory) REMOTEID  

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Geert Janssens]

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

Geert Janssens i...@kobaltwit.be changed:

   What|Removed |Added

 CC||i...@kobaltwit.be

--- Comment #3 from Geert Janssens i...@kobaltwit.be ---
I got this very same error when trying to add an owncloud resource in akonadi,
in which I have a calendar and addressbook that both use the same name (both
are named 'Kobalt' in my case). Due to this error my owncloud contacts are not
showing in my KAddressbook.

I could work around this issue by renaming the owncloud calendar. But the core
issue is that akonadi doesn't handle duplicate resource names very well. My use
case should work. A calendar and addressbook that use the same name are still
easily identified as different objects. It would be more difficult for two
calendars using the same name for example.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Daniel Vrátil]

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

Daniel Vrátil dvra...@redhat.com changed:

   What|Removed |Added

 Status|UNCONFIRMED |CONFIRMED
 CC||dvra...@redhat.com
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Daniel Vrátil]

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

--- Comment #1 from Daniel Vrátil dvra...@redhat.com ---
Is it possible that the folder already existed on server before you tried to
create it in KMail, but maybe you just weren't subscribed to it?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

[Akonadi] [Bug 323844] Adding foldert to imap-account gives Duplicate entry sql error

[Johannes Hirte]

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

--- Comment #2 from Johannes Hirte johannes.hi...@fem.tu-ilmenau.de ---
(In reply to comment #1)
 Is it possible that the folder already existed on server before you tried to
 create it in KMail, but maybe you just weren't subscribed to it?

No, I've tried with a complete new account that never existed neither on the
imap-server nor akonadi. Creating a new, not already existing folder gives the
akonadi-error.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs