The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Hello dear forum,

Today I have installed the new version of SA (17.0.6.2757 SP 1), and I found out that it is possible to crash dbsrv17.exe (64-bit) with the SQL Profiler, if you choose the option as you see in the image below:

alt text

To reproduce this, please follow steps:

  1. Start the profiler;
  2. Choose "Targeted";
  3. Click "Insert Criteria" and choose "sql_string";
  4. Remove the number 10 (seconds) in the text box above;
  5. Press OK
  6. Start dbsrv17, because it should crash :(

My purpose was to trace all SQL statements that have the specific table name (I was trying to capture what the application is doing with the DB). I have already submitted two crash reports, but I'd like to hear from you, whether you have the same behavior.

p.s. maybe this isn't a bug, but a feature.

Thanks,
Vlad

asked 19 Dec '16, 09:50

Vlad's gravatar image

Vlad
3165923
accept rate: 0%

maybe this isn't a bug, but a feature

Ah yes, something to add to the list of reproducible actions to crash the database server, as created by Reimer:

How to crash a SA11 engine with a simple SQL statement

(although here it's no simple SQL statement, apparently...)

(19 Dec '16, 10:00) Volker Barth
Replies hidden

And a nice way to introduce 17.0.6 - I wasn't aware of that:)

(Studying the readme it seems that one has not the same number of new features as 17.0.4...)

(19 Dec '16, 10:01) Volker Barth

I forgot to mention, even with an empty DB, one can crash the process. Do you have a chance to check my steps?

(19 Dec '16, 10:25) Vlad

Sorry, not currently... - I have not yet installed the EBF:(

(19 Dec '16, 10:34) Volker Barth

This definitely is bug, not a "feature". We'll look into it.

-- Chris Irie (SQL Anywhere engineering)

permanent link

answered 20 Dec '16, 11:26

ChrisIrie's gravatar image

ChrisIrie
29515
accept rate: 37%

Thank you, Chris. If you will update the thread with the results, it will be super!
I want to know whether you are able to reproduce it as well.

(20 Dec '16, 11:56) Vlad
1

I was able to reproduce it. Your instructions were very clear and easy to follow.

-- Chris

(20 Dec '16, 13:09) ChrisIrie
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×63
×43
×33
×7

question asked: 19 Dec '16, 09:50

question was seen: 2,959 times

last updated: 20 Dec '16, 13:09