[GitHub] [iotdb] IOjeffrey commented on issue #4637: Grafana-IoTDB java.sql.SQLException if IOTDB version > 0.12.2

[GitBox <gi...@apache.org>]

IOjeffrey commented on issue #4637:
URL: https://github.com/apache/iotdb/issues/4637#issuecomment-1001644295


   Hello Steve,
   
   "My" application is Grafana 8.3.3. My setup consists of three Docker containers:
   
   1. apache/iotdb:0.12.4-node
   2. apache/iotdb:0.12.4-grafana (or as stated before [my own Option 2 iotdb-grafana installation](https://github.com/promouseus/open-field_time-series/blob/main/iotdb-grafana/Dockerfile))
   3. [grafana/grafana:latest based container](https://github.com/promouseus/open-field_time-series/blob/main/grafana/Dockerfile) with the [data source configured](https://github.com/promouseus/open-field_time-series/blob/main/grafana/iotdb.yaml)
   
   For testing I add some time-series with a bash script like this:
   ```
   iotdbCli='docker exec -it iotdb /iotdb/sbin/start-cli.sh -h 127.0.0.1 -p 6667 -u root -pw root'
   ${iotdbCli} -e "set storage group to root.sentico"
   ${iotdbCli} -e "CREATE TIMESERIES root.sentico.portal.ipv4.\"10.20.20.254\".rtt WITH DATATYPE=FLOAT, ENCODING=RLE"
   ${iotdbCli} -e "CREATE TIMESERIES root.sentico.portal.ipv4.\"1.1.1.1\".rtt WITH DATATYPE=FLOAT, ENCODING=RLE"
   ```
   
   And I create some data by running the following bash script a couple of times:
   ```
   timestamp=`date +%s%3N`
   rtt1=`ping 8.8.8.8 -qc1|tail -n 1|awk -F' ' '{print $4}'|awk -F'/' '{print $1}'`
   rtt2=`ping 1.1.1.1 -qc1|tail -n 1|awk -F' ' '{print $4}'|awk -F'/' '{print $1}'`
   
   ${iotdbCli} -e "INSERT INTO root.sentico.portal.ipv4.\"10.20.20.254\"(timestamp,rtt) values(${timestamp},${rtt1})"
   ${iotdbCli} -e "INSERT INTO root.sentico.portal.ipv4.\"1.1.1.1\"(timestamp,rtt) values(${timestamp},${rtt2})"
   ```
   
   Doing above for 0.12.3 and 0.12.4 results in the log file as supplied. If I leave container 1 (iotdb-node) and 3 (grafana) in tact and only change container 2 (iotdb-grafana) back to 0.12.2 everything is working immediately. So the problem seems isolated to the iotdb-grafana 0.12.3 and 0.12.4 version. For now I use iotdb-node 0.12.4 combined with iotdb-grafana 0.12.2 and that seems to work (at least in my basic tests).
   
   If you need any more information or I can assist you with something, please let me know.
   
   Cheers,
   
   Jeffrey


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org