on localmachine i have idle transaction
“SELECT “database_table”.“id”, “database_table”.“version” FROM “database_table” WHERE “database_table”.“id” = 426 LIMIT 21”
“SELECT “database_table”.“id”, “database_table”.“version” FROM “database_table” WHERE “database_table”.“id” = 473 LIMIT 21”
and etc. Why?
LOGS
baserow.logs
| 1:C 08 May 2024 11:55:25.902 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
baserow-redis-1 | 1:C 08 May 2024 11:55:25.902 # Redis version=6.2.14, bits=64, commit=00000000, modified=0, pid=1, just started
baserow-redis-1 | 1:C 08 May 2024 11:55:25.902 # Configuration loaded
baserow-redis-1 | 1:M 08 May 2024 11:55:25.902 * monotonic clock: POSIX clock_gettime
baserow-redis-1 | 1:M 08 May 2024 11:55:25.903 * Running mode=standalone, port=6379.
baserow-redis-1 | 1:M 08 May 2024 11:55:25.903 # Server initialized
baserow-redis-1 | 1:M 08 May 2024 11:55:25.903 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
baserow-redis-1 | 1:M 08 May 2024 11:55:25.904 * Loading RDB produced by version 6.2.14
baserow-redis-1 | 1:M 08 May 2024 11:55:25.904 * RDB age 9545 seconds
baserow-redis-1 | 1:M 08 May 2024 11:55:25.904 * RDB memory usage when created 12.00 Mb
This file has been truncated. show original
Hello @MrRaccoon ,
as mentioned here: Re: BUG #4243: Idle in transaction it is probably best to check your pg_locks table to see what is being locked.