manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erlend GarĂ¥sen <e.f.gara...@usit.uio.no>
Subject Importing old configuration data
Date Mon, 23 Apr 2012 12:57:31 GMT

I'm trying to import my old configuration files into my freshly 
installed MCF version, but I'm afraid that these configuration data is 
too old (from version 0.3, I think). I get the following error: 
"Database exception: Exception doing query: ERROR: insert or update on 
table "jobs" violates foreign key constraint "jobs_outputname_fkey"
   Detail: Key (outputname)=(Solr) is not present in table 
"outputconnections"".

Here's what I tried to do. The last step fails:
./processes/script/executecommand.sh org.apache.manifoldcf.agents.Install
  ./processes/script/executecommand.sh 
org.apache.manifoldcf.agents.RegisterOutput 
org.apache.manifoldcf.agents.output.solr.SolrConnector SolrConnector
./processes/script/executecommand.sh 
org.apache.manifoldcf.agents.Register 
org.apache.manifoldcf.crawler.system.CrawlerAgent
./processes/script/executecommand.sh 
org.apache.manifoldcf.crawler.Register 
org.apache.manifoldcf.crawler.connectors.webcrawler.WebcrawlerConnector 
WebCrawler
./processes/script/executecommand.sh 
org.apache.manifoldcf.crawler.ImportConfiguration export_mcf.zip

Complete stack trace:

org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database 
exception: Exception doing query: ERROR: insert or update on table 
"jobs" violates foreign key constraint "jobs_outputname_fkey"
   Detail: Key (outputname)=(Solr) is not present in table 
"outputconnections".
	at 
org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:680)
	at 
org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:708)
	at 
org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1393)
	at 
org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144)
	at 
org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:185)
	at 
org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.performModification(DBInterfacePostgreSQL.java:631)
	at 
org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.performInsert(DBInterfacePostgreSQL.java:182)
	at 
org.apache.manifoldcf.core.database.BaseTable.performInsert(BaseTable.java:68)
	at org.apache.manifoldcf.crawler.jobs.Jobs.save(Jobs.java:756)
	at org.apache.manifoldcf.crawler.jobs.JobManager.save(JobManager.java:576)
	at 
org.apache.manifoldcf.crawler.jobs.JobManager.importConfiguration(JobManager.java:230)
	at 
org.apache.manifoldcf.crawler.system.ManifoldCF.importConfiguration(ManifoldCF.java:1100)
	at 
org.apache.manifoldcf.crawler.ImportConfiguration.doExecute(ImportConfiguration.java:40)
	at 
org.apache.manifoldcf.crawler.BaseCrawlerInitializationCommand.execute(BaseCrawlerInitializationCommand.java:37)
	at 
org.apache.manifoldcf.crawler.ImportConfiguration.main(ImportConfiguration.java:57)
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on 
table "jobs" violates foreign key constraint "jobs_outputname_fkey"
   Detail: Key (outputname)=(Solr) is not present in table 
"outputconnections".
	at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
	at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
	at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
	at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
	at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
	at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
	at org.apache.manifoldcf.core.database.Database.execute(Database.java:839)
	at 
org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:640)


-- 
Erlend GarĂ¥sen
Center for Information Technology Services
University of Oslo
P.O. Box 1086 Blindern, N-0317 OSLO, Norway
Ph: (+47) 22840193, Fax: (+47) 22852970, Mobile: (+47) 91380968, VIP: 31050

Mime
View raw message