Infinite refresh loop from clients

Troubleshooting
21

@jilfransoi Letting you know that I’ve asked our developers to take a look at this.

22

Hi @jilfransoi! The error above from your server logs suggest Mattermost is having trouble interacting with your database server when this problem occurs. Are you able to manually connect to your database server while in this state?

23

Thank you again

here is the code of the page that is looping

<!DOCTYPE html><html><head></head>
<body onload="window.location = '/error?message=Nous+avons+rencontr%C3%A9+une+erreur+lors+de+la+recherche+de+la+session&amp;s=MEYCIQDr9iG7sig4dijsNx8crNxI6w7hX0RrCCLS5jLPjK-IpQIhAMifuiF2cS2Fks18tF_axi4H47lTgWO8aV1M7bE0V-T8'">
<noscript><meta http-equiv="refresh" content="0; url=/error?message=Nous+avons+rencontr%C3%A9+une+erreur+lors+de+la+recherche+de+la+session&amp;s=MEYCIQDr9iG7sig4dijsNx8crNxI6w7hX0RrCCLS5jLPjK-IpQIhAMifuiF2cS2Fks18tF_axi4H47lTgWO8aV1M7bE0V-T8"></noscript>
<a href="/error?message=Nous+avons+rencontr%C3%A9+une+erreur+lors+de+la+recherche+de+la+session&amp;s=MEYCIQDr9iG7sig4dijsNx8crNxI6w7hX0RrCCLS5jLPjK-IpQIhAMifuiF2cS2Fks18tF_axi4H47lTgWO8aV1M7bE0V-T8" style="color: #c0c0c0;">...</a>
</body></html>

Maybe it can help ?

24

Yep. I will try to connect to it next time my instance start looping. What do you think I may look at ?

25

@jilfransoi, the primary litmus test would be to verify your own ability connect, and perhaps query a table:

SELECT COUNT(*) FROM Users;

Are you running MySQL or PostgreSQL? If connectivity is not a problem, it might also be useful to dump any locked tables, but the commands are database-specific.

26

I am on MySql
I will try that and will get back to you.
Cheers

27

@jilfransoi, excellent, also run this query against MySQL when this occurs:

SHOW OPEN TABLES IN mattermost;

and post back with the content. (Assuming your database name is mattermost, otherwise replace as necessary).