[RDD] Ubuntu 16.04 w/ 2.16.0 Log Generation Errors

Nick Andre nick at wmfo.org
Tue Jun 20 14:28:48 EDT 2017


Thanks Thomas!

On Mon, Jun 19, 2017 at 3:55 PM Thomas Golding <thomasg at worldradiolink.com>
wrote:

> 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 <(208)%20944-9624>
> t.f.888.533.3551x14 <(888)%20533-3551>
>
> 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)
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20170620/6357cbdc/attachment.html>


More information about the Rivendell-dev mailing list