[RDD] Incorrect date value: '' for column 'PURGE_DATE'

Thomas Golding thomasg at worldradiolink.com
Mon Jun 12 14:20:56 EDT 2017


Fred and fellow RDDev'ers,

After upgrading mysql to mariadb 10.2 with Galera clustering enabled, I'm
getting this from RDLogManager:

invalid SQL or failed DB connection[Incorrect date value: '' for column
'PURGE_DATE' at row 1 QMYSQL3: Unable to execute query]: update LOGS set
SERVICE="RadioTraff",                           DESCRIPTION="RadioTraff\
log\ for\ 06/13/2017",ORIGIN_USER="RDLogManager",
ORIGIN_DATETIME=now(),LINK_DATETIME=now(),
MODIFIED_DATETIME=now(),START_DATE=null,
END_DATE=null,NEXT_ID=0,PURGE_DATE="" where NAME="tue"

Database connection failed: update LOGS set SERVICE="RadioTraff",
DESCRIPTION="RadioTraff\ log\ for\ 06/13/2017",ORIGIN_USER="RDLogManager",
ORIGIN_DATETIME=now(),LINK_DATETIME=now(),
MODIFIED_DATETIME=now(),START_DATE=null,
END_DATE=null,NEXT_ID=0,PURGE_DATE="" where NAME="tue"
Database connection restored.

invalid SQL or failed DB connection[Field 'TIME_TYPE' doesn't have a default
value QMYSQL3: Unable to execute query]: insert into `tue_LOG` set
ID=552,COUNT=552,TYPE=5,SOURCE=3,TRANS_TYPE=1,LABEL="wed"

Database connection failed: insert into `tue_LOG` set
ID=552,COUNT=552,TYPE=5,SOURCE=3,TRANS_TYPE=1,LABEL="wed"
Database connection restored.

Rddbcheck says everything is ok. Also, all the other Rivendell components
seem to be working fine.

Do I have a corrupted database or is something just misconfigured? Is there
an easy was to confirm the integrity of the database schema?

Thanks for your thoughts,

Thomas Golding
Engineering Manager
Edgewater Broadcasting




More information about the Rivendell-dev mailing list