2062748 - SQL Anywhere DB is shutting down automatically

SAP Knowledge Base Article - Public

2062748 - SQL Anywhere DB is shutting down automatically

Symptom

After starting SQL anywhere DB it is getting started but after sometime it is getting down automatically.
   ** ERROR *** Assertion failed: 101413 (12.0.1.3152) Unable to allocate a multi-page block of memory.

Environment

Every SQL Anywhere Version will be applicable for this KBA.

Reproducing the Issue

There is no specific step for this issue.
After SQL Anywhere Database start-up, This problem occur automatically.

Cause


This problem can be occurred by lack of memory for SQL Anywhere on this machine.

Resolution

Please check the following step.

1. Figure out how much memory can be consumed for SQL Anywhere database.

    If it is difficult to check, Please use "-o" option for SQL Anywhere startup parameter.
      e.g.  dbspawn -f dbsrv12 -gk all -n "$SQLANYWHERE_SERVER" -ch 1g -o out.txt

      out.txt::

      I. 08/27 20:19:43. Note: A cache size of 673840K exceeds the available physical memory of 210280K.
                                          A performance penalty may result.
      I. 08/27 20:19:43. 673840K of memory used for caching
      I. 08/27 21:24:27. Note: A cache size of 673840K exceeds the available physical memory of 258280K.
                                          A performance penalty may result.
      I. 08/27 21:24:27. 673840K of memory used for caching
      I. 08/27 21:24:27. Minimum cache size: 9600K, maximum cache size: 1048576K
   
      ## You can only use 200MB for SQL Anywhere Cache. But the server configured to use 1GB.

2. You need to change the -ch option to limit using SQL Anywhere Cache size.

      e.g.  dbspawn -f dbsrv12 -gk all -n "$SQLANYWHERE_SERVER" -ch 150m -o out.txt


3. Start up again and then check the SQL Anywhere log file.

See Also

SQL Anywhere StartUp Parameter

Keywords

assertion failed, Unable to allocate a multi-page block, SQL Anywhere , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008