Get Data Moving 1
Results 1 to 4 of 4

Thread: Error when replicating MySQL to MapR-FS

  1. #1
    olivier is offline Junior Member
    Join Date
    Jun 2016
    Posts
    2
    Rep Power
    0

    Error when replicating MySQL to MapR-FS

    Hello,

    I'm trying to replicate a table from a MySQL Server v5.7 to MapR v5.1 HttpFS andWebHCat.
    I can configure Attunity Express but it fails during a full load of the table, as if it couldn't write the CSV file to HDFS.
    Below are Attunity Express and HttpFS log files.

    Attunity Task ServerLog:
    Code:
    00001928:2016-06-06T15:05:44 [SERVER         ]I:  Task Server Log - MySQL toHDFS (V4.0.9.71 038-PC Microsoft Windows 64-bit, PID: 7440) started at Mon Jun06 15:05:44 2016  (logger.c:448)
    00001928:2016-06-06T15:05:44 [SERVER         ]I:  Licensed to AttunityReplicate Express users (software license acceptance implied)Express license:You are running the Express Edition with reduced functionality (164 daysremaining)  (logger.c:451)
    00001928:2016-06-06T15:05:44 [SERVER         ]I:  Client session (ID 30674)allocated  (dispatcher.c:240)
    00001928:2016-06-06T15:05:44 [TASK_MANAGER   ]I:  Task 'MySQL to HDFS' runningfull load and CDC in fresh start mode (replicationtask.c:805)
    00001928:2016-06-06T15:05:44 [METADATA_MANAGER]I: ODBC additional properties = 'driver=MYSQL ODBC 5.3 Unicode Driver'  (mysql_endpoint_imp.c:569)
    00001928:2016-06-06T15:05:44 [METADATA_MANAGER]I: Connecting to MySQL through ODBC connection string: DRIVER={MySQL ODBC5.2 UnicodeDriver};SERVER=localhost;port=3306;UID=cdc;PWD=****;DB=;Option=74448896;driver=MYSQLODBC 5.3 Unicode Driver (mysql_endpoint_imp.c:653)
    00001928:2016-06-06T15:05:45 [METADATA_MANAGER]I: Hadoop version is '2.7.0-mapr-1602' (hadoop_imp.c:728)
    00001928:2016-06-06T15:05:45 [METADATA_MANAGER]I: Hive version 1.2.0-mapr-1603 (hadoop_imp.c:642)
    00007172:2016-06-06T15:05:45 [TASK_MANAGER   ]I:  Creating threads for allcomponents  (replicationtask.c:1279)
    00007172:2016-06-06T15:05:45 [TASK_MANAGER   ]I:  Threads for all componentswere created  (replicationtask.c:1425)
    00007172:2016-06-06T15:05:45 [TASK_MANAGER   ]I:  Task initialization completedsuccessfully  (replicationtask.c:2265)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  ODBC additional properties ='driver=MYSQL ODBC 5.3 Unicode Driver' (mysql_endpoint_imp.c:569)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  Connecting to MySQL throughODBC connection string: DRIVER={MySQL ODBC 5.2 UnicodeDriver};SERVER=localhost;port=3306;UID=cdc;PWD=****;DB=;Option=74448896;driver=MYSQLODBC 5.3 Unicode Driver (mysql_endpoint_imp.c:653)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  System var 'log_bin' ='ON'  (mysql_endpoint_capture.c:259)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  System var 'binlog_format' ='ROW'  (mysql_endpoint_capture.c:259)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  System var 'server_id' ='1'  (mysql_endpoint_capture.c:259)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  System var 'binlog_row_image'= 'FULL'  (mysql_endpoint_capture.c:259)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  System var 'binlog_checksum'= 'NONE'  (mysql_endpoint_capture.c:259)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  System var'lower_case_table_names' = '0' (mysql_endpoint_capture.c:259)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  System var'lower_case_file_system' = 'OFF' (mysql_endpoint_capture.c:259)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  System var'log_bin_use_v1_row_events' = 'OFF' (mysql_endpoint_capture.c:259)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  System var 'sql_mode' ='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'  (mysql_endpoint_capture.c:259)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  System var'binlog_row_event_max_size' = '' (mysql_endpoint_capture.c:259)
    00004656:2016-06-06T15:05:45 [STREAM_COMPONENT]I: Force switch to transactional apply mode for Hadoop target  (endpointshell.c:805)
    00004656:2016-06-06T15:05:45 [TARGET_APPLY   ]I:  Working in transactionalapply mode  (endpointshell.c:877)
    00004656:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  ODBC additional properties ='driver=MYSQL ODBC 5.3 Unicode Driver' (mysql_endpoint_imp.c:569)
    00004656:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  Connecting to MySQL throughODBC connection string: DRIVER={MySQL ODBC 5.2 UnicodeDriver};SERVER=localhost;port=3306;UID=cdc;PWD=****;DB=;Option=74448896;driver=MYSQLODBC 5.3 Unicode Driver (mysql_endpoint_imp.c:653)
    00007172:2016-06-06T15:05:45 [TASK_MANAGER   ]I:  All stream components wereinitialized  (replicationtask.c:2110)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  No context received - assumeNOW  (mysql_endpoint_capture.c:99)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  Poll binary log every 5seconds  (mysql_endpoint_capture.c:3269)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  Server version number =5007012  (mysql_endpoint_capture.c:427)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  System var 'server_id' ='1'  (mysql_endpoint_capture.c:259)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  System var'lower_case_table_names' = '0' (mysql_endpoint_capture.c:259)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  Set position to initialcontext 'now' (mysql_endpoint_capture.c:2798)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  Setting position in binlog'mysql-bin.000005' at 150 (mysql_endpoint_capture.c:744)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  Position was set in binlog'mysql-bin.000005' at 150 (mysql_endpoint_capture.c:771)
    00010432:2016-06-06T15:05:45 [SOURCE_CAPTURE ]I:  Stream positioning requestedby 'NOW' - located position is at timestamp 'now'  (mysql_endpoint_capture.c:2756)
    00006868:2016-06-06T15:05:45 [SORTER         ]I:  Transaction consistencyreached  (sorter_transaction.c:227)
    00007172:2016-06-06T15:05:45 [TASK_MANAGER   ]I:  Starting replication now  (replicationtask.c:1862)
    00007172:2016-06-06T15:05:45 [TASK_MANAGER   ]I:  Starting subtask #1  (replicationtask_util.c:862)
    00002076:2016-06-06T15:05:45 [SOURCE_UNLOAD  ]I:  ODBC additional properties ='driver=MYSQL ODBC 5.3 Unicode Driver' (mysql_endpoint_imp.c:569)
    00002076:2016-06-06T15:05:45 [SOURCE_UNLOAD  ]I:  Connecting to MySQL throughODBC connection string: DRIVER={MySQL ODBC 5.2 UnicodeDriver};SERVER=localhost;port=3306;UID=cdc;PWD=****;DB=;Option=74448896;driver=MYSQLODBC 5.3 Unicode Driver (mysql_endpoint_imp.c:653)
    00008932:2016-06-06T15:05:46 [SOURCE_CAPTURE ]I:  ODBC additional properties ='driver=MYSQL ODBC 5.3 Unicode Driver' (mysql_endpoint_imp.c:569)
    00008932:2016-06-06T15:05:46 [SOURCE_CAPTURE ]I:  Connecting to MySQL throughODBC connection string: DRIVER={MySQL ODBC 5.2 UnicodeDriver};SERVER=localhost;port=3306;UID=cdc;PWD=****;DB=;Option=74448896;driver=MYSQLODBC 5.3 Unicode Driver (mysql_endpoint_imp.c:653)
    00006868:2016-06-06T15:05:46 [SORTER         ]I:  Start collecting changes fortable id = 1  (sorter_transaction.c:1643)
    00007172:2016-06-06T15:05:46 [TASK_MANAGER   ]I:  Start loading table'mysrc'.'mytable' (Id = 1) by subtask 1. Start load timestamp 0005349BBAFBE663  (replicationtask_util.c:1028)
    00002076:2016-06-06T15:05:46 [METADATA_MANAGER]E: Metadata Manager table definition cannot be found. Table ID: 1.Component ID: mysql [120416] Failed to get a table definition.(metadatamanager.c:1121)
    00002076:2016-06-06T15:05:46 [SOURCE_UNLOAD  ]I: mysql_endpoint_get_table_def_imp mytable (mysql_endpoint_metadata.c:376)
    00002076:2016-06-06T15:05:46 [SOURCE_UNLOAD  ]I:  Enteringmysql_unload_source_loop (mysql_endpoint_unload.c:440)
    00002076:2016-06-06T15:05:46 [SOURCE_UNLOAD  ]I:  'ResumeFetchForXRows'property is set for 1500000000 rows (mysql_endpoint_unload.c:239)
    00002076:2016-06-06T15:05:46 [SOURCE_UNLOAD  ]I:  Unload finished for table'mysrc'.'mytable' (Id = 1). 4 rows sent. (streamcomponent.c:2561)
    00008932:2016-06-06T15:06:25 [TARGET_LOAD    ]I:  Load finished for table'mysrc'.'mytable' (Id = 1). 4 rows received. 0 rows skipped. Volume transfered1280  (streamcomponent.c:2781)
    00008932:2016-06-06T15:07:05 [INFRASTRUCTURE ]E:  HDFF-E-ERRWRITE, Errorwriting file </user/mapr/cdc2/mytable/20160606-1306258072.csv>
     -WHD-E-CREATF, Create file failed: Serverreturned nothing (no headers, no data) Base general error.(at_universal_fs_object.c:1353)
    00008932:2016-06-06T15:07:25 [TARGET_LOAD    ]E:  Failed to load file'C:\Program Files\Attunity\Replicate\data\tasks\MySQL toHDFS\data_files\1\20160606-1306258072.csv' Base general error.(hadoop_utils.c:500)
    00007172:2016-06-06T15:07:25 [TASK_MANAGER   ]W:  Table 'mysrc'.'mytable'(subtask 1 thread 1) is suspended. (replicationtask.c:1666)
    00008932:2016-06-06T15:07:25 [TARGET_LOAD    ]E:  Failed to load file '1' Basegeneral error. (hadoop_load.c:745)
    00008932:2016-06-06T15:07:25 [TARGET_LOAD    ]E:  Handling End of table'mysrc'.'mytable' loading failed by subtask 1 thread 1 Base general error.(endpointshell.c:1364)
    00007172:2016-06-06T15:07:26 [TASK_MANAGER   ]I:  Subtask #1 ended  (replicationtask_util.c:925)
    MapR HttpFS'saudit.log:
    Code:
    2016-06-0606:05:45,994  INFO [][mapr:]GETFILESTATUS [/]
    2016-06-0606:05:46,029  INFO [][mapr:]GETHOMEDIRECTORY
    2016-06-0606:05:46,482  INFO [][mapr:]GETFILESTATUS [/]
    2016-06-0606:05:46,508  INFO [][mapr:]GETHOMEDIRECTORY
    2016-06-0606:05:46,900  INFO [][mapr:]GETFILESTATUS [/]
    2016-06-0606:05:46,998  INFO [][mapr:]GETHOMEDIRECTORY
    2016-06-0606:06:05,690  INFO [][mapr:] DELETE[/user/mapr/cdc2/mytable] recursive [true]
    2016-06-0606:06:26,724  INFO [][mapr:] DELETE[/user/mapr/cdc2/mytable] recursive [true]
    2016-06-0606:06:26,779  WARN [][mapr:]GETFILESTATUS FAILED [GET:/v1/user/mapr/cdc2/mytable/20160606-1306258072.csv]response [Not Found] Requested file/user/mapr/cdc2/mytable/20160606-1306258072.csv does not exist.
    MapR httpfs.log:
    Code:
    2016-06-0606:06:26,779  WARNHttpFSExceptionProvider [][mapr:] GETFILESTATUS [[GET,/v1/user/mapr/cdc2/mytable/20160606-1306258072.csv, Not Found, Requested file/user/mapr/cdc2/mytable/20160606-1306258072.csv does notexist.]:java.io.FileNotFoundException: Requested file/user/mapr/cdc2/mytable/20160606-1306258072.csv does not exist.] response [{}]{}

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    299
    Rep Power
    6
    Hello Olivier,

    From the Replicate log we see that your version is 4.0.9.71, we made some improve for HDFS target.

    the latest 4.0.9xx is 4.0.9.114 :

    The Windows kit can be downloaded from this link: https://attunity-patch.s3.amazonaws.....9.114_X64.zip

    How to backup before upgrade:

    1.) Stop all tasks and Replicate services.


    2.) From the Replicate Command Line Console run the following:


    repctl exportrepository


    for alternate data directories use the syntax:


    repctl -d YOUR DATA DiRECOTRY PATH exportrepository


    3.) Back up the Replicate\data directory to a directory outside of the Attunity product.


    4.) Perform the upgrade by running the executable.


    5.) Resume the tasks.




    back Out:




    1.) The back out requires the product to be uninstalled and then installed to the same directory using the previous kit.


    2.) Once the install is done stop the Attunity Services and copy/overwrite the data directory with your backup.


    3.) start the Attunity service

  3. #3
    olivier is offline Junior Member
    Join Date
    Jun 2016
    Posts
    2
    Rep Power
    0
    Hello stevenguyen,

    Unfortunately upgrading to V4.0.9.114 doesn't help.
    Here's the log of a "reload target".

    Code:
    00009420: 2016-06-21T18:46:31 [SERVER          ]I:  Task Server Log - MySQL to HDFS (V4.0.9.114 038-PC Microsoft Windows 64-bit, PID: 6448) started at Tue Jun 21 18:46:31 2016  (logger.c:448)
    00009420: 2016-06-21T18:46:31 [SERVER          ]I:  Licensed to Attunity Replicate Express users (software license acceptance implied)Express license: You are running the Express Edition with reduced functionality (316 days remaining)  (logger.c:451)
    00009420: 2016-06-21T18:46:31 [SERVER          ]I:  Client session (ID 27161) allocated  (dispatcher.c:240)
    00009420: 2016-06-21T18:46:31 [TASK_MANAGER    ]I:  Task 'MySQL to HDFS' running full load and CDC in fresh start mode  (replicationtask.c:805)
    00009420: 2016-06-21T18:46:32 [METADATA_MANAGER]I:  ODBC additional properties = 'driver=MYSQL ODBC 5.3 Unicode Driver'  (mysql_endpoint_imp.c:569)
    00009420: 2016-06-21T18:46:32 [METADATA_MANAGER]I:  Connecting to MySQL through ODBC connection string: DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=localhost;port=3306;UID=cdc;PWD=****;DB=;Option=74448896;driver=MYSQL ODBC 5.3 Unicode Driver  (mysql_endpoint_imp.c:653)
    00009420: 2016-06-21T18:46:32 [METADATA_MANAGER]I:  Hadoop version is '2.7.0-mapr-1602'  (hadoop_imp.c:729)
    00009420: 2016-06-21T18:46:32 [METADATA_MANAGER]I:  Hive version 1.2.0-mapr-1603  (hadoop_imp.c:643)
    00005692: 2016-06-21T18:46:32 [TASK_MANAGER    ]I:  Creating threads for all components  (replicationtask.c:1279)
    00005692: 2016-06-21T18:46:32 [TASK_MANAGER    ]I:  Threads for all components were created  (replicationtask.c:1425)
    00005692: 2016-06-21T18:46:32 [TASK_MANAGER    ]I:  Task initialization completed successfully  (replicationtask.c:2265)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  ODBC additional properties = 'driver=MYSQL ODBC 5.3 Unicode Driver'  (mysql_endpoint_imp.c:569)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  Connecting to MySQL through ODBC connection string: DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=localhost;port=3306;UID=cdc;PWD=****;DB=;Option=74448896;driver=MYSQL ODBC 5.3 Unicode Driver  (mysql_endpoint_imp.c:653)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  'ResumeFetchForXRows' property is set for 1500000000 rows  (mysql_endpoint_imp.c:713)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  System var 'log_bin' = 'ON'  (mysql_endpoint_capture.c:259)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  System var 'binlog_format' = 'ROW'  (mysql_endpoint_capture.c:259)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  System var 'server_id' = '1'  (mysql_endpoint_capture.c:259)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  System var 'binlog_row_image' = 'FULL'  (mysql_endpoint_capture.c:259)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  System var 'binlog_checksum' = 'NONE'  (mysql_endpoint_capture.c:259)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  System var 'lower_case_table_names' = '0'  (mysql_endpoint_capture.c:259)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  System var 'lower_case_file_system' = 'OFF'  (mysql_endpoint_capture.c:259)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  System var 'log_bin_use_v1_row_events' = 'OFF'  (mysql_endpoint_capture.c:259)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  System var 'sql_mode' = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'  (mysql_endpoint_capture.c:259)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  System var 'binlog_row_event_max_size' = ''  (mysql_endpoint_capture.c:259)
    00003572: 2016-06-21T18:46:32 [STREAM_COMPONENT]I:  Force switch to transactional apply mode for Hadoop target  (endpointshell.c:808)
    00003572: 2016-06-21T18:46:32 [TARGET_APPLY    ]I:  Working in transactional apply mode  (endpointshell.c:880)
    00003572: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  ODBC additional properties = 'driver=MYSQL ODBC 5.3 Unicode Driver'  (mysql_endpoint_imp.c:569)
    00003572: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  Connecting to MySQL through ODBC connection string: DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=localhost;port=3306;UID=cdc;PWD=****;DB=;Option=74448896;driver=MYSQL ODBC 5.3 Unicode Driver  (mysql_endpoint_imp.c:653)
    00005692: 2016-06-21T18:46:32 [TASK_MANAGER    ]I:  All stream components were initialized  (replicationtask.c:2110)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  No context received - assume NOW  (mysql_endpoint_capture.c:99)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  Poll binary log every 5 seconds  (mysql_endpoint_capture.c:3269)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  Server version number = 5007012  (mysql_endpoint_capture.c:427)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  System var 'server_id' = '1'  (mysql_endpoint_capture.c:259)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  System var 'lower_case_table_names' = '0'  (mysql_endpoint_capture.c:259)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  Set position to initial context 'now'  (mysql_endpoint_capture.c:2798)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  Setting position in binlog 'mysql-bin.000011' at 400  (mysql_endpoint_capture.c:744)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  Position was set in binlog 'mysql-bin.000011' at 400  (mysql_endpoint_capture.c:771)
    00009644: 2016-06-21T18:46:32 [SOURCE_CAPTURE  ]I:  Stream positioning requested by 'NOW' - located position is at timestamp 'now'  (mysql_endpoint_capture.c:2756)
    00005692: 2016-06-21T18:46:32 [TASK_MANAGER    ]I:  Starting replication now  (replicationtask.c:1862)
    00009296: 2016-06-21T18:46:32 [SORTER          ]I:  Transaction consistency reached  (sorter_transaction.c:229)
    00005692: 2016-06-21T18:46:32 [TASK_MANAGER    ]I:  Starting subtask #1  (replicationtask_util.c:862)
    00006980: 2016-06-21T18:46:33 [SOURCE_CAPTURE  ]I:  ODBC additional properties = 'driver=MYSQL ODBC 5.3 Unicode Driver'  (mysql_endpoint_imp.c:569)
    00006980: 2016-06-21T18:46:33 [SOURCE_CAPTURE  ]I:  Connecting to MySQL through ODBC connection string: DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=localhost;port=3306;UID=cdc;PWD=****;DB=;Option=74448896;driver=MYSQL ODBC 5.3 Unicode Driver  (mysql_endpoint_imp.c:653)
    00009636: 2016-06-21T18:46:33 [SOURCE_UNLOAD   ]I:  ODBC additional properties = 'driver=MYSQL ODBC 5.3 Unicode Driver'  (mysql_endpoint_imp.c:569)
    00009636: 2016-06-21T18:46:33 [SOURCE_UNLOAD   ]I:  Connecting to MySQL through ODBC connection string: DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=localhost;port=3306;UID=cdc;PWD=****;DB=;Option=74448896;driver=MYSQL ODBC 5.3 Unicode Driver  (mysql_endpoint_imp.c:653)
    00009296: 2016-06-21T18:46:33 [SORTER          ]I:  Start collecting changes for table id = 1  (sorter_transaction.c:1681)
    00005692: 2016-06-21T18:46:33 [TASK_MANAGER    ]I:  Start loading table 'mysrc'.'mytable' (Id = 1) by subtask 1. Start load timestamp 000535CC902CAA00  (replicationtask_util.c:1028)
    00009636: 2016-06-21T18:46:33 [SOURCE_UNLOAD   ]I:  Unload finished for table 'mysrc'.'mytable' (Id = 1). 5 rows sent.  (streamcomponent.c:2567)
    00006980: 2016-06-21T18:48:01 [TARGET_LOAD     ]I:  Load finished for table 'mysrc'.'mytable' (Id = 1). 5 rows received. 0 rows skipped. Volume transfered 1760  (streamcomponent.c:2787)
    00006980: 2016-06-21T18:48:41 [INFRASTRUCTURE  ]E:  HDFF-E-ERRWRITE, Error writing file </user/mapr/cdc2/mytable/FL-20160621-1648016867.csv>
     -WHD-E-CREATF, Create file failed: Server returned nothing (no headers, no data) Base general error. (at_universal_fs_object.c:1381)
    00006980: 2016-06-21T18:49:01 [TARGET_LOAD     ]E:  Failed to load file 'C:\Program Files\Attunity\Replicate\data\tasks\MySQL to HDFS\data_files\1\FL-20160621-1648016867.csv' Base general error. (hadoop_utils.c:539)
    00005692: 2016-06-21T18:49:01 [TASK_MANAGER    ]W:  Table 'mysrc'.'mytable' (subtask 1 thread 1) is suspended.  (replicationtask.c:1666)
    00006980: 2016-06-21T18:49:01 [TARGET_LOAD     ]E:  Failed to load file '1' Base general error. (hadoop_load.c:767)
    00006980: 2016-06-21T18:49:01 [TARGET_LOAD     ]E:  Handling End of table 'mysrc'.'mytable' loading failed by subtask 1 thread 1 Base general error. (endpointshell.c:1367)
    00005692: 2016-06-21T18:49:01 [TASK_MANAGER    ]I:  Subtask #1 ended  (replicationtask_util.c:925)

  4. #4
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    299
    Rep Power
    6
    Hello Olivier,

    I just send you a PM, about enable detail debug and how to send the log files to me.

    thanks,
    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •