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
the issue is resolved in the following PR https://github.com/ceph/ceph/pull/54298
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