Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Running the Database Server

Create a debug log file Next Page

Error reporting in SQL Anywhere


When a fatal error or crash occurs and is detected by any of the following applications, an error report is created about what was happening at the time of the problem:

The error report includes information such as the execution state of the threads at the time of the crash, so that iAnywhere is better able to diagnose the cause of the problem. By default, the error report is created in the diagnostic directory (specified by the SADIAGDIR environment variable), or if this location does not exist, it is created in the same directory as the database file. The location of the error report file is written to the console and the request log.

Error report file names are composed as follows:

For example, SA10_20051220_133828_32116.mini_core is an error report from a SQL Anywhere version 10 database server from 2006/06/20, at 1:38:28 pm, from process 32116.

During normal database server operation, diagnostic information is also recorded about the database server, such as how many CPUs are on the computer, whether hyperthreading is enabled, and what options were specified when the server was started. This information can also be submitted using dbsupport.

How SQL Anywhere software submits error reports and diagnostic information

After the database server successfully writes out error report information, it launches SQL Anywhere Support utility (dbsupport) and passes it the name of the error report file to be submitted. By default, dbsupport attempts to prompt the user to submit an error report when it is generated, but if dbsupport is unable to prompt the user, then the report is not sent. iAnywhere encourages you to submit error reports when they occur. The report does not contain any information that identifies the sender.

You can change the default behavior of dbsupport with the -cc option:

If you choose not to submit an error report, it remains in the diagnostic directory on your hard disk. The location of the diagnostic directory is specified by the SADIAGDIR environment variable. See SADIAGDIR environment variable.

Submitting error reports to iAnywhere assists with diagnosing the cause of a fatal error or assertion. Once an error report is submitted, it is deleted from the computer where it was generated. See SQL Anywhere Support utility (dbsupport).

Error reports and diagnostic information are uploaded to the iAnywhere Error Reporting web site via HTTP. This is done to save you time by making it as convenient as possible to send relevant files to iAnywhere so that it is possible to diagnose and provide solutions to problems you encounter.