JIRA and CONFLUENCE failing to update since timezone change

[tnouel-m6]

Hi,
I'll paste the full traces below, but I'm pretty sure I know what the issue is :
since March 30th, we've passed to "summertime hours" in France, which means the date went from
2025-03-30 01:59 to 2025-03-30 03:00.
Hence, 2025-03-30 02:30, althought it seems perfectly legit, DOESN'T EXIST. And JIRA and CONFLUENCE are loosing it : most of my connectors are sending the request to retreive docs updated after 2025-03-30 02:30 and before now, and since the former date does not make any sense, the request fail. I've tested out and I know for a fact that if Onyx requested docs updated after 2025-03-30 01:00, it would work like a charm.

Is there a way for me to manually specify this date? I haven't found the right place in the tables.

Thanks ! full traces below

I'm getting the following error on half my JIRA connectors:
Traceback (most recent call last):
File "/app/onyx/background/indexing/job_client.py", line 83, in _initializer
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "/app/onyx/background/celery/tasks/indexing/tasks.py", line 826, in connector_indexing_task
raise e
File "/app/onyx/background/celery/tasks/indexing/tasks.py", line 799, in connector_indexing_task
run_indexing_entrypoint(
File "/app/onyx/background/indexing/run_indexing.py", line 726, in run_indexing_entrypoint
_run_indexing(db_session, index_attempt_id, tenant_id, callback)
File "/app/onyx/background/indexing/run_indexing.py", line 639, in _run_indexing
raise e
File "/app/onyx/background/indexing/run_indexing.py", line 433, in _run_indexing
for document_batch, failure, next_checkpoint in connector_runner.run(
File "/app/onyx/connectors/connector_runner.py", line 142, in run
for document_batch in self.connector.poll_source(
File "/app/onyx/connectors/onyx_jira/connector.py", line 243, in poll_source
for doc in fetch_jira_issues_batch(
File "/app/onyx/connectors/onyx_jira/connector.py", line 83, in fetch_jira_issues_batch
for issue in _paginate_jql_search(
File "/app/onyx/connectors/onyx_jira/connector.py", line 57, in _paginate_jql_search
issues = jira_client.search_issues(
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/jira/client.py", line 3083, in search_issues
issues = self._fetch_pages(
^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/jira/client.py", line 728, in _fetch_pages
resource = self._get_json(request_path, params=page_params, base=base)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/jira/client.py", line 3831, in _get_json
r = self._session.get(url, params=params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/requests/sessions.py", line 602, in get
return self.request("GET", url, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/jira/resilientsession.py", line 246, in request
elif raise_on_error(response, **processed_kwargs):
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/jira/resilientsession.py", line 71, in raise_on_error
raise JIRAError(
jira.exceptions.JIRAError: JiraError HTTP 400 url: https://jira.m6/rest/api/2/search?jql=project+%3D+%22LOOK%22+AND+updated+%3E%3D+%272025-03-30+02%3A30%27+AND+updated+%3C%3D+%272025-04-04+10%3A02%27&startAt=0&validateQuery=True&fields=%2Aall&maxResults=50
text: La valeur de date '2025-03-30 02:30' pour le champ 'updated' est invalide. Les formats valides comprennent : 'aaaa/MM/jj HH:mm', 'aaaa-MM-jj HH:mm', 'aaaa/MM/jj', 'aaaa-MM-jj', ou un format de période p. ex. '-5j', '4s 2j'.

response headers = {'Date': 'Fri, 04 Apr 2025 10:02:23 GMT', 'Server': 'Apache/2.4.41 (Ubuntu)', 'X-AREQUESTID': '722x59692x3', 'Referrer-Policy': 'strict-origin-when-cross-origin', 'X-XSS-Protection': '1; mode=block', 'X-Content-Type-Options': 'nosniff', 'X-Frame-Options': 'SAMEORIGIN', 'Content-Security-Policy': 'sandbox', 'Strict-Transport-Security': 'max-age=31536000', 'X-Seraph-LoginReason': 'OK', 'X-ASESSIONID': 'k1xzdu', 'X-AUSERNAME': 'danswer', 'Cache-Control': 'no-cache, no-store, no-transform', 'Content-Encoding': 'gzip', 'Vary': 'User-Agent', 'Content-Type': 'application/json;charset=UTF-8', 'Set-Cookie': 'JSESSIONID=D23C7ABC963DBF7EF2D230A680F65550; Path=/; HttpOnly, atlassian.xsrf.token=BJ3U-WJRN-IMS5-T3ZL_9c06c5e15a89b733608939a175c6b01b35ffccca_lin; Path=/', 'Connection': 'close', 'Transfer-Encoding': 'chunked'}
response text = {"errorMessages":["La valeur de date '2025-03-30 02:30' pour le champ 'updated' est invalide. Les formats valides comprennent : 'aaaa/MM/jj HH:mm', 'aaaa-MM-jj HH:mm', 'aaaa/MM/jj', 'aaaa-MM-jj', ou un format de période p. ex. '-5j', '4s 2j'."],"errors":{}}

and on CONFLUENCE :
Traceback (most recent call last):
File "/app/onyx/background/indexing/job_client.py", line 83, in _initializer
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "/app/onyx/background/celery/tasks/indexing/tasks.py", line 826, in connector_indexing_task
raise e
File "/app/onyx/background/celery/tasks/indexing/tasks.py", line 799, in connector_indexing_task
run_indexing_entrypoint(
File "/app/onyx/background/indexing/run_indexing.py", line 726, in run_indexing_entrypoint
_run_indexing(db_session, index_attempt_id, tenant_id, callback)
File "/app/onyx/background/indexing/run_indexing.py", line 639, in _run_indexing
raise e
File "/app/onyx/background/indexing/run_indexing.py", line 433, in _run_indexing
for document_batch, failure, next_checkpoint in connector_runner.run(
File "/app/onyx/connectors/connector_runner.py", line 142, in run
for document_batch in self.connector.poll_source(
File "/app/onyx/connectors/confluence/connector.py", line 338, in _fetch_document_batches
for page in self.confluence_client.paginated_cql_retrieval(
File "/app/onyx/connectors/confluence/onyx_confluence.py", line 538, in paginated_cql_retrieval
yield from self._paginate_url(
File "/app/onyx/connectors/confluence/onyx_confluence.py", line 481, in _paginate_url
raise e
File "/app/onyx/connectors/confluence/onyx_confluence.py", line 440, in _paginate_url
raw_response.raise_for_status()
File "/usr/local/lib/python3.11/site-packages/requests/models.py", line 1024, in raise_for_status
raise HTTPError(http_error_msg, response=self)
requests.exceptions.HTTPError: 400 Client Error: for url: https://confluence.m6/rest/api/content/search?cql=type=page%20and%20lastmodified%20%3E=%20'2025-03-30%2002:30'%20and%20lastmodified%20%3C=%20'2025-04-04%2009:00'&expand=body.view.value,version,space,metadata.labels,history.lastUpdated&limit=16

[github-actions]

This issue is stale because it has been open 75 days with no activity. Remove stale label or comment or this will be closed in 15 days.

[github-actions]

This issue was closed because it has been stalled for 90 days with no activity.