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.

v10.0.1.3976 64 bit Windows 2008 Server 32GB RAM, 200-300 busy users, 150GB database

Does anyone recognise this assertion-

* ERROR * Assertion failed: 104301 ( Attempt to free a user descriptor with non-zero reference count

The db engine apears to freeze every 30 - 60 mins & needs restarting.

It doesn't seem to be a corruption problem, we have restored back to a point sometime before it started happening and rolled logs forward - just starts happening again. No obvious correlation with any particular activity so far.


asked 08 Nov '10, 15:38

Justin%20Willey's gravatar image

Justin Willey
accept rate: 20%

closed 27 Mar '11, 16:00

Is this assertion failure the apparent cause of the freeze or is it happening when you shutdown the server after it freezes?

(08 Nov '10, 18:35) John Smirnios

Its not clear - I'll try to find out more.

(09 Nov '10, 12:27) Justin Willey
Comment Text Removed

Following an update to build 4501, things seem stable. The timing of the assertion still isn't clear - we probably won't be able to be sure unless the problem re-occurs. Thanks for taking a look.

(09 Nov '10, 14:31) Justin Willey

The question has been closed for the following reason "The question is answered, right answer was accepted" by Justin Willey 27 Mar '11, 16:00

Upgrade to build 4501 seems to fix - not clear what caused problem to start happening, however there were network config changes made around the time that the problem started.

permanent link

answered 11 Nov '10, 15:33

Justin%20Willey's gravatar image

Justin Willey
accept rate: 20%

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 08 Nov '10, 15:38

question was seen: 5,278 times

last updated: 27 Mar '11, 16:00