Error on SPARQL query

6 views
Skip to first unread message

Mike Travers

unread,
Aug 18, 2014, 7:05:04 PM8/18/14
to sta...@clarkparsia.com

I was running Stardog on a Linux box when we lost power. On restart, the database appeared damaged, SPARQL queries now get errors like that below.

I tried to run repair on the database and was told:

$ ./stardog-admin db repair kb

Trying to repair qkb database, this might take a while depending on database size.

Database kb is invalid and the repair failed: Index cannot be repaired!

Nothing I can't re-create, but that's not very good behavior for a database.


--> Got Exception: org.openrdf.query.QueryEvaluationException: com.complexible.stardog.plan.eval.ExecutionException: There was an error while creating a new query plan

java.lang.RuntimeException: org.openrdf.query.QueryEvaluationException: org.openrdf.query.QueryEvaluationException: com.complexible.stardog.plan.eval.ExecutionException: There was an error while creating a new query plan

at com.google.common.base.Throwables.propagate(Throwables.java:160)

at com.complexible.annex.repository.AbstractRepositoryHandler.queryTuples(AbstractRepositoryHandler.java:244)

at com.complexible.annex.api.SchemaHandler$RepositoryHandlerStrategy.queryTuples(SchemaHandler.java:490)

at com.complexible.annex.api.SchemaHandler.getClassTreeInfo(SchemaHandler.java:158)

at com.complexible.stardog.protocols.http.annex.SchemaService.classTree(SchemaService.java:82)

at com.complexible.stardog.protocols.http.annex.SchemaService.handleMessage(SchemaService.java:61)

at com.complexible.common.protocols.server.rpc.ServerHandler.handleMessage(ServerHandler.java:266)

at com.complexible.common.protocols.server.rpc.ServerHandler.channelRead(ServerHandler.java:149)

at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:332)

at io.netty.channel.AbstractChannelHandlerContext.access$700(AbstractChannelHandlerContext.java:31)

at io.netty.channel.AbstractChannelHandlerContext$8.run(AbstractChannelHandlerContext.java:323)

at io.netty.util.concurrent.DefaultEventExecutor.run(DefaultEventExecutor.java:36)

at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:116)

at java.lang.Thread.run(Thread.java:744)

Caused by: org.openrdf.query.QueryEvaluationException: org.openrdf.query.QueryEvaluationException: com.complexible.stardog.plan.eval.ExecutionException: There was an error while creating a new query plan

at com.complexible.stardog.protocols.http.annex.openrdf.AnnexTupleQuery.evaluate(AnnexTupleQuery.java:57)

at com.complexible.stardog.protocols.http.annex.openrdf.AnnexTupleQuery.evaluate(AnnexTupleQuery.java:37)

at com.complexible.annex.repository.AbstractRepositoryHandler.queryTuples(AbstractRepositoryHandler.java:223)

... 12 more

Caused by: org.openrdf.query.QueryEvaluationException: com.complexible.stardog.plan.eval.ExecutionException: There was an error while creating a new query plan

at com.complexible.stardog.query.DefaultQueryFactory$TupleQuery.execute(DefaultQueryFactory.java:198)

at com.complexible.stardog.query.DefaultQueryFactory$TupleQuery.execute(DefaultQueryFactory.java:181)

at com.complexible.stardog.protocols.http.annex.openrdf.AnnexQueryBase.execute(AnnexQueryBase.java:29)

at com.complexible.stardog.protocols.http.annex.openrdf.AnnexTupleQuery.evaluate(AnnexTupleQuery.java:48)

... 14 more

Caused by: com.complexible.stardog.plan.eval.ExecutionException: There was an error while creating a new query plan

at com.complexible.stardog.plan.eval.QueryEngine.getExecutablePlan(QueryEngine.java:194)

at com.complexible.stardog.plan.eval.QueryEngine.executeSelect(QueryEngine.java:115)

at com.complexible.stardog.query.DefaultQueryFactory$TupleQuery.execute(DefaultQueryFactory.java:195)

... 17 more

Caused by: com.complexible.stardog.plan.PlanException: There was an error while creating a new query plan

at com.complexible.stardog.plan.PlanGenerator.createPlan(PlanGenerator.java:562)

at com.complexible.stardog.plan.PlanGenerator.createPlan(PlanGenerator.java:526)

at com.complexible.stardog.plan.eval.QueryEngine.getExecutablePlan(QueryEngine.java:174)

... 19 more

Caused by: com.complexible.common.io.impl.PageNotFoundException: Page not found: 20780

at com.complexible.common.io.impl.PagedFileImpl.getPage(PagedFileImpl.java:71)

at com.complexible.common.io.impl.PageManagerImpl.getPageInternal(PageManagerImpl.java:267)

at com.complexible.common.io.impl.PageManagerImpl.getPage(PageManagerImpl.java:253)

