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: [email protected] on behalf of Andy Brown
> Sent: Sun 13/01/2013 20:56
> To: [email protected]
> 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
> [email protected]
> 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/
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
