Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
comp.databases.ingres
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
E_OP0802 and SIGSEGV
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   2 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Martin Bowes  
View profile  
 More options Jan 16, 8:47 am
Newsgroups: comp.databases.ingres
From: Martin Bowes <martin.bo...@ctsu.ox.ac.uk>
Date: Mon, 16 Jan 2012 13:47:59 +0000
Local: Mon, Jan 16 2012 8:47 am
Subject: [Info-Ingres] E_OP0802 and SIGSEGV
Print | Individual message | Show original | Report this message | Find messages by this author

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


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Martin Bowes  
View profile  
 More options Jan 16, 9:21 am
Newsgroups: comp.databases.ingres
From: Martin Bowes <martin.bo...@ctsu.ox.ac.uk>
Date: Mon, 16 Jan 2012 14:21:11 +0000
Local: Mon, Jan 16 2012 9:21 am
Subject: Re: [Info-Ingres] E_OP0802 and SIGSEGV
Print | Individual message | Show original | Report this message | Find messages by this author

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

From: Martin Bowes [mailto:martin.bo...@ctsu.ox.ac.uk]
Sent: 16 January 2012 13:48
To: Ingres and related product discussion forum
Subject: [Info-Ingres] E_OP0802 and SIGSEGV

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


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2012 Google