Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 09 Jul 2009 @ 21:19:02 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Backup Error: RDBMS CRASHED OR SESSIONS RESET
 
From:   Jha, Ayush

Greetings,

For a couple of days our backup script is failing. The below is the error in the log file:

     07/08/2009 23:46:17  TABLE "dCustomerAddress2" -   5,268,800 BYTES,  10,304
                          ROWS ARCHIVED
     07/09/2009 00:03:27  RDBMS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS
     ----------------------------------------------------------------
     Execution traceback not available on this platform.
     ----------------------------------------------------------------
     07/09/2009 00:04:34  UTILITY EVENT NUMBER  - 299
     07/09/2009 00:04:34  RESTART COMPLETED
     07/09/2009 05:44:02  *** Failure 8018:The session id is illegal.
     07/09/2009 05:45:05  LOGGED OFF   6 SESSIONS
     07/09/2009 05:45:05  ARCMAIN TERMINATED WITH SEVERITY 12

The change we did was to move the box having the database to a different physical location, everything else being the same.

Can anyone suggest what to do? I don t see my database crashing and I am not sure about session id issue. Also, for two days the daily ETL is stuck, and doesn t complete until and unless I release the lock manually. Can it be because of this?


Thanks

Ayush



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023