Question

I just upgraded to FogBugz 7 and my server's CPU is pinned at 99%. I've turned on logging and it looks like the maintenance service is getting stuck on indexing a case that has an email with a big attachment.

I blacklisted that particular bug and things were okay for a little while, but now the CPU is pinned again. What should I do?

Answer 1

I found that, of all things, my connection string was the culprit. I'm running MySQL and my connection string looked like this:

Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;`

After I changed it to this:

Driver={mysql};Port=3306;Server=localhost;User=myUsername;Password=myPassword; Option=16387;Database=myDatabase

everything is back to normal!