Many SQL request (postgreSQL)

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

in config.php, put false to DB_RUN_MIGRATIONS stops this behaviour…

If you dont run migrations, you will eventually run into issues down the road, i.e. if you upgrade or install certain plugins.

thank you for your answer,
if I ugrade kanboard, it seems natural to manually ugrade the database schema too…I prefer that instead of having several thousand requests a day, all year long, for nothing.

As long as you are doing it, you are all good. Just wanted to make sure.

ok, thank you creecros

Le lun. 26 août 2019 à 22:08, Craig Crosby via Kanboard kanboard1@discoursemail.com a écrit :

It’s not normal this create table attempts, even with run migrations enabled. I’ll take a look and see if I find a probable cause