The OpenNET Project / Index page

[ новости /+++ | форум | теги | ]




Версия для распечатки Пред. тема | След. тема
Новые ответы [ Отслеживать ]
PostgreSQL вылетает (1С 8.3), !*! Dark Smoke, 24-Май-15, 14:33  [смотреть все]
Добрый день
Люди подскажите, пожалуйста.
Значит, когда я загружаю базу 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. Подскажите куда копать, может покажите свои конфиги.

Заранее, благодарен.

  • PostgreSQL вылетает (1С 8.3), !*! ruata, 22:14 , 24-Май-15 (1)
  • PostgreSQL вылетает (1С 8.3), !*! чукчанепоимаю, 03:42 , 25-Май-15 (2)
  • PostgreSQL вылетает (1С 8.3), !*! pavel_simple, 07:43 , 25-Май-15 (3)
    • PostgreSQL вылетает (1С 8.3), !*! Dark Smoke, 10:36 , 25-Май-15 (4)
      > df
      > mount

      df -h
      Filesystem      Size  Used Avail Use% Mounted on
      udev             10M     0   10M   0% /dev
      tmpfs           1.6G  452K  1.6G   1% /run
      /dev/md3        878G   22G  812G   3% /
      tmpfs           5.0M  4.0K  5.0M   1% /run/lock
      tmpfs           9.1G     0  9.1G   0% /run/shm
      /dev/md0        464M   49M  391M  11% /boot
      /dev/md2        9.1G   29M  8.6G   1% /tmp
      /dev/sda1        15G  2.3M   15G   1% /media/pass
      encfs           878G   22G  812G   3% /usr/crypt/decrypted


      mount
      sysfs on /sys type sysfs (rw,nosuid,nodev,noexec,relatime)
      proc on /proc type proc (rw,nosuid,nodev,noexec,relatime)
      udev on /dev type devtmpfs (rw,relatime,size=10240k,nr_inodes=2038275,mode=755)
      devpts on /dev/pts type devpts (rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000)
      tmpfs on /run type tmpfs (rw,nosuid,noexec,relatime,size=1632412k,mode=755)
      /dev/disk/by-uuid/e7965d83-b464-4f80-ae38-934f72e3a1ac on / type ext4 (rw,relatime,errors=remount-ro,barrier=1,data=ordered)
      tmpfs on /run/lock type tmpfs (rw,nosuid,nodev,noexec,relatime,size=5120k)
      tmpfs on /run/shm type tmpfs (rw,nosuid,nodev,noexec,relatime,size=9511380k)
      fusectl on /sys/fs/fuse/connections type fusectl (rw,relatime)
      /dev/md0 on /boot type ext4 (rw,relatime,barrier=1,data=ordered)
      /dev/md2 on /tmp type ext4 (rw,relatime,barrier=1,data=ordered)
      rpc_pipefs on /run/rpc_pipefs type rpc_pipefs (rw,relatime)
      beancounter on /proc/vz/beancounter type cgroup (rw,relatime,blkio,name=beancounter)
      container on /proc/vz/container type cgroup (rw,relatime,freezer,devices,name=container)
      fairsched on /proc/vz/fairsched type cgroup (rw,relatime,cpuacct,cpu,cpuset,name=fairsched)
      /dev/sda1 on /media/pass type vfat (rw,relatime,fmask=0022,dmask=0022,codepage=cp437,iocharset=ascii,shortname=mixed,errors=remount-ro)
      encfs on /usr/crypt/decrypted type fuse.encfs (rw,nosuid,nodev,relatime,user_id=0,group_id=0,default_permissions,allow_other)


      База лежит на /usr/crypt/decrypted, на ночь тушим постгрес и отмантируем раздел.

  • PostgreSQL вылетает (1С 8.3), !*! цц, 15:55 , 25-Май-15 (6)



Партнёры:
PostgresPro
Inferno Solutions
Hosting by Hoster.ru
Хостинг:

Закладки на сайте
Проследить за страницей
Created 1996-2024 by Maxim Chirkov
Добавить, Поддержать, Вебмастеру