안녕하세요 @realmankwon입니다. 어제 SPT 임대 보상봇을 모니터링한 이전과 동일한 내용으로 오류가 발생하였고 보상도 나가지 않았습니다. 현재 관련해서 원인을 파악하여 소스를 수정하였습니다. [SPT 임대 보상 오류](https://www.steemcoinpan.com/sct/@realmankwon/realmankwon-posting-2019-12-22-14-34) 포스팅에서도 Lock 이 걸린 오류는 찾지 못했었습니다. 에러를 보면 동일 Key로 정보가 2건이 입력이 되면서 문제가 발생한 것으로 보이는데 하루에 한번 UTC 00시에 실행되는 것이 2번이 입력이 될 수 없는 구조이기에 더 이해가 가지 않았습니다. 이번에도 로그를 찾아 보았습니다. 저번과 동일한 Lock 으로 인한 대기시간 초과로 rollback 된 것을 알 수 있습니다. ![](https://cdn.steemitimages.com/DQmWbDXEUkuoizt3U7xancMks1ZFCv8q6Bww49ebPtMSu9i/image.png) 그래서 더 위의 로그를 찾아보았습니다. 그 중에 눈에 띄는 로그를 보게 되었습니다. ![](https://cdn.steemitimages.com/DQmZdDBE3kMYvgiRibFPbn4QuuSNxqtKg1WtkfCXoNrf8cc/image.png) 바로 @sct.krwp에 10% 수수료를 스테이킹하는 정보가 2번 입력이 되고 있었습니다. 그 말은 단 한가지 경우 밖에 없습니다. 한 소스에서 2번을 호출한 것이지요. 즉시 소스를 켜고 해당 부분을 보았더니 저의 실수가 바로 보였습니다. UTC 00시마다 SPT 임대 보상을 실행시키는 스케줄러를 2개로 작성했던 것입니다. 12월 14일에 스케줄러를 추가하면서 기존 소스를 복사하여 썼었는데 그때 중복으로 복사가 되었던 것 같습니다. 그렇다보니 12월 15일부터 보상이 나가지 않았습니다. DB lock 의 원인을 찾아서 다행이긴 하지만 또 실수를 한 것이 참...ㅜㅜ 더더더더 조심하여 수정을 하도록 하겠습니다. 관련 보상은 금일 정상적으로 처리된 것을 확인하였습니다. 앞으로도 @sct.krwp 에 많은 임대 부탁드립니다.
post_id | 82,798,793 |
---|---|
author | realmankwon |
permlink | realmankwon-posting-2019-12-24-00-15 |
category | sct |
json_metadata | {"tags":["sct","sct-kr","sct-freeboard","union","spt","zzan","palnet","steemleo","liv","busy"],"app":"steemcoinpan\/0.1"} |
created | 2019-12-24 05:50:33 |
last_update | 2019-12-24 05:50:33 |
depth | 0 |
children | 0 |
net_rshares | 64,667,059,048,524 |
last_payout | 2019-12-31 05:50:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 10.211 SBD |
curator_payout_value | 8.491 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 1,104 |
author_reputation | 3,146,138,068,696,221 |
root_title | "SPT 임대 보상 오류 모니터링" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
cheolwoo-kim | 0 | 3,135,880,185 | 50% | ||
gerber | 0 | 576,683,202,877 | 30% | ||
daan | 0 | 110,437,945,918 | 10% | ||
slowwalker | 0 | 672,630,024,561 | 10% | ||
exyle | 0 | 727,382,442,749 | 8% | ||
kopasi | 0 | 38,603,594,738 | 92.07% | ||
netaterra | 0 | 341,265,708,391 | 26% | ||
oldstone | 0 | 513,887,672,314 | 10% | ||
petrvl | 0 | 15,369,641,234 | 2.2% | ||
jack8831 | 0 | 54,110,865,784 | 100% | ||
megaspore | 0 | 793,306,276,157 | 100% | ||
ramires | 0 | 15,926,808,106 | 100% | ||
elviento | 0 | 6,483,153,410 | 6.33% | ||
happyberrysboy | 0 | 23,480,862,169 | 100% | ||
lotusofmymom | 0 | 6,259,625,857 | 11% | ||
isaaclab | 0 | 81,613,749,059 | 100% | ||
rycharde | 0 | 10,307,338,069 | 20% | ||
bizventurer | 0 | 18,656,396,305 | 75% | ||
belahejna | 0 | 2,606,498,810 | 2.2% | ||
sonki999 | 0 | 221,378,136,534 | 20% | ||
realmankwon | 0 | 28,455,178,427 | 100% | ||
techken | 0 | 138,193,678 | 2.1% | ||
becometheartist | 0 | 34,489,256,257 | 25% | ||
zinasura | 0 | 98,022,153,735 | 10% | ||
fur2002ks | 0 | 165,715,622,224 | 15% | ||
cryptopassion | 0 | 623,532,292,629 | 25% | ||
solar-junely | 0 | 57,430,717,138 | 100% | ||
unsw | 0 | 214,373,480 | 46% | ||
rocky1 | 0 | 2,970,938,191,065 | 3% | ||
dakeshi | 0 | 35,863,753,752 | 100% | ||
accelerator | 0 | 264,865,787,329 | 16.5% | ||
sbdraffle | 0 | 263,893,378 | 54% | ||
robertoueti | 0 | 1,409,204,497 | 3% | ||
arfa07 | 0 | 216,226,760 | 100% | ||
kimjh | 0 | 4,800,760,518 | 100% | ||
blockbrothers | 0 | 114,827,669,318 | 4% | ||
g10a | 0 | 644,784,383 | 2.47% | ||
imisstheoldkanye | 0 | 2,901,824,260 | 1% | ||
bitbulls | 0 | 67,913,459,165 | 100% | ||
backdm | 0 | 12,932,657,441 | 50% | ||
jacobyu | 0 | 538,474,950,536 | 92.07% | ||
bengy | 0 | 800,551,020 | 0.82% | ||
rokyupjung | 0 | 627,522,768 | 10% | ||
gfriend96 | 0 | 30,493,484,001 | 100% | ||
casberp | 0 | 8,478,465,943 | 1% | ||
banguri | 0 | 34,496,066,286 | 50% | ||
cadawg | 0 | 91,494,894,365 | 21% | ||
rainingfall | 0 | 3,697,230,033 | 10% | ||
happy-soul | 0 | 23,843,593,112 | 3% | ||
bozz | 0 | 3,940,781,373 | 1% | ||
earlmonk | 0 | 947,643,709 | 8% | ||
donekim | 0 | 54,781,335,830 | 100% | ||
bestboom | 0 | 9,030,057,216 | 24% | ||
eunsik | 0 | 281,759,034,856 | 50% | ||
rivalzzz | 0 | 41,376,863,545 | 20% | ||
jaephil | 0 | 550,286,921 | 100% | ||
tailcock | 0 | 67,453,579,786 | 32% | ||
stmdev | 0 | 146,960,348 | 1% | ||
bongje | 0 | 56,706,680,715 | 35% | ||
jungch98 | 0 | 6,547,382,073 | 100% | ||
alitavirgen | 0 | 18,849,985,678 | 11% | ||
therising | 0 | 3,055,232,335,593 | 10% | ||
jaydih | 0 | 489,689,453,962 | 11% | ||
andrewma | 0 | 0 | 0.2% | ||
prosperist | 0 | 203,205,864,042 | 100% | ||
kimseun | 0 | 71,578,513,402 | 11% | ||
wisdomandjustice | 0 | 501,093,172,132 | 10% | ||
kcc | 0 | 940,261,738,616 | 100% | ||
mynotsofitlife | 0 | 868,580,133 | 10% | ||
kibumh | 0 | 97,858,152,217 | 30% | ||
anpigon | 0 | 244,240,718,240 | 100% | ||
readygo | 0 | 615,866,982 | 100% | ||
bigjoy | 0 | 4,745,814,071 | 20% | ||
china-mobile | 0 | 131,245,809 | 10% | ||
luminaryhmo | 0 | 866,258,351 | 100% | ||
newbijohn | 0 | 33,987,810,399 | 100% | ||
nazishnaz | 0 | 2,300,345,123 | 100% | ||
lucky2 | 0 | 579,583,393,903 | 100% | ||
wdev | 0 | 420,950,552,596 | 100% | ||
kanadaramagi123 | 0 | 48,746,671,889 | 11% | ||
redoxer | 0 | 6,065,839,679 | 100% | ||
winston80 | 0 | 1,156,338,346 | 100% | ||
loveecho | 0 | 9,831,413,768 | 11% | ||
hammadmehdee | 0 | 513,847,164 | 100% | ||
crowdocracy.com | 0 | 1,714,924,222 | 100% | ||
angelslake | 0 | 18,542,347,243 | 11% | ||
alnida | 0 | 2,738,746,853 | 100% | ||
glory7 | 0 | 209,620,330,278 | 100% | ||
volare511 | 0 | 642,002,744 | 50% | ||
jeetbhowmik | 0 | 239,444,659 | 100% | ||
triptolemus | 0 | 61,084,967,278 | 15% | ||
wordit | 0 | 17,954,600,718 | 11% | ||
sj-jeong | 0 | 581,402,687,892 | 11% | ||
wondumyungga | 0 | 39,685,426,894 | 11% | ||
bobby.madagascar | 0 | 8,688,749,776 | 7.5% | ||
laissez-faire | 0 | 107,876,294 | 100% | ||
aquawink | 0 | 45,918,493,372 | 11% | ||
zeroc | 0 | 2,442,721,310 | 100% | ||
honeybeerbear | 0 | 33,910,639,945 | 100% | ||
abdulkalam | 0 | 153,846,504 | 100% | ||
ringit | 0 | 30,512,700,979 | 11% | ||
coreabeforekorea | 0 | 350,851,150,662 | 11% | ||
general.guy | 0 | 269,274,766 | 8% | ||
talkative-bk | 0 | 456,838,667,119 | 11% | ||
sojucaps1 | 0 | 545,683,240 | 100% | ||
edgarare1 | 0 | 5,154,032,475 | 4% | ||
swiftcash | 0 | 22,348,337,690 | 5% | ||
swiftbot | 0 | 577,989,351 | 5% | ||
rxzero | 0 | 81,078,194,586 | 100% | ||
primeradue | 0 | 28,534,931,541 | 30% | ||
playsteemmonster | 0 | 934,348,949 | 90% | ||
untold | 0 | 4,535,173,485 | 92.07% | ||
pgshow | 0 | 11,974,703,963 | 14.5% | ||
kryptogames | 0 | 18,715,635,155 | 3% | ||
nida0417 | 0 | 1,027,365,143 | 100% | ||
technohubtbi | 0 | 390,155,996 | 100% | ||
j-car | 0 | 214,845,991,528 | 11% | ||
steem-fund | 0 | 4,010,940,054 | 100% | ||
kamimoyla | 0 | 796,460,781 | 100% | ||
blender.steemit | 0 | 941,125,508 | 100% | ||
whatdidshewear | 0 | 91,189,895,251 | 11% | ||
sjgod4018 | 0 | 74,438,938,748 | 11% | ||
mustard-seed | 0 | 39,843,899,285 | 11% | ||
jcarvoting | 0 | 1,677,315,987 | 50% | ||
macau.bank | 0 | 10,001,265,010 | 100% | ||
haxxdump | 0 | 139,581,190 | 5% | ||
stpeople | 0 | 10,271,644,590 | 10.38% | ||
maxkim | 0 | 868,677,038 | 100% | ||
axeminni | 0 | 25,607,189 | 8% | ||
sct.cu1 | 0 | 22,566,903,400 | 100% | ||
sct.cu3 | 0 | 22,109,079,168 | 100% | ||
sct.cu4 | 0 | 22,544,869,006 | 100% | ||
sct.cu5 | 0 | 19,385,562,523 | 100% | ||
sct.cu8 | 0 | 23,440,048,232 | 100% | ||
sct.cu7 | 0 | 20,274,091,057 | 100% | ||
sct.cu15 | 0 | 22,993,685,612 | 100% | ||
sct.cu17 | 0 | 24,275,652,563 | 100% | ||
sct.cu20 | 0 | 20,669,684,790 | 100% | ||
sct.jac | 0 | 1,654,963,519 | 100% | ||
sct.tom | 0 | 7,898,612,669 | 50% | ||
sct.biz | 0 | 23,795,655,059 | 100% | ||
sct.adv | 0 | 25,930,833,043 | 92.07% | ||
sct.kop3 | 0 | 3,534,339,552 | 100% | ||
sct.kop4 | 0 | 3,943,335,075 | 100% | ||
fsm-liquid | 0 | 16,949,748,152 | 8% | ||
lovelyyeon.sct | 0 | 43,714,136,770 | 100% | ||
sct.dean | 0 | 1,965,826,142 | 100% | ||
feelsogood.cur | 0 | 1,931,259,642 | 100% | ||
map10k | 0 | 40,016,730,914 | 11.9% | ||
jstory | 0 | 3,047,385,614 | 40% | ||
darc | 0 | 880,977,308 | 100% | ||
korea.test | 0 | 619,084,266 | 100% | ||
wonsama.sct | 0 | 2,175,574,703 | 100% | ||
isi3.sct | 0 | 3,274,085,841 | 100% | ||
sct.min | 0 | 22,464,721,259 | 92.07% | ||
goodhello.sct | 0 | 1,458,993,224 | 90% | ||
union.sct | 0 | 4,228,661,981 | 90% | ||
sctm.winners | 0 | 555,546,820 | 100% | ||
triplea.bot | 0 | 3,436,250,253 | 8% | ||
mindtrap-leo | 0 | 0 | 1.94% | ||
cn-sct | 0 | 1,870,779,019 | 2% | ||
online-24-7 | 0 | 20,376,316,425 | 100% | ||
zaku-pal | 0 | 858,625,945 | 30% | ||
freegon.sct | 0 | 32,473,241,287 | 100% | ||
addax | 0 | 1,223,043,721 | 25% | ||
mapxv | 0 | 130,369,002,815 | 14.02% | ||
tina-tina | 0 | 751,825,559 | 100% | ||
roar2vote | 0 | 63,726,883 | 21% | ||
thranax | 0 | 9,381,369,576 | 15% | ||
cubot.sct | 0 | 541,901,929 | 100% | ||
busbecq | 0 | 621,229,155 | 25% | ||
kfu456 | 0 | 111,503,346 | 100% | ||
plcl | 0 | 618,130,409 | 100% | ||
sct.krwp | 0 | 27,249,480,861,293 | 55.66% | ||
csbcast | 0 | 4,004,685,974 | 100% | ||
maxuvc | 0 | 8,629,411,250 | 16.5% | ||
maxuvd | 0 | 8,254,951,996 | 16.5% | ||
maxuve | 0 | 52,463,340,007 | 14.85% | ||
jhzzanglove | 0 | 453,074,395 | 100% | ||
tonimontana.leo | 0 | 11,959,024 | 1.94% | ||
sct.curator | 0 | 102,796,083,912 | 36.32% | ||
therealyme | 0 | 18,303,430,196 | 7.2% | ||
jaykayw | 0 | 24,848,575,562 | 11% | ||
kopasi.sct | 0 | 17,239,461,084,378 | 100% | ||
tengri | 0 | 7,971,174,124 | 4.97% | ||
thebilpcointrain | 0 | 65,213,600 | 1% | ||
bilpcoin.pay | 0 | 185,026,314 | 1% | ||
roseofmylife | 0 | 131,342,614,662 | 10% | ||
sctvot | 0 | 1,135,958,976 | 100% | ||
ncm.wicked | 0 | 549,427,506 | 100% | ||
ncm.defying | 0 | 549,427,103 | 100% | ||
ncm.gravity | 0 | 549,427,794 | 100% | ||
ncm.hamilton | 0 | 549,427,915 | 100% | ||
ncm.whos | 0 | 549,428,072 | 100% | ||
ncm.next | 0 | 549,427,170 | 100% | ||
ncm.fire | 0 | 549,418,957 | 100% | ||
ncm.life | 0 | 549,454,562 | 100% | ||
ncm.death | 0 | 549,419,344 | 100% | ||
ncm.water | 0 | 549,396,087 | 100% | ||
ncm.earth | 0 | 548,377,466 | 100% | ||
zzan.sct | 0 | 2,388,098,962 | 100% | ||
kryptoformator | 0 | 955,501,138 | 1.1% | ||
reward.tier2 | 0 | 1,562,603,916 | 100% | ||
fierolma | 0 | -9,144,929 | -10% | ||
bilpcoinpower | 0 | 404,325,139 | 10% | ||
toni.pal | 0 | 0 | 0.74% |