You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@manifoldcf.apache.org by "Karl Wright (Created) (JIRA)" <ji...@apache.org> on 2011/12/15 14:54:30 UTC
[jira] [Created] (CONNECTORS-321) Every other time a multiprocess
initialization script is run using HSQLDB, a nonsense database exception
occurs
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
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
[jira] [Assigned] (CONNECTORS-321) Every other time a multiprocess
initialization script is run using HSQLDB, a nonsense database exception
occurs
Posted by "Karl Wright (Assigned) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CONNECTORS-321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Wright reassigned CONNECTORS-321:
--------------------------------------
Assignee: Karl Wright
> 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
[jira] [Commented] (CONNECTORS-321) Every other time a multiprocess
initialization script is run using HSQLDB, a nonsense database exception
occurs
Posted by "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
[jira] [Commented] (CONNECTORS-321) Every other time a multiprocess
initialization script is run using HSQLDB, a nonsense database exception
occurs
Posted by "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=13171425#comment-13171425 ]
Karl Wright commented on CONNECTORS-321:
----------------------------------------
r1215386 (trunk)
r1215387 (release branch)
> 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
[jira] [Commented] (CONNECTORS-321) Every other time a multiprocess
initialization script is run using HSQLDB, a nonsense database exception
occurs
Posted by "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=13170305#comment-13170305 ]
Karl Wright commented on CONNECTORS-321:
----------------------------------------
HSQLDB team will be looking at this in the next week or so. My recommendation is to postpone the release until then, given the importance of HSQLDB in it.
> 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
[jira] [Resolved] (CONNECTORS-321) Every other time a multiprocess
initialization script is run using HSQLDB, a nonsense database exception
occurs
Posted by "Karl Wright (Resolved) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CONNECTORS-321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Wright resolved CONNECTORS-321.
------------------------------------
Resolution: Fixed
> 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