 |
 |
Archives of the TeradataForum
Message Posted: Fri, 08 Jun 2001 @ 15:53:40 GMT
| 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
-
-----------------------------------------------------------------------
| |
