search

br1ghtyang / asterixdb

Automatically exported from code.google.com/p/asterixdb
0 stars 0 forks source link

TPC-H q5 array index out of bounds exception #557

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
To reproduce the issue, run q5 in the web interface on SF=1 with 3 nodes, the 
default configuration, and one IO device.

After one runs q5, the managix stop command hangs.  Thanks in advance for 
dealing with this bug.

Original issue reported on code.google.com by cmcintyr...@gmail.com on 8 Jul 2013 at 9:12

GoogleCodeExporter commented 8 years ago 
I forgot to mention that q5 gets an array index out of bounds exception after 
it is run.

Original comment by cmcintyr...@gmail.com on 8 Jul 2013 at 9:14

GoogleCodeExporter commented 8 years ago

Original comment by westm...@gmail.com on 19 Jul 2013 at 4:36

GoogleCodeExporter commented 8 years ago 
The error for the query disappears if I modify the query to the attached query 
and run it under the same conditions.  The section with the sum function was 
removed.  The query also fails with the same exception if sum is replaced with 
other aggregation functions such as min.

Original comment by cmcintyr...@gmail.com on 27 Jul 2013 at 12:13

Attachments:

GoogleCodeExporter commented 8 years ago 
The original query.

Original comment by westm...@gmail.com on 29 Jul 2013 at 5:41

GoogleCodeExporter commented 8 years ago 
Here's the corrected version of q05_mod.aql.

Original comment by cmcintyr...@gmail.com on 29 Jul 2013 at 6:22

Attachments:

GoogleCodeExporter commented 8 years ago 
Here are the optimized logical plans for q05 and q05_mod.

Original comment by cmcintyr...@gmail.com on 29 Jul 2013 at 6:25

Attachments:

GoogleCodeExporter commented 8 years ago 
Here's a version of q05 that shows the behavior but does not have the 
aggregation.

Original comment by cmcintyr...@gmail.com on 29 Jul 2013 at 9:13

Attachments:

GoogleCodeExporter commented 8 years ago 
stack trace of the error

Original comment by westm...@gmail.com on 29 Jul 2013 at 9:19

Attachments:

GoogleCodeExporter commented 8 years ago 
q05 no longer gets this error and now gets the correct results with the fixed 
version of q05 (attached).

Original comment by cmcintyr...@gmail.com on 31 Jul 2013 at 12:44

Attachments:

GoogleCodeExporter commented 8 years ago 
Pouria - please reassign to Till when the Hyracks fix that you are doing is in 
master.

Original comment by dtab...@gmail.com on 2 Aug 2013 at 5:54

GoogleCodeExporter commented 8 years ago

Original comment by dtab...@gmail.com on 2 Aug 2013 at 5:56

GoogleCodeExporter commented 8 years ago 
Pouria pushed his fix to master, so re-assigning issue to Till.

Original comment by pouria.p...@gmail.com on 2 Aug 2013 at 5:59

GoogleCodeExporter commented 8 years ago

Original comment by westm...@gmail.com on 9 Aug 2013 at 5:01