Error in workflow: too many attached databases - max 10

Question

Error in workflow: too many attached databases - max 10

mstrohFG opened this issue 4 years ago · 13 comments

Hello, Kevin.

I just downloaded version 2.0.0 and at first it was working great. A fantastic Alfred tool that will definitely help my day-to-day work. I had about 5 notebooks on my local OneNote app on my Mac and I was able to run 1a, 1r, 1m no problem. My Notebooks are all stored on SharePoint in my corporate tenet.

I then went into OneNote and and "added notebooks" to bring more books into my local rather than using the browser to view/edit the notebooks (which is how I usually access them). Once I added more than 10 notebooks, though, I got this error.

Error in workflow: 'OneNote Navigator'
too many attached databases - max 10

learn2reid commented 2 years ago

solution?

Answer 1 · 2021-02-12T21:48:20.000Z

+1
I have a bunch of notebooks...maybe a configuration setting to choose which to make searchable would work?

Answer 2 · 2021-03-06T10:19:34.000Z

I do have the same problem as I have 20+ Notebooks. Is there any way to resolve it?

Answer 3 · 2021-03-06T16:47:15.000Z

I see what you mean, so OneNote considers every notebook to be a database, so what I wanted was to be able to perform one search that searched every database. My solution was to consolidate all of the databases into one somewhat temporary database by attaching each database then performing the search, but it appears as if SQLitehas a limit to how many databases can be attached (which appears to be 10)

I personally only have 4 notebooks (but they are but they are very dense) which is why I didn't run into this problem while testing.

I will look into a solution and see what I can find out.

Answer 4 · 2021-03-07T17:13:05.000Z

I have seen that the default limit for attached databases is indeed defined with 10. Based on the following link it can be increased of up to 125 which should solve the issue :-)
https://www.sqlite.org/limits.html#:~:text=The%20number%20of%20simultaneously%20attached,cannot%20be%20increased%20above%20125.

SQLITE_LIMIT_ATTACHED
The maximum number of attached databases.

Would be great if you could set it somewhere in the code.

Answer 5 · 2021-04-30T06:01:51.000Z

Is there any possibility that someone could fix it? This would be so useful, in fact only then it can be used and I would highly appreciate it.

Answer 6 · 2021-04-30T19:24:18.000Z

Or any help or suggestion would be useful too

Answer 7 · 2021-06-04T05:55:04.000Z

appreciate if someone can fix this

Answer 8 · 2021-09-03T03:04:09.000Z

Anyone try to adjust the SQLLite ATTACH limit that @sysdevtra recommended?

Answer 9 · 2022-02-21T16:33:36.000Z

Any news on a solution @kevin-funderburg ? Not sure where and how it works but theoretically the attach limit can be raised to at least 62.

Answer 10 · 2022-05-03T03:20:31.000Z

I too am running into this problem, hoping to bump this issue. Thanks!

Answer 11 · 2024-03-05T21:40:23.000Z

any solution as of today ?

Answer 12 · 2024-09-10T06:54:08.000Z

Any potential workarounds for this? I also have many more notebooks, and it's not usable at the moment.