2 Replies Latest reply: Oct 10, 2013 3:11 AM by 006b7315-b506-4aa4-a648-6ac77005a859 RSS

    Golden Gate for mysql5.5 extract is Abended,and not error in the file

    006b7315-b506-4aa4-a648-6ac77005a859

      Dear All,

      golden gate for mysql5.5 to oracle 11g,extract is Abended ,but there didn't have error in the log , And sometimes the successful extraction some records;

      extract :

      EXTRACT EXT_M1               

      TRANLOGOPTIONS AltLogDest /mydata/mysqllog/binlog/binlog.index       

      SOURCEDB mama@192.168.2.46:16052, USERID mama,PASSWORD mama        

      sqlexec "set names gbk;"       

      EXTTRAIL dirdat/m1                  

      Dynamicresolution               

      TABLE mama.merchants_member_card_customer;   

       

      datapump:

      EXTRACT DPRD_M1  

      SOURCEDB mama@192.168.2.46:16052, USERID mama,PASSWORD mama  

      RMTHOST 192.168.2.57, MGRPORT 7089, compress --COMPRESSUPDATESETWHERE
      RMTTRAIL /home/oracle/goldengate/dirdat/m1

      NOPASSTHRU  

      TABLE mama.merchants_member_card_customer;

       

      GGSCI>>info all

       

      Program     Status      Group       Lag at Chkpt  Time Since Chkpt

       

      MANAGER     RUNNING                                          

      EXTRACT     RUNNING     DPRD_M1     00:00:00      00:00:01   

      EXTRACT     ABENDED     EXT_M1      00:11:49      00:01:56

       

      REPORT:

      GGSCI>>view report ext_m1

       

      ***********************************************************************

                        Oracle GoldenGate Capture for MySQL

            Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230

      Linux, x64, 64bit (optimized), MySQL Enterprise on Apr 23 2012 05:23:34

       

      Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

       

       

                          Starting at 2013-09-29 18:38:08

      ***********************************************************************

       

      Operating System Version:

      Linux

      Version #1 SMP Wed Jun 13 18:24:36 EDT 2012, Release 2.6.32-279.el6.x86_64

      Node: M46

      Machine: x86_64

                               soft limit   hard limit

      Address Space Size   :    unlimited    unlimited

      Heap Size            :    unlimited    unlimited

      File Size            :    unlimited    unlimited

      CPU Time             :    unlimited    unlimited

       

      Process id: 6322

       

      Description:

       

      ***********************************************************************

      **            Running with the following parameters                  **

      ***********************************************************************

       

      2013-09-29 18:38:08  INFO    OGG-03035  Operating system character set identified as UTF-8. Locale: zh_CN, LC_ALL:.

      EXTRACT EXT_M1

      TRANLOGOPTIONS AltLogDest /mydata/mysqllog/binlog/binlog.index

      SOURCEDB mama100@192.168.2.46:16052, USERID mama100,PASSWORD ****************

      sqlexec "set names gbk;"

       

      Executing SQL statement...

       

      2013-09-29 18:38:08  INFO    OGG-00893  SQL statement executed successfully.

       

      EXTTRAIL dirdat/m1

      Dynamicresolution

      TABLE mama100.merchants_member_card_customer;

       

      2013-09-29 18:38:08  INFO    OGG-01815  Virtual Memory Facilities for: COM

          anon alloc: mmap(MAP_ANON)  anon free: munmap

          file alloc: mmap(MAP_SHARED)  file free: munmap

          target directories:

          /home/goldengate/dirtmp.

       

      CACHEMGR virtual memory values (may have been adjusted)

      CACHESIZE:                               64G

      CACHEPAGEOUTSIZE (normal):                8M

      PROCESS VM AVAIL FROM OS (min):         128G

      CACHESIZEMAX (strict force to disk):     96G

       

      Database Version:

      MySQL

      Server Version: 5.5.24-patch-1.0-log

      Client Version: 6.0.0

      Host Connection: 192.168.2.46 via TCP/IP

      Protocol Version: 10

       

      2013-09-29 18:38:08  INFO    OGG-01056  Recovery initialization completed for target file dirdat/m1000000, at RBA 1295, CSN 000086|000000065228677.

       

      2013-09-29 18:38:08  INFO    OGG-01478  Output file dirdat/m1 is using format RELEASE 11.2.

       

      2013-09-29 18:38:08  INFO    OGG-01026  Rolling over remote file dirdat/m1000000.

       

      2013-09-29 18:38:08  INFO    OGG-00182  VAM API running in single-threaded mode.

       

      2013-09-29 18:38:08  INFO    OGG-01515  Positioning to begin time 2013-9-29 06:26:18.

       

      ***********************************************************************

      **                     Run Time Messages                             **

      ***********************************************************************

       

       

      2013-09-29 18:38:08  INFO    OGG-01516  Positioned to Log Number: 86

          Record Offset: 65223906, 2013-9-29 06:26:18.

       

      2013-09-29 18:38:08  INFO    OGG-01517  Position of first record processed Log Number: 86

          Record Offset: 65223906, 2013-9-29 06:26:18.

      TABLE resolved (entry mama100.merchants_member_card_customer):

        TABLE mama100."merchants_member_card_customer";

      Using the following key columns for source table mama100.merchants_member_card_customer: id.

       

       

      2013-09-29 18:38:08  INFO    OGG-01054  Recovery completed for target file dirdat/m1000001, at RBA 1316, CSN 000086|000000065228677.

       

      2013-09-29 18:38:08  INFO    OGG-01057  Recovery completed for all targets.

       

       

       

      ggsevt:

       

      2013-09-29 18:38:08  INFO    OGG-00963  Oracle GoldenGate Manager for MySQL, mgr.prm:  Command received from GGSCI on host localhost (START EXTRACT EXT_M1 ).

      2013-09-29 18:38:08  INFO    OGG-00975  Oracle GoldenGate Manager for MySQL, mgr.prm:  EXTRACT EXT_M1 starting.

      2013-09-29 18:38:08  INFO    OGG-00992  Oracle GoldenGate Capture for MySQL, ext_m1.prm:  EXTRACT EXT_M1 starting.

      2013-09-29 18:38:08  INFO    OGG-03035  Oracle GoldenGate Capture for MySQL, ext_m1.prm:  Operating system character set identified as UTF-8. Locale: zh_CN, LC_ALL:.

      2013-09-29 18:38:08  INFO    OGG-00893  Oracle GoldenGate Capture for MySQL, ext_m1.prm:  SQL statement executed successfully.

      2013-09-29 18:38:08  INFO    OGG-01815  Oracle GoldenGate Capture for MySQL, ext_m1.prm:  Virtual Memory Facilities for: COM

          anon alloc: mmap(MAP_ANON)  anon free: munmap

          file alloc: mmap(MAP_SHARED)  file free: munmap

          target directories:

          /home/goldengate/dirtmp.

      2013-09-29 18:38:08  INFO    OGG-00993  Oracle GoldenGate Capture for MySQL, ext_m1.prm:  EXTRACT EXT_M1 started.

      2013-09-29 18:38:08  INFO    OGG-01056  Oracle GoldenGate Capture for MySQL, ext_m1.prm:  Recovery initialization completed for target file dirdat/m1000000, at RBA 1295, CSN 000086|000000065228677.

      2013-09-29 18:38:08  INFO    OGG-01478  Oracle GoldenGate Capture for MySQL, ext_m1.prm:  Output file dirdat/m1 is using format RELEASE 11.2.

      2013-09-29 18:38:08  INFO    OGG-01026  Oracle GoldenGate Capture for MySQL, ext_m1.prm:  Rolling over remote file dirdat/m1000000.

      2013-09-29 18:38:08  INFO    OGG-00182  Oracle GoldenGate Capture for MySQL, ext_m1.prm:  VAM API running in single-threaded mode.

      2013-09-29 18:38:08  INFO    OGG-01515  Oracle GoldenGate Capture for MySQL, ext_m1.prm:  Positioning to begin time 2013-9-29 06:26:18.

      2013-09-29 18:38:08  INFO    OGG-01516  Oracle GoldenGate Capture for MySQL, ext_m1.prm:  Positioned to Log Number: 86

          Record Offset: 65223906, 2013-9-29 06:26:18.

      2013-09-29 18:38:08  INFO    OGG-01517  Oracle GoldenGate Capture for MySQL, ext_m1.prm:  Position of first record processed Log Number: 86

          Record Offset: 65223906, 2013-9-29 06:26:18.

      2013-09-29 18:38:08  INFO    OGG-01054  Oracle GoldenGate Capture for MySQL, ext_m1.prm:  Recovery completed for target file dirdat/m1000001, at RBA 1316, CSN 000086|000000065228677.

      2013-09-29 18:38:08  INFO    OGG-01057  Oracle GoldenGate Capture for MySQL, ext_m1.prm:  Recovery completed for all targets.

      2013-09-29 18:38:09  INFO    OGG-01054  Oracle GoldenGate Capture for MySQL, dprd_m1.prm:  Recovery completed for target file /home/oracle/goldengate/dirdat/m1000002, at RBA 1435, CSN 000086|000000055512672.

      2013-09-29 18:38:09  INFO    OGG-01057  Oracle GoldenGate Capture for MySQL, dprd_m1.prm:  Recovery completed for all targets.

        • 1. Re: Golden Gate for mysql5.5 extract is Abended,and not error in the file
          006b7315-b506-4aa4-a648-6ac77005a859

          GGSCI>>info ext_m1 showch

           

          EXTRACT    EXT_M1    Last Started 2013-09-29 18:38   Status ABENDED

          Checkpoint Lag       00:11:49 (updated 00:12:05 ago)

          VAM Read Checkpoint  2013-09-29 18:26:18.665841

           

           

           

          Current Checkpoint Detail:

           

          Read Checkpoint #1

           

            VAM External Interface

           

            Startup Checkpoint (starting position in the data source):

              Timestamp: 2013-09-29 18:26:18.665841

             

           

            Recovery Checkpoint (position of oldest unprocessed transaction in the data source):

              Timestamp: 2013-09-29 18:26:18.665841

             

           

            Current Checkpoint (position of last record read in the data source):

              Timestamp: 2013-09-29 18:26:18.665841

             

           

          Write Checkpoint #1

           

            GGS Log Trail

           

            Current Checkpoint (current write position):

              Sequence #: 0

              RBA: 917

              Timestamp: 2013-09-29 18:30:55.655570

              Extract Trail: dirdat/m1

           

          CSN state information:

            CRC: 20-82-1D-34

            CSN: Not available

           

          Header:

            Version = 2

            Record Source = A

            Type = 8

            # Input Checkpoints = 1

            # Output Checkpoints = 1

           

          File Information:

            Block Size = 2048

            Max Blocks = 100

            Record Length = 20480

            Current Offset = 0

           

          Configuration:

            Data Source = 5

            Transaction Integrity = 1

            Task Type = 0

           

          Status:

            Start Time = 2013-09-29 18:38:08

            Last Update Time = 2013-09-29 18:38:08

            Stop Status = A

            Last Result = 0