You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ambari.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/06/04 13:59:00 UTC
[jira] [Updated] (AMBARI-23996) Ambari server installation failing
on debian cluster with mysql db
[ https://issues.apache.org/jira/browse/AMBARI-23996?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated AMBARI-23996:
------------------------------------
Labels: pull-request-available (was: )
> 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
>
>
> 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)