Unable to solve Internal Server Error in erpnext

[avaiskhatri]

I found the solution and would like to share it the community.

First I have removed the warning of max_open_files
by editing file using this command

sudo nano /etc/systemd/system/mysqld.service

Changed LimitNOFILE to 40000 from 16364

#LimitNOFILE=16364
LimitNOFILE=40000

Then I googled and found the same problem on this thread

[SOLVED] Mysql error after restart

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 comm…

Repeated the same procedure
checked mysql-error.log file and the error was same.

Then entered 2 commands and my app was up and functional

mysqld --tc-heuristic-recover=ROLLBACK
service mysql start