Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.
This project is now read‑only. Starting Monday, February 2, please use https://ibm-ceph.atlassian.net/ for all bug tracking management.

Bug 2246150

Summary: [Workload-DFG] RGW crashed due to illegal calculation (exception)
Product: [Red Hat Storage] Red Hat Ceph Storage Reporter: Tim Wilkinson <twilkins>
Component: RGWAssignee: gal salomon <gsalomon>
Status: CLOSED COMPLETED QA Contact: Tim Wilkinson <twilkins>
Severity: high Docs Contact:
Priority: unspecified    
Version: 7.0CC: ceph-eng-bugs, cephqe-warriors, gsalomon, racpatel, rpollack, tserlin, vumrao
Target Milestone: ---Flags: rpollack: needinfo-
Target Release: 7.0   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: ceph-18.2.0-127.el9cp Doc Type: Bug Fix
Doc Text:
.SQL engine no longer causes Ceph Object Gateway crash with illegal calculations Previously, in some cases, the SQL engine would throw an exception that was not handled, causing a Ceph Object Gateway crash. This was caused due to an illegal SQL calculation of a date-time operation. With this fix, the exception is handled with an emitted error message, instead of crashing.
 Story Points: ---
Clone Of: Environment:
Last Closed: 2023-11-20 18:35:59 UTC 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 Tim Wilkinson 2023-10-25 15:10:32 UTC 
Created attachment 1995419 [details]
RGW log
Comment 4 gal salomon 2023-10-26 05:59:34 UTC 
"select DATE_DIFF(SECOND, utcnow(),date_add(year,1111111111111111111, utcnow())) from s3object limit 4;"
cause a crash due to illegal calculation (exception)

the title of this bug report should changed,
Comment 5 gal salomon 2023-11-02 07:32:29 UTC 
the issue is resolved in the following PR
https://github.com/ceph/ceph/pull/54298