Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-1816

LP #1711781: Redundant GTID unsafe mark for CREATE/DROP TEMPORARY TABLE in RBR/MBR

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Nickolay Ihalainen last update 28-09-2017 15:00:23

      Temporary tables are not logged in binlog for RBR after:
      https://bugs.launchpad.net/percona-server/+bug/1668602

      This makes tests passing for: https://bugs.mysql.com/bug.php?id=77354
      even with:

      @@ -11005,7 +11005,8 @@ bool THD::is_ddl_gtid_compatible()
      GTID even if the transaction is rolled back.
      This includes the execution inside Functions and Triggers.
      */

      • if (in_multi_stmt_transaction_mode() || in_sub_stmt)
        + if ((in_multi_stmt_transaction_mode() || in_sub_stmt)
        + && !is_current_stmt_binlog_format_row())

      Patch provided by customer fixes forever-opened Hibernate bug related to gtid and temporary tables inside transactions:
      https://hibernate.atlassian.net/browse/HHH-9289

      The bug is not applicable for upstream, because
      https://bugs.mysql.com/bug.php?id=85258 still not applied

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: