xibo
xibo copied to clipboard
Suspected race condition when two widgets use the same ticker with images on the same layout
CMS Version: 2.0.4
Issue: Create a Layout that contains more than one Ticker Widget configured the same as each other. In this example, the ticker was returning images. Schedule this Layout to a Xibo Player. This causes many errors, listed below/
Notes:
- Multiple deletes try to run on requiredfile table which causes a deadlock.
- The Player does not show as logged in, the Display page does not show any displays.
- The Error:
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction logged is returned.
- Making any changes to the Layout can cause this behaviour to occur again.
- Adding ?cache1, ?cache2 etc after the tickers does not resolve the issue.
Seems to be still happening. Seems to be where there are multiple tickers - not necessarily for the same URL. The layout that triggered it this time was as follows:
9 tickers, all use title tag only by the looks of it. there are also 2 clocks, 1 weather and 8 image widgets. layout duration is 20 hours, due to a 72000 second ticker
Jenkins Automation commented: alexharrington commented: Seems to be still happening. Seems to be where there are multiple tickers - not necessarily for the same URL. The layout that triggered it this time was as follows:
9 tickers, all use title tag only by the looks of it. there are also 2 clocks, 1 weather and 8 image widgets. layout duration is 20 hours, due to a 72000 second ticker