koduarve / mikrobill

5 stars 2 forks source link

[FIXED] Не стартует часть контейнеров, выдавая ошибку "Fatal glibc error" и "[ERROR] Server mysql:3306 missed 3 heartbeat" #1

Closed toxi22 closed 2 months ago

toxi22 commented 4 months ago

Добрый день. Ошибка того, что не стартует часть контейнеров, ссылаясь на Fatal glibc error и на conflict port 80 может быть связана с тем, что docker-compose версии 1.29.2?

mikrobill_core exited with code 0
mikrobill_nginx | grep: /etc/nginx/task/nginx/USE_HTTPS: No such file or directory
mikrobill_nginx | SSL OFF
mikrobill_nginx | nginx: [warn] conflicting server name "" on 0.0.0.0:80, ignored

mikrobill_db exited with code 127
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
mikrobill_core exited with code 0
mikrobill_nginx | kill: usage: kill [-s sigspec | -n signum | -sigspec] pid | jobspec ... or kill -l [sigspec]
mikrobill_core | /bin/entrypoint.sh: line 19:     9 Killed                  dotnet /home/MikroBILL/MikroBILL.dll /SILENT_INSTALL="{\"web_path\":\"/var/www/web\",\"check_db\":\"0\",\"language\":\"ru\",\"db_ip\":\"mysql\",\"db_port\":\"3306\",\"db_name\":\"${MYSQL_DATABASE}\",\"db_login\":\"root\",\"db_pass\":\"${MYSQL_ROOT_PASSWORD}\",\"admin_login\":\"${ADMIN_LOGIN}\",\"admin_pass\":\"${ADMIN_PASSWORD}\",\"admin_allowed_ip\":\"\",\"lic_accept\":\"1\"}" &> /dev/null
mikrobill_core | MikroBILL exist.
mikrobill_core | MikroBILL WEB exist in path /var/www/web
mikrobill_core exited with code 0
mikrobill_nginx | kill: usage: kill [-s sigspec | -n signum | -sigspec] pid | jobspec ... or kill -l [sigspec]
mikrobill_nginx | kill: usage: kill [-s sigspec | -n signum | -sigspec] pid | jobspec ... or kill -l [sigspec]
mikrobill_core | /bin/entrypoint.sh: line 19:     9 Killed                  dotnet /home/MikroBILL/MikroBILL.dll /SILENT_INSTALL="{\"web_path\":\"/var/www/web\",\"check_db\":\"0\",\"language\":\"ru\",\"db_ip\":\"mysql\",\"db_port\":\"3306\",\"db_name\":\"${MYSQL_DATABASE}\",\"db_login\":\"root\",\"db_pass\":\"${MYSQL_ROOT_PASSWORD}\",\"admin_login\":\"${ADMIN_LOGIN}\",\"admin_pass\":\"${ADMIN_PASSWORD}\",\"admin_allowed_ip\":\"\",\"lic_accept\":\"1\"}" &> /dev/null
proxysql_1   | 2024-07-01 01:59:05 [INFO] Creating new server in HG 10 : mysql:3306 , gtid_port=0, weight=1, status=0
proxysql_1   | 2024-07-01 01:59:05 [INFO] New mysql_group_replication_hostgroups table
proxysql_1   | 2024-07-01 01:59:05 [INFO] New mysql_galera_hostgroups table
proxysql_1   | 2024-07-01 01:59:05 [INFO] New mysql_aws_aurora_hostgroups table
proxysql_1   | 2024-07-01 01:59:05 [INFO] Checksum for table mysql_servers is 9150028803578676426
proxysql_1   | 2024-07-01 01:59:05 [INFO] MySQL_HostGroups_Manager::commit() locked for 3ms
proxysql_1   | Standard Query Processor rev. 2.0.6.0805 -- Query_Processor.cpp -- Thu Sep 30 21:22:46 2021
proxysql_1   | In memory Standard Query Cache (SQC) rev. 1.2.0905 -- Query_Cache.cpp -- Thu Sep 30 21:22:46 2021
proxysql_1   | Standard MySQL Monitor (StdMyMon) rev. 2.0.1226 -- MySQL_Monitor.cpp -- Thu Sep 30 21:22:46 2021
proxysql_1   | 2024-07-01 01:59:05 [INFO] Latest ProxySQL version available: 2.6.3-107-gcdfcfdc
proxysql_1   | 2024-07-01 01:59:35 MySQL_Monitor.cpp:2652:monitor_ping(): [ERROR] Server mysql:3306 missed 3 heartbeats, shunning it and killing all the connections. Disabling other checks until the node comes back online.
mikrobill_core | MikroBILL exist.
mikrobill_core | MikroBILL WEB exist in path /var/www/web
mikrobill_db exited with code 127
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
db_1         | Fatal glibc error: CPU does not support x86-64-v2
mikrobill_nginx | grep: /etc/nginx/task/nginx/USE_HTTPS: No such file or directory
mikrobill_nginx | SSL OFF
mikrobill_nginx | nginx: [warn] conflicting server name "" on 0.0.0.0:80, ignored
mikrobill_core | /bin/entrypoint.sh: line 19:    10 Killed                  dotnet /home/MikroBILL/MikroBILL.dll /SILENT_INSTALL="{\"web_path\":\"/var/www/web\",\"check_db\":\"0\",\"language\":\"ru\",\"db_ip\":\"mysql\",\"db_port\":\"3306\",\"db_name\":\"${MYSQL_DATABASE}\",\"db_login\":\"root\",\"db_pass\":\"${MYSQL_ROOT_PASSWORD}\",\"admin_login\":\"${ADMIN_LOGIN}\",\"admin_pass\":\"${ADMIN_PASSWORD}\",\"admin_allowed_ip\":\"\",\"lic_accept\":\"1\"}" &> /dev/null

04b03eb1866a mysql:8 "docker-entrypoint.s…" 3 minutes ago Restarting (127) 34 seconds ago mikrobill_db

root@backupsrv1:~/mikrobill# docker-compose --version
docker-compose version 1.29.2, build unknown

root@backupsrv1:~/mikrobill# docker --version
Docker version 24.0.7, build 24.0.7-0ubuntu2~22.04.1
toxi22 commented 2 months ago

Проблема решена. На сервере установлен ferm, который блокировал любые запросы в интернет от неизвестных сетей.