Loop in Ruby on Rails running twice -


i'm going crazy. each-loop in rails runs twice each collection item. have no clue why.

    locations = location.all      locations.each |loc|        # delay not overload le webservice        sleep 1.0         if [... webservice call - runs fine ... ]          # score calculation - v0.1         score = [... formula calculate score ...]          score_total = score + loc.score_total         score_count = loc.score_count + 1          # update current record fresh values webservice             loc.update(:temp1 => temp[0],             :temp2 => temp[1],             :temp3 => temp[2],             :temp4 => temp[3],             :temp5 => temp[4],              :condition1 => condition[0],              :condition2 => condition[1],              :condition3 => condition[2],              :condition4 => condition[3],              :condition5 => condition[4],              :score_yesterday => loc.score_now,              :score_now => score,              :score_total => score_total,              :score_count => score_count)       end     end

count jumps in 2-times steps

some variables want update within each iteration behind

log:

started "/loc" 127.0.0.1 @ 2014-02-01 13:37:22 +0100 processing whitelabelscontroller#loc html   [1m[36mwhitelabelwsd load (0.6ms)[0m  [1mselect "whitelabel_wsds".* "whitelabel_wsds"[0m   [1m[35m (0.3ms)[0m  begin   [1m[36msql (4.4ms)[0m  [1mupdate "whitelabel_wsds" set "temp1" = $1, "temp2" = $2, "temp3" = $3, "temp4" = $4, "temp5" = $5, "condition1" = $6, "condition2" = $7, "condition3" = $8, "condition4" = $9, "condition5" = $10, "score_now" = $11, "score_total" = $12, "score_count" = $13, "updated_at" = $14 "whitelabel_wsds"."id" = 2[0m  [["temp1", 17], ["temp2", 15], ["temp3", 13], ["temp4", 14], ["temp5", 13], ["condition1", "patchy rain nearby"], ["condition2", "cloudy "], ["condition3", "sunny"], ["condition4", "light rain shower"], ["condition5", "sunny"], ["score_now", 306], ["score_total", 10934], ["score_count", 48], ["updated_at", sat, 01 feb 2014 12:37:23 utc +00:00]]   [1m[35m (264.2ms)[0m  commit   [1m[36m (0.2ms)[0m  [1mbegin[0m   [1m[35msql (0.8ms)[0m  update "whitelabel_wsds" set "temp1" = $1, "temp2" = $2, "temp3" = $3, "temp4" = $4, "temp5" = $5, "condition1" = $6, "condition2" = $7, "condition3" = $8, "condition4" = $9, "condition5" = $10, "score_now" = $11, "score_total" = $12, "score_count" = $13, "updated_at" = $14 "whitelabel_wsds"."id" = 3  [["temp1", 16], ["temp2", 11], ["temp3", 16], ["temp4", 13], ["temp5", 17], ["condition1", "cloudy "], ["condition2", "sunny"], ["condition3", "cloudy "], ["condition4", "sunny"], ["condition5", "partly cloudy "], ["score_now", 391], ["score_total", 22791], ["score_count", 51], ["updated_at", sat, 01 feb 2014 12:37:25 utc +00:00]]   [1m[36m (1.3ms)[0m  [1mcommit[0m   [1m[35m (0.1ms)[0m  begin   [1m[36msql (1.4ms)[0m  [1mupdate "whitelabel_wsds" set "temp1" = $1, "temp2" = $2, "temp3" = $3, "temp4" = $4, "temp5" = $5, "condition1" = $6, "condition2" = $7, "score_now" = $8, "score_total" = $9, "score_count" = $10, "updated_at" = $11 "whitelabel_wsds"."id" = 1[0m  [["temp1", 21], ["temp2", 22], ["temp3", 21], ["temp4", 22], ["temp5", 23], ["condition1", "partly cloudy "], ["condition2", "partly cloudy "], ["score_now", 961], ["score_total", 93375], ["score_count", 61], ["updated_at", sat, 01 feb 2014 12:37:26 utc +00:00]]   [1m[35m (0.5ms)[0m  commit   rendered whitelabels/loc.html.erb within layouts/whitelabel (0.1ms) completed 200 ok in 4318ms (views: 6.6ms | activerecord: 277.8ms)   started "/loc" 127.0.0.1 @ 2014-02-01 13:37:26 +0100 processing whitelabelscontroller#loc html   [1m[36mwhitelabelwsd load (0.7ms)[0m  [1mselect "whitelabel_wsds".* "whitelabel_wsds"[0m   [1m[35m (0.2ms)[0m  begin   [1m[36msql (0.7ms)[0m  [1mupdate "whitelabel_wsds" set "score_yesterday" = $1, "score_total" = $2, "score_count" = $3, "updated_at" = $4 "whitelabel_wsds"."id" = 2[0m  [["score_yesterday", 306], ["score_total", 11240], ["score_count", 49], ["updated_at", sat, 01 feb 2014 12:37:27 utc +00:00]]   [1m[35m (0.6ms)[0m  commit   [1m[36m (0.2ms)[0m  [1mbegin[0m   [1m[35msql (0.6ms)[0m  update "whitelabel_wsds" set "score_yesterday" = $1, "score_total" = $2, "score_count" = $3, "updated_at" = $4 "whitelabel_wsds"."id" = 3  [["score_yesterday", 391], ["score_total", 23182], ["score_count", 52], ["updated_at", sat, 01 feb 2014 12:37:29 utc +00:00]]   [1m[36m (0.5ms)[0m  [1mcommit[0m   [1m[35m (0.2ms)[0m  begin   [1m[36msql (0.5ms)[0m  [1mupdate "whitelabel_wsds" set "score_yesterday" = $1, "score_total" = $2, "score_count" = $3, "updated_at" = $4 "whitelabel_wsds"."id" = 1[0m  [["score_yesterday", 961], ["score_total", 94336], ["score_count", 62], ["updated_at", sat, 01 feb 2014 12:37:30 utc +00:00]]   [1m[35m (0.5ms)[0m  commit   rendered whitelabels/loc.html.erb within layouts/whitelabel (0.1ms) completed 200 ok in 3598ms (views: 4.7ms | activerecord: 4.5ms)