at com.complexible.stardog.index.disk.btree.impl.TreePageManagerImpl.getPage(TreePageManagerImpl.java:57)

at com.complexible.stardog.index.disk.btree.impl.BPlusTreeImpl.getPage(BPlusTreeImpl.java:212)

at com.complexible.stardog.index.disk.btree.impl.BPlusTreeImpl.iterator(BPlusTreeImpl.java:575)

at com.complexible.stardog.index.disk.btree.impl.BPlusTreeImpl.iterator(BPlusTreeImpl.java:471)

at com.complexible.stardog.index.AggregateContextIndex.getSingleContext(AggregateContextIndex.java:138)

at com.complexible.stardog.plan.PlanGenerator.initializeDatasetGraphs(PlanGenerator.java:665)

at com.complexible.stardog.plan.PlanGenerator.access$300(PlanGenerator.java:152)

at com.complexible.stardog.plan.PlanGenerator$PlanBuilder.<init>(PlanGenerator.java:718)

at com.complexible.stardog.plan.PlanGenerator.createPlan(PlanGenerator.java:555)

... 21 more

--> Got Exception: com.complexible.common.io.impl.PageNotFoundException: Page not found: 20780

java.lang.RuntimeException: org.openrdf.query.QueryEvaluationException: com.complexible.common.io.impl.PageNotFoundException: Page not found: 20780

at com.google.common.base.Throwables.propagate(Throwables.java:160)

at com.complexible.annex.repository.AbstractRepositoryHandler.queryTuples(AbstractRepositoryHandler.java:244)

at com.complexible.annex.api.SchemaHandler$RepositoryHandlerStrategy.queryTuples(SchemaHandler.java:490)

at com.complexible.annex.api.SchemaHandler.getPropertyTreeInfo(SchemaHandler.java:182)

at com.complexible.stardog.protocols.http.annex.SchemaService.propertyTree(SchemaService.java:109)

at com.complexible.stardog.protocols.http.annex.SchemaService.handleMessage(SchemaService.java:64)

at com.complexible.common.protocols.server.rpc.ServerHandler.handleMessage(ServerHandler.java:266)

at com.complexible.common.protocols.server.rpc.ServerHandler.channelRead(ServerHandler.java:149)

at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:332)

at io.netty.channel.AbstractChannelHandlerContext.access$700(AbstractChannelHandlerContext.java:31)

at io.netty.channel.AbstractChannelHandlerContext$8.run(AbstractChannelHandlerContext.java:323)

at io.netty.util.concurrent.DefaultEventExecutor.run(DefaultEventExecutor.java:36)

at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:116)

at java.lang.Thread.run(Thread.java:744)

Caused by: org.openrdf.query.QueryEvaluationException: com.complexible.common.io.impl.PageNotFoundException: Page not found: 20780

at com.complexible.stardog.protocols.http.annex.openrdf.AnnexTupleQuery.evaluate(AnnexTupleQuery.java:57)

at com.complexible.stardog.protocols.http.annex.openrdf.AnnexTupleQuery.evaluate(AnnexTupleQuery.java:37)

at com.complexible.annex.repository.AbstractRepositoryHandler.queryTuples(AbstractRepositoryHandler.java:223)

... 12 more

Caused by: com.complexible.common.io.impl.PageNotFoundException: Page not found: 20780

at com.complexible.common.io.impl.PagedFileImpl.getPage(PagedFileImpl.java:71)

at com.complexible.common.io.impl.PageManagerImpl.getPageInternal(PageManagerImpl.java:267)

at com.complexible.common.io.impl.PageManagerImpl.getPage(PageManagerImpl.java:253)

at com.complexible.stardog.index.disk.btree.impl.TreePageManagerImpl.getPage(TreePageManagerImpl.java:57)

at com.complexible.stardog.index.disk.btree.impl.BPlusTreeImpl.getPage(BPlusTreeImpl.java:212)

at com.complexible.stardog.index.disk.btree.impl.BPlusTreeImpl.iterator(BPlusTreeImpl.java:569)

at com.complexible.stardog.index.disk.btree.impl.BPlusTreeImpl.iterator(BPlusTreeImpl.java:443)

at com.complexible.stardog.index.AggregateContextIndex.iterator(AggregateContextIndex.java:101)

at com.complexible.stardog.index.AggregateContextIndex.iterator(AggregateContextIndex.java:25)

at com.complexible.stardog.index.IteratorBuilder$ContextIterBuilder.build(IteratorBuilder.java:765)

at com.complexible.stardog.index.IteratorBuilder.iterator(IteratorBuilder.java:183)

at com.complexible.stardog.index.statistics.EstimateCardinality.getContextCardinality(EstimateCardinality.java:142)

at com.complexible.stardog.index.statistics.EstimateCardinality.getCardinality(EstimateCardinality.java:116)

at com.complexible.stardog.plan.Costs$CostingVisitor.visit(Costs.java:365)

