Compiling stored procedure while in use shutdown database
---------------------------------------------------------
Key: CORE-3524
URL: http://tracker.firebirdsql.org/browse/CORE-3524
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.0
Environment: Windows 2003 server. FB 2.5 Superserver
Reporter: Jesus Angel Garcia Zarco
Our database has one stored procedure called from 2 triggers. Today doing
something that has been done before without problem, that is compile one stored
procedure while others users connected to the database, and recompiling the two
triggers that calls the stored procedure makes the server crash. I have done
the process 2 times. First i have recompiled the stored procedure and the two
triggers and 7 minutes after i have done the process again. After the second
time, the database has been sutted down, when compiling the triggers that calls
the stored procedure.
This is the firebird log file.
SVD13SL03 (Server) Mon Dec 13 13:02:07 2010
Modifying procedure PET_FORMULA_CALC_RESULTADO which is currently in use by
active user requests
SVD13SL03 (Server) Mon Dec 13 13:09:51 2010
Modifying procedure PET_FORMULA_CALC_RESULTADO which is currently in use by
active user requests
SVD13SL03 (Client) Mon Dec 13 13:10:02 2010
"C:\Archivos de programa\Firebird\Firebird_2_5\bin\fbserver.exe": terminated
abnormally (4294967295)
SVD13SL03 (Client) Mon Dec 13 13:10:07 2010
Guardian starting: "C:\Archivos de
programa\Firebird\Firebird_2_5\bin\fbserver.exe"
SVD13SL03 (Client) Mon Dec 13 13:10:09 2010
INET/inet_error: send errno = 10054
SVD13SL03 (Client) Mon Dec 13 13:11:00 2010
INET/inet_error: send errno = 10054
SVD13SL03 (Client) Mon Dec 13 13:11:00 2010
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost
SVD13SL03 (Client) Mon Dec 13 13:11:59 2010
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost
--
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
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
