BUG #7858: Inaccurate Log Message

From: jackie(dot)qq(dot)zhang(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7858: Inaccurate Log Message
Date: 2013-02-08 06:46:29
Message-ID: E1U3hjB-0007yL-0Y@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7858
Logged by: Jackie Zhang
Email address: jackie(dot)qq(dot)zhang(at)gmail(dot)com
PostgreSQL version: 9.1.4
Operating system: Ubuntu
Description:

Hi,

The log message of the sanity check for "superuser_reserved_connections" in
PostmasterMain() is not accurate. See the following code snippet:

/*src/backend/postmaster/postmaster.c*/
730 /*
731 * Check for invalid combinations of GUC settings.
732 */
733 if (ReservedBackends >= MaxBackends)
734 {
735 write_stderr("%s: superuser_reserved_connections must
be less than max_connections\n", progname);
736 ExitPostmaster(1);
737 }

The problem is that "MaxBackends" is calculated by both
"autovacuum_max_workers" and "max_connections". See assign_maxconnections()
and assign_autovacuum_max_workers() in src/backend/utils/misc/guc.c.

The log message should inform both the two configuration parameters instead
of only one -- the root cause could be the oversized
"autovacuum_max_workers".

Thanks,
Jackie

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2013-02-08 09:57:35 Re: BUG #7857: postgresql91-libs fails to create ld.so.conf.d symlink
Previous Message chris.meisinger 2013-02-07 20:22:32 BUG #7857: postgresql91-libs fails to create ld.so.conf.d symlink