Добрый день
Люди подскажите, пожалуйста.
Значит, когда я загружаю базу 1с в PostgreSQL вылетает, хотя бывает и просто вылетает. Вот выдержка из логов
LOG: statement: create temporary table tt1 (_C_1RRef bytea,_C_2 bytea,_C_3 boolean,_C_4 timestamp,_C_5 numeric(9,0),_C_6 boolean,_C_7 mvarchar,_C_8RRef bytea,_C_9RRef bytea,_C_10RRef bytea,_C_11 timestamp,_C_12 timestamp,_C_13RRef bytea,_C_14RRef bytea,_C_15 timestamp,_TTC_1 bytea,_TTC_2 timestamp,_TTC_3RRef bytea,SDBL_IDENTITY serial4) WITHOUT OIDS
LOG: could not link file "pg_xlog/xlogtemp.383210" to "pg_xlog/0000000100000000000000A1" (initialization of log file 0
, segment 161): Operation not permitted
STATEMENT: create temporary table tt1 (_C_1RRef bytea,_C_2 bytea,_C_3 boolean,_C_4 timestamp,_C_5 numeric(9,0),_C_6 bo
olean,_C_7 mvarchar,_C_8RRef bytea,_C_9RRef bytea,_C_10RRef bytea,_C_11 timestamp,_C_12 timestamp,_C_13RRef bytea,_C_14
RRef bytea,_C_15 timestamp,_TTC_1 bytea,_TTC_2 timestamp,_TTC_3RRef bytea,SDBL_IDENTITY serial4) WITHOUT OIDS
PANIC: could not open file "pg_xlog/0000000100000000000000A1" (log file 0, segment 161): No such file or directory
STATEMENT: create temporary table tt1 (_C_1RRef bytea,_C_2 bytea,_C_3 boolean,_C_4 timestamp,_C_5 numeric(9,0),_C_6 bo
olean,_C_7 mvarchar,_C_8RRef bytea,_C_9RRef bytea,_C_10RRef bytea,_C_11 timestamp,_C_12 timestamp,_C_13RRef bytea,_C_14
RRef bytea,_C_15 timestamp,_TTC_1 bytea,_TTC_2 timestamp,_TTC_3RRef bytea,SDBL_IDENTITY serial4) WITHOUT OIDS
LOG: server process (PID 383210) was terminated by signal 6: Aborted
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because anothe
r server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted; last known up at 2015-05-23 17:14:36 EEST
LOG: database system was not properly shut down; automatic recovery in progress
LOG: consistent recovery state reached at 0/A0FD1208
LOG: redo starts at 0/A0FD1208
LOG: could not open file "pg_xlog/0000000100000000000000A1" (log file 0, segment 161): Нет такого файла или каталога
LOG: redo done at 0/A0FFEEA0
LOG: last completed transaction was at log time 2015-05-23 17:15:31.272288+03
LOG: could not link file "pg_xlog/xlogtemp.383212" to "pg_xlog/0000000100000000000000A1" (initialization of log file 0
, segment 161): Операция не позволена
FATAL: could not open file "pg_xlog/0000000100000000000000A1" (log file 0, segment 161): Нет такого файла или каталога
LOG: startup process (PID 383212) exited with exit code 1
LOG: aborting startup due to startup process failure
Вот конфиг
$ cat /usr/crypt/decrypted/data/postgresql.conf | grep -v "^#" | grep -v "^$"
listen_addresses = '*'
max_connections = 100
shared_buffers = 512MB
temp_buffers = 16MB
work_mem = 128MB
maintenance_work_mem = 512MB
effective_cache_size = 8GB
log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgre.log'
log_truncate_on_rotation = on
log_rotation_age = 1d
log_rotation_size = 0
log_min_error_statement = error
log_statement = 'ddl'
autovacuum = on
datestyle = 'iso, dmy'
lc_messages = 'ru_RU.UTF-8'
lc_monetary = 'ru_RU.UTF-8'
lc_numeric = 'ru_RU.UTF-8'
lc_time = 'ru_RU.UTF-8'
default_text_search_config = 'pg_catalog.russian'
max_locks_per_transaction = 150
Раньше вообще постоянно вылетало, но я поигрался с кол-вом памяти, стало на много лучше.
OS Debian 7 x64
postgres (PostgreSQL) 9.0.4-alt от Етерсофт
RAM 16Gb
Пользователей 15
P.S. Подскажите куда копать, может покажите свои конфиги.
Заранее, благодарен.
Вариант для распечатки
