Oninit cdi / Archive
Talk to an expert →

Help needed: onsoctcp on Linux

Posted in 1999

Summary

User reported Informix IDS 7.30 crashing on Linux with assertion failures in nsfpipe.c (errno=22) in the soctcppoll thread when network entries were in sqlhosts. Solution: add NETTYPE entry specifying CPU VP for TCP connections (NETTYPE soctcp,1,50,CPU) and set NUMCPUVPS to 1. This worked around a known NET VP bug on Linux, though other VP combinations still caused crashes.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management, Error Codes & Troubleshooting, Logging & Checkpoints, Networking & sqlhosts Configuration, Platform-Specific Issues

Marc Mielke — — source: Informix-list mailing list archive (1991-1998)

Hi, I do have problems getting Informix IDS to startup when network connectivity related entries are present in 'sqlhosts'. Apreciating any help.. Details: System from 'uname -a': Linux wasabi 2.0.36 .... i686 unknown Part of af.* file: 11:29:05 Informix Dynamic Server Version 7.30.U Software SerialNumber AAC#A518469 here is the trouble...: 11:29:05 Assert Failed: nsfpipe.c, line 2096, thread 9, errno=22, spipe error. ------------------------------------------------------------------------------- 11:29:05 Who: Session(3, root@, 0, 0) Thread(9, soctcppoll, 0, 8) File: called by ASF mt_affail Line: 0 --------------------------------- Begin System Alarm Program Output --------------------------------- Assertion Failure Type:\\t\\c FAILURE Host Name:\\t\\twasabi Database Server Name:\\tlocalshm Time of failure:\\t\\c Thu Jan 21 11:29:05 MET 1999 AF file:\\t\\t/adiuvo/tmp/af.90170 Shared memory file:\\tNone System Blocking:\\t\\c OFF ===========------------- - - - - - - tail -100 /adiuvo/logs/i-online.log: 10:55:07 On-Line Mode 10:55:07 Checkpoint Completed: duration was 0 seconds. 10:55:08 See Also: /adiuvo/tmp/af.9f975 10:55:08 nsfpipe.c, line 2096, thread 9, errno=22, spipe error. 10:55:08 PANIC: Attempting to bring system down 10:56:16 Segment locked: addr=0x10000000, size=58925056 10:56:16 Segment locked: addr=0x10000000, size=58925056 Thu Jan 21 10:56:16 1999 10:56:16 Event alarms enabled. ALARMPROG = '/adiuvo/ods/etc/log_full.sh' 10:56:23 DR: DRAUTO is 0 (Off) 10:56:23 Requested shared memory segment size rounded from 588KB to592KB 10:56:24 Informix Dynamic Server Version 7.30.U Software SerialNumber AAC#A518469 10:56:24 Assert Failed: nsfpipe.c, line 2096, thread 9, errno=22, spipe error. 10:56:24 Informix Dynamic Server Version 7.30.U 10:56:24 Who: Session(3, root@, 0, 0) Thread(9, soctcppoll, 0, 8) File: called by ASF mt_affail Line: 0 10:56:25 Informix Dynamic Server Initialized -- Shared MemoryInitialized. 10:56:25 Physical Recovery Started. 10:56:26 Physical Recovery Complete: 0 Pages Restored. 10:56:26 Logical Recovery Started. 10:56:29 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 10:56:29 Dataskip is now OFF for all dbspaces 10:56:29 On-Line Mode 10:56:29 Checkpoint Completed: duration was 0 seconds. 10:56:30 See Also: /adiuvo/tmp/af.9f9c7 10:56:30 nsfpipe.c, line 2096, thread 9, errno=22, spipe error. 10:56:30 PANIC: Attempting to bring system down 10:57:22 Segment locked: addr=0x10000000, size=58925056 10:57:22 Segment locked: addr=0x10000000, size=58925056 Thu Jan 21 10:57:23 1999 10:57:23 Event alarms enabled. ALARMPROG = '/adiuvo/ods/etc/log_full.sh' 10:57:30 DR: DRAUTO is 0 (Off) 10:57:30 Requested shared memory segment size rounded from 588KB to592KB 10:57:30 Informix Dynamic Server Version 7.30.U Software SerialNumber AAC#A518469 10:57:30 Assert Failed: nsfpipe.c, line 2096, thread 9, errno=22, spipe error. 10:57:30 Informix Dynamic Server Version 7.30.U 10:57:30 Who: Session(3, root@, 0, 0) Thread(9, soctcppoll, 0, 8) File: called by ASF mt_affail Line: 0 10:57:32 Informix Dynamic Server Initialized -- Shared MemoryInitialized. 10:57:32 Physical Recovery Started. 10:57:32 Physical Recovery Complete: 0 Pages Restored. 10:57:32 Logical Recovery Started. 10:57:35 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 10:57:35 Dataskip is now OFF for all dbspaces 10:57:35 On-Line Mode 10:57:35 Checkpoint Completed: duration was 0 seconds. 10:57:37 See Also: /adiuvo/tmp/af.9fa0a 10:57:37 nsfpipe.c, line 2096, thread 9, errno=22, spipe error. 10:57:37 PANIC: Attempting to bring system down 11:18:00 Segment locked: addr=0x10000000, size=58925056 11:18:00 Segment locked: addr=0x10000000, size=58925056 Thu Jan 21 11:18:00 1999 11:18:00 Event alarms enabled. ALARMPROG = '/adiuvo/ods/etc/log_full.sh' 11:18:07 DR: DRAUTO is 0 (Off) 11:18:07 Requested shared memory segment size rounded from 588KB to592KB 11:18:08 Informix Dynamic Server Version 7.30.U Software SerialNumber AAC#A518469 11:18:08 Assert Failed: nsfpipe.c, line 2096, thread 9, errno=22, spipe error. 11:18:08 Informix Dynamic Server Version 7.30.U 11:18:08 Who: Session(3, root@, 0, 0) Thread(9, soctcppoll, 0, 8) File: called by ASF mt_affail Line: 0 11:18:09 Informix Dynamic Server Initialized -- Shared MemoryInitialized. 11:18:09 Physical Recovery Started. 11:18:09 Physical Recovery Complete: 0 Pages Restored. 11:18:09 Logical Recovery Started. 11:18:12 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 11:18:12 Dataskip is now OFF for all dbspaces 11:18:12 On-Line Mode 11:18:12 Checkpoint Completed: duration was 0 seconds. 11:18:14 See Also: /adiuvo/tmp/af.9fedf 11:18:14 nsfpipe.c, line 2096, thread 9, errno=22, spipe error. 11:18:14 PANIC: Attempting to bring system down 11:28:56 Segment locked: addr=0x10000000, size=58925056 11:28:57 Segment locked: addr=0x10000000, size=58925056 Thu Jan 21 11:28:57 1999 11:28:57 Event alarms enabled. ALARMPROG = '/adiuvo/ods/etc/log_full.sh' 11:29:04 DR: DRAUTO is 0 (Off) 11:29:04 Requested shared memory segment size rounded from 588KB to592KB 11:29:05 Informix Dynamic Server Version 7.30.U Software SerialNumber AAC#A518469 11:29:05 Assert Failed: nsfpipe.c, line 2096, thread 9, errno=22, spipe error. 11:29:05 Informix Dynamic Server Version 7.30.U 11:29:05 Who: Session(3, root@, 0, 0) Thread(9, soctcppoll, 0, 8) File: called by ASF mt_affail Line: 0 ===========------------- - - - - - - /adiuvo/ods/bin/onstat -g ath: Informix Dynamic Server Version 7.30.U -- Initialization -- Up 00:00:09 -- 65544 Kbytes Threads: tid tcb rstcb prty status vp-class name 2 13944224 0 2 sleeping forever 3lio vp 0 3 13944458 0 2 sleeping forever 4pio vp 0 4 139446ac 0 2 sleeping forever 5aio vp 0 5 13944900 0 2 sleeping forever 6msc vp 0 6 13944b54 0 2 sleeping forever 7aio vp 1 7 13944e8c 13874014 4 sleeping forever 1cpu main_loop() 8 1394564c 0 2 running 1cpu sm_poll *9 1395ae10 0 2 running 8soc soctcppoll 10 1395b344 0 3 sleeping forever 1cpu sm_listen 11 1395bd78 0 2 sleeping secs: 1 1cpu sm_discon 12 1395e364 0 3 sleeping forever 1cpu soctcplst 13 1395e810 138744c8 2 sleeping forever 1cpu flush_sub(0) 14 1395ea68 1387497c 2 sleeping forever 1cpu flush_sub(1) 15 1395ed8c 0 2 sleeping secs: 1 9aio vp 2 16 1395efe0 0 2 sleeping secs: 1

