citusdata / citusdata/pg_cron

Segmentation fault in version 1.6.7

Open
#415 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
3.9k
Forks
260
Avg merge
5d 5h
Merged PRs (30d)
1

Description

We want to use pg_cron version 1.6.7 in PostgreSQL 17, Rocky Linux 9.7.

The background worker "pg_cron launcher" suffers segmentation fault and crashes the server.

It does not matter if we go with background workers or localhost connections mode.

Here is an excerpt from the debug level logs:

2026-01-21 14:49:05.798 CET [4179112]: [75] LOG: database system is ready to accept connections
2026-01-21 14:49:05.808 CET [4179119]: [8] LOG: pg_cron scheduler started
2026-01-21 14:49:05.814 CET [4179112]: [76] DEBUG: reaping dead processes
2026-01-21 14:49:05.814 CET [4179112]: [77] LOG: background worker "pg_cron launcher" (PID 4179119) was terminated by signal 11: Segmentation fault
2026-01-21 14:49:05.814 CET [4179112]: [78] LOG: terminating any other active server processes
2026-01-21 14:49:05.814 CET [4179112]: [78] LOG: terminating any other active server processes
2026-01-21 14:49:05.814 CET [4179112]: [79] DEBUG: sending SIGQUIT to process 4179120
2026-01-21 14:49:05.815 CET [4179112]: [80] DEBUG: sending SIGQUIT to process 4179115
2026-01-21 14:49:05.815 CET [4179112]: [81] DEBUG: sending SIGQUIT to process 4179114
2026-01-21 14:49:05.815 CET [4179112]: [82] DEBUG: sending SIGQUIT to process 4179117
2026-01-21 14:49:05.815 CET [4179112]: [83] DEBUG: sending SIGQUIT to process 4179118
2026-01-21 14:49:05.816 CET [4179112]: [84] DEBUG: reaping dead processes
2026-01-21 14:49:05.817 CET [4179112]: [85] DEBUG: reaping dead processes
2026-01-21 14:49:05.817 CET [4179112]: [86] LOG: all server processes terminated; reinitializing

Version strings:

PostgreSQL 17.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-11), 64-bit

$ dnf info pg_cron_17
Installed Packages
Name : pg_cron_17
Version : 1.6.7
Release : 1PGDG.rhel9
Architecture : x86_64
Size : 102 k
Source : pg_cron_17-1.6.7-1PGDG.rhel9.src.rpm

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.