12.10->14.10 with EaR
Posted in 2019
Topics: High Availability & Replication, Backup & Restore, Installation, Setup & Upgrades, Storage & Space Management, Error Codes & Troubleshooting, Server Administration, Security, Permissions & Auditing, Networking & sqlhosts Configuration, Migration, Import/Export & Data Conversion, Versions, Editions & End-of-Life
Hi
I have a problem with migration from 12.10 to 14.10 with encryption at rest
Main steps are:
I have Informix 12.10FC12 with DISK_ENCRYPTION parameter
Install Informix 14.10 in the different directory (install gsk8_64 too). Set
correct INFROMIXDIR...
Copy corresponding files to INFROMIXDIR/etc (from previous, 12.10
installation), such as: onconfig, sqlhosts, keystore.p12, keystore.sth
Run Informix instance:
oninit
Log file content:
...
04/18/19 04:47:09 Booting Language <c> from module <>
04/18/19 04:47:09 Loading Module <CNULL>
04/18/19 04:47:09 Booting Language <builtin> from module <>
04/18/19 04:47:09 Loading Module <BUILTINNULL>
04/18/19 04:47:15 DR: DRAUTO is 0 (Off)
04/18/19 04:47:15 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
04/18/19 04:47:15 Event notification facility epoll enabled.
04/18/19 04:47:15 Entries in the surrogates file
/etc/informix/allowed.surrogates are loaded into surrogate cache.
04/18/19 04:47:15 Trusted host cache successfully built:...
04/18/19 04:47:15 CCFLAGS2 value set to 0x200
04/18/19 04:47:15 SQL_FEAT_CTRL value set to 0x8008
04/18/19 04:47:15 SQL_DEF_CTRL value set to 0x4b0
04/18/19 04:47:15 IBM Informix Dynamic Server Version 14.10.FC1
04/18/19 04:47:16 Conversion from version 12.10.xC8 Started
04/18/19 04:47:16 Assert Failed: Page Check Error in init_dbspace_pre_chunk
04/18/19 04:47:16 IBM Informix Dynamic Server Version 14.10.FC1
04/18/19 04:47:16 Who: Session(1, informix@posproregister, 0, 0x4592e028)
Thread(7, main_loop(), 458e6028, 1)
File: rsdebug.c Line: 982
04/18/19 04:47:16 Results: Possible inconsistencies in '(null)'
...
04/18/19 04:47:23 Page Check Error in init_dbspace_pre_chunk
04/18/19 04:47:23 oninit: Fatal error in shared memory initialization
The similar issue with restoring from ontape backup
By the way, I see no error about encrypted restore while DISK_ENCRYPTIONs
files exit. On 12.10 it looks like:
One or both of the Encryption Key Database
(/opt/IBM/informix/etc/keystore.p12)
or Encryption Key Stashfile
(/opt/IBM/informix/etc/keystore.sth)
already exists. Because this is a complete initialization of
the __INF__ server they must not already exist.
Remove the file(s) manually or set the FULL_DISK_INIT onconfig
parameter to remove the files automatically.
Creation of encryption key database failed: GSKKM_ERR_DATABASE_ALREADY_EXISTS
(/opt/IBM/informix/etc/keystore.p12)
Physical restore failed - InitKeystore failed
I have no errors when I use unencrypted dbspaces, everything works fine...
What's wrong with my installation? Thank to all for any ideas...
Andy, nothing wrong, you are probably hitting against a known issue please look at my post for more details http://members.iiug.org/forums/ids/index.cgi/read/41671 Eric