Issue Details (XML | Word | Printable)

Key: CORE-4319
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Pavel Zotov
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias

Created: 19/Jan/14 08:09 AM   Updated: 26/Dec/15 12:45 PM
Component/s: Engine
Affects Version/s: 2.5.2 Update 1, 3.0 Alpha 1
Fix Version/s: 2.5.3, 3.0 Beta 1

File Attachments: 1. Zip Archive gdb-firebird.140119_115916.1.zip (14 kB)


QA Status: Done successfully


 Description  « Hide
LI-T3.0.0.30824

Scenario:
1. Window #1.
Running trace:

/opt/fb30trnk/bin/fbtracemgr -sta -c ztrace.conf -se localhost/3333:service_mgr
Trace session ID 1 started

2. Window #2.
$ /opt/fb30trnk/bin/isql -q
-- now trying to connect to alias that doesn`t present in databases.conf:
SQL> connect 'localhost/3333:nosuchdatabase';

Output in ISQL:
Statement failed, SQLSTATE = 08006
Error reading data from the connection.

Output in trace:
Error reading data from the connection.

After that coredump file is created, stacktrace for it see in attach.

PS-1. Trace config contains the following lines:

$ cat ztrace.conf
database = #
{
  enabled = true
  log_filename = /opt/fb30cs/ztrace.log
  log_sweep = true
  log_errors = true

  #################### A C H T U N G ##############
  time_threshold = 0
  connection_id=84
  ####################################################

  log_connections = true
  log_transactions = true

  #log_statement_prepare = true
  #log_statement_start = true
  #log_statement_free = true

  log_trigger_start = true
  log_procedure_start = true

  log_statement_finish = true
  log_procedure_finish = true
  log_trigger_finish = true

  print_plan = true
  print_perf = true
  max_sql_length = 8192
  max_log_size = 5000000
}

Please note that line with 'connection_id=84' is erroneously UNcommented.


PS-2. I have several instances of FB on that machine but currently only one is running:
$ ps aux|grep fir|grep -v grep
firebird 6030 0.0 0.0 28200 940 ? S 11:53 0:00 /opt/fb30trnk/bin/fbguard -pidfile /var/run/fb30trnk/fb30trnk.pid -daemon -forever
firebird 6237 0.0 0.0 300328 7012 ? Sl 11:59 0:00 /opt/fb30trnk/bin/firebird


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Zotov made changes - 19/Jan/14 08:09 AM
Field Original Value New Value
Attachment gdb-firebird.140119_115916.1.zip [ 12412 ]
Pavel Zotov made changes - 19/Jan/14 08:15 AM
Summary Engine crashes when trace session is opened and we try to connect to non-existent database/alias Engine crashes when trace config contains line "connection_id=NN" we try to connect to non-existent database/alias
Pavel Zotov made changes - 19/Jan/14 08:15 AM
Description Scenario:
1. Window #1.
Running trace:

/opt/fb30trnk/bin/fbtracemgr -sta -c ztrace.conf -se localhost/3333:service_mgr
Trace session ID 1 started

2. Window #2.
$ /opt/fb30trnk/bin/isql -q
-- now trying to connect to alias that doesn`t present in databases.conf:
SQL> connect 'localhost/3333:nosuchdatabase';

Output in ISQL:
Statement failed, SQLSTATE = 08006
Error reading data from the connection.

Output in trace:
Error reading data from the connection.

After that coredump file is created, stacktrace for it see in attach.

PS-1. Trace config contains the following lines:

$ cat ztrace.conf
database = #
{
  enabled = true
  log_filename = /opt/fb30cs/ztrace.log
  log_sweep = true
  log_errors = true

  #################### A C H T U N G ##############
  time_threshold = 0
  connection_id=84
  ####################################################

  log_connections = true
  log_transactions = true

  #log_statement_prepare = true
  #log_statement_start = true
  #log_statement_free = true

  log_trigger_start = true
  log_procedure_start = true

  log_statement_finish = true
  log_procedure_finish = true
  log_trigger_finish = true

  print_plan = true
  print_perf = true
  max_sql_length = 8192
  max_log_size = 5000000
}

Please note that line with 'connection_id=84' is erroneously UNcommented.


PS-2. I have several instances of FB on that machine but currently only one is running:
$ ps aux|grep fir|grep -v grep
firebird 6030 0.0 0.0 28200 940 ? S 11:53 0:00 /opt/fb30trnk/bin/fbguard -pidfile /var/run/fb30trnk/fb30trnk.pid -daemon -forever
firebird 6237 0.0 0.0 300328 7012 ? Sl 11:59 0:00 /opt/fb30trnk/bin/firebird
LI-T3.0.0.30824

Scenario:
1. Window #1.
Running trace:

/opt/fb30trnk/bin/fbtracemgr -sta -c ztrace.conf -se localhost/3333:service_mgr
Trace session ID 1 started

2. Window #2.
$ /opt/fb30trnk/bin/isql -q
-- now trying to connect to alias that doesn`t present in databases.conf:
SQL> connect 'localhost/3333:nosuchdatabase';

Output in ISQL:
Statement failed, SQLSTATE = 08006
Error reading data from the connection.

Output in trace:
Error reading data from the connection.

After that coredump file is created, stacktrace for it see in attach.

PS-1. Trace config contains the following lines:

$ cat ztrace.conf
database = #
{
  enabled = true
  log_filename = /opt/fb30cs/ztrace.log
  log_sweep = true
  log_errors = true

  #################### A C H T U N G ##############
  time_threshold = 0
  connection_id=84
  ####################################################

  log_connections = true
  log_transactions = true

  #log_statement_prepare = true
  #log_statement_start = true
  #log_statement_free = true

  log_trigger_start = true
  log_procedure_start = true

  log_statement_finish = true
  log_procedure_finish = true
  log_trigger_finish = true

  print_plan = true
  print_perf = true
  max_sql_length = 8192
  max_log_size = 5000000
}

Please note that line with 'connection_id=84' is erroneously UNcommented.


PS-2. I have several instances of FB on that machine but currently only one is running:
$ ps aux|grep fir|grep -v grep
firebird 6030 0.0 0.0 28200 940 ? S 11:53 0:00 /opt/fb30trnk/bin/fbguard -pidfile /var/run/fb30trnk/fb30trnk.pid -daemon -forever
firebird 6237 0.0 0.0 300328 7012 ? Sl 11:59 0:00 /opt/fb30trnk/bin/firebird
Dmitry Yemanov made changes - 19/Jan/14 10:20 AM
Assignee Vlad Khorsun [ hvlad ]
Component/s Engine [ 10000 ]
Pavel Zotov made changes - 19/Jan/14 10:32 AM
Summary Engine crashes when trace config contains line "connection_id=NN" we try to connect to non-existent database/alias Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
Vlad Khorsun made changes - 20/Jan/14 10:19 AM
Fix Version/s 2.5.3 [ 10461 ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Affects Version/s 3.0 Alpha 1 [ 10331 ]
Affects Version/s 2.5.2 Update 1 [ 10521 ]
Component/s TRACEMGR [ 10140 ]
Vlad Khorsun made changes - 20/Jan/14 10:24 AM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Pavel Cisar made changes - 22/Sep/15 09:40 AM
Status Resolved [ 5 ] Closed [ 6 ]
Pavel Zotov made changes - 26/Dec/15 12:45 PM
Status Closed [ 6 ] Closed [ 6 ]
QA Status Done successfully