IDS Forum

Re: error -285 Invalid cursor received by sqlexec.

Posted By: Fernando Nunes
Date: Tuesday, 2 August 2011, at 6:32 p.m.

In Response To: error -285 Invalid cursor received by sqlexec. (Cesar Inacio Martins)

Hmmm... I think the versions don't match... But:

- Do you have old 4GL clients connecting to that instance (7.20?) or old
CSDK (maybe 2.81?)
- Do the tables have decimal columns?
- Nothing more happens on the instance? AFs... bad query results?

Nevertheless you should open a PMR...

Regards

On Tue, Aug 2, 2011 at 10:18 PM, Cesar Inacio Martins <
cesar_inacio_martins@yahoo.com.br> wrote:

> Hi ,
>
> IDS 11.50 FC8 , AIX 6.1
>
> After a problem with creation online index , where the engine "lock" in
> some
> way the internal structure of the table and don't stop to raise errors -710
> for all tables with have foreign keys to table what the index was
> created...
> we need to force a bounce/start on the instance to stop this and allow the
> system company back functional.
>
> This is a problem, what there is no direct relation with the error on the
> subject of this message (I believed)
>
> *After this restart* of the instance , some applications (4gl 7.32 / aix
> 5.3)
> start abort with error -285 (Invalid cursor received by sqlexec) on the
> foreach command.
> Some of this applications are used daily for the users and they compilation
> was from 2 months ago (so, 2 months working without problems).
> The table what raise the error -285, there is any relationship with the
> table
> what the indexes are created and raise the error -710
>
> The curious is :
> - The error occur only when the SQLs have more of one host variables :
> declare xyz cursor select * from xyz where field1 = v_variable and field2 =
> v_variable2 ## get error 285 on the foreach
>
> declare xyz cursor select * from xyz where field1 = v_variable ## works
> declare xyz cursor select * from xyz where field1 = v_variable and field2 =
> 'abc' ## works
>
> - The problem appear occur always over the same tables (more of one
> program)
> - After recreate the indexes of the tables involved (drop online/create
> online), the error disappear... and back on the next day...
>
> - There is no corrupt data / index (at least, is what "oncheck" says... )
> - The error occur on the first "fetch" of the data (bellow , part of a
> stack
> trace, from AF trap)
>
> 0x00000001000b76a8 (oninit)afstack
>
> 0x00000001000b97bc (oninit)afhandler
>
> 0x0000000100130b90 (oninit)check_traperror
>
> 0x00000001001faa94 (oninit)sqerr
>
> 0x0000000100447374 (oninit)sql_nfetch
>
> 0x00000001004474f4 (oninit)sq_nfetch
>
> 0x000000010022463c (oninit)sqmain
>
> 0x000000010037c160 (oninit)listen_verify
>
> 0x000000010037a608 (oninit)spawn_thread
>
> 0x0000000100dd528c (oninit)startup
>
> This was confirmed by sqlidebug too.
>
> Executing a dummy 4gl program, with one of the SQL what abort the programs,
> We
> got the same error.
> +----------------------------------------------------------------
> | 2 main
> | 3 define s_teste char(5)
> | 4 define p_table RECORD LIKE tbl_table.*
>
> | 5 define l_intcod integer
> | 6
> | 7 let s_teste ='cesar'
> | 8 let l_intcod =72507
>
> | 9 DECLARE c01 CURSOR FOR
> | 10 SELECT *
> | 11 FROM tbl_table
> | 12 WHERE teste = s_teste AND
> | 13 intcod = l_intcod
> | 14 ORDER BY seqcod
> | 15
> | 16 FOREACH c01 INTO p_table.*
> | 17 end foreach
> | 18
> | 19
> | 20 end main
>
> |
> |
> |
> |(main.4gl:main)
>
> +----------------------------------------------------------------
> +----------------------------------------------------------------
> | sqlawarn = " "
> |end record
> |$run
> |Stopped in main at line 7 in module "main.4gl"
> |$s
>
> |Stopped in main at line 8 in module "main.4gl"
> |$s
> |Stopped in main at line 9 in module "main.4gl"
> |$s
>
> |Stopped in main at line 16 in module "main.4gl"
> |$s
> |Fatal error in main at line 16inmodule "main.4gl"
> | -285: Invalid cursor received by sqlexec.
> |$p sqlca
> |global:sqlca = record
> | sqlcode = -285
> | sqlerrm = (null)
>
> | sqlerrp = (null)
> | sqlerrd = {1, 0, 0, 1, 17, 0}
> | sqlawarn = " "
> |end record
>
> |$
> +----------------------------------------------------------------
>
> We cannot restart the instance again because of some business process what
> can't stop any more... and this is something what I don't believed should
> be a
> solution... This isn't a windows server ...
>
> Anyone already have some situation similar with this kind of error? (-285)
> Any tips?
>
> Attempts already tried :
> 1) Execute a update statistics over the table
> 2) Disable the Statement cache (onmode -e off) , but this command appear
> not
> working on the v11.50 FC8...
> 3) Recreate the indexes of the table (appear to works for a moment...and
> back
> the problem, but this was done only once and we not try again).
>
> Yes, is a very very odd situation.. but this is a production environment ,
> we
> can't play with stop/start of the instance...
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

--001485f6c822f0034504a98d52af

Messages In This Thread

• error -285 Invalid cursor received by sqlexec.
  Cesar Inacio Martins -- Tuesday, 2 August 2011, at 5:18 p.m.
  • Re: error -285 Invalid cursor received by sqlexec.
    Fernando Nunes -- Tuesday, 2 August 2011, at 6:32 p.m.
    • Re: error -285 Invalid cursor received by sqlexec.
      Cesar Inacio Martins -- Tuesday, 2 August 2011, at 9:20 p.m.
      • Re: error -285 Invalid cursor received by sqlexec.
        AJAY GUPTA -- Wednesday, 3 August 2011, at 1:28 p.m.
        • Re: error -285 Invalid cursor received by sqlexec.
          BRUCE THELEN -- Friday, 5 August 2011, at 3:03 p.m.
          • Re: error -285 Invalid cursor received by sqlexec.
            Cesar Inacio Martins -- Friday, 5 August 2011, at 4:45 p.m.
            • Re: error -285 Invalid cursor received by sqlexec.
              BRUCE THELEN -- Tuesday, 16 August 2011, at 1:12 p.m.
              • Re: error -285 Invalid cursor received by sqlexec.
                FRANK ARIAS -- Monday, 26 September 2011, at 12:59 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.