Uploaded image for project: 'Nuxeo ECM Build/Test Environment'
  1. Nuxeo ECM Build/Test Environment
  2. NXBT-1492

Fix MySQL usage on 7.10 jobs

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      See https://qa2.nuxeo.org/jenkins/view/Drive/job/7.10/job/addons_nuxeo-drive-server-7.10-multidb/159/PYTHON=System-CPython-2.7,Slave=MULTIDB_LINUX_710,dbprofile=mysql,jdk=java-8-oracle/console for instance:

      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

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: