You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ambari.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2018/06/05 14:20:00 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=16501855#comment-16501855 ]
Hudson commented on AMBARI-23996:
---------------------------------
FAILURE: Integrated in Jenkins build Ambari-trunk-Commit #9405 (See [https://builds.apache.org/job/Ambari-trunk-Commit/9405/])
[AMBARI-23996] Changing column type from timestamp to long in (github: [https://gitbox.apache.org/repos/asf?p=ambari.git&a=commit&h=3876e39fbd8fca4f2d346b8f5ca419fc82b1c592])
* (edit) ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog270.java
* (edit) ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql
* (edit) ambari-server/src/test/java/org/apache/ambari/server/security/authentication/jwt/AmbariJwtAuthenticationFilterTest.java
* (edit) ambari-server/src/main/java/org/apache/ambari/server/security/authorization/User.java
* (edit) ambari-server/src/test/java/org/apache/ambari/server/security/ldap/AmbariLdapDataPopulatorTest.java
* (edit) ambari-server/src/main/java/org/apache/ambari/server/controller/internal/UserAuthenticationSourceResourceProvider.java
* (edit) ambari-server/src/main/java/org/apache/ambari/server/orm/entities/UserAuthenticationEntity.java
* (edit) ambari-server/src/test/java/org/apache/ambari/server/controller/internal/UserAuthenticationSourceResourceProviderTest.java
* (edit) ambari-server/src/main/java/org/apache/ambari/server/controller/internal/UserResourceProvider.java
* (edit) ambari-server/src/main/java/org/apache/ambari/server/orm/entities/UserEntity.java
* (edit) ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql
* (edit) ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql
* (edit) ambari-server/src/test/java/org/apache/ambari/server/controller/internal/UserResourceProviderTest.java
* (edit) ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql
* (edit) ambari-server/src/test/java/org/apache/ambari/server/upgrade/UpgradeCatalog270Test.java
* (edit) ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql
* (edit) ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql
> 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)