Re: [RDD] RDAirPlay DB errors
Yep, the query works just fine. I also see the row added to the Production_SRT table so it seems to be executing. On May 15, 2015 2:27 AM, "Wayne Merricks" wrote: > Hi, > > Have you tried running that query in a mysql client directly? > > I had an issue with an old version of Riv where an operator had added a > clock called "HR3 " <-- notice the space, this was trimmed when Riv used it > but not when the table was created so I kept getting errors reported like > that "database lost, restored." > > It was obvious when I ran the SQL directly and got a "HR3 table does not > exist". > > Regards, > > Wayne Merricks > The Voice Asia > > On 15/05/15 07:09, Karl Koscher wrote: > >> insert into `Production_SRT` set >> LENGTH=308026,LOG_NAME="2015_05_11",LOG_ID=16,CART_NUMBER=10122,STATION_NAME="hill",EVENT_DATETIME="2015-05-11 >> 00:35:41",EVENT_TYPE=3,EVENT_SOURCE=2,EXT_START_TIME="00:33:00",EXT_LENGTH=0,EXT_DATA="",EXT_EVENT_ID="",EXT_ANNC_TYPE="",PLAY_SOURCE=1,CUT_NUMBER=1,EXT_CART_NAME="",TITLE="Master\ >> Blaster\ \(Jammin\'\)",ARTIST="Stevie\ >> Wonder",SCHEDULED_TIME="00:33:00",ISRC="",PUBLISHER="",COMPOSER="",USAGE_CODE=0,START_SOURCE=3,ONAIR_FLAG="N",ALBUM="Hotter\ >> Than\ July",LABEL="",USER_DEFINED="CD",CONDUCTOR="",SONG_ID="",ISCI="" >> > > ___ > Rivendell-dev mailing list > Rivendell-dev@lists.rivendellaudio.org > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] RDAirPlay DB errors
Hi, Have you tried running that query in a mysql client directly? I had an issue with an old version of Riv where an operator had added a clock called "HR3 " <-- notice the space, this was trimmed when Riv used it but not when the table was created so I kept getting errors reported like that "database lost, restored." It was obvious when I ran the SQL directly and got a "HR3 table does not exist". Regards, Wayne Merricks The Voice Asia On 15/05/15 07:09, Karl Koscher wrote: insert into `Production_SRT` set LENGTH=308026,LOG_NAME="2015_05_11",LOG_ID=16,CART_NUMBER=10122,STATION_NAME="hill",EVENT_DATETIME="2015-05-11 00:35:41",EVENT_TYPE=3,EVENT_SOURCE=2,EXT_START_TIME="00:33:00",EXT_LENGTH=0,EXT_DATA="",EXT_EVENT_ID="",EXT_ANNC_TYPE="",PLAY_SOURCE=1,CUT_NUMBER=1,EXT_CART_NAME="",TITLE="Master\ Blaster\ \(Jammin\'\)",ARTIST="Stevie\ Wonder",SCHEDULED_TIME="00:33:00",ISRC="",PUBLISHER="",COMPOSER="",USAGE_CODE=0,START_SOURCE=3,ONAIR_FLAG="N",ALBUM="Hotter\ Than\ July",LABEL="",USER_DEFINED="CD",CONDUCTOR="",SONG_ID="",ISCI="" ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
[RDD] RDAirPlay DB errors
Ever since we got started with Rivendell, RDAirPlay occasionally fails to chain to the next day's log. In the process of trying to debug this, I noticed RDAirPlay spitting out SQL errors occasionally, like so: invalid SQL or failed DB connection[Lost connection to MySQL server during query QMYSQL3: Unable to execute query]: insert into `Production_SRT` set LENGTH=308026,LOG_NAME="2015_05_11",LOG_ID=16,CART_NUMBER=10122,STATION_NAME="hill",EVENT_DATETIME="2015-05-11 00:35:41",EVENT_TYPE=3,EVENT_SOURCE=2,EXT_START_TIME="00:33:00",EXT_LENGTH=0,EXT_DATA="",EXT_EVENT_ID="",EXT_ANNC_TYPE="",PLAY_SOURCE=1,CUT_NUMBER=1,EXT_CART_NAME="",TITLE="Master\ Blaster\ \(Jammin\'\)",ARTIST="Stevie\ Wonder",SCHEDULED_TIME="00:33:00",ISRC="",PUBLISHER="",COMPOSER="",USAGE_CODE=0,START_SOURCE=3,ONAIR_FLAG="N",ALBUM="Hotter\ Than\ July",LABEL="",USER_DEFINED="CD",CONDUCTOR="",SONG_ID="",ISCI="" Database connection failed: insert into `Production_SRT` set LENGTH=308026,LOG_NAME="2015_05_11",LOG_ID=16,CART_NUMBER=10122,STATION_NAME="hill",EVENT_DATETIME="2015-05-11 00:35:41",EVENT_TYPE=3,EVENT_SOURCE=2,EXT_START_TIME="00:33:00",EXT_LENGTH=0,EXT_DATA="",EXT_EVENT_ID="",EXT_ANNC_TYPE="",PLAY_SOURCE=1,CUT_NUMBER=1,EXT_CART_NAME="",TITLE="Master\ Blaster\ \(Jammin\'\)",ARTIST="Stevie\ Wonder",SCHEDULED_TIME="00:33:00",ISRC="",PUBLISHER="",COMPOSER="",USAGE_CODE=0,START_SOURCE=3,ONAIR_FLAG="N",ALBUM="Hotter\ Than\ July",LABEL="",USER_DEFINED="CD",CONDUCTOR="",SONG_ID="",ISCI="" Database connection restored. However, looking at the traffic to MySQL with Wireshark, it doesn't look like the DB connection is dropping (or even returning an error). Any idea what's going on? There are also these errors, which may or may not be relevant: QSqlQuery::value: not positioned on a valid record QSqlQuery::value: not positioned on a valid record QSqlQuery::value: not positioned on a valid record QSqlQuery::value: not positioned on a valid record QTime::setHMS Invalid time 24:00:01.000 QTime::setHMS Invalid time 24:00:01.000 QTime::setHMS Invalid time 24:00:01.000 ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev