GH-1577 / Make processNewOrUpdatedSchema asynchronous

[lampajr]

Short term fix for of #1577

Feature idea.

Since fixing #1577 in the proper way could require some additional refactoring, that could have other implication, as short-term goal we decided to make the processNewOrUpdatedSchema

Horreum/horreum-backend/src/main/java/io/hyperfoil/tools/horreum/svc/RunServiceImpl.java

Lines 176 to 182 in 3849f04

	void processNewOrUpdatedSchema(SchemaDAO schema) {
	// we don't have to care about races with new runs
	findRunsWithUri(schema.uri, (runId, testId) -> {
	log.debugf("Recalculate Datasets for run %d - schema %d (%s) changed", runId, schema.id, schema.uri);
	onNewOrUpdatedSchemaForRun(runId, schema.id);
	});
	}

asynchronous, such that the creation/update of a Schema would become quite immediate and the run_schemas update (especially the FIND_RUNS_WITH_URI query execution) is handled asynchronously.

Describe the solution you'd like

Create a new channel to manage this new event type, on event receiving, trigger the processNewOrUpdatedSchema method.

Additional information

n/a

[lampajr]

Worth to note that with this (temporary) approach we should stick with an increased transaction timeout (~120s) otherwise the FIND_RUNS_WITH_URI query will go in timeout even in the async process.

[willr3]

This approach should also include some update to the UI so that the user knows the change is being processed in the background. There are parts of UI (e.g. assigning a run's schema) that relied on this being a synchronous operation.

[lampajr]

This approach should also include some update to the UI so that the user knows the change is being processed in the background. There are parts of UI (e.g. assigning a run's schema) that relied on this being a synchronous operation.

Good point, since this is meant to be (hopefully) a temporary solution, do you think it would be enough to show a popup/warning/alert on schema save?

[willr3]

Something in the banner display or any other inline popup might work. I would avoid any use of alert or a modal.