[RDD] RDAirPlay DB errors

Karl Koscher supersat at uwave.fm
Fri May 15 02:09:47 EDT 2015


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20150514/e28ba711/attachment.html>


More information about the Rivendell-dev mailing list