taosdata / taosdata/TDengine

tsd3.3.6使用websoket链接报错

Open
#35,333 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement
Dominant language
C
Stars
25.1k
Forks
5k
Avg merge
4d 59m
Merged PRs (30d)
7

Description

使用tdengine3.3.6版本,docker部署
java连接器版本3.6.3

问题:
1、websocket链接方式,写入数据时报错:

Error updating database.Cause: java.sql.SQLException: (Ox200):Invalid operation### The error may exist in file [E: \wonkspace\be-track-v2\target\classes \mybatis\mapper\DevicStatushisTdEngineMapper.xml]ceStatusHis## The error may involve com.cmiot.track.mapper. DeviceStatushisTdEngineMapper.batchInsertDev:### The error occurred while executing an updateSTAGS ('93081350310')### SQL: insert intodevice_statushis_93081350310 USING device_statushi
Cause: java.sql.SQLException: (Ox200):Invalid operationuncategorized SQLException; SQL state Inull]; error code [0]; (ex200):Invalid operationtionTranslator.java:96)at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExcerava:347)at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor. invoke (SqlSessionTemplate.at jdk.proxy2/jdk.proxy2.$Proxy99.insert(Unknown Source)at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate

2、切换至restful链接后,可正常写入

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the websocket write with TDengine 3.3.6 in Docker and the Java connector 3.6.3. Inspect the batchInsertDev call and the referenced DeviceStatushisTdEngineMapper.xml mapping, then compare it with the working RESTful path. Done means the insert using websocket completes without the Invalid operation error.

Written by the indexing model from the issue text.

Assessment

Tech stack
docker, java, sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.