Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-570

Loading database dump through readwritesplit causes error messages

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Cannot Reproduce
    • 1.3.0
    • 1.4.1
    • readwritesplit
    • None

    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?

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              markus makela markus makela
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.