Re: [Info-ingres] execution of a query results in a internal error

At 3:44 AM -0700 5/24/2006, dbecker wrote:
Hello,

Ingres Release II 3.0.2 on SuSE Linux 9.3 Professional reports an an
internal error, when trying to execute a query. The query works fine
until the result is larger than 83143 rows.
[snip]

SL93-RIS::[32771 , 9fb9fc40]: Mon May 22 04:55:06 2006
E_DM9712_SR_READ_ERROR Error occurred reading sort/hash join work
file -- path = /opt/CA/IngresII/ingres/work/default/risa
db, block 49.
read() failed with operating system error 0 (Success)

You have probably run afoul of one of the hash-join bugs that still
remained in the released version of 3.0.2. You have three options
that I can think of:
- ask Ingres Support for a link to a 3.0.3 release for your platform.
3.0.3 fixes nearly all of the remaining known hash join bugs and does
not require any upgrade. We don't publicly link to it because 3.0.3
uses the old CA-TOSL license.
- Upgrade to Ingres 2006, which also fixes nearly all of the remaining
known hash join bugs (all but one, if memory serves, and you aren't
hitting that last one). The move to Ingres 2006 does require upgradedb
to run, but the changes are trivial (versioning and some system catalog
view fixes).
- run your query with "set nohash", which turns off hash joining.
It will probably run more slowly but you should get the right answer
in all cases, even with 3.0.2.

Karl
.

Relevant Pages

  • Re: Few questions concerning Ingres 2006
    ... correspondence, a table that holds ... attachments to correspondences. ... formed query on a toy database that I happen to have handy (this should be ... It is quite rare that Ingres produces a bad query ...
    (comp.databases.ingres)
  • Re: jdbc-query tracing/logging
    ... A remote client can query the ... > This client is a complete blackbox. ... I do not have any idea what kind of queries. ... Fortunately the Ingres resource limiter ...
    (comp.databases.ingres)
  • Re: Few questions concerning Ingres 2006
    ... a subquery is the most ... attachments to correspondences. ... formed query on a toy database that I happen to have handy (this should be ... INGRES TERMINAL MONITOR Copyright 2007 Ingres Corporation ...
    (comp.databases.ingres)
  • execution of a query results in a internal error
    ... Ingres Release II 3.0.2 on SuSE Linux 9.3 Professional reports an an ... when trying to execute a query. ... 'REP' as Attributregelart, attersetzen.ereignis2sn, sbdat ... E_SC0206_CANNOT_PROCESS An internal error prevents further ...
    (comp.databases.ingres)
  • Re: how do we tune a large sql query
    ... engines for a major vendor observed that SQL Server people do not trust ... The classic one was a test done by Fabian Pascal in DATABASE ... He wrote the same query seven different ways and ran them on various ... Ingres knew they were logically identical and produces the fastest ...
    (comp.databases.ms-sqlserver)