Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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
2.5k91127
accept rate: 16%

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
30915
accept rate: 33%

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:

×246
×51
×43
×8

question asked: 19 Dec '16, 09:50

question was seen: 5,560 times

last updated: 20 Dec '16, 13:09