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 (Commented) (JIRA)" <ji...@apache.org> on 2011/12/15 12:32:30 UTC
[jira] [Commented] (CONNECTORS-320) DBCreate on HSQLDB instance
operating in external mode fails second time
[ https://issues.apache.org/jira/browse/CONNECTORS-320?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13170128#comment-13170128 ]
Karl Wright commented on CONNECTORS-320:
----------------------------------------
r1214707 (trunk)
r1214708 (release branch)
> DBCreate on HSQLDB instance operating in external mode fails second time
> ------------------------------------------------------------------------
>
> Key: CONNECTORS-320
> URL: https://issues.apache.org/jira/browse/CONNECTORS-320
> 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
>
>
> When ManifoldCF is configured to run HSQLDB, if you try to create the database twice you get an exception. This is used during upgrades. PostgreSQL works fine here. The exception is:
> C:\wip\mcf\CONNECTORS-313\dist\multiprocess-example>initialize.bat
> Configuration file successfully read
> org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: E
> xception doing query: object name already exists: DBNAME
> at org.apache.manifoldcf.core.database.Database.executeViaThread(Databas
> e.java:672)
> at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Dat
> abase.java:716)
> at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.creat
> e(Database.java:1363)
> at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndEx
> ecute(CacheManager.java:144)
> at org.apache.manifoldcf.core.database.Database.executeQuery(Database.ja
> va:179)
> at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.createUserAndDa
> tabase(DBInterfaceHSQLDB.java:621)
> at org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(Man
> ifoldCF.java:683)
> at org.apache.manifoldcf.crawler.RegisterConnectors.createDatabaseAndSch
> ema(RegisterConnectors.java:71)
> at org.apache.manifoldcf.crawler.RegisterAll.doExecute(RegisterAll.java:
> 33)
> at org.apache.manifoldcf.crawler.TransactionalCrawlerInitializationComma
> nd.execute(TransactionalCrawlerInitializationCommand.java:43)
> at org.apache.manifoldcf.crawler.RegisterAll.main(RegisterAll.java:55)
> Caused by: java.sql.SQLException: object name already exists: DBNAME
> 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:77
> 7)
> at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(D
> atabase.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