summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--issues/global-search-connection-slow.gmi24
1 files changed, 24 insertions, 0 deletions
diff --git a/issues/global-search-connection-slow.gmi b/issues/global-search-connection-slow.gmi
new file mode 100644
index 0000000..80a56ee
--- /dev/null
+++ b/issues/global-search-connection-slow.gmi
@@ -0,0 +1,24 @@
+# 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
+
+=> https://github.com/genenetwork/genenetwork2/issues/418 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.