[RDD] Ubuntu 16.04 w/ 2.16.0 Log Generation Errors

Nick Andre nick at wmfo.org
Mon Jun 19 16:34:35 EDT 2017


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


More information about the Rivendell-dev mailing list