GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — Give MappingQueryFbFixture its own test store. by niekschoemaker · Pull Request #1297 · FirebirdSQL/NETProvider

Conversation

@niekschoemaker

@niekschoemaker niekschoemaker commented Nov 4, 2026 •
edited
Loading

Uh oh!

There was an error while loading. Please reload this page.

Copy link
Copy Markdown
Contributor

MappingQueryFixtureBase uses the "Northwind" store name with a reduced model. FbTestStore creates a shared store from the model of the first fixture that uses it, so whenever MappingQueryFbTest happened to run before the Northwind tests, EFCore_Northwind.fdb was created without e.g. Products and Customers.City and every Northwind test failed with "Column unknown"/"Table unknown".

I noticed some tests randomly hang/fail, so decided to let AI dig through the enormous log files to figure out if there's any pattern that could cause the flaky tests, and it found that whenever MappingQueryFbTest runs before the Northwind tests all the northwind tests would fail.

The tests were writen for SQL Server which uses a script to generate the database, so SQL Server doesn't run into this issue, but since this provider use EnsureCreatedAsync the tests would fail whenever MappingQuery runs before the Northwind tests. So with some luck this should fix the random test failures and hangs.

Sorry, something went wrong.

Uh oh!

There was an error while loading. Please reload this page.

All reactions
@niekschoemaker @claude
Give MappingQueryFbFixture its own test store.
117e2df
MappingQueryFixtureBase uses the "Northwind" store name with a reduced model. FbTestStore creates a shared store
from the model of the first fixture that uses it, so whenever MappingQueryFbTest happened to run before the
Northwind tests, EFCore_Northwind.fdb was created without e.g. Products and Customers.City and every Northwind
test failed with "Column unknown"/"Table unknown".

Co-Authored-By: Claude Opus 5.5 <[email protected]>
@niekschoemaker
niekschoemaker marked this pull request as ready for review November 4, 2026 15:26
@niekschoemaker

niekschoemaker commented Nov 4, 2026 •
edited
Loading

Uh oh!

There was an error while loading. Please reload this page.

Copy link
Copy Markdown
Contributor Author

This still doesn't explain why it hangs, it does explain why it fails, but maybe the failure is also what causes the hang, but that's something that time will tell, as flaky tests are quite difficult to test.

All reactions

Sorry, something went wrong.

Uh oh!

There was an error while loading. Please reload this page.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Uh oh!

There was an error while loading. Please reload this page.

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

Uh oh!

There was an error while loading. Please reload this page.

1 participant

@niekschoemaker
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.