Page MenuHomePhabricator

/admin/django_comments/comment throws fatal error
Closed, ResolvedPublic

Description

Traceback
Internal Server Error: /admin/django_comments/comment/
Traceback (most recent call last):
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/core/handlers/base.py", line 164, in get_response
    response = response.render()
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/response.py", line 158, in render
    self.content = self.rendered_content
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/response.py", line 135, in rendered_content
    content = template.render(context, self._request)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/backends/django.py", line 74, in render
    return self.template.render(context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 210, in render
    return self._render(context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 202, in _render
    return self.nodelist.render(context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 905, in render
    bit = self.render_node(node, context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 919, in render_node
    return node.render(context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/loader_tags.py", line 135, in render
    return compiled_parent._render(context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 202, in _render
    return self.nodelist.render(context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 905, in render
    bit = self.render_node(node, context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 919, in render_node
    return node.render(context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/loader_tags.py", line 135, in render
    return compiled_parent._render(context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 202, in _render
    return self.nodelist.render(context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 905, in render
    bit = self.render_node(node, context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 919, in render_node
    return node.render(context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/loader_tags.py", line 65, in render
    result = block.nodelist.render(context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 905, in render
    bit = self.render_node(node, context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 919, in render_node
    return node.render(context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/loader_tags.py", line 65, in render
    result = block.nodelist.render(context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 905, in render
    bit = self.render_node(node, context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 919, in render_node
    return node.render(context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/template/base.py", line 1273, in render
    _dict = func(*resolved_args, **resolved_kwargs)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/contrib/admin/templatetags/admin_list.py", line 397, in date_hierarchy
    } for year in years]
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/db/models/query.py", line 162, in __iter__
    self._fetch_all()
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/db/models/query.py", line 965, in _fetch_all
    self._result_cache = list(self.iterator())
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/db/models/query.py", line 1217, in iterator
    for row in compiler.results_iter():
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 800, in results_iter
    row = self.apply_converters(row, converters)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 784, in apply_converters
    value = converter(value, expression, self.connection, self.query.context)
  File "/var/www/tracker.wikimedia.cz/deploy/pyenv/lib/python2.7/site-packages/django/db/models/expressions.py", line 927, in convert_value
    "Database returned an invalid value in QuerySet.datetimes(). "
ValueError: Database returned an invalid value in QuerySet.datetimes(). Are time zone definitions for your database and pytz installed?

With no comment, it works (locally). It also works with some comments added. Dump of prod django_comments (user_email and ip_address set to empty string/NULL; nonpublic/removed comments deleted) is attached.

Event Timeline

Urbanecm moved this task from Inbox to Bugs on the WMCZ-Tracker board.
Urbanecm triaged this task as Medium priority.Jan 18 2019, 6:58 PM

Have done testing locally and am pretty certain that the root of the issue is that some timezone information has not been imported into the SQL server - a sysadmin will need to run the following command and then flush tables to fix.

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
Urbanecm assigned this task to IAmNetx.

Done, problem fixed.

urbanecm@benes ~
$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
Enter password:
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
urbanecm@benes ~
$