Dear Fred,
Here is the output from the mysqlbin.logs...
I have included the creation of the cart (Note second cart Title was mispelled
and user corrected it). Problem is
on the Title Column only of CART.
I then added the mysqlbin logs of the entire update of those CARTS which
happened on our catch machine
Figured that out by tracing the thread ID 3972781 in the actual mysql logs.
The first cart number is 200210, second 200212.
(Machine origin name was changed...)...
Todd
******************************** CART 200210
*************************************************************
#at 8340696
#130319 9:51:36 server id 1 end_log_pos 8341052 Query
thread_id=3971543 exec_time=0 error_code=0
SET TIMESTAMP=1363701096;
insert into CART set
NUMBER=200210,TYPE=1,GROUP_NAME="LAOTIAN",TITLE="L0319-PM",
YEAR=NULL,ARTIST="",ALBUM="", LABEL="",CLIENT="",AGENCY="",
FORCED_LENGTH=3600060,AVERAGE_LENGTH=3600060,AVERAGE_SEGUE_LENGTH=3600060,
VALIDITY=1,CUT_QUANTITY=1;
# at 8341052
#130319 9:51:36 server id 1 end_log_pos 8341513 Query
thread_id=3971543 exec_time=0 error_code=0
SET TIMESTAMP=1363701096;
insert into CUTS set CUT_NAME="200210_001",
CART_NUMBER="200210",DESCRIPTION="Tuesday March 19,
2013(PM/Show)",LENGTH=3600060,
CODING_FORMAT=0,SAMPLE_RATE=44100,BIT_RATE=0,CHANNELS=1,
ORIGIN_NAME="XXXXXX-XX",ORIGIN_DATETIME="2013-03-19 09:51:36",
START_POINT=0,END_POINT=3600060,VALIDITY=1,START_DATETIME="2013-03-19",END_DATETIME="2013-05-18";
#at 22003556
#130319 22:01:11 server id 1 end_log_pos 22003677 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET TITLE="L0319-PM1" WHERE NUMBER=200210;
# at 22003677
#
*************** End Cart 200210 ***********************
**********************CART 200212 *********************
SET TIMESTAMP=1363721403;
insert into CART set
NUMBER=200212,TYPE=1,GROUP_NAME="LAOTIAN",TITLE="L0319-MPE",
YEAR=NULL,ARTIST="",ALBUM="", LABEL="",CLIENT="",AGENCY="",
FORCED_LENGTH=3600044,AVERAGE_LENGTH=3600044,AVERAGE_SEGUE_LENGTH=3600044,
CUT_QUANTITY=1;
# at 15216218
#130319 15:30:03 server id 1 end_log_pos 15216668 Query
thread_id=3972578 exec_time=0 error_code=0
SET TIMESTAMP=1363721403;
insert into CUTS set CUT_NAME="200212_001",
CART_NUMBER=200212,DESCRIPTION="TUESDAY, MARCH 19, 2013 (PM
SHOW)",LENGTH=3600044,
CODING_FORMAT=0,SAMPLE_RATE=44100,BIT_RATE=0,CHANNELS=1,
ORIGIN_NAME="XXXXXX-XX",ORIGIN_DATETIME="2013-03-19 15:30:03",
START_POINT=0,END_POINT=3600044,START_DATETIME="2013-03-19",END_DATETIME="2013-05-18";
# at 15216668
#130319 15:30:08 server id 1 end_log_pos 15216772 Query
thread_id=3972582 exec_time=0 error_code=0
# at 15297877
#130319 15:34:12 server id 1 end_log_pos 15298245 Query
thread_id=3972597 exec_time=0 error_code=0
SET TIMESTAMP=1363721652;
update CART set TYPE=1,GROUP_NAME="LAOTIAN",TITLE="L0319-PME",
YEAR=NULL,ARTIST="",ALBUM="", LABEL="",CLIENT="",AGENCY="",
FORCED_LENGTH=3600044,AVERAGE_LENGTH=3600044,AVERAGE_SEGUE_LENGTH=3600044,
CUT_QUANTITY=1 where NUMBER=200212;
# at 15298245
#130319 15:34:12 server id 1 end_log_pos 15298773 Query
thread_id=3972597 exec_time=0 error_code=0
SET TIMESTAMP=1363721652;
update CUTS set CART_NUMBER=200212,DESCRIPTION="TUESDAY, MARCH 19, 2013 (PM
SHOW)",
LENGTH=3600044,CODING_FORMAT=0,SAMPLE_RATE=44100,BIT_RATE=0,
CHANNELS=1,ORIGIN_NAME="XXXXXX-XX",ORIGIN_DATETIME="2013-03-19 15:34:12",
SUN="Y",MON="Y",TUE="Y",WED="Y",THU="Y",FRI="Y",SAT="Y",
START_POINT=0,END_POINT=3600044,START_DATETIME="2013-03-19",END_DATETIME="2013-05-18",EVERGREEN="N"
where CUT_NAME="200212_001";
# at 22006694
#130319 22:01:14 server id 1 end_log_pos 22006814 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET TITLE="L0319-PM" WHERE NUMBER=200212;
*********************** End Cart 200212
********************************************
The part that changed both of these carts happens below at around 22:01 .
Included all of the transactions so you
can see what I mean about system doing this.........
***************** *************** ****************** *******************
# at 22001915
#130319 22:01:11 server id 1 end_log_pos 22002039 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET GROUP_NAME="LAOTIAN" WHERE NUMBER=200210;
# at 22002039
#130319 22:01:11 server id 1 end_log_pos 22002161 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET LENGTH_DEVIATION=0 WHERE NUMBER=200210;
# at 22002161
#130319 22:01:11 server id 1 end_log_pos 22002287 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET AVERAGE_LENGTH=3600060 WHERE NUMBER=200210;
# at 22002287
#130319 22:01:11 server id 1 end_log_pos 22002419 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET AVERAGE_SEGUE_LENGTH=3600060 WHERE NUMBER=200210;
# at 22002419
#130319 22:01:11 server id 1 end_log_pos 22002544 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET AVERAGE_HOOK_LENGTH=0 WHERE NUMBER=200210;
# at 22002544
#130319 22:01:11 server id 1 end_log_pos 22002669 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET FORCED_LENGTH=3600060 WHERE NUMBER=200210;
# at 22002669
#130319 22:01:11 server id 1 end_log_pos 22002787 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET CUT_QUANTITY=1 WHERE NUMBER=200210;
# at 22002787
#130319 22:01:11 server id 1 end_log_pos 22002909 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
update CUTS set VALIDITY=1 where CUT_NAME="200210_001";
# at 22002909
#130319 22:01:11 server id 1 end_log_pos 22003061 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
update CART set START_DATETIME=NULL,END_DATETIME=NULL,VALIDITY=1 where
NUMBER=200210;
# at 22003061
#130319 22:01:11 server id 1 end_log_pos 22003187 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET AVERAGE_LENGTH=3600000 WHERE NUMBER=200210;
# at 22003187
#130319 22:01:11 server id 1 end_log_pos 22003312 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET FORCED_LENGTH=3600000 WHERE NUMBER=200210;
# at 22003312
#130319 22:01:11 server id 1 end_log_pos 22003434 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET ENFORCE_LENGTH="N" WHERE NUMBER=200210;
# at 22003434
#130319 22:01:11 server id 1 end_log_pos 22003556 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET PRESERVE_PITCH="N" WHERE NUMBER=200210;
# at 22003556
#130319 22:01:11 server id 1 end_log_pos 22003677 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET TITLE="L0319-PM1" WHERE NUMBER=200210;
# at 22003677
#130319 22:01:11 server id 1 end_log_pos 22003790 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET YEAR=NULL WHERE NUMBER=200210;
# at 22003790
#130319 22:01:11 server id 1 end_log_pos 22003908 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET SCHED_CODES="" WHERE NUMBER=200210;
# at 22003908
#130319 22:01:11 server id 1 end_log_pos 22004021 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET ARTIST="" WHERE NUMBER=200210;
# at 22004021
#130319 22:01:11 server id 1 end_log_pos 22004133 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET ALBUM="" WHERE NUMBER=200210;
# at 22004133
#130319 22:01:11 server id 1 end_log_pos 22004245 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET LABEL="" WHERE NUMBER=200210;
# at 22004245
#130319 22:01:11 server id 1 end_log_pos 22004358 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET CLIENT="" WHERE NUMBER=200210;
# at 22004358
#130319 22:01:11 server id 1 end_log_pos 22004471 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET AGENCY="" WHERE NUMBER=200210;
# at 22004471
#130319 22:01:11 server id 1 end_log_pos 22004587 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET PUBLISHER="" WHERE NUMBER=200210;
# at 22004587
#130319 22:01:11 server id 1 end_log_pos 22004702 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET COMPOSER="" WHERE NUMBER=200210;
# at 22004702
#130319 22:01:11 server id 1 end_log_pos 22004821 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET USER_DEFINED="" WHERE NUMBER=200210;
# at 22004821
#130319 22:01:11 server id 1 end_log_pos 22004937 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET USAGE_CODE=0 WHERE NUMBER=200210;
# at 22004937
#130319 22:01:11 server id 1 end_log_pos 22005053 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744871;
UPDATE CART SET PLAY_ORDER=0 WHERE NUMBER=200210;
# at 22005053
#130319 22:01:14 server id 1 end_log_pos 22005177 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET GROUP_NAME="LAOTIAN" WHERE NUMBER=200212;
# at 22005177
#130319 22:01:14 server id 1 end_log_pos 22005299 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET LENGTH_DEVIATION=0 WHERE NUMBER=200212;
# at 22005299
#130319 22:01:14 server id 1 end_log_pos 22005425 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET AVERAGE_LENGTH=3600044 WHERE NUMBER=200212;
# at 22005425
#130319 22:01:14 server id 1 end_log_pos 22005557 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET AVERAGE_SEGUE_LENGTH=3600044 WHERE NUMBER=200212;
# at 22005557
#130319 22:01:14 server id 1 end_log_pos 22005682 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET AVERAGE_HOOK_LENGTH=0 WHERE NUMBER=200212;
# at 22005682
#130319 22:01:14 server id 1 end_log_pos 22005807 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET FORCED_LENGTH=3600044 WHERE NUMBER=200212;
# at 22005807
#130319 22:01:14 server id 1 end_log_pos 22005925 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET CUT_QUANTITY=1 WHERE NUMBER=200212;
# at 22005925
#130319 22:01:14 server id 1 end_log_pos 22006047 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
update CUTS set VALIDITY=1 where CUT_NAME="200212_001";
# at 22006047
#130319 22:01:14 server id 1 end_log_pos 22006199 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
update CART set START_DATETIME=NULL,END_DATETIME=NULL,VALIDITY=1 where
NUMBER=200212;
# at 22006199
#130319 22:01:14 server id 1 end_log_pos 22006325 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET AVERAGE_LENGTH=3600000 WHERE NUMBER=200212;
# at 22006325
#130319 22:01:14 server id 1 end_log_pos 22006450 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET FORCED_LENGTH=3600000 WHERE NUMBER=200212;
# at 22006450
#130319 22:01:14 server id 1 end_log_pos 22006572 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET ENFORCE_LENGTH="N" WHERE NUMBER=200212;
# at 22006572
#130319 22:01:14 server id 1 end_log_pos 22006694 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET PRESERVE_PITCH="N" WHERE NUMBER=200212;
# at 22006694
#130319 22:01:14 server id 1 end_log_pos 22006814 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET TITLE="L0319-PM" WHERE NUMBER=200212;
# at 22006814
#130319 22:01:14 server id 1 end_log_pos 22006927 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET YEAR=NULL WHERE NUMBER=200212;
# at 22006927
#130319 22:01:14 server id 1 end_log_pos 22007045 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET SCHED_CODES="" WHERE NUMBER=200212;
# at 22007045
#130319 22:01:14 server id 1 end_log_pos 22007158 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET ARTIST="" WHERE NUMBER=200212;
# at 22007158
#130319 22:01:14 server id 1 end_log_pos 22007270 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET ALBUM="" WHERE NUMBER=200212;
# at 22007270
#130319 22:01:14 server id 1 end_log_pos 22007382 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET LABEL="" WHERE NUMBER=200212;
# at 22007382
#130319 22:01:14 server id 1 end_log_pos 22007495 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET CLIENT="" WHERE NUMBER=200212;
# at 22007495
#130319 22:01:14 server id 1 end_log_pos 22007608 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET AGENCY="" WHERE NUMBER=200212;
# at 22007608
#130319 22:01:14 server id 1 end_log_pos 22007724 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET PUBLISHER="" WHERE NUMBER=200212;
# at 22007724
#130319 22:01:14 server id 1 end_log_pos 22007839 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET COMPOSER="" WHERE NUMBER=200212;
# at 22007839
#130319 22:01:14 server id 1 end_log_pos 22007958 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET USER_DEFINED="" WHERE NUMBER=200212;
# at 22007958
#130319 22:01:14 server id 1 end_log_pos 22008074 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET USAGE_CODE=0 WHERE NUMBER=200212;
# at 22008074
#130319 22:01:14 server id 1 end_log_pos 22008190 Query
thread_id=3972781 exec_time=0 error_code=0
SET TIMESTAMP=1363744874;
UPDATE CART SET PLAY_ORDER=0 WHERE NUMBER=200212;
# at 22008190
********************************************************** End Of Output
**************************************
----- Original Message -----
From: "Fred Gleason" <[email protected]>
To: "User discussion about the Rivendell Radio Automation System"
<[email protected]>
Sent: Wednesday, March 27, 2013 10:29:10 AM
Subject: Re: [RDD] Strange Cart Title Problem Probably a Name Conflict and a
Race/regex bug?
On Mar 26, 2013, at 10:39 56, Todd Baker wrote:
> Maybe the regex expression in the code is geting a name match and is somehow
> deciding to change the name so as to fix the conflict? Duplicate Cart Titles
> are not allowed in our Database. It's close enough that a regular expression
> match could occur, and if it doesn't look at the entire string it may assume
> a conflict and try to work around it?
Do you know the precise SQL statement that's making the change? You should be
able to pull that from the MySQL binlogs.
Cheers!
|-------------------------------------------------------------------------|
| Frederick F. Gleason, Jr. | Chief Developer |
| | Paravel Systems |
|-------------------------------------------------------------------------|
| A room without books is like a body without a soul. |
| -- Cicero |
|-------------------------------------------------------------------------|
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
