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.

The readme files for earlier EBFs mention Engineering Case #625189, but that CR was OMITTED from the readme for 11.0.1.3158.

Was the fix removed or replaced by something else? It is very important to a client with that symptom currently on 11.0.1.2436.

http://download.sybase.com/swr/14650/rdme_1101_ebf_2587.html

 ================(Build #2447  - Engineering Case #625189)================

    Repeatedly inserting and deleting rows with long strings may have lead to 
    unconstrained database growth. This was more likely to occur if the server 
    was continually under heavy load. In 11.x servers, snapshot isolation must 
    have been enabled for this problem to have occurred. This has now been corrected.

SQL Anywhere Bug Fix Readme for Version 11.0.1, build 2960.htm

================(Build #2447  - Engineering Case #625189)================

    Repeatedly inserting and deleting rows with long strings may have lead to 
    unconstrained database growth. This was more likely to occur if the server 
    was continually under heavy load. In 11.x servers, snapshot isolation must 
    have been enabled for this problem to have occurred. This has now been corrected.

SQL Anywhere Bug Fix Readme for Version 11.0.1, build 3158.htm

- Engineering Case #625189 not found -

asked 12 Sep '14, 12:49

Breck%20Carter's gravatar image

Breck Carter
26.6k418575824
accept rate: 21%


I'm not sure what's going on for you but I can see that item in the readme file you mentioned. I can confirm that it is fixed in that build.

permanent link

answered 15 Sep '14, 13:46

Jason%20Noack's gravatar image

Jason Noack
85611116
accept rate: 75%

The file named ReadMe_EBF.html located inside SA11_Full_Win32+x64.1101_3158_EBF.exe which is located inside the downloadable EBF23111.zip does in fact include CR 625189... so that answers my question... THANK YOU!

However, to answer the unspoken question regarding my SANITY :), the attached standalone file "SQL Anywhere Bug Fix Readme for Version 11.0.1, build 3158.htm" which was downloadable separately from EBF23111.zip, does NOT contain CR 625189.

(15 Sep '14, 17:19) Breck Carter

It's supposed to be included. From all sources I can verify this from I have no reason to believe it was ever backed out and it is in the copies of the ReadMe you should have.

Maybe an accidental edit was involved? {mentioned by one who suffers from a bad case of MDND (MouseDragNDropItis)}

permanent link

answered 15 Sep '14, 12:18

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
6.2k2890
accept rate: 30%

1

Thanks... the issue suddenly became less fraught when it was realized that snapshot isolation was not required in this particular context... it is AMAZING what turning it off did for performance, not just disk and CPU but storage bloat... methinks snapshot isolation was a [mutter cough mumble] work in progress back in those days :)

(15 Sep '14, 12:24) Breck Carter
Replies hidden

Are you seeing a difference with Snapshot Isolation in v16?

(16 Sep '14, 08:48) Justin Willey
1

No... I have not seen any unexpected snapshot isolation performance issues in V16... many years have passed since the feature was introduced (10.0.0 in 2006).

However, note the careful use of the word "unexpected"... any time someone says they are considering it, my knee-jerk reaction is "don't" :)

(16 Sep '14, 17:50) Breck Carter
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:

×86

question asked: 12 Sep '14, 12:49

question was seen: 1,393 times

last updated: 16 Sep '14, 17:53