Manipulations with GTT from several attachments (using ES/EDS and different
roles) leads to: "internal Firebird consistency check (invalid SEND request
(167), file: JrdStatement.cpp line: 325)"
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-4754
URL: http://tracker.firebirdsql.org/browse/CORE-4754
Project: Firebird Core
Issue Type: Bug
Reporter: Pavel Zotov
WI-T3.0.0.31789, reproduced in SuperServer and SuperClassic.
The following script:
recreate global temporary table gtt_session(x int, y int) on commit preserve
rows;
commit;
set transaction read committed;
set term ^;
execute block as -- returns(att_id int, cnt int, sql_plan blob, idx_stat double
precision) as
declare v_dbname type of column mon$database.mon$database_name;
begin
v_dbname = 'localhost:' || rdb$get_context('SYSTEM', 'DB_NAME');
execute statement 'insert into gtt_session select rand()*10, rand()*10 from
rdb$types union all select -2, -3 from rdb$database'
on external v_dbname
as user 'sysdba' password 'masterke' role 'poor_dba';
--------------------------------------------------------
execute statement 'insert into gtt_session select rand()*10, rand()*10 from
rdb$types union all select -2, -3 from rdb$database'
on external v_dbname
as user 'sysdba' password 'masterke' role 'cool_dba';
execute statement 'create index gtt_session_x_y on gtt_session computed by (
x+y )'
with autonomous transaction
on external v_dbname
as user 'sysdba' password 'masterke' role 'cool_dba';
--------------------------------------------------------
execute statement 'insert into gtt_session select rand()*10, rand()*10 from
rdb$types union all select -2, -3 from rdb$database'
on external v_dbname
as user 'sysdba' password 'masterke' role 'super_dba';
end
^
set term ;^
-- leads to:
1) appearing in firebird.log message:
===
CSPROG Fri Apr 17 21:24:38 2015
Database: C:\MIX\firebird\QA\fbt-repo\tmp\e30.fdb
internal Firebird consistency check (invalid SEND request (167), file:
JrdStatement.cpp line: 325)
===
2) appearing 'abend message' on Windows XP with:
2.1) singnature of error:
szAppName : firebird.exe szAppVer : 3.0.0.31789 szModName : msvcr100.dll
szModVer : 10.0.30319.415 offset : 0008cb95
2.2) notion about two files (which have been attached here): firebird.exe.mdmp
and appcompat.txt
3) After this message will appear:
3.1) ISQL can not finish script, and can not be interrupted;
3.2) no new attaches can be etsablished to any other .fdb
3.3) these ISQLs loads CPU up to 100% and also can not be interrupted - even
after killing firebird process.
All necessary files please see in attached .zip
--
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
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
