💾 Archived View for thebird.nl › gn-gemtext-threads › issues › global-search-connection-slow.gmi captured on 2022-07-16 at 15:47:19. Gemini links have been rewritten to link to archived content

View Raw

More Information

⬅️ Previous capture (2022-04-28)

➡️ Next capture (2023-01-29)

-=-=-=-=-=-=-

Global search does not close connections properly (and is slow)

Tags

• type: bug
• priority: medium
• status: stalled
• assigned: Uditgulati
• keywords: global search, db connections, medium priority, from github

Description

From GitHub

Global search '*' causes loads of aborted connections... I mean

  2020-08-15  2:53:58 140273206434560 [Warning] Aborted connection 45219 to db: 'db_webqtl' user: 'webqtlout' host: '127.0.0.1' (CLOSE_CONNECTION)

generating 6Mb of log file info.

In fact, every row in the table has a SQL query that does not close the connection properly.