ENV: Ubuntu24 + docker-compose + odoo14
test14: 10 users
xmoo: 3 users
These two databases, every day access to the database connection close the browser, can not be released, every day the connection is increasing, this is not a good way.
Does manually setting a database timeout cause the odoo container to become inaccessible or the database to crash.
ALTER SYSTEM SET idle_session_timeout = '10min';
psql (15.7)
Type "help" for help.
postgres=# SELECT datname, usename, client_addr, state FROM pg_stat_activity ORDER BY datname, usename;
datname | usename | client_addr | state
----------+----------+-------------+--------
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
test14 | test14 | 172.18.0.11 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoo | xmoo14 | 172.18.0.8 | idle
xmoowx | xmoowx14 | 172.18.0.6 | idle
xmoowx | xmoowx14 | 172.18.0.6 | idle
xmoowx | xmoowx14 | 172.18.0.6 | idle
postgres | test14 | 172.18.0.11 | idle
postgres | xmoo14 | 172.18.0.8 | idle
postgres | postgres | | idle
postgres | postgres | | idle
postgres | postgres | | active
| postgres | |
| | |
| | |
| | |
| | |
(98 rows)
odoo.conf
[options]
addons_path = /mnt/extra-addons
csv_internal_sep = ,
data_dir = /var/lib/odoo
db_host = db
db_maxconn = 128
db_name = False
db_password = odoo
db_port = 5432
db_sslmode = prefer
db_template = template0
db_user = xmoo14
dbfilter = ^%d$
;dbfilter = %d_db
demo = {}
email_from = False
geoip_database = /usr/share/GeoIP/GeoLite2-City.mmdb
http_enable = True
http_interface =
http_port = 8069
import_partial =
limit_memory_hard = 2684354560
limit_memory_soft = 2147483648
limit_request = 8192
limit_time_cpu = 300
limit_time_real = 600
limit_time_real_cron = -1
list_db = True
log_db = False
log_db_level = warning
log_handler = :INFO
log_level = info
logfile =
longpolling_port = 8072
max_cron_threads = 1
osv_memory_age_limit = False
osv_memory_count_limit = False
pg_path = /usr/lib/postgresql/15/bin
pidfile =
proxy_mode = True
reportgz = False
screencasts =
screenshots = /tmp/odoo_tests
server_wide_modules = base,web
smtp_password = False
smtp_port = 25
smtp_server = localhost
smtp_ssl = False
smtp_user = False
syslog = False
test_enable = False
test_file =
test_tags = None
transient_age_limit = 1.0
translate_modules = ['all']
unaccent = False
upgrade_path =
without_demo = False
workers = 0