Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 29 Jul 2005 @ 08:15:48 GMT


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


Subj:   Re: Time out Waiting for Lock on UV Table.
 
From:   Victor Sokovin

  I was trying to mload a file to a table .The file had around 184 million records.  


  The session failed giving me the following error:  


  RDBMS failure, 2575:  


  Timed out waiting for lock on <databasename>.<UV_tablename> ( eg. production.UV_fact_table_)  


  Can anyone suggest why the there was a session timeout for acqiuring the lock on the UV table , although there were no simultaneous processes going on and hence no issue of any contention.  


The system might have been busy with something else at that time and could not process this request within the maximum waiting time period.

Did this happen when you were trying to restart the ML process? If so, then it is possible that the previous ML job's lock on the UV table was somehow still in place. Your DBA should be able to advise on such ghost locks and help you get rid of them.

If it is just a development database and you don't want to bother DBAs with this, then you might try the brute force approach: release ML lock, drop all the temp tables, backup the target table, drop it and recreate from the backup. You might need to do something with the data as well if you don't like the partial load from the failed ML session. This should normally give you a chance to repeat the load.


Regards,

Victor



     
  <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: 23 Jun 2019