[Info-Ingres] E_OP0802 and SIGSEGV
Martin Bowes
Hi All.
II 10.0.0 (a64.lnx/132)NPTL + p14200
This simple query generates a SIGSEGV in the errlog.
SELECT v.field_id,v.value,COUNT(v.value) AS num_vals
FROM val_int v, field f
WHERE f.field_id IN (20001,20002,20003,20004)
AND f.field_id = v.field_id
AND v.value NOT IN (
SELECT c.ivalue FROM code_int c WHERE c.encoding_id = f.encoding_id
)
GROUP BY v.value,v.field_id
ORDER BY v.value, v.field_id
A QEP is:
QUERY PLAN 2,2, no timeout, of hash func aggregate producing temporary table T3
estimated 1 tups, 1 pages
aggregate expression -> T3A3 = count(*)
by expression attribute -> T3A2 = field_id
by expression attribute -> T3A1 = value
right join
Hash Join(value,
encoding_id)
Heap
Pages 1 Tups 1
D9462 C42769
/ \
Exchange Exchange
Heap Heap
Pages 327 Tups 36187 Pages 3764 Tups 3074567
Reduction 196 Reduction 8409
Threads 1 Threads 1
D1600 C362 D7095 C9724
/ /
Proj-rest K Join(field_id)
Sorted(NU) Heap
Pages 327 Tups 36187 Pages 3764 Tups 3074567
D1600 C362 D7095 C9724
/ / \
c Proj-rest v
B-Tree(NU) Sorted(field_id) B-Tree(field_id)
Pages 6401 Tups 36187 Pages 1 Tups 4 Pages 2118773 Tups 378051808
D6 C0 Partitions 4
/
f
B-Tree(field_id)
Pages 3546 Tups 6930
QUERY PLAN 1,1, no timeout, of main query
Sort Keep dups
Pages 1 Tups 1
D9463 C42769
/
Proj-rest
Heap
Pages 1 Tups 1
D9463 C42769
/
_VT_3_0_2_1
Heap
Pages 1 Tups 1
********************************************************************
E_OP08A2 Unexpected exception occurred within query compilation
Anyone got any ideas what may be causing this.
Martin Bowes
Martin Bowes
Hi All,
The error is produced when opf_pq_dop is set to 8. When set to 1 the query is fine.
I'll raise this with Actian as a bug.
Marty