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

    • 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

        3. MDEV-4576 - 5.5 without error.7z
          1.79 MB
          roberto spadim

        Activity

          Ascending order - Click to sort in descending order
          View 45 older comments
          rspadim roberto spadim added a comment -

          downloaded, i will start tests

          rspadim roberto spadim added a comment - downloaded, i will start tests
          rspadim roberto spadim added a comment -

          2640 queries and no error....
          i will test more times and send a procmon to ensure that mdev was solved =]

          rspadim roberto spadim added a comment - 2640 queries and no error.... i will test more times and send a procmon to ensure that mdev was solved =]
          rspadim roberto spadim added a comment -

          procmon xml file, used 7z compression with ultra, since zip was 50MB and couldn't be uploaded (max of 10MB in jira)
          the xml have 850MB
          the patch worked and no error was sent to mysql client, temporary files are deleted from temporary path
          now everything is ok =) very nice job vladislav! thanks!

          rspadim roberto spadim added a comment - procmon xml file, used 7z compression with ultra, since zip was 50MB and couldn't be uploaded (max of 10MB in jira) the xml have 850MB the patch worked and no error was sent to mysql client, temporary files are deleted from temporary path now everything is ok =) very nice job vladislav! thanks!
          rspadim roberto spadim added a comment -

          check that 10.0.3 have the same problem

          rspadim roberto spadim added a comment - check that 10.0.3 have the same problem
          wlad Vladislav Vaintroub added a comment -

          fixed in 5.5 (all fixes are merged up to higher version, so it will be in 10.0 too)

          wlad Vladislav Vaintroub added a comment - fixed in 5.5 (all fixes are merged up to higher version, so it will be in 10.0 too)

          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.