c# - Very strange MySQL timeouts occurring on just one developer machine -


i'm not optimistic getting answer one, since it's such weird , seemingly machine-specific issue, i'm posting in hopes else has figured 1 out.

i'm developing application in c# using visual studio , mysql.data ado.net driver (version 6.9.8) database access. twice, i've run situation simple sql queries worked moments before start timing out. point forward, never succeed again -- on machine. every other query in application (and there hundreds) works fine, 1 query, if change slightly, never works again. if push code , developer runs it, code works on machine.

as example of how simple these queries are, here's 1 i'm having issues with:

select * user_preferences (user_id=@user_id) limit 1 

the table i'm selecting has 1 row , 4 columns. couldn't simpler. while query waiting time out, not appear in process list mysql, have assume either never made server or server returned instantly , mysql connector failing return response. i'd figure out which, doubt make difference either way.

so summarize, query worked fine morning. changed nothing except unrelated code, , briefly started returning no data. started debugging it, , times out. developer runs code, , works perfectly.

i'm @ complete loss, here. short of figuring out, fear i'm going have re-image laptop, , i'd avoid if @ possible. appreciated, though said, it's quite shot in dark.

edit: c# code in question:

using (var connection = new mysqlconnection(connectionsettings.getconnectionstring()))                 {                     await connection.openasync(cancellationtoken);                     using (var reader = await mysqlhelper.executereaderasync(connection, sql.query.tostring(), cancellationtoken, sql.parameters.toarray()))                     {                         while (await reader.readasync(cancellationtoken))                         {                             readeraction(reader);                         }                     }                 } 


Comments

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

Enable autocomplete or intellisense in Atom editor for PHP -