Many SQL request (postgreSQL)

#1

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

#2

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

#3

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

#4

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.

#5

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

#6

ok, thank you creecros

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

#7

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