F0000

At a glance

F0000 is the configuration-file error condition, but its severity and recovery boundary depend on the owner. Fixed core paths include a recovery-target failure and OAuth HBA validation; the unaccent contrib dictionary has its own file-open and rule-parser paths.

Meaning

The recovery path emits FATAL when archive recovery ends before a configured target is reached. OAuth validation calls ereport(elevel): HBA parsing supplies the level, load_hba() logs parse errors while retaining the old rules on reload, and initial postmaster startup turns a failed HBA load into a separate FATAL that prevents startup. The unaccent loader reports an ERROR when it cannot open its rules file, while duplicate rules and malformed rule lines are WARNING conditions with this SQLSTATE.

These are configuration-owner-specific paths. A line number and file context belong to HBA parsing; %m belongs to the dictionary file-open operation; a recovery-target message has neither of those fields.

Messages

• FATAL, SQLSTATE F0000: recovery ended before configured recovery target was reached.
• elevel selected by HBA loading, with SQLSTATE F0000: oauth_validator_libraries must be set for authentication method %s; context line %d of configuration file "%s".
• elevel selected by HBA loading: invalid list syntax in parameter "%s".
• elevel selected by HBA loading: authentication method "oauth" requires argument "validator" to be set when oauth_validator_libraries contains multiple options; context line %d of configuration file "%s".
• ERROR, SQLSTATE F0000: could not open unaccent file "%s": %m.
• WARNING, SQLSTATE F0000: duplicate source strings, first one will be used.
• WARNING, SQLSTATE F0000: invalid syntax: more than two strings in unaccent rule or invalid syntax: unfinished quoted string in unaccent rule.

The OAuth templates use ereport(elevel), so the source function alone does not turn every HBA event into ERROR or FATAL; the startup/reload caller determines the operational boundary.

Diagnosis

Keep the complete primary, detail, hint, context, file name, line number, subsystem, and phase. For recovery, inspect the configured target and available WAL/archive. For OAuth, inspect the HBA line and oauth_validator_libraries value; distinguish an empty list from list syntax and from a missing validator argument. For unaccent, check the resolved rules path, permissions, encoding, and rule format; a warning can leave the dictionary loaded with a first-rule-wins or skipped-line behavior.

Response

Fix the named configuration using its owning format and keep a known-good copy. A recovery-target FATAL or initial HBA-load FATAL ends startup, so there is no client transaction to roll back; correct the target/configuration and restart, then use a new connection. An HBA reload parse failure is logged and the old rules remain active, so repair the file and reload again rather than assuming the new rules took effect. An unaccent ERROR inside an explicit client transaction requires ROLLBACK or an existing savepoint before continuing; warning paths do not require rollback, but their skipped or duplicate rules should be reviewed before relying on the dictionary.

Versions

The locked catalogue records this condition from 7.4; fixed source coverage is PostgreSQL 18.6. No startup, reload, or dictionary failure was induced for this source-only page.

Related

58P01, F0001, 57P03

Sources

src/backend/access/transam/xlogrecovery.c#L1921-L1931

src/backend/libpq/auth-oauth.c#L813-L870

src/backend/libpq/hba.c#L2635-L2692

src/backend/postmaster/postmaster.c#L1327-L1338

contrib/unaccent/unaccent.c#L65-L109

contrib/unaccent/unaccent.c#L260-L271

The structured evidence record records the fixed message groups, caller-selected severity, and source/runtime boundary.

Source evidence

Evidence belongs to the frozen source and runtime versions listed here. It is not a runtime verification of the selected manual version.

• src/backend/utils/errcodes.txt · REL_18_6 ·
  724edf9bde9d356724ad384a2e196edc3c9f80f7
• src/backend/access/transam/xlogrecovery.c · REL_18_6 ·
  724edf9bde9d356724ad384a2e196edc3c9f80f7
• src/backend/libpq/auth-oauth.c · REL_18_6 ·
  724edf9bde9d356724ad384a2e196edc3c9f80f7
• src/backend/libpq/hba.c · REL_18_6 ·
  724edf9bde9d356724ad384a2e196edc3c9f80f7
• src/backend/postmaster/postmaster.c · REL_18_6 ·
  724edf9bde9d356724ad384a2e196edc3c9f80f7
• contrib/unaccent/unaccent.c · REL_18_6 ·
  724edf9bde9d356724ad384a2e196edc3c9f80f7

Message templates

recovery ended before configured recovery target was reached

oauth_validator_libraries must be set for authentication method %s

line %d of configuration file "%s"

invalid list syntax in parameter "%s"

authentication method "oauth" requires argument "validator" to be set when oauth_validator_libraries contains multiple options

line %d of configuration file "%s"

could not open unaccent file "%s": %m

duplicate source strings, first one will be used

invalid syntax: more than two strings in unaccent rule

invalid syntax: unfinished quoted string in unaccent rule

Reproduction & repair cases

No reproduction case is attached to this condition.

Recorded runtime evidence

No runtime observation is attached to this entry.