|
|
|
Проблема с БД
|
|||
|---|---|---|---|
|
#18+
Добрый день Пользователи начали отключаться из 1с, в сообщении "Server closed the connection unexpectedly. This probably means the server terminated abnormally before or while processing the request", в cat /var/log/syslog: Apr 7 17:07:53 srv-251 kernel: [9418477.480335] Process postmaster (pid: 25984, threadinfo ffff8801d5d9a000, task ffff88005b545c00) Apr 7 17:07:53 srv-251 kernel: [9418477.480335] Apr 7 17:07:53 srv-251 kernel: [9418477.480335] Call Trace: Apr 7 17:07:53 srv-251 kernel: [9418417.256569] NMI backtrace for cpu 0 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] CPU 0 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] Modules linked in: vsock(O) acpiphp des_generic md4 nls_utf8 cifs ext2 ppdev vmw_balloon psmouse serio_raw parport_pc vmwgfx ttm drm vmci(O) shpchp i2c_piix4 mac_hid lp parport floppy vmxnet3 mptspi mptscsih mptbase Apr 7 17:07:53 srv-251 kernel: [9418417.256569] Apr 7 17:07:53 srv-251 kernel: [9418417.256569] Pid: 10016, comm: postmaster Tainted: G O 3.2.0-58-generic #88-Ubuntu VMware, Inc. VMware Virtual Platform/440BX Desktop Reference Platform Apr 7 17:07:53 srv-251 kernel: [9418417.256569] RIP: 0010:[<ffffffff8104cf1c>] [<ffffffff8104cf1c>] tg_load_down+0x4c/0x80 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] RSP: 0000:ffff88013b803cc0 EFLAGS: 00000012 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] RAX: 0000000000000001 RBX: ffffffff8104ced0 RCX: 0000000000000008 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] RDX: ffff88055ffb4000 RSI: 0000000000001001 RDI: ffff880136604400 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] RBP: ffff88013b803cc0 R08: ffff88081ccf5600 R09: 0000000000000001 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] R10: ffff88013b8537c0 R11: 00000000000003fc R12: ffffffff81e0fe00 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] R13: ffffffff8104cbc0 R14: ffff880136604400 R15: 0000000000000000 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] FS: 00007feb4e9ce700(0000) GS:ffff88013b800000(0000) knlGS:0000000000000000 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] CS: 0010 DS: 0000 ES: 0000 CR0: 0000000080050033 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] CR2: 00007feb4655e254 CR3: 000000021961a000 CR4: 00000000000406f0 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] DR0: 0000000000000000 DR1: 0000000000000000 DR2: 0000000000000000 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] DR3: 0000000000000000 DR6: 00000000ffff0ff0 DR7: 0000000000000400 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] Process postmaster (pid: 10016, threadinfo ffff8801ad6e2000, task ffff880017914500) Apr 7 17:07:53 srv-251 kernel: [9418417.256569] Stack: Apr 7 17:07:53 srv-251 kernel: [9418417.256569] ffff88013b803d20 ffffffff8104cb2c 0000000000000400 0000000000000001 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] 0000000000000000 ffff8801366044f0 000000000000100c 0000000000000000 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] ffff880138880c00 00000000000001ff ffff88013b8537c0 00000000000001ff Apr 7 17:07:53 srv-251 kernel: [9418417.256569] Call Trace: Apr 7 17:07:53 srv-251 kernel: [9418417.256569] <IRQ> Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8104cb2c>] walk_tg_tree_from+0x3c/0xd0 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8105f9d4>] load_balance_fair+0x54/0x1a0 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff81661d8e>] ? _raw_spin_lock+0xe/0x20 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8105fc53>] load_balance+0x133/0x390 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8105ff51>] rebalance_domains+0xa1/0x180 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff810601b8>] run_rebalance_domains+0x48/0x60 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8106fa08>] __do_softirq+0xa8/0x210 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8109d314>] ? tick_program_event+0x24/0x30 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8166c62c>] call_softirq+0x1c/0x30 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff810162f5>] do_softirq+0x65/0xa0 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8106fdee>] irq_exit+0x8e/0xb0 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8166cfde>] smp_apic_timer_interrupt+0x6e/0x99 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8166ae9e>] apic_timer_interrupt+0x6e/0x80 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] <EOI> Apr 7 17:07:53 srv-251 kernel: [9418417.256569] Code: 00 00 00 00 48 8b 14 f0 49 8b 34 f0 48 8b 82 b0 00 00 00 48 0f af 06 48 8b 32 31 d2 48 83 c6 01 48 f7 f6 48 8b 57 28 48 8b 14 0a <48> 89 82 b0 00 00 00 31 c0 5d c3 66 0f 1f 84 00 00 00 00 00 48 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] Call Trace: Apr 7 17:07:53 srv-251 kernel: [9418417.256569] <IRQ> [<ffffffff8104cb2c>] walk_tg_tree_from+0x3c/0xd0 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8105f9d4>] load_balance_fair+0x54/0x1a0 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff81661d8e>] ? _raw_spin_lock+0xe/0x20 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8105fc53>] load_balance+0x133/0x390 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8105ff51>] rebalance_domains+0xa1/0x180 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff810601b8>] run_rebalance_domains+0x48/0x60 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8106fa08>] __do_softirq+0xa8/0x210 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8109d314>] ? tick_program_event+0x24/0x30 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8166c62c>] call_softirq+0x1c/0x30 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff810162f5>] do_softirq+0x65/0xa0 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8106fdee>] irq_exit+0x8e/0xb0 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8166cfde>] smp_apic_timer_interrupt+0x6e/0x99 Apr 7 17:07:53 srv-251 kernel: [9418417.256569] [<ffffffff8166ae9e>] apic_timer_interrupt+0x6e/0x80 Apr 7 17:15:01 srv-251 CRON[20968]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1) Apr 7 17:17:01 srv-251 CRON[25388]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.04.2015, 12:07 |
|
||
|
Проблема с БД
|
|||
|---|---|---|---|
|
#18+
Gallemar, а лога самого постгреса? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.04.2015, 12:24 |
|
||
|
Проблема с БД
|
|||
|---|---|---|---|
|
#18+
tadmin, 2015-04-07 00:00:48 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:01:50 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:02:51 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:03:13 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt1" in database "Conv_Demo" 2015-04-07 00:03:13 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt2" in database "Conv_Demo" 2015-04-07 00:03:13 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt3" in database "Conv_Demo" 2015-04-07 00:03:13 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt4" in database "Conv_Demo" 2015-04-07 00:03:53 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:04:54 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:05:56 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:06:57 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:07:59 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:08:13 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt1" in database "Conv_Demo" 2015-04-07 00:08:13 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt2" in database "Conv_Demo" 2015-04-07 00:08:13 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt3" in database "Conv_Demo" 2015-04-07 00:08:13 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt4" in database "Conv_Demo" 2015-04-07 00:09:00 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:10:03 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:11:07 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:12:10 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:13:12 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:13:47 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt1" in database "Conv_Demo" 2015-04-07 00:13:47 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt2" in database "Conv_Demo" 2015-04-07 00:13:47 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt3" in database "Conv_Demo" 2015-04-07 00:13:47 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt4" in database "Conv_Demo" 2015-04-07 00:14:14 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:14:40 IRKT LOG: autovacuum: found orphan temp table "pg_temp_13"."tt1" in database "ZUP_Mayak_14_12_20" 2015-04-07 00:14:40 IRKT LOG: autovacuum: found orphan temp table "pg_temp_13"."tt2" in database "ZUP_Mayak_14_12_20" 2015-04-07 00:14:40 IRKT LOG: autovacuum: found orphan temp table "pg_temp_13"."tt3" in database "ZUP_Mayak_14_12_20" 2015-04-07 00:14:40 IRKT LOG: autovacuum: found orphan temp table "pg_temp_13"."tt4" in database "ZUP_Mayak_14_12_20" 2015-04-07 00:14:40 IRKT LOG: autovacuum: found orphan temp table "pg_temp_13"."tt5" in database "ZUP_Mayak_14_12_20" 2015-04-07 00:14:40 IRKT LOG: autovacuum: found orphan temp table "pg_temp_13"."tt6" in database "ZUP_Mayak_14_12_20" 2015-04-07 00:15:16 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:16:18 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:17:21 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:18:24 IRKT FATAL: database "Arenda_3" does not exist 2015-04-07 00:18:47 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt1" in database "Conv_Demo" 2015-04-07 00:18:47 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt2" in database "Conv_Demo" 2015-04-07 00:18:47 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt3" in database "Conv_Demo" 2015-04-07 00:18:47 IRKT LOG: autovacuum: found orphan temp table "pg_temp_109"."tt4" in database "Conv_Demo" 2015-04-07 00:19:28 IRKT FATAL: database "Arenda_3" does not exist ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.04.2015, 12:29 |
|
||
|
Проблема с БД
|
|||
|---|---|---|---|
|
#18+
tadmin, 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT tableoid, oid, opcname, opcnamespace, (SELECT rolname FROM pg_catalog.pg_rol$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT tableoid, oid, dictname, dictnamespace, (SELECT rolname FROM pg_catalog.pg_r$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT tableoid, oid, cfgname, cfgnamespace, (SELECT rolname FROM pg_catalog.pg_rol$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT tableoid, oid, fdwname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid =$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT tableoid, oid, srvname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid =$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT oid, tableoid, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = defaclro$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT tableoid, oid, opfname, opfnamespace, (SELECT rolname FROM pg_catalog.pg_rol$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT tableoid, oid, conname, connamespace, (SELECT rolname FROM pg_catalog.pg_rol$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT c.tableoid, c.oid, c.relname, c.relacl, c.relkind, c.relnamespace, (SELECT r$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT c.tableoid, c.oid, c.relname, c.relacl, c.relkind, c.relnamespace, (SELECT r$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT c.tableoid, c.oid, c.relname, c.relacl, c.relkind, c.relnamespace, (SELECT r$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT c.tableoid, c.oid, c.relname, c.relacl, c.relkind, c.relnamespace, (SELECT r$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT c.tableoid, c.oid, c.relname, c.relacl, c.relkind, c.relnamespace, (SELECT r$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT c.tableoid, c.oid, c.relname, c.relacl, c.relkind, c.relnamespace, (SELECT r$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT c.tableoid, c.oid, c.relname, c.relacl, c.relkind, c.relnamespace, (SELECT r$ 2015-04-07 01:15:01 IRKT LOG: Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0 2015-04-07 01:15:01 IRKT STATEMENT: SELECT c.tableoid, c.oid, c.relname, c.relacl, c.relkind, c.relnamespace, (SELECT r$ 2015-04-07 01:15:55 IRKT FATAL: database "Arenda_3" does not exist ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.04.2015, 12:30 |
|
||
|
Проблема с БД
|
|||
|---|---|---|---|
|
#18+
Gallemar, Судя по всему, аварийный рестарт постгреса привел к потере данных: потеряна(?) база данных Arenda_3, пропал тип данных mvarvarchar (создается специально для 1С, насколько помню). Использования виртуальных машин при некоторой небрежности очень этому способствует. Гасили виртуальную машину с работающим постгресом? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.04.2015, 12:39 |
|
||
|
Проблема с БД
|
|||
|---|---|---|---|
|
#18+
tadminGallemar, Гасили виртуальную машину с работающим постгресом? нет Код: plaintext 1. 2. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.04.2015, 12:47 |
|
||
|
Проблема с БД
|
|||
|---|---|---|---|
|
#18+
Лучше всего - pg_dump а потом pg_restore боевой базы. Это быстрее vacuum full, дает бекап и полную картину. Если проходит без ошибок, гарантированно все ОК. Но, судя по потерянному mvchar, ошибки будут. Вы их увидите. Чтобы подстраховаться, всех выгнать, остановить постгрес и сделать файловую копию pg_data (со всеми xlog и пр). Сейчас непонятно, какая из баз у вас боевая. Возможно, часть ошибок это уже ненужные удаленные базы, которые висят в оснастке 1С. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.04.2015, 12:54 |
|
||
|
Проблема с БД
|
|||
|---|---|---|---|
|
#18+
tadmin,понятно,спасибо ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.04.2015, 12:56 |
|
||
|
Проблема с БД
|
|||
|---|---|---|---|
|
#18+
Вот еще что, не могут быть у вас две версии pg установлены: оригинальная, и с патчами от 1С? mvchar - только в патченой версии pg существует. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.04.2015, 12:59 |
|
||
|
Проблема с БД
|
|||
|---|---|---|---|
|
#18+
tadminВот еще что, не могут быть у вас две версии pg установлены: оригинальная, и с патчами от 1С? mvchar - только в патченой версии pg существует. нет,у нас только с патчами от 1с,у нас собственно на этом сервере только базы 1с и крутятся ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.04.2015, 13:00 |
|
||
|
Проблема с БД
|
|||
|---|---|---|---|
|
#18+
Gallemar, do it: "parameter "log_line_prefix" change to "%t %d %u %r %p " и не забудьте RELOAD -- у вас кучка баз, в одной, скажем, всё нормуль, а в других по левому поставлены новые инстансы 1С без накатки типов. Т.е. надо понять , в какой базёнке и на что оно ругается. не всё создается просто 1С--патчем -- часть 1c-ddl инициируется при создании пустышки из оснастки 1С. Причем от версии к версии платформы эта часть (по крайней мере раньше, когда я в этом ковырялся) менялась. Т.е. периодически после смены версии 1С-бл@тьформы приходилсоь переноситься через файловый дамп от 1С. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.04.2015, 13:35 |
|
||
|
|

start [/forum/topic.php?fid=53&msg=38929121&tid=1998064]: |
0ms |
get settings: |
4ms |
get forum list: |
9ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
180ms |
get topic data: |
9ms |
get forum data: |
2ms |
get page messages: |
49ms |
get tp. blocked users: |
1ms |
| others: | 212ms |
| total: | 470ms |

| 0 / 0 |
