Bricked with 502 bad gateway

[ciocead4]

Hello community,
I've been running Inventree since more than one year in a Proxmox->Lxc->docker container. I have recently got into the "502 Bad Gateway" issue. My thought was that when adding another Lxc container, something got updated so the older Inventree Lxc does not run (although the containers should be isolated from each other).
I have tried to "docker compose run --rm inventree-server invoke update" but it fails with:
"...
pg_dump: error: could not translate host name "inventree-db" to address: Name does not resolve

File "/root/.local/lib/python3.11/site-packages/dbbackup/utils.py", line 119, in wrapper
func(*args, **kwargs)
File "/root/.local/lib/python3.11/site-packages/dbbackup/management/commands/dbbackup.py", line 100, in handle
self._save_new_backup(database)
File "/root/.local/lib/python3.11/site-packages/dbbackup/management/commands/dbbackup.py", line 120, in _save_new_backup
outputfile = self.connector.create_dump()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/.local/lib/python3.11/site-packages/dbbackup/db/base.py", line 93, in create_dump
return self._create_dump()
^^^^^^^^^^^^^^^^^^^
File "/root/.local/lib/python3.11/site-packages/dbbackup/db/postgresql.py", line 128, in _create_dump
stdout, _ = self.run_command(cmd, env=self.dump_env)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/.local/lib/python3.11/site-packages/dbbackup/db/base.py", line 172, in run_command
raise exceptions.CommandConnectorError(

Traceback (most recent call last):
File "/home/inventree/src/backend/InvenTree/manage.py", line 24, in
main()
File "/home/inventree/src/backend/InvenTree/manage.py", line 20, in main
execute_from_command_line(sys.argv)
File "/root/.local/lib/python3.11/site-packages/django/core/management/init.py", line 442, in execute_from_command_line
utility.execute()
File "/root/.local/lib/python3.11/site-packages/django/core/management/init.py", line 436, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/root/.local/lib/python3.11/site-packages/django/core/management/base.py", line 412, in run_from_argv
self.execute(*args, **cmd_options)
File "/root/.local/lib/python3.11/site-packages/django/core/management/base.py", line 458, in execute
output = self.handle(*args, **options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/.local/lib/python3.11/site-packages/dbbackup/utils.py", line 119, in wrapper
func(*args, **kwargs)
File "/root/.local/lib/python3.11/site-packages/dbbackup/management/commands/dbbackup.py", line 100, in handle
self._save_new_backup(database)
File "/root/.local/lib/python3.11/site-packages/dbbackup/management/commands/dbbackup.py", line 120, in _save_new_backup
outputfile = self.connector.create_dump()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/.local/lib/python3.11/site-packages/dbbackup/db/base.py", line 93, in create_dump
return self._create_dump()
^^^^^^^^^^^^^^^^^^^
File "/root/.local/lib/python3.11/site-packages/dbbackup/db/postgresql.py", line 128, in _create_dump
stdout, _ = self.run_command(cmd, env=self.dump_env)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/.local/lib/python3.11/site-packages/dbbackup/db/base.py", line 172, in run_command
raise exceptions.CommandConnectorError(
dbbackup.db.exceptions.CommandConnectorError: Error running: pg_dump --dbname=postgresql://inv_db_user:inv_p5p@inventree-db:5432/inventree --format=custom
pg_dump: error: could not translate host name "inventree-db" to address: Name does not resolve

ERROR: InvenTree command failed: 'python3 manage.py dbbackup --noinput --compress -v 2'

• Refer to the error messages in the log above for more information
  "

For me it looks like postgres database issue but docker compose up -d shows normal:

[+] Running 4/4
✔ Container inventree-server Started 6.6s
✔ Container inventree-worker Started 0.4s
✔ Container inventree-proxy Started 0.4s
✔ Container inventree-db Started

Thanks in advance for any advice,
Daniel

[SchrodingersGat]

The error message indicates that (for whatever reason) the inventree server container cannot "see" the database container for the backup operation

Proxmox->Lxc->docker container

This setup is outside the scope of what we can document and support with regards to docker. Maybe someone who is more familiar with proxmox can assist here

[ciocead4]

Just wanted to report back, I managed to solve the problem. Initial issue was caused by my rookie attempt to tar.gz the /data folder as a backup. The operation succeeded but also duplicated each asset file within database by a *.gz copy. The resulted set of files rendered the database malfunctioning.
The fix was easy, extract and delete each *.gz file within /data folder, followed by invoke update procedure.