- Global search does not close connections properly (and is slow)
✓ issue opened on Mar 23 2022 by Frederick Muriuki Muriithi, last updated on Oct 14 2022 by Arun Isaac
...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...
- CD is slow
issue opened on Jul 20 2025 by Pjotr Prins, last updated on Jul 24 2025 by Pjotr Prins; 2 of 8 tasks done
...curl, try
```
curl -G https://query.wikidata.org/sparql -H "Accept: application/json; charset=utf-8" --data-urlencode query="SELECT DISTINCT * where {
wd:Q158695 wdt:P225 ?o .
} limit 5"
{
"head"...
- Sheepdog
issue opened on Nov 08 2021 by Pjotr Prins, last updated on Jul 01 2022 by Arun Isaac; 3 of 17 tasks done
...exists)
* [ ] synchronize between queues using a dump
* [ ] sheepdog_expect.rb - expect PINGs
* [ ] sheepdog_rsync.rb - test for 'total size is 0'
* [ ] sheepdog_list tag and filter switches improve...
- GN1 github problem
issue opened on Dec 17 2022 by Pjotr Prins
...rm --cached --ignore-unmatch \
MouseTissuesRWWMay08.xls' --prune-empty --tag-name-filter cat -- --all
git reflog expire --expire=now --all && git gc --prune=now --aggressive
```
Note this rewrites...
- Designing an issue tracker on gemini
✓ issue opened on Jul 25 2021 by Pjotr Prins, last updated on Feb 02 2022 by Pjotr Prins
...testing
* later
* documentation
* help wanted
* closed
the keyword statement may have aliases, such as tag and kanban. To undo a keyword simply remove them from the file.
Can't think of anything...
- Slow query
issue opened on May 27 2023 by Pjotr Prins, last updated on May 29 2023 by Pjotr Prins; 0 of 2 tasks done
...query.
## Indices
ProbeSet has a large number of columns, indices and full text indices(!)
## Nailing it down
The obvious thing to try is to reduce the query and see what speeds it up again. So, let's...
- Slow query
issue opened on Mar 23 2022 by Frederick Muriuki Muriithi
Slow query
## Tags
* assigned: Uditgulati
* priority: high
* status: stalled
* keywords: slow query, from github
## Description
=> https://github.com/genenetwork/genenetwork2/issues/419...
- AI UI Enhancements
issue opened on Mar 01 2024 by Pjotr Prins; 0 of 3 tasks done
...GN searched for the term(s) "shh" in 754 datasets and 39,765,944 traits across 10 species
and found 1210 results that match your query.
You can filter these results by adding key words in the fields...
- Parsing genotyfiles
issue opened on Jul 11 2023 by Alexander_Kabui
...the genofile identify
the file in the GENOTYPE_FILES and extract sample_listx
for entire parsing code refer to:
=> https://github.com/genenetwork/genenetwork3/blob/main/gn3/db/genotypes.py
* Linked...
- Add the option to save traits uploaded with the Submit Trait option
issue opened on Jul 19 2022 by Zachary Sloan
...limited period of time).
There are two main changes/additions that should be made to this:
- Allow data to be submitted via a CSV upload
- Allow data to be saved to the DB via an "Add" (or maybe "Save")...
- csv export meta data are not commented out
issue opened on Mar 22 2022 by Frederick Muriuki Muriithi
...45-60 min after injection in an activity chamber for males [n beam breaks]"
"Authors: Philip VM, Ansah TA, Blaha CD, Cook MN, Hamre KM, Lariviere WR, Matthews DB, Mittleman G, Goldowitz D, Chesler EJ"...
- Variant Browser seems to be using mm9
issue opened on Mar 22 2022 by Frederick Muriuki Muriithi
...do not match the query.
Searching for a gene gives correct coordinates in the search box at http://www.genenetwork.org/snp_browser, but the results are for the same coordinates in mm9 (see screenshot).
- Fetch trait names for phenotypes
issue opened on Mar 22 2022 by Frederick Muriuki Muriithi
.../564 From GitHub
The 'Fetch Trait Info' query returns detailed information for transcript expression traits, but not for traits from the 'Publish' database.
### Describe the solution you'd like
For...
- Tux02 Production
issue opened on Oct 07 2021 by Pjotr Prins, last updated on Jun 13 2025 by Pjotr Prins; 17 of 22 tasks done
...the recovered backup. Restart the DB and run mysql_upgrade followed by our tests. E.g.
```
systemctl stop mariadb
ln -s /export2/mysql/borg-backup-mariadb-20211024-03\:09-Sun /var/lib/mysql
systemctl...
- Add track for showing which regions in mouse/rat correspond to human regions to the mapping figure
issue opened on Jul 21 2022 by Zachary Sloan, last updated on Sep 14 2022 by Pjotr Prins
...showing homology across mouse/human/maybe rat (done for mouse, won't be hard to also enable for other species)
[ ] Make it display an arrow depending on the strand (whether the query strand matches...
- Annotate traits page with metadata from RDF
✓ issue opened on Sep 30 2022 by Munyoki Kilyungi, last updated on Dec 15 2022 by Munyoki Kilyungi; 16 of 16 tasks done
...query for the trait:
```
PREFIX gn: <http://genenetwork.org/>
SELECT ?name ?dataset ?dataset_group ?title ?summary ?aboutTissue ?aboutPlatform ?aboutProcessing
WHERE {
?dataset gn:accessionId "GN112"...
- GN2 Time Machines
issue opened on Aug 19 2022 by Pjotr Prins, last updated on Sep 05 2022 by Alexander_Kabui; 4 of 10 tasks done
.../lib/mysql
```
Check them and symlink the DB dir:
```
root@epysode:/export/tux01-mirror#
cp -vau /export2/tux01-restore/home/backup/tux01_mariadb_new .
systemctl stop mariadb
ln -s /export/tux01-mirror/...
- Fallback issues
issue opened on Mar 22 2024 by Pjotr Prins, last updated on Apr 05 2024 by Pjotr Prins; 3 of 6 tasks done
...path, query, fragment = parse_url(url)
File "/gnu/store/a39cgbdawj9vp24nsz9q25sf9g5vda7c-profile/lib/python3.10/site-packages/urllib3/util/url.py", line 397, in parse_url
return six.raise_from...