was going write comment, clearer here:

i'd imagine there 3 potential causes of problem:

  1. perhaps update saving data incorrectly / before & after webservice call
  2. your webservice may taking long
  3. perhaps else messing-up?

update_attributes

having looked on .update & .update_attributes methods, looks replace .update .update_attributes

although difference escapes me, use update_attributes time - need here:

 loc.update_attributes(             :temp1 => temp[0],             :temp2 => temp[1],             :temp3 => temp[2],             :temp4 => temp[3],             :temp5 => temp[4],              :condition1 => condition[0],              :condition2 => condition[1],              :condition3 => condition[2],              :condition4 => condition[3],              :condition5 => condition[4],              :score_yesterday => loc.score_now,              :score_now => score,              :score_total => score_total,              :score_count => score_count   )

webservice

another issue may webservice call taking long

any external dependencies carry added latency, may need factor process

currently, don't have logic determine whether call successful or not. explain app's increasing count without other items (it doesn't have access new data):

locations.each |loc|      if [... webservice call - runs fine ... ]          # score calculation - v0.1         score = [... formula calculate score ...]          score_total = score + loc.score_total          # update current record fresh values webservice             loc.update_attributes(:temp1 => temp[0],                 :temp2 => temp[1],                 :temp3 => temp[2],                 :temp4 => temp[3],                 :temp5 => temp[4],                  :condition1 => condition[0],                  :condition2 => condition[1],                  :condition3 => condition[2],                  :condition4 => condition[3],                  :condition5 => condition[4],                  :score_yesterday => loc.score_now,                  :score_now => score,                  :score_total => score_total         )          loc.increment!(:score_count)      end  end

.increment! method ;)

logs

lots of these types of error can explained logs

the logs detail calls being made & when; allowing see what's happening


-

Comments

Post a Comment

Popular posts from this blog

php - regexp cyrillic filename not matches -

i take list of files php glob(."*.pdf") . files have cyrillic names. example: ООО «Рога и копыта» then load company names database , try find them in file names: preg_match("/$firm_name/ui", $file_name, $match); i have problem: firms if $firm_name visually similar $file_name , preg_match says there no match. mb_detect_encoding both variables return utf-8. there problem in file name, or maybe there encoding or something, can not understand, ask help. upd: $file_name='ООО «Рога и копыта»'; preg_match("/... .Рога и копыта./ui", $file_name, $match); as result, ОО «Рога и копыта» , 1 О missing
Read more

c# - OpenXML hanging while writing elements -

Image
i have program pulls data database, caches file , exports data multiple formats (excel, excel 2003, csv). i'm using openxml sdk 2.0 excel work. these export processes run in parallel (using parallel.foreach ), , amount of data can pretty large - e.g. csvs 800mb. during these larger exports, i've noticed writing of xml documents hang. instance, if have 8 exporting in parallel, @ point "pause". hang around same point: //this.writer openxmlwriter created worksheetpart. this.writer.writeelement(new cell() { cellvalue = new cellvalue(value), datatype = cellvalues.string }); when happens, pause debugger (vs2013 in case) , notice threads blocking around same portion of code - bit deeper in openxml sdk - stem call openxmlwriter.writeelement . i dug through source using justdecompile didn't find answers. appears there intermediary stream in use writing isolated storage , is, reason, blocking. underlying stream each of these filestream . here screenshot ...
Read more

sql - Select Query has unexpected multiple records (MS Access) -

i may tired, can't seem figure out happening. have 2 queries. query 1 has 10 fields. query 2 has 5 fields. fields 1 through 3 same in both queries. trying write select query , simple add field 5 query2 query1 result should query1 additional field (query2.field5). i join first 3 fields both queries , choose select records in query1 , in query2 match. don't know sql, use query designer. expect same number of records have query 1 instead have 3 times or more. can tell me doing wrong. tried reversing joins still seem same records. thanks in advance. here query: the fields in common divisionname , supplierid = vendorid , commodityname . select [part revenue exposed query p1].divisionname, [part revenue exposed query p1].commodityname, [part revenue exposed query p1].suppliername, [part revenue exposed query p1].partnumber, [part revenue exposed query p1].partdescription, [part revenue exposed query p1].bucode, ...
Read more