Lost connection to MySQL server

[jiangnan-ten]

内存 1gb 单核 当导入的数据量达到10w左右的时候 频繁出现

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table duobao_all at row: 45895

canal.go:138 [Error] canal dump mysql err: exit status 3

[siddontang]

这个应该是mysqldump的问题，因为直接调用的mysqldump，你可以用mysqldump直接测试一下。

或者mysqldump还需要配置什么参数，才能不出现这个问题。

欢迎提PR。

[Ferparishuertas]

same error
Lost connection to MySQL server during query when dumping table SEARCH_PARTNER_PRODUCT at row: 220884
2016/09/16 21:50:53 canal.go:143: [error] canal dump mysql err: exit status 3

[siddontang]

This is a problem for mysqldump, we can google with mysqldump Lost connection to MySQL server.
Maybe we should use a channel to retrieving data from mysql and send to ES, not in one goroutine.

[Ferparishuertas]

Just fixed changing parameters on my.cnf

max_allowed_packet = 1024M at mysqldump level
net_read_timeout = 28800
net_write_timeout = 28800
at mydqld level Higg timeout to avoid lost connection

My process took 6 hours