java.sql.SQLSyntaxErrorException

user lacks privilege or object not found: CATALOG

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web408

  • via Unknown by Kenneth Barber,
  • via Unknown by Ken Barber,
  • Stack trace

    • java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: CATALOG at org.hsqldb.jdbc.Util.sqlException(Unknown Source)[puppetdb.jar:na] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)[puppetdb.jar:na] at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)[puppetdb.jar:na] at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)[puppetdb.jar:na] at com.jolbox.bonecp.ConnectionHandle.prepareStatement(ConnectionHandle.java:820)[puppetdb.jar:na] at com.puppetlabs.jdbc$with_query_results_cursor_STAR_$fn__6780.invoke(jdbc.clj:321)[na:na] at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223)[na:na] at com.puppetlabs.jdbc$with_query_results_cursor_STAR_.invoke(jdbc.clj:320)[na:na] at com.puppetlabs.puppetdb.query$streamed_query_result.invoke(query.clj:1140)[na:na] at com.puppetlabs.puppetdb.http.nodes$produce_body$fn__12996$fn__12999$fn__13000.invoke(nodes.clj:32)[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762$fn__6763.invoke(jdbc.clj:290)[na:na] at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:204)[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762.invoke(jdbc.clj:290)[na:na] at clojure.java.jdbc.internal$with_connection_STAR_.invoke(internal.clj:186)[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761.invoke(jdbc.clj:287)[na:na] at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741$fn__6742.invoke(jdbc.clj:259)[na:na] at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741.invoke(jdbc.clj:258)[na:na] at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740.invoke(jdbc.clj:250)[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:286)[na:na] at com.puppetlabs.puppetdb.http.nodes$produce_body$fn__12996$fn__12999.invoke(nodes.clj:30)[na:na] at com.puppetlabs.http$stream_json_response$fn__7475.invoke(http.clj:234)[na:na] at ring.util.io$piped_input_stream$fn__7339.invoke(io.clj:25)[na:na] at clojure.core$binding_conveyor_fn$fn__4145.invoke(core.clj:1910)[puppetdb.jar:na] at clojure.lang.AFn.call(AFn.java:18)[puppetdb.jar:na] at java.util.concurrent.FutureTask.run(FutureTask.java:262)[na:1.7.0_65] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)[na:1.7.0_65] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)[na:1.7.0_65] at java.lang.Thread.run(Thread.java:745)[na:1.7.0_65] Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: CATALOG at org.hsqldb.error.Error.error(Unknown Source)[puppetdb.jar:na] at org.hsqldb.error.Error.error(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ExpressionColumn.checkColumnsResolved(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ParserDQL.XreadTableSubqueryOrNull(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ParserCommand.compilePart(Unknown Source)[puppetdb.jar:na] at org.hsqldb.ParserCommand.compileStatement(Unknown Source)[puppetdb.jar:na] at org.hsqldb.Session.compileStatement(Unknown Source)[puppetdb.jar:na] at org.hsqldb.StatementManager.compile(Unknown Source)[puppetdb.jar:na] at org.hsqldb.Session.execute(Unknown Source)[puppetdb.jar:na] ... 26 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    marcbouvierdavmarcbouvierdav
    2 times, last one
    Unknown visitor
    Unknown visitorOnce,
    Unknown UserUnknown User
    2 times, last one
    AxeloAxelo
    12 times, last one
    92 more bugmates