SAP Knowledge Base Article - Preview

2820624 - After 'alter database upgrade' in IQ16.1 SP04, detected different 'log GUID' between database identity and database definition -- SAP IQ

Symptom

To apply SP04 from SAP IQ 16.1 SP03 PL02, customer tried to upgrade on test IQ server. DBA ran into upgrade failure and test DB wasn't started. The test DB is encrypted and enabled PITR function. Below is traced summary.

* TESTDEMO_DIAG.log =>

...
I. 07/22 22:46:41.538967 Using broadcast address of: 10.121.25.255
I. 07/22 22:46:46.539120 Server not found (no reply received)
I. 07/22 22:46:46.539268 TCPIP link started successfully
I. 07/22 22:46:46.540572 Now accepting requests
I. 07/22 22:47:42.107286 Connection ID 1: "DBA" connected to database "TESTDEMO" from SQL Anywhere 17.0.10 (1011) client over SharedMemory
I. 07/22 22:47:42.107397 Connection ID 1: AppInfo is IP=1.2.3.222;HOST=testsv;OSUSER=sybase;OS='Linux 3.10.0-862.11.6.el7.x86_64 #1 SMP Fri Aug 10 16:55:11 UTC 2018 x';EXE=/sapmnt/NLS/shared/SAPJRE-8_1_046_64BIT/bin/java;PID=0x6065;THREAD=0x7fe57c7b0700;VERSION=17.0.10.1011;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-240
...
I. 07/22 22:47:53.539407 Starting checkpoint of "TESTDEMO" (TESTDEMO.db) at Mon Jul 22 2019 22:47
I. 07/22 22:47:53.556384 Finished checkpoint of "TESTDEMO" (TESTDEMO.db) at Mon Jul 22 2019 22:47
...
I. 07/22 22:48:04.029858 Update previous log GUID to: 00000000-0000-0000-0000-000000000000
Update current log GUID to :3cc5d840-acb1-11e9-8000-b39658d89aa6
I. 07/22 22:48:04.038283 Starting checkpoint of "TESTDEMO" (TESTDEMO.db) at Mon Jul 22 2019 22:48
I. 07/22 22:48:04.061675 Finished checkpoint of "TESTDEMO" (TESTDEMO.db) at Mon Jul 22 2019 22:48
I. 07/22 22:48:04.075252 Starting shutdown of database "TESTDEMO" (TESTDEMO.db) at Mon Jul 22 2019 22:48
I. 07/22 22:48:04.075492 Connection ID 1: connection "DBA" terminated abnormally
I. 07/22 22:48:04.075595 Connection ID 1: Disconnected SharedMemory client's AppInfo is IP=1.2.3.222;HOST=testsv;OSUSER=sybase;OS='Linux 3.10.0-862.11.6.el7.x86_64 #1 SMP Fri Aug 10 16:55:11 UTC 2018 x';EXE=/sapmnt/NLS/shared/SAPJRE-8_1_046_64BIT/bin/java;PID=0x6065;THREAD=0x7fe57c7b0700;VERSION=17.0.10.1011;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-240
I. 07/22 22:48:04.075692 Connection ID 1: "DBA" disconnected from database "TESTDEMO"
I. 07/22 22:48:04.077779 Starting checkpoint of "TESTDEMO" (TESTDEMO.db) at Mon Jul 22 2019 22:48
I. 07/22 22:48:04.113690 Finished checkpoint of "TESTDEMO" (TESTDEMO.db) at Mon Jul 22 2019 22:48
I. 07/22 22:48:05.265997 Database "TESTDEMO" (TESTDEMO.db) stopped at Mon Jul 22 2019 22:48
I. 07/22 22:48:05.286313 Starting database "TESTDEMO" (/sapmnt/NLS/siqdata/db/TESTDEMO.db) at Mon Jul 22 2019 22:48
E. 07/22 22:48:07.684571 Error: The previous log GUID in database identity differs from database definition.
-- (stcxtlib/st_database.cxx 5497)
E. 07/22 22:48:10.010011 Connection ID 2: Connection error '08W10': Specified database not found
I. 07/22 22:50:38.537862 TCP/IP: Received connection request from 1.2.3.122.

To recover the test DB, conducted couple of following trials, but server wouldn't bring up too

  - Try to start without Transaction log => fail to start
  - Used '-iqfrec' but still failed with same error => fail to start

(* This problem is investigation to know if it's production problem or customer environment issue.)



Environment

SAP IQ16.1 SP04

Product

SAP NetWeaver 7.5

Keywords

"log GUID", "st_database.cxx" , "database identity" , "database definition" , PITR, Point In Time, Point In Time recovery, , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.