All-Day calendar entry is stored ~100 times

Ihon

Hi,

after update to Kopano core 8.7.80.402 and WebApp 3.5.1.2057 under Ubuntu server 18.04 I have the challenge that any all day calendar entry is store a 100 times and you cannot delete it because of Error HTTP 500, Internal Server Error.

Apache Log shows:
[Thu Jan 03 11:28:19.182296 2019] [php7:error] [pid 17196] [client 79.203.212.8:50597] PHP Fatal error: Uncaught ArgumentCountError: Too few arguments to function BaseException::__construct(), 0 passed in /usr/share/kopano-webapp/server/includes/core/class.operations.php on line 2891 and at least 1 expected in /usr/share/kopano-webapp/server/includes/mapi/class.baseexception.php:51\nStack trace:\n#0 /usr/share/kopano-webapp/server/includes/core/class.operations.php(2891): BaseException->__construct()\n#1 /usr/share/kopano-webapp/server/includes/core/class.operations.php(2836): Operations->copyMessages(Resource id #12, ‘\x00\x00\x00\x00\xD2\x81\x08\x94rnN]\xB3\x91Q…’, Resource id #12, ‘\x00\x00\x00\x00\xD2\x81\x08\x94rnN]\xB3\x91Q…’, Array, Array, true)\n#2 /usr/share/kopano-webapp/server/includes/modules/class.itemmodule.php(612): Operations->deleteMessages(Resource id #12, ‘\x00\x00\x00\x00\xD2\x81\x08\x94rnN]\xB3\x91Q…’, Array, false)\n#3 /usr/share/kopano-webapp/server/includes/modules/class.itemmodule.php(277): ItemModule->delete(Resource id #12, ‘\x00\x00\x00\x00\xD2\x81\x08\x94rnN]\xB3\x91Q…’, '\x00\x0 in /usr/share/kopano-webapp/server/includes/mapi/class.baseexception.php on line 51, referer: https://www.shaitan.eu/webapp/
[Thu Jan 03 11:31:25.920604 2019] [php7:notice] [pid 18425] [client 79.203.212.8:50667] Unknown language: ‘de_DE’
[Thu Jan 03 11:31:26.991678 2019] [php7:notice] [pid 18425] [client 79.203.212.8:50667] Unknown language: ‘de_DE’

and

[Thu Jan 03 11:35:42.644546 2019] [php7:error] [pid 19721] [client 192.168.2.128:55320] PHP Fatal error: Uncaught ArgumentCountError: Too few arguments to function BaseException::construct(), 0 passed in /usr/share/kopano-webapp/server/includes/core/class.operations.php on line 2891 and at least 1 expected in /usr/share/kopano-webapp/server/includes/mapi/class.baseexception.php:51\nStack trace:\n#0 /usr/share/kopano-webapp/server/includes/core/class.operations.php(2891): BaseException->construct()\n#1 /usr/share/kopano-webapp/server/includes/core/class.operations.php(2836): Operations->copyMessages(Resource id #12, '\x00\x00\x00\x00\x8Dh\x83k\xB9Cq\x9FC\x92…’, Resource id #12, '\x00\x00\x00\x00\x8Dh\x83k\xB9Cq\x9FC\x92…’, Array, Array, true)\n#2 /usr/share/kopano-webapp/server/includes/modules/class.itemmodule.php(612): Operations->deleteMessages(Resource id #12, '\x00\x00\x00\x00\x8Dh\x83k\xB9Cq\x9FC\x92…’, Array, false)\n#3 /usr/share/kopano-webapp/server/includes/modules/class.itemmodule.php(277): ItemModule->delete(Resource id #12, '\x00\x00\x00\x00\x8Dh\x83k\xB9Cq\x9FC\x92…’, '\x00\x00\x00\x00\x8 in /usr/share/kopano-webapp/server/includes/mapi/class.baseexception.php on line 51, referer: https://www.shaitan.eu/webapp/

Server.log shows nothing:
Thu Jan 3 10:48:13 2019: [=======] Starting kopano-server version 8.7.80 (pid 4481 uid 999)
Thu Jan 3 10:48:13 2019: [info ] Using epoll events
Thu Jan 3 10:48:13 2019: [notice ] Listening for TCP connections on port 236
Thu Jan 3 10:48:13 2019: [notice ] Listening for priority pipe connections on /var/run/kopano/prio.sock
Thu Jan 3 10:48:13 2019: [notice ] Listening for pipe connections on /var/run/kopano/server.sock
Thu Jan 3 10:48:13 2019: [notice ] Connection to database ‘Zarafa’ succeeded
Thu Jan 3 10:48:13 2019: [info ] Setting object cache size: 16777216
Thu Jan 3 10:48:13 2019: [info ] Setting indexedobject cache size: 33554432
Thu Jan 3 10:48:13 2019: [notice ] Querying database for searchfolders. This may take a while.
Thu Jan 3 10:48:13 2019: [notice ] Loading search folders.
Thu Jan 3 10:48:13 2019: [notice ] Done loading search folders.
Thu Jan 3 10:48:13 2019: [notice ] Startup succeeded on pid 4481
Thu Jan 3 11:00:03 2019: [info ] Start scheduled softdelete clean up
Thu Jan 3 11:00:03 2019: [info ] Start to purge 2 messages
Thu Jan 3 11:00:04 2019: [info ] Message purge done
Thu Jan 3 11:00:04 2019: [info ] Softdelete done: removed 0 stores, 0 folders, and 2 messages
Thu Jan 3 11:13:04 2019: [info ] Start syncs table clean up
Thu Jan 3 11:13:04 2019: [info ] syncs table clean up done: removed syncs: 0
Thu Jan 3 11:14:04 2019: [info ] Start syncedmessages table clean up
Thu Jan 3 11:14:04 2019: [info ] syncedmessages table clean up done, 0 entries removed

Thank you for your support

Ihon

marty

Hi @Ihon

The error seems to be the same as: https://jira.kopano.io/browse/KW-2699
Could you check if you performed similar steps or did you make any other changes to this store?

For a complete picture: From which version(s) did you upgrade

Ihon

Hi @marty,

no, it is not the same error and it looks like it was related to the mapi error from yesterday, (Error https://forum.kopano.io/topic/2031/version-8-7-80-402-1c7f107ba-0-44-1-breaks-php7-mapi).
I updated the CORE from version 8.7.80.355 to 8.7.80.402 and got the effect for all users.
WebApp was updated from 3.5.1.2033.

This morning I updated the core to version 8.7.80.424, effect gone, now all calendar entries are just added once.

Challenge, I need to delete at two users around 4 entries which were duplicated to 1200 entries.
Do you have a good idea how to delete these entries without fiddling in the database?

Thanks,

Ihon

marty

@Ihon
Python-kopano