FogBugz Technical Support

A forum for technical support discussion related to Fogbugz.
The current FogBugz Knowledge Base can be found at http://help.fogcreek.com/fogbugz.

Posts by Fog Creek Employees are marked:

Documentation
Release Notes
Network Status

"Can't create/write to file" errors

I'm getting this error all the time. When trying to access a case, or any other FogBugz page, there's about a 20% chance of getting the "FogBugz Internal Error" page. The error message is
"[MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Can't create/write to file 'C:\WINDOWS\TEMP\#sql_1ac4_0.MYD' (Errcode: 13), ".
I'm using IE7.
Any ideas?
Niels-Peter Vest Nielsen
Monday, December 17, 2007
 
 
I'm not entirely sure.  I'd been seeing that error pop up in our BugzScout logs, but you didn't include your email address so I couldn't get in contact with you. 

My guess is it has something to do with MySQL.  When I see an error message with .MYD or .MYI, it often has to do with MySQL getting corrupted somehow.  Although it's weird that it's happening on a temp database table - normally I see error messages relating to writing to Bug.MYI or BugEvent.MYI.

I'm not sure why MySQL would be writing to the windows temp directory, but maybe you can just add read/write permissions for the FogBugz user to that directory to fix the issue?
Eric Nehrlich Send private email
Monday, December 17, 2007
 
 
Thanks for the reply. We tried giving the FogBugz user read and write permissions to c:\windowstemp, but it didn't help.
Could it be some sort of timeout? It doesn't fail all the time, so it is something that varies...
The problem started when we update to FogBugz 6, by the way.
Niels-Peter Vest Nielsen
Tuesday, December 18, 2007
 
 
I'm wondering if the search tool is what is failing to have permission, and I want to make sure it's registered as the correct user.

Can you try reregistering the FogBugz DLLs (and especially the SearchTool)?  Go to FogBugz/Accessories in a command window, run:
register.bat /u

to unregister the DLLs and then:
register.bat

to re-register.  While running that register.bat script a dialog box will pop up asking for a username - make sure to enter the FogBugz username and password along with either the local machine name or the domain name.
Eric Nehrlich Send private email
Wednesday, December 19, 2007
 
 
An update: It seems that the problem lies with MySQL, somehow.

When we upgraded to FogBugz 6, the installer reported failure during update of the database. When I started FogBugz afterward, it updated the database without reporting any problems, but then we started getting the "can't create/write to file" errors.
Upon closer investigation, we found that we had trouble accessing the database via the MySQL Administrator, and that our backup was failing.
We have run and re-run repairs several times on the database, and this seems to have helped somwhat; we can now use the Administrator, and we haven't seen the "can't create/write to file" for some days.

Our conclusion is that the either the database had problems already, or the FogBugz update corrupted the database. Using the MySQL repair utilities iteratively has helped to the point where the system is usable. We plan to move to Microsoft SQL later this year, so we will not pursue this issue further.

Thanks for your kind assistance.
Niels-Peter Vest Nielsen
Tuesday, January 8, 2008
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz Bug Tracking and Evidence-Based Scheduling.