Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DailyStatistic execution exception #675

Closed
rabbitz opened this issue May 30, 2024 · 5 comments
Closed

DailyStatistic execution exception #675

rabbitz opened this issue May 30, 2024 · 5 comments
Assignees
Labels
bug Something isn't working

Comments

@rabbitz
Copy link

rabbitz commented May 30, 2024

No description provided.

@rabbitz rabbitz added the bug Something isn't working label May 30, 2024
@rabbitz rabbitz self-assigned this May 30, 2024
@rabbitz rabbitz moved this to 📌CurrentWeek in CKB Explorer May 30, 2024
@zmcNotafraid
Copy link
Member

  • mining_reward
  • address_balance_distribution
  • occupied_capacity
    The above three attr is slow, run about one minute

@zmcNotafraid
Copy link
Member

zmcNotafraid commented Jul 3, 2024

Today we found the scheduler job was not finished.First we query the log, from the below yesterday log we can see this job runs about 30 mintues.But today's log shows only start no finished.Then we found the scheduler container has restarted many times in these time.And the rufu-scheduler gem run job in memory not persist them.So I guess the container stoped after the job start,it caused the job lost.
image

@zmcNotafraid zmcNotafraid moved this from 🆕 New to 🏗 In Progress in CKB Explorer Jul 3, 2024
@zmcNotafraid
Copy link
Member

After the databse timeout set to 60s, these attrs will timeout: addresses_count, mining_reward, address_balance_distribution, occupied_capacity, ckb_hodl_wave, holder_count

@Keith-CY
Copy link
Member

Keith-CY commented Jul 8, 2024

After the databse timeout set to 60s, these attrs will timeout: addresses_count, mining_reward, address_balance_distribution, occupied_capacity, ckb_hodl_wave, holder_count

How about running these statistics works in independent services to reduce the pressure on the single/current service.

@zmcNotafraid zmcNotafraid moved this from 🏗 In Progress to ✅ Done in CKB Explorer Jul 22, 2024
@zmcNotafraid
Copy link
Member

image
After cell_outputs table's partitioned current only needs 5 minutes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
Status: ✅ Done
Development

No branches or pull requests

3 participants