i am using Umbraco 7.3.7 with Mysql database, i am getting random 500 Internal Server Errors on various resources (refreshing may fix it for that resource, but then random other resources then error). As this is my personal development machine, I have set the root folder permissions to allow full access to everyone, so can't see how it is denied access (the fact that some resources work would also suggest it's not permissions).

things i have tired:

1. reinstalled iis express,webmatrix and umbraco.
2. full access to every user.
3. enable 32 bit applications true in DefaultAppPool.

Software configuration:
windows 10 pro 64bit umbraco 7.3.7 IIS express 8.0

Exception Details: MySql.Data.MySqlClient.MySqlException: You can't specify target table 'umbracoCacheInstruction' for update in FROM clause

[MySqlException (0x80004005): You can't specify target table 'umbracoCacheInstruction' for update in FROM clause]
   MySql.Data.MySqlClient.MySqlStream.ReadPacket() +272
   MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) +68
   MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) +17
   MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) +110
   MySql.Data.MySqlClient.MySqlDataReader.NextResult() +783
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1564
   MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() +118
   StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() +60
   Umbraco.Core.Persistence.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0() +55
   Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction(Func`1 func) +170
   Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy) +118
   Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy) +52
   Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command) +48
   Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) +180
   Umbraco.Core.Persistence.Database.Execute(Sql sql) +40
   Umbraco.Core.Sync.DatabaseServerMessenger.PruneOldInstructions() +423
   Umbraco.Core.Sync.DatabaseServerMessenger.Sync() +387
   Umbraco.Web.BatchedDatabaseServerMessenger.UmbracoModule_RouteAttempt(Object sender, RoutableAttemptEventArgs e) +32
   Umbraco.Web.UmbracoModule.OnRouteAttempt(RoutableAttemptEventArgs args) +22
   Umbraco.Web.UmbracoModule.ProcessRequest(HttpContextBase httpContext) +256
   Umbraco.Web.UmbracoModule.<Init>b__8(Object sender, EventArgs e) +80
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +141
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +69