kvant.kako
New Pleskian
Hi,
Got an error:
Accessed server using ssh and ran command: grep mariadb /var/log/syslog
Here is the result:
There are several articles with nearly similar problem which are caused by running out of disk space, so I ran df as well:
Seems disk space is OK.
As the log stated about port usage I also checked it and ran: lsof -i :3306
and there was no output.
Any ideas?
Got an error:
500 Plesk\Exception\Database
DB query failed: "SET sql_mode = ''" Error: SQLSTATE[HY000] [2002] No such file or directoryType | Plesk\Exception\Database |
Message | DB query failed: "SET sql_mode = ''" Error: SQLSTATE[HY000] [2002] No such file or directory |
File | Mysql.php |
Line | 68 |
Accessed server using ssh and ran command: grep mariadb /var/log/syslog
Here is the result:
Bash:
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] /usr/sbin/mariadbd (mysqld 10.6.3-MariaDB-1:10.6.3+maria~bionic) starting as process 54
59 ...
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] InnoDB: Number of pools: 1
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] InnoDB: Using Linux native AIO
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] InnoDB: Completed initialization of buffer pool
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] InnoDB: 128 rollback segments are active.
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please
wait ...
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] InnoDB: 10.6.3 started; log sequence number 56246262715; transaction id 484563175
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] Plugin 'FEEDBACK' is disabled.
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibil
ity with old my.cnf files.
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Warning] 'innodb-large-prefix' was removed. It does nothing now and exists only for compatibi
lity with old my.cnf files.
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds
work.
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [Note] Server socket created on IP: '127.0.0.1'.
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 22: Invalid argument
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Sep 14 13:28:24 ip-172-26-12-43 mariadbd[5459]: 2021-09-14 13:28:24 0 [ERROR] Aborting
Sep 14 13:28:24 ip-172-26-12-43 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Sep 14 13:28:24 ip-172-26-12-43 systemd[1]: mariadb.service: Failed with result 'exit-code'.
There are several articles with nearly similar problem which are caused by running out of disk space, so I ran df as well:
Bash:
Filesystem 1K-blocks Used Available Use% Mounted onli
udev 1999436 0 1999436 0% /dev
tmpfs 402816 852 401964 1% /runil
/dev/xvda1 81253764 23611916 57625464 30% /
tmpfs 2014076 0 2014076 0% /dev/shms
tmpfs 5120 0 5120 0% /run/lock
tmpfs 2014076 0 2014076 0% /sys/fs/cgroup
/dev/loop0 25600 25600 0 100% /snap/amazon-ssm-agent/4046
/dev/loop1 56832 56832 0 100% /snap/core18/2074
/dev/loop2 101760 101760 0 100% /snap/core/11606
/dev/loop3 56832 56832 0 100% /snap/core18/2128
/dev/loop4 101888 101888 0 100% /snap/core/11420
/dev/loop5 34176 34176 0 100% /snap/amazon-ssm-agent/355220
tmpfs 402812 0 402812 0% /run/user/1000
Seems disk space is OK.
As the log stated about port usage I also checked it and ran: lsof -i :3306
and there was no output.
Any ideas?