at com.complexible.stardog.plan.ScanNodeImpl.accept(ScanNodeImpl.java:140)

at com.complexible.stardog.plan.BasePlanNodeVisitor.binaryVisit(BasePlanNodeVisitor.java:35)

at com.complexible.stardog.plan.Costs$CostingVisitor.binaryCost(Costs.java:593)

at com.complexible.stardog.plan.Costs$CostingVisitor.binaryVisit(Costs.java:553)

at com.complexible.stardog.plan.Costs$CostingVisitor.visit(Costs.java:211)

at com.complexible.stardog.plan.JoinPlanNodeImpl.accept(JoinPlanNodeImpl.java:102)

at com.complexible.stardog.plan.BasePlanNodeVisitor.binaryVisit(BasePlanNodeVisitor.java:35)

at com.complexible.stardog.plan.Costs$CostingVisitor.binaryCost(Costs.java:593)

at com.complexible.stardog.plan.Costs$CostingVisitor.binaryVisit(Costs.java:553)

at com.complexible.stardog.plan.Costs$CostingVisitor.visit(Costs.java:211)

at com.complexible.stardog.plan.JoinPlanNodeImpl.accept(JoinPlanNodeImpl.java:102)

at com.complexible.stardog.plan.BasePlanNodeVisitor.binaryVisit(BasePlanNodeVisitor.java:35)

at com.complexible.stardog.plan.Costs$CostingVisitor.binaryCost(Costs.java:593)

at com.complexible.stardog.plan.Costs$CostingVisitor.visit(Costs.java:426)

at com.complexible.stardog.plan.UnionPlanNodeImpl.accept(UnionPlanNodeImpl.java:100)

at com.complexible.stardog.plan.BasePlanNodeVisitor.unaryVisit(BasePlanNodeVisitor.java:43)

at com.complexible.stardog.plan.Costs$CostingVisitor.unaryCost(Costs.java:583)

at com.complexible.stardog.plan.Costs$CostingVisitor.unaryVisit(Costs.java:471)

at com.complexible.stardog.plan.Costs$CostingVisitor.visit(Costs.java:479)

at com.complexible.stardog.plan.ProjectionPlanNodeImpl.accept(ProjectionPlanNodeImpl.java:105)

at com.complexible.stardog.plan.BasePlanNodeVisitor.unaryVisit(BasePlanNodeVisitor.java:43)

at com.complexible.stardog.plan.Costs$CostingVisitor.unaryCost(Costs.java:583)

at com.complexible.stardog.plan.Costs$CostingVisitor.unaryVisit(Costs.java:471)

at com.complexible.stardog.plan.Costs$CostingVisitor.visit(Costs.java:531)

at com.complexible.stardog.plan.DistinctPlanNodeImpl.accept(DistinctPlanNodeImpl.java:64)

at com.complexible.stardog.plan.Costs.costOf(Costs.java:76)

at com.complexible.stardog.plan.optimizer.OptimizationPipeline.execute(OptimizationPipeline.java:107)

at com.complexible.stardog.plan.eval.ExecutablePlanFactory.createOptimized(ExecutablePlanFactory.java:97)

at com.complexible.stardog.plan.eval.QueryEngine.getExecutablePlan(QueryEngine.java:189)

at com.complexible.stardog.plan.eval.QueryEngine.executeSelect(QueryEngine.java:115)

at com.complexible.stardog.query.DefaultQueryFactory$TupleQuery.execute(DefaultQueryFactory.java:195)

at com.complexible.stardog.query.DefaultQueryFactory$TupleQuery.execute(DefaultQueryFactory.java:181)

at com.complexible.stardog.protocols.http.annex.openrdf.AnnexQueryBase.execute(AnnexQueryBase.java:29)

at com.complexible.stardog.protocols.http.annex.openrdf.AnnexTupleQuery.evaluate(AnnexTupleQuery.java:48)

... 14 more

miket@qdesktop-miket:~/stardog-2.2/bin$ 

Kendall Clark

unread,
Aug 19, 2014, 9:38:43 AM8/19/14
to stardog
Yeah, that's not good. Can you send stardog.log zipped up directly to me?

Cheers,
Kendall

--
-- --
You received this message because you are subscribed to the C&P "Stardog" group.
To post to this group, send email to sta...@clarkparsia.com
To unsubscribe from this group, send email to
stardog+u...@clarkparsia.com
For more options, visit this group at
http://groups.google.com/a/clarkparsia.com/group/stardog?hl=en

Kendall Clark

unread,
Aug 20, 2014, 2:15:17 PM8/20/14
to stardog
Hey,

We think that this bug was fixed in 2.2.1; also, db repair was improved in 2.2.1 to work in more situations. You might even be able to repair that db w/ 2.2.1.

Cheers,
Kendall
Reply all
Reply to author
Forward
0 new messages