-
Type: Bug
-
Status: Resolved
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Tags:
-
Team:AT
-
Sprint:nxAT Sprint 9.1.3
19:27:11 [ERROR] [sql] Failed to execute: GRANT USAGE on *.* TO userjabba2@'%' 19:27:11 [ERROR] 19:27:11 BUILD FAILED - at 1/7/17 7:27 PM 19:27:11 /opt/jenkins/workspace/7.10/addons_nuxeo-drive-server-7.10-multidb/PYTHON/System-CPython-2.7/Slave/MULTIDB_LINUX_710/dbprofile/mysql/jdk/java-8-oracle/target/nuxeo-ftest.xml:1302: The following error occurred while executing this line: 19:27:11 /opt/jenkins/workspace/7.10/addons_nuxeo-drive-server-7.10-multidb/PYTHON/System-CPython-2.7/Slave/MULTIDB_LINUX_710/dbprofile/mysql/jdk/java-8-oracle/target/nuxeo-ftest.xml:1173: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't find any matching row in the user table 19:27:11 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 19:27:11 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 19:27:11 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 19:27:11 at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 19:27:11 at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) 19:27:11 at com.mysql.jdbc.Util.getInstance(Util.java:387) 19:27:11 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942) 19:27:11 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966) 19:27:11 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902) 19:27:11 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526) 19:27:11 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673) 19:27:11 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) 19:27:11 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) 19:27:11 at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839) 19:27:11 at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739) 19:27:11 at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:794) 19:27:11 at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:764) 19:27:11 at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:1065) 19:27:11 at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:1007) 19:27:11 at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:672) 19:27:11 at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:293) 19:27:11 at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) 19:27:11 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 19:27:11 at java.lang.reflect.Method.invoke(Method.java:498) 19:27:11 at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) 19:27:11 at org.apache.tools.ant.Task.perform(Task.java:348) 19:27:11 at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68) 19:27:11 at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:293) 19:27:11 at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) 19:27:11 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 19:27:11 at java.lang.reflect.Method.invoke(Method.java:498) 19:27:11 at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) 19:27:11 at org.apache.tools.ant.Task.perform(Task.java:348) 19:27:11 at org.apache.tools.ant.taskdefs.Parallel$TaskRunnable.run(Parallel.java:454) 19:27:11 at java.lang.Thread.run(Thread.java:745)
Mathieu Guillaume says:
That's due to the mysql upgrade, the grant used to create the user if it didn't exist so we could drop it without error afterwards, but that doesn't work anymore. The way we do it was changed in ftest (in mysql-dbdrop), but I guess it would have to be backported to the ftest versions maintenance branches use
this was
NXBT-1130
- depends on
-
NXBT-1130 Add MariaDB to CI
- Resolved