Roundcube now giving 504 Gateway Timeout after upgrade

Help with Setup/Upgrade
1

Hi all. My MIAB was working great up to 55, just upgraded a few days ago to 56.
Now I get 504 Gateway Timeout Nginx when I try to open my webmail. If I reboot the server, it works again for a little while then same thing.

What happened?
Tail of roundcube error log:

[24-Jan-2022 13:34:28 -0800]: <2rpj9blv> DB Error: [5] database is locked (SQL )
[24-Jan-2022 13:34:28 -0800]: <2rpj9blv> DB Error: [5] database is locked (GET )
[24-Jan-2022 13:34:28 -0800]: <2rpj9blv> DB Error: [5] database is locked (SQL )
[24-Jan-2022 13:35:07 -0800]: DB Error: [5] database is locked (SQL )
[24-Jan-2022 13:36:23 -0800]: DB Error: [5] database is locked (SQL )
[24-Jan-2022 13:56:59 -0800]: DB Error: [5] database is locked (SQL )
[24-Jan-2022 13:57:59 -0800]: <0d0m81qt> DB Error: [5] database is locked (SQL )
[24-Jan-2022 14:13:34 -0800]: <3i9isfh0> DB Error: [5] database is locked (SQL )
[24-Jan-2022 14:13:34 -0800]: <3i9isfh0> DB Error: [5] database is locked (GET )
[24-Jan-2022 14:13:34 -0800]: <3i9isfh0> DB Error: [19] UNIQUE constraint faile)

Tail of Nginx log:

2022/01/24 13:51:34 [error] 880#880: *163 open() “/home/user-data/www/default/w”
2022/01/24 13:51:34 [error] 880#880: *163 open() “/home/user-data/www/default/n”
2022/01/24 13:51:34 [error] 880#880: *163 open() “/home/user-data/www/default/w”
2022/01/24 13:51:34 [error] 880#880: *163 open() “/home/user-data/www/default/t”
2022/01/24 13:51:34 [error] 880#880: *163 open() “/home/user-data/www/default/w”
2022/01/24 13:51:34 [error] 880#880: *163 open() “/home/user-data/www/default/s”
2022/01/24 13:51:34 [error] 880#880: *163 open() “/home/user-data/www/default/c”
2022/01/24 13:51:34 [error] 880#880: *163 open() “/home/user-data/www/default/s”
2022/01/24 13:56:59 [error] 880#880: *166 upstream timed out (110: Connection t"
2022/01/24 14:13:34 [error] 880#880: *180 upstream timed out (110: Connection t"

Anything else I can look at? I saw a previous thread on this error but it was for version 26. It did mention checking Nextcloud so I did that. That seem to be working fine for both Contacts and Calendars. It’s just Roundcube acting up.

2

Well I don’t know what happened. I had to reboot in this way about 5 times since the update, then it suddenly seems to be working fine since I posted this yesterday (last reboot)

1 Like
3

Still happening after all…

4

Did you make any changes, at all, to anything that MiaB configures?

5

Not a thing. Just did the upgrade as normal. Possibly in relation to the SQL error, I notice that if I don’t use/click through Roundcube too fast, it appears to remain working. If I start clicking things too fast or moving around areas too fast, it bombs out.

6

Mmmm… .i think that i am with the same trouble. Perhaps a bug in the current version of roundcube? Nextcloud runs ok and the admin panel runs ok too. I think that Roundcube may have a problem.

7

The error is

2022/02/01 15:56:58 [error] 2177#2177: *80 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 192.168.177.102, server: correo.tabigal.com, request: “POST /mail/?_task=login HTTP/2.0”, upstream: “fastcgi://unix:/var/run/php/php7.2-fpm.sock”, host: “correo.tabigal.com”, referrer: “box.correo.tabigal.com Webmail :: Welcome to box.correo.tabigal.com Webmail”

8

@wesblake , Can you try this workaround?

Edit /etc/hosts

You can find anything like this in the first line

127.0.0.1 localhost.localdomain localhost box

change it like this

127.0.0.1 localhost.localdomain localhost box box.yourdomain.com yourdomain.com

(Change “yourdomain” and put the right domain there).

This change makes your roundcube works? Tell us, please.

9

@marcosmatas

Been having the same issue, and your workaround worked for me. I basically just moved everything from the line with my external IP (other than internal.local) to the 127.0.0.1 line and Roundcube loaded immediately.

10

Sorry I missed the reply before. I just made those changes and will report back, but it’s off and on. Now it’s been working on it’s own for a few days again, after having to reboot it 3 times in a row to get it there!

11

So I did made that change a day ago, didn’t work, Roundcube just “locked up” again and I had to reboot the server.

12

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.