xibo icon indicating copy to clipboard operation
xibo copied to clipboard

Suspected race condition when two widgets use the same ticker with images on the same layout

Open DanielBW1 opened this issue 5 years ago • 2 comments

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.

DanielBW1 avatar Jul 25 '19 15:07 DanielBW1

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

alexharrington avatar Aug 13 '19 10:08 alexharrington

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

exalate-issue-sync[bot] avatar Aug 14 '19 10:08 exalate-issue-sync[bot]