MySQL: Queries created after the commit at 013859ms are still returning #2 for a time examples: 00740:003, 00740:003, 08180:016, 00753:022, 01960:005, 05683:012 <> 15:12:44:997 013814ms [00128:001:Main] End thread 15:12:44:997 013815ms [01363:023:Main] End thread 15:12:44:997 013817ms [01974:024:Main] Start thread 15:12:44:997 013806ms [07553:014:ReadLastRecordID] Before scope 15:12:44:997 013819ms [08800:017:Main] End thread 15:12:44:997 013808ms [08179:016:ReadLastRecordID] After scope dispose 15:12:44:997 013785ms [00100:021:InsertRecord_EF_Scoped] After save #3 ******************************************* 15:12:44:997 013812ms [09425:018:ReadLastRecordID] Before context 15:12:44:997 013790ms [06306:013:ReadLastRecordID] Before scope 15:12:44:997 013830ms [04432:010:ReadLastRecordID] After scope dispose 15:12:44:997 013830ms [03804:011:ReadLastRecordID] Last person id #2 15:12:44:997 013831ms [01364:023:Main] Start thread 15:12:44:997 013832ms [01974:024:ReadLastRecordID] Before scope 15:12:44:997 013771ms [00739:003:ReadLastRecordID] After scope dispose 15:12:44:997 013835ms [07553:014:ReadLastRecordID] Before context 15:12:44:997 013835ms [05682:012:ReadLastRecordID] After scope dispose 15:12:44:997 013820ms [02559:007:ReadLastRecordID] Last person id #2 15:12:44:997 013836ms [08801:017:Main] Start thread 15:12:44:997 013836ms [01355:006:ReadLastRecordID] Last person id #2 15:12:44:997 013821ms [05055:008:Main] Start thread 15:12:44:997 013837ms [01959:005:ReadLastRecordID] Last person id #2 15:12:44:997 013837ms [08179:016:Main] End thread 15:12:44:997 013798ms [03184:009:ReadLastRecordID] Last person id #2 15:12:44:997 013839ms [00100:021:InsertRecord_EF_Scoped] Before complete 15:12:44:997 013826ms [02575:025:ReadLastRecordID] Before context 15:12:44:997 013840ms [09425:018:ReadLastRecordID] Before query 15:12:44:997 013768ms [06930:015:ReadLastRecordID] Before context 15:12:44:997 013841ms [06306:013:ReadLastRecordID] Before context 15:12:44:997 013829ms [00129:001:Main] Start thread 15:12:44:997 013842ms [04432:010:Main] End thread 15:12:44:997 013804ms [00752:022:ReadLastRecordID] After scope dispose 15:12:44:997 013817ms [00126:019:ReadLastRecordID] After scope dispose 15:12:44:997 013844ms [01364:023:ReadLastRecordID] Before scope 15:12:44:997 013859ms [00739:003:Main] End thread 15:12:44:997 013859ms [05682:012:Main] End thread 15:12:44:997 013859ms [06930:015:ReadLastRecordID] Before query 15:12:44:997 013859ms [04433:010:Main] Start thread 15:12:44:997 013859ms [00126:019:Main] End thread 15:12:44:997 013859ms [00752:022:Main] End thread 15:12:44:997 013859ms [00100:021:InsertRecord_EF_Scoped] After Complete ******************************************* 15:12:44:997 013860ms [01974:024:ReadLastRecordID] Before context 15:12:44:997 013859ms [00129:001:ReadLastRecordID] Before scope 15:12:44:997 013862ms [00740:003:Main] Start thread 15:12:44:997 013859ms [07553:014:ReadLastRecordID] Before query 15:12:44:997 013859ms [05055:008:ReadLastRecordID] Before scope 15:12:44:997 013859ms [06306:013:ReadLastRecordID] Before query 15:12:44:997 013868ms [03184:009:ReadLastRecordID] After scope dispose 15:12:44:997 013868ms [01959:005:ReadLastRecordID] After scope dispose 15:12:44:997 013859ms [01364:023:ReadLastRecordID] Before context 15:12:44:997 013870ms [00143:019:Main] Start thread 15:12:44:997 013859ms [08801:017:ReadLastRecordID] Before scope 15:12:44:997 013860ms [02575:025:ReadLastRecordID] Before query 15:12:44:997 013859ms [08180:016:Main] Start thread 15:12:44:997 013875ms [00740:003:ReadLastRecordID] Before scope 15:12:44:997 013875ms [00129:001:ReadLastRecordID] Before context 15:12:44:997 013878ms [05055:008:ReadLastRecordID] Before context 15:12:44:997 013868ms [02559:007:ReadLastRecordID] After scope dispose 15:12:44:997 013880ms [03184:009:Main] End thread 15:12:44:997 013881ms [01959:005:Main] End thread 15:12:44:997 013882ms [01364:023:ReadLastRecordID] Before query 15:12:44:997 013884ms [00143:019:ReadLastRecordID] Before scope 15:12:44:997 013885ms [08801:017:ReadLastRecordID] Before context 15:12:44:997 013887ms [07553:014:ReadLastRecordID] Last person id #2 15:12:44:997 013888ms [08180:016:ReadLastRecordID] Before scope 15:12:44:997 013889ms [00740:003:ReadLastRecordID] Before context 15:12:44:997 013867ms [04433:010:ReadLastRecordID] Before scope 15:12:44:997 013892ms [05055:008:ReadLastRecordID] Before query 15:12:44:997 013868ms [01355:006:ReadLastRecordID] After scope dispose 15:12:44:997 013894ms [02559:007:Main] End thread 15:12:44:997 013870ms [00753:022:Main] Start thread 15:12:44:997 013895ms [01960:005:Main] Start thread 15:12:44:997 013896ms [02575:025:ReadLastRecordID] Last person id #2 15:12:44:997 013871ms [09425:018:ReadLastRecordID] Last person id #2 15:12:44:997 013897ms [00143:019:ReadLastRecordID] Before context 15:12:44:997 013873ms [01974:024:ReadLastRecordID] Before query 15:12:44:997 013899ms [08801:017:ReadLastRecordID] Before query 15:12:44:997 013863ms [03804:011:ReadLastRecordID] After scope dispose 15:12:44:997 013864ms [05683:012:Main] Start thread 15:12:44:997 013900ms [08180:016:ReadLastRecordID] Before context 15:12:44:997 013890ms [06306:013:ReadLastRecordID] Last person id #2 15:12:44:997 013902ms [00740:003:ReadLastRecordID] Before query 15:12:44:997 013879ms [06930:015:ReadLastRecordID] Last person id #2 15:12:44:997 013903ms [04433:010:ReadLastRecordID] Before context 15:12:44:997 013904ms [01364:023:ReadLastRecordID] Last person id #2 15:12:44:997 013892ms [00129:001:ReadLastRecordID] Before query 15:12:44:997 013905ms [07553:014:ReadLastRecordID] After scope dispose 15:12:44:997 013894ms [03185:009:Main] Start thread 15:12:44:997 013906ms [01355:006:Main] End thread 15:12:44:997 013920ms [01356:006:Main] Start thread 15:12:44:997 013920ms [00143:019:ReadLastRecordID] Before query 15:12:44:997 013920ms [03804:011:Main] End thread 15:12:44:997 013933ms [03805:011:Main] Start thread 15:12:44:997 013920ms [00753:022:ReadLastRecordID] Before scope 15:12:44:997 013920ms [01960:005:ReadLastRecordID] Before scope 15:12:44:997 013924ms [01356:006:ReadLastRecordID] Before scope 15:12:44:997 013920ms [08180:016:ReadLastRecordID] Before query 15:12:44:997 013933ms [06930:015:ReadLastRecordID] After scope dispose 15:12:44:997 013934ms [02575:025:ReadLastRecordID] After scope dispose 15:12:44:997 013920ms [04433:010:ReadLastRecordID] Before query 15:12:44:997 013920ms [02560:007:Main] Start thread 15:12:44:997 013938ms [01974:024:ReadLastRecordID] Last person id #2 15:12:45:239 013938ms [05055:008:ReadLastRecordID] Last person id #2 15:12:45:239 013920ms [07553:014:Main] End thread 15:12:45:239 013939ms [01960:005:ReadLastRecordID] Before context 15:12:45:239 013940ms [08801:017:ReadLastRecordID] Last person id #2 15:12:45:239 013920ms [05683:012:ReadLastRecordID] Before scope 15:12:45:239 013940ms [01356:006:ReadLastRecordID] Before context 15:12:45:239 013920ms [03185:009:ReadLastRecordID] Before scope 15:12:45:239 013942ms [00143:019:ReadLastRecordID] Last person id #2 15:12:45:239 013934ms [01364:023:ReadLastRecordID] After scope dispose 15:12:45:239 013943ms [06930:015:Main] End thread 15:12:45:239 013934ms [09425:018:ReadLastRecordID] After scope dispose 15:12:45:239 013945ms [02575:025:Main] End thread 15:12:45:239 013935ms [03805:011:ReadLastRecordID] Before scope 15:12:45:239 013937ms [00753:022:ReadLastRecordID] Before context 15:12:45:239 013948ms [02560:007:ReadLastRecordID] Before scope 15:12:45:239 013938ms [06306:013:ReadLastRecordID] After scope dispose 15:12:45:239 013961ms [01960:005:ReadLastRecordID] Before query 15:12:45:239 013961ms [07554:014:Main] Start thread 15:12:45:239 013961ms [09425:018:Main] End thread 15:12:45:239 013961ms [06306:013:Main] End thread 15:12:45:239 013961ms [05683:012:ReadLastRecordID] Before context 15:12:45:239 013961ms [03805:011:ReadLastRecordID] Before context 15:12:45:239 013961ms [02560:007:ReadLastRecordID] Before context 15:12:45:239 013961ms [03185:009:ReadLastRecordID] Before context 15:12:45:239 013961ms [08180:016:ReadLastRecordID] Last person id #2 15:12:45:239 013961ms [01364:023:Main] End thread 15:12:45:239 013961ms [01356:006:ReadLastRecordID] Before query 15:12:45:239 013961ms [00753:022:ReadLastRecordID] Before query 15:12:45:239 013961ms [06931:015:Main] Start thread 15:12:45:239 013962ms [02576:025:Main] Start thread 15:12:45:239 013973ms [07554:014:ReadLastRecordID] Before scope 15:12:45:239 013973ms [06931:015:ReadLastRecordID] Before scope 15:12:45:239 013973ms [03805:011:ReadLastRecordID] Before query 15:12:45:239 013973ms [09426:018:Main] Start thread 15:12:45:239 013974ms [01365:023:Main] Start thread 15:12:45:239 013977ms [01974:024:ReadLastRecordID] After scope dispose 15:12:45:239 013979ms [08801:017:ReadLastRecordID] After scope dispose 15:12:45:239 013979ms [05055:008:ReadLastRecordID] After scope dispose 15:12:45:239 013973ms [05683:012:ReadLastRecordID] Before query 15:12:45:239 013980ms [00740:003:ReadLastRecordID] Last person id #2 15:12:45:239 013973ms [02560:007:ReadLastRecordID] Before query 15:12:45:239 013973ms [03185:009:ReadLastRecordID] Before query 15:12:45:239 013974ms [02576:025:ReadLastRecordID] Before scope 15:12:45:239 013973ms [06307:013:Main] Start thread 15:12:45:239 013988ms [00753:022:ReadLastRecordID] Last person id #2 15:12:45:239 013989ms [08801:017:Main] End thread 15:12:45:239 013990ms [05055:008:Main] End thread 15:12:45:239 013991ms [01356:006:ReadLastRecordID] Last person id #2 15:12:45:239 013993ms [03805:011:ReadLastRecordID] Last person id #2 15:12:45:239 013983ms [08180:016:ReadLastRecordID] After scope dispose 15:12:45:239 013998ms [01960:005:ReadLastRecordID] Last person id #2 15:12:45:239 013999ms [02576:025:ReadLastRecordID] Before context 15:12:45:239 014001ms [06307:013:ReadLastRecordID] Before scope 15:12:45:239 014002ms [00740:003:ReadLastRecordID] After scope dispose 15:12:45:239 013980ms [04433:010:ReadLastRecordID] Last person id #2 15:12:45:239 014006ms [05056:008:Main] Start thread 15:12:45:239 013980ms [06931:015:ReadLastRecordID] Before context 15:12:45:239 013981ms [00143:019:ReadLastRecordID] After scope dispose 15:12:45:239 014009ms [00753:022:ReadLastRecordID] After scope dispose 15:12:45:239 013984ms [09426:018:ReadLastRecordID] Before scope 15:12:45:239 014009ms [08180:016:Main] End thread 15:12:45:239 013985ms [01365:023:ReadLastRecordID] Before scope 15:12:45:239 014011ms [03185:009:ReadLastRecordID] Last person id #2 15:12:45:239 013988ms [01974:024:Main] End thread 15:12:45:239 014013ms [02576:025:ReadLastRecordID] Before query 15:12:45:239 014013ms [01356:006:ReadLastRecordID] After scope dispose 15:12:45:239 014002ms [05683:012:ReadLastRecordID] Last person id #2 15:12:45:239 014014ms [06307:013:ReadLastRecordID] Before context 15:12:45:239 014014ms [03805:011:ReadLastRecordID] After scope dispose 15:12:45:239 013979ms [07554:014:ReadLastRecordID] Before context 15:12:45:239 014015ms [00740:003:Main] End thread 15:12:45:239 014004ms [08802:017:Main] Start thread 15:12:45:239 014017ms [01960:005:ReadLastRecordID] After scope dispose 15:12:45:239 014006ms [02560:007:ReadLastRecordID] Last person id #2 15:12:45:239 014018ms [05056:008:ReadLastRecordID] Before scope 15:12:45:239 014032ms [09426:018:ReadLastRecordID] Before context 15:12:45:239 014031ms [07554:014:ReadLastRecordID] Before query 15:12:45:239 014031ms [06931:015:ReadLastRecordID] Before query 15:12:45:239 014032ms [05056:008:ReadLastRecordID] Before context 15:12:45:239 014031ms [01356:006:Main] End thread 15:12:45:239 014031ms [01960:005:Main] End thread 15:12:45:239 014032ms [00143:019:Main] End thread 15:12:45:239 014031ms [00741:003:Main] Start thread 15:12:45:239 014032ms [00753:022:Main] End thread 15:12:45:239 014032ms [01975:024:Main] Start thread 15:12:45:239 014031ms [08181:016:Main] Start thread 15:12:45:239 014032ms [01365:023:ReadLastRecordID] Before context 15:12:45:239 014031ms [08802:017:ReadLastRecordID] Before scope 15:12:45:239 014034ms [09426:018:ReadLastRecordID] Before query 15:12:45:239 014031ms [03805:011:Main] End thread 15:12:45:239 014037ms [04433:010:ReadLastRecordID] After scope dispose 15:12:45:239 014031ms [06307:013:ReadLastRecordID] Before query 15:12:45:239 014048ms [01961:005:Main] Start thread 15:12:45:239 014048ms [08802:017:ReadLastRecordID] Before context 15:12:45:239 014048ms [03806:011:Main] Start thread 15:12:45:239 014048ms [05683:012:ReadLastRecordID] After scope dispose 15:12:45:239 014048ms [01365:023:ReadLastRecordID] Before query 15:12:45:239 014048ms [03185:009:ReadLastRecordID] After scope dispose 15:12:45:239 014048ms [00741:003:ReadLastRecordID] Before scope 15:12:45:239 014048ms [00144:019:Main] Start thread 15:12:45:239 014052ms [02560:007:ReadLastRecordID] After scope dispose 15:12:45:239 014048ms [08181:016:ReadLastRecordID] Before scope 15:12:45:239 014053ms [08802:017:ReadLastRecordID] Before query 15:12:45:239 014063ms [00144:019:ReadLastRecordID] Before scope 15:12:45:239 014051ms [01961:005:ReadLastRecordID] Before scope 15:12:45:239 014048ms [01357:006:Main] Start thread 15:12:45:239 014061ms [00741:003:ReadLastRecordID] Before context 15:12:45:239 014060ms [03185:009:Main] End thread 15:12:45:239 014048ms [05056:008:ReadLastRecordID] Before query 15:12:45:239 014059ms [09426:018:ReadLastRecordID] Last person id #2 15:12:45:239 014056ms [05683:012:Main] End thread 15:12:45:239 014055ms [06931:015:ReadLastRecordID] Last person id #2 15:12:45:239 014066ms [08181:016:ReadLastRecordID] Before context 15:12:45:239 014067ms [00144:019:ReadLastRecordID] Before context 15:12:45:239 014064ms [02560:007:Main] End thread 15:12:45:239 014052ms [02576:025:ReadLastRecordID] Last person id #2 15:12:45:239 014061ms [06307:013:ReadLastRecordID] Last person id #3 15:12:45:239 014059ms [00100:021:InsertRecord_EF_Scoped] After scope dispose 15:12:45:239 014048ms [00754:022:Main] Start thread 15:12:45:239 014076ms [08802:017:ReadLastRecordID] Last person id #3 15:12:45:239 014077ms [05684:012:Main] Start thread 15:12:45:239 014054ms [03806:011:ReadLastRecordID] Before scope 15:12:45:239 014048ms [04433:010:Main] End thread 15:12:45:239 014080ms [08181:016:ReadLastRecordID] Before query 15:12:45:239 014068ms [01365:023:ReadLastRecordID] Last person id #3 15:12:45:239 014081ms [00144:019:ReadLastRecordID] Before query 15:12:45:239 014081ms [09426:018:ReadLastRecordID] After scope dispose 15:12:45:239 014069ms [01961:005:ReadLastRecordID] Before context 15:12:45:239 014082ms [02591:007:Main] Start thread 15:12:45:239 014070ms [01357:006:ReadLastRecordID] Before scope 15:12:45:239 014084ms [06931:015:ReadLastRecordID] After scope dispose 15:12:45:239 014072ms [00741:003:ReadLastRecordID] Before query 15:12:45:239 014073ms [03186:009:Main] Start thread 15:12:45:239 014086ms [00100:021:Main] End thread 15:12:45:239 014087ms [05056:008:ReadLastRecordID] Last person id #3 15:12:45:239 014057ms [07554:014:ReadLastRecordID] Last person id #2 15:12:45:239 014088ms [00754:022:ReadLastRecordID] Before scope 15:12:45:239 014048ms [01975:024:ReadLastRecordID] Before scope 15:12:45:239 014089ms [02576:025:ReadLastRecordID] After scope dispose 15:12:45:239 014102ms [03186:009:ReadLastRecordID] Before scope 15:12:45:239 014102ms [00754:022:ReadLastRecordID] Before context 15:12:45:239 014102ms [06307:013:ReadLastRecordID] After scope dispose 15:12:45:239 014102ms [06931:015:Main] End thread 15:12:45:239 014102ms [01975:024:ReadLastRecordID] Before context 15:12:45:239 014102ms [05684:012:ReadLastRecordID] Before scope 15:12:45:239 014102ms [02591:007:ReadLastRecordID] Before scope 15:12:45:239 014102ms [01961:005:ReadLastRecordID] Before query 15:12:45:239 014102ms [04434:010:Main] Start thread 15:12:45:239 014107ms [03186:009:ReadLastRecordID] Before context 15:12:45:239 014106ms [00129:001:ReadLastRecordID] Last person id #3 15:12:45:239 014102ms [03806:011:ReadLastRecordID] Before context 15:12:45:239 014110ms [00754:022:ReadLastRecordID] Before query 15:12:45:239 014110ms [08802:017:ReadLastRecordID] After scope dispose 15:12:45:239 014111ms [01365:023:ReadLastRecordID] After scope dispose 15:12:45:239 014102ms [00101:021:Main] Start thread 15:12:45:239 014111ms [06307:013:Main] End thread 15:12:45:239 014112ms [07554:014:ReadLastRecordID] After scope dispose 15:12:45:239 014112ms [05056:008:ReadLastRecordID] After scope dispose 15:12:45:239 014102ms [09426:018:Main] End thread <>