Insert record with multiple timestamp cols may cause insert error invalid timestamp

[johnnylc]

Bug Description When stable created with multiple timestamp cols, for example ts device_ts data_ts local_ts ..., When perform a insert action using Springboot jdbc, and set the data_ts and local_ts using the same timestamp string like "2024-07-09 23:00:00:000". Occasionally, the insert may fail and the error log of Springboot says " invalid timestamp near xxxxxx".

It happens many times, and when it happens I try to not set local_ts, just set the data_ts using the same timestamp string, then the record could be inserted successfully.

Environment (please complete the following information):

• OS: Windows 10 Docker
• Memory: 128G, CPU: Intel Xeon Silver 4210 X 2
• TDengine Version 3.3.0.3

[yu285]

Could you provide us core code ?

[yu285]

and JDBC version please .