[ https://issues.apache.org/jira/browse/CONNECTORS-330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13171527#comment-13171527 ]
Karl Wright edited comment on CONNECTORS-330 at 12/17/11 12:12 PM: ------------------------------------------------------------------- The story points back to HSQLDB again, unfortunately. Here's a trace: {code} [junit] Created HSQLDB instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@113beb5 with user manifoldcf which is meant to work with schema dbname [junit] Created HSQLDB instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@747fa2 with user manifoldcf which is meant to work with schema dbname [junit] Created HSQLDB instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@6782a9 with user sa which is meant to work with schema administration [junit] Created HSQLDB instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@17200b4 with user manifoldcf which is meant to work with schema dbname [junit] Created HSQLDB instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@18c3679 with user sa which is meant to work with schema administration [junit] Creating schema DBNAME using instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@18c3679 [junit] Altering user "manifoldcf" [junit] Alter User succeeded! ALTER USER "manifoldcf" SET INITIAL SCHEMA DBNAME [junit] Created HSQLDB instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@289d2e with user manifoldcf which is meant to work with schema dbname [junit] Checking for table in schema DBNAME in instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@289d2e [junit] Creating table in schema DBNAME in instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@289d2e [junit] org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: Exception doing query: user lacks privilege or object not found: PUBLIC in statement [CREATE CACHED TABLE agents(classname VARCHAR(255) NOT NULL PRIMARY KEY)] [junit] at org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:672) ... {code} was (Author: kwri...@metacarta.com): The story points back to HSQLDB again, unfortunately. Here's an annotated trace: {code} <<Here's the schema creation>> [junit] Created HSQLDB instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@18c3679 with user sa which is meant to work with schema administration [junit] Creating schema DBNAME using instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@18c3679 <<Here's the alter user>> [junit] Altering user "manifoldcf" [junit] Alter User succeeded! ALTER USER "manifoldcf" SET INITIAL SCHEMA DBNAME <<Here's the table create>> [junit] Created HSQLDB instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@289d2e with user manifoldcf which is meant to work with schema dbname [junit] Checking for table in schema DBNAME in instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@289d2e [junit] Creating table in schema DBNAME in instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@289d2e [junit] org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: Exception doing query: user lacks privilege or object not found: PUBLIC in statement [CREATE CACHED TABLE agents(classname VARCHAR(255) NOT NULL PRIMARY KEY)] [junit] at org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:672) [junit] at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:716) [junit] at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1363) [junit] at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144) [junit] at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:179) [junit] at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.performModification(DBInterfaceHSQLDB.java:752) [junit] at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.performCreate(DBInterfaceHSQLDB.java:364) [junit] at org.apache.manifoldcf.core.database.BaseTable.performCreate(BaseTable.java:111) [junit] at org.apache.manifoldcf.agents.agentmanager.AgentManager.install(AgentManager.java:72) [junit] at org.apache.manifoldcf.agents.system.ManifoldCF.installTables(ManifoldCF.java:73) [junit] at org.apache.manifoldcf.agents.tests.BaseHSQLDBext.localSetUp(BaseHSQLDBext.java:65) [junit] at org.apache.manifoldcf.crawler.tests.BaseHSQLDBext.localSetUp(BaseHSQLDBext.java:60) [junit] at org.apache.manifoldcf.crawler.tests.BaseHSQLDBext.setUp(BaseHSQLDBext.java:48) [junit] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [junit] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [junit] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [junit] at java.lang.reflect.Method.invoke(Method.java:592) [junit] at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44) [junit] at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15) [junit] at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41) [junit] at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27) [junit] at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31) [junit] at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:76) [junit] at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) [junit] at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193) [junit] at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52) [junit] at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191) [junit] at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42) [junit] at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184) [junit] at org.junit.runners.ParentRunner.run(ParentRunner.java:236) [junit] at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:39) [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:422) [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUnitTestRunner.java:931) [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:785) [junit] Caused by: java.sql.SQLException: user lacks privilege or object not found: PUBLIC in statement [CREATE CACHED TABLE agents(classname VARCHAR(255) NOT NULL PRIMARY KEY)] [junit] at org.hsqldb.jdbc.Util.sqlException(Util.java:255) [junit] at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1838) [junit] at org.hsqldb.jdbc.JDBCStatement.execute(JDBCStatement.java:636) [junit] at org.apache.manifoldcf.core.database.Database.execute(Database.java:777) [junit] at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:632) <<The rest is cleanup>> [junit] Created HSQLDB instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@18ce14a with user manifoldcf which is meant to work with schema dbname [junit] Created HSQLDB instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@1ae90c with user manifoldcf which is meant to work with schema dbname [junit] Created HSQLDB instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@ba4211 with user manifoldcf which is meant to work with schema dbname [junit] Created HSQLDB instance org.apache.manifoldcf.core.database.DBInterfaceHSQLDB@47a0d4 with user sa which is meant to work with schema administration {code} > HSQLDB external database tests fail > ----------------------------------- > > Key: CONNECTORS-330 > URL: https://issues.apache.org/jira/browse/CONNECTORS-330 > Project: ManifoldCF > Issue Type: Bug > Components: Framework core > Affects Versions: ManifoldCF 0.4 > Reporter: Karl Wright > Assignee: Karl Wright > Priority: Blocker > Fix For: ManifoldCF 0.4 > > > Here's the exception we get: > [junit] Database exception: Exception doing query: user lacks privilege > or o > bject not found: PUBLIC in statement [CREATE CACHED TABLE agents(classname > VARCH > AR(255) NOT NULL PRIMARY KEY)] > [junit] org.apache.manifoldcf.core.interfaces.ManifoldCFException: > Database > exception: Exception doing query: user lacks privilege or object not found: > PUBL > IC in statement [CREATE CACHED TABLE agents(classname VARCHAR(255) NOT NULL > PRIM > ARY KEY)] > [junit] at > org.apache.manifoldcf.core.database.Database.executeViaThread > (Database.java:672) > [junit] at > org.apache.manifoldcf.core.database.Database.executeUncachedQ > uery(Database.java:716) > [junit] at > org.apache.manifoldcf.core.database.Database$QueryCacheExecut > or.create(Database.java:1363) > [junit] at > org.apache.manifoldcf.core.cachemanager.CacheManager.findObje > ctsAndExecute(CacheManager.java:144) > [junit] at > org.apache.manifoldcf.core.database.Database.executeQuery(Dat > abase.java:179) > [junit] at > org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.perform > Modification(DBInterfaceHSQLDB.java:746) > [junit] at > org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.perform > Create(DBInterfaceHSQLDB.java:361) > [junit] at > org.apache.manifoldcf.core.database.BaseTable.performCreate(B > aseTable.java:111) > [junit] at > org.apache.manifoldcf.agents.agentmanager.AgentManager.instal > l(AgentManager.java:72) > [junit] at > org.apache.manifoldcf.agents.system.ManifoldCF.installTables( > ManifoldCF.java:73) > [junit] at > org.apache.manifoldcf.agents.tests.BaseHSQLDBext.localSetUp(B > aseHSQLDBext.java:65) > [junit] at > org.apache.manifoldcf.crawler.tests.BaseHSQLDBext.localSetUp( > BaseHSQLDBext.java:60) > [junit] at > org.apache.manifoldcf.crawler.tests.BaseHSQLDBext.setUp(BaseH > SQLDBext.java:48) > [junit] Caused by: java.sql.SQLException: user lacks privilege or object > not > found: PUBLIC in statement [CREATE CACHED TABLE agents(classname > VARCHAR(255) N > OT NULL PRIMARY KEY)] > [junit] at org.hsqldb.jdbc.Util.sqlException(Util.java:255) > [junit] at > org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java: > 1838) > [junit] at > org.hsqldb.jdbc.JDBCStatement.execute(JDBCStatement.java:636) > [junit] at > org.apache.manifoldcf.core.database.Database.execute(Database > .java:777) > [junit] at > org.apache.manifoldcf.core.database.Database$ExecuteQueryThre > ad.run(Database.java:632) > [junit] > [junit] -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira