Re: [Firebird-devel] SP crashing server

[Fabiano B. <fa...@pe...>]

Alex Peshkov escreveu:
> Fabiano Bonin wrote:
>> Milan Babuskov escreveu:
>>
>>> Fabiano Bonin wrote:
>>>
>>>> Ops, maybe it's a IBExpert issue. It seems it runs OK in isql.
>>>> Maybe someone want to give it a try.
>>>
>>>
>>> Are you using the same connection string in both tools?
>>>
>>>
>>> I just tried with FlameRobin (against Classic Server). Firebird 
>>> didn't crash, but I got this:
>>>
>>> Message: isc_dsql_fetch failed.
>>>
>>> SQL Message : -501
>>> The cursor identified in a FETCH or CLOSE statement is not open.
>>>
>>> Engine Code    : 335544327
>>> Engine Message :
>>> invalid request handle
>>>
>>>
>>
>> You got a point here!
>>
>> If i connect with isql using the same string, the error appears:
>>
>> [root@servidor clientes]# isql 127.0.0.1:/share/clientes/trevilub.fdb 
>> -user sysdba -pass ????????
>> Database:  127.0.0.1:/share/clientes/trevilub.fdb, User: sysdba
>> SQL> select * from sp_record_count(null);
>>
>> TABLE_NAME                      RECORD_COUNT
>> =============================== ============
>> Statement failed, SQLCODE = -902
>>
>> Error reading data from the connection.
>>
> 
> I've repeated this 1000 times on linux with yesterday's HEAD :
> 
> echo 'select * from sp_record_count(null);' | ./isql -user sysdba -pas 
> masterke 127.0.0.1:/data/test.fdb
> 
> No problems were found.
> 
> Alex.

Is your database big enough?

Maybe it's something related with my metadata, but i can reproduce this 
behaviour with all my customers databases.

I have a 10MB database (zipped) where this error can be reproduced, if 
you need.