↪ replying to Marc Mielke
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

Marc Mielke wrote: > > Hi, > > I do have problems getting Informix IDS to startup when > network connectivity related entries are present in 'sqlhosts'. > > Apreciating any help.. I believe that you need a NETTYPE entry specifying that CPU VP be used to listen to TCP connections, there is a known bug in the NET VP code on Linux. Towit: NETTYPE soctcp,1,50,CPU # One CPU VP listening, up to 50 connections Art S. Kagel

↪ replying to Art S. Kagel
Joe Blackman — — source: Informix-list mailing list archive (1991-1998)

Tried that, failed. I almost thought it had worked, but it took just a few dbaccess connections to bring the whole lot tumbling down. I raised a case via the net with Informix support, but they have not gotten back to me. Do they really care...? I have even resorted to upgrading to _exactly_ the configuration recommended by Informix, to no avail. If I do get any responses back from Informix, I'll post it on the informix.idn.linux newsgroup. Cheers, Joe. "Art S. Kagel" wrote: > Marc Mielke wrote: > > > > Hi, > > > > I do have problems getting Informix IDS to startup when > > network connectivity related entries are present in 'sqlhosts'. > > > > Apreciating any help.. > > I believe that you need a NETTYPE entry specifying that CPU VP be used > to listen to TCP connections, there is a known bug in the NET VP code > on Linux. Towit: > > NETTYPE soctcp,1,50,CPU # One CPU VP listening, up to 50 connections> > Art S. Kagel

