Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
6 Odpowiedzi
44030 Widoki

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 ?

Awatar
Odrzuć

Try to start/restart you service for the postgreSQL.

Autor

I've already done this, but it stops and give me the message I posted.

Najlepsza odpowiedź

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 


Awatar
Odrzuć
Najlepsza odpowiedź

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?

Awatar
Odrzuć
Najlepsza odpowiedź

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.


Awatar
Odrzuć
Najlepsza odpowiedź

try to replace mimetypes.pyc in odoo server from python lib folder. after that restart server

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
1
mar 15
9031
0
lut 25
1586
2
sty 25
8216
2
sty 24
10138
7
sty 24
49009