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

sudden signal 6 abort after running for 2 days

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Cannot Reproduce
    • 1.1.0
    • 1.3.0
    • Core, qlafilter, topfilter
    • None
    • DISTRIB_ID=Ubuntu
      DISTRIB_RELEASE=14.04
      DISTRIB_CODENAME=trusty
      DISTRIB_DESCRIPTION="Ubuntu 14.04.2 LTS"

    Description

      Getting a signal 6 abort about 3 hours after getting authentication failures on a certain DB. I'm not able to estimate the significance of those auth. failures in relation to the signal 6. Pay attention to the event time (silent for almost 3 hrs ->@ 13:55:36 ).

      This actually never happend until now, uptime a few weeks. But I started using topfilter/qla filter recently, which is the only change I can think of. I cannot debug/trace/log due to issues described in #MXS-164 bug report.

      The permission problem warning disappeared now that I added the needed privileges. I also switched topfilter off for now.

      May 31 11:03:18 ttextlb1 MaxScale[18908]: Error : Invalid authentication message from backend. Error : 42000, Msg : Access denied for user 'ticketing'@'%' to database 'ticketingfrontend_crm2'
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Error : Backend server didn't accept authentication for user ticketing.
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: tim@% for database: ticketingfrontend_crm
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: tim@% for database: ticketingstaging
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: tim@% for database: ticketingstaging_crm
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: brenden@% for database: ticketingfrontend_crm
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: brenden@% for database: ticketingstaging
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: brenden@% for database: ticketingstaging_crm
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: logging@% for database: logmediaframe
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: logging@% for database: logstaging
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: logging@% for database: logticketing
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Error : Unable to write to backend due to authentication failure.
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Error : Invalid authentication message from backend. Error : 42000, Msg : Access denied for user 'ticketing'@'%' to database 'ticketingfrontend_crm2'
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Error : Backend server didn't accept authentication for user ticketing.
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: tim@% for database: ticketingfrontend_crm
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: tim@% for database: ticketingstaging
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: tim@% for database: ticketingstaging_crm
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: brenden@% for database: ticketingfrontend_crm
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: brenden@% for database: ticketingstaging
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: brenden@% for database: ticketingstaging_crm
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: logging@% for database: logmediaframe
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: logging@% for database: logstaging
      May 31 11:03:18 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: logging@% for database: logticketing
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Error : Invalid authentication message from backend. Error : 42000, Msg : Access denied for user 'ticketing'@'%' to database 'ticketingfrontend_crm2'
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Error : Backend server didn't accept authentication for user ticketing.
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: tim@% for database: ticketingfrontend_crm
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: tim@% for database: ticketingstaging
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: tim@% for database: ticketingstaging_crm
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: brenden@% for database: ticketingfrontend_crm
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: brenden@% for database: ticketingstaging
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: brenden@% for database: ticketingstaging_crm
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: logging@% for database: logmediaframe
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: logging@% for database: logstaging
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: logging@% for database: logticketing
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Error : Unable to write to backend due to authentication failure.
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: tim@% for database: ticketingfrontend_crm
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: tim@% for database: ticketingstaging
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: tim@% for database: ticketingstaging_crm
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: brenden@% for database: ticketingfrontend_crm
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: brenden@% for database: ticketingstaging
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: brenden@% for database: ticketingstaging_crm
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: logging@% for database: logmediaframe
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: logging@% for database: logstaging
      May 31 11:03:25 ttextlb1 MaxScale[18908]: Warning: Duplicate MySQL user found for service [RW Split Router]: logging@% for database: logticketing
      May 31 11:03:35 ttextlb1 MaxScale[18908]: Error : Invalid authentication message from backend. Error : 42000, Msg : Access denied for user 'ticketing'@'%' to database 'ticketingfrontend_crm2'
      May 31 11:03:35 ttextlb1 MaxScale[18908]: Error : Backend server didn't accept authentication for user ticketing.
      May 31 11:03:35 ttextlb1 MaxScale[18908]: RW Split Router: Refresh rate limit exceeded for load of users' table.
      May 31 11:03:35 ttextlb1 MaxScale[18908]: Error : Unable to write to backend due to authentication failure.
      May 31 11:03:35 ttextlb1 MaxScale[18908]: RW Split Router: Refresh rate limit exceeded for load of users' table.
      May 31 11:03:35 ttextlb1 MaxScale[18908]: Error : Unable to write to backend due to authentication failure.
      May 31 13:55:36 ttextlb1 MaxScale[18908]: Fatal: MaxScale received fatal signal 6. Attempting backtrace.
      May 31 13:55:36 ttextlb1 MaxScale[18908]: /usr/local/mariadb-maxscale/bin/maxscale() [0x5483e3]
      May 31 13:55:36 ttextlb1 MaxScale[18908]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x10340) [0x7f7e636b2340]
      May 31 13:55:36 ttextlb1 MaxScale[18908]: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x39) [0x7f7e622e9cc9]
      May 31 13:55:36 ttextlb1 MaxScale[18908]: /lib/x86_64-linux-gnu/libc.so.6(abort+0x148) [0x7f7e622ed0d8]
      May 31 13:55:36 ttextlb1 MaxScale[18908]: /lib/x86_64-linux-gnu/libc.so.6(+0x73394) [0x7f7e62326394]
      May 31 13:55:36 ttextlb1 MaxScale[18908]: /lib/x86_64-linux-gnu/libc.so.6(+0x7f66e) [0x7f7e6233266e]
      May 31 13:55:36 ttextlb1 MaxScale[18908]: /usr/local/mariadb-maxscale/modules/libtopfilter.so(+0x3d64) [0x7f7e4408fd64]
      May 31 13:55:36 ttextlb1 MaxScale[18908]: /usr/local/mariadb-maxscale/modules/libMySQLClient.so(+0x6ac6) [0x7f7e472ceac6]
      May 31 13:55:36 ttextlb1 MaxScale[18908]: /usr/local/mariadb-maxscale/modules/libMySQLClient.so(+0x57de) [0x7f7e472cd7de]
      May 31 13:55:36 ttextlb1 MaxScale[18908]: /usr/local/mariadb-maxscale/bin/maxscale() [0x55ac51]
      May 31 13:55:36 ttextlb1 MaxScale[18908]: /usr/local/mariadb-maxscale/bin/maxscale(poll_waitevents+0x6d4) [0x55a502]
      May 31 13:55:36 ttextlb1 MaxScale[18908]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x8182) [0x7f7e636aa182]
      May 31 13:55:36 ttextlb1 MaxScale[18908]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7f7e623ad47d]

      Attachments

        Issue Links

          Activity

            People

              markus makela markus makela
              gplv2 Glenn Plas
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.