SA 12 Assertion failed: 101413

Recently I updated the database from version 9 to version 12. Since then the 
database
has crashed several times.  Is this a bug?

Error information:
E. 01/10 14:14:07. *** ERROR *** Assertion failed: 101413 (12.0.0.2601)
Unable to allocate a multi-page block of memory
I. 01/10 14:14:07. Connection terminated abnormally
I. 01/10 14:14:07. Disconnected TCPIP client's AppInfo: 
IP=10.29.200.221;HOST=WNMTSE221;OSUSER=BrunoS;OS='Windows 2000 Build 2195 
Service Pack 
4';EXE=g:\apps\vipre\Silver-11-01-07.exe;PID=0x20e0;THREAD=0x1a1c;VERSION=12.0.0.2601;API=ODBC;TIMEZONEADJUSTMENT=60
I. 01/10 14:14:07. Database server shutdown requested via server console
I. 01/10 14:22:02. SQL Anywhere Network Server Version 12.0.0.2601

Database stratup configuration:
D:\Silver\Db\Silver.db
-n Silver_WNM1SQL01
-x TCPIP(PORT=2639)
-c 1g
-ca 0
-sb 0
-m
-o D:\Silver\Db\Silver_ConsoleLogFile.txt

Server information:
OS Name    Microsoft(R) Windows(R) Server 2003, Standard Edition
Version    5.2.3790 Service Pack 2 Build 3790
System Name    WNM1SQL01
System Type    X86-based PC
Processor    x86 Family 15 Model 2 Stepping 9 GenuineIntel ~2791 Mhz
Processor    x86 Family 15 Model 2 Stepping 9 GenuineIntel ~2791 Mhz
Total Physical Memory    2.047,49 MB
Available Physical Memory    217,02 MB
Total Virtual Memory    4,79 GB
Available Virtual Memory    3,19 GB
Page File Space    2,93 GB 

0
Koos
1/12/2011 8:41:21 AM
sybase.sqlanywhere.general 32637 articles. 4 followers. Follow

2 Replies
851 Views

Similar Articles

[PageSpeed] 56

You would appear to be running out of address space. The default max 
cache size in v12 is much larger than v9 though it is smaller than in 
v11. V12 leaves 512MB available for uses other than the cache and it is 
surprising that that would be insufficient. If you add "-ch 1g" to your 
command line you will get the same max cache size as you did in v9. Note 
that "-ca 0" doesn't change the max cache size: it only turns off 
automatic adjustment of the cache size based on usage statistics. The 
cache will still grow on demand if a query plan can make use of the 
space or if the cache is full of pages that cannot be ejected from cache 
(and that latter case is pretty rare).

-john.

John Smirnios
Senior Staff Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere 
Developer Community at http://www.ianywhere.com/developer


On 1/12/2011 3:41 AM, Koos Biesenbeek wrote:
> Recently I updated the database from version 9 to version 12. Since then
> the database
> has crashed several times. Is this a bug?
>
> Error information:
> E. 01/10 14:14:07. *** ERROR *** Assertion failed: 101413 (12.0.0.2601)
> Unable to allocate a multi-page block of memory
> I. 01/10 14:14:07. Connection terminated abnormally
> I. 01/10 14:14:07. Disconnected TCPIP client's AppInfo:
> IP=10.29.200.221;HOST=WNMTSE221;OSUSER=BrunoS;OS='Windows 2000 Build
> 2195 Service Pack
> 4';EXE=g:\apps\vipre\Silver-11-01-07.exe;PID=0x20e0;THREAD=0x1a1c;VERSION=12.0.0.2601;API=ODBC;TIMEZONEADJUSTMENT=60
>
> I. 01/10 14:14:07. Database server shutdown requested via server console
> I. 01/10 14:22:02. SQL Anywhere Network Server Version 12.0.0.2601
>
> Database stratup configuration:
> D:\Silver\Db\Silver.db
> -n Silver_WNM1SQL01
> -x TCPIP(PORT=2639)
> -c 1g
> -ca 0
> -sb 0
> -m
> -o D:\Silver\Db\Silver_ConsoleLogFile.txt
>
> Server information:
> OS Name Microsoft(R) Windows(R) Server 2003, Standard Edition
> Version 5.2.3790 Service Pack 2 Build 3790
> System Name WNM1SQL01
> System Type X86-based PC
> Processor x86 Family 15 Model 2 Stepping 9 GenuineIntel ~2791 Mhz
> Processor x86 Family 15 Model 2 Stepping 9 GenuineIntel ~2791 Mhz
> Total Physical Memory 2.047,49 MB
> Available Physical Memory 217,02 MB
> Total Virtual Memory 4,79 GB
> Available Virtual Memory 3,19 GB
> Page File Space 2,93 GB
0
John
1/12/2011 3:05:51 PM
I've noticed that the crash occurred during very intensive processing tasks,
sometimes combined with a backup. I have removed -ca 0 and added -ch 1g
and will see what is going to happen.

