How to solve error 1292 'incorrect datetime value' when trying to deploy environment with MySQL?

asked 2016-08-23 05:00:06 -0500

tercos gravatar image

When deploying environment with MySQL (SqlDatabase Library and Debian 8 x64 (pre-installed murano-agent) are insured) on Liberty/murano-api 1.0.2. murano log shows this error:

2016-08-22 14:13:16.395 10347 ERROR oslo_messaging.notify.dispatcher DBDataError: (_mysql_exceptions.OperationalError) (1292, "Incorrect datetime value: '2016-08-22 12:13:16+00:00' for column 'created' at row 1") [SQL: u'INSERT INTO status (created, updated, id, entity_id, entity, task_id, text, level, details) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)'] [parameters: (datetime. datetime(2016, 8, 22, 12, 13, 16, tzinfo=<iso8601.iso8601.utc object="" at="" 0x7f4c66c12fd0="">), datetime.datetime(2016, 8, 22, 12, 13, 16, 393720), 'f383a44a5cf249659054e13d3dc20862', 'd4eee574-a4c1-476a-9a64-cde94b6d84cf', None, 'f87513398bc64a63afcf247da972303b', 'Creating ecoster database.', 'info', None)]

When test command
mysql> INSERT INTO status (id, created, updated) VALUES (1, '2016-08-22 06:51:09+00:00', '2016-08-22 06:51:09+00:00');

is run on local computer, insertion is done, but on controller node ERROR 1292 occurrs as shown. It's something with datetime format, what should I change?

edit retag flag offensive close merge delete