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

Some records are not updated on storage engine (innodb) but exist on binary log

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.0.38
    • N/A
    • None
    • OS: CentOS release 6.7 (Final)
      Application: Node v0.12.12

    Description

      I have a nodejs application that build a query to update records on my table.

      In the binary logs there is a transaction that occurred but in the storage engine (innodb) it did not update.

      for example in the binary log, the transaction is like this. but the id with 2 and 3 are not updated in the storage engine(innodb).

      BEGIN
      UPDATE my_table SET status = 1, updated_at = NOW() WHERE id = 1
      UPDATE my_table SET status = 1, updated_at = NOW() WHERE id = 2
      UPDATE my_table SET status = 1, updated_at = NOW() WHERE id = 3
      UPDATE my_table SET status = 1, updated_at = NOW() WHERE id = 4
      UPDATE my_table SET status = 1, updated_at = NOW() WHERE id = 5
      COMMIT

      Attachments

        Activity

          People

            Unassigned Unassigned
            michaelvelayo Michael Velayo
            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.