Mariadb 10.3.22 has Big Problem #270
Description
Hello,
When you get a "Error establishing a database connection" error you can restart mysql stack or configure wp-config.php
I try to restart mariadb but I can't there are some errors on
systemctl status mysql:
This is a bug on Mariadb you can check iti here
https://jira.mariadb.org/browse/MDEV-21826
Affected versions: 10.2.31, 10.3.22, 10.4.12
Solving is use different maridb version like 10.2.32, 10.3.23, 10.4.13
2020-02-26 20:31:15 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3388965427
2020-02-26 20:31:30 0 [Note] InnoDB: Read redo log up to LSN=3388965888
2020-02-26 20:31:45 0 [Note] InnoDB: Read redo log up to LSN=3388965888
2020-02-26 20:32:00 0 [Note] InnoDB: Read redo log up to LSN=3388965888
2020-02-26 20:32:15 0 [Note] InnoDB: Read redo log up to LSN=3388965888
2020-02-26 20:32:30 0 [Note] InnoDB: Read redo log up to LSN=3388965888
2020-02-26 20:32:45 0 [Note] InnoDB: Read redo log up to LSN=3388965888
2020-02-26 20:33:00 0 [Note] InnoDB: Read redo log up to LSN=3388965888
System Information
-
lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 18.04.3 LTS
Release: 18.04
Codename: bionic
-
wo info
NGINX (1.16.1 ):
user www-data
worker_processes auto
worker_connections 50000
keepalive_timeout 8
fastcgi_read_timeout 300
client_max_body_size 100m
allow 127.0.0.1 ::1
PHP (7.3.16-1):
user
expose_php Off
memory_limit 128M
post_max_size 100M
upload_max_filesize 100M
max_execution_time 300
Information about www.conf
ping.path /ping
pm.status_path /status
process_manager ondemand
pm.max_requests 1500
pm.max_children 50
pm.start_servers 10
pm.min_spare_servers 5
pm.max_spare_servers 15
request_terminate_timeout 300
xdebug.profiler_enable_trigger off
listen php73-fpm.sock
Information about debug.conf
ping.path /ping
pm.status_path /status
process_manager ondemand
pm.max_requests 1500
pm.max_children 50
pm.start_servers 10
pm.min_spare_servers 5
pm.max_spare_servers 15
request_terminate_timeout 300
xdebug.profiler_enable_trigger on
listen 127.0.0.1:9173
MySQL (10.3.22-MariaDB) on localhost:
port 3306
wait_timeout 60
interactive_timeout 28800
max_used_connections 5
datadir /var/lib/mysql/
socket /var/run/mysqld/mysqld.sock
my.cnf [PATH] /etc/mysql/conf.d/my.cnf
-
nginx -V
nginx version: nginx/1.16.1 (WordOps Nginx-wo)
built with OpenSSL 1.1.1d 10 Sep 2019 (running with OpenSSL 1.1.1 11 Sep 2018)
TLS SNI support enabled
configure arguments: --with-cc-opt='-g -O2 -fdebug-prefix-map=/build/nginx-xSli4x/nginx-1.16.1=. -fstack-protector-strong -Wformat -Werror=format-security -fPIC -Wdate-time -D_FORTIFY_SOURCE=2' --with-ld-opt='-Wl,-Bsymbolic-functions -Wl,-z,relro -fPIC' --prefix=/usr/share/nginx --conf-path=/etc/nginx/nginx.conf --http-log-path=/var/log/nginx/access.log --error-log-path=/var/log/nginx/error.log --lock-path=/var/lock/nginx.lock --pid-path=/run/nginx.pid --http-client-body-temp-path=/var/lib/nginx/body --http-fastcgi-temp-path=/var/lib/nginx/fastcgi --http-proxy-temp-path=/var/lib/nginx/proxy --http-scgi-temp-path=/var/lib/nginx/scgi --http-uwsgi-temp-path=/var/lib/nginx/uwsgi --build='WordOps Nginx-wo' --with-debug --with-pcre-jit --with-file-aio --with-threads --with-http_ssl_module --with-http_v2_module --with-http_stub_status_module --with-http_realip_module --with-http_v2_hpack_enc --with-http_auth_request_module --with-openssl-opt='enable-ec_nistp_64_gcc_128 enable-tls1_3 no-ssl3-method' --with-http_addition_module --with-http_geoip_module --with-http_gzip_static_module --with-http_mp4_module --with-http_sub_module --without-http_memcached_module --add-module=/build/nginx-xSli4x/nginx-1.16.1/debian/modules/headers-more-nginx-module --add-module=/build/nginx-xSli4x/nginx-1.16.1/debian/modules/nginx-auth-pam --add-module=/build/nginx-xSli4x/nginx-1.16.1/debian/modules/nginx-cache-purge --add-module=/build/nginx-xSli4x/nginx-1.16.1/debian/modules/nginx-echo --add-module=/build/nginx-xSli4x/nginx-1.16.1/debian/modules/nginx-upstream-fair --add-module=/build/nginx-xSli4x/nginx-1.16.1/debian/modules/ngx_http_substitutions_filter_module --add-module=/build/nginx-xSli4x/nginx-1.16.1/debian/modules/memc-nginx-module --add-module=/build/nginx-xSli4x/nginx-1.16.1/debian/modules/srcache-nginx-module --add-module=/build/nginx-xSli4x/nginx-1.16.1/debian/modules/HttpRedisModule --add-module=/build/nginx-xSli4x/nginx-1.16.1/debian/modules/redis2-nginx-module --add-module=/build/nginx-xSli4x/nginx-1.16.1/debian/modules/ngx_devel_kit --add-module=/build/nginx-xSli4x/nginx-1.16.1/debian/modules/set-misc-nginx-module --add-module=/build/nginx-xSli4x/nginx-1.16.1/debian/modules/nginx-module-vts --add-module=/build/nginx-xSli4x/nginx-1.16.1/debian/modules/ngx_brotli
-
wo -v
WordOps v3.11.4
-
wp cli info --allow-root
OS: Linux 4.15.0-91-generic #92-Ubuntu SMP Fri Feb 28 11:09:48 UTC 2020 x86_64
Shell: /bin/bash
PHP binary: /usr/bin/php7.4
PHP version: 7.4.4
php.ini used: /etc/php/7.4/cli/php.ini
WP-CLI root dir: phar://wp-cli.phar/vendor/wp-cli/wp-cli
WP-CLI vendor dir: phar://wp-cli.phar/vendor
WP_CLI phar path: /root
WP-CLI packages dir:
WP-CLI global config:
WP-CLI project config:
WP-CLI version: 2.4.0
-
curl -sL git.io/fjAp3 | sudo -E bash -
https://transfer.vtbox.net/ZnSJj/wordops.txt