Hi,
I begin to investigate some freezes in kanboard and in house web applications (~30 seconds), all of them using postgresql 9.2 as backend.
I enabled logging in postgresql server and it appears that kanboard continually send requests to the server :
2019-08-23 13:13:03 CEST kanboard ::1 [953]: [1-1] NOTICE: relation “schema_version” already exists, skipping
2019-08-23 13:13:03 CEST kanboard ::1 [953]: [2-1] STATEMENT: CREATE TABLE IF NOT EXISTS schema_version (version INTEGER DEFAULT 0)
2019-08-23 13:13:04 CEST kanboard ::1 [954]: [1-1] NOTICE: relation “schema_version” already exists, skipping
2019-08-23 13:13:04 CEST kanboard ::1 [954]: [2-1] STATEMENT: CREATE TABLE IF NOT EXISTS schema_version (version INTEGER DEFAULT 0)
2019-08-23 13:13:05 CEST kanboard ::1 [955]: [1-1] NOTICE: relation “schema_version” already exists, skipping
2019-08-23 13:13:05 CEST kanboard ::1 [955]: [2-1] STATEMENT: CREATE TABLE IF NOT EXISTS schema_version (version INTEGER DEFAULT 0)
2019-08-23 13:13:25 CEST kanboard ::1 [1057]: [1-1] NOTICE: relation “schema_version” already exists, skipping
2019-08-23 13:13:25 CEST kanboard ::1 [1057]: [2-1] STATEMENT: CREATE TABLE IF NOT EXISTS schema_version (version INTEGER DEFAULT 0)
2019-08-23 13:14:03 CEST kanboard ::1 [1114]: [1-1] NOTICE: relation “schema_version” already exists, skipping
2019-08-23 13:14:03 CEST kanboard ::1 [1114]: [2-1] STATEMENT: CREATE TABLE IF NOT EXISTS schema_version (version INTEGER DEFAULT 0)
2019-08-23 13:14:04 CEST kanboard ::1 [1115]: [1-1] NOTICE: relation “schema_version” already exists, skipping
2019-08-23 13:14:04 CEST kanboard ::1 [1115]: [2-1] STATEMENT: CREATE TABLE IF NOT EXISTS schema_version (version INTEGER DEFAULT 0)
2019-08-23 13:14:05 CEST kanboard ::1 [1116]: [1-1] NOTICE: relation “schema_version” already exists, skipping
2019-08-23 13:14:05 CEST kanboard ::1 [1116]: [2-1] STATEMENT: CREATE TABLE IF NOT EXISTS schema_version (version INTEGER DEFAULT 0)
I don’t think this causes the freeze, but seems to be a strange behaviour
do you have an idea what these requests are? and how we can disable them?
Thank you
Gérald