Data Replication 2
Results 1 to 6 of 6

Thread: The CDC task stopped abnormally

  1. #1
    qing is offline Junior Member
    Join Date
    Sep 2015
    Posts
    4
    Rep Power
    0

    The CDC task stopped abnormally

    source: mysql rds
    target: redshift

    Attunity Replicate succeeded in FULL Load but failed in CDC.
    The error is "the task stopped abnormally". Rather than that, I can not see any other warnings or errors in log.

    Also what is the difference between 'Apply Changes' and 'Store Changes'.

    Log information about configure :
    00099204: 2015-09-17T09:04:24 [SOURCE_CAPTURE ]I: System var 'log_bin' = 'ON' (mysql_endpoint_capture.c:259)00099204: 2015-09-17T09:04:24 [SOURCE_CAPTURE ]I: System var 'binlog_format' = 'ROW' (mysql_endpoint_capture.c:259)
    00099204: 2015-09-17T09:04:24 [SOURCE_CAPTURE ]I: System var 'server_id' = '1842332511' (mysql_endpoint_capture.c:259)
    00099204: 2015-09-17T09:04:24 [SOURCE_CAPTURE ]I: System var 'binlog_row_image' = 'FULL' (mysql_endpoint_capture.c:259)
    00099204: 2015-09-17T09:04:24 [SOURCE_CAPTURE ]I: System var 'binlog_checksum' = 'NONE' (mysql_endpoint_capture.c:259)
    00099204: 2015-09-17T09:04:24 [SOURCE_CAPTURE ]I: System var 'lower_case_table_names' = '0' (mysql_endpoint_capture.c:259)
    00099204: 2015-09-17T09:04:24 [SOURCE_CAPTURE ]I: System var 'lower_case_file_system' = 'OFF' (mysql_endpoint_capture.c:259)
    00099204: 2015-09-17T09:04:24 [SOURCE_CAPTURE ]I: System var 'log_bin_use_v1_row_events' = 'OFF' (mysql_endpoint_capture.c:259)
    00099204: 2015-09-17T09:04:24 [SOURCE_CAPTURE ]I: System var 'sql_mode' = 'NO_ENGINE_SUBSTITUTION' (mysql_endpoint_capture.c:259)
    00099204: 2015-09-17T09:04:24 [SOURCE_CAPTURE ]I: System var 'binlog_row_event_max_size' = '' (mysql_endpoint_capture.c:259)

  2. #2
    KeithT is offline Junior Member
    Join Date
    Jul 2014
    Posts
    4
    Rep Power
    0
    Hello Qing,

    Please attach the complete task log in a reply to this thread for review.

  3. #3
    qing is offline Junior Member
    Join Date
    Sep 2015
    Posts
    4
    Rep Power
    0
    Quote Originally Posted by KeithT View Post
    Hello Qing,

    Please attach the complete task log in a reply to this thread for review.
    Below is the task log:

    00165144: 2015-09-22T13:04:25 [SERVER ]I: Task Server Log - CDC TASK (V4.0.5.114 WIN-3JR7OLBVDLR Microsoft Windows 64-bit, PID: 165796) started at Tue Sep 22 13:04:25 2015 (logger.c:448)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]I: Product license was not found. (license.c:746)
    00165144: 2015-09-22T13:04:25 [SERVER ]I: Client session (ID 26611) allocated (dispatcher.c:237)
    00165144: 2015-09-22T13:04:25 [TASK_MANAGER ]I: Task 'CDC TASK' running CDC only in fresh start mode (replicationtask.c:728)
    00165144: 2015-09-22T13:04:25 [UTILITIES ]D: Notifications was not defined (notification_manager.c:525)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: Alloc repo C:\Program Files\Attunity\Replicate\data\tasks\CDC TASK/CDC TASK.repo (repository.c:4769)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: Free repository C:\Program Files\Attunity\Replicate\data\tasks\CDC TASK/CDC TASK.repo (repository.c:362)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC provider = 'MySQL ODBC 5.2 Unicode Driver' (mysql_endpoint_imp.c:487)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]I: ODBC additional properties = 'Driver=MySQL ODBC 5.1 Driver;Driver=MySQL ODBC 5.1 Driver;user=****;pwd=****' (mysql_endpoint_imp.c:569)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]I: Connecting to MySQL through ODBC connection string: DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=***.eu-west-1.rds.amazonaws.com;port=3306;UID=****;PWD=****;DB =;Option=74448896;Driver=MySQL ODBC 5.1 Driver;Driver=MySQL ODBC 5.1 Driver;user=****;pwd=**** (mysql_endpoint_imp.c:653)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC version '03.80.0000' (ar_odbc_conn.c:435)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC qualifier name separator: '.' (ar_odbc_conn.c:444)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC quote char: '`' (ar_odbc_conn.c:451)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC dbms name: 'MySQL' (ar_odbc_conn.c:458)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC dbms version: '5.6.23-log' (ar_odbc_conn.c:464)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC driver name: 'myodbc5.dll' (ar_odbc_conn.c:470)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC driver version: '05.01.0013' (ar_odbc_conn.c:476)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC database name: 'null' (ar_odbc_conn.c:482)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC server name: '*****.eu-west-1.rds.amazonaws.com via TCP/IP' (ar_odbc_conn.c:490)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC max schema name len: '0' (ar_odbc_conn.c:496)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC max table name len: '192' (ar_odbc_conn.c:501)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC max column name len: '192' (ar_odbc_conn.c:506)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC provider needs long data len: 'N' (ar_odbc_conn.c:512)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Search pattern escape: '\' (ar_odbc_conn.c:524)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC Provider supported data types: (ar_odbc_conn.c:967)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 0) name: 'bit', SQLType: -7, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 1) name: 'tinyint', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 2) name: 'tinyint unsigned', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 3) name: 'tinyint auto_increment', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 4) name: 'tinyint unsigned auto_increment', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 5) name: 'bigint', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 6) name: 'bigint unsigned', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 7) name: 'bigint auto_increment', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 8) name: 'bigint unsigned auto_increment', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 9) name: 'long varbinary', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC version '03.80.0000' (ar_odbc_conn.c:435)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC qualifier name separator: '.' (ar_odbc_conn.c:444)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC quote char: '`' (ar_odbc_conn.c:451)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC dbms name: 'MySQL' (ar_odbc_conn.c:458)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC dbms version: '5.6.23-log' (ar_odbc_conn.c:464)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC driver name: 'myodbc5.dll' (ar_odbc_conn.c:470)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC driver version: '05.01.0013' (ar_odbc_conn.c:476)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC database name: 'null' (ar_odbc_conn.c:482)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC server name: '****.eu-west-1.rds.amazonaws.com via TCP/IP' (ar_odbc_conn.c:490)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC max schema name len: '0' (ar_odbc_conn.c:496)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC max table name len: '192' (ar_odbc_conn.c:501)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC max column name len: '192' (ar_odbc_conn.c:506)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC provider needs long data len: 'N' (ar_odbc_conn.c:512)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Search pattern escape: '\' (ar_odbc_conn.c:524)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC Provider supported data types: (ar_odbc_conn.c:967)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 0) name: 'bit', SQLType: -7, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 1) name: 'tinyint', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 2) name: 'tinyint unsigned', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 3) name: 'tinyint auto_increment', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 4) name: 'tinyint unsigned auto_increment', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 5) name: 'bigint', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 6) name: 'bigint unsigned', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 7) name: 'bigint auto_increment', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 8) name: 'bigint unsigned auto_increment', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 9) name: 'long varbinary', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 10) name: 'blob', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 11) name: 'longblob', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 12) name: 'tinyblob', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 13) name: 'mediumblob', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 14) name: 'varbinary', SQLType: -3, create params: 'length' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 15) name: 'binary', SQLType: -2, create params: 'length' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 16) name: 'long varchar', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 17) name: 'text', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 18) name: 'mediumtext', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 19) name: 'longtext', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 20) name: 'tinytext', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 21) name: 'char', SQLType: 1, create params: 'length' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 22) name: 'numeric', SQLType: 2, create params: 'precision,scale' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 23) name: 'decimal', SQLType: 3, create params: 'precision,scale' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 24) name: 'integer', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 25) name: 'integer unsigned', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 26) name: 'int', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 27) name: 'int unsigned', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 28) name: 'mediumint', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 29) name: 'mediumint unsigned', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 30) name: 'integer auto_increment', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 31) name: 'integer unsigned auto_increment', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 32) name: 'int auto_increment', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 33) name: 'int unsigned auto_increment', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 34) name: 'mediumint auto_increment', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 35) name: 'mediumint unsigned auto_increment', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 36) name: 'smallint', SQLType: 5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 37) name: 'smallint unsigned', SQLType: 5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 38) name: 'smallint auto_increment', SQLType: 5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 39) name: 'smallint unsigned auto_increment', SQLType: 5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 40) name: 'double', SQLType: 6, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 41) name: 'double auto_increment', SQLType: 6, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 42) name: 'float', SQLType: 7, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 43) name: 'float auto_increment', SQLType: 7, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 44) name: 'double', SQLType: 8, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 45) name: 'double auto_increment', SQLType: 8, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 46) name: 'date', SQLType: 91, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 47) name: 'time', SQLType: 92, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 48) name: 'year', SQLType: 5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 49) name: 'datetime', SQLType: 93, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 50) name: 'timestamp', SQLType: 93, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 51) name: 'varchar', SQLType: 12, create params: 'length' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: Syntax object for 'Redshift' provider was not found in the repository (dbprops.c:414)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: 'Redshift' provider syntax was not found in the repository. (dbprops.c:745)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]I: Going to connect to server ****.eu-west-1.redshift.amazonaws.com database dev (redshift_imp.c:726)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC version '03.80.0000' (ar_odbc_conn.c:435)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC qualifier name separator: '.' (ar_odbc_conn.c:444)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC quote char: '"' (ar_odbc_conn.c:451)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC dbms name: 'PostgreSQL' (ar_odbc_conn.c:458)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC dbms version: '8.0.2' (ar_odbc_conn.c:464)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC driver name: 'PSQLODBC35W.DLL' (ar_odbc_conn.c:470)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC driver version: '09.00.0101' (ar_odbc_conn.c:476)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC database name: 'dev' (ar_odbc_conn.c:482)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC server name: '****.eu-west-1.redshift.amazonaws.com' (ar_odbc_conn.c:490)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC max schema name len: '64' (ar_odbc_conn.c:496)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC max table name len: '64' (ar_odbc_conn.c:501)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC max column name len: '64' (ar_odbc_conn.c:506)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC provider needs long data len: 'N' (ar_odbc_conn.c:512)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Search pattern escape: '\' (ar_odbc_conn.c:524)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: ODBC Provider supported data types: (ar_odbc_conn.c:967)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 0) name: 'int8', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 1) name: 'char', SQLType: -7, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 2) name: 'char', SQLType: 1, create params: 'max. length' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 3) name: 'date', SQLType: 91, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 4) name: 'date', SQLType: 9, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 5) name: 'numeric', SQLType: 3, create params: 'precision, scale' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 6) name: 'float8', SQLType: 8, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 7) name: 'float8', SQLType: 6, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 8) name: 'int4', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 9) name: 'lo', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 10) name: 'text', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 11) name: 'numeric', SQLType: 2, create params: 'precision, scale' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 12) name: 'float4', SQLType: 7, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 13) name: 'int2', SQLType: 5, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 14) name: 'time', SQLType: 92, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 15) name: 'timestamptz', SQLType: 93, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 16) name: 'time', SQLType: 10, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 17) name: 'timestamptz', SQLType: 11, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 18) name: 'int2', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 19) name: 'bytea', SQLType: -3, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 20) name: 'varchar', SQLType: 12, create params: 'max. length' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 21) name: 'char', SQLType: -8, create params: 'max. length' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 22) name: 'varchar', SQLType: -9, create params: 'max. length' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 23) name: 'text', SQLType: -10, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]D: 24) name: 'unknown', SQLType: -11, create params: '' (ar_odbc_conn.c:1013)
    00165144: 2015-09-22T13:04:25 [METADATA_MANAGER]I: Connected to server ****.eu-west-1.redshift.amazonaws.com database dev successfully. (redshift_imp.c:745)
    00165144: 2015-09-22T13:04:25 [TASK_MANAGER ]D: Task Manager starting. Topology was created (replicationtask.c:870)
    00165144: 2015-09-22T13:04:25 [TASK_MANAGER ]D: Task Manager starting. Allocated (replicationtask_cmd.c:76)
    00165144: 2015-09-22T13:04:25 [TASK_MANAGER ]D: Task Manager starting. Thread Started (replicationtask_cmd.c:93)
    00164976: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: creating new thread pool (at_memory.c:333)
    00164976: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: Thread ID 164976 has started (ar_apr.c:296)
    00164976: 2015-09-22T13:04:25 [TASK_MANAGER ]D: Start control thread (replicationtask.c:2022)
    00164976: 2015-09-22T13:04:25 [TASK_MANAGER ]D: Preparing all components (replicationtask.c:1093)
    00164976: 2015-09-22T13:04:25 [UTILITIES ]D: The state is saved to file 'C:\Program Files\Attunity\Replicate\data\tasks\CDC TASK/StateManager/ars_saved_state_000001.sts' at Tue, 22 Sep 2015 13:04:25 GMT (1442927065845191) (statemanager.c:644)
    00164976: 2015-09-22T13:04:25 [TASK_MANAGER ]I: Creating threads for all components (replicationtask.c:1151)
    00164976: 2015-09-22T13:04:25 [TABLES_MANAGER ]D: Calling for get capture table list from the Metadata Manager started. (tasktablesmanager.c:828)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Get capture table list from shell component started (metadatamanager.c:2846)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Get capture tables. Explicits=1, include-patterns=0, exclude-patterns=7, max=60000 (mysql_endpoint_imp.c:1776)
    00165312: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: creating new thread pool (at_memory.c:333)
    00165312: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: Thread ID 165312 has started (ar_apr.c:296)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Insert table 'nutmeglive.T_WEB_ABOUTYOU' to entry 0 (mysql_endpoint_imp.c:1725)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Num tables returned in response = 1 (mysql_endpoint_imp.c:1881)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Add special tables started (metadatamanager.c:2853)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Get capture table list from sqlite started (metadatamanager.c:2860)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager persistent storage. Table Name: 'nutmeglive.T_WEB_ABOUTYOU', table Id: '1', Table Object Id: '0' (metadatamanager.c:2172)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager indices. Table Name: 'nutmeglive.T_WEB_ABOUTYOU', table Id: '1', Table Object Id: '0' (metadatamanager.c:2780)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager. Table Name: 'nutmeglive.T_WEB_ABOUTYOU', table Id: '1', Table Object Id: '0' (metadatamanager.c:2573)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager persistent storage. Table Name: '.attrep_status', table Id: '2', Table Object Id: '3' (metadatamanager.c:2172)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager indices. Table Name: '.attrep_status', table Id: '2', Table Object Id: '3' (metadatamanager.c:2780)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager. Table Name: '.attrep_status', table Id: '2', Table Object Id: '3' (metadatamanager.c:2573)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager persistent storage. Table Name: '.attrep_suspended_tables', table Id: '3', Table Object Id: '4' (metadatamanager.c:2172)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager indices. Table Name: '.attrep_suspended_tables', table Id: '3', Table Object Id: '4' (metadatamanager.c:2780)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager. Table Name: '.attrep_suspended_tables', table Id: '3', Table Object Id: '4' (metadatamanager.c:2573)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager persistent storage. Table Name: '.attrep_history', table Id: '4', Table Object Id: '5' (metadatamanager.c:2172)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager indices. Table Name: '.attrep_history', table Id: '4', Table Object Id: '5' (metadatamanager.c:2780)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager. Table Name: '.attrep_history', table Id: '4', Table Object Id: '5' (metadatamanager.c:2573)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager persistent storage. Table Name: '.attrep_apply_exceptions', table Id: '5', Table Object Id: '6' (metadatamanager.c:2172)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager indices. Table Name: '.attrep_apply_exceptions', table Id: '5', Table Object Id: '6' (metadatamanager.c:2780)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Table Desc has been added to the Metadata Manager. Table Name: '.attrep_apply_exceptions', table Id: '5', Table Object Id: '6' (metadatamanager.c:2573)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] starting lg_net_send (C5AAB0) (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] lg_net_send - socket 412 , send_size 16 , state 1 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] lg_net_send - using hook (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] starting lg_net_send (C5AAB0) (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] lg_net_send - socket 412 , send_size 32 , state 1 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] lg_net_send - using io mode 0 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] starting lg_net_send_sync - buffer is 1576090 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] starting send loop (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] going to send 32 from 1576090 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] sent 32 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] sent 32 bytes on socket 412 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] starting lg_net_send (C5AAB0) (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] lg_net_send - socket 412 , send_size 16 , state 1 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] lg_net_send - using hook (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] starting lg_net_send (C5AAB0) (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] lg_net_send - socket 412 , send_size 32 , state 1 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] lg_net_send - using io mode 0 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] starting lg_net_send_sync - buffer is 1576090 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] starting send loop (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] going to send 32 from 1576090 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] sent 32 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] sent 32 bytes on socket 412 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] 1 members in selection group (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] s_session[0] events mask is 8 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] adding socket 412 to read group (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] select timeout is 3000 ms (at_logger.c:2754)
    00165144: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: [network] max fd is 1 (at_logger.c:2754)
    00164976: 2015-09-22T13:04:25 [METADATA_MANAGER]D: Create captured table list ended (metadatamanager.c:2864)
    00164976: 2015-09-22T13:04:25 [TABLES_MANAGER ]D: Calling for get capture table list from the Metadata Manager ended. (tasktablesmanager.c:834)
    00164976: 2015-09-22T13:04:25 [TABLES_MANAGER ]D: Captured Table 'nutmeglive'.'T_WEB_ABOUTYOU' ID - 1 (tasktablesmanager.c:923)
    00164976: 2015-09-22T13:04:25 [TABLES_MANAGER ]D: Get capture table list ended. (tasktablesmanager.c:1143)
    00164976: 2015-09-22T13:04:25 [TASK_MANAGER ]D: Create thread for component st_0_MySQLProd (subtask.c:928)
    00163668: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: creating new thread pool (at_memory.c:333)
    00164976: 2015-09-22T13:04:25 [TASK_MANAGER ]D: Create thread for component st_0_RedShift (subtask.c:928)
    00163668: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: Thread ID 163668 has started (ar_apr.c:296)
    00164976: 2015-09-22T13:04:25 [TASK_MANAGER ]D: Create thread for component st_0_transaction_sorter (subtask.c:928)
    00164976: 2015-09-22T13:04:25 [TASK_MANAGER ]D: Task Manager starting. CDC subtask created (replicationtask.c:1277)
    00164976: 2015-09-22T13:04:25 [TASK_MANAGER ]I: Threads for all components were created (replicationtask.c:1297)
    00164976: 2015-09-22T13:04:25 [TASK_MANAGER ]I: Task initialization completed successfully (replicationtask.c:2064)
    00164976: 2015-09-22T13:04:25 [UTILITIES ]D: No notification is defined for trigger of type 'TASK_STARTED' (notification_manager.c:933)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC provider = 'MySQL ODBC 5.2 Unicode Driver' (mysql_endpoint_imp.c:487)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]I: ODBC additional properties = 'Driver=MySQL ODBC 5.1 Driver;Driver=MySQL ODBC 5.1 Driver;user=****;pwd=****' (mysql_endpoint_imp.c:569)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]I: Connecting to MySQL through ODBC connection string: DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=****.eu-west-1.rds.amazonaws.com;port=3306;UID=****;PWD=****;DB =;Option=74448896;Driver=MySQL ODBC 5.1 Driver;Driver=MySQL ODBC 5.1 Driver;user=****;pwd=**** (mysql_endpoint_imp.c:653)
    00164496: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: creating new thread pool (at_memory.c:333)
    00162668: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: creating new thread pool (at_memory.c:333)
    00164496: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: Thread ID 164496 has started (ar_apr.c:296)
    00162668: 2015-09-22T13:04:25 [INFRASTRUCTURE ]D: Thread ID 162668 has started (ar_apr.c:296)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC version '03.80.0000' (ar_odbc_conn.c:435)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC qualifier name separator: '.' (ar_odbc_conn.c:444)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC quote char: '`' (ar_odbc_conn.c:451)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC dbms name: 'MySQL' (ar_odbc_conn.c:458)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC dbms version: '5.6.23-log' (ar_odbc_conn.c:464)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC driver name: 'myodbc5.dll' (ar_odbc_conn.c:470)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC driver version: '05.01.0013' (ar_odbc_conn.c:476)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC database name: 'null' (ar_odbc_conn.c:482)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC server name: '****.eu-west-1.rds.amazonaws.com via TCP/IP' (ar_odbc_conn.c:490)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC max schema name len: '0' (ar_odbc_conn.c:496)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC max table name len: '192' (ar_odbc_conn.c:501)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC max column name len: '192' (ar_odbc_conn.c:506)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC provider needs long data len: 'N' (ar_odbc_conn.c:512)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: Search pattern escape: '\' (ar_odbc_conn.c:524)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC Provider supported data types: (ar_odbc_conn.c:967)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 0) name: 'bit', SQLType: -7, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 1) name: 'tinyint', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 2) name: 'tinyint unsigned', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 3) name: 'tinyint auto_increment', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 4) name: 'tinyint unsigned auto_increment', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 5) name: 'bigint', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 6) name: 'bigint unsigned', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 7) name: 'bigint auto_increment', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 8) name: 'bigint unsigned auto_increment', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 9) name: 'long varbinary', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 10) name: 'blob', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 11) name: 'longblob', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 12) name: 'tinyblob', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 13) name: 'mediumblob', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 14) name: 'varbinary', SQLType: -3, create params: 'length' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 15) name: 'binary', SQLType: -2, create params: 'length' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 16) name: 'long varchar', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 17) name: 'text', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 18) name: 'mediumtext', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 19) name: 'longtext', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 20) name: 'tinytext', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 21) name: 'char', SQLType: 1, create params: 'length' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 22) name: 'numeric', SQLType: 2, create params: 'precision,scale' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC version '03.80.0000' (ar_odbc_conn.c:435)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC qualifier name separator: '.' (ar_odbc_conn.c:444)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC quote char: '`' (ar_odbc_conn.c:451)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC dbms name: 'MySQL' (ar_odbc_conn.c:458)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC dbms version: '5.6.23-log' (ar_odbc_conn.c:464)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC driver name: 'myodbc5.dll' (ar_odbc_conn.c:470)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC driver version: '05.01.0013' (ar_odbc_conn.c:476)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC database name: 'null' (ar_odbc_conn.c:482)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC server name: '****.eu-west-1.rds.amazonaws.com via TCP/IP' (ar_odbc_conn.c:490)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC max schema name len: '0' (ar_odbc_conn.c:496)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC max table name len: '192' (ar_odbc_conn.c:501)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC max column name len: '192' (ar_odbc_conn.c:506)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC provider needs long data len: 'N' (ar_odbc_conn.c:512)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: Search pattern escape: '\' (ar_odbc_conn.c:524)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: ODBC Provider supported data types: (ar_odbc_conn.c:967)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 0) name: 'bit', SQLType: -7, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 1) name: 'tinyint', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 2) name: 'tinyint unsigned', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 3) name: 'tinyint auto_increment', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 4) name: 'tinyint unsigned auto_increment', SQLType: -6, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 5) name: 'bigint', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 6) name: 'bigint unsigned', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 7) name: 'bigint auto_increment', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 8) name: 'bigint unsigned auto_increment', SQLType: -5, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 9) name: 'long varbinary', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 10) name: 'blob', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 11) name: 'longblob', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 12) name: 'tinyblob', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 13) name: 'mediumblob', SQLType: -4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 14) name: 'varbinary', SQLType: -3, create params: 'length' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 15) name: 'binary', SQLType: -2, create params: 'length' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 16) name: 'long varchar', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 17) name: 'text', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 18) name: 'mediumtext', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 19) name: 'longtext', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 20) name: 'tinytext', SQLType: -1, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 21) name: 'char', SQLType: 1, create params: 'length' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 22) name: 'numeric', SQLType: 2, create params: 'precision,scale' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 23) name: 'decimal', SQLType: 3, create params: 'precision,scale' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 24) name: 'integer', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 25) name: 'integer unsigned', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 26) name: 'int', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 27) name: 'int unsigned', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 28) name: 'mediumint', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 29) name: 'mediumint unsigned', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 30) name: 'integer auto_increment', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 31) name: 'integer unsigned auto_increment', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 32) name: 'int auto_increment', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 33) name: 'int unsigned auto_increment', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 34) name: 'mediumint auto_increment', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 35) name: 'mediumint unsigned auto_increment', SQLType: 4, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 36) name: 'smallint', SQLType: 5, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 37) name: 'smallint unsigned', SQLType: 5, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 38) name: 'smallint auto_increment', SQLType: 5, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 39) name: 'smallint unsigned auto_increment', SQLType: 5, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 40) name: 'double', SQLType: 6, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 41) name: 'double auto_increment', SQLType: 6, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 42) name: 'float', SQLType: 7, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 43) name: 'float auto_increment', SQLType: 7, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 44) name: 'double', SQLType: 8, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 45) name: 'double auto_increment', SQLType: 8, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 46) name: 'date', SQLType: 91, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 47) name: 'time', SQLType: 92, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 48) name: 'year', SQLType: 5, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 49) name: 'datetime', SQLType: 93, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 50) name: 'timestamp', SQLType: 93, create params: '' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: 51) name: 'varchar', SQLType: 12, create params: 'length' (ar_odbc_conn.c:1013)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]D: validate_mysql_server (mysql_endpoint_capture.c:276)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]I: System var 'log_bin' = 'ON' (mysql_endpoint_capture.c:259)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]I: System var 'binlog_format' = 'ROW' (mysql_endpoint_capture.c:259)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]I: System var 'server_id' = '1842332511' (mysql_endpoint_capture.c:259)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]I: System var 'binlog_row_image' = 'FULL' (mysql_endpoint_capture.c:259)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]I: System var 'binlog_checksum' = 'NONE' (mysql_endpoint_capture.c:259)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]I: System var 'lower_case_table_names' = '0' (mysql_endpoint_capture.c:259)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]I: System var 'lower_case_file_system' = 'OFF' (mysql_endpoint_capture.c:259)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]I: System var 'log_bin_use_v1_row_events' = 'OFF' (mysql_endpoint_capture.c:259)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]I: System var 'sql_mode' = 'NO_ENGINE_SUBSTITUTION' (mysql_endpoint_capture.c:259)
    00163668: 2015-09-22T13:04:25 [SOURCE_CAPTURE ]I: System var 'binlog_row_event_max_size' = '' (mysql_endpoint_capture.c:259)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] select result is 1 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_recv - using hook, requested to read 16 bytes (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_recv_sync_intern: requested to recv 16 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_recv_sync_intern: curr_bytes_received = 16 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_recv_sync_intern: requested to recv 16 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_recv_sync_intern: curr_bytes_received = 16 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_recv hook returned, actually read 16 bytes (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_recv - using hook, requested to read 23 bytes (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_recv_sync_intern: requested to recv 16 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_recv_sync_intern: curr_bytes_received = 16 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_recv_sync_intern: requested to recv 16 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_recv_sync_intern: curr_bytes_received = 16 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_recv hook returned, actually read 23 bytes (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [SERVER ]D: Request received (Session #26611) (server.c:1937)
    00165144: 2015-09-22T13:04:26 [SERVER ]D: Executing command GETTASKSTATUS_REQ (Session #26611) (server.c:404)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] starting lg_net_send (C5AAB0) (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_send - socket 412 , send_size 16 , state 1 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_send - using hook (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] starting lg_net_send (C5AAB0) (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_send - socket 412 , send_size 32 , state 1 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_send - using io mode 0 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] starting lg_net_send_sync - buffer is 1576090 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] starting send loop (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] going to send 32 from 1576090 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] sent 32 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] sent 32 bytes on socket 412 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] starting lg_net_send (C5AAB0) (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_send - socket 412 , send_size 149 , state 1 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_send - using hook (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] starting lg_net_send (C5AAB0) (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_send - socket 412 , send_size 160 , state 1 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] lg_net_send - using io mode 0 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] starting lg_net_send_sync - buffer is 1576090 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] starting send loop (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] going to send 160 from 1576090 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] sent 160 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] sent 160 bytes on socket 412 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] 1 members in selection group (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] s_session[0] events mask is 8 (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] adding socket 412 to read group (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] select timeout is 3000 ms (at_logger.c:2754)
    00165144: 2015-09-22T13:04:26 [INFRASTRUCTURE ]D: [network] max fd is 1 (at_logger.c:2754)

  4. #4
    KeithT is offline Junior Member
    Join Date
    Jul 2014
    Posts
    4
    Rep Power
    0
    Please confirm that the following was done for MySQL on RDS with the following:


    To enable CDC with Amazon RDS MySQL, you need to use Amazon RDS MySQL version 5.6 or higher.


    1. Follow the instructions provided by AWS to create a new Parameter Group (see the Binary Logging Format section):
    MySQL Database Log Files - Amazon Relational Database Service


    2. When creating the new Parameter Group, set the following values:
    - binlog_format=row
    - binlog_checksum=NONE (This one is appears to have been defined already)


    3. Save the new Parameter Group.


    4. If you have an existing instance of Amazon RDS MySQL, edit the instance to use the parameters specified in Step 2 above. Or, if you are provisioning a new instance of Amazon RDS MySQL, reference the new Parameter Group created in Step 1 above.


    Also, from the log you can see defined something that does not look normal for your source connection string:
    DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=****.eu-west-1.rds.amazonaws.com;port=3306;UID=****;PWD=****;DB =;Option=74448896;Driver=MySQL ODBC 5.1 Driver;Driver=MySQL ODBC 5.1 Driver;user=****;pwd=****


    A normal connection string should look like this:
    00003792: 2015-08-20T18:59:20 [SOURCE_CAPTURE ]I: Connecting to MySQL through ODBC connection string: DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=yy-rpt-vcex64.qa.int;port=3306;UID=root;PWD=****;DB=;Opti on=74448896; (mysql_endpoint_imp.c:653)


    Is there a reason for the connection string you are using?

  5. #5
    qing is offline Junior Member
    Join Date
    Sep 2015
    Posts
    4
    Rep Power
    0
    In the configuration part, I can see that we use 'Driver=MySQL ODBC 5.1 Driver'. But I am not sure why the log file mentioned 'DRIVER={MySQL ODBC 5.2 Unicode Driver}'.

    Quote Originally Posted by KeithT View Post
    Please confirm that the following was done for MySQL on RDS with the following:


    To enable CDC with Amazon RDS MySQL, you need to use Amazon RDS MySQL version 5.6 or higher.


    1. Follow the instructions provided by AWS to create a new Parameter Group (see the Binary Logging Format section):
    MySQL Database Log Files - Amazon Relational Database Service


    2. When creating the new Parameter Group, set the following values:
    - binlog_format=row
    - binlog_checksum=NONE (This one is appears to have been defined already)


    3. Save the new Parameter Group.


    4. If you have an existing instance of Amazon RDS MySQL, edit the instance to use the parameters specified in Step 2 above. Or, if you are provisioning a new instance of Amazon RDS MySQL, reference the new Parameter Group created in Step 1 above.


    Also, from the log you can see defined something that does not look normal for your source connection string:
    DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=****.eu-west-1.rds.amazonaws.com;port=3306;UID=****;PWD=****;DB =;Option=74448896;Driver=MySQL ODBC 5.1 Driver;Driver=MySQL ODBC 5.1 Driver;user=****;pwd=****


    A normal connection string should look like this:
    00003792: 2015-08-20T18:59:20 [SOURCE_CAPTURE ]I: Connecting to MySQL through ODBC connection string: DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=yy-rpt-vcex64.qa.int;port=3306;UID=root;PWD=****;DB=;Opti on=74448896; (mysql_endpoint_imp.c:653)


    Is there a reason for the connection string you are using?

  6. #6
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    299
    Rep Power
    6
    Quote Originally Posted by qing View Post
    In the configuration part, I can see that we use 'Driver=MySQL ODBC 5.1 Driver'. But I am not sure why the log file mentioned 'DRIVER={MySQL ODBC 5.2 Unicode Driver}'.

    Look like you change your MySQL connection with additional information.

    From my test job:

    00003400: 2015-10-06T09:55:17 [METADATA_MANAGER]I: ODBC additional properties = '(null)' (mysql_endpoint_imp.c:569)
    00003400: 2015-10-06T09:55:17 [METADATA_MANAGER]I: Connecting to MySQL through ODBC connection string: DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=xxxx.cjxafvnblqms.us-east-1.rds.amazonaws.com;port=3306;UID=support;PWD=**** ;DB=;Option=74448896; (mysql_endpoint_imp.c:653)

    ====
    Try to create a new RDSMySQL connection as the source, which is just MySQL as a DB type.

    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
  •