Koos

"John Smirnios [Sybase]"  wrote in message news:4d2dc34f@forums-1-dub...

You would appear to be running out of address space. The default max
cache size in v12 is much larger than v9 though it is smaller than in
v11. V12 leaves 512MB available for uses other than the cache and it is
surprising that that would be insufficient. If you add "-ch 1g" to your
command line you will get the same max cache size as you did in v9. Note
that "-ca 0" doesn't change the max cache size: it only turns off
automatic adjustment of the cache size based on usage statistics. The
cache will still grow on demand if a query plan can make use of the
space or if the cache is full of pages that cannot be ejected from cache
(and that latter case is pretty rare).

-john.

John Smirnios
Senior Staff Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer


On 1/12/2011 3:41 AM, Koos Biesenbeek wrote:
> Recently I updated the database from version 9 to version 12. Since then
> the database
> has crashed several times. Is this a bug?
>
> Error information:
> E. 01/10 14:14:07. *** ERROR *** Assertion failed: 101413 (12.0.0.2601)
> Unable to allocate a multi-page block of memory
> I. 01/10 14:14:07. Connection terminated abnormally
> I. 01/10 14:14:07. Disconnected TCPIP client's AppInfo:
> IP=10.29.200.221;HOST=WNMTSE221;OSUSER=BrunoS;OS='Windows 2000 Build
> 2195 Service Pack
> 4';EXE=g:\apps\vipre\Silver-11-01-07.exe;PID=0x20e0;THREAD=0x1a1c;VERSION=12.0.0.2601;API=ODBC;TIMEZONEADJUSTMENT=60
>
> I. 01/10 14:14:07. Database server shutdown requested via server console
> I. 01/10 14:22:02. SQL Anywhere Network Server Version 12.0.0.2601
>
> Database stratup configuration:
> D:\Silver\Db\Silver.db
> -n Silver_WNM1SQL01
> -x TCPIP(PORT=2639)
> -c 1g
> -ca 0
> -sb 0
> -m
> -o D:\Silver\Db\Silver_ConsoleLogFile.txt
>
> Server information:
> OS Name Microsoft(R) Windows(R) Server 2003, Standard Edition
> Version 5.2.3790 Service Pack 2 Build 3790
> System Name WNM1SQL01
> System Type X86-based PC
> Processor x86 Family 15 Model 2 Stepping 9 GenuineIntel ~2791 Mhz
> Processor x86 Family 15 Model 2 Stepping 9 GenuineIntel ~2791 Mhz
> Total Physical Memory 2.047,49 MB
> Available Physical Memory 217,02 MB
> Total Virtual Memory 4,79 GB
> Available Virtual Memory 3,19 GB
> Page File Space 2,93 GB 

0
Koos
1/13/2011 7:33:22 AM
Reply:

Similar Artilces:

SQLAnywhere 11: Assertion failed: 101413 (11.0.1.2376)
We have been getting this assertion failure with SQLAnywhere version 11.0.1.2376: Internal database error *** ERROR *** Assertion failed: 101413 (11.0.1.2376) Prior to this assertion, the db server is mostly idle. The assertion happens during a small time period when a bunch of connections are made to the database from multiple programs at the same time. This connection pattern is typically for our applications and works normally for 2-3 weeks. Then once every 2-3 weeks, we hit upon this assertion error. After the error, the db server terminates all connections and d...

assertion failed #12
SQL A 5.5.05 Assertion Failed:50260 Page number on page does not match page requested Can anything be done about this? Can I access the DB at all? NOTE: I am running DB without logfile. -- Regards, John Kingan Without a good backup and/or log file, your options are very limited. With a backup, you will lose any changes since the last backup. I would review the following for next steps: http://www.sybase.com/detail/1,6904,1010805,00.html -- Chris Keating Sybase Adaptive Server Anywhere Professional Version 8 Sybase TechWave User Training and Solut...

SA 10: Assertion failed: 106104
Hi! SQL Anywhere Personal Server Version 10.0.0.2744. I have created view (syntax has been simplified, the sense here is not important): -------- Create View dba.v1 as select d.File_ID, d.File_Name, d.DbSpace_Name, d.store_type from sysfile as d, SYSUSERAUTHORITY as ed where ed.User_ID=user_id(*) and 0<=(select Coalesce(sum(esn.Scale),0) from systabcol as esn,SYSTYPEMAP as eg where esn.table_ID=eg.sa_user_type and eg.sa_Domain_ID=ed.User_ID and esn.Domain_ID=1 and esn.column_ID=d.File_ID) -------- Execute of query: --...

