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 |
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. |
Is this assertion failure the apparent cause of the freeze or is it happening when you shutdown the server after it freezes?
Its not clear - I'll try to find out more.
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.