In order to post questions, answers, or comments, you now need a validated email address. Details on how to validate your address are in the FAQ.

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 (10.0.1.3976) 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.

Thanks

asked Nov 08 '10 at 15:38

Justin%20Willey's gravatar image

Justin Willey
4.7k6486128

closed Mar 27 '11 at 16:00

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

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

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

(Nov 09 '10 at 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.

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

The question has been closed for the following reason "The question is answered, right answer was accepted" by Justin Willey Mar 27 '11 at 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.

answered Nov 11 '10 at 15:33

Justin%20Willey's gravatar image

Justin Willey
4.7k6486128

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 (indent for sublists):
    1. Foo
    2. Bar
  • bullet list (indent for sublists):
    * Foo
    * Bar
  • to add a line break, add two spaces to where you would like the new line to be.
  • Code blocks should be indented by 4 spaces. SQL code should begin with ":::SQL" on the first line.
  • basic HTML tags are also supported

Tags:

×27
×21

Asked: Nov 08 '10 at 15:38

Seen: 793 times

Last updated: Mar 27 '11 at 16:00

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link: [text](http://url.com/ "title")
  • image: ![alt text](/path/img.jpg "title")
  • numbered list (indent for sublists):
    1. Foo
    2. Bar
  • bullet list (indent for sublists):
    * Foo
    * Bar
  • to add a line break, add two spaces to where you would like the new line to be.
  • Code blocks should be indented by 4 spaces. SQL code should begin with ":::SQL" on the first line.
  • basic HTML tags are also supported