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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.3, 5.5.31
    • 5.5.32
    • None
    • None
    • 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

            wlad Vladislav Vaintroub
            rspadim roberto spadim
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.