[MXS-570] Loading database dump through readwritesplit causes error messages Created: 2016-02-09  Updated: 2016-04-01  Resolved: 2016-04-01

Status: Closed
Project: MariaDB MaxScale
Component/s: readwritesplit
Affects Version/s: 1.3.0
Fix Version/s: 1.4.1

Type: Bug Priority: Minor
Reporter: markus makela Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None

Issue Links:
Relates
relates to MXS-564 Loading database dump through readwri... Closed

 Description   

Originally reported by engel75:

Dear markus makela great success! The import finished successful! I still get those errors:

2016-02-05 15:15:51.782   error  : Backend hangup error handling.
 
2016-02-05 15:15:51.783   error  : Backend hangup error handling.
 
2016-02-05 15:15:51.784   error  : Backend hangup error handling.
 
2016-02-05 15:15:51.784   error  : Backend hangup error handling.
 
2016-02-05 15:29:23.315   error  : Backend hangup error handling.
 
2016-02-05 15:29:23.315   error  : Backend hangup error handling.
 
2016-02-05 15:29:23.316   error  : Backend hangup error handling.
 
2016-02-05 15:29:23.319   error  : Backend hangup error handling.
 
2016-02-05 15:42:57.576   error  : Backend hangup error handling.
 
2016-02-05 15:42:57.578   error  : Backend hangup error handling.
 
2016-02-05 15:42:57.579   error  : Backend hangup error handling.
 
2016-02-05 15:42:57.579   error  : Backend hangup error handling.
 
2016-02-05 15:56:30.138   error  : Backend hangup error handling.
 
2016-02-05 15:56:30.138   error  : Backend hangup error handling.
 
2016-02-05 15:56:30.139   error  : Backend hangup error handling.
 
2016-02-05 15:56:30.140   error  : Backend hangup error handling.
 
2016-02-05 16:10:06.993   error  : Backend hangup error handling.
 
2016-02-05 16:10:06.993   error  : Backend hangup error handling.
 
2016-02-05 16:10:06.993   error  : Backend hangup error handling.
 
2016-02-05 16:10:07.014   error  : Backend hangup error handling.
 
2016-02-05 16:23:40.733   error  : Backend hangup error handling.
 
2016-02-05 16:23:40.733   error  : Backend hangup error handling.
 
2016-02-05 16:23:40.735   error  : Backend hangup error handling.
 
2016-02-05 16:23:40.736   error  : Backend hangup error handling.
 
2016-02-05 16:37:23.695   error  : Backend hangup error handling.
 
2016-02-05 16:37:23.695   error  : Backend hangup error handling.
 
2016-02-05 16:37:23.697   error  : Backend hangup error handling.
 
2016-02-05 16:37:23.699   error  : Backend hangup error handling.

The syslog of those Galera nodes looks like:

