[jira] [Commented] (CONNECTORS-321) Every other time a multiprocess initialization script is run using HSQLDB, a nonsense database exception occurs

["Karl Wright (Commented) (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CONNECTORS-321?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13170204#comment-13170204 ] 

Karl Wright commented on CONNECTORS-321:
----------------------------------------

At least initially, I'm treating this as an HSQLDB problem.  I've notified that team.

                
> Every other time a multiprocess initialization script is run using HSQLDB, a nonsense database exception occurs
> ---------------------------------------------------------------------------------------------------------------
>
>                 Key: CONNECTORS-321
>                 URL: https://issues.apache.org/jira/browse/CONNECTORS-321
>             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
>
>
> The script is the multiprocess-example "initialize" script.  Here's the exception:
> Successfully registered output connector 'org.apache.manifoldcf.agents.output.opensearchserver.OpenSearchServerConnector'org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: Exception doing query: user lacks privilege or object not found: OUTPUTCONNECTORS
>         at org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:672)
>         at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:700)
>         at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1363)
>         at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144)
>         at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:179)
>         at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.performModification(DBInterfaceHSQLDB.java:771)
>         at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.performLock(DBInterfaceHSQLDB.java:213)
>         at org.apache.manifoldcf.core.database.BaseTable.performLock(BaseTable.java:65)
>         at org.apache.manifoldcf.agents.outputconnmgr.OutputConnectorManager.registerConnector(OutputConnectorManager.java:161)
>         at org.apache.manifoldcf.crawler.RegisterConnectors.registerConnectors(RegisterConnectors.java:250)
>         at org.apache.manifoldcf.crawler.InitializeAndRegister.doExecute(InitializeAndRegister.java:56)
>         at org.apache.manifoldcf.crawler.InitializeAndRegister.main(InitializeAndRegister.java:73)
> Caused by: java.sql.SQLException: user lacks privilege or object not found: OUTPUTCONNECTORS
>         at org.hsqldb.jdbc.Util.sqlException(Util.java:255)
>         at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1838)
>         at org.hsqldb.jdbc.JDBCStatement.execute(JDBCStatement.java:636)
>         at org.apache.manifoldcf.core.database.Database.execute(Database.java:777)
>         at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:632)

--
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