1. Home
  2. Support
Article - CS386597

ThingWorx invoked some SQL statements are caused InfluxDB performance issue

Modified: 08-May-2023   


Applies To

  • ThingWorx Manufacturing Apps Family 9.1 to 9.1.1

Description

  • There is reported by Influx engineer ThingWorx invoked below SQL statements are caused InfluxDB performance issue
Apr 16 03:40:04 XXXXX influxd: [httpd] 10.31.253.16,10.31.253.243 - twadmin [16/Apr/2023:03:40:04 +0900] "POST /query?chunk_size=10000&chunked=true&db=thingworx&params=%7B%220%22%3A1681497604208000000%2C%221%22%3A1681584004208000000%7D HTTP/1.1 {'q': 'SELECT "ErrorState" FROM "XXXXXX" WHERE valuestreamname = 'The $v1ValueStream_XXXXXX' AND time >= $0 AND time <= $1 ORDER BY time DESC LIMIT 1'}" 200 58 "-" "okhttp/4.9.1" efd06879-dbbc-11ed-afad-0050569f90e8 630
This is a printer-friendly version of Article 386597 and may be out of date. For the latest version click CS386597