Segmentation violation w/ PostgreSQL file table maintenance (Type = Admin ) job

22 views

Skip to first unread message

Robert

unread,

May 8, 2019, 10:33:14 AM5/8/19

to bareos-users

Hi,

using Bareos version 16.2.4 I wanted to setup a similar maintenance job as described at documentation:
http://download.bareos.org/bareos/experimental/nightly/documentation/html/bareos-manual-main-reference.html#x1-48100033.3.1

But bareos-director.service restart after adding this job config segfault-ed :(

-------- config: etc/bareos/bareos-dir.d/job/postgreSQL_file_table_maintenance_job.conf BEGIN -----------
# PostgreSQL file table maintenance job
Job {
Name = FileTableMaintJob
Type = Admin
Client = "greatpapa-node-02-fd"
Messages = Standard
FileSet = "Catalog"
Schedule = "Catalog"
Priority = 20 # to run after BackupCatalog job
RunScript {
RunsWhen = Before
RunsOnClient = no
Fail Job On Error = yes
Command = "sudo -u postgres /usr/lib/bareos/scripts/postgresql_file_table_maintenance.sh"
}
}
-------- config: etc/bareos/bareos-dir.d/job/postgreSQL_file_table_maintenance_job.conf END -----------

From systemd journal:

Mai 08 16:01:06 greatpapa-node-02 bareos-dir[21140]: BAREOS interrupted by signal 11: Segmentation violation
Mai 08 16:01:06 greatpapa-node-02 bareos-dir[21140]: BAREOS interrupted by signal 11: Segmentation violation
Mai 08 16:01:06 greatpapa-node-02 bareos-dir[21140]: Kaboom! bareos-dir, bareos-dir got signal 11 - Segmentation violation. Attempting traceback.
Mai 08 16:01:06 greatpapa-node-02 bareos-dir[21140]: Kaboom! exepath=/usr/sbin/
Mai 08 16:01:06 greatpapa-node-02 bareos-dir[21140]: Calling: /usr/sbin/btraceback /usr/sbin/bareos-dir 21140 /var/lib/bareos
Mai 08 16:01:06 greatpapa-node-02 bareos-dir[21140]: It looks like the traceback worked...
Mai 08 16:01:06 greatpapa-node-02 bareos-dir[21140]: Dumping: /var/lib/bareos/bareos-dir.21140.bactrace
Mai 08 16:01:06 greatpapa-node-02 systemd[1]: bareos-director.service: control process exited, code=exited status=11
Mai 08 16:01:06 greatpapa-node-02 systemd[1]: Failed to start Bareos Director Daemon service.
Mai 08 16:01:06 greatpapa-node-02 systemd[1]: Unit bareos-director.service entered failed state.

The command itself

"sudo -u postgres /usr/lib/bareos/scripts/postgresql_file_table_maintenance.sh"

works w/o any issues.

If I omit 'FileSet =' or 'Client =' directive a service restart complains about these missing directives, although an admin job probably doesn't need them?

What am I doing wrong?

BTW: There is an error at documented SQL statement as backtick table name escaping is invalid for postgresql, you have to use quotes instead.