Hello,
I’ve SOLVED the issue by myself, I’d like to share the solution with the community.
This post helped me to SOLVE the issue:
I’ve found the following error in /var/lib/mysql/mysql-error.log
2018-04-16 16:22:15 140293027571904 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions.
2018-04-16 16:22:15 140293027571904 [ERROR] Aborting
Then I followed the instruction listed in the above post so I hit the following command:
mysqld --tc-heuristic-recover=ROLLBACK
and then
service mysql start
And everything started to work again.
Thanks for your help
Dario