blob: 80a56eef7c17f3f8b7c57cb82a1dce84a5a2c4e6 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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.
|
