You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I can confirm that there is a problem, but it's very hard to point a finger on the source. I was able to reproduce the "Error reading data
from the connection." with remote connection to Classic FB 2.0 (over xinetd on my SuSE 9.3), but the same Classic with local connection works just fine, and 2.0 Super Server works as well.
Problem appears only when *both* EXECUTE PROCEDURE and UDF call are in stored procedure (it doesn't matter where and in what form). There is nothing special or wrong about the UDF, procedure code, used libraries, whatever.
No messages in firebird.log. There is next entry in xinetd log:
That means that Firebird died on Invalid memory reference that has to be somehow related to fb_inet_server thought (as local classic and SS works).
Instructions to reproduce.
1. restore database from 'bug1.gbak'
2. Untar the archive 'udfbug.tgz'
3. build the library 'http://udfbug.so'
$ cd udfbug; make
4. From isql do
$ isql localhost:bug1.gdb
SQL>select * from calc_all;
gives
RES
Statement failed, SQLCODE = -902
Error reading data from the connection.
Stored procedure CALC_ALL consist of 2 parts. If one of these parts (any) are commented then it runs ok. it always crash with fresh
connection to database (may not if there are other commands before the select from procedure).
The text was updated successfully, but these errors were encountered:
Submitted by: @pcisar
Duplicates CORE982
Attachments:
bug1.gbak
udfbug.tgz
bug1.sh
Reported by FB user.
I can confirm that there is a problem, but it's very hard to point a finger on the source. I was able to reproduce the "Error reading data
from the connection." with remote connection to Classic FB 2.0 (over xinetd on my SuSE 9.3), but the same Classic with local connection works just fine, and 2.0 Super Server works as well.
Problem appears only when *both* EXECUTE PROCEDURE and UDF call are in stored procedure (it doesn't matter where and in what form). There is nothing special or wrong about the UDF, procedure code, used libraries, whatever.
No messages in firebird.log. There is next entry in xinetd log:
06/12/10@15:47:00: START: gds_db from=127.0.0.1
06/12/10@15:47:00: EXIT: gds_db signal=11 duration=0(sec)
That means that Firebird died on Invalid memory reference that has to be somehow related to fb_inet_server thought (as local classic and SS works).
Instructions to reproduce.
1. restore database from 'bug1.gbak'
2. Untar the archive 'udfbug.tgz'
3. build the library 'http://udfbug.so'
$ cd udfbug; make
4. From isql do
$ isql localhost:bug1.gdb
SQL>select * from calc_all;
RES
Statement failed, SQLCODE = -902
Error reading data from the connection.
Stored procedure CALC_ALL consist of 2 parts. If one of these parts (any) are commented then it runs ok. it always crash with fresh
connection to database (may not if there are other commands before the select from procedure).
The text was updated successfully, but these errors were encountered: