arangoexport and max-runtime for the long queries

Alexander Lanin

unread,

Apr 21, 2021, 4:21:42 AM4/21/21

to ArangoDB

Hi. How can I have max-runtime set to the low value and arangoexport works at the same time? I want to have slow queries killed after 1 minute, but the export process is the long query too.

Jan

unread,

Apr 21, 2021, 4:24:56 AM4/21/21

to ArangoDB

Hi,

currently arangoexport does not provide any such options to limit the runtime of queries.

But I fully agree it would be good to have that. I will try to add the option to one of the upcoming versions.

Jan

unread,

Apr 21, 2021, 6:13:47 AM4/21/21

to ArangoDB

To be added to 3.8 via https://github.com/arangodb/arangodb/pull/14041

Alexander Lanin

unread,

Apr 21, 2021, 10:23:39 AM4/21/21

to ArangoDB

O! Thank you. It will be very handy.
Is it any workaround right now? I didn't find how to reconfigure max-runtime on the fly. Looks like it is not possible.

Jan Steemann

unread,

Apr 21, 2021, 10:29:49 AM4/21/21

to aran...@googlegroups.com

There is no workaround right now for arangoexport. It doesn't support any way to restrict the query runtime yet.

You can however set the startup option `--query.max-runtime` globally for all arangod instances you start.

But this limit will then be applied to all queries.

--
You received this message because you are subscribed to a topic in the Google Groups "ArangoDB" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/arangodb/VJwTB7F7SiI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to arangodb+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/arangodb/e13f14b7-c8bd-42b5-a707-2508e7f581can%40googlegroups.com.

Alexander Lanin

unread,

Apr 21, 2021, 11:03:33 AM4/21/21

to ArangoDB

Looks like I worded my question not quite good. I already have used `--query.max-runtime`, because I don't want long queries on my server.
But I need the export queries last long.
Example: `--query.max-runtime 60` and `arangoexport --query-max-runtime 600 ...`

Jan Steemann

unread,

Apr 21, 2021, 11:08:11 AM4/21/21

to aran...@googlegroups.com

Ok, that functionality should be provided in the future by the new arangoexport option.

I don't see a workaround for it in a current release.

To view this discussion on the web visit https://groups.google.com/d/msgid/arangodb/8e1a5461-1862-4137-8cea-fd679fa5b1acn%40googlegroups.com.

Reply all

Reply to author

Forward