Re: ER initialization problems
Posted in 2004
Topics: High Availability & Replication, SQL Development & Query Writing, Server Administration, Platform-Specific Issues
"Madison Pruet" <mpruet@comcast.net> wrote in message news:<j3nhc.169851$gA5.1981630@attbi_s03>...
> no, but I'd like to see the output of several onstat -g ath on the gr_asp2
> when the target is hanging...
>
>
> "Harry Johnson" <hjohnson@keeneinfo.com> wrote in message
> news:6830f442.0404201851.17a1cfaf@posting.google.com...
> > I am having a problem initializing ER on my 2 Linux servers. I am
> > running Informix 9.4.UC3 on both. I had a problem on the target
> > server so I deleted the server on both the Primary and Target using:
> >
> > "cdr delete server gr_asp" on the primary
> > "cdr delete server gr_asp2" on the target
> >
> > I checked both servers and the cdr database was gone from both. I
> > then tried to recreate the servers using the following on the primary:
> >
> > "cdr define server -c gr_asp -I gr_asp"
> > "cdr define server -c gr_asp2 -I -S gr_asp gr_asp2"
> >
> > This is what I used to create ER earlier. Now the target server just
> > hangs and I have to kill the server with ipcrm and then start it
> > again. Does anyone have any ideas?
> >
> > Thanks in advance.
Madison,
Here is the result of onstat -g ath
IBM Informix Dynamic Server Version 9.40.UC3 -- On-Line -- Up
23:42:28 -- 146148 Kbytes
Threads: tid tcb rstcb prty status vp-class
name
2 4a4e2370 0 2 sleeping forever 5lio
lio vp 0
3 4a500140 0 2 sleeping forever 6pio
pio vp 0
4 4a515140 0 2 running 7aio
aio vp 0
5 4a52a140 0 2 sleeping forever 8msc
msc vp 0
6 4a557140 0 2 sleeping forever 9aio
aio vp 1
7 4a56c140 0 2 sleeping forever 10aio
aio vp 2
8 4a5812a0 49fd4018 4 ready 1cpu
main_loop()
9 4a581e98 0 2 running 11soc
soctcppoll
10 4a5a98b0 0 2 cond wait arrived 12soc
soctcppoll
11 4a5bb8b0 0 3 ready 1cpu
soctcplst
12 4a5bbcf8 49fd4630 2 sleeping forever 1cpu
flush_sub(0)
13 4a5bbe88 49fd4c48 2 sleeping forever 1cpu
flush_sub(1)
14 4a5152d0 49fd5260 3 sleeping forever 1cpu
aslogflush
15 4a5157e0 49fd5878 1 ready 1cpu
btscanner 0
30 4a56ce98 49fd5e90 1 ready 1cpu
sbspclean
31 4a515e40 49fd6ac0 4 ready 1cpu
onmode_mon
34 4a557888 49fd76f0 1 cond wait btc sort 1cpu
btscanner 1
36 4a52a850 49fd64a8 2 ready 1cpu
onmonitor
37 4a56c4e0 49fd70d8 2 join wait 38 1cpu
sqlexec
38 4a500580 49fd7d08 2 running 1cpu
GCReq
Is there a case open?
"Harry Johnson" <hjohnson@keeneinfo.com> wrote in message
news:6830f442.0404211702.170bc10a@posting.google.com...
> "Madison Pruet" <mpruet@comcast.net> wrote in message
news:<j3nhc.169851$gA5.1981630@attbi_s03>...
> > no, but I'd like to see the output of several onstat -g ath on the
gr_asp2
> > when the target is hanging...
> >
> >
> > "Harry Johnson" <hjohnson@keeneinfo.com> wrote in message
> > news:6830f442.0404201851.17a1cfaf@posting.google.com...
> > > I am having a problem initializing ER on my 2 Linux servers. I am
> > > running Informix 9.4.UC3 on both. I had a problem on the target
> > > server so I deleted the server on both the Primary and Target using:
> > >
> > > "cdr delete server gr_asp" on the primary
> > > "cdr delete server gr_asp2" on the target
> > >
> > > I checked both servers and the cdr database was gone from both. I
> > > then tried to recreate the servers using the following on the primary:
> > >
> > > "cdr define server -c gr_asp -I gr_asp"
> > > "cdr define server -c gr_asp2 -I -S gr_asp gr_asp2"
> > >
> > > This is what I used to create ER earlier. Now the target server just
> > > hangs and I have to kill the server with ipcrm and then start it
> > > again. Does anyone have any ideas?
> > >
> > > Thanks in advance.
>
>
> Madison,
>
> Here is the result of onstat -g ath
>
> IBM Informix Dynamic Server Version 9.40.UC3 -- On-Line -- Up
> 23:42:28 -- 146148 Kbytes
>
> Threads:> tid tcb rstcb prty status vp-class
> name
> 2 4a4e2370 0 2 sleeping forever 5lio
> lio vp 0
> 3 4a500140 0 2 sleeping forever 6pio
> pio vp 0
> 4 4a515140 0 2 running 7aio
> aio vp 0
> 5 4a52a140 0 2 sleeping forever 8msc
> msc vp 0
> 6 4a557140 0 2 sleeping forever 9aio
> aio vp 1
> 7 4a56c140 0 2 sleeping forever 10aio
> aio vp 2
> 8 4a5812a0 49fd4018 4 ready 1cpu
> main_loop()
> 9 4a581e98 0 2 running 11soc
> soctcppoll
> 10 4a5a98b0 0 2 cond wait arrived 12soc
> soctcppoll
> 11 4a5bb8b0 0 3 ready 1cpu
> soctcplst
> 12 4a5bbcf8 49fd4630 2 sleeping forever 1cpu
> flush_sub(0)
> 13 4a5bbe88 49fd4c48 2 sleeping forever 1cpu
> flush_sub(1)
> 14 4a5152d0 49fd5260 3 sleeping forever 1cpu
> aslogflush
> 15 4a5157e0 49fd5878 1 ready 1cpu
> btscanner 0
> 30 4a56ce98 49fd5e90 1 ready 1cpu
> sbspclean
> 31 4a515e40 49fd6ac0 4 ready 1cpu
> onmode_mon
> 34 4a557888 49fd76f0 1 cond wait btc sort 1cpu
> btscanner 1
> 36 4a52a850 49fd64a8 2 ready 1cpu
> onmonitor
> 37 4a56c4e0 49fd70d8 2 join wait 38 1cpu
> sqlexec
> 38 4a500580 49fd7d08 2 running 1cpu
> GCReq
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g