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 [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
