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

Server crash when executing syntactically wrong SQL statement with an active trace session [CORE2852] #3237

Closed
firebird-automations opened this issue Feb 8, 2010 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Thomas Steinmaurer (tsteinmaurer)

I have a reproducable server crash with the Trace API here:

Windows XP Prof.
Firebird 2.5 Snapshot Build 25920 - SuperClassic

The following user trace configuration is used:

<database tourism.fdb>
enabled true
log_connections true
log_transactions true
log_statement_prepare true
log_statement_free true
log_statement_start true
log_statement_finish true
log_procedure_start true
log_procedure_finish true
log_trigger_start true
log_trigger_finish true
log_context true
print_plan true
print_perf true
log_blr_requests true
print_blr true
log_dyn_requests true
print_dyn true
</database>
<services>
</services>

Usage:

fbtracemgr.exe -se localhost/3051:service_mgr -user sysdba -password masterkey -start -name "My Trace" -config trace.conf

Now, in isql:

select * From customer;

works fine. I get a result set in isql and the trace output is written to stdout. Now, executing a syntactical wrong statement, e.g.:

select customer;

In both sesssions, isql and trace output, I get an unable to complete network request to host "localhost" error message.

In isql:

Statement failed, SQLCODE = 08006
Unable to complete network request to host "localhost".
-Error reading data from the connection.

In trace output:
Unable to complete network request to host "localhost".
-Error reading data from the connection.

If there is no trace session running, isql complains about the wrong SQL statement and the server is keep on running.

Commits: b9012c8 b3a3268

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

The fix is too late for v2.5 RC2, AFAIU, so it will be included into next release (probably RC3)

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.0 [ 10221 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Version: 2.5 RC2 [ 10372 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 2.5 RC3 [ 10381 ]

summary: Server crash when executing syntactical wrong SQL statement with an active trace session => Server crash when executing syntactically wrong SQL statement with an active trace session

Fix Version: 2.5.0 [ 10221 ] =>

@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
Projects
None yet
Development

No branches or pull requests

2 participants