↪ replying to Art S. Kagel
Marc Mielke — — source: Informix-list mailing list archive (1991-1998)

"Art S. Kagel" wrote: > > Marc Mielke wrote: > > > > Hi, > > > > I do have problems getting Informix IDS to startup when > > network connectivity related entries are present in 'sqlhosts'. > > > > Apreciating any help.. > > I believe that you need a NETTYPE entry specifying that CPU VP be used > to listen to TCP connections, there is a known bug in the NET VP code > on Linux. Towit: > > NETTYPE soctcp,1,50,CPU # One CPU VP listening, up to 50 connections> > Art S. Kagel Hi, I could swear I had that in the file before... I added the entry and for now it works (or better: it starts up and allows connects, there is no real load) without trouble. Thank you very much. -- ----------- Marc Mielke

↪ replying to Art S. Kagel
Marc Mielke — — source: Informix-list mailing list archive (1991-1998)

Hi, It only works if NUMCPUVPS 1 ^and NETTYPE soctcp, 1, xx, CPU ^ Any other combination of numbers of VPs crashes (@ least mine) the system. Marc "Art S. Kagel" wrote: > > Marc Mielke wrote: > > > > Hi, > > > > I do have problems getting Informix IDS to startup when > > network connectivity related entries are present in 'sqlhosts'. > > > > Apreciating any help.. > > I believe that you need a NETTYPE entry specifying that CPU VP be used > to listen to TCP connections, there is a known bug in the NET VP code > on Linux. Towit: > > NETTYPE soctcp,1,50,CPU # One CPU VP listening, up to 50 connections> > Art S. Kagel -- ----------- Marc Mielke

↪ replying to Marc Mielke
Joe Blackman — — source: Informix-list mailing list archive (1991-1998)

Curiouser and curiouser. Yes, it works for me as well. I think I can survive the handicap of having to make all connections through a socket. I had NUMCPUVPS 2 as a legacy of my attempts to have both shm and soc working at the same time. Many thanks, Marc and Art. Joe. Marc Mielke wrote: > Hi, > > It only works if > > NUMCPUVPS 1 > ^> and > > NETTYPE soctcp, 1, xx, CPU > ^> > Any other combination of numbers of VPs crashes (@ least mine) the > system. > > Marc > > "Art S. Kagel" wrote: > > > > Marc Mielke wrote: > > > > > > Hi, > > > > > > I do have problems getting Informix IDS to startup when > > > network connectivity related entries are present in 'sqlhosts'. > > > > > > Apreciating any help.. > > > > I believe that you need a NETTYPE entry specifying that CPU VP be used > > to listen to TCP connections, there is a known bug in the NET VP code > > on Linux. Towit: > > > > NETTYPE soctcp,1,50,CPU # One CPU VP listening, up to 50 connections> > > > Art S. Kagel > > -- > > ----------- > Marc Mielke

Related threads

Glossary