Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16162

Unexplained sql error logging behavior

    XMLWordPrintable

Details

    Description

      I posted this last week to open questions and have not gotten a reply, so I am opening a ticket in the hopes someone can point me in the right direction. Any assistance so I can resolve this is greatly appreciated.

      I have three servers. One master and two are slaves. I have a process that does an insert ignore the master and then does it again 5 seconds later to ensure the row has been written.

      The servers are MariaDB 5.5.50 (CentOS 7.3) and 5.5.34 (CentOS 6.5).

      A few weeks ago after making no changes what so ever, one of the slaves started logging the 1062 error(s) to the sql_errrors.log and I can not figure out why.

      If I check the binary log on all three servers, I can find the insert ignore and the second one 5 seconds later on all three servers, so I know it is being executed everywhere.

      I have diffed the server configs to make sure they are all the same.

      Compared the mysql database between the servers for any differences.

      I have logged in as the replication account and checked:

      show variables like 'sql_error%';
      show variables like '%mode%'; all settings return the same.

      Can someone point me at anything else I can check to understand why the behavior for the one slave changed?

      Attachments

        Activity

          People

            Unassigned Unassigned
            lpatrick Lori Patrick
            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.