I’m trying to install htmengine-traffic-tutorial but facing issue on step “6. Apply database migration”. I tried to check around and found nothing. Besides, I found that found there’s similar issue related to mysql version 5.7.8+ in taurus app, and htm skeleton.
Appreciate if you can point me to where I can look to make change to successfully install this htm application.
P/S: system: ubuntu 16.04 LTS, nupic already installed, mysql 5.7.16-0ubuntu0.16.04.1 (Ubuntu)
Error log:
meharu@meharu-X3V3:~/htmengine-traffic-tutorial$ python python-engine/repository/migrate.py
INFO [sqlalchemy.engine.base.Engine] SHOW VARIABLES LIKE 'sql_mode'
INFO [sqlalchemy.engine.base.Engine] ()
INFO [sqlalchemy.engine.base.Engine] SELECT DATABASE()
INFO [sqlalchemy.engine.base.Engine] ()
INFO [sqlalchemy.engine.base.Engine] show collation where `Charset` = 'utf8' and `Collation` = 'utf8_bin'
INFO [sqlalchemy.engine.base.Engine] ()
INFO [sqlalchemy.engine.base.Engine] SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1
INFO [sqlalchemy.engine.base.Engine] ()
INFO [sqlalchemy.engine.base.Engine] SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1
INFO [sqlalchemy.engine.base.Engine] ()
INFO [sqlalchemy.engine.base.Engine] SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8) COLLATE utf8_bin AS anon_1
INFO [sqlalchemy.engine.base.Engine] ()
INFO [alembic.runtime.migration] Context impl MySQLImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
INFO [sqlalchemy.engine.base.Engine] DESCRIBE `alembic_version`
INFO [sqlalchemy.engine.base.Engine] ()
INFO [sqlalchemy.engine.base.Engine] SELECT alembic_version.version_num
FROM alembic_version
INFO [sqlalchemy.engine.base.Engine] ()
INFO [sqlalchemy.engine.base.Engine] DESCRIBE `alembic_version`
INFO [sqlalchemy.engine.base.Engine] ()
INFO [alembic.runtime.migration] Running upgrade -> 57ab75d58038, Initial htmengine
INFO [sqlalchemy.engine.base.Engine]
CREATE TABLE instance_status_history (
server VARCHAR(100) DEFAULT '' NOT NULL,
timestamp TIMESTAMP DEFAULT '0000-00-00 00:00:00',
status VARCHAR(32) DEFAULT '' NOT NULL,
PRIMARY KEY (server, timestamp)
)
INFO [sqlalchemy.engine.base.Engine] ()
INFO [sqlalchemy.engine.base.Engine] ROLLBACK
Traceback (most recent call last):
File "python-engine/repository/migrate.py", line 62, in <module>
migrate(options.version, offline=options.offline)
File "python-engine/repository/migrate.py", line 46, in migrate
alembic.command.upgrade(ALEMBIC_CONFIG, version, sql=offline)
File "/home/meharu/.local/lib/python2.7/site-packages/alembic/command.py", line 174, in upgrade
script.run_env()
File "/home/meharu/.local/lib/python2.7/site-packages/alembic/script/base.py", line 416, in run_env
util.load_python_file(self.dir, 'env.py')
File "/home/meharu/.local/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file
module = load_module_py(module_id, path)
File "/home/meharu/.local/lib/python2.7/site-packages/alembic/util/compat.py", line 79, in load_module_py
mod = imp.load_source(module_id, path, fp)
File "/home/meharu/htmengine-traffic-tutorial/python-engine/repository/migrations/env.py", line 100, in <module>
runMigrationsOnline()
File "/home/meharu/htmengine-traffic-tutorial/python-engine/repository/migrations/env.py", line 91, in runMigrationsOnline
context.run_migrations()
File "<string>", line 8, in run_migrations
File "/home/meharu/.local/lib/python2.7/site-packages/alembic/runtime/environment.py", line 797, in run_migrations
self.get_context().run_migrations(**kw)
File "/home/meharu/.local/lib/python2.7/site-packages/alembic/runtime/migration.py", line 314, in run_migrations
step.migration_fn(**kw)
File "/home/meharu/htmengine-traffic-tutorial/python-engine/repository/migrations/versions/000_57ab75d58038_initial_htmengine.py", line 50, in upgrade
sa.PrimaryKeyConstraint('server', 'timestamp')
File "<string>", line 8, in create_table
File "<string>", line 3, in create_table
File "/home/meharu/.local/lib/python2.7/site-packages/alembic/operations/ops.py", line 1098, in create_table
return operations.invoke(op)
File "/home/meharu/.local/lib/python2.7/site-packages/alembic/operations/base.py", line 318, in invoke
return fn(self, operation)
File "/home/meharu/.local/lib/python2.7/site-packages/alembic/operations/toimpl.py", line 101, in create_table
operations.impl.create_table(table)
File "/home/meharu/.local/lib/python2.7/site-packages/alembic/ddl/impl.py", line 194, in create_table
self._exec(schema.CreateTable(table))
File "/home/meharu/.local/lib/python2.7/site-packages/alembic/ddl/impl.py", line 118, in _exec
return conn.execute(construct, *multiparams, **params)
File "/home/meharu/.local/lib/python2.7/site-packages/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 720, in execute
return meth(self, multiparams, params)
File "/home/meharu/.local/lib/python2.7/site-packages/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/sql/ddl.py", line 67, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/meharu/.local/lib/python2.7/site-packages/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 774, in _execute_ddl
compiled
File "/home/meharu/.local/lib/python2.7/site-packages/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 947, in _execute_context
context)
File "/home/meharu/.local/lib/python2.7/site-packages/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1108, in _handle_dbapi_exception
exc_info
File "/home/meharu/.local/lib/python2.7/site-packages/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/util/compat.py", line 185, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/meharu/.local/lib/python2.7/site-packages/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 940, in _execute_context
context)
File "/home/meharu/.local/lib/python2.7/site-packages/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py", line 435, in do_execute
cursor.execute(statement, parameters)
File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 205, in execute
File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
sqlalchemy.exc.OperationalError: (OperationalError) (1067, "Invalid default value for 'timestamp'") "\nCREATE TABLE instance_status_history (\n\tserver VARCHAR(100) DEFAULT '' NOT NULL, \n\ttimestamp TIMESTAMP DEFAULT '0000-00-00 00:00:00', \n\tstatus VARCHAR(32) DEFAULT '' NOT NULL, \n\tPRIMARY KEY (server, timestamp)\n)\n\n" ()