search

nextcloud / calendar

📆 Calendar app for Nextcloud
https://apps.nextcloud.com/apps/calendar
GNU Affero General Public License v3.0
966 stars 236 forks source link

Appointment booking - can't delete confirmed appointment #5368

Open schiessle opened 1 year ago

schiessle commented 1 year ago

Steps to reproduce

  1. create a calendar to book appointmens
  2. book a appointment
  3. confirm booked appointment
  4. try to delete the booked appointment again from the owner of the calendar

Expected behavior

Apppointment can be deleted and the person who booked the appointment gets a mail the the appointment was canceled

Actual behaviour

The person who booked the appointment gets a mail that the appointment was cancelled but it doesn't get deleted from the owners calendar.

The sidebar loads forever:

grafik

The network console of the browser shows this response:

<?xml version="1.0" encoding="utf-8"?>
<d:error xmlns:d="DAV:" xmlns:s="http://sabredav.org/ns">
  <s:exception>OC\DB\Exceptions\DbalException</s:exception>
  <s:message>An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction</s:message>
</d:error>

tested on c.nc.com

Calendar app version

4.4.3

CalDAV-clients used

No response

Browser

No response

Client operating system

No response

Server operating system

No response

Web server

None

Database engine version

None

PHP engine version

None

Nextcloud version

27.0.1.1

Updated from an older installed version or fresh install

None

List of activated apps

No response

Nextcloud configuration

No response

Web server error log

No response

Log file

No response

Browser log

No response

Additional info

No response

schiessle commented 1 year ago

Empty the trash bin like described here solved the problem for me: https://github.com/nextcloud/calendar/issues/5365#issuecomment-1638021403

Seems like there is a issue when the trashbin reaches some limits?

schiessle commented 1 year ago

Maybe to add, after deleting the trash bin the event was deleted directly from the calendar. I didn't had to delete it again manually. At the same time the person who booked the appointment got another 5-10 mails that the event was cancelled. It looks like the delete operation(s) was queued and executed once there was space again in the trash bin?!