Creating external function (udf) to not existing dll - and then procedure with
it - crash server
------------------------------------------------------------------------------------------------
Key: CORE-4172
URL: http://tracker.firebirdsql.org/browse/CORE-4172
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: Windows XP Prof SP3
Reporter: Karol Bieniaszewski
Priority: Critical
I do all by flamerobin
1. Create 2 databases - i use 16KB pages WIN1250 - but i suppose not the case
and connect only for first db
2.
then create external function to not existed dll on HDD
DECLARE EXTERNAL FUNCTION LICZ_XXX
integer
RETURNS integer BY VALUE
ENTRY_POINT 'LICZ_XXX'
MODULE_NAME 'XXX_UDF';
commit;
3. then try to create procedure with this udf
SET TERM ^ ;
CREATE PROCEDURE bbb
( ccc integer )
RETURNS
( ddd integer )
AS
BEGIN
ddd = LICZ_XXX(ccc);
suspend;
END^
SET TERM ; ^
try commit
*** IBPP::SQLException ***
Context: Transaction::Commit
SQL Message : -104
can't format message 13:896 -- message file C:\WINDOWS\system32\firebird.msg
not found
Engine Code : 335544343
Engine Message :
invalid request BLR at offset 40
function LICZ_XXX is not defined
module name or entrypoint could not be found
4.
aboce is ok and now
rollback transaction;
5. try to connect to second db - FB crashes
VIRTUALXP-28174 Wed Aug 07 08:28:05 2013
Database: C:\DOCUMENTS AND SETTINGS\XPMUSER\PULPIT\KBSQLSTAT\DWA.FDB
Allocated 57516 page buffers of 65536 requested
VIRTUALXP-28174 Wed Aug 07 08:28:05 2013
Operating system call _beginthreadex failed. Error code 8
VIRTUALXP-28174 Wed Aug 07 08:28:05 2013
Database: C:\DOCUMENTS AND SETTINGS\XPMUSER\PULPIT\KBSQLSTAT\DWA.FDB
internal Firebird consistency check (cannot start cache writer thread)
VIRTUALXP-28174 Wed Aug 07 08:28:05 2013
"C:\Program Files\Firebird\Firebird_3_0\firebird.exe": terminated
abnormally (4294967295)
VIRTUALXP-28174 Wed Aug 07 08:28:05 2013
Shutting down the server with 1 active connection(s) to 1 database(s),
0 active service(s)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead.
Download for free and get started troubleshooting in minutes.
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
