Change Details

(I don't know if this is a security issue, but since my wdqs-updater makes my wikibase instance unresponsive, I tagged it as such) Run curl https://www.wikidata.org/wiki/Special:EntityData/Q406528.ttl?flavor=dump&nocache=1706954710380 Observed behavior The connection will not be closed. Expected behavior The connection is closed like when one omits the nocache parameter Context: The request is generated by the wikidata query service updater

We recently updated the wdqs-updater following https://github.com/wmde/wikibase-release-pipeline/commit/21088b5e6030e3e3fd968a2dbc1ea71abf2c93bf After that update, the updater script of the wikidata query service does not close connections to our wikibase instance. After a few minutes over 100 open connections can be seen on the wikibase host ``` apache2ctl status Apache Server Status for localhost (via 127.0.0.1) Server Version: Apache/2.4.57 (Debian) PHP/8.1.27 Server MPM: prefork Server Built: 2023-04-13T03:26:51 ------------------------------------------------------------------------------- Current Time: Saturday, 03-Feb-2024 14:33:23 CET Restart Time: Saturday, 03-Feb-2024 14:28:53 CET Parent Server Config. Generation: 1 Parent Server MPM Generation: 0 Server uptime: 4 minutes 29 seconds Server load: 16.25 17.23 17.00 Total accesses: 920 - Total Traffic: 2.9 MB - Total Duration: 313546 CPU Usage: u44.45 s13.12 cu16.76 cs2.97 - 28.7% CPU load 3.42 requests/sec - 10.9 kB/second - 3257 B/request - 340.811 ms/request 104 requests currently being processed, 6 idle workers WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW WWWWWWWWWWWWWWWWWWWWWWW_WWWWWW_WWWWWWWWWW____W.................. ...................... Scoreboard Key: "_" Waiting for Connection, "S" Starting up, "R" Reading Request, "W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup, "C" Closing connection, "L" Logging, "G" Gracefully finishing, "I" Idle cleanup of worker, "." Open slot with no current process ``` Stopping the query service resolves the problem, and restarting it creates a lot of connections again.

(I don't know if this is a security issuWe recently updated the wdqs-updater following https://github.com/wmde/wikibase-release-pipeline/commit/21088b5e6030e3e3fd968a2dbc1ea71abf2c93bf After that update, but since my wdqs-updater makes my wikibase instance unresponsive,the updater script of the wikidata query service does not close connections to our wikibase instance. I tagged it as suchAfter a few minutes over 100 open connections can be seen on the wikibase host ``` apache2ctl status Apache Server Status for localhost (via 127.0.0.1) RunServer Version: Apache/2.4.57 (Debian) PHP/8.1.27 Server MPM: prefork Server Built: 2023-04-13T03:26:51 ------------------------------------------------------------------------------- Current Time: Saturday, 03-Feb-2024 14:33:23 CET Restart Time: Saturday, 03-Feb-2024 14:28:53 CET Parent Server Config. Generation: 1 Parent Server MPM Generation: 0 curl https://www.wikidata.org/wiki/Special:EntityData/Q406528.ttl?flavor=dump&nocache=1706954710380Server uptime: 4 minutes 29 seconds Observed behaviorServer load: 16.25 17.23 17.00 The connection will not be closed. Expected behaviorTotal accesses: 920 - Total Traffic: 2.9 MB - Total Duration: 313546 The connection is closed like when one omits the nocache parameterCPU Usage: u44.45 s13.12 cu16.76 cs2.97 - 28.7% CPU load 3.42 requests/sec - 10.9 kB/second - 3257 B/request - 340.811 ms/request 104 requests currently being processed, 6 idle workers WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW WWWWWWWWWWWWWWWWWWWWWWW_WWWWWW_WWWWWWWWWW____W.................. ...................... Context:Scoreboard Key: "_" Waiting for Connection, "S" Starting up, "R" Reading Request, "W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup, "C" Closing connection, "L" Logging, "G" Gracefully finishing, "I" Idle cleanup of worker, "." Open slot with no current process ``` Stopping the query service resolves the problem, The request is generated by the wikidata query service updaterand restarting it creates a lot of connections again.