ISQL: provide switch to immediatelly cancel script containing many 'heavy
statements' if database in shutdown or any engine error occured
-----------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-4232
URL: http://tracker.firebirdsql.org/browse/CORE-4232
Project: Firebird Core
Issue Type: Improvement
Components: ISQL
Affects Versions: 3.0 Alpha 1
Reporter: Pavel Zotov
I have a few huge scripts to be handled by ISQL. These scripts contains many
EXECUTE BLOCKs delimited by COMMIT statement.
Each of EB, in turn, does a lot of DML.
For some test purpoces its needed to stop immediately all of ISQLs if server
has been crashed or detected some serious error in database.
But ISQL will continue after error that enountered on N-th statement and will
see that FB is (again) alive - due to fbguard that 'lifted up' FB process.
The "-b" switch (or the command issued inside ISQL prompt: set bail on) -
doesn`t help in such situation:
sesson #1
########
-- run THREE 'heavy statement':
select count(*) from rdb$fields, rdb$fields, rdb$fields, rdb$fields; select
count(*) from rdb$relations; select count(*) from rdb$relations;
session #2
#########
gfix -shut full -force 0
session #1
#########
COUNT
============
Statement failed, SQLSTATE = HY000
database C:\MIX\FIREBIRD\TB.FDB shutdown ----- (1)
Statement failed, SQLSTATE = HY000
database C:\MIX\FIREBIRD\TB.FDB shutdown ----- (2)
Statement failed, SQLSTATE = HY000
database C:\MIX\FIREBIRD\TB.FDB shutdown ----- (3)
As we can see, ISQL attempted to run 2nd and 3rd statements after first error.
Is it possible to implement such func. that (2) and (3) will NOT appear and
ISQL immediately will finish ?
(not only on case db shutdown - i'm speaking about ANY error)
--
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
------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
