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 - confirmation step hangs #5367

Open schiessle opened 1 year ago

schiessle commented 1 year ago

Steps to reproduce

  1. Setup a calendar for appointment booking
  2. open the link and book a appointment
  3. once you received the confirmation mail click on the "confirm" button

Expected behavior

The user get's a response that the appointment was successfully confirmed

Actual behaviour

browser loads about half a minute before the request most likely timeout:

grafik

This was 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

miaulalala commented 1 year ago

Got any log entries?

ChristophWurst commented 1 year ago

image

works for me on the same instance

ChristophWurst commented 1 year ago

Sentry shows some General error: 1205 Lock wait timeout exceeded; try restarting transaction for that time frame. Does the page still hang and error out?

schiessle commented 1 year ago

Timeouts might be the reason. I noticed lately that many calendar operations a really slow for me. Maybe because my calendar collected quite a lot of entries over the years and I also have access to a lot of (similar big) shared calendars?

schiessle commented 1 year ago

It now seems to work again... strange. The timeout might have been the problem. I see sometimes quite long loading times when doing stuff in my calendar.

Probably because of the reason mentioned above: My calendar collected quite a lot of entries over the years and I also have access to a lot of (similar big) shared calendars?

I leave the decision to you @ChristophWurst if you want to keep it open and observe the issue for some time, maybe look into performance enhancements for many large calendars, or close it for now

tcitworld commented 1 year ago

Performance issues when finding slots was also the motivation for https://github.com/nextcloud/calendar/pull/4288