Get Instant Solutions for Kubernetes, Databases, Docker and more
When encountering the error 1236: Cannot access partition in MySQL, follow these steps:
systemctl status mysql
tail -100 /var/log/mysql/error.log
SHOW GRANTS FOR 'your
mysql
user'@'your_host';
SHOW BINARY LOGS;
and check the last successfully executed binary log file and position:SHOW SLAVE STATUS\G
STOP SLAVE;
CHANGE MASTER TO MASTERLOG
FILE='log
file', MASTER
LOG
POS=log
pos;
START SLAVE;
df -h
ls -ld /var/lib/mysql
chown mysql:mysql /var/lib/mysql -R
chmod 755 /var/lib/mysql
systemctl restart mysql
systemctl status mysql
Only proceed with actions you are comfortable executing and understand the implications of, especially when adjusting file permissions or manipulating binary logs.
(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)
Get Instant Solutions for Kubernetes, Databases, Docker and more
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
Unordered list
Bold text
Emphasis
Superscript
Subscript
(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)