Help needed: onsoctcp on Linux
Posted in 1999
Hi,
I do have problems getting Informix IDS to startup when
network connectivity related entries are present in 'sqlhosts'.
Appreciating 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
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
===========------------- - - - - - -
part of /adiuvo/logs/i-online.log:
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 10aio vp
3
17 1395f288 0 2 sleeping forever 11aio vp
4
18 1395f4dc 0 2 sleeping forever 12aio vp
5
===========------------- - - - - - -
/adiuvo/ods/bin/onstat -g stk 9 light:
Informix Dynamic Server Version 7.30.U -- Initialization -- Up
00:00:09 -- 65544 Kbytes
Stack for thread: 9 soctcppoll
base: 0x139fe014
len: 33280
pc: 0x082b7691
tos: 0x13a058c4state: running
vp: 8
0x082b7691 (oninit)mt_system(0x13a05d0c, 0x13a05f98, 0x843f35f, 0x1,
0x1, 0x1)
0x082cc228 (oninit)afhandler(0x2, 0x13a05f98, 0x0, 0x0, 0x0, 0x0)
0x082cbd6d (oninit)affail_interface(0x13a05f98, 0x0, 0x0, 0x8438597,
0x0, 0x13a05fe8)
0x082cbd04 (oninit)mt_affail(0x13a05f98, 0x0, 0x0, 0x0, 0x0, 0x13a05f98)
0x082e5748 (oninit)net_abort(0x843f35f, 0x830, 0x843f353, 0x843f313,
0x7d4e, 0x0)
0x082e6c1b (oninit)bsd_nsf_flush(0x0, 0x843f2a4, 0x0, 0x4, 0x16, 0xc)
0x082e6ae7 (oninit)bsd_nsf_sendfd(0x0, 0x4, 0x0, 0x1, 0x0, 0x138bb8b8)
0x082e79f8 (oninit)bsd_nsf_putlocal(0x0, 0x138c5d98, 0x0, 0x13a060c4,
0x82ee28e, 0x0)
0x082ee352 (oninit)interupt_input_poll(0x0, 0x1, 0x3, 0x138c5d98, 0x0,
0x0)
0x082ee28e (oninit)interupt_process(0x138c5d98, 0x1, 0x0, 0x0, 0x0,
0x13a0c014)
0x082ed910 (oninit)soc_poll_thread(0x0, 0x0, 0x0, 0xffffffff,
0x13a08000, 0x139fe000)
0x082b8ce5 (oninit)startup (0xffffffff, 0x13a08000, 0x139fe000, 0x1dec,
0x27407ded, 0x13a0a114)
0x00000000 (***nosymtab***)0x0
===========------------- - - - - - -
/adiuvo/ods/bin/onstat -u:
Informix Dynamic Server Version 7.30.U -- Initialization -- Up
00:00:09 -- 65544 Kbytes
Userthreads
address flags