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 2245145

Summary: [rgw][s3select]: rgw going down executing query "select DATE_DIFF(SECOND, utcnow(),date_add(year,1111111111111111111, utcnow())) from s3object;"
Product: [Red Hat Storage] Red Hat Ceph Storage Reporter: Hemanth Sai <hmaheswa>
Component: RGWAssignee: gal salomon <gsalomon>
Status: CLOSED ERRATA QA Contact: Hemanth Sai <hmaheswa>
Severity: urgent Docs Contact: Rivka Pollack <rpollack>
Priority: unspecified    
Version: 7.0CC: akraj, ceph-eng-bugs, cephqe-warriors, gsalomon, tserlin
Target Milestone: ---Flags: gsalomon: needinfo-
Target Release: 7.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: ceph-18.2.0-127.el9cp Doc Type: Bug Fix
Doc Text:
.Ceph Object Gateway daemon no longer crashes if a big value is entered Previously, due to too large of a value entry, the query for `select DATE_DIFF(SECOND, utcnow(),date_add(year,1111111111111111111, utcnow())) from s3object;` would cause the Ceph Object Gateway daemon to crash. With this fix, the crash is identified and an error is reported.
 Story Points: ---
Clone Of: Environment:
Last Closed: 2023-12-13 15:24:30 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 Hemanth Sai 2023-10-19 19:04:05 UTC 
Description of problem:
rgw daemon going down while executing the below query:

[cephuser@ceph-hmaheswa-reef-v0q7fq-node6 ~]$ aws s3api --endpoint-url http://10.0.210.182:80 select-object-content  --bucket bkt1 --key polarion_data.csv --expression-type 'SQL' --input-serialization '{"CSV": {}, "CompressionType": "NONE"}' --output-serialization '{"CSV": {}}' --expression "select DATE_DIFF(SECOND, utcnow(),date_add(year,1111111111111111111, utcnow())) from s3object;" /dev/stdout

Could not connect to the endpoint URL: "http://10.0.210.182:80/bkt1/polarion_data.csv?select&select-type=2"
[cephuser@ceph-hmaheswa-reef-v0q7fq-node6 ~]$


Version-Release number of selected component (if applicable):
ceph version 18.2.0-86.el9cp

How reproducible:
always

Steps to Reproduce:
1.deploy rhcs7.0 ceph cluster
2.upload an csv object using aws-cli
3.execute the query "elect DATE_DIFF(SECOND, utcnow(),date_add(year,1111111111111111111, utcnow())) from s3object;"

Actual results:
rgw daemon going down

Expected results:
no crashes should be seen

Additional info:
rgw node: 10.0.210.182
creds: root/passwd ; cephuser/cephuser
Comment 3 gal salomon 2023-11-02 07:19:22 UTC 
the issue is resolved in the following PR
https://github.com/ceph/ceph/pull/54298
Comment 8 errata-xmlrpc 2023-12-13 15:24:30 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (Red Hat Ceph Storage 7.0 Bug Fix update), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2023:7780