java.io.IOException: org.hsqldb.HsqlException: user lacks privilege or object not found: MY\_TABLE

hsqldb | jcpalmer | 6 years ago
  1. 0

    Privledge problems after crash

    hsqldb | 6 years ago | jcpalmer
    java.io.IOException: org.hsqldb.HsqlException: user lacks privilege or object not found: MY\_TABLE
  2. 0

    Re: Failed to use sqoop-1.4.3 job tool on hadoop-2.1.0-beta

    apache.org | 11 months ago
    java.io.IOException: Invalid metadata version. >> at >> org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:202) >> >> at >> org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) >> at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) >> at org.apache.sqoop.Sqoop.run(Sqoop.java:145) >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) >> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) >> at org.apache.sqoop.Sqoop.main(Sqoop.java:238) >> >> >> 2) If I use hsqldb-1.8.0.10.jar in my env, the exception will be: >> Exception in thread "main" java.lang.NoSuchMethodError: >> org/hsqldb/DatabaseURL. >> parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties; >> at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) >> at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) >> at java.sql.DriverManager.getConnection(DriverManager.java:419) >> at java.sql.DriverManager.getConnection(DriverManager.java:467) >> at >> org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:176) >> at >> org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) >> at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) >> at org.apache.sqoop.Sqoop.run(Sqoop.java:145) >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) >> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) >> at org.apache.sqoop.Sqoop.main(Sqoop.java:238) >> >> >> >> 2013/11/19 sam liu <liuqiyun2011@gmail.com> >> Hi Experts, My cluster is hadoop-2.1.0-beta and it requires hsqldb-2.0.0.jar. At the same time, my sqoop is 1.4.3, and it requires hsqldb-1.8.0.10.jar. Now I failed to run sqoop-1.4.3 job tool($SQOOP_HOME/bin/sqoop job --list) agains hadoop-2.1.0-beta: 1) If I use hsqldb-2.0.0.jar in my env, the exception will be: Exception in thread "main" java.lang.NoSuchMethodError: org/hsqldb/DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
  3. 0

    Re: Failed to use sqoop-1.4.3 job tool on hadoop-2.1.0-beta

    sqoop-user | 3 years ago | sam liu
    java.io.IOException: Invalid metadata version. > at > org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:202) > > at > org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) > at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) > at org.apache.sqoop.Sqoop.run(Sqoop.java:145) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) > at org.apache.sqoop.Sqoop.main(Sqoop.java:238) > > > 2) If I use hsqldb-1.8.0.10.jar in my env, the exception will be: > Exception in thread "main" java.lang.NoSuchMethodError: > org/hsqldb/DatabaseURL. > parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties; > at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) > at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) > at java.sql.DriverManager.getConnection(DriverManager.java:419) > at java.sql.DriverManager.getConnection(DriverManager.java:467) > at > org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:176) > at > org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) > at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) > at org.apache.sqoop.Sqoop.run(Sqoop.java:145) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) > at org.apache.sqoop.Sqoop.main(Sqoop.java:238) > > > > 2013/11/19 sam liu <liuqiyun2011@gmail.com> > Hi Experts, My cluster is hadoop-2.1.0-beta and it requires hsqldb-2.0.0.jar. At the same time, my sqoop is 1.4.3, and it requires hsqldb-1.8.0.10.jar. Now I failed to run sqoop-1.4.3 job tool($SQOOP_HOME/bin/sqoop job --list) agains hadoop-2.1.0-beta: 1) If I use hsqldb-2.0.0.jar in my env, the exception will be: Exception in thread "main" java.lang.NoSuchMethodError: org/hsqldb/DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: Failed to use sqoop-1.4.3 job tool on hadoop-2.1.0-beta

    sqoop-user | 3 years ago | sam liu
    java.io.IOException: Invalid metadata version. >> at >> org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:202) >> >> at >> org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) >> at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) >> at org.apache.sqoop.Sqoop.run(Sqoop.java:145) >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) >> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) >> at org.apache.sqoop.Sqoop.main(Sqoop.java:238) >> >> >> 2) If I use hsqldb-1.8.0.10.jar in my env, the exception will be: >> Exception in thread "main" java.lang.NoSuchMethodError: >> org/hsqldb/DatabaseURL. >> parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties; >> at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) >> at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) >> at java.sql.DriverManager.getConnection(DriverManager.java:419) >> at java.sql.DriverManager.getConnection(DriverManager.java:467) >> at >> org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:176) >> at >> org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) >> at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) >> at org.apache.sqoop.Sqoop.run(Sqoop.java:145) >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) >> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) >> at org.apache.sqoop.Sqoop.main(Sqoop.java:238) >> >> >> >> 2013/11/19 sam liu <liuqiyun2011@gmail.com> >> Hi Experts, My cluster is hadoop-2.1.0-beta and it requires hsqldb-2.0.0.jar. At the same time, my sqoop is 1.4.3, and it requires hsqldb-1.8.0.10.jar. Now I failed to run sqoop-1.4.3 job tool($SQOOP_HOME/bin/sqoop job --list) agains hadoop-2.1.0-beta: 1) If I use hsqldb-2.0.0.jar in my env, the exception will be: Exception in thread "main" java.lang.NoSuchMethodError: org/hsqldb/DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
  6. 0

    Re: Failed to use sqoop-1.4.3 job tool on hadoop-2.1.0-beta

    sqoop-user | 3 years ago | sam liu
    java.io.IOException: Invalid metadata version. > at > org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:202) > > at > org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) > at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) > at org.apache.sqoop.Sqoop.run(Sqoop.java:145) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) > at org.apache.sqoop.Sqoop.main(Sqoop.java:238) > > > 2) If I use hsqldb-1.8.0.10.jar in my env, the exception will be: > Exception in thread "main" java.lang.NoSuchMethodError: > org/hsqldb/DatabaseURL. > parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties; > at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) > at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) > at java.sql.DriverManager.getConnection(DriverManager.java:419) > at java.sql.DriverManager.getConnection(DriverManager.java:467) > at > org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:176) > at > org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) > at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) > at org.apache.sqoop.Sqoop.run(Sqoop.java:145) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) > at org.apache.sqoop.Sqoop.main(Sqoop.java:238) > > > > 2013/11/19 sam liu <liuqiyun2011@gmail.com> > Hi Experts, My cluster is hadoop-2.1.0-beta and it requires hsqldb-2.0.0.jar. At the same time, my sqoop is 1.4.3, and it requires hsqldb-1.8.0.10.jar. Now I failed to run sqoop-1.4.3 job tool($SQOOP_HOME/bin/sqoop job --list) agains hadoop-2.1.0-beta: 1) If I use hsqldb-2.0.0.jar in my env, the exception will be: Exception in thread "main" java.lang.NoSuchMethodError: org/hsqldb/DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.io.IOException

      org.hsqldb.HsqlException: user lacks privilege or object not found: MY\_TABLE

      at org.hsqldb.lib.java.JavaSystem.toIOException()
    2. HSQLDB
      JDBCDriver.connect
      1. org.hsqldb.lib.java.JavaSystem.toIOException(JavaSystem.java:77)
      2. org.hsqldb.scriptio.ScriptReaderText.processStatement(ScriptReaderText.java:295)
      3. org.hsqldb.scriptio.ScriptReaderText.readLoggedStatement(ScriptReaderText.java:225)
      4. org.hsqldb.persist.ScriptRunner.runScript(ScriptRunner.java:137)
      5. org.hsqldb.persist.ScriptRunner.runScript(ScriptRunner.java:118)
      6. org.hsqldb.persist.Log.processLog(Log.java:792)
      7. org.hsqldb.persist.Log.open(Log.java:133)
      8. org.hsqldb.persist.Logger.openPersistence(Logger.java:289)
      9. org.hsqldb.Database.reopen(Database.java:220)
      10. org.hsqldb.Database.open(Database.java:186)
      11. org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:240)
      12. org.hsqldb.DatabaseManager.newSession(DatabaseManager.java:157)
      13. org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3281)
      14. org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:321)
      15. org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:259)
      15 frames
    3. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(Unknown Source)
      2. java.sql.DriverManager.getConnection(Unknown Source)
      2 frames