This question has been flagged
5580 Views

I use odoo 10.0 on windows 10 for a year then today suddenly I got 'Internal server error', when checked the PostgreSQL service I found that it not running. I cannot start the service. the error message is "The PostgreSQL_For_Odoo - PostgreSQL Server 9.5 service on local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs."

This is log file in pg_log 

2019-06-28 11:17:50 ICT LOG: database system was interrupted while in recovery at 2019-06-28 10:20:30 ICT 
2019-06-28 11:17:50 ICT HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery. 
2019-06-28 11:17:51 ICT FATAL: the database system is starting up 
2019-06-28 11:17:52 ICT FATAL: the database system is starting up 
2019-06-28 11:17:53 ICT FATAL: the database system is starting up 
2019-06-28 11:17:54 ICT FATAL: the database system is starting up 
2019-06-28 11:17:55 ICT FATAL: the database system is starting up 
2019-06-28 11:17:56 ICT FATAL: the database system is starting up 
2019-06-28 11:17:57 ICT FATAL: the database system is starting up 
2019-06-28 11:17:58 ICT FATAL: the database system is starting up 
2019-06-28 11:18:00 ICT FATAL: the database system is starting up 
2019-06-28 11:18:01 ICT FATAL: the database system is starting up 
2019-06-28 11:18:02 ICT FATAL: the database system is starting up 
2019-06-28 11:18:03 ICT FATAL: the database system is starting up 
2019-06-28 11:18:03 ICT FATAL: the database system is starting up 
2019-06-28 11:18:04 ICT FATAL: the database system is starting up 
2019-06-28 11:18:05 ICT FATAL: the database system is starting up 
2019-06-28 11:18:06 ICT FATAL: the database system is starting up 
2019-06-28 11:18:07 ICT LOG: database system was not properly shut down; automatic recovery in progress 
2019-06-28 11:18:07 ICT FATAL: the database system is starting up 
2019-06-28 11:18:07 ICT LOG: redo starts at B/86A556A0 
2019-06-28 11:18:07 ICT FATAL: could not access status of transaction 1413782 
2019-06-28 11:18:07 ICT DETAIL: Could not read from file "pg_clog/0001" at offset 90112: No error. 
2019-06-28 11:18:07 ICT CONTEXT: xlog redo Transaction/COMMIT: 2019-06-27 17:46:18.90281+07 
2019-06-28 11:18:07 ICT LOG: startup process (PID 11432) exited with exit code 1 
2019-06-28 11:18:07 ICT LOG: aborting startup due to startup process failure

How can I solve this problem? 

Avatar
Discard