[RDD] RDLogmanager and clocks

Andy Brown andy at thebmwz3.co.uk
Mon Jan 14 05:05:26 EST 2013


Hi Wayne,
Thanks for your feedback, running rdlogmanager on the CLI does give a
few hints. I wonder if the indexes on the MySQL database are incorrect,
as the insert is failing due to duplicate ID

rdlogmanager -g -d 0 -s Production

invalid SQL or failed DB connection: insert into `2013_01_15_LOG` set
ID=3,COUNT=3,TYPE=1,
SOURCE=3,START_TIME=7000,GRACE_TIME=-1,
CART_NUMBER=0,TIME_TYPE=0,POST_POINT="N",
TRANS_TYPE=1,COMMENT="End\ song"
rdlogmanager: invalid SQL or failed DB connection: insert into
`2013_01_15_LOG` set ID=3,COUNT=3,TYPE=1,
SOURCE=3,START_TIME=7000,GRACE_TIME=-1,
CART_NUMBER=0,TIME_TYPE=0,POST_POINT="N",
TRANS_TYPE=1,COMMENT="End\ song"
Database connection failed: insert into `2013_01_15_LOG` set
ID=3,COUNT=3,TYPE=1,
SOURCE=3,START_TIME=7000,GRACE_TIME=-1,
CART_NUMBER=0,TIME_TYPE=0,POST_POINT="N",
TRANS_TYPE=1,COMMENT="End\ song"
Database connection restored.
invalid SQL or failed DB connection: insert into `2013_01_15_LOG` set
ID=8,COUNT=8,TYPE=1,
SOURCE=3,START_TIME=3607000,GRACE_TIME=-1,
CART_NUMBER=0,TIME_TYPE=0,POST_POINT="N",
TRANS_TYPE=1,COMMENT="End\ song"
rdlogmanager: invalid SQL or failed DB connection: insert into
`2013_01_15_LOG` set ID=8,COUNT=8,TYPE=1,
SOURCE=3,START_TIME=3607000,GRACE_TIME=-1,
CART_NUMBER=0,TIME_TYPE=0,POST_POINT="N",
TRANS_TYPE=1,COMMENT="End\ song"
Database connection failed: insert into `2013_01_15_LOG` set
ID=8,COUNT=8,TYPE=1,
SOURCE=3,START_TIME=3607000,GRACE_TIME=-1,
CART_NUMBER=0,TIME_TYPE=0,POST_POINT="N",
TRANS_TYPE=1,COMMENT="End\ song"
Database connection restored.


That repeats a lot, then I get the part you mention:
QTime::setHMS Invalid time 83:00:00.000
QTime::setHMS Invalid time 83:00:00.000
QTime::setHMS Invalid time 83:00:00.000
QTime::setHMS Invalid time 83:00:00.000
QTime::setHMS Invalid time 83:00:00.000
QTime::setHMS Invalid time 83:00:00.000

And nothing after it. Would the MySQL insert fails be causing my issues
due to duplicate keys?

Checking the db structure I have:
mysql> describe 2013_01_15_LOG;
+-------------------+------------------+------+-----+---------+-------+
| Field             | Type             | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+-------+
| ID                | int(11)          | NO   | PRI | NULL    |       |
| COUNT             | int(11)          | NO   | MUL | NULL    |       |
| TYPE              | int(11)          | YES  |     | 0       |       |
| SOURCE            | int(11)          | NO   |     | NULL    |       |
| START_TIME        | int(11)          | YES  |     | NULL    |       |
| GRACE_TIME        | int(11)          | YES  |     | 0       |       |
| CART_NUMBER       | int(10) unsigned | NO   | MUL | NULL    |       |
| TIME_TYPE         | int(11)          | NO   |     | NULL    |       |
| POST_POINT        | enum('N','Y')    | YES  |     | N       |       |
| TRANS_TYPE        | int(11)          | NO   |     | NULL    |       |
| START_POINT       | int(11)          | NO   |     | -1      |       |
| END_POINT         | int(11)          | NO   |     | -1      |       |
| FADEUP_POINT      | int(11)          | YES  |     | -1      |       |
| FADEUP_GAIN       | int(11)          | YES  |     | -3000   |       |
| FADEDOWN_POINT    | int(11)          | YES  |     | -1      |       |
| FADEDOWN_GAIN     | int(11)          | YES  |     | -3000   |       |
| SEGUE_START_POINT | int(11)          | NO   |     | -1      |       |
| SEGUE_END_POINT   | int(11)          | NO   |     | -1      |       |
| SEGUE_GAIN        | int(11)          | YES  |     | -3000   |       |
| DUCK_UP_GAIN      | int(11)          | YES  |     | 0       |       |
| DUCK_DOWN_GAIN    | int(11)          | YES  |     | 0       |       |
| COMMENT           | char(255)        | YES  |     | NULL    |       |
| LABEL             | char(64)         | YES  | MUL | NULL    |       |
| ORIGIN_USER       | char(255)        | YES  |     | NULL    |       |
| ORIGIN_DATETIME   | datetime         | YES  |     | NULL    |       |
| LINK_EVENT_NAME   | char(64)         | YES  |     | NULL    |       |
| LINK_START_TIME   | int(11)          | YES  |     | NULL    |       |
| LINK_LENGTH       | int(11)          | YES  |     | 0       |       |
| LINK_START_SLOP   | int(11)          | YES  |     | 0       |       |
| LINK_END_SLOP     | int(11)          | YES  |     | 0       |       |
| LINK_ID           | int(11)          | YES  |     | -1      |       |
| LINK_EMBEDDED     | enum('N','Y')    | YES  |     | N       |       |
| EXT_START_TIME    | time             | YES  |     | NULL    |       |
| EXT_LENGTH        | int(11)          | YES  |     | NULL    |       |
| EXT_CART_NAME     | char(32)         | YES  |     | NULL    |       |
| EXT_DATA          | char(32)         | YES  |     | NULL    |       |
| EXT_EVENT_ID      | char(32)         | YES  |     | NULL    |       |
| EXT_ANNC_TYPE     | char(8)          | YES  |     | NULL    |       |
+-------------------+------------------+------+-----+---------+-------+


