Unix Technical Forum

Problem with ER

This is a discussion on Problem with ER within the Informix forums, part of the Database Server Software category; --> Hi all, IDS 7.31.UD4; SCO 3.2 5.0.6 7 Server with update everywhere in ER. On one Server (A) ER ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 07:49 AM
Heinz Weitkamp
 
Posts: n/a
Default Problem with ER




Hi all,

IDS 7.31.UD4; SCO 3.2 5.0.6

7 Server with update everywhere in ER.

On one Server (A) ER hangs. The other Server can't replicate Data to the
Server (A).
Server (A) does't replicate Data to the other Server.

"cdr disconnect serv serverxyz" on server (A) doesn't come back. (the
command hangs)

onstat-output of Server (A):

onstat -g ath|grep mutex

2264 26d575b0 2aa1b0c8 2 mutex wait DTCLog 1cpu CDRD_0
2426 26dfe410 2aa18e00 2 mutex wait DTCLog 1cpu CDRD_1
123846 26e16130 26c652f8 2 mutex wait DTCLog 1cpu CDRNsT2
123866 26e2f180 2aa236f0 2 mutex wait DTCLog 1cpu CDRNsA13
170060 2e970f78 2c215c50 2 mutex wait DTCLog 1cpu CDRNsA21
280760 26f0f070 307adbb8 2 mutex wait DTCLog 1cpu CDRNsA22
280775 2e970448 2aa245d8 2 mutex wait DTCLog 1cpu CDRNsA1
330226 26ea6888 26c675c0 2 mutex wait DTCLog 1cpu CDRNsA5
334552 26e8ebf0 2c232078 2 mutex wait DTCLog 1cpu CDRNsA3
334556 2b12dcc0 307ac7d8 2 mutex wait DTCLog 1cpu CDRNsA23
335755 26f1a130 2aa34340 2 mutex wait DTCLog 1cpu CDRNsA20
345457 26f1e908 26c6c540 2 mutex wait DTCLog 1cpu CDRNsA10
----------------------------------------------------------------------------
----

onstat -g wmx

Informix Dynamic Server Version 7.31.UD4 -- On-Line -- Up 86 days
20:31:01 -
- 598016 Kbytes

Mutexes with waiters:
mid addr name holder lkcnt waiter waittime
274010 2915c298 DTCLog 2243 0 2264 8390
123866 678233
335755 -1
280775 678233
123846 678233
334552 -1
330226 -1
345457 -1
170060 678233
280760 678233
334556 -1
2426 7670

----------------------------------------------------------------------------
-----
onstat -g lmx|more

Informix Dynamic Server Version 7.31.UD4 -- On-Line -- Up 86 days
20:31:44 -
- 598016 Kbytes

Locked mutexes:
mid addr name holder lkcnt waiter waittime
274010 2915c298 DTCLog 2243 0 2264 8432
123866 678275
335755 -1
280775 678275
123846 678275
334552 -1
330226 -1
345457 -1
170060 678275
280760 678275
334556 -1
2426 7712
----------------------------------------------------------------------------
----

The holder-thread is:

onstat -g ath|grep 2243

2243 26f17478 2aa12aa0 1 ready 1cpu
CDRDTCleaner

----------------------------------------------------------------------------
------

What can i do to solve this problem?
How can i activate ER without booting the Server (A)?
Do you need more Information?

(excuse my poor school-english)
thanks in advance

Heinz

sending to informix-list
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-20-2008, 07:50 AM
mpruet
 
Posts: n/a
Default Re: Problem with ER

Heinz,

You are seeing Bug 144544.

Please contact tech support on this problem.


"Heinz Weitkamp" <heinz.weitkamp@westfleisch.de> wrote in message news:<cjukts$n7q$1@news.xmission.com>...
> Hi all,
>
> IDS 7.31.UD4; SCO 3.2 5.0.6
>
> 7 Server with update everywhere in ER.
>
> On one Server (A) ER hangs. The other Server can't replicate Data to the
> Server (A).
> Server (A) does't replicate Data to the other Server.
>
> "cdr disconnect serv serverxyz" on server (A) doesn't come back. (the
> command hangs)
>
> onstat-output of Server (A):
>
> onstat -g ath|grep mutex
>
> 2264 26d575b0 2aa1b0c8 2 mutex wait DTCLog 1cpu CDRD_0
> 2426 26dfe410 2aa18e00 2 mutex wait DTCLog 1cpu CDRD_1
> 123846 26e16130 26c652f8 2 mutex wait DTCLog 1cpu CDRNsT2
> 123866 26e2f180 2aa236f0 2 mutex wait DTCLog 1cpu CDRNsA13
> 170060 2e970f78 2c215c50 2 mutex wait DTCLog 1cpu CDRNsA21
> 280760 26f0f070 307adbb8 2 mutex wait DTCLog 1cpu CDRNsA22
> 280775 2e970448 2aa245d8 2 mutex wait DTCLog 1cpu CDRNsA1
> 330226 26ea6888 26c675c0 2 mutex wait DTCLog 1cpu CDRNsA5
> 334552 26e8ebf0 2c232078 2 mutex wait DTCLog 1cpu CDRNsA3
> 334556 2b12dcc0 307ac7d8 2 mutex wait DTCLog 1cpu CDRNsA23
> 335755 26f1a130 2aa34340 2 mutex wait DTCLog 1cpu CDRNsA20
> 345457 26f1e908 26c6c540 2 mutex wait DTCLog 1cpu CDRNsA10
> ----------------------------------------------------------------------------
> ----
>
> onstat -g wmx
>
> Informix Dynamic Server Version 7.31.UD4 -- On-Line -- Up 86 days
> 20:31:01 -
> - 598016 Kbytes
>
> Mutexes with waiters:
> mid addr name holder lkcnt waiter waittime
> 274010 2915c298 DTCLog 2243 0 2264 8390
> 123866 678233
> 335755 -1
> 280775 678233
> 123846 678233
> 334552 -1
> 330226 -1
> 345457 -1
> 170060 678233
> 280760 678233
> 334556 -1
> 2426 7670
>
> ----------------------------------------------------------------------------
> -----
> onstat -g lmx|more
>
> Informix Dynamic Server Version 7.31.UD4 -- On-Line -- Up 86 days
> 20:31:44 -
> - 598016 Kbytes
>
> Locked mutexes:
> mid addr name holder lkcnt waiter waittime
> 274010 2915c298 DTCLog 2243 0 2264 8432
> 123866 678275
> 335755 -1
> 280775 678275
> 123846 678275
> 334552 -1
> 330226 -1
> 345457 -1
> 170060 678275
> 280760 678275
> 334556 -1
> 2426 7712
> ----------------------------------------------------------------------------
> ----
>
> The holder-thread is:
>
> onstat -g ath|grep 2243
>
> 2243 26f17478 2aa12aa0 1 ready 1cpu
> CDRDTCleaner
>
> ----------------------------------------------------------------------------
> ------
>
> What can i do to solve this problem?
> How can i activate ER without booting the Server (A)?
> Do you need more Information?
>
> (excuse my poor school-english)
> thanks in advance
>
> Heinz
>
> sending to informix-list

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:07 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com