RES: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)

2008-04-11 Thread Tadeu Augusto Dutra Pinto 
That's it Darrel..
 
I forgot to say...
 
After you truncate your table  enable an escalation to delete records from 
this table ... one escalation that clear all records that are more than one 
week on databse, for example...
 
Att,
 
 
 
 
Tadeu Augusto Dutra Pinto
-
IT Web Services ATM 
Cinq Technologies
http://www.cinq.com.br 
<https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/> 
 
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 
Fone: 41 3018-2833 - Cinq
-
Confiabilidade, Inovação e Qualidade em T.I.



De: Action Request System discussion list(ARSList) em nome de Darrell Reading
Enviada: sex 11/4/2008 18:37
Para: arslist@ARSLIST.ORG
Assunto: Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)



We set up an escalation that deletes old tickets.  We only keep 2 to 10 
thousand records in there at any given time depending on how many transactions 
we have that day.  I can't imagine having that many rows in that form. :S


Darrell Reading Systems Engineer
Phone 479.204.5739
[EMAIL PROTECTED]

Wal-Mart Stores, Inc.
805 Moberly Lane, MS-0560-68
Bentonville, AR 72716
Save Money. Live Better

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Tadeu Augusto Dutra Pinto
Sent: Friday, April 11, 2008 16:24
To: arslist@ARSLIST.ORG
Subject: RES: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)

Jorge...

I think that 2,063,253 of records is really a lot of rows in the table AR 
System Email Messages...

Recently, these week, we had problems with server crash ... and we've noticed 
that sql statements in this table were contributing for crash in our server ... 
and our AR System Email Messages table had "only" one million records... rs

I advise you to truncate your table to clear it ...
do something like these:
TUNCATE TABLE T99
TUNCATE TABLE B99
TUNCATE TABLE H99

Assuming that your table id is 99..

I hope that help you..

thanks ... have a nice weekend...
and drink Beer!!!


Tadeu Augusto Dutra Pinto
-
IT Web Services ATM
Cinq Technologies
http://www.cinq.com.br <http://www.cinq.com.br/>  
<https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/> 
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Fone: 41 3018-2833 - Cinq
-
Confiabilidade, Inovação e Qualidade em T.I.




De: Action Request System discussion list(ARSList) em nome de George Jungle
Enviada: sex 11/4/2008 00:59
Para: arslist@ARSLIST.ORG
Assunto: Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)


**
Thanks for all the replies guys. I've answered some of your questions



1. Gary Opela (Corporate)" <[EMAIL PROTECTED]>
Is your database local or remote?
>>> Local

2. Garrison, Sean (Norcross)" <[EMAIL PROTECTED]> 
If you are on a unix server check the number of open files being used by the 
process.  Maybe it has hit the max and locked up your server (why you aren't 
seeing anything in the logs). 
type in "ulimit -a" to tell you the limits you have
pfiles  to tell the number of open files used by the process.
>>> Thanks Sean, will try this out. currently ulimit says :
XX $ ulimit -a
core file size(blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
open files(-n) 256
pipe size  (512 bytes, -p) 10
stack size(kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes(-u) 29995
virtual memory(kbytes, -v) unlimited

3. Roger Medsker <[EMAIL PROTECTED]>
I have seen this behavior in a situation we had where  AR System was actually 
restarting. There is no indication in any of the logs that the server crashed 
or was manually stopped. You can detect this by having server side SQL logging 
on when this occurs. If you see lots of SQL transactions with no identified 
user associated to them, then the server process is starting up.  This doesn't 
help identify the root cause but the question changes from "Why does the server 
'hang'?" to "Why is the server restarting?"

>>> Ok. Thanks Roger. will give that a go next time it hangs... only prob is 
>>> it's intermittent and we really can't have SQL logging on all the time 
>>> will figure something out.

4. Tadeu Augusto Dutra Pinto <[EMAIL PROTECTED]> 
one question
how many records does your AR System Email Messages has???

>>> 2,06

RES: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)

2008-04-11 Thread Tadeu Augusto Dutra Pinto 
Jorge...
 
I think that 2,063,253 of records is really a lot of rows in the table AR 
System Email Messages...
 
Recently, these week, we had problems with server crash ... and we've noticed 
that sql statements in this table were contributing for crash in our server ... 
and our AR System Email Messages table had "only" one million records... rs
 
I advise you to truncate your table to clear it ...
do something like these:
TUNCATE TABLE T99
TUNCATE TABLE B99
TUNCATE TABLE H99
 
Assuming that your table id is 99..
 
I hope that help you..
 
thanks ... have a nice weekend...
and drink Beer!!!
 
 
Tadeu Augusto Dutra Pinto
-
IT Web Services ATM 
Cinq Technologies
http://www.cinq.com.br 
 
 
[EMAIL PROTECTED]  
Fone: 41 3018-2833 - Cinq
-
Confiabilidade, Inovação e Qualidade em T.I.

 


De: Action Request System discussion list(ARSList) em nome de George Jungle
Enviada: sex 11/4/2008 00:59
Para: arslist@ARSLIST.ORG
Assunto: Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)


