Kobo server is not starting

after upgrading kobo to 2.022.24 it is not starting and when checking my log it is shown that kobocat is not starting up
this is what I got from the log

Please help!

kobocat_1 | KoBoCAT intializing…
kobocat_1 | Waiting for container mongo.
kobocat_1 | wait-for-it: waiting 40 seconds for mongo.domain.private:27017
kobocat_1 | wait-for-it: mongo.domain.private:27017 is available after 0 seconds
kobocat_1 | Container mongo up.
kobocat_1 | Waiting for container postgres.
kobocat_1 | wait-for-it: waiting 20 seconds for postgres.domain.private:5432
kobocat_1 | wait-for-it: postgres.domain.private:5432 is available after 0 seconds
kobocat_1 | Container postgres up.
kobocat_1 | Waiting for Postgres service.
kobocat_1 | postgres.domain.private:5432 - accepting connections
kobocat_1 | Postgres service running; ensuring kobocat database exists and has PostGIS extensions…
kobocat_1 | ERROR: database “kobocat” already exists
kobocat_1 | You are now connected to database “kobocat” as user “kobo”.
kobocat_1 | NOTICE: extension “postgis” already exists, skipping
kobocat_1 | CREATE EXTENSION
kobocat_1 | NOTICE: extension “postgis_topology” already exists, skipping
kobocat_1 | CREATE EXTENSION
kobocat_1 | NOTICE: extension “fuzzystrmatch” already exists, skipping
kobocat_1 | CREATE EXTENSION
kobocat_1 | NOTICE: extension “postgis_tiger_geocoder” already exists, skipping
kobocat_1 | CREATE EXTENSION
kobocat_1 | Postgres database kobocat ready for use!
kobocat_1 | Running migrations…
kobocat_1 | Your environment is:“onadata.settings.prod”
kobocat_1 | Operations to perform:
kobocat_1 | Apply all migrations: admin, api, auth, authtoken, contenttypes, django_celery_beat, django_digest, guardian, logger, main, oauth2_provider, restservice, reversion, sessions, sites, taggit, viewer
kobocat_1 | Running migrations:
kobocat_1 | Traceback (most recent call last):
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/backends/utils.py”, line 84, in _execute
kobocat_1 | return self.cursor.execute(sql, params)
kobocat_1 | psycopg2.errors.UndefinedColumn: column oauth2_provider_application.created does not exist
kobocat_1 | LINE 1: …auth2_provider_application".“skip_authorization”, “oauth2_pr…
kobocat_1 | ^
kobocat_1 |
kobocat_1 |
kobocat_1 | The above exception was the direct cause of the following exception:
kobocat_1 |
kobocat_1 | Traceback (most recent call last):
kobocat_1 | File “/srv/src/kobocat/manage.py”, line 17, in
kobocat_1 | execute_from_command_line(sys.argv)
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/core/management/init.py”, line 381, in execute_from_command_line
kobocat_1 | utility.execute()
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/core/management/init.py”, line 375, in execute
kobocat_1 | self.fetch_command(subcommand).run_from_argv(self.argv)
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/core/management/base.py”, line 323, in run_from_argv
kobocat_1 | self.execute(*args, **cmd_options)
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/core/management/base.py”, line 364, in execute
kobocat_1 | output = self.handle(*args, **options)
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/core/management/base.py”, line 83, in wrapped
kobocat_1 | res = handle_func(*args, **kwargs)
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/core/management/commands/migrate.py”, line 232, in handle
kobocat_1 | post_migrate_state = executor.migrate(
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/migrations/executor.py”, line 117, in migrate
kobocat_1 | state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/migrations/executor.py”, line 147, in _migrate_all_forwards
kobocat_1 | state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/migrations/executor.py”, line 245, in apply_migration
kobocat_1 | state = migration.apply(state, schema_editor)
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/migrations/migration.py”, line 124, in apply
kobocat_1 | operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/migrations/operations/special.py”, line 190, in database_forwards
kobocat_1 | self.code(from_state.apps, schema_editor)
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/oauth2_provider/migrations/0006_alter_application_client_secret.py”, line 14, in forwards_func
kobocat_1 | for application in applications:
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/models/query.py”, line 274, in iter
kobocat_1 | self._fetch_all()
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/models/query.py”, line 1242, in _fetch_all
kobocat_1 | self._result_cache = list(self._iterable_class(self))
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/models/query.py”, line 55, in iter
kobocat_1 | results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/models/sql/compiler.py”, line 1142, in execute_sql
kobocat_1 | cursor.execute(sql, params)
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/backends/utils.py”, line 67, in execute
kobocat_1 | return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/backends/utils.py”, line 76, in _execute_with_wrappers
kobocat_1 | return executor(sql, params, many, context)
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/backends/utils.py”, line 80, in _execute
kobocat_1 | with self.db.wrap_database_errors:
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/utils.py”, line 89, in exit
kobocat_1 | raise dj_exc_value.with_traceback(traceback) from exc_value
kobocat_1 | File “/opt/venv/lib/python3.10/site-packages/django/db/backends/utils.py”, line 84, in _execute
kobocat_1 | return self.cursor.execute(sql, params)
kobocat_1 | django.db.utils.ProgrammingError: column oauth2_provider_application.created does not exist
kobocat_1 | LINE 1: …auth2_provider_application”.“skip_authorization”, "oauth2_pr…
kobocat_1 | ^
kobocat_1 |
kobocat_1 | Applying oauth2_provider.0006_alter_application_client_secret…KoBoCAT intializing…
kobocat_1 | Waiting for container mongo.
kobocat_1 | wait-for-it: waiting 40 seconds for mongo.domain.private:27017
kobocat_1 | wait-for-it: mongo.domain.private:27017 is available after 0 seconds
kobocat_1 | Container mongo up.
kobocat_1 | Waiting for container postgres.
kobocat_1 | wait-for-it: waiting 20 seconds for postgres.domain.private:5432
kobocat_1 | wait-for-it: postgres.domain.private:5432 is available after 0 seconds
kobocat_1 | Container postgres up.
kobocat_1 | Waiting for Postgres service.
kobocat_1 | postgres.domain.private:5432 - accepting connections
kobocat_1 | Postgres service running; ensuring kobocat database exists and has PostGIS extensions…
kobocat_1 | ERROR: database “kobocat” already exists
kobocat_1 | You are now connected to database “kobocat” as user “kobo”.
kobocat_1 | NOTICE: extension “postgis” already exists, skipping
kobocat_1 | CREATE EXTENSION
kobocat_1 | NOTICE: extension “postgis_topology” already exists, skipping
kobocat_1 | CREATE EXTENSION
kobocat_1 | NOTICE: extension “fuzzystrmatch” already exists, skipping
kobocat_1 | CREATE EXTENSION
kobocat_1 | NOTICE: extension “postgis_tiger_geocoder” already exists, skipping

1 Like

Welcome back to the community, @fanar! Maybe this post discussed previously should be helpful for you to troubleshoot:

hello @fanar

Can you try to follow these steps:

At the end, do not upgrade to 1.3.2 but to 1.7.1.

1 Like

thanks, it is working now

1 Like

Thanks, it is working now

1 Like