Skip to content

Make "another CREATE STATICS job is already running" errors less urgent #148413

@mw5h

Description

@mw5h

Describe the problem

In v24.3.14, the sql.stats.automatic_job_check_before_creating_job.enabled settings was introduced. This setting reduces the level of stats-induced contention on the jobs table by performing the check to see if a stats job already exists outside of the transaction that creates the stats job. While this does reduce contention, it opens up the possibility that multiple nodes will simultaneously try to create stats jobs, resulting in one or more of them failing.

In v24.3.14, failing to create the stats job results in a warning in the server log. Alert customers may note this error and become alarmed that their mission critical cluster is degraded, when in fact this is a normal part of operation. We should not issue this failure notification as a warning.

Jira issue: CRDB-51606

Metadata

Metadata

Assignees

Labels

A-loggingIn and around the logging infrastructure.C-escalation-improvementHaving this feature would have made an escalation easierO-supportWould prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docsT-sql-queriesSQL Queries Team

Type

No type

Projects

Status

Triage

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions