Summary Mattermost do not go further than “Pinging SQL master database” on startup. Steps to reproduce Mattermost team 5.12.3 3.13.1 Ubuntu 18.04 Postgresql 10 config.json : “SqlSettings”: { “DriverName”: “postgres”, “DataSource”: “postgres://mmuser:<my_password>@localhost:5432/mattermost?ss…

Hi @VoyagesDivins , as a first step, wondering if some of these earlier threads might help: [Solved] Failed to ping db err [SOLVED] Trouble during instalation, failed to ping DB https://github.com/mattermost/mattermost-server/issues/6860 https://stackoverflow.com/questions/42039274/mattermost-3-6-2…

Hi, thanks for replying. I don’t think it’s a firewall problem as db and service are on the same server. Also I do not get messages of connection failed. For instance if I intentionnaly make a mistake, say in port number, I immediately get a message "Failed to ping DB retrying in 10 seconds Wh…

Hi @VoyagesDivins , a response from a community member: If the interruption (full disk) occurred during install, it might be worth a try to drop the mattermost database and try again.

The problem didn’t occure during install. Server was already up and running. As you suggest, the problem came from the database. Table “jobs” had more than 15000 rows. I did a hard truncate on that table and I was able to start mattermost server again. Thank you

The problem occured again after a server reboot. This time truncating “jobs” table didn’t help.

The problem occured again when trying to migrate my data on another server, any ideas ? should I open a issue on github ?

@VoyagesDivins , sorry to hear about the trouble you keep running into. The behaviour you describe is expected from the Mattermost server: if it cannot communicate with your PostgresSQL instance, it will block on startup, eventually stopping altogether after a fixed number of attempts. I’d recommend…

From psql, running SELECT pid, age(clock_timestamp(), query_start), usename, query FROM pg_stat_activity WHERE query != ‘’ AND query NOT ILIKE ‘%pg_stat_activity%’ ORDER BY query_start desc; Two queries running under mattermost user are listed as follow : 10550 | 00:14:26.840856 | mattermos…

The only occurence of this request in the sources is in file supplier.go line 290. The complete request is SELECT Value FROM Systems WHERE Name=‘Version’ Executing this from psql gives me value -------- 5.15.0 (1 row)

Mattermost blocks on pinging database

Troubleshooting

amy.blais (Amy Blais) July 23, 2019, 2:03pm 2

Hi @VoyagesDivins, as a first step, wondering if some of these earlier threads might help:

[Solved] Failed to ping db err
[SOLVED] Trouble during instalation, failed to ping DB
https://github.com/mattermost/mattermost-server/issues/6860
https://stackoverflow.com/questions/42039274/mattermost-3-6-2-ubuntu-16-04-pgsql-9-5-db-dial-err-issue

Topic		Replies	Views
"Failed to ping DB" when trying to start mattermost server Troubleshooting	23	10136	March 28, 2023
Failed to ping to DB Troubleshooting	1	734	April 13, 2023
[Solved] Failed to ping db err Installation	7	16962	September 23, 2016
[SOLVED] Trouble during instalation, failed to ping DB Troubleshooting	9	12796	March 9, 2020
Failed to ping DB error, while installing Troubleshooting	1	772	March 9, 2020

Mattermost blocks on pinging database

Related topics