** 
Thanks for all the replies guys. I've answered some of your questions
 
 

1. Gary Opela (Corporate)" <[EMAIL PROTECTED]>
Is your database local or remote? 
>>> Local

2. Garrison, Sean (Norcross)" <[EMAIL PROTECTED]>  
If you are on a unix server check the number of open files being used by the 
process.  Maybe it has hit the max and locked up your server (why you aren't 
seeing anything in the logs).  
type in "ulimit -a" to tell you the limits you have
pfiles  to tell the number of open files used by the process.
>>> Thanks Sean, will try this out. currently ulimit says :
XX $ ulimit -a
core file size(blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
open files(-n) 256
pipe size  (512 bytes, -p) 10
stack size(kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes(-u) 29995
virtual memory(kbytes, -v) unlimited

3. Roger Medsker <[EMAIL PROTECTED]>
I have seen this behavior in a situation we had where  AR System was actually 
restarting. There is no indication in any of the logs that the server crashed 
or was manually stopped. You can detect this by having server side SQL logging 
on when this occurs. If you see lots of SQL transactions with no identified 
user associated to them, then the server process is starting up.  This doesn't 
help identify the root cause but the question changes from "Why does the server 
'hang'?" to "Why is the server restarting?"

>>> Ok. Thanks Roger. will give that a go next time it hangs... only prob is 
>>> it's intermittent and we really can't have SQL logging on all the time 
>>> will figure something out.
 
4. Tadeu Augusto Dutra Pinto <[EMAIL PROTECTED]>  
one question
how many records does your AR System Email Messages has??? 

>>> 2,063,253 records... Delete Outgoing Messages is set to "No". Will have to 
>>> get that changed! Does this sound like a lot of rows to you?


 

 
George


 
On 4/11/08, Tadeu Augusto Dutra Pinto <[EMAIL PROTECTED]> wrote: 

one question

how many records does your AR System Email Messages has???



De: Action Request System discussion list(ARSList) em nome de Roger 
Medsker
Enviada: qui 10/4/2008 11:45
Para: arslist@ARSLIST.ORG
Assunto: Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)


**

George,



I have seen this behavior in a situation we had where  AR System was 
actually restarting. There is no indication in any of the logs that the server 
crashed or was manually stopped. You can detect this by having server side SQL 
logging on when this occurs. If you see lots of SQL transactions with no 
identified user associated to them, then the server process is starting up.  
This doesn't help identify the root cause but the question changes from "Why 
does the server 'hang'?" to "Why is the server restarting?"



HTH



Roger



From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
PROTECTED] On Behalf Of George Jungle
Sent: Thursday, April 10, 2008 2:45 AM
To: arslist@ARSLIST.ORG
Subject: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)



**



Hey guys,



We're getting a strange issue (seemingly intermittent) with the 
arserverd where it just seems to 'hang'.

RES: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)

2008-04-10 Thread Tadeu Augusto Dutra Pinto 
one question
 
how many records does your AR System Email Messages has???



De: Action Request System discussion list(ARSList) em nome de Roger Medsker
Enviada: qui 10/4/2008 11:45
Para: arslist@ARSLIST.ORG
Assunto: Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)


** 

George,

 

I have seen this behavior in a situation we had where  AR System was actually 
restarting. There is no indication in any of the logs that the server crashed 
or was manually stopped. You can detect this by having server side SQL logging 
on when this occurs. If you see lots of SQL transactions with no identified 
user associated to them, then the server process is starting up.  This doesn't 
help identify the root cause but the question changes from "Why does the server 
'hang'?" to "Why is the server restarting?"

 

HTH

 

Roger

 

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of George Jungle
Sent: Thursday, April 10, 2008 2:45 AM
To: arslist@ARSLIST.ORG
Subject: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)

 

** 

 

Hey guys,

 

We're getting a strange issue (seemingly intermittent) with the arserverd where 
it just seems to 'hang'.

 

All existing and new clients receive a "TimeOut" error, but yet when you check :

-the processes at the o/s 

-the error logs

-db sessions

 

there is no evidence that there is an issue.   (i.e. all processes running, you 
get timeouts appearing due to Brie / SLM engine not being able to connect and 
db sessions are not 'locked' or taking an extensive amount of time to process). 

 

It seems that the only way to fix this is to do a restart of the AR Server. 

 

I was just wondering if anyone else has experienced anything remotely similar 
to this?

 

 

Thanks.

George

 

(AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"