Webdav Calendar Integrity constraint violation: 1062 Duplicate entry

[ggeorgg]

I have a problem with webdav. I am not sure if this is a bug or if something in my configuration is wrong. Could someone try to reproduce this?
I have a shared calendar with my girlfriend and everytime she tries to create an event with her mobile phone she can't see this event but I normally do. There is a fatal error message in my nextcloud log which says that there is a constraint violation: 1062 Duplicate entry.

Steps to reproduce

1. Create calendar with user1 and share this calendar with user2 with.
2. Give user2 the rights to edit the shared calendar
3. Create an event with user2 on a mobile phone which syncs the calendar with DAVdroid OR create an event with user2 in Thunderbird and sync the calendar with SOGo.

Expected behaviour

Event is displayed for both users in the calendar

Actual behaviour

Event is only displayed for user1 in the shared calendar.

Server configuration

Operating system:

Web server:
Shared Host ALLinkl

Database:
MySQL
PHP version:
PHP 7.0.10 CGI
Nextcloud version: (see Nextcloud admin page)
Nextcloud 10.0.1

Updated from an older Nextcloud/ownCloud or fresh install:
updated from owncloud 9
to nextcloud 9
to nextcloud 10

Where did you install Nextcloud from:
Manual updated from https://download.nextcloud.com/server/releases/nextcloud-10.0.1.zip

Signing status:

Signing status

No errors have been found.

List of activated apps:

Calendar 1.4.0, Tasks 0.9.3

Activity, Auditing/Logging, Collaborative tags, Comments, Deleted files, External storage support, Federation, File sharing, First run wizard, Gallery, Mail template editor, Notifications, Password policy, PDF viewer, Provisioning API, Server info, Text editor, Theming, Update notificaiton, Usage report, Versions, Video player, Calendar 1.4.0, Contacts, Tasks 0.9.3, Fb Sync, Keeweb, Mail

The content of config/config.php:

Config report

<?php
$CONFIG = array (
  'instanceid' => 'XXXXX',
  'passwordsalt' => 'XXXXX',
  'secret' => 'XXXXX',
  'trusted_domains' => 
  array (
    0 => 'domain.de',
  ),
  'datadirectory' => '/www/htdocs/XXXXXXXX/domain.de/data',
  'overwrite.cli.url' => 'https://domain.de/owncloud',
  'dbtype' => 'mysql',
  'version' => '9.1.1.5',
  'dbname' => 'dbname',
  'dbhost' => 'localhost',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'dbname',
  'dbpassword' => 'XXXXX',
  'logtimezone' => 'Europe/Berlin',
  'installed' => true,
  'tempdirectory' => '/www/htdocs/XXXXXXXX/domain.de/tmp/',
  'appstore.experimental.enabled' => true,
  'theme' => '',
  'loglevel' => 2,
  'maintenance' => false,
  'mail_smtpmode' => 'smtp',
  'mail_from_address' => 'XXXXX',
  'mail_domain' => 'XXXXX.de',
  'mail_smtpsecure' => 'tls',
  'mail_smtpauthtype' => 'LOGIN',
  'mail_smtpauth' => 1,
  'mail_smtphost' => 'XXXXXXXX.kasserver.com',
  'mail_smtpport' => '587',
  'asset-pipeline.enabled' => false,
  'updatechecker' => true,
  'updater.release.channel' => 'stable',
);

Are you using external storage, if yes which one: local/smb/sftp/...
dropbox

Are you using encryption: yes/no
no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...

Client configuration

Browser:
Firefox
Operating system:
Windows 10, Android 4

Logs

Nextcloud log (data/nextcloud.log)

Nextcloud log

Exception: {"Message":"An exception occurred while executing 'INSERT INTO `oc_calendarobjects` (`calendarid`, `uri`, `calendardata`, `lastmodified`, `etag`, `size`, `componenttype`, `firstoccurence`, `lastoccurence`, `classification`, `uid`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\"11\", \"52880154-667a-4acb-80f2-f8d5c594d6ad.ics\", \"BEGIN:VCALENDAR\\r\\nPRODID:-\\\/\\\/Mozilla.org\\\/NONSGML Mozilla Calendar V1.1\\\/\\\/EN\\r\\nVERSION:2.0\\r\\nBEGIN:VTIMEZONE\\r\\nTZID:Europe\\\/Berlin\\r\\nBEGIN:DAYLIGHT\\r\\nTZOFFSETFROM:+0100\\r\\nTZOFFSETTO:+0200\\r\\nTZNAME:CEST\\r\\nDTSTART:19700329T020000\\r\\nRRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3\\r\\nEND:DAYLIGHT\\r\\nBEGIN:STANDARD\\r\\nTZOFFSETFROM:+0200\\r\\nTZOFFSETTO:+0100\\r\\nTZNAME:CET\\r\\nDTSTART:19701025T030000\\r\\nRRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10\\r\\nEND:STANDARD\\r\\nEND:VTIMEZONE\\r\\nBEGIN:VTODO\\r\\nCREATED:20161018T072408Z\\r\\nLAST-MODIFIED:20161018T072551Z\\r\\nDTSTAMP:20161018T072551Z\\r\\nUID:52880154-667a-4acb-80f2-f8d5c594d6ad\\r\\nSUMMARY:Theaterkarten\\r\\nDTSTART;TZID=Europe\\\/Berlin:20161017T092408\\r\\nCLASS:PRIVATE\\r\\nX-MOZ-GENERATION:1\\r\\nEND:VTODO\\r\\nEND:VCALENDAR\\r\\n\", 1476776421, \"311c763c4ead40ba23fac4d18f64bf41\", 698, \"VTODO\", null, null, 1, \"52880154-667a-4acb-80f2-f8d5c594d6ad\"]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '11-52880154-667a-4acb-80f2-f8d5c594d6ad.ics' for key 'calobjects_index'","Exception":"Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException","Code":0,"Trace":"#0 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(116): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(996): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'INSERT INTO `oc...', Array)\n#2 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/lib\/private\/DB\/Connection.php(210): Doctrine\\DBAL\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\n#3 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php(208): OC\\DB\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\n#4 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php(142): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/apps\/dav\/lib\/CalDAV\/CalDavBackend.php(634): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/3rdparty\/sabre\/dav\/lib\/CalDAV\/Calendar.php(199): OCA\\DAV\\CalDAV\\CalDavBackend->createCalendarObject('11', '52880154-667a-4...', 'BEGIN:VCALENDAR...')\n#7 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(1036): Sabre\\CalDAV\\Calendar->createFile('52880154-667a-4...', 'BEGIN:VCALENDAR...')\n#8 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/3rdparty\/sabre\/dav\/lib\/DAV\/CorePlugin.php(523): Sabre\\DAV\\Server->createFile('calendars\/carin...', 'BEGIN:VCALENDAR...', NULL)\n#9 [internal function]: Sabre\\DAV\\CorePlugin->httpPut(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#10 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\n#11 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(459): Sabre\\Event\\EventEmitter->emit('method:PUT', Array)\n#12 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(248): Sabre\\DAV\\Server->invokeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#13 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/apps\/dav\/lib\/Server.php(184): Sabre\\DAV\\Server->exec()\n#14 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/apps\/dav\/appinfo\/v2\/remote.php(30): OCA\\DAV\\Server->exec()\n#15 \/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/remote.php(165): require_once('\/www\/htdocs\/w01...')\n#16 {main}","File":"\/www\/htdocs\/xxxxxxxx\/domain.de\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php","Line":66,"User":"user2"} 

[ggeorgg]

This issue can be closed since I made a fresh install of nextcloud 11 where I can't reproduce this error.