Feb  5 15:15:51 wsccms-db01f-prod mysqld: 160205 15:15:51 [Warning] Aborted connection 2539773 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:29:23 wsccms-db01f-prod mysqld: 160205 15:29:23 [Warning] Aborted connection 2541432 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:42:57 wsccms-db01f-prod mysqld: 160205 15:42:57 [Warning] Aborted connection 2543106 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:56:30 wsccms-db01f-prod mysqld: 160205 15:56:30 [Warning] Aborted connection 2544780 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 16:10:06 wsccms-db01f-prod mysqld: 160205 16:10:06 [Warning] Aborted connection 2546459 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 16:23:40 wsccms-db01f-prod mysqld: 160205 16:23:40 [Warning] Aborted connection 2548143 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 16:37:23 wsccms-db01f-prod mysqld: 160205 16:37:23 [Warning] Aborted connection 2549837 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:15:51 wsccms-db03f-prod mysqld: 160205 15:15:51 [Warning] Aborted connection 1695844 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:29:23 wsccms-db03f-prod mysqld: 160205 15:29:23 [Warning] Aborted connection 1696702 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:42:57 wsccms-db03f-prod mysqld: 160205 15:42:57 [Warning] Aborted connection 1697566 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:56:30 wsccms-db03f-prod mysqld: 160205 15:56:30 [Warning] Aborted connection 1698429 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 16:10:06 wsccms-db03f-prod mysqld: 160205 16:10:06 [Warning] Aborted connection 1699297 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 16:23:40 wsccms-db03f-prod mysqld: 160205 16:23:40 [Warning] Aborted connection 1700171 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 16:37:23 wsccms-db03f-prod mysqld: 160205 16:37:23 [Warning] Aborted connection 1701044 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 12:03:02 wsccms-db04f-prod mysqld: 160205 12:03:02 [Warning] Aborted connection 1683684 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 12:23:14 wsccms-db04f-prod mysqld: 160205 12:23:14 [Warning] Aborted connection 1684983 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 13:58:12 wsccms-db04f-prod mysqld: 160205 13:58:12 [Warning] Aborted connection 1691049 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 14:28:30 wsccms-db04f-prod mysqld: 160205 14:28:30 [Warning] Aborted connection 1692992 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 14:38:36 wsccms-db04f-prod mysqld: 160205 14:38:36 [Warning] Aborted connection 1693635 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 14:48:41 wsccms-db04f-prod mysqld: 160205 14:48:41 [Warning] Aborted connection 1694279 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:05:09 wsccms-db04f-prod mysqld: 160205 15:05:09 [Warning] Aborted connection 1681093 to db: 'unconnected' user: 'maxscalemon' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:15:51 wsccms-db04f-prod mysqld: 160205 15:15:51 [Warning] Aborted connection 1696031 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:29:23 wsccms-db04f-prod mysqld: 160205 15:29:23 [Warning] Aborted connection 1696889 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:42:57 wsccms-db04f-prod mysqld: 160205 15:42:57 [Warning] Aborted connection 1697753 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:56:30 wsccms-db04f-prod mysqld: 160205 15:56:30 [Warning] Aborted connection 1698618 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 16:10:06 wsccms-db04f-prod mysqld: 160205 16:10:06 [Warning] Aborted connection 1699486 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 16:23:40 wsccms-db04f-prod mysqld: 160205 16:23:40 [Warning] Aborted connection 1700360 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 16:37:23 wsccms-db04f-prod mysqld: 160205 16:37:23 [Warning] Aborted connection 1701235 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 11:12:25 wsccms-db05f-prod mysqld: 160205 11:12:25 [Warning] Aborted connection 3727084 to db: 'unconnected' user: 'maxscalemon' host: '10.0.249.211' (Unknown error)
 