Assertion failed while using a SA 5.5.03 DB
Hi everybody, I am experiencing a bad problem with a DB of one of our customers: while inserting rows from a PowerBuild app, I get the message "Assertion failed 50213: page size does not match..." (or similar). I tryed to unload the DB to reload it on a new DataBase file, but I get the same error message while unloading. Is there a way to solve the problem and get the DataBase "back to life"? Thanks for reading. Antonio > Hi everybody, > > I am experiencing a bad problem with a DB of one of our customers: while > inserting rows from a Powe...

Insert update Fails on the server on SqlAnywhere Version 12.0
Hi, SqlAnywhere Version 12.0 i am having issues with the upload insert and upload update environment we have three servers SVRMLRELAY - relay server SVRMOBILINK - Mobilink server and it also has the Consolidated database SVRDEV2 - Application Database server when is try to sync all my download scripts work on initial and subsequent synch but when i update or insert records to the remote database then the sync is failing i have SVRDEV2 as a linked server in the SVRMOBILINK. Note: using same scripts i was successfully sync in SqlAnywhere 11.0. please refer to the below e...

Assertion Failed msgs. SQLAnywhere version
Since moving to SQLAnywhere 10 from 8 last June the number of corrupted databases that we have encountered has greatly increased to about 1 every other week. The corruption seems to happen, not during synchronization, but at some point prior to that. We have about 3000 laptops with remote databases so the number might seem small overall but the debug time is starting to add up. When running DBValid I receive an Assertion Failed error message; SQLAnywhere version - 10.0.1.3680 Mobilink server - Windows 2003 server Consolidated DB - SQL 2005 client machines - Dell windows XP ...

Assertion failed: 101412 SQLanywhere 7.0.4 when altering a table containing data to add a primary key
Can anyone tell me if I am doing something wrong? I have quite a large database created by reading in Dbase files with the input statement in ISQL I want to add relations between the tables, but whenever I try to do this the database gets corrupted For example the following code produces an error 100% reproducibly %% remove blanks and set up relationship delete from zhdr where horder is null; alter table zhdr modify horder not null; alter table zhdr add primary key (horder); *** ERROR *** Assertion failed: 101412 (7.0.4.2788) Page number on page does not match page requested...

