Сервер 1С находится на сервере с Windows2003, базы на Linux в PostgreSQL, пользователи работаю в терминале.
Примерно две недели назад началось странное - пользователей стало выбрасывать из 1С, при попытке входа появляется сообщение "Информационная база разрушена". Сейчас решаю перезапуском службы 1С.
На одном из форумов подсказали, что возможно проблема не в 1С, а в Postgres и его перезапуск снимет проблему на 2 -3 месяца. PostgreSQL я перезапущу, но с трудом верится что проблема в этом, так как эта связка работает уже более года без проблем.
В логах PostgreSQL следующее:
Код: Выделить всё
Oct 11 12:30:16 database postgres[6927]: [3-1] NOTICE: there is no transaction in progress
Oct 11 13:14:11 database postgres[6942]: [5-1] ERROR: deadlock detected
Oct 11 13:14:11 database postgres[6942]: [5-2] DETAIL: Process 6942 waits for ApplicationExclusiveLock on relation 79057 of database 41202; blocked by process 6853.
Oct 11 13:14:11 database postgres[6942]: [5-3] #011Process 6853 waits for ApplicationShareLock on relation 80623 of database 41202; blocked by process 6942.
Oct 11 13:14:11 database postgres[6942]: [5-4] STATEMENT: LOCK _DocumentJournal3911 IN APPLICATION EXCLUSIVE MODE;
Oct 11 13:14:11 database postgres[6942]: [5-5] #011 SET STATEMENT_TIMEOUT TO DEFAULT;
Oct 11 13:14:11 database postgres[6942]: [5-6] #011
Oct 11 13:14:11 database postgres[6942]: [6-1] NOTICE: there is no transaction in progress
Oct 11 13:56:01 database postgres[6853]: [2-1] NOTICE: CREATE TABLE will create implicit sequence "tt86_f_1_seq" for serial column "tt86.f_1"
Oct 11 15:56:45 database postgres[6560]: [2-1] LOG: could not receive data from client: Connection reset by peer
Oct 11 15:56:45 database postgres[6560]: [3-1] LOG: unexpected EOF on client connection
Oct 11 15:57:13 database postgres[6964]: [3-1] LOG: could not receive data from client: Connection reset by peer
Oct 11 15:57:13 database postgres[6964]: [4-1] LOG: unexpected EOF on client connection
Oct 11 15:57:20 database postgres[6927]: [4-1] LOG: could not receive data from client: Connection reset by peer
Oct 11 15:57:20 database postgres[6927]: [5-1] LOG: unexpected EOF on client connection
Oct 11 15:58:32 database postgres[6863]: [2-1] LOG: could not receive data from client: Connection reset by peer
Oct 11 15:58:32 database postgres[6863]: [3-1] LOG: unexpected EOF on client connection
Oct 11 15:58:39 database postgres[6681]: [3-1] LOG: could not receive data from client: Connection reset by peer
Oct 11 15:58:39 database postgres[6681]: [4-1] LOG: unexpected EOF on client connection
Oct 11 16:51:53 database postgres[7986]: [2-1] NOTICE: CREATE TABLE will create implicit sequence "tt3_f_1_seq" for serial column "tt3.f_1"
Oct 11 17:32:29 database postgres[7966]: [2-1] NOTICE: CREATE TABLE will create implicit sequence "tt25_f_1_seq" for serial column "tt25.f_1"
Oct 11 17:42:09 database postgres[6942]: [7-1] LOG: could not receive data from client: Connection reset by peer
Oct 11 17:42:09 database postgres[6942]: [8-1] LOG: incomplete message from client
Oct 11 17:50:40 database postgres[7475]: [2-1] LOG: could not receive data from client: Connection reset by peer
Oct 11 17:50:40 database postgres[7475]: [3-1] LOG: unexpected EOF on client connection
Oct 11 17:54:09 database postgres[6853]: [3-1] LOG: could not receive data from client: Connection reset by peer
Oct 11 17:54:09 database postgres[6853]: [4-1] LOG: unexpected EOF on client connection
Oct 11 17:55:47 database postgres[7884]: [2-1] LOG: could not receive data from client: Connection reset by peer
Oct 11 17:55:47 database postgres[7884]: [3-1] LOG: unexpected EOF on client connection
Oct 11 17:56:40 database postgres[6762]: [2-1] LOG: could not receive data from client: Connection reset by peer
Oct 11 17:56:40 database postgres[6762]: [3-1] LOG: unexpected EOF on client connection
Более ничего подозрительного не увидел.
Поэтому авопрос - встречался ли кто-нибудь с подобным и как решал?
Спасибо.