3610!

[Lysen]

Hi all,

with this sql

select * from plato.agent
 where datumtot is null
   and anvr_nummer 
    in (  sel agentnummer 
         from plato.reservering
        where reserveringsnummer 
        in 
        ( sel distinct(reserveringsnummer)             from plato.pax
        where paxnaam = 'lysen')
       );

I get this error code:
3610: Internal error: Please do not resubmit the last request.

Does anyone know what this means of what to do?

 

[dnoeth]

Call your admin, he probably already knows about it:
This means a parser bug, the PE crashed and produced a mini dump.
That's why it says "Please do not resubmit the last request" ;-)

So you'll have to contact NCR support and open an incident.

Btw, in worst case this might crash the DBMS...

Dieter

 

[Lysen]

Thanks Dieter, for your reply.

So it's a pretty bad thing, that 3610...
It's a query that's been running fine during the night for months now, and all of a sudden this errorcode!

Could it be caused by the data? Or is it an bug in teradata software?

BTW how was your holiday in greece?

 

[dnoeth]

Hi Lysen,
if it was because of the data it probably would have been a DBMS crash (To check for corrupted data there's the CheckTable utility).

Did you modify the query?
Was the DBMS version/patch level switched?

You definitly should open an incident, but as a workaround a slight modification of the query is sometimes enough to remove a 3610:
You should remove the Distinct (because a Subquery is Distinct by default) or replace it with a
Group By reserveringsnummer

Or rewrite it as a join (untested):
select distinct a.*
from plato.agent a
join plato.reservering r
on a.anvr_nummer = r.agentnummer
join plato.pax p
on r.reserveringsnummer = p.reserveringsnummer
where a.datumtot is null
and p.paxnaam = 'lysen'



My holidays were great, i was there when Greece won the European Championship in soccer ;-)
It was the first time we had "all inclusive" and my children (3 and 5) enjoyed it most: Fruits/soft drinks/ice cream all day long and good children's animation.
But it was hard to get them away from the pool onto the beach and into the sea ;-)

Dieter

 

[Lysen]

Well, NCR contacted us because of the crashdumps, and told they were trying to reproduce the problem on their test machines.

We have a service contract and a software contract so they ordered new software which will arrive soon; then they 'll come over and install the latest update!