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

Could not remove temporary table: ... error: 0

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: 8.0.x
    • Fix Version/s: None
    • Component/s: TokuDB
    • Labels:
      None

      Description

      # mysqld options required for replay: --plugin-load=TokuDB=ha_tokudb.so --log-bin --server-id=0 
      CREATE DATABASE test;
      USE test;
      XA START 'xa3';
      CREATE TEMPORARY TABLE t1(a INT)ENGINE=TokuDB;
      INSERT INTO t1 VALUES(8385959.0000003);
      BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8='; 

      Fully succeeds inc

      8.0.13>BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
      Query OK, 0 rows affected (4.03 sec)
      

      Yet, in the error log:

      2018-12-19T10:34:29.603333Z 8 [ERROR] [MY-000000] [Server] Plugin tokudb reported: 'Could not delete table /sda/PS191218-percona-server-8.0.13-2-linux-x86_64-opt/data/#sql4747_8_0 because another transaction has accessed the table. To drop the table, make sure no transactions touch the table.'
      2018-12-19T10:34:29.603388Z 8 [Warning] [MY-010726] [Server] Could not remove temporary table: '/sda/PS191218-percona-server-8.0.13-2-linux-x86_64-opt/data/#sql4747_8_0', error: 0 

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned
                Reporter:
                roel.vandepaar Roel Van de Paar (Inactive)
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 20 minutes
                    20m