Bug 2241929

Summary: opendmarc-expire fails on an empty database
Product: [Fedora] Fedora EPEL Reporter: Frank Büttner <bugzilla>
Component: opendmarcAssignee: Kevin Fenzi <kevin>
Status: NEW --- QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: epel9CC: abo, kevin
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: ---
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Frank Büttner 2023-10-03 13:48:03 UTC
Description of problem:
When the database is empty the tool fails with exit code 1

Version-Release number of selected component (if applicable):
opendmarc-1.4.2-10.el9.x86_64

How reproducible:
Every time

Steps to Reproduce:
1. Create an empty database with the default schema
2. call OPENDMARC_PASSWORD=XXXXXX /usr/sbin/opendmarc-expire --verbose;echo $?


Actual results:
It fails with:
opendmarc-expire: started at Tue Oct  3 15:45:33 2023
opendmarc-expire: connected to database
opendmarc-expire: expiring messages older than 180 day(s)
opendmarc-expire: no rows deleted
1

Expected results:
That an empty database will be intercepted.

Additional info:
The error comes from line 323 of the perl script.