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
ArangoDB reload taking lot of time when pod restarts #14386
Comments
@yogeshbidari Can you share a bit more information? In particular the K8s configuration? Do I understand correctly that the two log messages that you posted are the only output from arangod? How exactly did you active trace logging? With |
I checked with engineering and they clarified that |
@Simran-B Yes, I am using |
@yogeshbidari Did you find anything in the trace logs yet? |
@Simran-B I have changed the log.level to Still it is taking lot of time to reload databases. choosing Rocksdb storage engine |
@Simran-B Any update on the issue. |
My Environment
Component, Query & Data
Affected feature:
AQL query (if applicable):
AQL explain and/or profile (if applicable):
Dataset:
Size of your Dataset on disk:
80GB
Replication Factor & Number of Shards (Cluster only):
Steps to reproduce
Problem:
After Pod restart, it takes around 16hrs to reload the databases, till this time will not be able to access arango service in both CLI and UI.
We see some slow query logs in POD logs
2021-06-17T23:44:05Z [1] WARNING {queries} slow query: '\n FOR item IN @value0\n UPSERT {mount: item[0]}\n INSERT item[1]\n REPLACE item[1]\n IN @@value1\n ', bind vars: {"@value1":"_apps","value0":[["/_admin/aardvark",{"id":"/_admin/aardvark","mount":"/_admin/aardvark","options":{"configuration":{},"dependencies":{},"development":false}}],["/_api/foxx",{"id":"/_api/foxx","mount":"/_api/foxx","options":{"configuration":{},"dependencies":{},"development":false}}],["/_api/gharial",{"id":"/_api/gharial","mount":"/_api/gharial","options":{"configuration":{},"dependencies":{},"development":false}}]]}, took: 18.012608 s
We have enabled trace logging also, but we dont see any extra logs except slow query and below one
2021-06-18T15:58:58Z [1] TRACE optimization ends with 1 plans 2021-06-18T15:58:58Z [1] TRACE optimization ends with 1 plans 2021-06-18T15:58:58Z [1] TRACE optimization ends with 1 plans 2021-06-18T15:58:58Z [1] TRACE optimization ends with 1 plans
Does reloading of 16k or 80GB databases after pod restart takes so much of time?
Expected result:
DB reload has to take less time.
The text was updated successfully, but these errors were encountered: