Closed scout249 closed 1 year ago
Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid.
Your SQL container is refusing connection. You probably want to investigate that.
@j0nnymoe
This is the log from mariadb container.
230816 17:02:19 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:19 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:20 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:20 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:21 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:21 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:22 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:22 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:23 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:23 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:24 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:24 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:25 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:25 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:26 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:26 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:27 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:27 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:28 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:28 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:29 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:29 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:30 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:30 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:31 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:31 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:32 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:32 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:33 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:33 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:34 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:34 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:35 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:35 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:36 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:36 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:37 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:37 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:38 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:38 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:39 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:39 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:40 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:40 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:41 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:41 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:42 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:42 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
230816 17:02:43 mysqld_safe Logging to '/config/databases/dcd59ebc11b2.err'.
230816 17:02:43 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
Yep, you've got a corrupted database there. Follow that guide but also, you're using portainer. We don't support nor recommend it. https://info.linuxserver.io/issues/2023-05-22-portainer/
Thank you, this is the first time I heard portainer and Synology will overwrite settings.
I am trying to repair the database, and getting error message. Is there any specific log I need to check? Thank you.
root@docker:~$ docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
09a2e8e159fc lscr.io/linuxserver/bookstack:amd64-version-v22.10.2 "/init" 19 seconds ago Up 18 seconds 443/tcp, 0.0.0.0:6875->80/tcp, :::6875->80/tcp bookstack
fd72148f19b2 lscr.io/linuxserver/mariadb:amd64-10.6.10-r0-ls75 "/init" 19 seconds ago Up 18 seconds 3306/tcp bookstack_db
root@docker:~$ docker exec -it fd72 bash
root@fd72148f19b2:/# mariadb-check -A
mariadb-check: Got error: 2002: Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2) when trying to connect
root@fd72148f19b2:/# mariadb-check -A -u root
mariadb-check: Got error: 2002: Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2) when trying to connect
root@fd72148f19b2:/# mariadb-check -A -u root -p
Enter password:
mariadb-check: Got error: 2002: Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2) when trying to connect
root@fd72148f19b2:/# mariadb-check -A -u bookstack -p
Enter password:
mariadb-check: Got error: 2002: Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2) when trying to connect
root@fd72148f19b2:/# mariadb-check -a -A
mariadb-check: Got error: 2002: Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2) when trying to connect
root@fd72148f19b2:/# mariadb-check -a -A -u bookstack -p
Enter password:
mariadb-check: Got error: 2002: Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2) when trying to connect
root@fd72148f19b2:/# mariadb-check -a -A -u root -p
Enter password:
mariadb-check: Got error: 2002: Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2) when trying to connect
I am trying to repair the database, and getting error message. Is there any specific log I need to check? Thank you.
We support the container, not the application. I would suggest that if you wish to repair the db, you consult the official mariadb documentation. The easier thing would be to restore your latest backup prior to the corruption. As a note, we haven't supported or recommended portainer for 5+ years.
Is there an existing issue for this?
Current Behavior
I've tried to upgrade bookstack from
amd64-version-v22.10.2
tolatest
via docker-compose, but it does not work and show HTTP error 500. I have tried to revert to old version, but bookstack still not show HTTP 500.Expected Behavior
Should serve Bookstack.
Steps To Reproduce
Copy/paste docker-compose config from README with the addition of APP_URL Access it through a browser, no error is shown
Modify the script to use latest tag for
bookstack:latest
andmariadb:latest
Environment
CPU architecture
x86-64
Docker creation
Container logs