Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bug alert!? LOAD_FILE files are kept open.

Status
Not open for further replies.
TonyGroves

TonyGroves

Programmer
Aug 13, 2003
2,389
IE
It seems that when I do an UPDATE or INSERT query which uses a LOAD_FILE assignment, the file referred to in the LOAD_FILE call is not closed when the loading is finished, but is kept open by the MySQL server for the duration of the connection.

As you can imagine, this can be a serious problem when a program has to do many LOAD_FILE operations, as an extra file gets opened each time, and never closed until the end of the session.

Has anybody else noticed this, and know if it is a recognised bug? I am using MySQL 4.0.13.
 
Sort by date Sort by votes
Sorry, false alarm!

It was a bug in my program. Apologies to the MySQL people for casting aspersions on the fruits of their labour!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
490
spamjim
spamjim
PeDa
  • Locked
  • Question
Opening MySQL table from Microsoft Access
Replies
1
Views
209
PeDa
PeDa
BJZeak
  • Locked
  • Question
Looking for direction, preferably Open Source Option, to replace 20+ yr old MS ACCESS Apps
Replies
3
Views
145
spamjim
spamjim
Makino
  • Locked
  • Question
Access can't open MariaDB connected tables
Replies
0
Views
100
Makino
Makino
Auguy
  • Locked
  • Question
Why Are There Duplicate Data Types 1
Replies
14
Views
121
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top