Any further hints?




On 13/01/13 21:34, Wayne Merricks wrote:
> Hi,
> 
> Seems odd that its skipping the 00 event, I assume there is audio available in the MUSIC category? (btw why not have both in music and use the code latest?).
> 
> Try running log manager from a command line you sometimes get more errors than the GUI.
> 
> 
> rdlogmanager -g -d 0 -s Production
> 
> -d 0 = today, -d 1 = tomorrow etc.
> -s Production is your rivendell service name, Production is the default.
> 
> You'll probably get QTIME errors saying something like 86:00:00 is not a valid QTIME ignore those and pay attention to the rest of the stuff that follows immediately after that.
> 
> Regards,
> 
> Wayne
> 
> -----Original Message-----
> From: rivendell-dev-bounces at lists.rivendellaudio.org on behalf of Andy Brown
> Sent: Sun 13/01/2013 20:56
> To: rivendell-dev at lists.rivendellaudio.org
> Subject: [RDD] RDLogmanager and clocks
>  
> Hi all,
> I'm new to Rivendell, look after a few community FM radio stations here
> in the UK and looking to migrate them all over to Rivendell as its
> looking impressive!
> 
> Have done a manual install on Ubuntu, got everything all up and running.
> Rivendell version: 2.2.0
> 
> Everything is looking good, audio fine (using Jack), streaming using
> Darkice, etc.
> However I have an issue using RDLogmanager to create hour clocks and
> generate them. I have followed the guide at thebrettblog (Fab guide
> btw), but think I've missed something or there is a new tweak that I'm
> missing. A basic rundown:
> 
> Events: I have 3 setup:
>   TOTH Opener (Use hard start time, Make Next, PRE-IMPORT the 7 second
> toth opener and set it to my service)
>   Latest music (Import, select from "Latest", Title separation 100, Must
> have code "Latest", imported carts have a play transition)
>   00s music (Import, select from "MUSIC", Title separation 100, Must
> have code "00s", imported carts have a play transition)
> 
> Clocks: 24x7 setup [THIS MAY ME WHERE I GO WRONG!]:
> TOTH Opener at 00:00.0, end 00:07.0
> Latest Music start 00:07.0 end 03:00.0
> 00s start 03:00.0 end 06:00.0
> (and so on, repeating Latest Music and 00s to fill the hour)
> Scheduler rules, the two categories have max in a row set to 999
> Services list again set.
> 
> Grids: I've setup this 24x7 to every entry in GRIDS
> 
> I go to Generate Logs and select today/tomorrows date, select my service
> and generate. It takes about 15 seconds and says "No exceptions found" -
> so kinda good!
> 
> But when I check the schedule its created it does:
> 
> TOTH opener audio - Time 00:00:00.0 Length: :07
> Latest song - Time 00:00:07.0 Length: 3:42
> TOTH opener audio - Time 01:00:00.0 Length: :07
> Latest song - Time 01:00:07.0 Length: 3:01
> 
> And so on, just those two keep repeating, interestingly they repeat 24
> times (i.e. one for each hour of the day)
> Then a Segue to the next day.
> 
> Can anyone spot from the above what I'm doing wrong, or what further
> info I can provide to try and figure this out!
> 
> Thanks in advance folks
> 
> 
> 
> _______________________________________________
> Rivendell-dev mailing list
> Rivendell-dev at lists.rivendellaudio.org
> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
> 


-- 
Andy
e: andy @ thebmwz3.co.uk
w: http://www.thebmwz3.co.uk
g: https://github.com/andyb2000/


More information about the Rivendell-dev mailing list