|
|
|
Падает база при попытке проверить состояние memcache
|
|||
|---|---|---|---|
|
#18+
Добрый день. При выполнении запроса Код: plsql 1. Не удается получить результат, кроме того коннекты к БД обрываются. В логе пишет: 2016-03-21 17:30:30 MSK [2637]: [21-1] user=,db= LOG: server process (PID 11656) was terminated by signal 11: Segmentation fault 2016-03-21 17:30:30 MSK [2637]: [22-1] user=,db= DETAIL: Failed process was running: select * from memcache_stats(); 2016-03-21 17:30:30 MSK [2637]: [23-1] user=,db= LOG: terminating any other active server processes 2016-03-21 17:30:30 MSK [12613]: [1-1] user=<database>,db=<database> WARNING: terminating connection because of crash of another server process 2016-03-21 17:30:30 MSK [12613]: [2-1] user=<database>,db=<database> DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2016-03-21 17:30:30 MSK [12613]: [3-1] user=<database>,db=<database> HINT: In a moment you should be able to reconnect to the database and repeat your command. 2016-03-21 17:30:30 MSK [12612]: [1-1] user=<database>,db=<database> WARNING: terminating connection because of crash of another server process 2016-03-21 17:30:30 MSK [12612]: [2-1] user=<database>,db=<database> DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. ...................... 2016-03-21 17:30:30 MSK [12563]: [3-1] user=<database>,db=<database> HINT: In a moment you should be able to reconnect to the database and repeat your command. 2016-03-21 17:30:30 MSK [11981]: [1-1] user=callcenter,db=<database> WARNING: terminating connection because of crash of another server process 2016-03-21 17:30:30 MSK [11981]: [2-1] user=callcenter,db=<database> DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2016-03-21 17:30:30 MSK [11981]: [3-1] user=callcenter,db=<database> HINT: In a moment you should be able to reconnect to the database and repeat your command. 2016-03-21 17:30:30 MSK [2637]: [24-1] user=,db= LOG: archiver process (PID 3499) exited with exit code 1 2016-03-21 17:30:30 MSK [12623]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:30 MSK [12626]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:30 MSK [12633]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:30 MSK [2637]: [25-1] user=,db= LOG: all server processes terminated; reinitializing 2016-03-21 17:30:32 MSK [12658]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:32 MSK [12659]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:32 MSK [12660]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:32 MSK [12661]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:32 MSK [12662]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:32 MSK [12663]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:32 MSK [12657]: [1-1] user=,db= LOG: database system was interrupted; last known up at 2016-03-21 17:27:41 MSK 2016-03-21 17:30:32 MSK [12664]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:32 MSK [12665]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode ........................ 2016-03-21 17:30:36 MSK [12870]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:36 MSK [12871]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:36 MSK [12657]: [2-1] user=,db= LOG: database system was not properly shut down; automatic recovery in progress 2016-03-21 17:30:36 MSK [12657]: [3-1] user=,db= LOG: redo starts at 14C/C800D850 2016-03-21 17:30:36 MSK [12872]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:36 MSK [12873]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode ....... 2016-03-21 17:30:36 MSK [12892]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:36 MSK [12893]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:36 MSK [12657]: [4-1] user=,db= LOG: record with zero length at 14C/CD30EB00 2016-03-21 17:30:36 MSK [12657]: [5-1] user=,db= LOG: redo done at 14C/CD30EAD0 2016-03-21 17:30:36 MSK [12657]: [6-1] user=,db= LOG: last completed transaction was at log time 2016-03-21 17:30:30.266522+03 2016-03-21 17:30:36 MSK [12894]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:36 MSK [12895]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode ..... 2016-03-21 17:30:37 MSK [12916]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:37 MSK [12917]: [1-1] user=<database>,db=<database> FATAL: the database system is in recovery mode 2016-03-21 17:30:37 MSK [12921]: [1-1] user=,db= LOG: autovacuum launcher started 2016-03-21 17:30:37 MSK [2637]: [26-1] user=,db= LOG: database system is ready to accept connections БД была недавно перенесена с другого сервера. Функция была восстановлена командой: Код: plsql 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.03.2016, 17:39 |
|
||
|
Падает база при попытке проверить состояние memcache
|
|||
|---|---|---|---|
|
#18+
sec0nd, Стороннее расширение, которое добавляет библиотеку. Скорее всего вы просто скопировали библиотеку, что есть неправильно. Вам следовало бы пересобрать её, или же поставить через пакет. Что поменялось при переезде на новый сервер — ОС? Процессор? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.03.2016, 18:26 |
|
||
|
Падает база при попытке проверить состояние memcache
|
|||
|---|---|---|---|
|
#18+
vyegorov, Да, было просто скопировано... Менялась и ОС и процессор. Содержимое libdir было перенесено со старого сервера на новый. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.03.2016, 18:28 |
|
||
|
Падает база при попытке проверить состояние memcache
|
|||
|---|---|---|---|
|
#18+
sec0ndvyegorov, Да, было просто скопировано... Менялась и ОС и процессор. Содержимое libdir было перенесено со старого сервера на новый. Так нельзя делать НИКОГДА. -- Maxim Boguk www.postgresql-consulting.ru ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.03.2016, 23:58 |
|
||
|
|

start [/forum/topic.php?fid=53&fpage=94&tid=1997340]: |
0ms |
get settings: |
7ms |
get forum list: |
14ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
47ms |
get topic data: |
8ms |
get forum data: |
2ms |
get page messages: |
29ms |
get tp. blocked users: |
1ms |
| others: | 199ms |
| total: | 313ms |

| 0 / 0 |
