Yup exactly, we noticed the same thing. DB ran out of temp space and ultimately crashed. What are your recommendations, how can we avoid this in future?
On Mar 30, 11:47 am, "Shellman, David" <[email protected]> wrote: > Been there. Done that. In my case, we ran up against not enough temp space > and froze the system. > > Dave > > > > > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Raj > Sent: Friday, March 30, 2012 2:36 PM > To: [email protected] > Subject: Re: Can remedy code push cause DB crash, etc? > > Typo ; > DB Version : 10.2.0.5.0 - 64bi > > On Mar 30, 11:33 am, Raj <[email protected]> wrote: > > Sorry, missed the environment info: > > > Server : 5.01.02 Patch 1313 > > Hardware : sun4u > > OS: SunOS 5.10 > > DB: SQL -- Oracle > > DB Version : 0.2.0.5.0 - 64bi > > > On Mar 30, 11:30 am, Raj <[email protected]> wrote: > > > > Hi All, > > > > Very recently I performed Remedy code push on our production server. > > > > This involved importing some new forms and related workflow and also > > > modifying existing forms like HelpDesk and Change forms.(Using > > > ARAdmin > > > tool) > > > > I tested this same on our Dev and QA Servers and the code push was a > > > success without any issues. > > > > But when I performed this on our Production server, it caused DB > > > crash and brought down Remedy. > > > > The outage was caused by the fact that the database became > > > unresponsive. > > > > After we brought back Remedy, we noticed some of the DB view needed > > > to be recompiled. > > > > As we are still investigating if it has to do with issues in non > > > remedy components but we couldn't find any solid clues and > > > ultimately brings it back to Remedy code push. > > > > Here are the logs : > > > > ------------------------------ > > > > Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server > > > terminated when a signal was received by the server (ARDSNOTE 3000) > > > Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:09:59 2012 Distrib : AR > > > System Distributed Server terminated when a signal was received by > > > the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 > > > 01:11:23 2012 390600 : Requested database table not found. > > > Please check the spelling (table name is case-sensitive) (ARERR 481) > > > Wed Mar 28 01:29:29 2012 390620 : Failure while trying to connect to > > > the SQL database. > > > Please ensure the SQL database is running or contact the Database > > > Administrator for help (ARERR 550) Wed Mar 28 01:29:29 2012 > > > ORA-12535: TNS:operation timed out Wed Mar 28 01:29:29 2012 390620 : > > > Cannot initialize contact with SQL database (ARERR 551) Wed Mar 28 > > > 01:29:29 2012 Thread 67 not handling connection > > > > ------------------------------- > > > > At this point, I would like to understand from experts in here to > > > see if anything like the above mentioned is possible? If yes, what > > > could be the reasons and what can I look into to find the root cause. > > > > Thanks, > > > > Raj > > > > ____________________________________________________________________ > > > ___________ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > attend wwrug12www.wwrug12.comARSList:"Where the Answers Are" > > > ______________________________________________________________________ > > _________ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug12www.wwrug12.comARSList:"Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgattend > wwrug12www.wwrug12.comARSList: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug12www.wwrug12.comARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
