[RDD] Ubuntu 16.04 w/ 2.16.0 Log Generation Errors

Thomas Golding thomasg at worldradiolink.com
Mon Jun 19 18:55:44 EDT 2017


Fred,

"NOT NULL DEFAULT NULL" is not a legal combination in strict mode. Looks like the schema upgrade routine in 2.16 misses some strict mode issues. I didn’t notice before but this is exactly what I was running in to last week.

Nick,

See https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-strict for info on how to turn off mysql strict mode.

Thanks,

Thomas Golding
Engineering Manager
Edgewater Broadcasting
p.208.944.9624
t.f.888.533.3551x14

From: rivendell-dev-bounces at lists.rivendellaudio.org [mailto:rivendell-dev-bounces at lists.rivendellaudio.org] On Behalf Of Nick Andre
Sent: Monday, June 19, 2017 2:35 PM
To: rivendellDev
Subject: [RDD] Ubuntu 16.04 w/ 2.16.0 Log Generation Errors

We're getting some MySQL errors when we create the log through the command line interface related to database schema.

Rivendell 2.16.0 with Ubuntu 16.04
mysql  Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using  EditLine wrapper

Running:
/usr/local/bin/rdlogmanager -g -m -s Automation -d 0
The result is:
invalid SQL or failed DB connection[Field 'TIME_TYPE' doesn't have a default value QMYSQL3: Unable to execute query]: insert into `2017_06_20_LOG` set ID=816,COUNT=816,TYPE=5,SOURCE=3,TRANS_TYPE=1,LABEL="2017_06_21"
rdlogmanager: invalid SQL or failed DB connection[Field 'TIME_TYPE' doesn't have a default value QMYSQL3: Unable to execute query]: insert into `2017_06_20_LOG` set ID=816,COUNT=816,TYPE=5,SOURCE=3,TRANS_TYPE=1,LABEL="2017_06_21"
Database connection failed: insert into `2017_06_20_LOG` set ID=816,COUNT=816,TYPE=5,SOURCE=3,TRANS_TYPE=1,LABEL="2017_06_21"
Database connection restored.
Rivendell Log Exception Report
Generated at: 06/19/2017 - 15:00:46
Log: 2017_06_20
Effective Airdate: 06/20/2017


0 exceptions found. 

mysql> desc 2017_06_20_LOG;
+-------------------+------------------+------+-----+---------+-------+
| Field             | Type             | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+-------+
| ID                | int(11)          | NO   | PRI | NULL    |       |
| COUNT             | int(11)          | NO   | MUL | NULL    |       |
| TYPE              | int(11)          | YES  |     | 0       |       |
| SOURCE            | int(11)          | NO   |     | NULL    |       |
| START_TIME        | int(11)          | YES  |     | NULL    |       |
| GRACE_TIME        | int(11)          | YES  |     | 0       |       |
| CART_NUMBER       | int(10) unsigned | NO   | MUL | 0       |       |
| TIME_TYPE         | int(11)          | NO   |     | NULL    |       |
| POST_POINT        | enum('N','Y')    | YES  |     | N       |       |
| TRANS_TYPE        | int(11)          | NO   |     | NULL    |       |
| START_POINT       | int(11)          | NO   |     | -1      |       |
| END_POINT         | int(11)          | NO   |     | -1      |       |
| FADEUP_POINT      | int(11)          | YES  |     | -1      |       |
| FADEUP_GAIN       | int(11)          | YES  |     | -3000   |       |
| FADEDOWN_POINT    | int(11)          | YES  |     | -1      |       |
| FADEDOWN_GAIN     | int(11)          | YES  |     | -3000   |       |
| SEGUE_START_POINT | int(11)          | NO   |     | -1      |       |
| SEGUE_END_POINT   | int(11)          | NO   |     | -1      |       |
| SEGUE_GAIN        | int(11)          | YES  |     | -3000   |       |
| DUCK_UP_GAIN      | int(11)          | YES  |     | 0       |       |
| DUCK_DOWN_GAIN    | int(11)          | YES  |     | 0       |       |
| COMMENT           | char(255)        | YES  |     | NULL    |       |
| LABEL             | char(64)         | YES  | MUL | NULL    |       |
| ORIGIN_USER       | char(255)        | YES  |     | NULL    |       |
| ORIGIN_DATETIME   | datetime         | YES  |     | NULL    |       |
| EVENT_LENGTH      | int(11)          | YES  |     | -1      |       |
| LINK_EVENT_NAME   | char(64)         | YES  |     | NULL    |       |
| LINK_START_TIME   | int(11)          | YES  |     | NULL    |       |
| LINK_LENGTH       | int(11)          | YES  |     | 0       |       |
| LINK_START_SLOP   | int(11)          | YES  |     | 0       |       |
| LINK_END_SLOP     | int(11)          | YES  |     | 0       |       |
| LINK_ID           | int(11)          | YES  |     | -1      |       |
| LINK_EMBEDDED     | enum('N','Y')    | YES  |     | N       |       |
| EXT_START_TIME    | time             | YES  |     | NULL    |       |
| EXT_LENGTH        | int(11)          | YES  |     | NULL    |       |
| EXT_CART_NAME     | char(32)         | YES  |     | NULL    |       |
| EXT_DATA          | char(32)         | YES  |     | NULL    |       |
| EXT_EVENT_ID      | char(32)         | YES  |     | NULL    |       |
| EXT_ANNC_TYPE     | char(8)          | YES  |     | NULL    |       |
+-------------------+------------------+------+-----+---------+-------+
39 rows in set (0.00 sec)




More information about the Rivendell-dev mailing list