Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I tried to run the odoo and got 'Internal server error', when checked the PostgreSQL service I found that it is stopped. When I tried to run it I got the error message : "The PostgerSQL_For_OpenERP - PostgreSQL Server 9.3 service on local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs."
any help ?
For some reasons postgresql process is still running in the background.
You can encounter this problem if your system forcefully shutdowns down.
Solution:
1. Windows + X (Open task Manager - Processes)
2. Find all running postgresql services and 'End Task'.
After all processes have ended. You can reopen task manager to ensure no postgres services is running.
3. Restart Postgresql server
I also face this error. The suggestion cannot help me to solve the problem. I checked all the background process but don't have any postgresql process.
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
I cannot access SQL Shell(psql) because the service not running
Server [localhost]:
Database [postgres]:
Port [5432]:
Username [openpg]:
psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?
Enter below command on terminal
pg_lscluster
This will give you status of postgres service and log file path.
Check log file of postgres by entering following command on terminal.
tailf /postgres log file path
This will help to find root cause to fix issue.
try to replace mimetypes.pyc in odoo server from python lib folder. after that restart server
| 관련 게시물 | 답글 | 화면 | 활동 | |
|---|---|---|---|---|
|
1
3월 15
|
10088 | ||
|
0
2월 25
|
2891 | ||
|
2
1월 25
|
10068 | ||
|
2
1월 24
|
10139 | ||
|
7
1월 24
|
50907 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Try to start/restart you service for the postgreSQL.
I've already done this, but it stops and give me the message I posted.