[CONNECTORS-1165] example can not start

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Cannot Reproduce
• Component/s: Examples
• Assignee: Unassigned
• Reporter: Shinichiro Abe
• Created: 17/Feb/15 03:35
• Updated: 17/Feb/15 06:46
• Resolved: 17/Feb/15 06:46

Description

On trunk, example-proprietary can start, but example can' start because there is not a user privilege?

abe:example abe$ ./start.sh 
Configuration file successfully read
org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: SQLException doing query (42501): user lacks privilege or object not found: NEEDPRIORITY
	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:771)
	at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1444)
	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.DBInterfaceHSQLDB.performModification(DBInterfaceHSQLDB.java:750)
	at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.performAddIndex(DBInterfaceHSQLDB.java:522)
	at org.apache.manifoldcf.core.database.BaseTable.performAddIndex(BaseTable.java:139)
	at org.apache.manifoldcf.crawler.jobs.JobQueue.install(JobQueue.java:279)
	at org.apache.manifoldcf.crawler.jobs.JobManager.install(JobManager.java:103)
	at org.apache.manifoldcf.crawler.system.ManifoldCF.installSystemTables(ManifoldCF.java:718)
	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:144)
	at org.apache.manifoldcf.jettyrunner.ManifoldCFJettyRunner.main(ManifoldCFJettyRunner.java:237)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: NEEDPRIORITY
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at org.apache.manifoldcf.core.database.Database.execute(Database.java:863)
	at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:683)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: NEEDPRIORITY
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.Table.getColumnIndex(Unknown Source)
	at org.hsqldb.Table.getColumnIndexes(Unknown Source)
	at org.hsqldb.ParserDQL.readColumnList(Unknown Source)
	at org.hsqldb.ParserDDL.compileCreateIndex(Unknown Source)
	at org.hsqldb.ParserDDL.compileCreate(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 4 more