VP Notify mechanism incomplete after 5 minutes
Posted in 2009
Topics: Error Codes & Troubleshooting, Networking & sqlhosts Configuration, Platform-Specific Issues
Question: We are receiving the two errors below. Has anyone else
received these and what was the course of action? The OS is AIX 6.1.0.0
and IDS version 9.40.UC3.
We have two instances on the same server, which one has synonyms
pointing to the other. The application is probably using a TCP/IP
connection.
Question: Should they utilize a shared memory connection with being on
the same server or is that not necessary?
IBM Informix Dynamic Server Version 9.40.UC3 -- On-Line -- Up
03:22:38 -- 2275792 Kbytes
geordi:/home/informix>onstat -m
IBM Informix Dynamic Server Version 9.40.UC3 -- On-Line (CKPT REQ)
-- Up 01:28:14 -- 1642400 Kbytes
Blocked:CKPT
Message Log File: /ifmx/ifmxehdsp/online.log
File: mtex.c Line: 431
17:33:33 Results: Exception Caught. Type: MT_EX_OS, Context: ill
17:33:33 Action: Please notify IBM Informix Technical Support.
17:33:33 stack trace for pid 913464 written to
/ifmx/backups/af.8c0b6fad
17:33:33 See Also: /ifmx/backups/af.8c0b6fad
17:33:36 Assert Failed: inbuf->sb_base->io_head.io_nrows <=
sr->sr_iorows
17:33:36 IBM Informix Dynamic Server Version 9.40.UC3
17:33:36 Who: Session(35242, hds@picard, 426142, 62a136c0)
Thread(35792, srvinfx, 6736f248, 1)
File: sort.c Line: 3202
17:33:36 Results: srtrdbuf
17:33:36 stack trace for pid 819390 written to
/ifmx/backups/af.8fb86faf
17:33:36 See Also: /ifmx/backups/af.8fb86faf
17:33:37 mtex.c, line 431, thread 34851, proc id 913464, No Exception
Handler.
17:33:39 inbuf->sb_base->io_head.io_nrows <= sr->sr_iorows
17:38:37 VP Notify mechanism incomplete after 5 minutes. This can be
due to slow network file access. Will try 12 more times
17:43:37 VP Notify mechanism incomplete after 5 minutes. This can be
due to slow network file access. Will try 11 more times
17:48:37 VP Notify mechanism incomplete after 5 minutes. This can be
due to slow network file access. Will try 10 more times
17:53:37 VP Notify mechanism incomplete after 5 minutes. This can be
due to slow network file access. Will try 9 more times
17:58:37 VP Notify mechanism incomplete after 5 minutes. This can be
due to slow network file access. Will try 8 more times
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com
Blackberry: 2244650553@messaging.sprintpcs.com
<mailto:2244650553@messaging.sprintpcs.com>
Page via Skytel: 2244650553@sprint.skytel.com
<mailto:2244650553@sprint.skytel.com>
Informix or MySQL Primary: 9110210@skytel.com
<mailto:9110210@skytel.com>
Informix or MySQL Secondary: 7276872@skytel.com
<mailto:7276872@skytel.com>
" Yes we can make a Change! "
" It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS!
"
" Lets not forget - GO Pistons and Red Wings! "
GSU
*******************************************************************
Ernest,
Check out this link:
http://www-01.ibm.com/support/docview.wss?uid=swg21237045
Looks like the NET VP or CPU VP listening on TLI is hung. The post is from
a Solaris installation, so the response about patches may be spurious, but
the symptom and immediate cause is valid.
Again, it's time to upgrade.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, Aug 19, 2009 at 10:57 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrote:
> Question: We are receiving the two errors below. Has anyone else
> received these and what was the course of action? The OS is AIX 6.1.0.0
> and IDS version 9.40.UC3.
>
> We have two instances on the same server, which one has synonyms
> pointing to the other. The application is probably using a TCP/IP
> connection.
>
> Question: Should they utilize a shared memory connection with being on
> the same server or is that not necessary?
>
> IBM Informix Dynamic Server Version 9.40.UC3 -- On-Line -- Up
> 03:22:38 -- 2275792 Kbytes
>
> geordi:/home/informix>onstat -m
>
> IBM Informix Dynamic Server Version 9.40.UC3 -- On-Line (CKPT REQ)
> -- Up 01:28:14 -- 1642400 Kbytes>
> Blocked:CKPT
>
> Message Log File: /ifmx/ifmxehdsp/online.log
>
> File: mtex.c Line: 431
>
> 17:33:33 Results: Exception Caught. Type: MT_EX_OS, Context: ill
>
> 17:33:33 Action: Please notify IBM Informix Technical Support.
>
> 17:33:33 stack trace for pid 913464 written to
> /ifmx/backups/af.8c0b6fad
>
> 17:33:33 See Also: /ifmx/backups/af.8c0b6fad
>
> 17:33:36 Assert Failed: inbuf->sb_base->io_head.io_nrows <=
> sr->sr_iorows
>
> 17:33:36 IBM Informix Dynamic Server Version 9.40.UC3
>
> 17:33:36 Who: Session(35242, hds@picard, 426142, 62a136c0)
>
> Thread(35792, srvinfx, 6736f248, 1)
>
> File: sort.c Line: 3202
>
> 17:33:36 Results: srtrdbuf
>
> 17:33:36 stack trace for pid 819390 written to
> /ifmx/backups/af.8fb86faf
>
> 17:33:36 See Also: /ifmx/backups/af.8fb86faf
>
> 17:33:37 mtex.c, line 431, thread 34851, proc id 913464, No Exception
> Handler.
>
> 17:33:39 inbuf->sb_base->io_head.io_nrows <= sr->sr_iorows
>
> 17:38:37 VP Notify mechanism incomplete after 5 minutes. This can be
> due to slow network file access. Will try 12 more times
>
> 17:43:37 VP Notify mechanism incomplete after 5 minutes. This can be
> due to slow network file access. Will try 11 more times
>
> 17:48:37 VP Notify mechanism incomplete after 5 minutes. This can be
> due to slow network file access. Will try 10 more times
>
> 17:53:37 VP Notify mechanism incomplete after 5 minutes. This can be
> due to slow network file access. Will try 9 more times
>
> 17:58:37 VP Notify mechanism incomplete after 5 minutes. This can be
> due to slow network file access. Will try 8 more times
>
> Thanks,
>
> *******************************************************************
>
> Ernie Knox
>
> IT Database Administrator Specialist
>
> Sears Holdings
>
> 3333 Beverly Rd., B4-266A
>
> Hoffman Estates, IL. 60179
>
> Office: (847) 286-5735
>
> Email: Ernest.Knox@searshc.com
>
> Blackberry: 2244650553@messaging.sprintpcs.com
> <mailto:2244650553@messaging.sprintpcs.com>
>
> Page via Skytel: 2244650553@sprint.skytel.com
> <mailto:2244650553@sprint.skytel.com>
>
> Informix or MySQL Primary: 9110210@skytel.com
> <mailto:9110210@skytel.com>
>
> Informix or MySQL Secondary: 7276872@skytel.com
> <mailto:7276872@skytel.com>
>
> " Yes we can make a Change! "
>
> " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS!
> "
>
> " Lets not forget - GO Pistons and Red Wings! "
>
> GSU
>
> *******************************************************************
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001517473434398afc0471938036