MySQL- Extract Fails Lost Connection To MySQL Server During Query For Large Tables (Doc ID 1940762.1)

Last updated on MAY 18, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Goal

Initial load Extract (SOURCEISTABLE) fails Lost connection to MySQL server during query for large tables. ( When Tables are 5GB+ )

net_read_timeout, net_write_timeout have been increased to 5 minutes
2014-09-29 22:32:37 INFO OGG-01815 Oracle GoldenGate Capture for MySQL, evminit3.prm: Virtual Memory Facilities for: COM
  anon alloc: mmap(MAP_ANON) anon free: munmap
  file alloc: mmap(MAP_SHARED) file free: munmap
  target directories:
  /t/12.1.2/dirtmp.
2014-09-29 22:32:38 INFO OGG-00993 Oracle GoldenGate Capture for MySQL, evminit3.prm: EXTRACT EVMINIT3 started.
2014-09-29 22:32:38 INFO OGG-01478 Oracle GoldenGate Capture for MySQL, evminit3.prm: Output file /stg/dirdat/v3 is using format RELEASE 11.2.
2014-09-29 22:32:43 INFO OGG-01226 Oracle GoldenGate Capture for MySQL, evminit3.prm: Socket buffer size set to 27985 (flush size 27985).
2014-09-29 22:33:42 ERROR OGG-00768 Oracle GoldenGate Capture for MySQL, evminit3.prm: Storing result set for query SELECT `InstanceId`,`id`,`lastModificationDate`,`lastReadDate`,unhex(hex(`processId`)),`processInstanceByteArray`,`startDate`,`state`,`OPTLOCK` FROM `VM`.`ProcessInstanceInfo`. SQL error (2013). Lost connection to MySQL server during query.
2014-09-29 22:33:42 ERROR OGG-01668 Oracle GoldenGate Capture for MySQL, evminit3.prm: PROCESS ABENDING.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms