Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Engine crash after recompiling one stored procedure and the triggers that calls the sp when users are using the triggers' table [CORE3513] #3871

Closed
firebird-automations opened this issue Jun 3, 2011 · 15 comments
Closed

Engine crash after recompiling one stored procedure and the triggers that calls the sp when users are using the triggers' table [CORE3513] #3871

firebird-automations opened this issue Jun 3, 2011 · 15 comments
Labels
affect-version: 2.1.4 affect-version: 2.5.0 component: engine priority: blocker resolution: duplicate type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Jesus Angel Garcia Zarco (cointec)

Duplicates CORE3524

Attachments:
fbcrash1.rar
GESTLAB21.part01.rar
GESTLAB21.part02.rar

2 users updating records from one table. If i recompile one stored procedure that is called by two triggers of that table, and after that i recompile the triggers, then the engine crash and fbserver is shutted down. I allways compile the stored procedure twice and then the triggers. Is complicated to reproduce the steps, because there are 3 transactions involved (2 from 2 instances of the application and another one altering metadata).

Can a dump help or do you need how to reproduce it from sql commands?. The second one is more complicated, because with the same steps not allways crash, i have tgo do it 2 or three times.

Firebird log file shows

PORTATIL06 (Server) Fri Jun 03 18:18:00 2011
Modifying procedure PET_FORMULA_CALC_RESULTADO which is currently in use by active user requests
PORTATIL06 (Server) Fri Jun 03 18:19:25 2011
Modifying procedure PET_FORMULA_CALC_RESULTADO which is currently in use by active user requests
PORTATIL06 (Server) Fri Jun 03 18:19:48 2011
Access violation.
The code attempted to access a virtual
address without privilege to do so.
This exception will cause the Firebird server
to terminate abnormally.
PORTATIL06 (Server) Fri Jun 03 18:19:48 2011
INET/inet_error: select in packet_receive errno = 10093
PORTATIL06 (Server) Fri Jun 03 18:19:48 2011
INET/select_wait: select failed, errno = 10093
PORTATIL06 (Server) Fri Jun 03 18:19:48 2011
SRVR_multi_thread/RECEIVE: error on main_port, shutting down
PORTATIL06 (Client) Fri Jun 03 18:19:48 2011
"C:\Firebird\Firebird_2_5\bin\fbserver.exe": terminated abnormally (4294967295)
PORTATIL06 (Client) Fri Jun 03 18:19:49 2011
Guardian starting: "C:\Firebird\Firebird_2_5\bin\fbserver.exe"
PORTATIL06 (Client) Fri Jun 03 18:20:51 2011
INET/inet_error: send errno = 10054
@firebird-automations
Copy link
Collaborator Author

Commented by: Jesus Angel Garcia Zarco (cointec)

I have tested it with 2.1.4 as is easyest to reproduce.

I execute the update of the table in one transaction without commit. After that i recompile the procedure and the triggers, and the engine crash

PORTATIL06 (Server) Fri Jun 03 19:11:56 2011
Modifying procedure PET_FORMULA_CALC_RESULTADO which is currently in use by active user requests
PORTATIL06 (Client) Fri Jun 03 19:11:59 2011
"C:\Firebird\Firebird_2_1\bin\fbserver.exe": terminated abnormally (4294967295)
PORTATIL06 (Client) Fri Jun 03 19:12:00 2011
Guardian starting: "C:\Firebird\Firebird_2_1\bin\fbserver.exe"

I'm going to create a little app to demonstrate the problem.

@firebird-automations
Copy link
Collaborator Author

Modified by: Jesus Angel Garcia Zarco (cointec)

Version: 2.1.4 [ 10361 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Jesus Angel Garcia Zarco (cointec)

This file contains one demo that crash the database witg firebird 2.1.4

@firebird-automations
Copy link
Collaborator Author

Modified by: Jesus Angel Garcia Zarco (cointec)

Attachment: fbcrash1.rar [ 11958 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Jesus Angel Garcia Zarco (cointec)

Database in firebird 2.1 part 1

@firebird-automations
Copy link
Collaborator Author

Modified by: Jesus Angel Garcia Zarco (cointec)

Attachment: GESTLAB21.part01.rar [ 11959 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Jesus Angel Garcia Zarco (cointec)

Database in 2.1.4 part 2

@firebird-automations
Copy link
Collaborator Author

Modified by: Jesus Angel Garcia Zarco (cointec)

Attachment: GESTLAB21.part02.rar [ 11960 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Jesus Angel Garcia Zarco (cointec)

Steps:

Run crash1.exe
Input databasename, user and password
click on connect
click on run step 1
click on run step 2 -> FB Crash

Doing the same steps 1 time or twice, and opening the database file from fb 2.5, also crash fb 2.5. (Note that the ODS is FB 2.1.4)

@firebird-automations
Copy link
Collaborator Author

Modified by: Jesus Angel Garcia Zarco (cointec)

security: Developers [ 10012 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Duplicate of CORE3524

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Link: This issue duplicates CORE3524 [ CORE3524 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affect-version: 2.1.4 affect-version: 2.5.0 component: engine priority: blocker resolution: duplicate type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@firebird-automations