Re: [Firebird-devel] SP crashing server

[Alex P. <pe...@in...>]

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.