Skip to Content
Menu
This question has been flagged

I have got two High Availablity Server (Config: Linux 2vCPU and 16GB RAM each server), connecting to the same Postgres database server (Config: Linux 2vCPU and 8GB RAM) as the same user.



Each Odoo Server Config Details:
limit_memory_hard = 4026531840
limit_memory_soft = 3355443200
limit_request = 8192
limit_time_cpu = 3600
limit_time_real = 3600
max_cron_threads = 2
workers = 5
db_maxconn = 50



Postgres Config Details:
max_connections = 400
shared_buffers = 2GB
effective_cache_size = 6GB
maintenance_work_mem = 512MB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 100
random_page_cost = 1.1
effective_io_concurrency = 200
work_mem = 5242kB
min_wal_size = 1GB
max_wal_size = 4GB
max_worker_processes = 2
max_parallel_workers_per_gather = 1
max_parallel_workers = 2
max_parallel_maintenance_workers = 1




For some reason, the connection gets increased within seconds (during long polling - my findings/guess from the log), and getting the connection pool is full error in the Odoo log. I am using PGBouncer still I am getting the same error.


Avatar
Discard
Author

Please find the log.

Mar 30 07:14:28 odoopd02 odoo14[5194]: 2022-03-30 07:14:28,114 5194 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=3/max=25) Give back connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:28 odoopd02 odoo14[5194]: 2022-03-30 07:14:28,114 5194 DEBUG ? odoo.sql_db: ConnectionPool(used=0/count=2/max=25) Forgot connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:28 odoopd02 odoo14[5194]: 2022-03-30 07:14:28,115 5194 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:28 odoopd02 odoo14[5194]: 2022-03-30 07:14:28,115 5194 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Borrow existing connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' at index 0
Mar 30 07:14:28 odoopd02 odoo14[5194]: 2022-03-30 07:14:28,115 5194 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:14:28 odoopd02 odoo14[5194]: base_cache_signaling.last_value
Mar 30 07:14:28 odoopd02 odoo14[5194]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:14:28 odoopd02 odoo14[5194]: 2022-03-30 07:14:28,115 5194 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [288]
Mar 30 07:14:28 odoopd02 odoo14[5194]: 2022-03-30 07:14:28,115 5194 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [288]
Mar 30 07:14:28 odoopd02 odoo14[5194]: 2022-03-30 07:14:28,115 5194 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Give back connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:28 odoopd02 odoo14[5194]: 2022-03-30 07:14:28,116 5194 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=0/count=2/max=25) Put connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' in pool
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,137 5201 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Create new connection
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,137 5201 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('template0', 'postgres') order by datname
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,142 5201 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,142 5201 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.004867/1
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,142 5201 DEBUG ? odoo.sql_db: SUM from:0:00:00.004867/1 [397]
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,142 5201 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [397]
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,142 5201 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Give back connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,142 5201 DEBUG ? odoo.sql_db: ConnectionPool(used=0/count=1/max=25) Forgot connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,142 5201 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,147 5201 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=1/max=25) Borrow existing connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' at index 0
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,147 5201 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:14:28 odoopd02 odoo14[5201]: base_cache_signaling.last_value
Mar 30 07:14:28 odoopd02 odoo14[5201]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,151 5201 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [398]
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,151 5201 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [398]
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,152 5201 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=1/max=25) Give back connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,152 5201 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=0/count=1/max=25) Put connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' in pool
Mar 30 07:14:28 odoopd02 odoo14[5194]: 2022-03-30 07:14:28,177 5194 INFO DatabaseName werkzeug: 10.0.1.4 - - [30/Mar/2022 07:14:28] "GET / HTTP/1.1" 303 - 2 0.002 0.085
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,206 5201 INFO DatabaseName werkzeug: 10.0.1.4 - - [30/Mar/2022 07:14:28] "GET / HTTP/1.0" 303 - 2 0.010 0.103
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,416 5197 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,427 5201 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,440 5197 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Create new connection
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,441 5197 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('template0', 'postgres') order by datname
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,442 5201 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Create new connection
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,442 5201 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('template0', 'postgres') order by datname
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,443 5201 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,443 5201 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.001355/1
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,443 5201 DEBUG ? odoo.sql_db: SUM from:0:00:00.001355/1 [399]
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,443 5201 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [399]
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,443 5201 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Give back connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,444 5201 DEBUG ? odoo.sql_db: ConnectionPool(used=0/count=1/max=25) Forgot connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,444 5201 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,446 5201 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=1/max=25) Borrow existing connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' at index 0
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,446 5201 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:14:28 odoopd02 odoo14[5201]: base_cache_signaling.last_value
Mar 30 07:14:28 odoopd02 odoo14[5201]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,458 5197 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,459 5197 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.017748/1
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,459 5197 DEBUG ? odoo.sql_db: SUM from:0:00:00.017748/1 [436]
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,459 5197 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [436]
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,459 5201 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [400]
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,459 5201 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [400]
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,459 5197 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Give back connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,459 5197 DEBUG ? odoo.sql_db: ConnectionPool(used=0/count=1/max=25) Forgot connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,459 5197 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,460 5197 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=1/max=25) Borrow existing connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' at index 0
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,460 5197 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:14:28 odoopd02 odoo14[5197]: base_cache_signaling.last_value
Mar 30 07:14:28 odoopd02 odoo14[5197]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,459 5201 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=1/max=25) Give back connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,460 5201 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=0/count=1/max=25) Put connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' in pool
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,460 5197 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [437]
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,460 5197 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [437]
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,460 5197 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=1/max=25) Give back connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,460 5197 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=0/count=1/max=25) Put connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' in pool
Mar 30 07:14:28 odoopd02 odoo14[5197]: 2022-03-30 07:14:28,521 5197 INFO DatabaseName werkzeug: 10.0.1.5 - - [30/Mar/2022 07:14:28] "GET / HTTP/1.1" 303 - 2 0.018 0.086
Mar 30 07:14:28 odoopd02 odoo14[5201]: 2022-03-30 07:14:28,540 5201 INFO DatabaseName werkzeug: 10.0.1.5 - - [30/Mar/2022 07:14:28] "GET / HTTP/1.0" 303 - 2 0.014 0.099
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,288 5204 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,303 5204 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=4/max=25) Create new connection
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,304 5204 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('template0', 'postgres') order by datname
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,305 5204 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,305 5204 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.001506/1
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,305 5204 DEBUG ? odoo.sql_db: SUM from:0:00:00.001506/1 [304]
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,305 5204 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [304]
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,305 5204 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=4/max=25) Give back connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,306 5204 DEBUG ? odoo.sql_db: ConnectionPool(used=0/count=3/max=25) Forgot connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,306 5204 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,306 5204 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=3/max=25) Borrow existing connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' at index 0
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,306 5204 DEBUG DatabaseName odoo.sql_db: query: SELECT latest_version FROM ir_module_module WHERE name='base'
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,306 5204 DEBUG DatabaseName odoo.sql_db: query: SELECT COUNT(*) FROM ir_module_module WHERE state LIKE 'to %'
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,307 5204 DEBUG DatabaseName odoo.sql_db: query: SELECT * FROM ir_cron
Mar 30 07:14:46 odoopd02 odoo14[5204]: WHERE numbercall != 0
Mar 30 07:14:46 odoopd02 odoo14[5204]: AND active AND nextcall <= (now() at time zone 'UTC')
Mar 30 07:14:46 odoopd02 odoo14[5204]: ORDER BY priority
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,307 5204 DEBUG DatabaseName odoo.sql_db: SQL LOG from:
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,307 5204 DEBUG DatabaseName odoo.sql_db: table: ir_module_module: 0:00:00.000545/2
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,307 5204 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00.000545/3 [307]
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,307 5204 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/3 [307]
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,307 5204 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=3/max=25) Give back connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:46 odoopd02 odoo14[5204]: 2022-03-30 07:14:46,307 5204 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=0/count=3/max=25) Put connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' in pool
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,100 5201 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,103 5194 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,116 5194 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=3/max=25) Create new connection
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,116 5194 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('template0', 'postgres') order by datname
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,118 5194 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,118 5194 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.001861/1
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,118 5194 DEBUG ? odoo.sql_db: SUM from:0:00:00.001861/1 [289]
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,118 5194 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [289]
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,118 5194 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=3/max=25) Give back connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,118 5194 DEBUG ? odoo.sql_db: ConnectionPool(used=0/count=2/max=25) Forgot connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,119 5194 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,126 5194 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Borrow existing connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' at index 0
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,126 5194 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:14:58 odoopd02 odoo14[5194]: base_cache_signaling.last_value
Mar 30 07:14:58 odoopd02 odoo14[5194]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,200 5194 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [290]
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,200 5194 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [290]
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,204 5194 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Give back connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:58 odoopd02 odoo14[5194]: 2022-03-30 07:14:58,204 5194 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=0/count=2/max=25) Put connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' in pool
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,218 5201 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Create new connection
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,218 5201 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('template0', 'postgres') order by datname
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,228 5201 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,228 5201 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.009293/1
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,228 5201 DEBUG ? odoo.sql_db: SUM from:0:00:00.009293/1 [401]
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,228 5201 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [401]
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,228 5201 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Give back connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,228 5201 DEBUG ? odoo.sql_db: ConnectionPool(used=0/count=1/max=25) Forgot connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,229 5201 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,236 5201 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=1/max=25) Borrow existing connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' at index 0
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,236 5201 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:14:58 odoopd02 odoo14[5201]: base_cache_signaling.last_value
Mar 30 07:14:58 odoopd02 odoo14[5201]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,247 5201 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [402]
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,247 5201 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [402]
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,247 5201 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=1/max=25) Give back connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,247 5201 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=0/count=1/max=25) Put connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' in pool
Mar 30 07:14:58 odoopd02 odoo14[5201]: 2022-03-30 07:14:58,311 5201 INFO DatabaseName werkzeug: 10.0.1.4 - - [30/Mar/2022 07:14:58] "GET / HTTP/1.1" 303 - 2 0.020 0.191
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,419 5193 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,422 5197 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,441 5193 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=3/max=25) Create new connection
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,441 5193 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('template0', 'postgres') order by datname
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,459 5197 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Create new connection
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,459 5193 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,460 5193 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.018422/1
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,461 5193 DEBUG ? odoo.sql_db: SUM from:0:00:00.018422/1 [677]
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,462 5193 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [677]
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,481 5193 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=3/max=25) Give back connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,481 5197 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('template0', 'postgres') order by datname
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,481 5193 DEBUG ? odoo.sql_db: ConnectionPool(used=0/count=2/max=25) Forgot connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,509 5193 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,513 5193 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Borrow existing connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' at index 0
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,513 5193 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:14:58 odoopd02 odoo14[5193]: base_cache_signaling.last_value
Mar 30 07:14:58 odoopd02 odoo14[5193]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,516 5193 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [678]
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,516 5193 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [678]
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,517 5193 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Give back connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,518 5193 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=0/count=2/max=25) Put connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' in pool
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,510 5197 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,573 5197 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.028463/1
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,573 5197 DEBUG ? odoo.sql_db: SUM from:0:00:00.028463/1 [438]
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,573 5197 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [438]
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,585 5197 DEBUG ? odoo.sql_db: ConnectionPool(used=1/count=2/max=25) Give back connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,585 5197 DEBUG ? odoo.sql_db: ConnectionPool(used=0/count=1/max=25) Forgot connection to 'user=odoo14 password=xxx dbname=postgres host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:58 odoopd02 odoo14[5193]: 2022-03-30 07:14:58,587 5193 INFO DatabaseName werkzeug: 10.0.1.5 - - [30/Mar/2022 07:14:58] "GET / HTTP/1.1" 303 - 2 0.019 0.149
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,606 5197 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,606 5197 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=1/max=25) Borrow existing connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' at index 0
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,607 5197 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:14:58 odoopd02 odoo14[5197]: base_cache_signaling.last_value
Mar 30 07:14:58 odoopd02 odoo14[5197]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,611 5197 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [439]
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,611 5197 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [439]
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,612 5197 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=1/count=1/max=25) Give back connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer'
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,612 5197 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=0/count=1/max=25) Put connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' in pool
Mar 30 07:14:58 odoopd02 odoo14[5197]: 2022-03-30 07:14:58,707 5197 INFO DatabaseName werkzeug: 10.0.1.5 - - [30/Mar/2022 07:14:58] "GET / HTTP/1.0" 303 - 2 0.029 0.256
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,795 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,796 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,796 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,796 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,797 5203 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,797 5203 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,798 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,822 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,822 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,823 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,851 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,851 5203 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,851 5203 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,885 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,885 5203 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,886 5203 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,886 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,887 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,887 5203 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,888 5203 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,888 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,889 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,889 5203 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,890 5203 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,890 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,891 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,892 5203 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,892 5203 DEBUG ? odoo.sql_db: create serialized cursor to {'database': 'postgres', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,893 5203 DEBUG DatabaseName odoo.sql_db: create serialized cursor to {'database': 'DatabaseName', 'host': '10.0.0.8', 'port': 5432, 'user': 'odoo14', 'password': 'DatabasePassword', 'sslmode': 'prefer'}
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,893 5203 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=2/count=3/max=25) Borrow existing connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' at index 1
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,893 5203 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:15:07 odoopd02 odoo14[5203]: base_cache_signaling.last_value
Mar 30 07:15:07 odoopd02 odoo14[5203]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,894 5203 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [2288]
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,894 5203 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [2288]
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,896 5203 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=3/count=3/max=25) Borrow existing connection to 'user=odoo14 password=xxx dbname=DatabaseName host=10.0.0.8 port=5432 sslmode=prefer' at index 1
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,896 5203 DEBUG DatabaseName odoo.sql_db: query: SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2022-03-30 07:14:17') AND ("bus_bus"."channel" in ('"bundle_changed"','["DatabaseName","mail.channel",1]','["DatabaseName","res.partner",90]','["DatabaseName","ir.needaction",90]'))) ORDER BY "bus_bus"."id"
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,902 5203 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=4/count=4/max=25) Create new connection
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,902 5203 DEBUG DatabaseName odoo.sql_db: query: SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2022-03-30 07:14:17') AND ("bus_bus"."channel" in ('"bundle_changed"','["DatabaseName","mail.channel",1]','["DatabaseName","res.partner",86]','["DatabaseName","ir.needaction",86]'))) ORDER BY "bus_bus"."id"
Mar 30 07:15:07 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,904 5203 DEBUG DatabaseName odoo.sql_db: SQL LOG from:
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,904 5203 DEBUG DatabaseName odoo.sql_db: table: bus_bus: 0:00:00.001681/1
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,904 5203 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00.001681/1 [2289]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,904 5203 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [2289]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,908 5203 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=5/count=5/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,909 5203 DEBUG DatabaseName odoo.sql_db: query: SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2022-03-30 07:14:17') AND ("bus_bus"."channel" in ('"bundle_changed"','["DatabaseName","mail.channel",1]','["DatabaseName","res.partner",96]','["DatabaseName","ir.needaction",96]'))) ORDER BY "bus_bus"."id"
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,910 5203 DEBUG DatabaseName odoo.sql_db: SQL LOG from:
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,911 5203 DEBUG DatabaseName odoo.sql_db: table: bus_bus: 0:00:00.001648/1
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,911 5203 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00.001648/1 [2290]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,911 5203 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [2290]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,915 5203 DEBUG DatabaseName odoo.sql_db: SQL LOG from:
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,915 5203 DEBUG DatabaseName odoo.sql_db: table: bus_bus: 0:00:00.010125/1
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,916 5203 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00.010125/1 [2291]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,916 5203 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [2291]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:07,955 5203 DEBUG ? odoo.sql_db: ConnectionPool(used=6/count=6/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,222 5203 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('postgres', 'template0') order by datname
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,239 5203 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,239 5203 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.016703/1
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,239 5203 DEBUG ? odoo.sql_db: SUM from:0:00:00.016703/1 [2292]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,239 5203 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [2292]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,256 5203 DEBUG ? odoo.sql_db: ConnectionPool(used=7/count=7/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,257 5203 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('postgres', 'template0') order by datname
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,262 5203 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=8/count=8/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,262 5203 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:15:08 odoopd02 odoo14[5203]: base_cache_signaling.last_value
Mar 30 07:15:08 odoopd02 odoo14[5203]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,263 5203 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [2293]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,263 5203 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [2293]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,274 5203 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,274 5203 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.017630/1
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,274 5203 DEBUG ? odoo.sql_db: SUM from:0:00:00.017630/1 [2294]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,274 5203 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [2294]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,293 5203 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=9/count=9/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,294 5203 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:15:08 odoopd02 odoo14[5203]: base_cache_signaling.last_value
Mar 30 07:15:08 odoopd02 odoo14[5203]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,298 5203 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [2295]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,298 5203 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [2295]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,303 5203 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=10/count=10/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,303 5203 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:15:08 odoopd02 odoo14[5203]: base_cache_signaling.last_value
Mar 30 07:15:08 odoopd02 odoo14[5203]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,303 5203 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [2296]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,303 5203 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [2296]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,311 5203 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=11/count=11/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,311 5203 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:15:08 odoopd02 odoo14[5203]: base_cache_signaling.last_value
Mar 30 07:15:08 odoopd02 odoo14[5203]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,312 5203 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [2297]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,312 5203 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [2297]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,334 5203 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=12/count=12/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,334 5203 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:15:08 odoopd02 odoo14[5203]: base_cache_signaling.last_value
Mar 30 07:15:08 odoopd02 odoo14[5203]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,338 5203 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [2298]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,338 5203 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [2298]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,348 5203 DEBUG ? odoo.sql_db: ConnectionPool(used=13/count=13/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,348 5203 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('postgres', 'template0') order by datname
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,349 5203 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,349 5203 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.001487/1
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,349 5203 DEBUG ? odoo.sql_db: SUM from:0:00:00.001487/1 [2299]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,349 5203 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [2299]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,358 5203 DEBUG ? odoo.sql_db: ConnectionPool(used=14/count=14/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,359 5203 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('postgres', 'template0') order by datname
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,360 5203 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,360 5203 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.001498/1
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,360 5203 DEBUG ? odoo.sql_db: SUM from:0:00:00.001498/1 [2300]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,360 5203 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [2300]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,379 5203 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=15/count=15/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,379 5203 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:15:08 odoopd02 odoo14[5203]: base_cache_signaling.last_value
Mar 30 07:15:08 odoopd02 odoo14[5203]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,385 5203 DEBUG ? odoo.sql_db: ConnectionPool(used=16/count=16/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,385 5203 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('postgres', 'template0') order by datname
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,386 5203 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [2301]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,386 5203 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [2301]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,387 5203 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,387 5203 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.001921/1
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,387 5203 DEBUG ? odoo.sql_db: SUM from:0:00:00.001921/1 [2302]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,387 5203 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [2302]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,406 5203 DEBUG ? odoo.sql_db: ConnectionPool(used=17/count=17/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,406 5203 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('postgres', 'template0') order by datname
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,412 5203 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,412 5203 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.005095/1
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,412 5203 DEBUG ? odoo.sql_db: SUM from:0:00:00.005095/1 [2303]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,412 5203 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [2303]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,412 5203 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=18/count=18/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,412 5203 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:15:08 odoopd02 odoo14[5203]: base_cache_signaling.last_value
Mar 30 07:15:08 odoopd02 odoo14[5203]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,413 5203 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [2304]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,413 5203 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [2304]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,418 5203 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=19/count=19/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,418 5203 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:15:08 odoopd02 odoo14[5203]: base_cache_signaling.last_value
Mar 30 07:15:08 odoopd02 odoo14[5203]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,419 5203 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [2305]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,419 5203 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [2305]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,438 5203 DEBUG ? odoo.sql_db: ConnectionPool(used=20/count=20/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,438 5203 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('postgres', 'template0') order by datname
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,443 5203 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,443 5203 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.004742/1
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,443 5203 DEBUG ? odoo.sql_db: SUM from:0:00:00.004742/1 [2306]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,443 5203 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [2306]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,470 5203 DEBUG ? odoo.sql_db: ConnectionPool(used=21/count=21/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,471 5203 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('postgres', 'template0') order by datname
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,475 5203 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,475 5203 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.004620/1
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,475 5203 DEBUG ? odoo.sql_db: SUM from:0:00:00.004620/1 [2307]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,475 5203 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [2307]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,477 5203 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=22/count=22/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,477 5203 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:15:08 odoopd02 odoo14[5203]: base_cache_signaling.last_value
Mar 30 07:15:08 odoopd02 odoo14[5203]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,478 5203 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [2308]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,478 5203 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [2308]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,507 5203 DEBUG DatabaseName odoo.sql_db: ConnectionPool(used=23/count=23/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,507 5203 DEBUG DatabaseName odoo.sql_db: query: SELECT base_registry_signaling.last_value,
Mar 30 07:15:08 odoopd02 odoo14[5203]: base_cache_signaling.last_value
Mar 30 07:15:08 odoopd02 odoo14[5203]: FROM base_registry_signaling, base_cache_signaling
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,512 5203 DEBUG DatabaseName odoo.sql_db: SUM from:0:00:00/1 [2309]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,512 5203 DEBUG DatabaseName odoo.sql_db: SUM into:0:00:00/1 [2309]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,517 5203 DEBUG ? odoo.sql_db: ConnectionPool(used=24/count=24/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,517 5203 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('postgres', 'template0') order by datname
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,519 5203 DEBUG ? odoo.sql_db: SQL LOG from:
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,519 5203 DEBUG ? odoo.sql_db: table: pg_user: 0:00:00.002152/1
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,519 5203 DEBUG ? odoo.sql_db: SUM from:0:00:00.002152/1 [2310]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,519 5203 DEBUG ? odoo.sql_db: SUM into:0:00:00/1 [2310]
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,528 5203 DEBUG ? odoo.sql_db: ConnectionPool(used=25/count=25/max=25) Create new connection
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,528 5203 DEBUG ? odoo.sql_db: query: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('postgres', 'template0') order by datname
Mar 30 07:15:08 odoopd02 odoo14[5203]: Traceback (most recent call last):
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/env/lib/python3.8/site-packages/gevent/pywsgi.py", line 970, in handle_one_response
Mar 30 07:15:08 odoopd02 odoo14[5203]: self.run_application()
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/env/lib/python3.8/site-packages/gevent/pywsgi.py", line 917, in run_application
Mar 30 07:15:08 odoopd02 odoo14[5203]: self.result = self.application(self.environ, self.start_response)
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/odoo/service/wsgi_server.py", line 111, in application
Mar 30 07:15:08 odoopd02 odoo14[5203]: return ProxyFix(application_unproxied)(environ, start_response)
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/env/lib/python3.8/site-packages/werkzeug/middleware/proxy_fix.py", line 232, in __call__
Mar 30 07:15:08 odoopd02 odoo14[5203]: return self.app(environ, start_response)
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/odoo/service/wsgi_server.py", line 88, in application_unproxied
Mar 30 07:15:08 odoopd02 odoo14[5203]: result = odoo.http.root(environ, start_response)
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/odoo/http.py", line 1307, in __call__
Mar 30 07:15:08 odoopd02 odoo14[5203]: return self.dispatch(environ, start_response)
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/odoo/http.py", line 1273, in __call__
Mar 30 07:15:08 odoopd02 odoo14[5203]: return self.app(environ, start_wrapped)
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/env/lib/python3.8/site-packages/werkzeug/middleware/shared_data.py", line 220, in __call__
Mar 30 07:15:08 odoopd02 odoo14[5203]: return self.app(environ, start_response)
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/odoo/http.py", line 1479, in dispatch
Mar 30 07:15:08 odoopd02 odoo14[5203]: odoo.registry(db).check_signaling()
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/odoo/modules/registry.py", line 610, in check_signaling
Mar 30 07:15:08 odoopd02 odoo14[5203]: with closing(self.cursor()) as cr:
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/odoo/modules/registry.py", line 704, in cursor
Mar 30 07:15:08 odoopd02 odoo14[5203]: return self._db.cursor()
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/odoo/sql_db.py", line 676, in cursor
Mar 30 07:15:08 odoopd02 odoo14[5203]: return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/odoo/sql_db.py", line 248, in __init__
Mar 30 07:15:08 odoopd02 odoo14[5203]: self._cnx = pool.borrow(dsn)
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/odoo/sql_db.py", line 559, in _locked
Mar 30 07:15:08 odoopd02 odoo14[5203]: return fun(self, *args, **kwargs)
Mar 30 07:15:08 odoopd02 odoo14[5203]: File "/odoo14/odoo14-server/odoo/sql_db.py", line 622, in borrow
Mar 30 07:15:08 odoopd02 odoo14[5203]: raise PoolError('The Connection Pool Is Full')
Mar 30 07:15:08 odoopd02 odoo14[5203]: psycopg2.pool.PoolError: The Connection Pool Is Full
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30T07:15:08Z {'REMOTE_ADDR': '10.0.1.5', 'REMOTE_PORT': '55500', 'HTTP_HOST': 'apps.domain.com', (hidden keys: 47)} failed with PoolError
Mar 30 07:15:08 odoopd02 odoo14[5203]: 2022-03-30 07:15:08,531 5203 INFO DatabaseName longpolling: 10.0.1.5 - - [2022-03-30 07:15:08] "POST /longpolling/poll HTTP/1.0" 500 161 0.640781

Related Posts Replies Views Activity
1
Jul 21
4006
0
Dec 17
5958
4
Jun 24
3821
2
Dec 22
2872
1
Dec 22
4274