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

I_S temporary table files aren't deleted in Windows - USING ANTIVIRUS

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.3, 5.5.31
    • Fix Version/s: 5.5.32
    • Component/s: None
    • Labels:
      None
    • Environment:
      windows 7 32bits pt-br

      Description

      "select * from <information_schema_table_with_problem>"
      Many times per second (press f5 in heidisql and leave pressed) or run many commands in mysql command line

      Give errors some times, errcode=13 (no permission?) sql err=6 (problem deleting file) , and files stay in filesystem "forever", only with admin tasks we can remove the file

      show warnings
      "Level" "Code" "Message"
      "Error" "6" "Error on delete of 'C:\Users\Beto\AppData\Local\Temp#sqlc24_7_1a6.MAD' (Errcode: 13)"


      temporary file isn't deleted
      my temporary folder have about 10 files like this
      #sqlc24_7_16e.MAD
      #sqlc24_7_16c.MAD
      #sqlc24_7_2d4.MAD
      #sqlc24_7_2b8.MAD


      <information_schema_table_with_problem> are (in mariadb10.0.2):
      QUERY_CACHE_INFORMATION (qc_info without patch of MDEV-4581)
      STATISTICS
      EVENTS
      KEY_COLUMN_USAGE
      PARAMETERS
      PARTITIONS
      PLUGINS
      REFERENTIAL_CONSTRAINTS
      ROUTINES
      TABLES
      TABLE_CONSTRAINTS
      TRIGGERS

        Attachments

        1. MDEV-4576.zip
          4.38 MB
        2. MDEV-4576 - 5.5 patch.XML.zip
          150 kB
        3. MDEV-4576 - 5.5 without error.7z
          1.79 MB
        4. MDEV-4576 - antivirus included.zip
          376 kB
        5. MDEV-4576 - antivirus included external locking.zip
          2.17 MB
        6. mysqld.zip
          8.96 MB
        7. mysqld-5.5.zip
          9.02 MB

          Activity

            People

            • Assignee:
              wlad Vladislav Vaintroub
              Reporter:
              rspadim roberto spadim
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved: