RE: [-9111]: System error: Move error

[Alexei Novakov]

--- "Becker, Holger" <holger.becker@stripped> wrote:

> Alexei Novakov wrote:
> 
> > I trying out latest MaxDB version 7.5.0.26 and ran
> > into a problem with extremely simple query:
> > 
> > select T1.ENTITY_ID, T2.ENTITY_DOWN_FK
> > from ENTITY_E T1, RELATIONSHIP_R T2
> > where T1.ENTITY_ID = 3640722049958068233
> > and T2.TYPE_FK = 201104
> > and 3640722049958068233 = T2.ENTITY_UP_FK
> > order by T2.ORDER_R, 1, 2
> > 
> > It results: "[-9111]: System error: Move error" I
> > guess this is some kind of internal error. It
> supposed
> > to return 3 records in result set. It starts
> working
> > OK if I remove and of listed columns in "ORDER BY"
> > clause (for instance "order by T2.ORDER_R, 1"
> works
> > fine). It also works fine if I add T2.ORDER_R into
> > select.
> > 
> > Any ideas?
> 
> Hi,
> 
> you are right it's an internal error and there is
> more 
> information in the knldiag or knldiag.err about the
> problem.
> 
> Please send one of those file to the list.
> 
> Kind regards
> Holger
> 

Hi,

Yes I found corresponding message in the knldiag.err.
Here it is:

2005-06-04 13:13:23      0x67C ERR 11012 MOVECODE Bad
parameter: limit source 80 destination 80, source
[0X7E687858]+49, destination [0X7E687858]+0, 12 bytes
2005-06-04 13:13:23      0x67C ERR 51080 SYSERROR
-9111 Move error
2005-06-04 13:13:23      0x67C ERR 11012 MOVECODE +
2005-06-04 13:13:23.640 MOVECODE ERROR 11014
2005-06-04 13:13:23      0x67C ERR 11012 MOVECODE -  
Module Join_JoinOperator.cpp call index 3
2005-06-04 13:13:23      0x67C ERR 11012 MOVECODE Bad
parameter: limit source 80 destination 80, source
[0X7E687858]+49, destination [0X7E687858]+0, 12 bytes


Alexei.