[
https://issues.apache.org/jira/browse/AMBARI-23996?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sandor Molnar updated AMBARI-23996:
-----------------------------------
Status: Patch Available (was: Open)
> 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
> Priority: Critical
> Labels: pull-request-available
> Fix For: 2.7.0
>
> Time Spent: 1h 20m
> Remaining Estimate: 0h
>
> 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)
