Assertion failed on IQ 15.4

[#1]

We have the messages below, after this IQ starts normally. What should we check now? In SQL Anywhere this is a corruption message is it the same for IQ? Maybe it is something on the db file and not in data

Thank you in advance,

Kimon

E. 06/19 17:16:20. *** ERROR *** Assertion failed: 201503 (15.4.1.3019)[BP_DW_PROD]

I. 06/19 17:16:22. Connection terminated abnormally

I. 06/19 17:16:22. Disconnected TCPIP client's AppInfo: IP=10.96.64.52;HOST=HP5800-260209-1;OSUSER=bpt100023;OS='Windows XP Build 2600 Service Pack 3';EXE='D:\sybase15\Shared\Sybase Central 6.1.0\win32\scjview.exe';PID=0x14d0;THREAD=0x1014;VERSION=12.0.1.3014;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=180

I. 06/19 17:16:22. Connection terminated abnormally

I. 06/19 17:16:22. Disconnected TCPIP client's AppInfo: IP=10.99.5.105;HOST=BUCHQ02WS159;OSUSER=BPT300856;OS='Windows XP Build 2600 Service Pack 3';EXE='C:\Sybase\shared\Sybase Central 6.1.0\win32\scjview.exe';PID=0x648;THREAD=0xafc;VERSION=11.0.1.5027;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=180

I. 06/19 17:16:42. Connection terminated abnormally

I. 06/19 17:16:42. Disconnected TCPIP client's AppInfo: IP=10.96.64.80;HOST=BANCPOST-BD410C;OSUSER=bpt400439;OS='Windows XP Build 2600 Service Pack 3';EXE='C:\IQ15\Shared\Sybase Central 6.1.0\win32\scjview.exe';PID=0xb2c;THREAD=0x5e0;VERSION=12.0.1.3014;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=180

I. 06/19 17:16:42. Connection terminated abnormally

I. 06/19 17:16:42. Disconnected TCPIP client's AppInfo: IP=10.96.64.67;HOST=BUCHQ01WS230;OSUSER=bpt06142;OS='Windows XP Build 2600 Service Pack 3';EXE='C:\Sybase\shared\Sybase Central 6.1.0\win32\scjview.exe';PID=0x714;THREAD=0xc0;VERSION=11.0.1.5027;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=180

I. 06/19 17:21:30. Sybase IQ

[saroj_bagai · Accepted solution]

what is exact version of 154 with esd 

and can you send us msg before assertion failure ?

[kimon_moschandreou · Accepted solution]

Here is the version and the last messages before "assertion failed" message from srvlog

Best regards

Kimon Moschandreou

'Sybase IQ/15.4.0.3019/120816/P/ESD 2/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit/2012-08-16 10:48:47'

I. 06/19 17:15:44. Insert Pass 1 completed in 0 seconds.

I. 06/19 17:15:44. Insert Pass 2 completed in 0 seconds.

I. 06/19 17:15:44.

I. 06/19 17:15:44. Insert for '#MK1' completed in 0 seconds.  5954 rows inserted.

I. 06/19 17:16:00.

I. 06/19 17:16:00. Insert Pass 1 completed in 0 seconds.

I. 06/19 17:16:00. Insert Pass 2 completed in 0 seconds.

I. 06/19 17:16:00.

I. 06/19 17:16:00. Insert for '#MK1' completed in 0 seconds.  5954 rows inserted.

I. 06/19 17:16:06.

I. 06/19 17:16:07. Insert Pass 1 completed in 1 seconds.

I. 06/19 17:16:07. Insert Pass 2 completed in 0 seconds.

I. 06/19 17:16:07.

I. 06/19 17:16:07. Insert for '#baza' completed in 1 seconds.  45462 rows inserted.

I. 06/19 17:16:11.

E. 06/19 17:16:20. *** ERROR *** Assertion failed: 201503 (15.4.1.3019)[BP_DW_PROD]

I. 06/19 17:16:22. Connection terminated abnormally

I. 06/19 17:16:22. Disconnected TCPIP client's AppInfo: IP=10.96.64.52;HOST=HP5800-260209-1;OSUSER=bpt100023;OS='Windows XP Build 2600 Service Pack 3';EXE='D:\sybase15\Shared\Sybase Central 6.1.0\win32\scjview.exe';PID=0x14d0;THREAD=0x1014;VERSION=12.0.1.3014;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=180

I. 06/19 17:16:22. Connection terminated abnormally

I. 06/19 17:16:22. Disconnected TCPIP client's AppInfo: IP=10.99.5.105;HOST=BUCHQ02WS159;OSUSER=BPT300856;OS='Windows XP Build 2600 Service Pack 3';EXE='C:\Sybase\shared\Sybase Central 6.1.0\win32\scjview.exe';PID=0x648;THREAD=0xafc;VERSION=11.0.1.5027;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=180

I. 06/19 17:16:42. Connection terminated abnormally

I. 06/19 17:16:42. Disconnected TCPIP client's AppInfo: IP=10.96.64.80;HOST=BANCPOST-BD410C;OSUSER=bpt400439;OS='Windows XP Build 2600 Service Pack 3';EXE='C:\IQ15\Shared\Sybase Central 6.1.0\win32\scjview.exe';PID=0xb2c;THREAD=0x5e0;VERSION=12.0.1.3014;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=180

I. 06/19 17:16:42. Connection terminated abnormally

I. 06/19 17:16:42. Disconnected TCPIP client's AppInfo: IP=10.96.64.67;HOST=BUCHQ01WS230;OSUSER=bpt06142;OS='Windows XP Build 2600 Service Pack 3';EXE='C:\Sybase\shared\Sybase Central 6.1.0\win32\scjview.exe';PID=0x714;THREAD=0xc0;VERSION=11.0.1.5027;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=180

I. 06/19 17:21:30. Sybase IQ

I. 06/19 17:21:30. Version 15.4

I. 06/19 17:21:30. (64bit mode)

I. 06/19 17:21:30. Copyright 1992-2012 by Sybase, Inc. All rights reserved

I. 06/19 17:21:30. Copyright (c) 2001-2012, Sybase, Inc.

I. 06/19 17:21:30. Portions copyright (c) 1988-2012, iAnywhere Solutions, Inc. All rights reserved.

I. 06/19 17:21:30. Use of this software is governed by the Sybase License Agreement.

I. 06/19 17:21:30. Refer to http://www.sybase.com/softwarelicenses.

[saroj_bagai · Accepted solution]

seems related to  CR 715843 fixed in IQ 154 esd3.

CR 715843:

In rare cases, attempting to use nested procedures with nested transactions and internally generated temporary tables would have failed assertion 201501, 101412, 200505 or others. This problem has now been fixed.

[kimon_moschandreou · Accepted solution]

Thank you very much for this, however I see this CR only in SQL Anywhere 12.0.1 EBFs and not in IQ EBFs. However I think you have spotted the solution for this.

Best regards,

Kimon

[saroj_bagai · Accepted solution]

IQ 15.4 esd3  is build with SA build 3858 and SA fix is in SA  build 3781, so IQ 154 esd3 does have this fix

[kimon_moschandreou · Accepted solution]

thank you very much

[former_member333181]

Please open a case with supoprt and provide all the logs including hardware log. It is possible that there might be some corruption, but we need to validate that from logs.

Regards

Shashi