Arthur P Goldberg
Arthur P Goldberg
Hi @ndobb Thanks Nic. You've an interesting hypothesis RE MSSQL timing out because a query is not progressing, and that using `PARALLEL` may help avoid this. With these timeout and...
Hello again @ndobb I returned to using `"QueryStrategy": "CTE"`. This query (taken from the Leaf log) generates a timeout at 60 s. in Leaf: WITH wrapper (personId) AS ( SELECT...
Thanks for looking into this @jnahmias . I don't have any thoughts about your observation. But I've run some searches on the code which might be interesting. The appsettings for...
Hi @jnahmias @ndobb I've replaced all occurrences of `dbOpts.DefaultTimeout` in `QueryService.cs` with `10` (which is seconds [according to MSFT](https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand.commandtimeout?view=dotnet-plat-ext-5.0)) and run Leaf queries that take longer than 10 s. I...
@ndobb , I'm starting to investigate this. Here's my approach: 1. Make easily repeatable 1. Find at least 1 simple Leaf query X that consistently times out at 60 s,...
Yes, x-odd. Yes, Leaf is working, and not logging. And yes, there's plenty of disk space. Regarding write permissions on the log directory, I've not changed them and I've asked...
Thanks @mh2727 I've returned from taking Thurs. & Fri. off. And I find that the Leaf logs started working again on Fri. Dec. 10, which is good. But I don't...
Hi @mh2727 Thank you very much. Arthur
Also, it would be really neat to be able to output graphs into an interactive graph network viewer, like vis.js!
@naiquevin Thanks for your great work!