diff options
| -rw-r--r-- | issues/unresponsive-rdf-in-cd.gmi | 64 | ||||
| -rw-r--r-- | topics/systems/virtuoso.gmi | 2 |
2 files changed, 65 insertions, 1 deletions
diff --git a/issues/unresponsive-rdf-in-cd.gmi b/issues/unresponsive-rdf-in-cd.gmi new file mode 100644 index 0000000..dffa2fb --- /dev/null +++ b/issues/unresponsive-rdf-in-cd.gmi @@ -0,0 +1,64 @@ +# Unresponsive Virtuoso in CD + +* assigned: bonfacem +* tags: critical + +## Description + +In CD, when you navigate to a datasets page, say: + +=> https://cd.genenetwork.org/datasets/BXDPublish /datasets/BXDPublish + +you get the following stack trace: + +``` + GeneNetwork 2.11-rc2 https://cd.genenetwork.org/datasets/BXDPublish (11:31AM UTC Apr 02, 2024) +Traceback (most recent call last): + File "/gnu/store/jl6x90wdbwbs7c7zxnyz2kfd0qx8bf5h-profile/lib/python3.10/site-packages/flask/app.py", line 1523, in full_dispatch_request + rv = self.dispatch_request() + File "/gnu/store/jl6x90wdbwbs7c7zxnyz2kfd0qx8bf5h-profile/lib/python3.10/site-packages/flask/app.py", line 1509, in dispatch_request + return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) + File "/genenetwork2/gn2/wqflask/views.py", line 1176, in get_dataset + return render_template( + File "/gnu/store/jl6x90wdbwbs7c7zxnyz2kfd0qx8bf5h-profile/lib/python3.10/site-packages/flask/templating.py", line 148, in render_template + return _render( + File "/gnu/store/jl6x90wdbwbs7c7zxnyz2kfd0qx8bf5h-profile/lib/python3.10/site-packages/flask/templating.py", line 128, in _render + rv = template.render(context) + File "/gnu/store/jl6x90wdbwbs7c7zxnyz2kfd0qx8bf5h-profile/lib/python3.10/site-packages/jinja2/environment.py", line 1291, in render + self.environment.handle_exception() + File "/gnu/store/jl6x90wdbwbs7c7zxnyz2kfd0qx8bf5h-profile/lib/python3.10/site-packages/jinja2/environment.py", line 926, in handle_exception + raise rewrite_traceback_stack(source=source) + File "/genenetwork2/gn2/wqflask/templates/dataset.html", line 1, in top-level template code + {% extends "base.html" %} + File "/genenetwork2/gn2/wqflask/templates/base.html", line 200, in top-level template code + {% block content %} + File "/genenetwork2/gn2/wqflask/templates/dataset.html", line 91, in block 'content' + <a hx-get={{ url_for('metadata.view_history', id_=dataset.id.split('/')[-1], name=name, title=(dataset.title or dataset.label or dataset.altLabel)) }} hx-target=".dataset-content" hx-push-url="true" hx-select="#history">History</a> + File "/gnu/store/jl6x90wdbwbs7c7zxnyz2kfd0qx8bf5h-profile/lib/python3.10/site-packages/jinja2/environment.py", line 475, in getattr + return getattr(obj, attribute) +jinja2.exceptions.UndefinedError: 'dict object' has no attribute 'id' +``` + +Doing a CURL on the CD RDF endpoint yields: + + +``` +╭─munyoki@saitama ~ ╰─➤ curl https://cd.genenetwork.org/api3/metadata/datasets/BXDPublish +{} +``` + +## Resolution + +At one point, CD was restarted and the password was not set. To remedy this: + +``` +SQL> set password "dba" "XXXXXXXXXX"; +SQL> UPDATE ws.ws.sys_dav_user SET u_account_disabled=1 WHERE u_name='dav'; +SQL> CHECKPOINT; +``` + +Refer to the following for more details: + +=> /topics/systems/virtuoso Configuring Virtuoso + +* closed diff --git a/topics/systems/virtuoso.gmi b/topics/systems/virtuoso.gmi index c6a42cf..e911a8b 100644 --- a/topics/systems/virtuoso.gmi +++ b/topics/systems/virtuoso.gmi @@ -104,7 +104,7 @@ After running virtuoso, you will want to change the default password of the `dba In a typical production virtuoso installation, you will want to change the password of the dba user and disable the dav user. Here are the commands to do so. Pay attention to the single versus double quoting. ``` -SQL> set password "dba" "new-password"; +SQL> set password "dba" "rFw,OntlJ@Sz"; SQL> UPDATE ws.ws.sys_dav_user SET u_account_disabled=1 WHERE u_name='dav'; SQL> CHECKPOINT; ``` |