The timestamp was forcibly changed. Procedure

[Dapeng960208]

To reproduce

quest_db_url = f'questdb://{user}:{password}@{host}:{port}/qdb?timezone=UTC%2B8'
create_engine(quest_db_url, pool_pre_ping=True)As soon as I link to quest db through this code, my local time locale is implemented, forced to utc, and in fastapi, all subsequent times become utc
2024-05-11 **15:30:39,592** - uvicorn.access - INFO - 10.132.49.248:56978 - "OPTIONS /lsf/api/clusters/1/resource?start_time=2024-05-10+15:32:00&end_time=2024-05-11+15:32:00 HTTP/1.0" 200 2024-05-11 **07:30:40,088** - uvicorn.access - INFO - 10.132.49.248:56980 - "GET /lsf/api/clusters/1/resource?start_time=2024-05-10+15:32:00&end_time=2024-05-11+15:32:00 HTTP/1.0" 200 2024-05-11 **07:30:46,709** - uvicorn.access - INFO - 10.132.49.248:56982 - "GET /lsf/api/clusters/1/summary HTTP/1.0" 200

This problem affects the time zone Settings of my entire system, how can I solve this problem, I use the recommended sqlachemy for connection

QuestDB version:

7.3.5

OS, in case of Docker specify Docker and the Host OS:

rehat 7

File System, in case of Docker specify Host File System:

无

Full Name:

dapeng

Affiliation:

1332606303@qq.com

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

No response

[Dapeng960208]

2024-05-11 20:30:40,636 - uvicorn.error - INFO - Uvicorn running on http://10.132.62.2:8000 (Press CTRL+C to quit)
2024-05-11 20:30:44,021 - uvicorn.access - INFO - 10.132.49.248:49068 - "GET /lsf/api/host-groups?page=1&size=20 HTTP/1.0" 307
2024-05-11 20:30:44,281 - uvicorn.access - INFO - 10.132.49.248:49070 - "GET /lsf/api/host-groups/?page=1&size=20 HTTP/1.0" 200
2024-05-11 20:30:55,663 - uvicorn.access - INFO - 10.132.49.248:49248 - "GET /lsf/api/hosts?page=1&size=20 HTTP/1.0" 307
2024-05-11 20:30:55,665 - uvicorn.access - INFO - 10.132.49.248:49250 - "GET /lsf/api/projects?page=1&size=20 HTTP/1.0" 307
2024-05-11 20:30:55,665 - uvicorn.access - INFO - 10.132.49.248:49252 - "GET /lsf/api/queues?page=1&size=20 HTTP/1.0" 307
2024-05-11 20:30:55,666 - uvicorn.access - INFO - 10.132.49.248:49254 - "GET /lsf/api/host-groups?page=1&size=20 HTTP/1.0" 307
2024-05-11 20:30:55,774 - uvicorn.access - INFO - 10.132.49.248:49260 - "GET /lsf/api/projects/?page=1&size=20 HTTP/1.0" 200
2024-05-11 20:30:56,022 - uvicorn.access - INFO - 10.132.49.248:49258 - "GET /lsf/api/hosts/?page=1&size=20 HTTP/1.0" 200
2024-05-11 20:30:56,218 - uvicorn.access - INFO - 10.132.49.248:49262 - "GET /lsf/api/host-groups/?page=1&size=20 HTTP/1.0" 200
2024-05-11 20:30:56,306 - uvicorn.access - INFO - 10.132.49.248:49264 - "GET /lsf/api/queues/?page=1&size=20 HTTP/1.0" 200
2024-05-11 20:30:56,660 - uvicorn.access - INFO - 10.132.49.248:49286 - "GET /lsf/api/host-groups?page=1&size=20 HTTP/1.0" 307
2024-05-11 20:30:56,863 - uvicorn.access - INFO - 10.132.49.248:49288 - "GET /lsf/api/host-groups/?page=1&size=20 HTTP/1.0" 200
2024-05-11 20:31:01,143 - uvicorn.access - INFO - 10.132.49.248:49346 - "OPTIONS /lsf/api/host-groups/11/summary HTTP/1.0" 200
2024-05-11 20:31:01,143 - uvicorn.access - INFO - 10.132.49.248:49348 - "OPTIONS /lsf/api/host-groups/11/resource?start_time=2024-05-10+20:32:22&end_time=2024-05-11+20:32:22 HTTP/1.0" 200
2024-05-11 20:31:01,182 - uvicorn.access - INFO - 10.132.49.248:49350 - "GET /lsf/api/host-groups/11/summary HTTP/1.0" 200
2024-05-11 12:31:01,262 - uvicorn.access - INFO - 10.132.49.248:49352 - "GET /lsf/api/host-groups/11/resource?start_time=2024-05-10+20:32:22&end_time=2024-05-11+20:32:22 HTTP/1.0" 200
2024-05-11 12:31:35,795 - uvicorn.access - INFO - 10.132.49.248:49708 - "GET /lsf/api/hosts?page=1&size=20 HTTP/1.0" 307
2024-05-11 12:31:35,800 - uvicorn.access - INFO - 10.132.49.248:49710 - "GET /lsf/api/projects?page=1&size=20 HTTP/1.0" 307
2024-05-11 12:31:35,800 - uvicorn.access - INFO - 10.132.49.248:49712 - "GET /lsf/api/queues?page=1&size=20 HTTP/1.0" 307
2024-05-11 12:31:35,800 - uvicorn.access - INFO - 10.132.49.248:49714 - "GET /lsf/api/host-groups?page=1&size=20 HTTP/1.0" 307

[jerrinot]

hello @Dapeng960208, can you please clarify what's the expected behaviour vs. the behaviour you observe? it's not very clear what you are trying to achieve.