Problem in active gateway tracking #201
Description
As found in livepeer/explorer#410 (comment) the current active-gateway tracking logic permanently removes a gateway from the active set if it is inactive for more than 90 days, which prevents its 30/60/90-day rolling fee totals from ever updating when it becomes active again; instead, whenever a new ticket is received from a previously inactive gateway, it should be automatically re-added to the active set so its rolling volume windows resume updating correctly.
Reproduce
- Go to https://thegraph.com/explorer/subgraphs/FE63YgkzcpVocxdCEyEYbvjYqEf2kb1A6daMYRxmejYC?view=Query&chain=arbitrum-one and use the following command:
{
broadcaster(id: "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1"){
id
deposit
reserve
totalVolumeETH
totalVolumeUSD
thirtyDayVolumeETH
sixtyDayVolumeETH
ninetyDayVolumeETH
firstActiveDay
lastActiveDay
broadcasterDays(orderBy: date, orderDirection: desc){
id
date
volumeETH
volumeUSD
}
}
}- This will give you the output below:
Output
{
"data": {
"broadcaster": {
"broadcasterDays": [
{
"date": 1767916800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20462",
"volumeETH": "0.00202020202020202",
"volumeUSD": "6.236192885876413427379679198328888"
},
{
"date": 1767657600,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20459",
"volumeETH": "0.0012",
"volumeUSD": "3.868075756405035800570352031553352"
},
{
"date": 1767571200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20458",
"volumeETH": "0.00322020202020202",
"volumeUSD": "10.21822380463549297346742767215717"
},
{
"date": 1767484800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20457",
"volumeETH": "0.0012",
"volumeUSD": "3.776705476079899651723995202311737"
},
{
"date": 1767398400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20456",
"volumeETH": "0.0024",
"volumeUSD": "7.443976283574690097516485865649487"
},
{
"date": 1767312000,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20455",
"volumeETH": "0.0024",
"volumeUSD": "7.400008509641703655046569204973869"
},
{
"date": 1767139200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20453",
"volumeETH": "0.0012",
"volumeUSD": "3.568794949704724638983855700189526"
},
{
"date": 1767052800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20452",
"volumeETH": "0.0024",
"volumeUSD": "7.11149600306538398036768755428368"
},
{
"date": 1766880000,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20450",
"volumeETH": "0.0024",
"volumeUSD": "7.064239177369197090038318306547535"
},
{
"date": 1766793600,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20449",
"volumeETH": "0.0024",
"volumeUSD": "7.030463198726448784643648863292113"
},
{
"date": 1766534400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20446",
"volumeETH": "0.00202020202020202",
"volumeUSD": "5.920742383981600542029458283811274"
},
{
"date": 1766188800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20442",
"volumeETH": "0.0036",
"volumeUSD": "10.73913805447792066278816345521617"
},
{
"date": 1766016000,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20440",
"volumeETH": "0.0012",
"volumeUSD": "3.39246456598832449733200377425821"
},
{
"date": 1765929600,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20439",
"volumeETH": "0.0036",
"volumeUSD": "10.16066186705118499265463020433676"
},
{
"date": 1765843200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20438",
"volumeETH": "0.00200424",
"volumeUSD": "5.907623751083517809865474526971741"
},
{
"date": 1765756800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20437",
"volumeETH": "0.00190824",
"volumeUSD": "5.687129410252437885425742471025342"
},
{
"date": 1765411200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20433",
"volumeETH": "0.0012",
"volumeUSD": "3.891132684218321227790662929413905"
},
{
"date": 1765324800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20432",
"volumeETH": "0.0012",
"volumeUSD": "3.987767983000153004463141835032416"
},
{
"date": 1765152000,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20430",
"volumeETH": "0.0012",
"volumeUSD": "3.751696485204782301131742601648866"
},
{
"date": 1765065600,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20429",
"volumeETH": "0.004",
"volumeUSD": "12.20243038243458053651056257736495"
},
{
"date": 1764979200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20428",
"volumeETH": "0.0012",
"volumeUSD": "3.629824307342778936845517865648104"
},
{
"date": 1764892800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20427",
"volumeETH": "0.00258852",
"volumeUSD": "8.148411966817011148014727395116239"
},
{
"date": 1764460800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20422",
"volumeETH": "0.0012",
"volumeUSD": "3.59631389606690953451493307924208"
},
{
"date": 1764374400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20421",
"volumeETH": "0.0024",
"volumeUSD": "7.231731808229097975230436926852124"
},
{
"date": 1764115200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20418",
"volumeETH": "0.0012",
"volumeUSD": "3.63235174858126264229180293454601"
},
{
"date": 1763769600,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20414",
"volumeETH": "0.0024",
"volumeUSD": "6.550621678036026852439991017869516"
},
{
"date": 1763683200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20413",
"volumeETH": "0.00153384",
"volumeUSD": "4.316700139338690738219159302194395"
},
{
"date": 1763596800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20412",
"volumeETH": "0.0012",
"volumeUSD": "3.63282127304808294212868508685641"
},
{
"date": 1763424000,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20410",
"volumeETH": "0.0012",
"volumeUSD": "3.616572221535917279493574235941061"
},
{
"date": 1763251200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20408",
"volumeETH": "0.0024",
"volumeUSD": "7.637985382917129648504811444302572"
},
{
"date": 1762992000,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20405",
"volumeETH": "0.0014988",
"volumeUSD": "4.758842334709348915265325721293682"
},
{
"date": 1762905600,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20404",
"volumeETH": "0.0012",
"volumeUSD": "4.094239362714094974313702723550429"
},
{
"date": 1762732800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20402",
"volumeETH": "0.0044",
"volumeUSD": "15.79248851372491044526604239556754"
},
{
"date": 1762646400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20401",
"volumeETH": "0.002",
"volumeUSD": "7.202489926213195841770052059025808"
},
{
"date": 1762387200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20398",
"volumeETH": "0.0024",
"volumeUSD": "8.179622457142579861950158085390099"
},
{
"date": 1761696000,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20390",
"volumeETH": "0.00437052",
"volumeUSD": "17.48967736113973134042186415250024"
},
{
"date": 1761436800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20387",
"volumeETH": "0.0012",
"volumeUSD": "4.724180864015339431089020827959685"
},
{
"date": 1761350400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20386",
"volumeETH": "0.001311",
"volumeUSD": "5.149612227310567113867619070636018"
},
{
"date": 1760486400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20376",
"volumeETH": "0.0012",
"volumeUSD": "4.799211327159464058492606196916141"
},
{
"date": 1759622400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20366",
"volumeETH": "0.00124836",
"volumeUSD": "5.671693285076653613534261749581745"
},
{
"date": 1759449600,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20364",
"volumeETH": "0.0012",
"volumeUSD": "5.440339039919599698877705221012788"
},
{
"date": 1759104000,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20360",
"volumeETH": "0.0024",
"volumeUSD": "9.906198414258080730227680996334268"
},
{
"date": 1758931200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20358",
"volumeETH": "0.00253488",
"volumeUSD": "10.16279289493712529518181088700711"
},
{
"date": 1758844800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20357",
"volumeETH": "0.0012",
"volumeUSD": "4.83525441345593765120791914859997"
},
{
"date": 1758758400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20356",
"volumeETH": "0.0132",
"volumeUSD": "51.76280514421336184912494411707631"
},
{
"date": 1758672000,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20355",
"volumeETH": "0.0012",
"volumeUSD": "5.020211598732769878592113181356036"
},
{
"date": 1758585600,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20354",
"volumeETH": "0.0012",
"volumeUSD": "5.028315151825274732884067503783943"
},
{
"date": 1758499200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20353",
"volumeETH": "0.0024",
"volumeUSD": "10.05598160916538859141674318281039"
},
{
"date": 1757980800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20347",
"volumeETH": "0.0024",
"volumeUSD": "10.83168903684456293235928811966506"
},
{
"date": 1757894400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20346",
"volumeETH": "0.0012",
"volumeUSD": "5.378574590534816238747450744069256"
},
{
"date": 1757721600,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20344",
"volumeETH": "0.0012",
"volumeUSD": "5.66951657039934871027002359672461"
},
{
"date": 1757548800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20342",
"volumeETH": "0.0012",
"volumeUSD": "5.287984886124558860878536165076202"
},
{
"date": 1757116800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20337",
"volumeETH": "0.0012",
"volumeUSD": "5.124071442997989673278675029658766"
},
{
"date": 1757030400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20336",
"volumeETH": "0.0012",
"volumeUSD": "5.167953479934441677191670809396346"
},
{
"date": 1756857600,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20334",
"volumeETH": "0.002",
"volumeUSD": "8.935483174367013481737319006051674"
},
{
"date": 1756771200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20333",
"volumeETH": "0.0012",
"volumeUSD": "5.189187783704613038586004380975545"
},
{
"date": 1755820800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20322",
"volumeETH": "0.0015066",
"volumeUSD": "7.287086981609127738466958022676324"
},
{
"date": 1753574400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20296",
"volumeETH": "0.002",
"volumeUSD": "7.555385140340649530751258232310066"
},
{
"date": 1753056000,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20290",
"volumeETH": "0.0012",
"volumeUSD": "4.50691629772117150347321758433638"
},
{
"date": 1752710400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20286",
"volumeETH": "0.0012",
"volumeUSD": "4.06608643934651111011570253965834"
},
{
"date": 1752537600,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20284",
"volumeETH": "0.0012",
"volumeUSD": "3.590464479056189480465136343675321"
},
{
"date": 1752278400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20281",
"volumeETH": "0.0013926",
"volumeUSD": "4.126533543872510020094883195188831"
},
{
"date": 1751673600,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20274",
"volumeETH": "0.0012",
"volumeUSD": "3.021493880745227475108575295693289"
},
{
"date": 1750377600,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20259",
"volumeETH": "0.0012",
"volumeUSD": "3.01963428226757972672302458834725"
},
{
"date": 1750118400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20256",
"volumeETH": "0.00140904",
"volumeUSD": "3.548687055068013149549482814735057"
},
{
"date": 1749945600,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20254",
"volumeETH": "0.0012",
"volumeUSD": "3.035905950048168273477747621441822"
},
{
"date": 1749859200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20253",
"volumeETH": "0.0012",
"volumeUSD": "3.041501498529674490768962205470674"
},
{
"date": 1749686400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20251",
"volumeETH": "0.0012",
"volumeUSD": "3.284807469235205852849887961941742"
},
{
"date": 1749600000,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20250",
"volumeETH": "0.002",
"volumeUSD": "5.513822949515593483725259162508272"
},
{
"date": 1749427200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20248",
"volumeETH": "0.0012",
"volumeUSD": "3.044282573706256246830218641435715"
},
{
"date": 1749340800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20247",
"volumeETH": "0.0036",
"volumeUSD": "9.066771671818803320019008098771472"
},
{
"date": 1748908800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20242",
"volumeETH": "0.0012",
"volumeUSD": "3.141052812348922417299068820258732"
},
{
"date": 1747440000,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20225",
"volumeETH": "0.0012",
"volumeUSD": "2.987119334063671158951855245329862"
},
{
"date": 1747267200,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20223",
"volumeETH": "0.0012",
"volumeUSD": "3.041660119472376157854483438415406"
},
{
"date": 1747094400,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1-20221",
"volumeETH": "0.0012",
"volumeUSD": "3.238135126234647968256481583825942"
}
],
"deposit": "0.05463275393939394",
"firstActiveDay": 1710460800,
"id": "0x173173b30b5d3c8f09ee78816da8a6402d6b16e1",
"lastActiveDay": 1767916800,
"ninetyDayVolumeETH": "0",
"reserve": "0.2",
"sixtyDayVolumeETH": "0",
"thirtyDayVolumeETH": "0",
"totalVolumeETH": "0.14536724606060606",
"totalVolumeUSD": "493.1280625303057889987270580149758"
}
}
}- See that active
broadcasterDaysentries and alsolastActiveDayare less than 90D ago but still the 30/60/90 day sums are 0.