mt_shm_remove: WARNING: may not have removed all/c
An Informix instance failed to initialize with a shared memory error after encountering corrupt logical log records during recovery. The root cause was inability to rollforward from checkpoint due to unknown log record types. Suggested solutions included: attempting single-user mode initialization (oninit -j), restoring logical logs, or forcing the server to skip to the next log file.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
Good Day, one of our informix instance went down and cannot be initialized.
Upon checking the log file here is what we gathered, we even tried bouncing
the server to no avail.
Part of the initialization process succeeded up until ReadAhead Daemon
Initializing 8 flushers...succeeded
Initializing SDS Server network connections...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Initializing DBSPACETEMP list...succeeded
Init ReadAhead Daemon...succeeded
oninit: Fatal error in shared memory initialization
Part of the log file
11:09:59 Started 1 B-tree scanners.
11:09:59 B-tree scanner threshold set at 5000.
11:09:59 B-tree scanner range scan size set to -1.
11:09:59 B-tree scanner ALICE mode set to 6.
11:09:59 B-tree scanner index compression level set to med.
11:09:59 Physical Recovery Started at Page (2:4957).
11:09:59 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
11:09:59 Logical Recovery Started.
11:09:59 10 recovery worker threads will be started.
11:09:59 Requested shared memory segment size rounded from 464204KB to 464208KB
11:09:59 Dynamically allocated new virtual shared memory segment (size
464208KB)
11:09:59 Memory sizes:resident:186208 KB, virtual:505936 KB, no SHMTOTAL limit
11:09:59 Transaction Not Found.
11:09:59 Log Record: log = 50635, pos = 0x8c018, type = UNKNOWN:UNKNOWN(2),
trans = 808465457
11:09:59 Cannot Rollforward from Checkpoint.
11:10:00 oninit: Fatal error in shared memory initialization
11:10:00 IBM Informix Dynamic Server Stopped.
11:10:00 mt_shm_remove: WARNING: may not have removed all/correct segments
Shared memory issue is irrelevant - the problem is you are not able to roll
forward. Looks like corrupt logical log records ? Got support then call IBM
Cheers
Paul
Paul Watson
Oninit www.oninit.com
+1 913 387 7529
Oninit® is a Registered Trademark of Oninit LLC
> On Dec 2, 2015, at 21:42, LESTER POLICARPIO <lpolicarpio2009@yahoo.com>
wrote:
>
> Hi,
>
> Good Day, one of our informix instance went down and cannot be initialized.
> Upon checking the log file here is what we gathered, we even tried bouncing
> the server to no avail.
>
> Part of the initialization process succeeded up until ReadAhead Daemon
>
> Initializing 8 flushers...succeeded
> Initializing SDS Server network connections...succeeded
> Initializing log/checkpoint information...succeeded
> Initializing dbspaces...succeeded
> Opening primary chunks...succeeded
> Opening mirror chunks...succeeded
> Validating chunks...succeeded
> Initialize Async Log Flusher...succeeded
> Starting B-tree Scanner...succeeded
> Initializing DBSPACETEMP list...succeeded
> Init ReadAhead Daemon...succeeded
> oninit: Fatal error in shared memory initialization
>
> Part of the log file
>
> 11:09:59 Started 1 B-tree scanners.
> 11:09:59 B-tree scanner threshold set at 5000.
> 11:09:59 B-tree scanner range scan size set to -1.
> 11:09:59 B-tree scanner ALICE mode set to 6.
> 11:09:59 B-tree scanner index compression level set to med.
> 11:09:59 Physical Recovery Started at Page (2:4957).
> 11:09:59 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
> 11:09:59 Logical Recovery Started.
> 11:09:59 10 recovery worker threads will be started.
> 11:09:59 Requested shared memory segment size rounded from 464204KB to
> 464208KB
> 11:09:59 Dynamically allocated new virtual shared memory segment (size
> 464208KB)
> 11:09:59 Memory sizes:resident:186208 KB, virtual:505936 KB, no SHMTOTAL
limit
> 11:09:59 Transaction Not Found.
> 11:09:59 Log Record: log = 50635, pos = 0x8c018, type = UNKNOWN:UNKNOWN(2),
> trans = 808465457
> 11:09:59 Cannot Rollforward from Checkpoint.
> 11:10:00 oninit: Fatal error in shared memory initialization
>
> 11:10:00 IBM Informix Dynamic Server Stopped.
>
> 11:10:00 mt_shm_remove: WARNING: may not have removed all/correct segments
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
Check if you can make the server up in Single user mode.=20
Thanks,,
Amitava
(This is an Informix Enthustic Comment - IBM company not responsible)
From: "Paul Watson" <paul@oninit.com>
To: ids@iiug.org
Date: 12/03/2015 11:58 AM
Subject: Re: mt=5Fshm=5Fremove: WARNING: may not have remov.... [361=
45]
Sent by: ids-bounces@iiug.org
Shared memory issue is irrelevant - the problem is you are not able to=20
roll=20
forward. Looks like corrupt logical log records ? Got support then call=20
IBM=20
Cheers=20
Paul=20
Paul Watson=20
Oninit www.oninit.com=20
+1 913 387 7529=20
Oninit=AE is a Registered Trademark of Oninit LLC=20
> On Dec 2, 2015, at 21:42, LESTER POLICARPIO <lpolicarpio2009@yahoo.com>=20
wrote:=20
>=20
> Hi,=20
>=20
> Good Day, one of our informix instance went down and cannot be=20
initialized.=20
> Upon checking the log file here is what we gathered, we even tried=20
bouncing=20
> the server to no avail.=20
>=20
> Part of the initialization process succeeded up until ReadAhead Daemon=20
>=20
> Initializing 8 flushers...succeeded=20
> Initializing SDS Server network connections...succeeded=20
> Initializing log/checkpoint information...succeeded=20
> Initializing dbspaces...succeeded=20
> Opening primary chunks...succeeded=20
> Opening mirror chunks...succeeded=20
> Validating chunks...succeeded=20
> Initialize Async Log Flusher...succeeded=20
> Starting B-tree Scanner...succeeded=20
> Initializing DBSPACETEMP list...succeeded=20
> Init ReadAhead Daemon...succeeded=20
> oninit: Fatal error in shared memory initialization=20
>=20
> Part of the log file=20
>=20
> 11:09:59 Started 1 B-tree scanners.=20
> 11:09:59 B-tree scanner threshold set at 5000.=20
> 11:09:59 B-tree scanner range scan size set to -1.=20
> 11:09:59 B-tree scanner ALICE mode set to 6.=20
> 11:09:59 B-tree scanner index compression level set to med.=20
> 11:09:59 Physical Recovery Started at Page (2:4957).=20
> 11:09:59 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. =
> 11:09:59 Logical Recovery Started.=20
> 11:09:59 10 recovery worker threads will be started.=20
> 11:09:59 Requested shared memory segment size rounded from 464204KB to=20
> 464208KB=20
> 11:09:59 Dynamically allocated new virtual shared memory segment (size=20
> 464208KB)=20
> 11:09:59 Memory sizes:resident:186208 KB, virtual:505936 KB, no SHMTOTAL =
limit=20
> 11:09:59 Transaction Not Found.=20
> 11:09:59 Log Record: log =3D 50635, pos =3D 0x8c018, type =3D=20
UNKNOWN:UNKNOWN(2),=20
> trans =3D 808465457=20
> 11:09:59 Cannot Rollforward from Checkpoint.=20
> 11:10:00 oninit: Fatal error in shared memory initialization=20
>=20
> 11:10:00 IBM Informix Dynamic Server Stopped.=20
>=20
> 11:10:00 mt=5Fshm=5Fremove: WARNING: may not have removed all/correct=20
segments=20
>=20
>=20
>=20
***************************************************************************=
****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
Hi Amitava,
Thanks for the response just to be sure you are referring to the oninit -j
command right? And if ever I successfully login in the server what would be
the next step to fully correct the issue?
Thanks,
correct you are.
Thanks,,
Amitava
From: "LESTER POLICARPIO" <lpolicarpio2009@yahoo.com>
To: ids@iiug.org
Date: 12/03/2015 02:35 PM
Subject: Re: mt=5Fshm=5Fremove: WARNING: may not have remov.... [361=
49]
Sent by: ids-bounces@iiug.org
Hi Amitava,=20
Thanks for the response just to be sure you are referring to the oninit -j =
command right? And if ever I successfully login in the server what would=20
be=20
the next step to fully correct the issue?=20
Thanks,=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
You can try for 2 options.
1. restore logical log
2. force the server to the next log.
Thanks,,
Amitava
(This is an Informix Enthustic Comment - IBM company not responsible)
From: Amitava Chakraborty/India/IBM
To: ids@iiug.org
Date: 12/03/2015 02:49 PM
Subject: Re: mt=5Fshm=5Fremove: WARNING: may not have remov.... [361=
49]
correct you are.
Thanks,,
Amitava
From: "LESTER POLICARPIO" <lpolicarpio2009@yahoo.com>
To: ids@iiug.org
Date: 12/03/2015 02:35 PM
Subject: Re: mt=5Fshm=5Fremove: WARNING: may not have remov.... [361=
49]
Sent by: ids-bounces@iiug.org
Hi Amitava,=20
Thanks for the response just to be sure you are referring to the oninit -j =
command right? And if ever I successfully login in the server what would=20
be=20
the next step to fully correct the issue?=20
Thanks,=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20