Unable to Connect after upgrading to Ubuntu22.04.01 LTS

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

Unable to Connect after upgrading to Ubuntu22.04.01 LTS

1424 Views

ubuntu Upgrade

As with the title, after upgrading to Ubuntu 22.04.01 LTS from 22.04, Odoo stopped working as in I'm getting "Unable to connect" in the browser.

I have checked the services, both Odoo and PostgresSQL are running.

the logs of both didn't show any problems.

could the problem be because of the libraries and packages that has been removed because of the upgrade?

I'm not sure what of the exact problem and how to investigate the problem, I would appreciate any advise.

Ibrahim Boudmir

Hi,
can you show us odoo logs please ?
maybe there is something you didn't notice..

Author

@Ibrahim Boudmir
here are the postgresSQL logs:
2022-08-25 07:32:25.672 GMT [23896] LOG: received fast shutdown request
2022-08-25 07:32:25.674 GMT [23896] LOG: aborting any active transactions
2022-08-25 07:32:25.679 GMT [23896] LOG: background worker "logical replication launcher" (PID 23903) exited with exit code 1
2022-08-25 07:32:25.679 GMT [23898] LOG: shutting down
2022-08-25 07:32:25.696 GMT [23896] LOG: database system is shut down
2022-08-25 07:32:25.862 GMT [79079] LOG: starting PostgreSQL 12.12 (Ubuntu 12.12-0ubuntu0.20.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
2022-08-25 07:32:25.862 GMT [79079] LOG: listening on IPv4 address "127.0.0.1", port 5432
2022-08-25 07:32:25.864 GMT [79079] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-08-25 07:32:25.876 GMT [79080] LOG: database system was shut down at 2022-08-25 07:32:25 GMT
2022-08-25 07:32:25.885 GMT [79079] LOG: database system is ready to accept connections
2022-08-25 07:46:57.106 GMT [79079] LOG: received fast shutdown request
2022-08-25 07:46:57.107 GMT [79079] LOG: aborting any active transactions
2022-08-25 07:46:57.111 GMT [79079] LOG: background worker "logical replication launcher" (PID 79086) exited with exit code 1
2022-08-25 07:46:57.112 GMT [79081] LOG: shutting down
2022-08-25 07:46:57.121 GMT [79079] LOG: database system is shut down
2022-08-25 07:46:57.306 GMT [93458] LOG: starting PostgreSQL 12.12 (Ubuntu 12.12-0ubuntu0.20.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
2022-08-25 07:46:57.306 GMT [93458] LOG: listening on IPv4 address "127.0.0.1", port 5432
2022-08-25 07:46:57.307 GMT [93458] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-08-25 07:46:57.319 GMT [93459] LOG: database system was shut down at 2022-08-25 07:46:57 GMT
2022-08-25 07:46:57.327 GMT [93458] LOG: database system is ready to accept connections
2022-08-25 08:34:25.119 GMT [93458] LOG: received fast shutdown request
2022-08-25 08:34:25.131 GMT [93458] LOG: aborting any active transactions
2022-08-25 08:34:25.135 GMT [93458] LOG: background worker "logical replication launcher" (PID 93465) exited with exit code 1
2022-08-25 08:34:25.137 GMT [93460] LOG: shutting down
2022-08-25 08:34:25.179 GMT [93458] LOG: database system is shut down
2022-08-25 08:34:32.755 GMT [1013] LOG: starting PostgreSQL 12.12 (Ubuntu 12.12-0ubuntu0.20.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
2022-08-25 08:34:32.755 GMT [1013] LOG: listening on IPv4 address "127.0.0.1", port 5432
2022-08-25 08:34:32.756 GMT [1013] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-08-25 08:34:32.789 GMT [1097] LOG: database system was shut down at 2022-08-25 08:34:25 GMT
2022-08-25 08:34:32.800 GMT [1013] LOG: database system is ready to accept connections
2022-08-25 09:11:47.116 GMT [1013] LOG: received fast shutdown request
2022-08-25 09:11:47.122 GMT [1013] LOG: aborting any active transactions
2022-08-25 09:11:47.124 GMT [1013] LOG: background worker "logical replication launcher" (PID 1106) exited with exit code 1
2022-08-25 09:11:47.125 GMT [1101] LOG: shutting down
2022-08-25 09:11:47.148 GMT [1013] LOG: database system is shut down
2022-08-25 09:11:54.412 GMT [1038] LOG: starting PostgreSQL 12.12 (Ubuntu 12.12-0ubuntu0.20.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
2022-08-25 09:11:54.413 GMT [1038] LOG: listening on IPv4 address "127.0.0.1", port 5432
2022-08-25 09:11:54.414 GMT [1038] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-08-25 09:11:54.456 GMT [1111] LOG: database system was shut down at 2022-08-25 09:11:47 GMT
2022-08-25 09:11:54.467 GMT [1038] LOG: database system is ready to accept connections
2022-08-25 10:17:40.474 GMT [6353] postgres@odoo FATAL: database "odoo" does not exist
2022-08-25 11:33:19.522 GMT [1038] LOG: received fast shutdown request
2022-08-25 11:33:19.523 GMT [1038] LOG: aborting any active transactions
2022-08-25 11:33:19.525 GMT [1038] LOG: background worker "logical replication launcher" (PID 1129) exited with exit code 1
2022-08-25 11:33:19.529 GMT [1124] LOG: shutting down
2022-08-25 11:33:19.555 GMT [1038] LOG: database system is shut down
2022-08-25 11:33:26.798 GMT [1018] LOG: starting PostgreSQL 12.12 (Ubuntu 12.12-0ubuntu0.20.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
2022-08-25 11:33:26.799 GMT [1018] LOG: listening on IPv4 address "127.0.0.1", port 5432
2022-08-25 11:33:26.799 GMT [1018] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-08-25 11:33:26.823 GMT [1096] LOG: database system was shut down at 2022-08-25 11:33:19 GMT
2022-08-25 11:33:26.834 GMT [1018] LOG: database system is ready to accept connections
2022-08-25 11:48:39.388 GMT [1018] LOG: received fast shutdown request
2022-08-25 11:48:39.389 GMT [1018] LOG: aborting any active transactions
2022-08-25 11:48:39.395 GMT [1018] LOG: background worker "logical replication launcher" (PID 1108) exited with exit code 1
2022-08-25 11:48:39.396 GMT [1100] LOG: shutting down
2022-08-25 11:48:39.406 GMT [1018] LOG: database system is shut down
2022-08-25 11:48:39.582 GMT [5584] LOG: starting PostgreSQL 12.12 (Ubuntu 12.12-0ubuntu0.20.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
2022-08-25 11:48:39.582 GMT [5584] LOG: listening on IPv4 address "127.0.0.1", port 5432
2022-08-25 11:48:39.583 GMT [5584] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-08-25 11:48:39.596 GMT [5593] LOG: database system was shut down at 2022-08-25 11:48:39 GMT
2022-08-25 11:48:39.606 GMT [5584] LOG: database system is ready to accept connections

Here are the logs from odoo server:
2022-08-10 06:00:42,722 997 INFO lipcolive odoo.addons.base.models.ir_cron: Job `payment: post-process transactions` done.
2022-08-10 06:10:53,452 997 INFO lipcolive odoo.addons.base.models.ir_cron: Starting job `payment: post-process transactions`.
2022-08-10 06:10:53,457 997 INFO lipcolive odoo.addons.base.models.ir_cron: Job `payment: post-process transactions` done.
2022-08-10 06:21:04,025 997 INFO lipcolive odoo.addons.base.models.ir_cron: Starting job `payment: post-process transactions`.
2022-08-10 06:21:04,030 997 INFO lipcolive odoo.addons.base.models.ir_cron: Job `payment: post-process transactions` done.
2022-08-10 06:31:14,680 997 INFO lipcolive odoo.addons.base.models.ir_cron: Starting job `payment: post-process transactions`.
2022-08-10 06:31:14,685 997 INFO lipcolive odoo.addons.base.models.ir_cron: Job `payment: post-process transactions` done.
2022-08-10 06:40:24,175 997 INFO lipcolive odoo.addons.base.models.ir_cron: Starting job `payment: post-process transactions`.
2022-08-10 06:40:24,180 997 INFO lipcolive odoo.addons.base.models.ir_cron: Job `payment: post-process transactions` done.
2022-08-10 06:45:49,576 997 INFO ? odoo.service.server: Initiating shutdown
2022-08-10 06:45:49,576 997 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2022-08-10 06:45:49,669 997 INFO ? odoo.sql_db: ConnectionPool(used=0/count=0/max=64): Closed 6 connections
2022-08-10 06:45:59,652 1000 INFO ? odoo: Odoo version 15.0
2022-08-10 06:45:59,653 1000 INFO ? odoo: Using configuration file at /etc/odoo-server.conf
2022-08-10 06:45:59,653 1000 INFO ? odoo: addons paths: ['/odoo/odoo-server/odoo/addons', '/odoo/.local/share/Odoo/addons/15.0', '/odoo/odoo-server/addons', '/odoo/custom/addons', '/odoo/enterprise']
2022-08-10 06:45:59,653 1000 INFO ? odoo: database: default@default:default
2022-08-10 06:45:59,822 1000 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /bin/wkhtmltopdf
2022-08-10 06:46:00,094 1000 INFO ? odoo.service.server: HTTP service (werkzeug) running on [hidden]:8079
2022-08-17 08:25:51,264 1023 INFO ? odoo: Odoo version 15.0
2022-08-17 08:25:51,265 1023 INFO ? odoo: Using configuration file at /etc/odoo-server.conf
2022-08-17 08:25:51,265 1023 INFO ? odoo: addons paths: ['/odoo/odoo-server/odoo/addons', '/odoo/.local/share/Odoo/addons/15.0', '/odoo/odoo-server/addons', '/odoo/custom/addons', '/odoo/enterprise']
2022-08-17 08:25:51,265 1023 INFO ? odoo: database: default@default:default
2022-08-17 08:25:51,417 1023 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /bin/wkhtmltopdf
2022-08-17 08:25:51,677 1023 INFO ? odoo.service.server: HTTP service (werkzeug) running on [hidden]:8079
2022-08-25 08:34:25,043 1023 INFO ? odoo.service.server: Initiating shutdown
2022-08-25 08:34:25,043 1023 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2022-08-25 08:34:25,206 1023 INFO ? odoo.sql_db: ConnectionPool(used=0/count=0/max=64): Closed 2 connections

25 is the day I have upgraded the system.

This question has been flagged