From 7a48d26d11362472631becf189606c55019481ef Mon Sep 17 00:00:00 2001
From: Munyoki Kilyungi
Date: Wed, 28 Sep 2022 17:46:23 +0300
Subject: Track error regarding getting SNPs

* issues/error-when-fetching-snps.gmi: New issue.
* pictures/trait-search-page-1427571_at.png: Screenshot.
---
 issues/error-when-fetching-snps.gmi       |  54 ++++++++++++++++++++++++++++++
 pictures/trait-search-page-1427571_at.png | Bin 0 -> 43625 bytes
 2 files changed, 54 insertions(+)
 create mode 100644 issues/error-when-fetching-snps.gmi
 create mode 100644 pictures/trait-search-page-1427571_at.png

diff --git a/issues/error-when-fetching-snps.gmi b/issues/error-when-fetching-snps.gmi
new file mode 100644
index 0000000..68e70c2
--- /dev/null
+++ b/issues/error-when-fetching-snps.gmi
@@ -0,0 +1,54 @@
+# Error when fetching SNPs in a search page
+Wed 28 Sep 2022 17:45:01 EAT
+
+* assigned: zachs, bonfacem
+* tags: critical
+
+## Steps to reproduce
+
+* Consider this search page:
+
+=> https://genenetwork.org/show_trait?trait_id=1434280_at&dataset=HC_M2_0606_P
+
+=> https://github.com/genenetwork/gn-gemtext-threads/blob/main/pictures/trait-search-page-1427571_at.png
+
+* After clicking on "SNPs", this error is generated (full stack-trace):
+
+```
+      GeneNetwork tux01:gene:2.11-rc2-HEAD-52318e03c  http://genenetwork.org/snp_browser?first_run=true&species=mouse&gene_name=BG976607&limit_strains=on ( 2:42PM UTC Sep 28, 2022) 
+Traceback (most recent call last):
+  File "/usr/local/guix-profiles/gn-latest-20220122/lib/python3.9/site-packages/flask/app.py", line 1513, in full_dispatch_request
+    rv = self.dispatch_request()
+  File "/usr/local/guix-profiles/gn-latest-20220122/lib/python3.9/site-packages/flask/app.py", line 1499, in dispatch_request
+    return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
+  File "/home/gn2/production/gene/wqflask/wqflask/views.py", line 867, in snp_browser_page
+    template_vars = snp_browser.SnpBrowser(cursor, request.args)
+  File "/home/gn2/production/gene/wqflask/wqflask/snp_browser/snp_browser.py", line 14, in __init__
+    self.initialize_parameters(start_vars)
+TypeError: initialize_parameters() missing 1 required positional argument: 'start_vars'
+ 
+```
+
+* If you are using the provided local database, you get an error because the "RatSnpPattern" table does not exist:
+
+```
+ERROR:wqflask:http://localhost:5004/snp_browser?first_run=true&species=mouse&gene_name=BG976607&limit_strains=on ( 2:11PM UTC Sep 28, 2022)
+Traceback (most recent call last):
+  File "/home/bonface/opt/genenetwork2/lib/python3.9/site-packages/flask/app.py", line 1523, in full_dispatch_request
+    rv = self.dispatch_request()
+  File "/home/bonface/opt/genenetwork2/lib/python3.9/site-packages/flask/app.py", line 1509, in dispatch_request
+    return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
+  File "/home/bonface/projects/oqo-genenetwork2/search/wqflask/wqflask/views.py", line 859, in snp_browser_page
+    template_vars = snp_browser.SnpBrowser(request.args)
+  File "/home/bonface/projects/oqo-genenetwork2/search/wqflask/wqflask/snp_browser/snp_browser.py", line 13, in __init__
+    self.strain_lists = get_browser_sample_lists()
+  File "/home/bonface/projects/oqo-genenetwork2/search/wqflask/wqflask/snp_browser/snp_browser.py", line 672, in get_browser_sample_lists
+    cursor.execute("SHOW COLUMNS FROM RatSnpPattern")
+  File "/home/bonface/opt/genenetwork2/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
+    res = self._query(query)
+  File "/home/bonface/opt/genenetwork2/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
+    db.query(q)
+  File "/home/bonface/opt/genenetwork2/lib/python3.9/site-packages/MySQLdb/connections.py", line 259, in query
+    _mysql.connection.query(self, query)
+MySQLdb._exceptions.ProgrammingError: (1146, "Table 'db_webqtl_s.RatSnpPattern' doesn't exist")
+```
diff --git a/pictures/trait-search-page-1427571_at.png b/pictures/trait-search-page-1427571_at.png
new file mode 100644
index 0000000..baab110
Binary files /dev/null and b/pictures/trait-search-page-1427571_at.png differ
-- 
cgit v1.2.3