We have a Rivendell server at a private school where the broadcast studio is.
We also have 2 remote Rivendell systems.
Each of the remote Rivendell system access the main MySQL running at the school
over a VPN. Using rsync scripts, the remote systems keep their own local copy
of /var/snd and send local updates to the main Rivendell server.
This works fairly well for RDLogManager, RDLogEdit and RDLibrary.
What I cannot get to work is RDAirPlay. RDAirPlay is constantly running MySQL
queries, even when not playing anything:
select CART.TYPE,CART.GROUP_NAME,CART.TITLE,
CART.ARTIST,CART.ALBUM,CART.YEAR,CART.ISRC,
CART.LABEL,CART.CLIENT,CART.AGENCY,
CART.USER_DEFINED,CART.CONDUCTOR,CART.SONG_ID,
CART.FORCED_LENGTH,
CART.CUT_QUANTITY,CART.LAST_CUT_PLAYED,
CART.PLAY_ORDER,CART.START_DATETIME,
CART.END_DATETIME,CART.ENFORCE_LENGTH,
CART.PRESERVE_PITCH,GROUPS.ENABLE_NOW_NEXT,
CART.ASYNCRONOUS,CART.PUBLISHER,
CART.COMPOSER,CART.USAGE_CODE,
CART.AVERAGE_SEGUE_LENGTH,CART.NOTES,
GROUPS.COLOR from CART left join GROUPS on
CART.GROUP_NAME=GROUPS.NAME
where (CART.NUMBER=10996)
select `NUMBER` from `CART` where `NUMBER`=10996
select `NUMBER` from `CART` where `NUMBER`=10996
select `TYPE` from `CART` where `NUMBER`=10996
select `USE_WEIGHTING` from `CART` where `NUMBER`=10996
select CUT_NAME,PLAY_ORDER,WEIGHT,LOCAL_COUNTER,LAST_PLAY_DATETIME from CUTS
where (((START_DATETIME<=\"2018-01-22 20:12:17\")&&(END_DATETIME>=\"2018-01-22
20:12:17\"))||(START_DATETIME is
null))&&(((START_DAYPART<=\"20:12:17\")&&(END_DAYPART>=\"20:12:17\")||START_DAYPART
is null))&&(MON=\"Y\")&&(CART_NUMBER=10996)&&(EVERGREEN=\"N\")&&(LENGTH>0)
order by LOCAL_COUNTER ASC, ISNULL(END_DATETIME), END_DATETIME ASC,
LAST_PLAY_DATETIME ASC ...
select `USE_WEIGHTING` from `CART` where `NUMBER`=10996
select
LENGTH,START_POINT,END_POINT,SEGUE_START_POINT,SEGUE_END_POINT,SEGUE_GAIN,TALK_START_POINT,TALK_END_POINT,HOOK_START_POINT,HOOK_END_POINT,OUTCUE,ISRC,ISCI,DESCRIPTION
from CUTS where CUT_NAME=\"010996_001\"
Then it starts over with the next cart
select CART.TYPE,CART.GROUP_NAME,CART.TITLE,
CART.ARTIST,CART.ALBUM,CART.YEAR,CART.ISRC,
CART.LABEL,CART.CLIENT,CART.AGENCY,
CART.USER_DEFINED,CART.CONDUCTOR,CART.SONG_ID,
CART.FORCED_LENGTH,
CART.CUT_QUANTITY,CART.LAST_CUT_PLAYED,
CART.PLAY_ORDER,CART.START_DATETIME,
CART.END_DATETIME,CART.ENFORCE_LENGTH,
CART.PRESERVE_PITCH,GROUPS.ENABLE_NOW_NEXT,
CART.ASYNCRONOUS,CART.PUBLISHER,
CART.COMPOSER,CART.USAGE_CODE,
CART.AVERAGE_SEGUE_LENGTH,CART.NOTES,
GROUPS.COLOR from CART left join GROUPS on
CART.GROUP_NAME=GROUPS.NAME
where (CART.NUMBER=10720)
This seems to continue over and over again, with every cart, forever.
This bogs RDAirPlay down so much, the clock updates about every 20 seconds and
RDAirPlay is mostly unresponsive.
Does anyone know what RDAirPlay is actually doing and why it continually does
this? I have not dug into the source code yet, hoping someone knew how
RDAirPlay works.
We are in the sticks and crappy DSL is about all we can get, so these SQL
queries take a long time.
Patrick
My99.7
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
