Re: BUG #14295: Hot standby crash during tsvector rebuild

Поиск
Список
Период
Сортировка
От Spencer Thomason
Тема Re: BUG #14295: Hot standby crash during tsvector rebuild
Дата
Msg-id 7E7B1C18-719C-4BF8-8A60-D8F0857EA03F@whiteskycommunications.com
обсуждение исходный текст
Ответ на Re: BUG #14295: Hot standby crash during tsvector rebuild  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #14295: Hot standby crash during tsvector rebuild
Список pgsql-bugs
Please see the attachments.

I have included the master and slave configs and python scripts that trigger this on our systems.  

The way to reproduce this are:
- create a new database 
- setup streaming replication to 2 or more slaves
- run the populate_db.py script
- if slaves do not crash, run the purge_db.py script followed by the populate_db.py script again.

I didn’t see failures immediately but within 15-20 mins of inserting records, the slaves crashed.

Also, I should note that this is on a SPARC T2 at 1.4GHz so the single thread performance might be a factor as well.
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: villan.lampard.epl@gmail.com
Дата:
Сообщение: BUG #14306: copy command from csv to table is missing the timestamp in
Следующее
От: neil@postgrescompare.com
Дата:
Сообщение: BUG #14307: SELECT from pg_timezone_abbrevs gives an ERROR: F0000