Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 08 Jun 2001 @ 15:53:40 GMT


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


Subj:   Re: Multiload Errors on V2R4.0.1
 
From:   Carmen Hofmann

Thanks so far!

I do not know if 10k rows is really the limit - we just tried several input files (small ones and big ones) and found that the multiload crashes after having applied between 12k and 25k rows.

To make it clearer, here is a log file. It shows the multiload re-starting automatically three times and three times crashing with the same error (after 15525 rows, after 0 rows and after 17647 rows) :-(

 -----------------------------------------------------------------------
 -
 -     MultiLoad Acquisition Phase
 -
 -----------------------------------------------------------------------
**** 15:13:13 UTY0817 MultiLoad submitting the following request:
     BEGIN TRANSACTION;
**** 15:13:13 UTY0817 MultiLoad submitting the following request:
     CHECKPOINT LOADING;
**** 15:17:06 UTY0806 RDBMS error, 2825: NO RECORD OF THE LAST REQUEST WAS FOUND AFTER DBC      RESTART
**** 15:17:06 UTY1803 Import processing statistics
     .                                       IMPORT  1     Total thus far
     .                                       ---------     --------------
     Candidate records considered:........       15525.......       15525
     Apply conditions satisfied:..........       15525.......       15525
     Candidate records not applied:.......           0.......           0
     Candidate records rejected:..........           0.......           0
**** 15:17:06 UTY1804 Re-starting this MultiLoad task because the RDBMS crashed.

 -----------------------------------------------------------------------
 -
 -     MultiLoad Initial Phase
 -
 -----------------------------------------------------------------------
**** 15:17:06 UTY0829 Options in effect for this MultiLoad import task:
     .       Sessions:    8 session(s).
     .       Checkpoint:  1000000 records.
     .       Tenacity:    4 hour limit to successfully connect load sessions.
     .       Errlimit:    1000 rejected record(s).
     .       AmpCheck:    In effect for apply phase transitions.
**** 15:26:50 UTY0817 MultiLoad submitting the following request:
     Select NULL from trans_akba.LOG_raw_server_log where (LogType = 125) and
     (Seq = 1) and (MloadSeq = 0);
**** 15:26:50 UTY0817 MultiLoad submitting the following request:
     Select NULL from trans_akba.LOG_raw_server_log where (LogType = 120) and
     (Seq = 1);
**** 15:26:51 UTY0812 MLOAD session(s) requested: 8.
**** 15:26:51 UTY0815 MLOAD session(s) connected: 8.
**** 15:26:51 UTY0817 MultiLoad submitting the following request:
     BEGIN MLOAD trans_akba.raw_server_log;

 -----------------------------------------------------------------------
 -
 -     MultiLoad Acquisition Phase
 -
 -----------------------------------------------------------------------
**** 15:26:51 UTY0817 MultiLoad submitting the following request:
     SELECT MiscInt1 (INTEGER), MiscInt2 (INTEGER),MiscInt3 (INTEGER), MiscInt4
     (INTEGER), MiscInt5 (INTEGER),MiscInt6 (INTEGER), MiscInt7 (INTEGER),
     MiscInt8 (INTEGER),MloadSeq (INTEGER), MloadImpSeq (INTEGER),MloadSrcSeq
     (INTEGER), MloadCkpt (VARBYTE(1024)) from trans_akba.LOG_raw_server_log
     WHERE (LogType = 110) and (Seq = 1) and (MloadSeq IN (SELECT MAX (MloadSeq)
     from trans_akba.LOG_raw_server_log where (LogType = 110) and (Seq = 1)));
**** 15:26:51 UTY0817 MultiLoad submitting the following request:
     BEGIN TRANSACTION;
**** 15:26:51 UTY0817 MultiLoad submitting the following request:
     CHECKPOINT LOADING;
**** 15:30:24 UTY0806 RDBMS error, 2825: NO RECORD OF THE LAST REQUEST WAS FOUND AFTER DBC
     RESTART
**** 15:30:24 UTY1804 Re-starting this MultiLoad task because the RDBMS crashed.

 -----------------------------------------------------------------------
 -
 -     MultiLoad Initial Phase
 -
 -----------------------------------------------------------------------
**** 15:30:24 UTY0829 Options in effect for this MultiLoad import task:
     .       Sessions:    8 session(s).
     .       Checkpoint:  1000000 records.
     .       Tenacity:    4 hour limit to successfully connect load sessions.
     .       Errlimit:    1000 rejected record(s).
     .       AmpCheck:    In effect for apply phase transitions.
**** 15:30:26 UTY0817 MultiLoad submitting the following request:
     Select NULL from trans_akba.LOG_raw_server_log where (LogType = 125) and
     (Seq = 1) and (MloadSeq = 0);
**** 15:30:26 UTY0817 MultiLoad submitting the following request:
     Select NULL from trans_akba.LOG_raw_server_log where (LogType = 120) and
     (Seq = 1);
**** 15:30:27 UTY0812 MLOAD session(s) requested: 8.
**** 15:30:27 UTY0815 MLOAD session(s) connected: 8.
**** 15:30:27 UTY0817 MultiLoad submitting the following request:
     BEGIN MLOAD trans_akba.raw_server_log;

 -----------------------------------------------------------------------
 -
 -     MultiLoad Acquisition Phase
 -
 -----------------------------------------------------------------------
**** 15:30:27 UTY0817 MultiLoad submitting the following request:
     SELECT MiscInt1 (INTEGER), MiscInt2 (INTEGER),MiscInt3 (INTEGER), MiscInt4
     (INTEGER), MiscInt5 (INTEGER),MiscInt6 (INTEGER), MiscInt7 (INTEGER),
     MiscInt8 (INTEGER),MloadSeq (INTEGER), MloadImpSeq (INTEGER),MloadSrcSeq
     (INTEGER), MloadCkpt (VARBYTE(1024)) from trans_akba.LOG_raw_server_log
     WHERE (LogType = 110) and (Seq = 1) and (MloadSeq IN (SELECT MAX (MloadSeq)
     from trans_akba.LOG_raw_server_log where (LogType = 110) and (Seq = 1)));
**** 15:30:28 UTY0817 MultiLoad submitting the following request:
     BEGIN TRANSACTION;
**** 15:30:28 UTY0817 MultiLoad submitting the following request:
     CHECKPOINT LOADING;
**** 15:33:59 UTY0806 RDBMS error, 2825: NO RECORD OF THE LAST REQUEST WAS FOUND AFTER DBC
     RESTART
**** 15:33:59 UTY1803 Import processing statistics
     .                                       IMPORT  1     Total thus far
     .                                       ---------     --------------
     Candidate records considered:........       17647.......       17647
     Apply conditions satisfied:..........       17647.......       17647
     Candidate records not applied:.......           0.......           0
     Candidate records rejected:..........           0.......           0
**** 15:33:59 UTY1804 Re-starting this MultiLoad task because the RDBMS crashed.

 -----------------------------------------------------------------------
 -
 -     MultiLoad Initial Phase
 -
 -----------------------------------------------------------------------


     
  <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: 27 Dec 2016