SQL Anywhere database - Internal database error *** ERROR *** Assertion failed: 104301 (9.0.1.1964)

Author

Internal database error *** ERROR *** Assertion failed: 104301 (9.0.1.1964)

Dave Westphal

2005-04-19, 8:23 pm

I am running a process which is used to add a new remote to a consolidated database. The process is ending with ISQL having the following error:
Internal database error *** ERROR *** Assertion failed: 104301 (9.0.1.1964)
Attempt to free a user descriptor with non-zero reference count -- transaction rolled back

I have also tried applying the 2009 EBF and rerunning and process, but received the same assertion with version 2009.

The last thing that I see in the dbsrv9 output window is:

GRANT CONNECT to "R265259" IDENTIFIED by ""
Starting checkpoint of "TFLLOAD" (tfl.db) at Tue Apr 19 2005 13:17
Finished checkpoint of "TFLLOAD" (tfl.db) at Tue Apr 19 2005 13:17
*** ERROR *** Assertion failed: 104301 (9.0.1.1964)
Attempt to free a user descriptor with non-zero reference count

I also turned on -zr all and have the output file.
What should I do to get around the error?

Thanks in advance,
Dave

Chris Keating $iAnywhere Solutions$

2005-04-20, 3:23 am

You may want to consider opening a technical support case. The only recent occurence of this ASSERTION that I can find reference was addressed in the EBF level that you were running.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

********************
********************
********************
*****************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

********************
********************
********************
*****************

"Dave Westphal" <Dave_Westphal@aal.org> wrote in message news:42655955$1@foru
ms-2-dub...
I am running a process which is used to add a new remote to a consolidated database. The process is ending with ISQL having the following error:
Internal database error *** ERROR *** Assertion failed: 104301 (9.0.1.1964)
Attempt to free a user descriptor with non-zero reference count -- transaction rolled back

I have also tried applying the 2009 EBF and rerunning and process, but received the same assertion with version 2009.

The last thing that I see in the dbsrv9 output window is:

GRANT CONNECT to "R265259" IDENTIFIED by ""
Starting checkpoint of "TFLLOAD" (tfl.db) at Tue Apr 19 2005 13:17
Finished checkpoint of "TFLLOAD" (tfl.db) at Tue Apr 19 2005 13:17
*** ERROR *** Assertion failed: 104301 (9.0.1.1964)
Attempt to free a user descriptor with non-zero reference count

I also turned on -zr all and have the output file.
What should I do to get around the error?

Thanks in advance,
Dave

Reg Domaratzki $iAnywhere Solutions$

2005-04-20, 9:23 am

If you've got a reproducible at v901.2009, we'd love it if you open a case
through CaseXpress so we could figure out what's going on. You can always
report a bug for free by visiting CaseXpress at
http://casexpress.sybase.com/cx/cx.stm. When submitting calls through
CaseXpress, please make sure to give an accurate description of the steps
you take to reproduce the bug, and include any files that may be needed
(database, source code) to reproduce the problem.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Dave Westphal" <Dave_Westphal@aal.org> wrote in message
news:42655955$1@foru
ms-2-dub...
I am running a process which is used to add a new remote to a consolidated
database. The process is ending with ISQL having the following error:
Internal database error *** ERROR *** Assertion failed: 104301 (9.0.1.1964)
Attempt to free a user descriptor with non-zero reference count --
transaction rolled back

I have also tried applying the 2009 EBF and rerunning and process, but
received the same assertion with version 2009.

The last thing that I see in the dbsrv9 output window is:

GRANT CONNECT to "R265259" IDENTIFIED by ""
Starting checkpoint of "TFLLOAD" (tfl.db) at Tue Apr 19 2005 13:17
Finished checkpoint of "TFLLOAD" (tfl.db) at Tue Apr 19 2005 13:17
*** ERROR *** Assertion failed: 104301 (9.0.1.1964)
Attempt to free a user descriptor with non-zero reference count

I also turned on -zr all and have the output file.
What should I do to get around the error?

Thanks in advance,
Dave

Chris Keating $iAnywhere Solutions$

2005-04-20, 11:23 am

Make sure that you provide a full repro if you submit this a "report a bug" case. It is unlikely that we will be able to do much will just request logs.

"Dave Westphal" <Dave_Westphal@aal.org> wrote in message news:42655955$1@foru
ms-2-dub...
I am running a process which is used to add a new remote to a consolidated database. The process is ending with ISQL having the following error:
Internal database error *** ERROR *** Assertion failed: 104301 (9.0.1.1964)
Attempt to free a user descriptor with non-zero reference count -- transaction rolled back

I have also tried applying the 2009 EBF and rerunning and process, but received the same assertion with version 2009.

The last thing that I see in the dbsrv9 output window is:

GRANT CONNECT to "R265259" IDENTIFIED by ""
Starting checkpoint of "TFLLOAD" (tfl.db) at Tue Apr 19 2005 13:17
Finished checkpoint of "TFLLOAD" (tfl.db) at Tue Apr 19 2005 13:17
*** ERROR *** Assertion failed: 104301 (9.0.1.1964)
Attempt to free a user descriptor with non-zero reference count

I also turned on -zr all and have the output file.
What should I do to get around the error?

Thanks in advance,
Dave

Sponsored Links