From: | neos(at)olansoft(dot)com |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Too long startup time after each crash. |
Date: | 2016-12-22 00:16:59 |
Message-ID: | 374041482365819@web39j.yandex.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
22.12.2016, 04:21, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>:
> On 12/21/2016 02:17 PM, neos(at)olansoft(dot)com wrote:
>> Hi.
>>
>> Perhaps i've sent it to wrong mail-list previously.
>>
>> After the upgrade postgresql had a strange behavior. After the crash, server launch now take a long time, up to 30-40 minutes sometimes. When connecting to the server (as well as in the log), the message - "the database system is starting up". Startup process consumes 0.4 - 1% CPU.
>
> What upgrade and how was it done?
By standard distro method (emerge in my case), and then pg_upgrade utility (according to pg docs). Upgrade was from 9.4 to 9.5, and now 9.5.3 to 9.6.1.
>
> What crash and what caused it?
>
> In particular why are you seeing multiple crashes?
Sorry, I did not specify a crash, i mean technical failure on the server - power failure or sometimes CPU overheating ("home" server problem).
>
> What is the log just before the crash?
Nothing, as expected, since it's not postgresql crash.
>
> What is the log after the the "database system is starting up" part?
First - "the database system was interrupted; last known up at..."
then many times "database system is starting up" (one per connection attempt)
and after 5-40 min i get - database system was not properly shut down; automatic recovery in progress...redo starts from...ready to accept connections, and, finally, everything is going well.
(my logs in ru_RU locale, so do not place them here)
>
>> Tried different version 9.5.[2,3,4], 9.6.1 (9.4 works fine). On the Internet this problem is not met, perhaps the problem lies in a combination of different factors (configuration database, Linux kernel), may be my config is wrong?
>
> Do you mean you searched for this problem description and could not find it?
Yes, it is, my fault, Google translator is not always saving me from mistakes.
>
>> Technical details:
>>
>> Gentoo Linux 4.4.2-hardened
>> current pg version 9.6.1
>>
>> ## pg config:
>>
>> listen_addresses = '*'
>> port = 5432
>> max_connections = 500
>> shared_buffers = 2048MB
>> temp_buffers = 16MB
>> work_mem = 64MB
>> maintenance_work_mem = 512MB
>> max_stack_depth = 4MB
>> dynamic_shared_memory_type = posix
>> wal_level = replica
>> wal_buffers = 8MB
>> checkpoint_completion_target = 0.85
>> archive_mode = on
>> archive_command = 'gzip < %p > /home/pgbasebackup/xlogs/%f.gz'
>> max_wal_senders = 3
>> effective_cache_size = 9GB
>> log_min_duration_statement = 1500
>> log_timezone = 'Asia/Yekaterinburg'
>> datestyle = 'iso, dmy'
>> timezone = 'Asia/Yekaterinburg'
>> 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'
>> plperl.on_init = 'use utf8; use re; package utf8; require "utf8_heavy.pl";'
>>
>> ## end of config
>>
>> Sorry for my eng :)
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-12-22 01:31:00 | Re: Too long startup time after each crash. |
Previous Message | Tom Lane | 2016-12-21 23:56:45 | Re: How well does PostgreSQL 9.6.1 support unicode? |