Open GoogleCodeExporter opened 9 years ago
That's not a valid query, but we probably can report the error message at
compile time.
Count is an aggregation function, but $t's type is record instead of a
collection.
I guess this is what you want:
count(for $t in dataset page_views return $t);
Original comment by buyingyi@gmail.com
on 10 Oct 2014 at 9:11
[deleted comment]
I removed the group-by and its rebinding to a list, hence as you said the right
way is as follows:
use dataverse kereno;
count(for $t in dataset page_views return $t);
which returns a null[], see stack below:
Oct 10, 2014 2:22:17 PM edu.uci.ics.hyracks.control.cc.work.JobCleanupWork run
WARNING: Ignoring duplicate cleanup for JobRun with id: JID:81
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.storage.am.btree.exceptions.BTreeException:
edu.uci.ics.hyracks.api.exc
eptions.HyracksDataException: java.nio.channels.ClosedChannelException
at edu.uci.ics.hyracks.control.common.utils.ExceptionUtils.setNodeIds(ExceptionUtils.java:41)
at edu.uci.ics.hyracks.control.nc.Task.run(Task.java:296)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.storage.am.btree.exceptions.BTreeException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException: java.nio.channel
s.ClosedChannelException
at edu.uci.ics.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.nextFrame(IndexSearchOperatorNodePushable.java:201)
at edu.uci.ics.hyracks.dataflow.common.comm.util.FrameUtils.flushFrame(FrameUtils.java:38)
at edu.uci.ics.hyracks.algebricks.runtime.operators.std.EmptyTupleSourceRuntimeFactory$1.open(EmptyTupleSourceRuntimeFactory.java:55)
at edu.uci.ics.hyracks.algebricks.runtime.operators.meta.AlgebricksMetaOperatorDescriptor$1.initialize(AlgebricksMetaOperatorDescriptor.java:104)
at edu.uci.ics.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.initialize(SuperActivityOperatorNodePushable.java:81)
at edu.uci.ics.hyracks.control.nc.Task.run(Task.java:239)
... 3 more
Caused by: edu.uci.ics.hyracks.storage.am.btree.exceptions.BTreeException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
java.nio.channels.ClosedChannelException
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.performOp(BTree.java:784)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.search(BTree.java:197)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.access$600(BTree.java:69)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree$BTreeAccessor.search(BTree.java:909)
at edu.uci.ics.hyracks.storage.am.lsm.btree.impls.LSMBTreeRangeSearchCursor.open(LSMBTreeRangeSearchCursor.java:206)
at edu.uci.ics.hyracks.storage.am.lsm.btree.impls.LSMBTreeSearchCursor.open(LSMBTreeSearchCursor.java:77)
at edu.uci.ics.hyracks.storage.am.lsm.btree.impls.LSMBTree.search(LSMBTree.java:431)
at edu.uci.ics.hyracks.storage.am.lsm.common.impls.LSMHarness.search(LSMHarness.java:255)
at edu.uci.ics.hyracks.storage.am.lsm.common.impls.LSMTreeIndexAccessor.search(LSMTreeIndexAccessor.java:95)
at edu.uci.ics.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.nextFrame(IndexSearchOperatorNodePushable.java:197)
... 8 more
Caused by: edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
java.nio.channels.ClosedChannelException
at edu.uci.ics.hyracks.control.nc.io.IOManager.syncRead(IOManager.java:124)
at edu.uci.ics.hyracks.storage.common.buffercache.BufferCache.read(BufferCache.java:401)
at edu.uci.ics.hyracks.storage.common.buffercache.BufferCache.pin(BufferCache.java:148)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.performOp(BTree.java:600)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.performOp(BTree.java:631)
... 17 more
Caused by: java.nio.channels.ClosedChannelException
at sun.nio.ch.FileChannelImpl.ensureOpen(FileChannelImpl.java:99)
at sun.nio.ch.FileChannelImpl.read(FileChannelImpl.java:679)
at edu.uci.ics.hyracks.control.nc.io.IOManager.syncRead(IOManager.java:112)
... 21 more
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.storage.am.btr
ee.exceptions.BTreeException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
java.nio.channels.ClosedChannelException
at edu.uci.ics.hyracks.client.dataset.HyracksDatasetReader.nextPartition(HyracksDatasetReader.java:117)
at edu.uci.ics.hyracks.client.dataset.HyracksDatasetReader.read(HyracksDatasetReader.java:127)
at edu.uci.ics.asterix.result.ResultReader.read(ResultReader.java:58)
at edu.uci.ics.asterix.result.ResultUtils.displayResults(ResultUtils.java:88)
at edu.uci.ics.asterix.aql.translator.AqlTranslator.handleQuery(AqlTranslator.java:2056)
at edu.uci.ics.asterix.aql.translator.AqlTranslator.compileAndExecute(AqlTranslator.java:316)
at edu.uci.ics.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:546)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:970)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:411)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:192)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:904)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)
at org.eclipse.jetty.server.Server.handle(Server.java:347)
at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:439)
at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:924)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:781)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:220)
at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:43)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:545)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:43)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:529)
at java.lang.Thread.run(Thread.java:745)
Caused by: edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.storage.am.btree.exceptions.BTreeException: edu.uci.ics.hyra
cks.api.exceptions.HyracksDataException:
java.nio.channels.ClosedChannelException
at edu.uci.ics.hyracks.control.common.utils.ExceptionUtils.setNodeIds(ExceptionUtils.java:41)
at edu.uci.ics.hyracks.control.nc.Task.run(Task.java:296)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
... 1 more
Caused by: edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.storage.am.btree.exceptions.BTreeException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException: java.nio.channel
s.ClosedChannelException
at edu.uci.ics.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.nextFrame(IndexSearchOperatorNodePushable.java:201)
at edu.uci.ics.hyracks.dataflow.common.comm.util.FrameUtils.flushFrame(FrameUtils.java:38)
at edu.uci.ics.hyracks.algebricks.runtime.operators.std.EmptyTupleSourceRuntimeFactory$1.open(EmptyTupleSourceRuntimeFactory.java:55)
at edu.uci.ics.hyracks.algebricks.runtime.operators.meta.AlgebricksMetaOperatorDescriptor$1.initialize(AlgebricksMetaOperatorDescriptor.java:104)
at edu.uci.ics.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.initialize(SuperActivityOperatorNodePushable.java:81)
at edu.uci.ics.hyracks.control.nc.Task.run(Task.java:239)
... 3 more
Caused by: edu.uci.ics.hyracks.storage.am.btree.exceptions.BTreeException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
java.nio.channels.ClosedChannelException
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.performOp(BTree.java:784)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.search(BTree.java:197)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.access$600(BTree.java:69)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree$BTreeAccessor.search(BTree.java:909)
at edu.uci.ics.hyracks.storage.am.lsm.btree.impls.LSMBTreeRangeSearchCursor.open(LSMBTreeRangeSearchCursor.java:206)
at edu.uci.ics.hyracks.storage.am.lsm.btree.impls.LSMBTreeSearchCursor.open(LSMBTreeSearchCursor.java:77)
at edu.uci.ics.hyracks.storage.am.lsm.btree.impls.LSMBTree.search(LSMBTree.java:431)
at edu.uci.ics.hyracks.storage.am.lsm.common.impls.LSMHarness.search(LSMHarness.java:255)
at edu.uci.ics.hyracks.storage.am.lsm.common.impls.LSMTreeIndexAccessor.search(LSMTreeIndexAccessor.java:95)
at edu.uci.ics.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.nextFrame(IndexSearchOperatorNodePushable.java:197)
... 8 more
Caused by: edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
java.nio.channels.ClosedChannelException
at edu.uci.ics.hyracks.control.nc.io.IOManager.syncRead(IOManager.java:124)
at edu.uci.ics.hyracks.storage.common.buffercache.BufferCache.read(BufferCache.java:401)
at edu.uci.ics.hyracks.storage.common.buffercache.BufferCache.pin(BufferCache.java:148)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.performOp(BTree.java:600)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.performOp(BTree.java:631)
... 17 more
Caused by: java.nio.channels.ClosedChannelException
at sun.nio.ch.FileChannelImpl.ensureOpen(FileChannelImpl.java:99)
at sun.nio.ch.FileChannelImpl.read(FileChannelImpl.java:679)
at edu.uci.ics.hyracks.control.nc.io.IOManager.syncRead(IOManager.java:112)
... 21 more
Oct 10, 2014 2:22:17 PM edu.uci.ics.asterix.api.http.servlet.APIServlet doPost
SEVERE: edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.storage.am.btree.exceptions.BTreeException:
edu.uci.ics.hyracks
.api.exceptions.HyracksDataException: java.nio.channels.ClosedChannelException
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.storage.am.btr
ee.exceptions.BTreeException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
java.nio.channels.ClosedChannelException
at edu.uci.ics.hyracks.client.dataset.HyracksDatasetReader.nextPartition(HyracksDatasetReader.java:117)
at edu.uci.ics.hyracks.client.dataset.HyracksDatasetReader.read(HyracksDatasetReader.java:127)
at edu.uci.ics.asterix.result.ResultReader.read(ResultReader.java:58)
at edu.uci.ics.asterix.result.ResultUtils.displayResults(ResultUtils.java:88)
at edu.uci.ics.asterix.aql.translator.AqlTranslator.handleQuery(AqlTranslator.java:2056)
at edu.uci.ics.asterix.aql.translator.AqlTranslator.compileAndExecute(AqlTranslator.java:316)
at edu.uci.ics.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:546)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:970)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:411)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:192)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:904)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)
at org.eclipse.jetty.server.Server.handle(Server.java:347)
at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:439)
at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:924)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:781)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:220)
at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:43)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:545)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:43)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:529)
at java.lang.Thread.run(Thread.java:745)
Caused by: edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.storage.am.btree.exceptions.BTreeException: edu.uci.ics.hyra
cks.api.exceptions.HyracksDataException:
java.nio.channels.ClosedChannelException
at edu.uci.ics.hyracks.control.common.utils.ExceptionUtils.setNodeIds(ExceptionUtils.java:41)
at edu.uci.ics.hyracks.control.nc.Task.run(Task.java:296)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
... 1 more
Caused by: edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
edu.uci.ics.hyracks.storage.am.btree.exceptions.BTreeException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException: java.nio.channel
s.ClosedChannelException
at edu.uci.ics.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.nextFrame(IndexSearchOperatorNodePushable.java:201)
at edu.uci.ics.hyracks.dataflow.common.comm.util.FrameUtils.flushFrame(FrameUtils.java:38)
at edu.uci.ics.hyracks.algebricks.runtime.operators.std.EmptyTupleSourceRuntimeFactory$1.open(EmptyTupleSourceRuntimeFactory.java:55)
at edu.uci.ics.hyracks.algebricks.runtime.operators.meta.AlgebricksMetaOperatorDescriptor$1.initialize(AlgebricksMetaOperatorDescriptor.java:104)
at edu.uci.ics.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.initialize(SuperActivityOperatorNodePushable.java:81)
at edu.uci.ics.hyracks.control.nc.Task.run(Task.java:239)
... 3 more
Caused by: edu.uci.ics.hyracks.storage.am.btree.exceptions.BTreeException:
edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
java.nio.channels.ClosedChannelException
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.performOp(BTree.java:784)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.search(BTree.java:197)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.access$600(BTree.java:69)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree$BTreeAccessor.search(BTree.java:909)
at edu.uci.ics.hyracks.storage.am.lsm.btree.impls.LSMBTreeRangeSearchCursor.open(LSMBTreeRangeSearchCursor.java:206)
at edu.uci.ics.hyracks.storage.am.lsm.btree.impls.LSMBTreeSearchCursor.open(LSMBTreeSearchCursor.java:77)
at edu.uci.ics.hyracks.storage.am.lsm.btree.impls.LSMBTree.search(LSMBTree.java:431)
at edu.uci.ics.hyracks.storage.am.lsm.common.impls.LSMHarness.search(LSMHarness.java:255)
at edu.uci.ics.hyracks.storage.am.lsm.common.impls.LSMTreeIndexAccessor.search(LSMTreeIndexAccessor.java:95)
at edu.uci.ics.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.nextFrame(IndexSearchOperatorNodePushable.java:197)
... 8 more
Caused by: edu.uci.ics.hyracks.api.exceptions.HyracksDataException:
java.nio.channels.ClosedChannelException
at edu.uci.ics.hyracks.control.nc.io.IOManager.syncRead(IOManager.java:124)
at edu.uci.ics.hyracks.storage.common.buffercache.BufferCache.read(BufferCache.java:401)
at edu.uci.ics.hyracks.storage.common.buffercache.BufferCache.pin(BufferCache.java:148)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.performOp(BTree.java:600)
at edu.uci.ics.hyracks.storage.am.btree.impls.BTree.performOp(BTree.java:631)
... 17 more
Caused by: java.nio.channels.ClosedChannelException
at sun.nio.ch.FileChannelImpl.ensureOpen(FileChannelImpl.java:99)
at sun.nio.ch.FileChannelImpl.read(FileChannelImpl.java:679)
at edu.uci.ics.hyracks.control.nc.io.IOManager.syncRead(IOManager.java:112)
... 21 more
Original comment by ker...@gmail.com
on 10 Oct 2014 at 9:35
It looks like the file I/O has some issue.
Do you have disk failures on that machine?
Original comment by buyingyi@gmail.com
on 10 Oct 2014 at 9:37
Or the file is closed or has not been opened before being read? If so, it
should be a bug.
It seems LSM related. I assign this issue to Young-Seok.
Original comment by buyingyi@gmail.com
on 10 Oct 2014 at 9:43
Original comment by buyingyi@gmail.com
on 10 Oct 2014 at 9:45
No disk failures.
I will see with Young-Seok, thanks.
Original comment by ker...@gmail.com
on 10 Oct 2014 at 10:05
Keren, for the issue below (from your comment 3), I believe it is/can be
related to
Issue 16: count( dataset('dataset-name') ); should return count
use dataverse kereno;
count(for $t in dataset page_views return $t);
which returns a null[], see stack below:
Original comment by khfaraaz82
on 10 Oct 2014 at 10:38
Kharruam, they are separate issues. This one is a runtime issue - buffer cache
has closed channel. The old one was a compiler issue.
Original comment by buyingyi@gmail.com
on 10 Oct 2014 at 10:50
The exception stack seems that some concurrent operations(at least one writer)
were going on.
Is this reproducible?
Original comment by kiss...@gmail.com
on 11 Oct 2014 at 3:34
Original comment by ker...@gmail.com
on 19 Nov 2014 at 2:56
Original issue reported on code.google.com by
ker...@gmail.com
on 10 Oct 2014 at 5:53