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

TooManySortsException from Microsoft.Isam.Esent.Interop.Api.GetColumnDictionary() at startup #550

Closed
nblumhardt opened this issue Apr 13, 2017 · 4 comments

Comments

Projects
None yet
1 participant
@nblumhardt
Copy link
Member

commented Apr 13, 2017

On one particular machine, we've had the following issue reported when loading Seq's metadata (document) store:

Microsoft.Isam.Esent.Interop.EsentTooManySortsException: Too many sort processes
   at Microsoft.Isam.Esent.Interop.Api.Check(Int32 err)
   at Microsoft.Isam.Esent.Interop.Api.JetGetTableColumnInfo(JET_SESID sesid, JET_TABLEID tableid, String columnName, JET_COLUMNLIST& columnlist)
   at Microsoft.Isam.Esent.Interop.Api.GetColumnDictionary(JET_SESID sesid, JET_TABLEID tableid)

The error appears even after a completely new database is created, suggesting that there's some machine-specific issue going on.

As mentioned in #549, we're planning to update the Esent.Interop.dll dependency to take advantage of a number of bug fixes in the latest version. We've provided the customer experiencing this with an updated Seq build and will hopefully be able to confirm soon whether the issue is indeed version-specific.

@nblumhardt nblumhardt added the bug label Apr 13, 2017

@nblumhardt nblumhardt added this to the 4.0-pre milestone Apr 20, 2017

@nblumhardt

This comment has been minimized.

Copy link
Member Author

commented Apr 20, 2017

Updating Esent.Interop.dll does appear to have fixed this so far (if we hear otherwise I'll re-open).

@nblumhardt nblumhardt closed this Apr 20, 2017

@nblumhardt

This comment has been minimized.

Copy link
Member Author

commented Oct 12, 2017

We've seen this in the wild in version 4.1.17, reopening so that our findings can be recorded here.

@nblumhardt nblumhardt reopened this Oct 12, 2017

@nblumhardt nblumhardt removed this from the 4.0.58 milestone Oct 12, 2017

@nblumhardt

This comment has been minimized.

Copy link
Member Author

commented Oct 12, 2017

Possibly more-specific information about the error, from https://msdn.microsoft.com/en-us/library/gg269211(v=exchg.10).aspx:

JET_errTooManySorts The operation failed because the engine cannot allocate the resources required to create a temporary table. Temporary table resources are configured using JetSetSystemParameter with JET_paramMaxTemporaryTables.

@nblumhardt nblumhardt added this to the 4.2-pre milestone Oct 16, 2017

@nblumhardt

This comment has been minimized.

Copy link
Member Author

commented Oct 16, 2017

Settting JET_paramMaxTemporaryTables appears to have addressed this; will reopen if any further issues are reported.

@nblumhardt nblumhardt closed this Oct 16, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.