Skip to content

Instantly share code, notes, and snippets.

@ahmgithubahm
Last active April 3, 2024 10:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ahmgithubahm/39f10fb7f5e7f4dbe3402e4cc17b1c33 to your computer and use it in GitHub Desktop.
Save ahmgithubahm/39f10fb7f5e7f4dbe3402e4cc17b1c33 to your computer and use it in GitHub Desktop.
Indico issue
2024-04-03 10:42:44,841 INFO 2e25126258a14b99 - indico.rh GET /register/?next=/event/936/contributions/8849/ [IP=nnn.nnn.nnn.nnn] [PID=1470607]
2024-04-03 10:42:44,852 ERROR 2e25126258a14b99 - indico.flask (psycopg2.OperationalError) could not translate host name "indico-db.internal.ourdomain.tld" to address: Name or service not known
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Traceback (most recent call last):
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/core/settings/util.py", line 54, in get_setting
value = cache[cache_key]
KeyError: (<class 'indico.core.settings.proxy.SettingsProxy'>, 'announcement', 'enabled', frozenset())
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3366, in _wrap_pool_connect
return fn()
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 327, in connect
return _ConnectionFairy._checkout(self)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 894, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 498, in checkout
rec._checkin_failed(err, _fairy_was_created=False)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
raise exception
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
dbapi_connection = rec.get_connection()
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 659, in get_connection
self.__connect()
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 691, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
raise exception
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 686, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/create.py", line 574, in connect
return dialect.connect(*cargs, **cparams)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 598, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/opt/indico/.venv/lib/python3.9/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: could not translate host name "indico-db.internal.ourdomain.tld" to address: Name or service not known
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/indico/.venv/lib/python3.9/site-packages/flask/app.py", line 1484, in full_dispatch_request
rv = self.dispatch_request()
File "/opt/indico/.venv/lib/python3.9/site-packages/flask/app.py", line 1469, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/flask/util.py", line 79, in wrapper
return obj().process()
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/rh.py", line 295, in process
handle_sqlalchemy_database_error() # this will re-raise an exception
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/rh.py", line 285, in process
res = self._do_process()
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/rh.py", line 256, in _do_process
rv = self._process()
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/modules/auth/controllers.py", line 267, in _process
return self._process_verify(handler)
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/modules/auth/controllers.py", line 287, in _process_verify
return WPSignup.render_template('register_verify.html', form=form, email_sent=email_sent)
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/views.py", line 129, in render_template
return cls(g.rh, *wp_args, **context).display()
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/views.py", line 271, in display
body = self._display(params)
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/views.py", line 359, in _display
return self._apply_decoration(self._get_body(params | self._kwargs))
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/views.py", line 356, in _apply_decoration
self._get_header(), breadcrumbs, body, self._get_footer())
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/views.py", line 348, in _get_header
return render_header()
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/views.py", line 40, in render_header
return render_template('header.html',
File "/opt/indico/.venv/lib/python3.9/site-packages/flask/templating.py", line 151, in render_template
return _render(app, template, context)
File "/opt/indico/.venv/lib/python3.9/site-packages/flask/templating.py", line 132, in _render
rv = template.render(context)
File "/opt/indico/.venv/lib/python3.9/site-packages/jinja2/environment.py", line 1301, in render
self.environment.handle_exception()
File "/opt/indico/.venv/lib/python3.9/site-packages/jinja2/environment.py", line 936, in handle_exception
raise rewrite_traceback_stack(source=source)
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/templates/header.html", line 6, in top-level template code
{{ render_announcements(legacy=true) }}
File "/opt/indico/.venv/lib/python3.9/site-packages/jinja2/runtime.py", line 777, in _invoke
rv = self._func(*arguments)
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/modules/announcement/templates/display.html", line 38, in template
{% set announcements = template_hook('global-announcement', as_list=true) %}
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/flask/templating.py", line 208, in call_template_hook
for snippet in values_from_signal(signals.plugin.template_hook.send(str(name), **kwargs),
File "/opt/indico/.venv/lib/python3.9/site-packages/blinker/base.py", line 300, in send
result = receiver(sender, **kwargs) # type: ignore[call-arg]
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/flask/templating.py", line 177, in _func
res = receiver(**kw)
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/modules/announcement/__init__.py", line 27, in _inject_announcement_header
if not announcement_settings.get('enabled'):
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/core/settings/proxy.py", line 242, in get
return get_setting(Setting, self, name, default, self._cache)
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/core/settings/util.py", line 58, in get_setting
setting = _preload_settings(cls, proxy, cache, **kwargs).get(name, _not_in_db)
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/core/settings/util.py", line 19, in _preload_settings
settings = cls.get_all(proxy.module, **kwargs)
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/core/settings/models/base.py", line 113, in get_all
for s in cls.query.filter_by(**kwargs):
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2901, in __iter__
result = self._iter()
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter
result = self.session.execute(
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1716, in execute
conn = self._connection_for_bind(bind)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1555, in _connection_for_bind
return self._transaction._connection_for_bind(
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 750, in _connection_for_bind
conn = bind.connect()
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3320, in connect
return self._connection_cls(self, close_with_result=close_with_result)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
else engine.raw_connection()
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3399, in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3369, in _wrap_pool_connect
Connection._handle_dbapi_exception_noconnection(
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2203, in _handle_dbapi_exception_noconnection
util.raise_(
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
raise exception
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3366, in _wrap_pool_connect
return fn()
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 327, in connect
return _ConnectionFairy._checkout(self)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 894, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 498, in checkout
rec._checkin_failed(err, _fairy_was_created=False)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
raise exception
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
dbapi_connection = rec.get_connection()
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 659, in get_connection
self.__connect()
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 691, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
raise exception
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 686, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/create.py", line 574, in connect
return dialect.connect(*cargs, **cparams)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 598, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/opt/indico/.venv/lib/python3.9/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not translate host name "indico-db.internal.ourdomain.tld" to address: Name or service not known
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment