Sandor Molnar created AMBARI-23996:
--------------------------------------
Summary: Ambari server installation failing on debian cluster with
mysql db
Key: AMBARI-23996
URL: https://issues.apache.org/jira/browse/AMBARI-23996
Project: Ambari
Issue Type: Bug
Components: ambari-server
Affects Versions: 2.7.0
Reporter: Sandor Molnar
Assignee: Sandor Molnar
Fix For: 2.7.0
Ambari server install is failing at db create phase
{noformat}
2018-05-28
09:49:40,565|executor.py.165|DEBUG|13917|MainThread|172.27.17.22|executing the
command='mysql --user=ambaricustomuser --password=bigdatacustom <
/tmp/createDB.sql'
2018-05-28 09:49:40,822|executor.py.165|DEBUG|13917|Thread-165|stdout: mysql:
[Warning] Using a password on the command line interface can be insecure.
2018-05-28 09:49:40,822|executor.py.165|DEBUG|13917|Thread-165|stdout: ERROR
1067 (42000) at line 330 in file: '/tmp/Ambari-DDL-MySQL-CREATE.sql': Invalid
default value for 'update_time'
2018-05-28 09:49:40,822|executor.py.128|ERROR|13917|MainThread|command='mysql
--user=ambaricustomuser --password=bigdatacustom < /tmp/createDB.sql' execution
failed with exitcode=1
2018-05-28 09:49:40,823|executor.py.116|INFO|13917|MainThread|command='mysql
--user=ambaricustomuser --password=bigdatacustom < /tmp/createDB.sql' execution
re-try #1
2018-05-28 09:49:41,250|executor.py.165|DEBUG|13917|Thread-166|stdout: mysql:
[Warning] Using a password on the command line interface can be insecure.
2018-05-28 09:49:41,250|executor.py.165|DEBUG|13917|Thread-166|stdout: ERROR
1067 (42000) at line 330 in file: '/tmp/Ambari-DDL-MySQL-CREATE.sql': Invalid
default value for 'update_time'
2018-05-28 09:49:41,251|executor.py.128|ERROR|13917|MainThread|command='mysql
--user=ambaricustomuser --password=bigdatacustom < /tmp/createDB.sql' execution
failed with exitcode=1
2018-05-28 09:49:41,252|executor.py.116|INFO|13917|MainThread|command='mysql
--user=ambaricustomuser --password=bigdatacustom < /tmp/createDB.sql' execution
re-try #2
2018-05-28 09:49:41,561|executor.py.165|DEBUG|13917|Thread-167|stdout: mysql:
[Warning] Using a password on the command line interface can be insecure.
2018-05-28 09:49:41,561|executor.py.165|DEBUG|13917|Thread-167|stdout: ERROR
1067 (42000) at line 330 in file: '/tmp/Ambari-DDL-MySQL-CREATE.sql': Invalid
default value for 'update_time'
2018-05-28 09:49:41,561|executor.py.128|ERROR|13917|MainThread|command='mysql
--user=ambaricustomuser --password=bigdatacustom < /tmp/createDB.sql' execution
failed with exitcode=1
{noformat}
Ambari server version - 2.7.0.0-568
Mysql version - 5.7.21
The root cause is (per documentation):
{noformat}
NOW() (or its synonyms) can be used as the default value for TIMESTAMP columns
as well as,
since MariaDB 10.0.1, DATETIME columns. Before MariaDB 10.0.1, it was only
possible for a single TIMESTAMP
column per table to contain the CURRENT_TIMESTAMP as its default.
{noformat}
In _user_authentication_ there is another TIMESTAMP column with default value
of CURRENT_TIMESTAMP called '_create_time_' and this causes the issue in older
versions (< v10).
For the sake of consistency the following columns' type should be changed to
BIGINT (defaulting to 0):
* users.create_time
* user_authentication.create_time
* user_authentication.update_time
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
