After updating to 5.0.6-0 web interface is not accessible, and network shares are also not accessible

OK… so far it all is coherent. Let’s see if rockstor.log has more info as to what part of initrock.py fails:

cat /opt/rockstor/var/log/rockstor.log | grep "18/Jan"

[18/Jan/2023 14:16:17] INFO [scripts.initrock:269] Normalising on shellinaboxd service file
[18/Jan/2023 14:16:17] INFO [scripts.initrock:273] - shellinaboxd.service already exists
[18/Jan/2023 14:16:17] INFO [scripts.initrock:328] /etc/systemd/system/rockstor-pre.service up-to-date.
[18/Jan/2023 14:16:17] INFO [scripts.initrock:328] /etc/systemd/system/rockstor.service up-to-date.
[18/Jan/2023 14:16:17] INFO [scripts.initrock:328] /etc/systemd/system/rockstor-bootstrap.service up-to-date.
[18/Jan/2023 14:16:17] INFO [scripts.initrock:328] /etc/systemd/system/rockstor-ipv6check.service up-to-date.
[18/Jan/2024 16:31:51] INFO [system.pkg_mgmt:464] Updating all but rockstor package for distro opensuse
[18/Jan/2024 15:36:56] INFO [scripts.initrock:546] Checking for flash and Running flash optimizations if appropriate.
[18/Jan/2024 15:36:57] INFO [scripts.initrock:549] Updating the timezone from the system
[18/Jan/2024 15:36:57] INFO [scripts.initrock:221] system timezone = Europe/Copenhagen
[18/Jan/2024 15:36:57] INFO [scripts.initrock:234] Changed timezone from “Europe/Lisbon” to Europe/Copenhagen
[18/Jan/2024 15:36:57] INFO [scripts.initrock:556] Initialising SSHD config
[18/Jan/2024 15:36:57] INFO [system.ssh:394] SSHD (/etc/ssh/sshd_config) sftp-server already disabled
[18/Jan/2024 15:36:57] INFO [system.ssh:100] SSHD (/etc/ssh/sshd_config) already initialised
[18/Jan/2024 15:36:57] INFO [scripts.initrock:473] API CLIENT_SECRET set/reset successfully.
[18/Jan/2024 15:36:57] INFO [scripts.initrock:569] --DB-- Tune Postgres --DB–
[18/Jan/2024 15:36:57] INFO [scripts.initrock:571] --DB-- Running - Setup_host_based_auth
[18/Jan/2024 15:36:58] INFO [scripts.initrock:576] --DB-- Done with Setup_host_based_auth.
[18/Jan/2024 15:36:58] INFO [scripts.initrock:571] --DB-- Running - Reload_config
[18/Jan/2024 15:36:58] INFO [scripts.initrock:576] --DB-- Done with Reload_config.
[18/Jan/2024 15:36:58] INFO [scripts.initrock:571] --DB-- Running - PG_tune
[18/Jan/2024 15:36:58] INFO [scripts.initrock:576] --DB-- Done with PG_tune.
[18/Jan/2024 15:36:58] INFO [scripts.initrock:577] --DB-- Tune Postgres Done --DB–.
[18/Jan/2024 15:36:58] INFO [scripts.initrock:581] Running app database migrations…
[18/Jan/2024 15:37:01] ERROR [system.osi:261] non-zero code(1) returned by command: [‘/opt/rockstor/.venv/bin/django-admin’, ‘migrate’, ‘–noinput’, ‘–fake-initial’, ‘–database=default’, ‘contenttypes’]. output: [‘’] error: [‘Traceback (most recent call last):’, ’ File “/opt/rockstor/.venv/bin/django-admin”, line 8, in ‘, ’ sys.exit(execute_from_command_line())’, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/init.py”, line 442, in execute_from_command_line’, ’ utility.execute()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/init.py”, line 436, in execute’, ’ self.fetch_command(subcommand).run_from_argv(self.argv)‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/base.py”, line 412, in run_from_argv’, ’ self.execute(*args, **cmd_options)‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/base.py”, line 458, in execute’, ’ output = self.handle(*args, **options)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/base.py”, line 106, in wrapper’, ’ res = handle_func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/commands/migrate.py”, line 117, in handle’, ’ executor = MigrationExecutor(connection, self.migration_progress_callback)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/executor.py”, line 18, in init’, ’ self.loader = MigrationLoader(self.connection)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/loader.py”, line 58, in init’, ’ self.build_graph()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/loader.py”, line 235, in build_graph’, ’ self.applied_migrations = recorder.applied_migrations()‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/recorder.py”, line 81, in applied_migrations’, ’ if self.has_table():‘, ’ ^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/recorder.py”, line 57, in has_table’, ’ with self.connection.cursor() as cursor:‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner’, ’ return func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 330, in cursor’, ’ return self._cursor()‘, ’ ^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 306, in _cursor’, ’ self.ensure_connection()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner’, ’ return func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 289, in ensure_connection’, ’ self.connect()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner’, ’ return func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 272, in connect’, ’ self.init_connection_state()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/postgresql/base.py”, line 309, in init_connection_state’, ’ super().init_connection_state()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 239, in init_connection_state’, ’ self.check_database_version_supported()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 214, in check_database_version_supported’, ’ raise NotSupportedError(‘, ‘django.db.utils.NotSupportedError: PostgreSQL 12 or later is required (found 10.23).’, ‘’]
[18/Jan/2024 16:45:13] INFO [scripts.initrock:546] Checking for flash and Running flash optimizations if appropriate.
[18/Jan/2024 16:45:14] INFO [scripts.initrock:549] Updating the timezone from the system
[18/Jan/2024 16:45:14] INFO [scripts.initrock:221] system timezone = Europe/Copenhagen
[18/Jan/2024 16:45:14] INFO [scripts.initrock:556] Initialising SSHD config
[18/Jan/2024 16:45:14] INFO [system.ssh:394] SSHD (/etc/ssh/sshd_config) sftp-server already disabled
[18/Jan/2024 16:45:14] INFO [system.ssh:100] SSHD (/etc/ssh/sshd_config) already initialised
[18/Jan/2024 16:45:14] INFO [scripts.initrock:569] --DB-- Tune Postgres --DB–
[18/Jan/2024 16:45:14] INFO [scripts.initrock:571] --DB-- Running - Setup_host_based_auth
[18/Jan/2024 16:45:15] INFO [scripts.initrock:576] --DB-- Done with Setup_host_based_auth.
[18/Jan/2024 16:45:15] INFO [scripts.initrock:571] --DB-- Running - Reload_config
[18/Jan/2024 16:45:15] INFO [scripts.initrock:576] --DB-- Done with Reload_config.
[18/Jan/2024 16:45:15] INFO [scripts.initrock:571] --DB-- Running - PG_tune
[18/Jan/2024 16:45:15] INFO [scripts.initrock:576] --DB-- Done with PG_tune.
[18/Jan/2024 16:45:15] INFO [scripts.initrock:577] --DB-- Tune Postgres Done --DB–.
[18/Jan/2024 16:45:15] INFO [scripts.initrock:581] Running app database migrations…
[18/Jan/2024 16:45:20] ERROR [system.osi:261] non-zero code(1) returned by command: [’/opt/rockstor/.venv/bin/django-admin’, ‘migrate’, ‘–noinput’, ‘–fake-initial’, ‘–database=default’, ‘contenttypes’]. output: [‘’] error: [‘Traceback (most recent call last):’, ’ File “/opt/rockstor/.venv/bin/django-admin”, line 8, in ‘, ’ sys.exit(execute_from_command_line())’, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/init.py”, line 442, in execute_from_command_line’, ’ utility.execute()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/init.py”, line 436, in execute’, ’ self.fetch_command(subcommand).run_from_argv(self.argv)‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/base.py”, line 412, in run_from_argv’, ’ self.execute(*args, **cmd_options)‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/base.py”, line 458, in execute’, ’ output = self.handle(*args, **options)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/base.py”, line 106, in wrapper’, ’ res = handle_func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/commands/migrate.py”, line 117, in handle’, ’ executor = MigrationExecutor(connection, self.migration_progress_callback)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/executor.py”, line 18, in init’, ’ self.loader = MigrationLoader(self.connection)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/loader.py”, line 58, in init’, ’ self.build_graph()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/loader.py”, line 235, in build_graph’, ’ self.applied_migrations = recorder.applied_migrations()‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/recorder.py”, line 81, in applied_migrations’, ’ if self.has_table():‘, ’ ^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/recorder.py”, line 57, in has_table’, ’ with self.connection.cursor() as cursor:‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner’, ’ return func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 330, in cursor’, ’ return self._cursor()‘, ’ ^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 306, in _cursor’, ’ self.ensure_connection()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner’, ’ return func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 289, in ensure_connection’, ’ self.connect()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner’, ’ return func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 272, in connect’, ’ self.init_connection_state()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/postgresql/base.py”, line 309, in init_connection_state’, ’ super().init_connection_state()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 239, in init_connection_state’, ’ self.check_database_version_supported()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 214, in check_database_version_supported’, ’ raise NotSupportedError(‘, ‘django.db.utils.NotSupportedError: PostgreSQL 12 or later is required (found 10.23).’, ‘’]
[18/Jan/2024 16:49:57] INFO [scripts.initrock:546] Checking for flash and Running flash optimizations if appropriate.
[18/Jan/2024 16:49:57] INFO [scripts.initrock:549] Updating the timezone from the system
[18/Jan/2024 16:49:57] INFO [scripts.initrock:221] system timezone = Europe/Copenhagen
[18/Jan/2024 16:49:57] INFO [scripts.initrock:556] Initialising SSHD config
[18/Jan/2024 16:49:57] INFO [system.ssh:394] SSHD (/etc/ssh/sshd_config) sftp-server already disabled
[18/Jan/2024 16:49:57] INFO [system.ssh:100] SSHD (/etc/ssh/sshd_config) already initialised
[18/Jan/2024 16:49:57] INFO [scripts.initrock:569] --DB-- Tune Postgres --DB–
[18/Jan/2024 16:49:57] INFO [scripts.initrock:571] --DB-- Running - Setup_host_based_auth
[18/Jan/2024 16:49:58] INFO [scripts.initrock:576] --DB-- Done with Setup_host_based_auth.
[18/Jan/2024 16:49:58] INFO [scripts.initrock:571] --DB-- Running - Reload_config
[18/Jan/2024 16:49:58] INFO [scripts.initrock:576] --DB-- Done with Reload_config.
[18/Jan/2024 16:49:58] INFO [scripts.initrock:571] --DB-- Running - PG_tune
[18/Jan/2024 16:49:59] INFO [scripts.initrock:576] --DB-- Done with PG_tune.
[18/Jan/2024 16:49:59] INFO [scripts.initrock:577] --DB-- Tune Postgres Done --DB–.
[18/Jan/2024 16:49:59] INFO [scripts.initrock:581] Running app database migrations…
[18/Jan/2024 16:50:05] ERROR [system.osi:261] non-zero code(1) returned by command: [’/opt/rockstor/.venv/bin/django-admin’, ‘migrate’, ‘–noinput’, ‘–fake-initial’, ‘–database=default’, ‘contenttypes’]. output: [‘’] error: [‘Traceback (most recent call last):’, ’ File “/opt/rockstor/.venv/bin/django-admin”, line 8, in ‘, ’ sys.exit(execute_from_command_line())’, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/init.py”, line 442, in execute_from_command_line’, ’ utility.execute()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/init.py”, line 436, in execute’, ’ self.fetch_command(subcommand).run_from_argv(self.argv)‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/base.py”, line 412, in run_from_argv’, ’ self.execute(*args, **cmd_options)‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/base.py”, line 458, in execute’, ’ output = self.handle(*args, **options)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/base.py”, line 106, in wrapper’, ’ res = handle_func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/commands/migrate.py”, line 117, in handle’, ’ executor = MigrationExecutor(connection, self.migration_progress_callback)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/executor.py”, line 18, in init’, ’ self.loader = MigrationLoader(self.connection)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/loader.py”, line 58, in init’, ’ self.build_graph()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/loader.py”, line 235, in build_graph’, ’ self.applied_migrations = recorder.applied_migrations()‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/recorder.py”, line 81, in applied_migrations’, ’ if self.has_table():‘, ’ ^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/recorder.py”, line 57, in has_table’, ’ with self.connection.cursor() as cursor:‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner’, ’ return func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 330, in cursor’, ’ return self._cursor()‘, ’ ^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 306, in _cursor’, ’ self.ensure_connection()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner’, ’ return func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 289, in ensure_connection’, ’ self.connect()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner’, ’ return func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 272, in connect’, ’ self.init_connection_state()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/postgresql/base.py”, line 309, in init_connection_state’, ’ super().init_connection_state()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 239, in init_connection_state’, ’ self.check_database_version_supported()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 214, in check_database_version_supported’, ’ raise NotSupportedError(‘, ‘django.db.utils.NotSupportedError: PostgreSQL 12 or later is required (found 10.23).’, ‘’]
[18/Jan/2024 16:00:55] INFO [scripts.initrock:546] Checking for flash and Running flash optimizations if appropriate.
[18/Jan/2024 16:00:56] INFO [scripts.initrock:549] Updating the timezone from the system
[18/Jan/2024 16:00:56] INFO [scripts.initrock:221] system timezone = Europe/Copenhagen
[18/Jan/2024 16:00:56] INFO [scripts.initrock:234] Changed timezone from “Europe/Lisbon” to Europe/Copenhagen
[18/Jan/2024 16:00:56] INFO [scripts.initrock:556] Initialising SSHD config
[18/Jan/2024 16:00:56] INFO [system.ssh:394] SSHD (/etc/ssh/sshd_config) sftp-server already disabled
[18/Jan/2024 16:00:56] INFO [system.ssh:100] SSHD (/etc/ssh/sshd_config) already initialised
[18/Jan/2024 16:00:56] INFO [scripts.initrock:569] --DB-- Tune Postgres --DB–
[18/Jan/2024 16:00:56] INFO [scripts.initrock:571] --DB-- Running - Setup_host_based_auth
[18/Jan/2024 16:00:57] INFO [scripts.initrock:576] --DB-- Done with Setup_host_based_auth.
[18/Jan/2024 16:00:57] INFO [scripts.initrock:571] --DB-- Running - Reload_config
[18/Jan/2024 16:00:57] INFO [scripts.initrock:576] --DB-- Done with Reload_config.
[18/Jan/2024 16:00:57] INFO [scripts.initrock:571] --DB-- Running - PG_tune
[18/Jan/2024 16:00:57] INFO [scripts.initrock:576] --DB-- Done with PG_tune.
[18/Jan/2024 16:00:57] INFO [scripts.initrock:577] --DB-- Tune Postgres Done --DB–.
[18/Jan/2024 16:00:57] INFO [scripts.initrock:581] Running app database migrations…
[18/Jan/2024 16:00:59] ERROR [system.osi:261] non-zero code(1) returned by command: [’/opt/rockstor/.venv/bin/django-admin’, ‘migrate’, ‘–noinput’, ‘–fake-initial’, ‘–database=default’, ‘contenttypes’]. output: [‘’] error: [‘Traceback (most recent call last):’, ’ File “/opt/rockstor/.venv/bin/django-admin”, line 8, in ‘, ’ sys.exit(execute_from_command_line())’, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/init.py”, line 442, in execute_from_command_line’, ’ utility.execute()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/init.py”, line 436, in execute’, ’ self.fetch_command(subcommand).run_from_argv(self.argv)‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/base.py”, line 412, in run_from_argv’, ’ self.execute(*args, **cmd_options)‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/base.py”, line 458, in execute’, ’ output = self.handle(*args, **options)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/base.py”, line 106, in wrapper’, ’ res = handle_func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/core/management/commands/migrate.py”, line 117, in handle’, ’ executor = MigrationExecutor(connection, self.migration_progress_callback)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/executor.py”, line 18, in init’, ’ self.loader = MigrationLoader(self.connection)‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/loader.py”, line 58, in init’, ’ self.build_graph()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/loader.py”, line 235, in build_graph’, ’ self.applied_migrations = recorder.applied_migrations()‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/recorder.py”, line 81, in applied_migrations’, ’ if self.has_table():‘, ’ ^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/migrations/recorder.py”, line 57, in has_table’, ’ with self.connection.cursor() as cursor:‘, ’ ^^^^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner’, ’ return func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 330, in cursor’, ’ return self._cursor()‘, ’ ^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 306, in _cursor’, ’ self.ensure_connection()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner’, ’ return func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 289, in ensure_connection’, ’ self.connect()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner’, ’ return func(*args, **kwargs)‘, ’ ^^^^^^^^^^^^^^^^^^^^^’, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 272, in connect’, ’ self.init_connection_state()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/postgresql/base.py”, line 309, in init_connection_state’, ’ super().init_connection_state()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 239, in init_connection_state’, ’ self.check_database_version_supported()‘, ’ File “/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 214, in check_database_version_supported’, ’ raise NotSupportedError(', ‘django.db.utils.NotSupportedError: PostgreSQL 12 or later is required (found 10.23).’, ‘’]

1 Like

Hope you can make heads or tails from it, I sure cant :slight_smile:

Has this got something to do with it??

PostgreSQL 12 or later is required (found 10.23)

2 Likes

Searching the error comes up with something about Django being to new, and it doesn’t support postgresql lower than version 12.

I’m way out of my league here, I will await instructions :slight_smile:

Yes, I think we have a culprit here:

And the error output:

NotSupportedError(', ‘django.db.utils.NotSupportedError: PostgreSQL 12 or later is required (found 10.23).’, ‘’]

So it seems to somehow work on PostgreSQL 10 (found 10.23), while Rockstor depends on postgres 13! I have not seen that one before.

For reference, our postgres dependencies are defined at:

We’ve seen some old postgres versions sticking and not being updated as “to-be-used” by zypper in some systems that were old installs being updated progressively. Would that be the case for yours, by any chance? In other words, is that an old Rockstor install that has been updated from previous Leap versions?
In particular, the following thread comes to mind:

Let’s see if that is available to your system:

update-alternatives --list postgresql

Yes my install is a perhaps 5 years old install that has been updated with new releases.

I even think I used some info in the thread you mention to make Rockstor work after updating to 5.0.1-0

update-alternatives --list postgresql:

/usr/lib/postgresql10
/usr/lib/postgresql13

1 Like

Oh, interesting…

So it seems you have it, let’s check and see if you can verify that update-alternatives is indeed set to use v10:

rockstable:/opt/rockstor # update-alternatives --config postgresql
There is 1 choice for the alternative postgresql (providing /usr/lib/postgresql).

  Selection    Path                   Priority   Status
------------------------------------------------------------
  0            /usr/lib/postgresql13   130       auto mode
* 1            /usr/lib/postgresql13   130       manual mode

Press <enter> to keep the current choice[*], or type selection number:

The * denotes the one in use (you can press Ctrl + C to cancel at that point).

Alternatively, checking the symlink for pg_config could indirectly tell us the same thing:

ls -lah /etc/alternatives/pg_config
1 Like

Sorry its a little unclear what you want me to do now.

What do I do to see the info you display.

/opt/rockstor # update-alternatives --config postgresql

Doesnt give me any usefull reply.

Try running:

update-alternatives --config postgresql

When it asks you the following:

Press <enter> to keep the current choice[*], or type selection number:

… you can press Ctrl + C on your keyboard to cancel the selection. We’re just verifying what you currently have so far.

Alternatively, you can also run:

ls -lah /etc/alternatives/pg_config

as that will show you the actual binary used for pg_config (given its version number is in its name, it’ll be showing us what version is being used).

update-alternatives --config postgresql

There are 2 choices for the alternative postgresql (providing /usr/lib/postgresql).

  Selection    Path                   Priority   Status
  0            /usr/lib/postgresql13   130       auto mode
  1            /usr/lib/postgresql10   100       manual mode
* 2            /usr/lib/postgresql13   130       manual mode
ls -lah /etc/alternatives/pg_config
lrwxrwxrwx 1 root root 35 Nov 20 22:50 /etc/alternatives/pg_config -> /usr/lib/postgresql13/bin/pg_config

The forum messes with the lauyout a little, hope you see what it says.

That is curious because it seems to indicate you are indeed using v13 (as it should be). We could try uninstalling postgresql10 and re-set update-alternatives to use v13 (as it currently says it’s doing), but let’s first look at it in more details:

update-alternatives --display postgresql

postgresql - manual mode
link best version is /usr/lib/postgresql13
link currently points to /usr/lib/postgresql13
link postgresql is /usr/lib/postgresql
slave clusterdb is /usr/bin/clusterdb
slave createdb is /usr/bin/createdb
slave createuser is /usr/bin/createuser
slave dropdb is /usr/bin/dropdb
slave dropuser is /usr/bin/dropuser
slave initdb is /usr/bin/initdb
slave pg_basebackup is /usr/bin/pg_basebackup
slave pg_checksums is /usr/bin/pg_checksums
slave pg_config is /usr/bin/pg_config
slave pg_controldata is /usr/bin/pg_controldata
slave pg_ctl is /usr/bin/pg_ctl
slave pg_dump is /usr/bin/pg_dump
slave pg_dumpall is /usr/bin/pg_dumpall
slave pg_isready is /usr/bin/pg_isready
slave pg_receivewal is /usr/bin/pg_receivewal
slave pg_recvlogical is /usr/bin/pg_recvlogical
slave pg_resetwal is /usr/bin/pg_resetwal
slave pg_restore is /usr/bin/pg_restore
slave pg_rewind is /usr/bin/pg_rewind
slave pg_verifybackup is /usr/bin/pg_verifybackup
slave pg_waldump is /usr/bin/pg_waldump
slave postgres is /usr/bin/postgres
slave postmaster is /usr/bin/postmaster
slave psql is /usr/bin/psql
slave reindexdb is /usr/bin/reindexdb
slave vacuumdb is /usr/bin/vacuumdb
/usr/lib/postgresql10 - priority 100
slave clusterdb: /usr/lib/postgresql10/bin/clusterdb
slave createdb: /usr/lib/postgresql10/bin/createdb
slave createuser: /usr/lib/postgresql10/bin/createuser
slave dropdb: /usr/lib/postgresql10/bin/dropdb
slave dropuser: /usr/lib/postgresql10/bin/dropuser
slave initdb: /usr/lib/postgresql10/bin/initdb
slave pg_basebackup: /usr/lib/postgresql10/bin/pg_basebackup
slave pg_controldata: /usr/lib/postgresql10/bin/pg_controldata
slave pg_ctl: /usr/lib/postgresql10/bin/pg_ctl
slave pg_dump: /usr/lib/postgresql10/bin/pg_dump
slave pg_dumpall: /usr/lib/postgresql10/bin/pg_dumpall
slave pg_isready: /usr/lib/postgresql10/bin/pg_isready
slave pg_receivewal: /usr/lib/postgresql10/bin/pg_receivewal
slave pg_recvlogical: /usr/lib/postgresql10/bin/pg_recvlogical
slave pg_resetwal: /usr/lib/postgresql10/bin/pg_resetwal
slave pg_restore: /usr/lib/postgresql10/bin/pg_restore
slave pg_rewind: /usr/lib/postgresql10/bin/pg_rewind
slave pg_waldump: /usr/lib/postgresql10/bin/pg_waldump
slave postgres: /usr/lib/postgresql10/bin/postgres
slave postmaster: /usr/lib/postgresql10/bin/postmaster
slave psql: /usr/lib/postgresql10/bin/psql
slave reindexdb: /usr/lib/postgresql10/bin/reindexdb
slave vacuumdb: /usr/lib/postgresql10/bin/vacuumdb
/usr/lib/postgresql13 - priority 130
slave clusterdb: /usr/lib/postgresql13/bin/clusterdb
slave createdb: /usr/lib/postgresql13/bin/createdb
slave createuser: /usr/lib/postgresql13/bin/createuser
slave dropdb: /usr/lib/postgresql13/bin/dropdb
slave dropuser: /usr/lib/postgresql13/bin/dropuser
slave initdb: /usr/lib/postgresql13/bin/initdb
slave pg_basebackup: /usr/lib/postgresql13/bin/pg_basebackup
slave pg_checksums: /usr/lib/postgresql13/bin/pg_checksums
slave pg_config: /usr/lib/postgresql13/bin/pg_config
slave pg_controldata: /usr/lib/postgresql13/bin/pg_controldata
slave pg_ctl: /usr/lib/postgresql13/bin/pg_ctl
slave pg_dump: /usr/lib/postgresql13/bin/pg_dump
slave pg_dumpall: /usr/lib/postgresql13/bin/pg_dumpall
slave pg_isready: /usr/lib/postgresql13/bin/pg_isready
slave pg_receivewal: /usr/lib/postgresql13/bin/pg_receivewal
slave pg_recvlogical: /usr/lib/postgresql13/bin/pg_recvlogical
slave pg_resetwal: /usr/lib/postgresql13/bin/pg_resetwal
slave pg_restore: /usr/lib/postgresql13/bin/pg_restore
slave pg_rewind: /usr/lib/postgresql13/bin/pg_rewind
slave pg_verifybackup: /usr/lib/postgresql13/bin/pg_verifybackup
slave pg_waldump: /usr/lib/postgresql13/bin/pg_waldump
slave postgres: /usr/lib/postgresql13/bin/postgres
slave postmaster: /usr/lib/postgresql13/bin/postmaster
slave psql: /usr/lib/postgresql13/bin/psql
slave reindexdb: /usr/lib/postgresql13/bin/reindexdb
slave vacuumdb: /usr/lib/postgresql13/bin/vacuumdb

Again… puzzling as it seems your system should point Django to use v10 . This is also expected as we now manually set this during each RPM install/update:

So what we see here is a sign that the RPM update did what it was supposed to do.

I’m honestly really not sure why Django still tries to use v10 on your system, though. We could try uninstalling v10 as that should then (theoretically) prevent it to even being detected as an option. That shouldn’t break things either, but I’m always a bit reticent in doing that. It depends on whether you are game. You could always see what packages would be removed if you were to do that before committing to anything:

zypper remove postgresql10

and make sure to press n (for NO) when asked.

1 Like

Well what is the worst that could happen, the system is not working as is, so if we cant fix it here, I’ll probably end up reinstalling.

I would rather not, but I’m willing to try if this fixes anything.

If I uninstall sql10, and then try the force install rockstor, then that should be enough?

That would be the idea, yes… unless I am barking at the wrong tree and there is some old psycopg binary at play somehow… Could you quickly check that, actually?

zypper search *psycopg*

It did not seem to fix it.

When I run:

sudo systemctl start rockstor-bootstrap

I get this:

A dependency job for rockstor-bootstrap.service failed.

So something else is up.

zypper search *psycopg*

Loading repository data…
Reading installed packages…

S | Name | Summary | Type
—±------------------------------±----------------------------------------------±----------
| python-psycopg2 | Python-PostgreSQL Database Adapter | srcpackage
i+ | python2-psycopg2 | Python-PostgreSQL Database Adapter | package
| python3-aws-xray-sdk-psycopg2 | psycopg2 backend for the AWS X-Ray Python SDK | package
| python3-psycopg2 | Python-PostgreSQL Database Adapter | package
| python311-psycopg2 | Python-PostgreSQL Database Adapter | package

Maybe it’s that python2-psycopg2 remnant you have still installed, then. What would be removed if you run:

zypper remove python2-psycopg2

(you can say n for no here again if you don’t want to commit).

I have removed python2-psycopg2

Sadly that didnt seem to help. Still gets an error about depency.

journalctl -xe, gives this:

Jan 18 22:28:09 RockstorNAS [RPM][6204]: Transaction ID 65a997e9 started
Jan 18 22:28:09 RockstorNAS systemd[1]: Reloading.
Jan 18 22:28:09 RockstorNAS systemd[1]: Configuration file /etc/systemd/system/smb.service is marked world-inaccessible. This has no effect as con>
Jan 18 22:28:09 RockstorNAS systemd[1]: /usr/lib/systemd/system/rpc-statd.service:14: PIDFile= references a path below legacy directory /var/run/,>
Jan 18 22:28:10 RockstorNAS systemd[1]: Reloading.
Jan 18 22:28:11 RockstorNAS systemd[1]: Configuration file /etc/systemd/system/smb.service is marked world-inaccessible. This has no effect as con>
Jan 18 22:28:11 RockstorNAS systemd[1]: /usr/lib/systemd/system/rpc-statd.service:14: PIDFile= references a path below legacy directory /var/run/,>
Jan 18 22:28:11 RockstorNAS [RPM][6204]: install rockstor-5.0.6-0.x86_64: success
Jan 18 22:28:11 RockstorNAS [RPM][6204]: Transaction ID 65a997e9 finished: 0
Jan 18 22:28:27 RockstorNAS sudo[5497]: pam_unix(sudo:session): session closed for user root
Jan 18 22:28:33 RockstorNAS sudo[7816]: root : TTY=pts/0 ; PWD=/ ; USER=root ; COMMAND=/usr/bin/systemctl start rockstor-bootstrap
Jan 18 22:28:33 RockstorNAS sudo[7816]: pam_unix(sudo:session): session opened for user root by root(uid=0)
Jan 18 22:28:33 RockstorNAS systemd[1]: Starting PostgreSQL database server…
░░ Subject: A start job for unit postgresql.service has begun execution
░░ Defined-By: systemd
░░ Support: systemd-devel Info Page
░░
░░ A start job for unit postgresql.service has begun execution.
░░
░░ The job identifier is 5247.
Jan 18 22:28:33 RockstorNAS postgresql-script[7819]: Your database files were created by PostgreSQL version 10.
Jan 18 22:28:33 RockstorNAS postgresql-script[7819]: Could not find executables for this version.
Jan 18 22:28:33 RockstorNAS postgresql-script[7819]: Please install the PostgreSQL server package for version 10.
Jan 18 22:28:33 RockstorNAS systemd[1]: postgresql.service: Control process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: systemd-devel Info Page
░░
░░ An ExecStart= process belonging to unit postgresql.service has exited.
░░
░░ The process’ exit code is ‘exited’ and its exit status is 1.
Jan 18 22:28:33 RockstorNAS systemd[1]: postgresql.service: Failed with result ‘exit-code’.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: systemd-devel Info Page
░░
░░ The unit postgresql.service has entered the ‘failed’ state with result ‘exit-code’.
Jan 18 22:28:33 RockstorNAS systemd[1]: Failed to start PostgreSQL database server.
░░ Subject: A start job for unit postgresql.service has failed
░░ Defined-By: systemd
░░ Support: systemd-devel Info Page
░░
░░ A start job for unit postgresql.service has finished with a failure.
░░
░░ The job identifier is 5247 and the job result is failed.
Jan 18 22:28:33 RockstorNAS systemd[1]: Dependency failed for Tasks required prior to starting Rockstor.
░░ Subject: A start job for unit rockstor-pre.service has failed
░░ Defined-By: systemd
░░ Support: systemd-devel Info Page
░░
░░ A start job for unit rockstor-pre.service has finished with a failure.
░░
░░ The job identifier is 5237 and the job result is dependency.
Jan 18 22:28:33 RockstorNAS systemd[1]: Dependency failed for Rockstor startup script.
░░ Subject: A start job for unit rockstor.service has failed
░░ Defined-By: systemd
░░ Support: systemd-devel Info Page
░░
░░ A start job for unit rockstor.service has finished with a failure.
░░
░░ The job identifier is 5121 and the job result is dependency.
Jan 18 22:28:33 RockstorNAS systemd[1]: Dependency failed for Rockstor bootstrapping tasks.
░░ Subject: A start job for unit rockstor-bootstrap.service has failed
░░ Defined-By: systemd
░░ Support: systemd-devel Info Page
░░
░░ A start job for unit rockstor-bootstrap.service has finished with a failure.
░░
░░ The job identifier is 5120 and the job result is dependency.
Jan 18 22:28:33 RockstorNAS systemd[1]: rockstor-bootstrap.service: Job rockstor-bootstrap.service/start failed with result ‘dependency’.
Jan 18 22:28:33 RockstorNAS systemd[1]: rockstor.service: Job rockstor.service/start failed with result ‘dependency’.
Jan 18 22:28:33 RockstorNAS systemd[1]: rockstor-pre.service: Job rockstor-pre.service/start failed with result ‘dependency’.
Jan 18 22:28:33 RockstorNAS sudo[7816]: pam_unix(sudo:session): session closed for user root
lines 1245-1317/1317 (END)

It seems it complains about database files being made by SQL10, that is now missing :slight_smile:

1 Like

I’m off to bed for today, I’ll pick up again tommorow evening, if you have any ideas for what I can do.