decen
Execute the command to see what errors are displayed in the mysql log
cat /www/server/data/*.err|grep -i -C 10 error
MySQL error
- Edited
decen
This shows only logs from March not the latest.
decen
Hi, have you done anything? Or did the server lose power? Prompt mysql-bin.000037 file does not exist
Try to delete ./mysql-bin.000037 from the content of this /www/server/data/mysql-bin.index file, and then restart mysql. Can it be solved?
It can be operated in the "File" interface of the panel
cp /www/server/data/mysql-bin.index /www/server/data/mysql-bin.index
/etc/init.d/mysqld restart
Deleted mysql-bin.000037 from the /www/server/data/mysql-bin.index file.
Restarted MySQL. Didn't help
As I understand server can't connect to MySQL,
decen
look again
Execute the command to see what errors are displayed in the mysql log
cat /www/server/data/*.err|grep -i -C 10 error
Yesterday upgraded apt-get upgrade:
Start-Date: 2022-08-02 18:02:27
Commandline: apt-get upgrade
Requested-By: ubuntu (1000)
Upgrade: update-notifier-common:amd64 (3.192.30.10, 3.192.30.11), apt:amd64 (2.0.8, 2.0.9), libkmod2:amd64 (27-1ubuntu2, 27-1ubuntu2.1), snapd:amd64 (2.54.3+20.04.1ubuntu0.3, 2.55.5+20.04), ubuntu-advantage-tools:amd64 (27.820.04.1, 27.920.04.1), isc-dhcp-common:amd64 (4.4.1-2.1ubuntu5.20.04.2, 4.4.1-2.1ubuntu5.20.04.3), libapt-pkg6.0:amd64 (2.0.8, 2.0.9), kmod:amd64 (27-1ubuntu2, 27-1ubuntu2.1), ec2-hibinit-agent:amd64 (1.0.0-0ubuntu9.1, 1.0.0-0ubuntu9.2), libkeyutils1:amd64 (1.6-6ubuntu1, 1.6-6ubuntu1.1), apt-utils:amd64 (2.0.8, 2.0.9), unattended-upgrades:amd64 (2.3ubuntu0.1, 2.3ubuntu0.3), isc-dhcp-client:amd64 (4.4.1-2.1ubuntu5.20.04.2, 4.4.1-2.1ubuntu5.20.04.3)
End-Date: 2022-08-02 18:03:08
Maybe after that MySQL stoped working
decen
Check out what mysql-bin files are in your directory, and can you tell me what you have done before?
ls /www/server/data/mysql-bin*
decen
It shouldn't matter. Is there anything related to mysql?
only one site is connected to mysql. Yesterday I upgraded apt-get upgrade
That's is all i did
- Edited
Execute the command check out what mysql-bin files are in your directory
ls /www/server/data/mysql-bin*
Solved! Everything works perfect.
How to avoid to create this mysql-bin files?
Thank you so much for helping!
decen
This problem does not occur in normal use. Did you do anything? Clear the log? Close mysql-bin?
Time to time i use Log Cleanup app
decen
The mysql-bin log does not need to be cleared by itself. The mysql of the panel is only kept for 10 days, the old ones are cleared every day.