"perl: utf8.c:1997: Perl_swash_fetch: Assertion `klen <= sizeof(PL_last_swash_key)' failed." [5.12.1]
--0015174bdef6bf9e640495d5749b Content-Type: text/plain; charset=ISO-8859-1 I'm experimenting with some text scanning code against a very large corpus, and I've got Perl 5.12.1 dying on this assertion failure: perl: utf8.c:1997: Perl_swash_fetch: Assertion `klen <= sizeof(PL_last_swash_key)' failed. I'm not at all familar with what swashes even are, let alone what they precisely do; I know they're related to Unicode attributes, that's about it. Any clues out there? I'm scanning through so many pages with such a highly distributed program that ...

Smoke [5.12.0] v5.12.0-RC1-12-ge4717ba FAIL(F) MSWin32 Win2000 SP4 (x86/2 cpu)
Automated smoke report for 5.12.0 patch e4717ba1e5ff27330def3ee76ec70eeb31d= 58d07 v5.12.0-RC1-12-ge4717ba perl-win2k: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz(~2636 MHz) (x86/2 cpu) on MSWin32 - Win2000 SP4 using cl version 14.00.50727.762 smoketime 4 hours 16 minutes (average 32 minutes) Summary: FAIL(F) O =3D OK F =3D Failure(s), extended report at the bottom X =3D Failure(s) under TEST but not under harness ? =3D still running or test results not (yet) available Build failures during: - =3D unknown or N/A c =3D Configure, m =3D make, M =3D make (a...

Smoke [5.12.0] v5.12.0-RC0-12-gaaf643c FAIL(F) MSWin32 Win2000 SP4 (x86/2 cpu)
Automated smoke report for 5.12.0 patch aaf643cef9412894b3ea120d62ac78b85d1= 83930 v5.12.0-RC0-12-gaaf643c perl-win2k: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz(~2636 MHz) (x86/2 cpu) on MSWin32 - Win2000 SP4 using cl version 14.00.50727.762 smoketime 4 hours 14 minutes (average 31 minutes 50 seconds) Summary: FAIL(F) O =3D OK F =3D Failure(s), extended report at the bottom X =3D Failure(s) under TEST but not under harness ? =3D still running or test results not (yet) available Build failures during: - =3D unknown or N/A c =3D Configure, m =3D make, M ...

Smoke [5.12.0] v5.12.0-RC1-12-ge4717ba FAIL(F) MSWin32 WinXP/.Net SP3 (x86/2 cpu)
Automated smoke report for 5.12.0 patch e4717ba1e5ff27330def3ee76ec70eeb31d= 58d07 v5.12.0-RC1-12-ge4717ba maldoror.bath.planit.group: Intel(R) Core(TM)2 CPU 6700 @ 2.66GHz(~2660 MHz= ) (x86/2 cpu) on MSWin32 - WinXP/.Net SP3 using cl version 13.10.3077 smoketime 7 hours 19 minutes (average 43 minutes 54 seconds) Summary: FAIL(F) O =3D OK F =3D Failure(s), extended report at the bottom X =3D Failure(s) under TEST but not under harness ? =3D still running or test results not (yet) available Build failures during: - =3D unknown or N/A c =3D Configure...

Smoke [5.12.0] v5.12.0-RC1-12-ge4717ba FAIL(F) openvms V8.3-1H1 (IA64/2 cpu)
Automated smoke report for 5.12.0 patch e4717ba1e5ff27330def3ee76ec70eeb31d58d07 v5.12.0-RC1-12-ge4717ba ALMA: HP rx2600 (1.50GHz/6.0MB) (IA64/2 cpu) on openvms - V8.3-1H1 using ? CC/DECC version 70390018 smoketime 5 hours 31 minutes (average 2 hours 45 minutes) Summary: FAIL(F) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = make test-prep v5.1...

failed to create ike-sa
--____BJKFREPWZKLPZBJKXFKW____ Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline; modification-date="Wed, 29 Aug 2006 10:05:25 -0400" We had a bm3.8sp4 slave servers certificates expire. We renewed the certs = and most of the connections have come back up. Unfortunately it is still = having issues connecting to some sites. Looking at the ike logs of the = servers it can't connect to I keep seeing this message "failed to create = ike-sa - acl check failed" in reference to the server who...

Smoke [5.12.0] v5.12.0-12-ga4cb5f2 FAIL(XM) linux 2.6.31-20-generic [debian] (x86_64/8 cpu)
Automated smoke report for 5.12.0 patch a4cb5f2834e402bcad4d822e471ee0efce4= 68fe3 v5.12.0-12-ga4cb5f2 zwei: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz (GenuineIntel 2668MHz) (x86_64= /8 cpu) on linux - 2.6.31-20-generic [debian] using cc version 4.4.1 smoketime 9 hours 17 minutes (average 34 minutes 49 seconds) Summary: FAIL(XM) O =3D OK F =3D Failure(s), extended report at the bottom X =3D Failure(s) under TEST but not under harness ? =3D still running or test results not (yet) available Build failures during: - =3D unknown or N/A c =3D Configure, m ...

Web resources about - SA 12 Assertion failed: 101413 - sybase.sqlanywhere.general

Security Assertion Markup Language - Wikipedia, the free encyclopedia
) is an XML -based open standard data format for exchanging authentication and authorization data between parties, in particular, between an ...

Joe de Bruyn's assertion he has majority support against gay marriage challenged
Joe de Bruyn says that the majority of his members support him against gay marriage. I challenge him to hold a secret ballot of all members to ...

Justin Trudeau Fires Back At Harper's Assertion He Dislikes Military
OTTAWA - Stephen Harper dishonours soldiers who've died to preserve Canada's democracy when he asserts that Justin Trudeau distrusts and dislikes ...

2005 Purple iPhone design could thwart Samsung’s assertion that Apple copied Sony
. We hope you aren’t sick of early iPhone prototypes just yet as the monster Apple vs. Samsung trial is kicking off today and yet another prototype ...

Cell Phones Need A Warrant, But Cell Site Location Info Doesn’t? Appellants Challenge Government’s Assertions ...
While the government makes the usual claims about third party data and warrant requirements being an undue burden, the appellant's reply takes ...

Sy Hersh: No evidence of nuclear program in Iran, despite Obama administration assertions
Iran and the Bomb How real is the nuclear threat? ABSTRACT: ... Is Iran actively trying to develop nuclear weapons? Members of the Obama Administration ...

Hogan Fortune 500 assertion not true - Baltimore Sun
A claim that has also been central to Republican gubernatorial candidate Larry Hogan 's critique of Maryland's economy &amp;ndash; that the state ...

Reinventing assertions
If you have ever written a test in Java, you are undoubtedly familiar with the Assert class: Assert.assertEquals(result, expected); Java 5 introduced ...

OECD Pushes Crazy Assertion that Poverty Is Higher in the U.S. than in Greece, Hungary, Portugal, and ...
Supporters of individual liberty and national sovereignty have been skeptical of the United Nations, and with good reason. With the support of ...

Drudge slags the First Lady with the unsupported assertion that the "Inaugural lunch tops 3,000 calories." ...
Drudge links to a Washington Times article that refers without linking to another website that supposedly lists the items on the menu and purports ...

Resources last updated: 1/22/2016 3:40:23 AM