manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karl Wright <daddy...@gmail.com>
Subject Re: Migration from mcf 1.1 to 1.7
Date Thu, 23 Oct 2014 13:07:16 GMT
Hi Markus,

I'm sorry, but Derby migration has never been supported.  It's never
supposed to be used in production.  In fact, it will no longer be supported
in any manner on MCF 2.0.

Thanks,
Karl


On Thu, Oct 23, 2014 at 8:43 AM, Markus Schuch <markus_schuch@web.de> wrote:

> Hi Karl,
>
> we encountered an issue when migrating on a derby database. (test
> environment running on derby)
> Is derby migration supported? (may be not in scope, since derby should be
> used for production?)
>
> org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database
> exception: SQLException doing query (42X01): Syntaxfehler: Encountered
> "ONLY" at line 1, column 13.
>         at
> org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.finishUp(Database.java:702)
>         at
> org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:728)
>         at
> org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:762)
>         at
> org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1435)
>         at
> org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:146)
>         at
> org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:191)
>         at
> org.apache.manifoldcf.core.database.DBInterfaceDerby.performModification(DBInterfaceDerby.java:836)
>         at
> org.apache.manifoldcf.core.database.DBInterfaceDerby.performAlter(DBInterfaceDerby.java:396)
>         at
> org.apache.manifoldcf.core.database.BaseTable.performAlter(BaseTable.java:118)
>         at
> org.apache.manifoldcf.crawler.repository.RepositoryConnectionManager.install(RepositoryConnectionManager.java:167)
>         at
> org.apache.manifoldcf.crawler.system.ManifoldCF.installSystemTables(ManifoldCF.java:619)
>         at
> org.apache.manifoldcf.crawler.system.CrawlerAgent.install(CrawlerAgent.java:116)
>         at
> org.apache.manifoldcf.agents.agentmanager.AgentManager.registerAgent(AgentManager.java:146)
>         at
> org.apache.manifoldcf.crawler.system.ManifoldCF.registerThisAgent(ManifoldCF.java:136)
>         at
> org.apache.manifoldcf.combinedservice.ServletListener.contextInitialized(ServletListener.java:45)
>         ... 10 more
> Caused by: java.sql.SQLSyntaxErrorException: Syntaxfehler: Encountered
> "ONLY" at line 1, column 13.
>         at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
>         at
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown
> Source)
>         at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown
> Source)
>         at
> org.apache.manifoldcf.core.database.Database.execute(Database.java:854)
>         at
> org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:683)
> Caused by: java.sql.SQLException: Syntaxfehler: Encountered "ONLY" at line
> 1, column 13.
>         at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
>         at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
>         ... 10 more
> Caused by: ERROR 42X01: Syntaxfehler: Encountered "ONLY" at line 1, column
> 13.
>         at
> org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>         at
> org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source)
>         at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown
> Source)
>         at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown
> Source)
>         at
> org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
> Source)
>         ... 4 more
>
> The failing statement is
>
> ALTER TABLE ONLY repoconnections DROP authorityname
>
> Seems to me that ONLY is not a keyword in derby.
>
> Regards,
> Markus
>

Mime
View raw message