Dmitry Lychagin created ASTERIXDB-3016: ------------------------------------------
Summary: Failure in hash groupby: Failed to insert a new buffer into the aggregate operator Key: ASTERIXDB-3016 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3016 Project: Apache AsterixDB Issue Type: Bug Components: RT - Runtime Affects Versions: 0.9.6 Reporter: Dmitry Lychagin Assignee: Dmitry Lychagin Fix For: 0.9.8 Load the data as follows: {noformat} drop dataverse tpcds if exists; create dataverse tpcds; use tpcds; create dataset item(i_item_sk string not unknown) open type primary key i_item_sk; create dataset inventory(inv_date_sk string not unknown, inv_item_sk string not unknown, inv_warehouse_sk string not unknown) open type primary key inv_date_sk, inv_item_sk, inv_warehouse_sk; {noformat} {noformat} use tpcds; set `import-private-functions` `true`; insert into item (select value object_remove(t, "table_name") from tpcds_datagen("item", 0.5) t); insert into inventory (select value object_remove(t, "table_name") from tpcds_datagen("inventory", 0.5) t); {noformat} Run the following query: {noformat} SELECT i.i_product_name, AVG(inv.inv_quantity_on_hand) qoh FROM inventory inv, item i WHERE inv.inv_item_sk /*+hash-bcast*/ = i.i_item_sk /*+ hash */ GROUP BY i.i_product_name ORDER BY qoh, i.i_product_name LIMIT 1; {noformat} The query fails with: {noformat} org.apache.hyracks.api.exceptions.HyracksDataException: Failed to insert a new buffer into the aggregate operator! at org.apache.hyracks.dataflow.std.group.external.ExternalHashGroupBy.insert(ExternalHashGroupBy.java:57) ~[classes/:?] at org.apache.hyracks.dataflow.std.group.external.ExternalGroupWriteOperatorNodePushable.buildGroup(ExternalGroupWriteOperatorNodePushable.java:175) ~[classes/:?] at org.apache.hyracks.dataflow.std.group.external.ExternalGroupWriteOperatorNodePushable.doPass(ExternalGroupWriteOperatorNodePushable.java:146) ~[classes/:?] at org.apache.hyracks.dataflow.std.group.external.ExternalGroupWriteOperatorNodePushable.initialize(ExternalGroupWriteOperatorNodePushable.java:108) ~[classes/:?] {noformat} Also the test framework prints the following error: {noformat} java.lang.AssertionError: There are 7 leaked run files. {noformat} -- This message was sent by Atlassian Jira (v8.20.1#820001)