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 <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 <process id> to tell the number of open files used by the process. >>> Thanks Sean, will try this out. currently ulimit says : XXXXXXXXXXXXXX $ 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'. 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 <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" __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" ----------------------------------------- ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ********************************************************************** Wal-Mart Confidential ********************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"