RE: Implicit SERVERDB restart

[Elke Zabach]

Arne Gehlhaar wrote:
> 
> Hi,
> 
> I am trying to write an SQL statement that counts the number of 
> many-to-many references on a specific table (CalculationRule)
> 
> The query I use is:
> 
> select
>    cru.cruId,
>    (select count(cruId) from NebHasCru nhc where cru.cruId = 
> nhc.cruId) +
>    (select count(cruId) from VoyHasCru vhc where cru.cruId = 
> vhc.cruId) +
>    (select count(cruId) from OrdHasCru ohc where cru.cruId = 
> ohc.cruId) +
>    (select count(cruId) from DctHasCru dhc where cru.cruId = 
> dhc.cruId)
> from CalculationRule cru
> where cru.cruId = 2000
> 
> which executes without problems. But when I want to see the 
> individual 
> counts, the database server crashed and had to be restarted:
> 
> > ---- Error -------------------------------
> > Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
> > General error;800 Implicit SERVERDB restart (connection aborted).
> > select 
> >   cru.cruId, 
> >   (select count(cruId) from NebHasCru nhc where cru.cruId = 
> nhc.cruId) ,
> >   (select count(cruId) from VoyHasCru vhc where cru.cruId = 
> vhc.cruId) ,
> >   (select count(cruId) from OrdHasCru ohc where cru.cruId = 
> ohc.cruId) ,
> >   (select count(cruId) from DctHasCru dhc where cru.cruId = 
> dhc.cruId)
> > from CalculationRule cru 
> > where cru.cruId = 2000
> 
> Is this a known and/or fixed bug? I searched the mail archives but 
> didn't find anything helpful.
> 
> Versions:
> Kernel   Kernel 7.4.3  Build 010-00-035-462
> Runtime  X32/LINUX 7.4.3  Build 010-00-035-462
> 
> Arne


May I ask to use the newest version of 7.4.3 as we changed several things in the meantime.

May I ask, too, to provide the knldiag (the trace Back) of the crash to give us a chance
to find out if this is/was a known bug, fixed with version   xyz .

May I ask for the table definition (with some data) and the select causing the
core if even with the newest version this bug is in.

Elke
SAP Labs Berlin