Some API interfaces are abnormal

[guomaoqiu]

According to the log alarm, some API interfaces are abnormal. The following is the alarm content. Please @rabbitz @zmcNotafraid investigate and handle it.

响应状态码: 502
发生时间UTC: 2024-07-17T02:39:16Z
ES Index: proxy-testnet-api.explorer.nervos.org.log-2024.07.17
num_hits: 44
请求URL: https://testnet-api.explorer.nervos.org/api/v1/cell_output_lock_scripts/179417497
Request Method: GET
ClientIP: 38.207.142.19, 172.68.225.43
num_matches: 20
UserAgent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36

响应状态码: 502
发生时间UTC: 2024-07-17T02:39:50Z
ES Index: proxy-testnet-api.explorer.nervos.org.log-2024.07.17
num_hits: 45
请求URL: https://testnet-api.explorer.nervos.org/api/v1/address_live_cells/ckt1qzda0cr08m85hc8jlnfp3zer7xulejywt49kt2rr0vthywaa50xwsqw6vjzy9kahx3lyvlgap8dp8ewd8g80pcgcexzrj?page=1&page_size=10&sort=capacity.desc
Request Method: GET
ClientIP: 38.207.142.19, 172.68.225.43
num_matches: 1
UserAgent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36

响应状态码: 500
发生时间UTC: 2024-07-17T03:30:19Z
ES Index: proxy-testnet-api.explorer.nervos.org.log-2024.07.17
num_hits: 41
请求URL: https://testnet-api.explorer.nervos.org/api/v1/address_live_cells/ckt1qzda0cr08m85hc8jlnfp3zer7xulejywt49kt2rr0vthywaa50xwsqgy2q6qz79wyaexr2pcez0eejmk5xgw6jcfw7zmg?page=1&page_size=10&sort=capacity.desc
Request Method: GET
ClientIP: 45.62.167.185, 172.71.210.40
num_matches: 2
UserAgent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36

响应状态码: 500
发生时间UTC: 2024-07-17T03:17:00Z
ES Index: proxy-mainnet-api.explorer.nervos.org.log-2024.07.17
num_hits: 1
请求URL: https://mainnet-api.explorer.nervos.org/api/v2/das_accounts
Request Method: POST
ClientIP: 66.249.79.205, 172.71.151.95
num_matches: 1
UserAgent: Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.6422.175 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)

响应状态码: 500
发生时间UTC: 2024-07-17T02:56:38Z
ES Index: proxy-testnet-api.explorer.nervos.org.log-2024.07.17
num_hits: 2
请求URL: https://testnet-api.explorer.nervos.org/api/v1/daily_statistics/circulating_supply-liquidity
Request Method: GET
ClientIP: 38.207.142.19, 162.158.178.88
num_matches: 2
UserAgent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36

响应状态码: 502
发生时间UTC: 2024-07-17T03:32:18Z
ES Index: proxy-testnet-api.explorer.nervos.org.log-2024.07.17
num_hits: 43
请求URL: https://testnet-api.explorer.nervos.org/api/v1/address_live_cells/ckt1qzda0cr08m85hc8jlnfp3zer7xulejywt49kt2rr0vthywaa50xwsqw6vjzy9kahx3lyvlgap8dp8ewd8g80pcgcexzrj?page=1&page_size=10&sort=capacity.desc
Request Method: GET
ClientIP: 45.62.167.185, 172.71.210.40
num_matches: 2
UserAgent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36

[guomaoqiu]

Error Code Query:

• testnet
  https://kibana.magickbase.com/app/discover#/?_g=(filters:!(),refreshInterval:(pause:!t,value:0),time:(from:now-5h,to:now))&_a=(columns:!(request_uri,request_method,status),filters:!(),index:f910c170-4187-11ef-bf5d-e50a58fe936f,interval:auto,query:(language:kuery,query:'status%20%3E%3D%20500%20'),sort:!(!('@timestamp',desc)))
  
• mainnet:
  https://kibana.magickbase.com/app/discover#/?_g=(filters:!(),refreshInterval:(pause:!t,value:0),time:(from:now-5h,to:now))&_a=(columns:!(request_uri,request_method,status,server_addr),filters:!(),index:f6119c90-4116-11ef-9451-d5b9a8c5d266,interval:auto,query:(language:kuery,query:'status%20%3E%3D%20500%20'),sort:!(!('@timestamp',desc)))

[rabbitz]

mainnet

1. The suggest query resulted in a 502 error because the corresponding cell_dependencies had errors, possibly caused by transaction revert leading to dirty data. The data has been resynchronized.

0xc1778d558426c9ff866c20c9c867cc01d157ac35e6ca7a4e89e9fbd208cb78ef
0xd65c52ac0afe50b3ca49a5b202445962c21e09dbc9c082574082282fb811892c

2. The das_accounts API call is incorrect; the parameter should be an array.

curl --location --request POST 'https://mainnet-api.explorer.nervos.org/api/v2/das_accounts' \
--header 'Authorization: eyJhbGciOiJIUzI1NiJ9.eyJ1dWlkIjoiZWY0ZTU5ZTAtMGJiMi00N2U5LWE2ZjctOGQxYTQ1NWY3OGZhIiwiZXhwIjoxNjk5ODU4OTgwfQ.1m0Fa7c09PdUzsWKOpG2fqpzTzbD_64pKPGmK1SeaeY' \
--header 'User-Agent: Apifox/1.0.0 (https://apifox.com)' \
--header 'Content-Type: application/json' \
--header 'Accept: */*' \
--header 'Host: mainnet-api.explorer.nervos.org' \
--header 'Connection: keep-alive' \
--data-raw '{
    "addresses": [
        "ckb1qzmpjxz2hy2zc5dsae6lfcjtempaqalwlegnz9d666yrd5r88r7jcqgu5dwttldyh42zuuweffk47nqdy4wk6ma6w0zpeazay6f7txesw2qddt80jukmg6yypzj7r9he96cy2l9qq0v658z9luzs266znv6nj0djzuqqqqqqqqgsd7zy"
    ]
}'