Upgrade from IDS 15.0.0.2 to 15.0.1.0 errors for IPA's
Jean-Guy Charron could not upgrade from 15.0.0.2 to 15.0.1.0: startup reported outstanding in-place alters on partition pages despite running task('table update_ipa') on tables with tabid >= 100. Hedwig Fuchs asked for a support ticket; Milan Rafaj had similar problems. Andreas Legner asked about dropping the tabid filter, which Jean-Guy had tried without change. Unresolved; a case was opened.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi everyone,
When I try to upgrade from 15.0.0.2 to 15.0.1.0 I have errors about IPA's.
On 15.0.0.2 I run for each database:
select sysadmin:task("table update_ipa",tabname)
from systables
where tabid >= 100
and tabtype = "T"
;
When I start 15.0.1.0 I have the following messages:
14:11:57 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 228978688 bytes. Available: 0 bytes.
The default memory page size will be used.
14:11:57 Requested shared memory segment size rounded from 223609KB to 223612KB
14:11:57 Segment locked: addr=0x145ed0000, size=228978688
14:11:57 Successfully added a bufferpool of page size 2K.
14:11:57 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure permissions
14:11:57 Event alarms enabled. ALARMPROG = '/opt/IBM/informix/etc/alarmprogram.sh'
14:11:57 Booting Language <c> from module <>
14:11:57 Loading Module <CNULL>
14:11:57 Booting Language <builtin> from module <>
14:11:57 Loading Module <BUILTINNULL>
14:12:03 Trusted host cache successfully built:/etc/hosts.equiv.
14:12:03 KERNEL_CTRL - Default value: 0x270b5, Current setting: 0x70b5
14:12:03 CCFLAGS - Default value: 0, Current setting: 0x0
14:12:03 DR: DRAUTO is 0 (Off)
14:12:03 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
14:12:03 Event notification facility epoll enabled.
14:12:03 IBM Informix Dynamic Server Version 15.0.1.0WE
14:12:03 VP 8 is requesting 8192 kaio event resources.
14:12:03 Performance Advisory: The current size of the physical log buffer is smaller than recommended.
14:12:03 Results: Transaction performance might not be optimal.
14:12:03 Action: For better performance, increase the physical log buffer size to 4096.
14:12:03 The current size of the logical log buffer is smaller than recommended.
14:12:03 Conversion from version 15.0.0.0 Started
14:12:04 Checking partition header pages for IPAs and required free space...
14:12:05 IPA Version slot on secondary partition page 5:21 shows outstanding IPAs.
14:12:05 IPA Version slot on secondary partition page 5:42 shows outstanding IPAs.
14:12:06 IPA Version slot on secondary partition page 5:585 shows outstanding IPAs.
14:12:06 You will need to resolve all in-place alters (IPAs) in your previous
version before migrating to version 15.0.1.0. No disk structures have
been altered during this conversion attempt. For information
on generating the list of tables requiring IPA resolution,
see the section titled "Resolve outstanding in-place alter
operations" in the latest Informix documentation.
14:12:06 Check for IPAs and required space in partition header pages failed.
14:12:06 oninit: Fatal error in shared memory initialization
14:12:06 IBM Informix Dynamic Server Stopped.
I run oncheck -pT for each database and there is no IPA.
OS: OpenSuse 15.5 on VMware
Linux compt-flexio-dev 5.14.21-150500.55.39-default #1 SMP PREEMPT_DYNAMIC Tue Dec 5 10:06:35 UTC 2023 (2e4092e) x86_64 x86_64 x86_64 GNU/Linux
I try fix_ipa from
Art Kagel but it did't find any IPA.
What's next ?
Thanks
------------------------------
Jean-Guy Charron
------------------------------
Hi I see some more questions here which needs an answer. Therefore - can you open a support ticket for this issue? ------------------------------ Hedwig Fuchs ------------------------------
Hello, I had similar problems when trying upgrade from 15.0.0.2 to 15.0.1.0 (besides others during conversion from 12/14.x to 15.x on AIX) - see TS020674987 Milan Rafaj Senior Lead, Infrastructure/Cloud Architecture Kyndryl Consult +420 737 264 248 www.kyndryl.cz Planned absence/Plánovaná nepřítomnost: 30.5., 6.6., 20.6.2025 Kyndryl Česká republika, spol. s r. o. Sídlo: Praha 4, Chodov, V Parku 2308/8, PSČ: 148 00, IČ: 14890992 Zapsaná v obchodním rejstříku, vedeném Městským soudem v Praze (oddíl C, vložka 339277) Registered address: Prague 4, Chodov, V Parku, 2308/8, Zip code: 148 00 Company ID: 14890992 Entered in the Commercial Register maintained by the Municipal Court in Prague (Part C, Entry 339277) --
Just curious: would omitting the "tabid >= 100" filter in your update_ipa query avoid this problem? ------------------------------ Andreas Legner Informix Dev HCL Software ------------------------------
Case number TS021403988 ------------------------------ Jean-Guy Charron ------------------------------
I already try it and It dont' change anything. ------------------------------ Jean-Guy Charron ------------------------------