internal error in Oracle 8.1.7, SuSE linux 7.2

From: Laci <laci_at_gmx.ch>
Date: 14 Feb 2003 06:44:25 -0800
Message-ID: <41aadac6.0302140644.1f80f81d@posting.google.com>

Hi
Since I created several functional indexes for a table we're getting the follwing error on the server:

Exception signal: 11 (SIGSEGV)
*** 2003-02-14 16:48:05.785
ksedmp: internal or fatal error
Current SQL statement for this session:
SELECT VA_ADDRESSPARTNERINSURANCEPOOL.* FROM VA_ADDRESSPARTNERINSURANCEPOOL WHERE ( UPPER(ADDRESSSOURCEVN) = 'VN' AN
----- Call Stack Trace -----

calling              call     entry                argument values in
hex
location             type     point                (? means dubious

value)

-------------------- -------- --------------------
----------------------------
ksedmp()+142         CALL     ksedst()+0           
ssexhd()+198         CALL     ksedmp()+0           0 ?

etc...

On the client side it's a 'end-of-file on communication channel...

The indexes are on several columns, all with the function UPPER(). When we use each column separately in a where clause, everything's fine.
Most combinations of columns are ok, too. Just a few ( with an AND) give this
error.

I increased the system swap space, it didn't help.

Any ideas?

Thanks for your help
Laci Received on Fri Feb 14 2003 - 08:44:25 CST