|
|
|
Цэ баг чи ни?
|
|||
|---|---|---|---|
|
#18+
Обнаружил на одном из серверов такое 2015-08-14 15:54:37 MSK [19203]: [36-1] user=,db=,app=,client=LOG: archive command failed with exit code 1 2015-08-14 15:54:37 MSK [19203]: [37-1] user=,db=,app=,client=DETAIL: The failed archive command was: test ! -f /backups/db_backup_buf_developer/00000001000000C00000003E && cp pg_xlog/00000001000000C00000003E /backups/db_backup_buf_developer/00000001000000C00000003E 2015-08-14 15:54:38 MSK [19203]: [38-1] user=,db=,app=,client=LOG: archive command failed with exit code 1 2015-08-14 15:54:38 MSK [19203]: [39-1] user=,db=,app=,client=DETAIL: The failed archive command was: test ! -f /backups/db_backup_buf_developer/00000001000000C00000003E && cp pg_xlog/00000001000000C00000003E /backups/db_backup_buf_developer/00000001000000C00000003E 2015-08-14 15:54:39 MSK [19203]: [40-1] user=,db=,app=,client=LOG: archive command failed with exit code 1 2015-08-14 15:54:39 MSK [19203]: [41-1] user=,db=,app=,client=DETAIL: The failed archive command was: test ! -f /backups/db_backup_buf_developer/00000001000000C00000003E && cp pg_xlog/00000001000000C00000003E /backups/db_backup_buf_developer/00000001000000C00000003E 2015-08-14 15:54:39 MSK [19203]: [42-1] user=,db=,app=,client=WARNING: archiving transaction log file "00000001000000C00000003E" failed too many times, willtry again later 2015-08-14 15:55:07 MSK [19203]: [43-1] user=,db=,app=,client=LOG: archive command failed with exit code 1 2015-08-14 15:55:07 MSK [19203]: [44-1] user=,db=,app=,client=DETAIL: The failed archive command was: test ! -f /backups/db_backup_buf_developer/00000001000000C00000003E && cp pg_xlog/00000001000000C00000003E /backups/db_backup_buf_developer/00000001000000C00000003E 2015-08-14 15:55:08 MSK [19203]: [45-1] user=,db=,app=,client=LOG: archive command failed with exit code 1 2015-08-14 15:55:08 MSK [19203]: [46-1] user=,db=,app=,client=DETAIL: The failed archive command was: test ! -f /backups/db_backup_buf_developer/00000001000000C00000003E && cp pg_xlog/00000001000000C00000003E /backups/db_backup_buf_developer/00000001000000C00000003E 2015-08-14 15:55:09 MSK [19203]: [47-1] user=,db=,app=,client=LOG: archive command failed with exit code 1 2015-08-14 15:55:09 MSK [19203]: [48-1] user=,db=,app=,client=DETAIL: The failed archive command was: test ! -f /backups/db_backup_buf_developer/00000001000000C00000003E && cp pg_xlog/00000001000000C00000003E /backups/db_backup_buf_developer/00000001000000C00000003E 2015-08-14 15:55:09 MSK [19203]: [49-1] user=,db=,app=,client=WARNING: archiving transaction log file "00000001000000C00000003E" failed too many times, willtry again later 2015-08-14 15:55:38 MSK [19203]: [50-1] user=,db=,app=,client=LOG: archive command failed with exit code 1 2015-08-14 15:55:38 MSK [19203]: [51-1] user=,db=,app=,client=DETAIL: The failed archive command was: test ! -f /backups/db_backup_buf_developer/00000001000000C00000003E && cp pg_xlog/00000001000000C00000003E /backups/db_backup_buf_developer/00000001000000C00000003E 2015-08-14 15:55:39 MSK [19203]: [52-1] user=,db=,app=,client=LOG: archive command failed with exit code 1 2015-08-14 15:55:39 MSK [19203]: [53-1] user=,db=,app=,client=DETAIL: The failed archive command was: test ! -f /backups/db_backup_buf_developer/00000001000000C00000003E && cp pg_xlog/00000001000000C00000003E /backups/db_backup_buf_developer/00000001000000C00000003E 2015-08-14 15:55:40 MSK [19203]: [54-1] user=,db=,app=,client=LOG: archive command failed with exit code 1 2015-08-14 15:55:40 MSK [19203]: [55-1] user=,db=,app=,client=DETAIL: The failed archive command was: test ! -f /backups/db_backup_buf_developer/00000001000000C00000003E && cp pg_xlog/00000001000000C00000003E /backups/db_backup_buf_developer/00000001000000C00000003E 2015-08-14 15:55:40 MSK [19203]: [56-1] user=,db=,app=,client=WARNING: archiving transaction log file "00000001000000C00000003E" failed too many times, willtry again later PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit Убрал проблемный файл 00000001000000C00000003E из /backups/db_backup_buf_developer/ - всё исчезло. Со свободным местом проблем быть не может. Что это могло быть? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.08.2015, 17:16 |
|
||
|
Цэ баг чи ни?
|
|||
|---|---|---|---|
|
#18+
ОКТОГЕН, а где первое сообщение про этот файл, возможно в нём есть текст сообщения об ошибке? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.08.2015, 17:46 |
|
||
|
Цэ баг чи ни?
|
|||
|---|---|---|---|
|
#18+
ОКТОГЕН, 2 Шага: 1)archive command работает почти успешно но cp ломается на полпути отставив в /backups/db_backup_buf_developer/ полную или неполную версию файла... т.е. archive command вернула не 0 код но файл уже лежит 2)дальше она продолжает ломаться уже на этапе test ! -f Чтобы понять что именно произошло в момент 1) - надо смотреть логи может что то будет видно. Бага тут никакого нет, просто использованная archive command на такой сбой не рассчитана. -- Maxim Boguk www.postgresql-consulting.ru ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.08.2015, 17:48 |
|
||
|
Цэ баг чи ни?
|
|||
|---|---|---|---|
|
#18+
Нашёл странное место 2015-08-14 15:34:31 MSK [26508]: [20-1] user=,db=,app=,client=LOG: checkpointer process (PID 26517) was terminated by signal 9: Killed 2015-08-14 15:34:31 MSK [26508]: [21-1] user=,db=,app=,client=LOG: terminating any other active server processes 2015-08-14 15:34:31 MSK [15654]: [1-1] user=user1,db=db_test1,app=[unknown],client=192.168.1.153WARNING: terminating connection because of crash of another server process 2015-08-14 15:34:31 MSK [15654]: [2-1] user=michas,db=db_test1,app=[unknown],client=192.168.1.153DETAIL: 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. 2015-08-14 15:34:31 MSK [15654]: [3-1] user=michas,db=db_test1,app=[unknown],client=192.168.1.153HINT: In a moment you should be able to reconnect to the database and repeat your command. После него появляется ошибка, мол, сервер восстанавливается. 2015-08-14 15:34:32 MSK [15660]: [1-1] user=user1,db=db_test1,app=[unknown],client=192.168.1.10FATAL: the database system is in recovery mode 2015-08-14 15:34:32 MSK [15661]: [1-1] user=michas,db=db_test1,app=[unknown],client=192.168.1.154FATAL: the database system is in recovery mode 2015-08-14 15:34:32 MSK [15662]: [1-1] user=michas,db=db_test1,app=[unknown],client=192.168.1.154FATAL: the database system is in recovery mode Ещё раз 2015-08-14 15:34:36 MSK [26508]: [22-1] user=,db=,app=,client=LOG: archiver process (PID 26521) was terminated by signal 9: Killed 2015-08-14 15:34:36 MSK [26508]: [23-1] user=,db=,app=,client=LOG: all server processes terminated; reinitializing 2015-08-14 15:34:36 MSK [15676]: [1-1] user=user1,db=db_test1,app=[unknown],client=192.168.1.10FATAL: the database system is in recovery mode 2015-08-14 15:34:36 MSK [15669]: [1-1] user=michas,db=db_test1,app=[unknown],client=192.168.1.152FATAL: the database system is in recovery mode 2015-08-14 15:34:36 MSK [15672]: [1-1] user=user1,db=db_test1,app=[unknown],client=192.168.1.10FATAL: the database system is in recovery mode 2015-08-14 15:34:36 MSK [15677]: [1-1] user=michas,db=db_test1,app=[unknown],client=192.168.1.152FATAL: the database system is in recovery mode 2015-08-14 15:34:36 MSK [15668]: [1-1] user=michas,db=db_test1,app=[unknown],client=192.168.1.150FATAL: the database system is in recovery mode 2015-08-14 15:34:36 MSK [15667]: [1-1] user=,db=,app=,client=LOG: database system was interrupted; last known up at 2015-08-14 15:33:27 MSK 2015-08-14 15:34:37 MSK [15682]: [1-1] user=user1,db=db_test1,app=[unknown],client=192.168.1.10FATAL: the database system is in recovery mode 2015-08-14 15:34:37 MSK [15684]: [1-1] user=user1,db=db_test1,app=[unknown],client=192.168.1.10FATAL: the database system is in recovery mode 2015-08-14 15:34:37 MSK [15683]: [1-1] user=michas,db=db_test1,app=[unknown],client=192.168.1.152FATAL: the database system is in recovery mode 2015-08-14 15:34:37 MSK [15685]: [1-1] user=michas,db=db_test1,app=[unknown],client=192.168.1.150FATAL: the database system is in recovery mode Востановился, запустился - и сразу пошла ошибка как в заголовке. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.08.2015, 18:59 |
|
||
|
Цэ баг чи ни?
|
|||
|---|---|---|---|
|
#18+
Ещё нашёл фигню root@tester:~# cd /var/log/ root@tester:/var/log# cat kern.log Aug 10 08:00:39 tester kernel: [2908595.167794] type=1400 audit(1439182839.901:171): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/lib/cups/backend/cups-pdf" pid=8172 comm="apparmor_parser" Aug 10 08:00:39 tester kernel: [2908595.167807] type=1400 audit(1439182839.901:172): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/cupsd" pid=8172 comm="apparmor_parser" Aug 10 08:00:39 tester kernel: [2908595.168406] type=1400 audit(1439182839.905:173): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/cupsd" pid=8172 comm="apparmor_parser" Aug 11 07:53:14 tester kernel: [2994549.511798] type=1400 audit(1439268794.243:174): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/lib/cups/backend/cups-pdf" pid=27461 comm="apparmor_parser" Aug 11 07:53:14 tester kernel: [2994549.511811] type=1400 audit(1439268794.243:175): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/cupsd" pid=27461 comm="apparmor_parser" Aug 11 07:53:14 tester kernel: [2994549.512404] type=1400 audit(1439268794.247:176): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/cupsd" pid=27461 comm="apparmor_parser" Aug 12 08:05:25 tester kernel: [3081680.353670] type=1400 audit(1439355925.089:177): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/lib/cups/backend/cups-pdf" pid=29438 comm="apparmor_parser" Aug 12 08:05:25 tester kernel: [3081680.353682] type=1400 audit(1439355925.089:178): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/cupsd" pid=29438 comm="apparmor_parser" Aug 12 08:05:25 tester kernel: [3081680.354249] type=1400 audit(1439355925.089:179): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/cupsd" pid=29438 comm="apparmor_parser" Aug 13 07:45:54 tester kernel: [3166909.366348] type=1400 audit(1439441154.100:180): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/lib/cups/backend/cups-pdf" pid=32085 comm="apparmor_parser" Aug 13 07:45:54 tester kernel: [3166909.366364] type=1400 audit(1439441154.100:181): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/cupsd" pid=32085 comm="apparmor_parser" Aug 13 07:45:54 tester kernel: [3166909.366968] type=1400 audit(1439441154.100:182): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/cupsd" pid=32085 comm="apparmor_parser" Aug 14 07:41:16 tester kernel: [3253032.221245] type=1400 audit(1439527276.954:183): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/lib/cups/backend/cups-pdf" pid=15721 comm="apparmor_parser" Aug 14 07:41:16 tester kernel: [3253032.221257] type=1400 audit(1439527276.954:184): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/cupsd" pid=15721 comm="apparmor_parser" Aug 14 07:41:16 tester kernel: [3253032.221823] type=1400 audit(1439527276.954:185): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/cupsd" pid=15721 comm="apparmor_parser" Aug 14 15:34:31 tester kernel: [3281426.013337] postgres invoked oom-killer: gfp_mask=0x280da, order=0, oom_score_adj=0 Aug 14 15:34:31 tester kernel: [3281426.013343] postgres cpuset=/ mems_allowed=0 Aug 14 15:34:31 tester kernel: [3281426.013348] CPU: 1 PID: 15653 Comm: postgres Not tainted 3.13.0-24-generic #46-Ubuntu Aug 14 15:34:31 tester kernel: [3281426.013350] Hardware name: System manufacturer System Product Name/P5LD2-VM SE, BIOS 0401 07/07/2006 Aug 14 15:34:31 tester kernel: [3281426.013353] 0000000000000000 ffff880008b73a98 ffffffff81715a64 ffff8800679a17f0 Aug 14 15:34:31 tester kernel: [3281426.013358] ffff880008b73b20 ffffffff8171039f 0000000000000000 0000000000000000 Aug 14 15:34:31 tester kernel: [3281426.013363] 0000000000000000 0000000000000000 0000000000000000 0000000000000000 Aug 14 15:34:31 tester kernel: [3281426.013367] Call Trace: Aug 14 15:34:31 tester kernel: [3281426.013378] [<ffffffff81715a64>] dump_stack+0x45/0x56 Aug 14 15:34:31 tester kernel: [3281426.013383] [<ffffffff8171039f>] dump_header+0x7f/0x1f1 Aug 14 15:34:31 tester kernel: [3281426.013388] [<ffffffff8115197e>] oom_kill_process+0x1ce/0x330 Aug 14 15:34:31 tester kernel: [3281426.013393] [<ffffffff812d0135>] ? security_capable_noaudit+0x15/0x20 Aug 14 15:34:31 tester kernel: [3281426.013397] [<ffffffff811520b4>] out_of_memory+0x414/0x450 Aug 14 15:34:31 tester kernel: [3281426.013402] [<ffffffff81158223>] __alloc_pages_nodemask+0x983/0xa20 Aug 14 15:34:31 tester kernel: [3281426.013407] [<ffffffff811976ba>] alloc_pages_vma+0x9a/0x140 Aug 14 15:34:31 tester kernel: [3281426.013411] [<ffffffff81178d1b>] handle_mm_fault+0xb2b/0xf10 Aug 14 15:34:31 tester kernel: [3281426.013416] [<ffffffff8118a9a5>] ? free_pages_and_swap_cache+0x95/0xb0 Aug 14 15:34:31 tester kernel: [3281426.013420] [<ffffffff817219a4>] __do_page_fault+0x184/0x560 Aug 14 15:34:31 tester kernel: [3281426.013425] [<ffffffff8101b7d9>] ? sched_clock+0x9/0x10 Aug 14 15:34:31 tester kernel: [3281426.013430] [<ffffffff8109d13d>] ? sched_clock_local+0x1d/0x80 Aug 14 15:34:31 tester kernel: [3281426.013435] [<ffffffff811112fc>] ? acct_account_cputime+0x1c/0x20 Aug 14 15:34:31 tester kernel: [3281426.013438] [<ffffffff8109d76b>] ? account_user_time+0x8b/0xa0 Aug 14 15:34:31 tester kernel: [3281426.013442] [<ffffffff8109dd84>] ? vtime_account_user+0x54/0x60 Aug 14 15:34:31 tester kernel: [3281426.013445] [<ffffffff81721d9a>] do_page_fault+0x1a/0x70 Aug 14 15:34:31 tester kernel: [3281426.013450] [<ffffffff8171e208>] page_fault+0x28/0x30 Aug 14 15:34:31 tester kernel: [3281426.013452] Mem-Info: Aug 14 15:34:31 tester kernel: [3281426.013455] Node 0 DMA per-cpu: Aug 14 15:34:31 tester kernel: [3281426.013458] CPU 0: hi: 0, btch: 1 usd: 0 Aug 14 15:34:31 tester kernel: [3281426.013461] CPU 1: hi: 0, btch: 1 usd: 0 Aug 14 15:34:31 tester kernel: [3281426.013463] Node 0 DMA32 per-cpu: Aug 14 15:34:31 tester kernel: [3281426.013466] CPU 0: hi: 186, btch: 31 usd: 0 Aug 14 15:34:31 tester kernel: [3281426.013468] CPU 1: hi: 186, btch: 31 usd: 0 Aug 14 15:34:31 tester kernel: [3281426.013474] active_anon:407906 inactive_anon:52910 isolated_anon:0 Aug 14 15:34:31 tester kernel: [3281426.013474] active_file:1714 inactive_file:1835 isolated_file:0 Aug 14 15:34:31 tester kernel: [3281426.013474] unevictable:8 dirty:18 writeback:1785 unstable:0 Aug 14 15:34:31 tester kernel: [3281426.013474] free:13232 slab_reclaimable:6147 slab_unreclaimable:6711 Aug 14 15:34:31 tester kernel: [3281426.013474] mapped:200757 shmem:255710 pagetables:11114 bounce:0 Aug 14 15:34:31 tester kernel: [3281426.013474] free_cma:0 Aug 14 15:34:31 tester kernel: [3281426.013480] Node 0 DMA free:8248kB min:348kB low:432kB high:520kB active_anon:6368kB inactive_anon:448kB active_file:28kB inactive_file:4kB unevictable:0kB isolated(anon):0kB isolated(file):0kB present:15992kB managed:15908kB mlocked:0kB dirty:0kB writeback:32kB mapped:1732kB shmem:2256kB slab_reclaimable:80kB slab_unreclaimable:124kB kernel_stack:40kB pagetables:284kB unstable:0kB bounce:0kB free_cma:0kB writeback_tmp:0kB pages_scanned:59 all_unreclaimable? yes Aug 14 15:34:31 tester kernel: [3281426.013487] lowmem_reserve[]: 0 1975 1975 1975 Aug 14 15:34:31 tester kernel: [3281426.013492] Node 0 DMA32 free:44680kB min:44704kB low:55880kB high:67056kB active_anon:1625256kB inactive_anon:211192kB active_file:6828kB inactive_file:7336kB unevictable:32kB isolated(anon):0kB isolated(file):0kB present:2072192kB managed:2025336kB mlocked:32kB dirty:72kB writeback:7108kB mapped:801296kB shmem:1020584kB slab_reclaimable:24508kB slab_unreclaimable:26720kB kernel_stack:3912kB pagetables:44172kB unstable:0kB bounce:0kB free_cma:0kB writeback_tmp:0kB pages_scanned:22177 all_unreclaimable? yes Aug 14 15:34:31 tester kernel: [3281426.013499] lowmem_reserve[]: 0 0 0 0 Aug 14 15:34:31 tester kernel: [3281426.013504] Node 0 DMA: 30*4kB (EM) 16*8kB (EM) 8*16kB (EM) 9*32kB (UEM) 3*64kB (EM) 4*128kB (UE) 1*256kB (E) 3*512kB (UEM) 1*1024kB (M) 2*2048kB (MR) 0*4096kB = 8280kB Aug 14 15:34:31 tester kernel: [3281426.013526] Node 0 DMA32: 770*4kB (UEM) 409*8kB (UEM) 558*16kB (UEM) 368*32kB (UEM) 192*64kB (UEM) 42*128kB (UEM) 0*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 44720kB Aug 14 15:34:31 tester kernel: [3281426.013544] Node 0 hugepages_total=0 hugepages_free=0 hugepages_surp=0 hugepages_size=2048kB Aug 14 15:34:31 tester kernel: [3281426.013547] 259259 total pagecache pages Aug 14 15:34:31 tester kernel: [3281426.013549] 0 pages in swap cache Aug 14 15:34:31 tester kernel: [3281426.013552] Swap cache stats: add 0, delete 0, find 0/0 Aug 14 15:34:31 tester kernel: [3281426.013554] Free swap = 0kB Aug 14 15:34:31 tester kernel: [3281426.013555] Total swap = 0kB Aug 14 15:34:31 tester kernel: [3281426.013557] 522046 pages RAM Aug 14 15:34:31 tester kernel: [3281426.013559] 0 pages HighMem/MovableOnly Aug 14 15:34:31 tester kernel: [3281426.013561] 11714 pages reserved Aug 14 15:34:31 tester kernel: [3281426.013562] [ pid ] uid tgid total_vm rss nr_ptes swapents oom_score_adj name Aug 14 15:34:31 tester kernel: [3281426.013572] [ 184] 0 184 7960 211 18 0 0 mountall Aug 14 15:34:31 tester kernel: [3281426.013576] [ 281] 0 281 4868 68 13 0 0 upstart-udev-br Aug 14 15:34:31 tester kernel: [3281426.013580] [ 287] 0 287 12927 302 28 0 -1000 systemd-udevd Aug 14 15:34:31 tester kernel: [3281426.013584] [ 502] 0 502 3815 81 12 0 0 upstart-socket- Aug 14 15:34:31 tester kernel: [3281426.013589] [ 762] 102 762 10190 507 23 0 0 dbus-daemon Aug 14 15:34:31 tester kernel: [3281426.013592] [ 810] 0 810 82558 328 62 0 0 ModemManager Aug 14 15:34:31 tester kernel: [3281426.013596] [ 811] 0 811 4823 123 14 0 0 bluetoothd Aug 14 15:34:31 tester kernel: [3281426.013600] [ 848] 0 848 10890 181 26 0 0 systemd-logind Aug 14 15:34:31 tester kernel: [3281426.013604] [ 850] 101 850 66099 2538 35 0 0 rsyslogd Aug 14 15:34:31 tester kernel: [3281426.013607] [ 885] 0 885 3819 79 11 0 0 upstart-file-br Aug 14 15:34:31 tester kernel: [3281426.013611] [ 911] 107 911 8116 219 21 0 0 avahi-daemon Aug 14 15:34:31 tester kernel: [3281426.013614] [ 916] 107 916 8056 76 20 0 0 avahi-daemon Aug 14 15:34:31 tester kernel: [3281426.013618] [ 939] 0 939 86695 985 65 0 0 NetworkManager Aug 14 15:34:31 tester kernel: [3281426.013621] [ 945] 0 945 70358 670 38 0 0 polkitd Aug 14 15:34:31 tester kernel: [3281426.013625] [ 1000] 0 1000 4629 104 13 0 0 getty Aug 14 15:34:31 tester kernel: [3281426.013628] [ 1004] 0 1004 4629 107 13 0 0 getty Aug 14 15:34:31 tester kernel: [3281426.013632] [ 1012] 0 1012 4629 108 13 0 0 getty Aug 14 15:34:31 tester kernel: [3281426.013635] [ 1013] 0 1013 4629 107 13 0 0 getty Aug 14 15:34:31 tester kernel: [3281426.013639] [ 1016] 0 1016 4629 108 13 0 0 getty Aug 14 15:34:31 tester kernel: [3281426.013642] [ 1061] 0 1061 15341 239 34 0 -1000 sshd Aug 14 15:34:31 tester kernel: [3281426.013646] [ 1083] 0 1083 1092 96 8 0 0 acpid Aug 14 15:34:31 tester kernel: [3281426.013649] [ 1099] 0 1099 4785 63 13 0 0 atd Aug 14 15:34:31 tester kernel: [3281426.013653] [ 1103] 0 1103 87902 795 40 0 0 lightdm Aug 14 15:34:31 tester kernel: [3281426.013656] [ 1115] 0 1115 18838 284 40 0 0 cups-browsed Aug 14 15:34:31 tester kernel: [3281426.013660] [ 1122] 121 1122 27697 844 26 0 0 apt-cacher-ng Aug 14 15:34:31 tester kernel: [3281426.013664] [ 1143] 0 1143 81914 3777 103 0 0 Xorg Aug 14 15:34:31 tester kernel: [3281426.013667] [ 1146] 0 1146 71887 347 43 0 0 accounts-daemon Aug 14 15:34:31 tester kernel: [3281426.013671] [ 1165] 105 1165 92373 432 76 0 0 whoopsie Aug 14 15:34:31 tester kernel: [3281426.013675] [ 1312] 0 1312 43652 292 54 0 0 lightdm Aug 14 15:34:31 tester kernel: [3281426.013678] [ 1367] 0 1367 59841 280 46 0 0 upowerd Aug 14 15:34:31 tester kernel: [3281426.013682] [ 1399] 111 1399 42229 127 19 0 0 rtkit-daemon Aug 14 15:34:31 tester kernel: [3281426.013685] [ 1665] 1000 1665 55544 716 38 0 0 gnome-keyring-d Aug 14 15:34:31 tester kernel: [3281426.013689] [ 1668] 1000 1668 9987 561 24 0 0 init Aug 14 15:34:31 tester kernel: [3281426.013692] [ 1979] 120 1979 13553 162 28 0 0 exim4 Aug 14 15:34:31 tester kernel: [3281426.013696] [ 1993] 109 1993 9286 137 22 0 0 kerneloops Aug 14 15:34:31 tester kernel: [3281426.013699] [ 2348] 0 2348 4629 104 13 0 0 getty Aug 14 15:34:31 tester kernel: [3281426.013703] [ 2388] 1000 2388 2654 79 7 0 0 ssh-agent Aug 14 15:34:31 tester kernel: [3281426.013707] [ 2394] 1000 2394 10291 462 25 0 0 dbus-daemon Aug 14 15:34:31 tester kernel: [3281426.013710] [ 2402] 1000 2402 5209 114 14 0 0 upstart-event-b Aug 14 15:34:31 tester kernel: [3281426.013714] [ 2409] 1000 2409 19207 215 29 0 0 window-stack-br Aug 14 15:34:31 tester kernel: [3281426.013718] [ 2433] 1000 2433 7377 81 18 0 0 upstart-file-br Aug 14 15:34:31 tester kernel: [3281426.013721] [ 2434] 1000 2434 5211 60 12 0 0 upstart-dbus-br Aug 14 15:34:31 tester kernel: [3281426.013725] [ 2436] 1000 2436 5211 62 13 0 0 upstart-dbus-br Aug 14 15:34:31 tester kernel: [3281426.013728] [ 2438] 1000 2438 90103 356 43 0 0 ibus-daemon Aug 14 15:34:31 tester kernel: [3281426.013732] [ 2452] 1000 2452 203528 2000 168 0 0 unity-settings- Aug 14 15:34:31 tester kernel: [3281426.013736] [ 2460] 1000 2460 48840 249 30 0 0 gvfsd Aug 14 15:34:31 tester kernel: [3281426.013739] [ 2461] 1000 2461 168985 1491 149 0 0 hud-service Aug 14 15:34:31 tester kernel: [3281426.013743] [ 2462] 1000 2462 84395 179 30 0 0 at-spi-bus-laun Aug 14 15:34:31 tester kernel: [3281426.013746] [ 2466] 1000 2466 86415 708 38 0 0 gvfsd-fuse Aug 14 15:34:31 tester kernel: [3281426.013750] [ 2470] 1000 2470 143938 931 113 0 0 gnome-session Aug 14 15:34:31 tester kernel: [3281426.013754] [ 2473] 1000 2473 9840 220 25 0 0 dbus-daemon Aug 14 15:34:31 tester kernel: [3281426.013757] [ 2485] 1000 2485 125011 3746 118 0 0 unity-panel-ser Aug 14 15:34:31 tester kernel: [3281426.013761] [ 2487] 1000 2487 69928 758 37 0 0 ibus-dconf Aug 14 15:34:31 tester kernel: [3281426.013764] [ 2488] 1000 2488 119802 1243 107 0 0 ibus-ui-gtk3 Aug 14 15:34:31 tester kernel: [3281426.013768] [ 2490] 1000 2490 96488 1019 88 0 0 ibus-x11 Aug 14 15:34:31 tester kernel: [3281426.013772] [ 2498] 1000 2498 31228 189 30 0 0 at-spi2-registr Aug 14 15:34:31 tester kernel: [3281426.013775] [ 2527] 1000 2527 50998 208 34 0 0 ibus-engine-sim Aug 14 15:34:31 tester kernel: [3281426.013779] [ 2538] 1000 2538 138031 1830 113 0 0 bamfdaemon Aug 14 15:34:31 tester kernel: [3281426.013783] [ 2546] 1000 2546 165134 1326 122 0 0 indicator-keybo Aug 14 15:34:31 tester kernel: [3281426.013786] [ 2548] 1000 2548 83482 174 30 0 0 indicator-messa Aug 14 15:34:31 tester kernel: [3281426.013790] [ 2554] 1000 2554 65619 226 29 0 0 indicator-bluet Aug 14 15:34:31 tester kernel: [3281426.013794] [ 2555] 1000 2555 69319 263 36 0 0 indicator-power Aug 14 15:34:31 tester kernel: [3281426.013797] [ 2558] 1000 2558 290453 1276 108 0 0 indicator-datet Aug 14 15:34:31 tester kernel: [3281426.013801] [ 2561] 1000 2561 119560 450 68 0 0 indicator-sound Aug 14 15:34:31 tester kernel: [3281426.013804] [ 2562] 1000 2562 111489 1533 116 0 0 indicator-print Aug 14 15:34:31 tester kernel: [3281426.013808] [ 2570] 1000 2570 223141 887 52 0 0 indicator-sessi Aug 14 15:34:31 tester kernel: [3281426.013812] [ 2592] 1000 2592 93641 603 85 0 0 pulseaudio Aug 14 15:34:31 tester kernel: [3281426.013815] [ 2619] 1000 2619 273582 1344 145 0 0 evolution-sourc Aug 14 15:34:31 tester kernel: [3281426.013819] [ 2625] 1000 2625 73736 344 72 0 0 indicator-appli Aug 14 15:34:31 tester kernel: [3281426.013822] [ 2644] 103 2644 75373 443 49 0 0 colord Aug 14 15:34:31 tester kernel: [3281426.013826] [ 2651] 1000 2651 24598 256 49 0 0 gconf-helper Aug 14 15:34:31 tester kernel: [3281426.013830] [ 2653] 1000 2653 14302 511 30 0 0 gconfd-2 Aug 14 15:34:31 tester kernel: [3281426.013833] [ 2661] 1000 2661 84907 804 97 0 0 notify-osd Aug 14 15:34:31 tester kernel: [3281426.013837] [ 2667] 1000 2667 356506 33496 327 0 0 compiz Aug 14 15:34:31 tester kernel: [3281426.013840] [ 2676] 1000 2676 44544 173 23 0 0 dconf-service Aug 14 15:34:31 tester kernel: [3281426.013844] [ 2766] 1000 2766 277606 4806 207 0 0 nautilus Aug 14 15:34:31 tester kernel: [3281426.013848] [ 2767] 1000 2767 137573 1295 99 0 0 unity-fallback- Aug 14 15:34:31 tester kernel: [3281426.013852] [ 2771] 1000 2771 82738 756 97 0 0 polkit-gnome-au Aug 14 15:34:31 tester kernel: [3281426.013855] [ 2772] 1000 2772 114648 1139 124 0 0 nm-applet Aug 14 15:34:31 tester kernel: [3281426.013859] [ 2787] 1000 2787 93384 1255 48 0 0 gvfs-udisks2-vo Aug 14 15:34:31 tester kernel: [3281426.013862] [ 2796] 1000 2796 218995 9155 152 0 0 evolution-calen Aug 14 15:34:31 tester kernel: [3281426.013866] [ 2799] 0 2799 109289 839 47 0 0 udisksd Aug 14 15:34:31 tester kernel: [3281426.013870] [ 2813] 1000 2813 52782 261 37 0 0 gvfs-gphoto2-vo Aug 14 15:34:31 tester kernel: [3281426.013873] [ 2819] 1000 2819 49741 203 31 0 0 gvfs-mtp-volume Aug 14 15:34:31 tester kernel: [3281426.013877] [ 2823] 1000 2823 71170 223 38 0 0 gvfs-afc-volume Aug 14 15:34:31 tester kernel: [3281426.013881] [ 2867] 1000 2867 89578 815 41 0 0 gvfsd-trash Aug 14 15:34:31 tester kernel: [3281426.013884] [ 2892] 1000 2892 67274 181 32 0 0 gvfsd-burn Aug 14 15:34:31 tester kernel: [3281426.013888] [ 2909] 1000 2909 113586 919 107 0 0 telepathy-indic Aug 14 15:34:31 tester kernel: [3281426.013891] [ 2917] 1000 2917 80615 428 57 0 0 mission-control Aug 14 15:34:31 tester kernel: [3281426.013895] [ 2931] 1000 2931 116833 420 86 0 0 zeitgeist-datah Aug 14 15:34:31 tester kernel: [3281426.013899] [ 2936] 1000 2936 82819 245 31 0 0 zeitgeist-daemo Aug 14 15:34:31 tester kernel: [3281426.013902] [ 2942] 1000 2942 58298 850 36 0 0 zeitgeist-fts Aug 14 15:34:31 tester kernel: [3281426.013906] [ 2955] 1000 2955 2478 20 10 0 0 cat Aug 14 15:34:31 tester kernel: [3281426.013909] [ 2997] 1000 2997 124338 1042 110 0 0 update-notifier Aug 14 15:34:31 tester kernel: [3281426.013913] [ 3022] 1000 3022 94189 773 50 0 0 deja-dup-monito Aug 14 15:34:31 tester kernel: [3281426.013916] [ 3055] 1000 3055 143273 1303 114 0 0 unity-panel-ser Aug 14 15:34:31 tester kernel: [3281426.013920] [ 3593] 0 3593 262962 345 46 0 0 console-kit-dae Aug 14 15:34:31 tester kernel: [3281426.013923] [ 2341] 0 2341 22078 931 46 0 0 /usr/sbin/apach Aug 14 15:34:31 tester kernel: [3281426.013927] [20949] 125 20949 8377 249 21 0 0 ntpd Aug 14 15:34:31 tester kernel: [3281426.013930] [30676] 0 30676 5914 117 18 0 0 cron Aug 14 15:34:31 tester kernel: [3281426.013934] [ 3424] 1000 3424 150438 6846 154 0 0 update-manager Aug 14 15:34:31 tester kernel: [3281426.013938] [ 7372] 1000 7372 149158 1452 130 0 0 deja-dup Aug 14 15:34:31 tester kernel: [3281426.013941] [ 2726] 1001 2726 22078 814 45 0 0 /usr/sbin/apach Aug 14 15:34:31 tester kernel: [3281426.013945] [ 2733] 1001 2733 323928 1932 90 0 0 /usr/sbin/apach Aug 14 15:34:31 tester kernel: [3281426.013948] [ 2812] 1001 2812 324048 2102 90 0 0 /usr/sbin/apach Aug 14 15:34:31 tester kernel: [3281426.013952] [26508] 117 26508 225476 10159 74 0 -900 postgres Aug 14 15:34:31 tester kernel: [3281426.013955] [26509] 117 26509 25984 969 51 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.013959] [26517] 117 26517 225675 190653 437 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.013962] [26518] 117 26518 225569 67874 368 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.013966] [26519] 117 26519 225569 4615 61 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.013969] [26520] 117 26520 225677 765 58 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.013973] [26521] 117 26521 25728 481 50 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.013976] [26522] 117 26522 26376 903 50 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.013979] [26526] 117 26526 232227 12289 104 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.013983] [26527] 117 26527 233274 16448 138 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.013986] [26528] 117 26528 229933 4666 81 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.013990] [26529] 117 26529 231189 7252 120 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.013993] [26534] 117 26534 228879 2206 67 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.013997] [27328] 117 27328 232145 12196 220 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014000] [27336] 117 27336 228875 1949 67 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014003] [27337] 117 27337 228402 2680 78 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014006] [27507] 117 27507 228452 2743 79 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014010] [ 1927] 117 1927 228416 1832 69 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014013] [ 3562] 117 3562 232426 9124 104 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014017] [ 3575] 117 3575 228359 1956 66 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014020] [ 3576] 117 3576 229752 3646 84 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014023] [15722] 0 15722 19248 373 42 0 0 cupsd Aug 14 15:34:31 tester kernel: [3281426.014027] [15725] 7 15725 15789 219 34 0 0 dbus Aug 14 15:34:31 tester kernel: [3281426.014030] [17245] 117 17245 232545 11557 157 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014034] [17269] 117 17269 228447 8102 105 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014037] [18426] 117 18426 235588 20454 215 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014041] [31315] 117 31315 233685 12878 145 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014044] [ 4362] 117 4362 230107 5724 108 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014047] [ 7664] 117 7664 228435 3803 92 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014051] [20032] 117 20032 228447 3314 96 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014054] [ 6052] 117 6052 228447 3523 92 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014057] [31376] 0 31376 27995 388 59 0 0 sshd Aug 14 15:34:31 tester kernel: [3281426.014060] [ 1044] 1000 1044 27995 324 56 0 0 sshd Aug 14 15:34:31 tester kernel: [3281426.014064] [ 1045] 1000 1045 6364 598 17 0 0 bash Aug 14 15:34:31 tester kernel: [3281426.014067] [ 1320] 0 1320 20641 265 44 0 0 sudo Aug 14 15:34:31 tester kernel: [3281426.014070] [ 1431] 0 1431 6359 616 17 0 0 bash Aug 14 15:34:31 tester kernel: [3281426.014073] [ 8729] 0 8729 11445 514 27 0 0 mc Aug 14 15:34:31 tester kernel: [3281426.014077] [ 8753] 0 8753 6368 625 17 0 0 bash Aug 14 15:34:31 tester kernel: [3281426.014080] [11357] 117 11357 227413 5973 91 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014084] [14862] 117 14862 279106 143469 427 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014087] [15635] 117 15635 1111 122 7 0 0 sh Aug 14 15:34:31 tester kernel: [3281426.014091] [15638] 117 15638 3788 109 13 0 0 cp Aug 14 15:34:31 tester kernel: [3281426.014094] [15639] 117 15639 227353 2979 71 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014097] [15643] 117 15643 227353 2991 71 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014101] [15644] 117 15644 227352 2996 71 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014104] [15645] 117 15645 227352 2993 71 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014107] [15646] 117 15646 227353 2993 71 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014111] [15647] 117 15647 227352 2996 71 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014114] [15648] 117 15648 225931 2205 59 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014118] [15649] 117 15649 227352 2997 71 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014121] [15650] 117 15650 227352 3001 71 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014124] [15651] 117 15651 225931 2204 59 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014128] [15652] 117 15652 225931 2208 59 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014131] [15653] 117 15653 225640 805 54 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014134] [15654] 117 15654 225604 769 52 0 0 postgres Aug 14 15:34:31 tester kernel: [3281426.014137] Out of memory: Kill process 26517 (postgres) score 374 or sacrifice child Aug 14 15:34:31 tester kernel: [3281426.014141] Killed process 26517 (postgres) total-vm:902700kB, anon-rss:2240kB, file-rss:760372kB root@tester:/var/log# битая память? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.08.2015, 19:04 |
|
||
|
Цэ баг чи ни?
|
|||
|---|---|---|---|
|
#18+
ОКТОГЕН, Почему битая то? Почитайте про postgresql + linux + oom killer. Система решила что закончилась память и пристрелила базу. -- Maxim Boguk www.postgresql-consulting.ru ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 15.08.2015, 04:22 |
|
||
|
|

start [/forum/topic.php?fid=53&fpage=106&tid=1997825]: |
0ms |
get settings: |
6ms |
get forum list: |
16ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
105ms |
get topic data: |
13ms |
get forum data: |
4ms |
get page messages: |
52ms |
get tp. blocked users: |
2ms |
| others: | 221ms |
| total: | 425ms |

| 0 / 0 |
