Details
-
Type:
Bug
-
Status: Closed
-
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
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
downloaded, i will start tests
2640 queries and no error....
i will test more times and send a procmon to ensure that mdev was solved =]
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!
check that 10.0.3 have the same problem
fixed in 5.5 (all fixes are merged up to higher version, so it will be in 10.0 too)
Hi Roberto,
Please try to do the same with other tables in information schema – it's about the first problem you reported.
Please do not report several unrelated problems in one bug report, only one (at best) will be addressed.
Please do not raise JIRA issues for questions that are neither bugs or tasks. There are a mailing list and IRC for that.
Thanks.