Feb  5 11:22:38 wsccms-db05f-prod mysqld: 160205 11:22:38 [Warning] Aborted connection 3798430 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 11:32:43 wsccms-db05f-prod mysqld: 160205 11:32:43 [Warning] Aborted connection 3799067 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 11:42:49 wsccms-db05f-prod mysqld: 160205 11:42:49 [Warning] Aborted connection 3799712 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 11:52:55 wsccms-db05f-prod mysqld: 160205 11:52:55 [Warning] Aborted connection 3800362 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 12:03:01 wsccms-db05f-prod mysqld: 160205 12:03:01 [Warning] Aborted connection 3801007 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 12:13:07 wsccms-db05f-prod mysqld: 160205 12:13:07 [Warning] Aborted connection 3801662 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 12:23:13 wsccms-db05f-prod mysqld: 160205 12:23:13 [Warning] Aborted connection 3802306 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 12:33:19 wsccms-db05f-prod mysqld: 160205 12:33:19 [Warning] Aborted connection 3802949 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 12:43:24 wsccms-db05f-prod mysqld: 160205 12:43:24 [Warning] Aborted connection 3803591 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 12:57:37 wsccms-db05f-prod mysqld: 160205 12:57:37 [Warning] Aborted connection 3804497 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 13:07:43 wsccms-db05f-prod mysqld: 160205 13:07:43 [Warning] Aborted connection 3805143 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 13:17:48 wsccms-db05f-prod mysqld: 160205 13:17:48 [Warning] Aborted connection 3805797 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 13:27:54 wsccms-db05f-prod mysqld: 160205 13:27:54 [Warning] Aborted connection 3806439 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 13:37:59 wsccms-db05f-prod mysqld: 160205 13:37:59 [Warning] Aborted connection 3807082 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 13:48:05 wsccms-db05f-prod mysqld: 160205 13:48:05 [Warning] Aborted connection 3807725 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 13:58:11 wsccms-db05f-prod mysqld: 160205 13:58:11 [Warning] Aborted connection 3808370 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 14:08:17 wsccms-db05f-prod mysqld: 160205 14:08:17 [Warning] Aborted connection 3809011 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 14:18:23 wsccms-db05f-prod mysqld: 160205 14:18:23 [Warning] Aborted connection 3809666 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 14:28:29 wsccms-db05f-prod mysqld: 160205 14:28:29 [Warning] Aborted connection 3810311 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 14:38:34 wsccms-db05f-prod mysqld: 160205 14:38:34 [Warning] Aborted connection 3810954 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 14:48:40 wsccms-db05f-prod mysqld: 160205 14:48:40 [Warning] Aborted connection 3811598 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 14:58:47 wsccms-db05f-prod mysqld: 160205 14:58:47 [Warning] Aborted connection 3812242 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:05:09 wsccms-db05f-prod mysqld: 160205 15:05:09 [Warning] Aborted connection 3798418 to db: 'unconnected' user: 'maxscalemon' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:15:51 wsccms-db05f-prod mysqld: 160205 15:15:51 [Warning] Aborted connection 3813354 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:29:23 wsccms-db05f-prod mysqld: 160205 15:29:23 [Warning] Aborted connection 3814210 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:42:57 wsccms-db05f-prod mysqld: 160205 15:42:57 [Warning] Aborted connection 3815074 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 15:56:30 wsccms-db05f-prod mysqld: 160205 15:56:30 [Warning] Aborted connection 3815939 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 16:10:06 wsccms-db05f-prod mysqld: 160205 16:10:06 [Warning] Aborted connection 3816807 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 16:23:40 wsccms-db05f-prod mysqld: 160205 16:23:40 [Warning] Aborted connection 3817681 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)
 
Feb  5 16:37:23 wsccms-db05f-prod mysqld: 160205 16:37:23 [Warning] Aborted connection 3818556 to db: 'xoops_meta_db' user: 'admin' host: '10.0.249.211' (Unknown error)

It looks like each import causes 4 of those errors. Any idea what that could be?

 Comments   
Comment by Johan Wikman [ 2016-03-01 ]

Downgrading to minor as the importing works and those log entries are present only because it was a debug build.

Comment by Timofey Turenko [ 2016-03-31 ]

Tried to load big dump (about 3 GB):

vagrant@ns3014560:~$ mysql -uskysql -pskysql -h 192.168.121.234 -P 4006 test < spider_logs.sql 
ERROR 2013 (HY000) at line 2045: Lost connection to MySQL server during query

Maxscale logs says:

2016-03-30 17:58:04   error  : Backend hangup error handling.
 
2016-03-30 17:58:04   error  : Backend hangup error handling.
 
2016-03-30 17:58:04   error  : server 192.168.121.33:3306 lost the master status. Readwritesplit service can't locate the master. Client sessions will be closed.
 
2016-03-30 17:58:04   error  : Backend hangup -> closing session.

it took about 8 hours. Tested with 1.4.1.

Comment by Timofey Turenko [ 2016-04-01 ]

Tried to send directly to one of Galera nodes: it took more then 1 day without finishing (I aborted test at some point). So, it does not look like Maxscale problem.
Closing

Generated at Thu Feb 08 04:00:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.