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