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