diff options
| author | Frederick Muriuki Muriithi | 2022-03-23 09:57:05 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2022-03-23 09:57:05 +0300 |
| commit | 59f470f942d6bab9bc357d8c7fda73b580e4054f (patch) | |
| tree | 41e5f05d7951fca44b319d72d43ba06f45acc2bb | |
| parent | 7ce421df8109ef47ef6d300c135f3b3539d30143 (diff) | |
| download | gn-gemtext-59f470f942d6bab9bc357d8c7fda73b580e4054f.tar.gz | |
Add `global search connection` Issue from GitHub
| -rw-r--r-- | issues/global-search-connection-slow.gmi | 24 |
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. |