Timeout for REST API Item creation on Staging Portal

[MarcoReidelbach]

Describe the bug
When creating an item via the Wikibase REST API on staging.mardi4nfdi.org, the request returns HTTP 200 but with an HTML fatal error in the response body instead of JSON and no item creation. Error messages received in different trials

Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/html/w/includes/libs/Rdbms/Database/DatabaseMySQL.php on line 689

Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/html/w/includes/libs/Rdbms/Database/Database.php on line 405

Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/html/w/includes/libs/Rdbms/Database/Query.php on line 52

Creating new items like this worked without problems in the past.

Expected behavior

• Create new item upon post request.
  (- Do not return 200 in such cases)

To Reproduce

Send paylod, e.g.

{"item": {"labels": {"en": "abc"}, "descriptions": {"en": "def"}, "statements": {"P3": [{"property": {"id": "P3", "data_type": "wikibase-item"}, "value": {"type": "value", "content": "Q3758"}}], "P582": [{"property": {"id": "P582", "data_type": "wikibase-item"}, "value": {"type": "value", "content": "Q3842"}}], "P583": [{"property": {"id": "P583", "data_type": "wikibase-item"}, "value": {"type": "value", "content": "Q13354"}}]}}}

to endpoint

https://staging.mardi4nfdi.org/w/rest.php/wikibase/v1/entities/items

Checklist for this issue:
(Some checks for making sure this issue is completely formulated)

• Assignee has been set for this issue
• All fields of the issue have been filled
• the main MaRDI project has been assigned as project

[timconrad]

@physikerwelt I remember you changed some of the behaviour of the staging portal - can you please check what is the status here?

[physikerwelt]

I don't think we should increase the limits. Is this reproducible?

Operational note for API timeouts

For staging API item-creation timeouts, increasing PHP's max_execution_time is not a good fix:

• It only hides the real bottleneck (typically slow/blocked DB queries) and keeps requests expensive.
• Longer-running requests reduce portal capacity, increasing queueing and failure risk for other users.
• The proper fix is to investigate and optimize the underlying query/locking/performance issue.

[eloiferrer]

@MarcoReidelbach Can you check whether this is still happening?
I was able to create an item through the API and did not get an error back: https://staging.mardi4nfdi.org/wiki/Item:Q21837

[MarcoReidelbach]

@eloiferrer I tried it, still the same behavior.

[eloiferrer]

This was apparently caused by a regression in the OAuth extension which I have now temporarily patched: MaRDI4NFDI/docker-wikibase#344

The fix will also be part of the wmf/1.47.0-wmf.13 release. Once this is released we can remove the patch.

@MarcoReidelbach can you check again whether it works now (in staging)?

[MarcoReidelbach]

@eloiferrer works again (in staging)