TDengine icon indicating copy to clipboard operation
TDengine copied to clipboard

binding insert doesn't support high-concurrency ? 2.6.0.6

Open qihuagaosh opened this issue 3 years ago • 0 comments

java.sql.SQLException: TDengine ERROR (2350): failed to bind table name and corresponding tags, reason: invalid operation: not multiple table insert at com.taosdata.jdbc.TSDBError.createSQLException(TSDBError.java:76) at com.taosdata.jdbc.TSDBJNIConnector.setBindTableNameAndTags(TSDBJNIConnector.java:314) at com.taosdata.jdbc.TSDBPreparedStatement.columnDataAddBatch(TSDBPreparedStatement.java:816) at logics.UploadDataV3.$anonfun$batchInsertIOTV2$5(UploadDataV3.scala:348) at logics.UploadDataV3.$anonfun$batchInsertIOTV2$5$adapted(UploadDataV3.scala:331) at scala.collection.Iterator.foreach(Iterator.scala:943) at scala.collection.Iterator.foreach$(Iterator.scala:943) at scala.collection.AbstractIterator.foreach(Iterator.scala:1431) at logics.UploadDataV3.$anonfun$batchInsertIOTV2$1(UploadDataV3.scala:331) at logics.UploadDataV3.$anonfun$batchInsertIOTV2$1$adapted(UploadDataV3.scala:311) java.sql.SQLException: TDengine ERROR (2350): failed to bind table name and corresponding tags, reason: invalid operation: not multiple table insert at com.taosdata.jdbc.TSDBError.createSQLException(TSDBError.java:76) at com.taosdata.jdbc.TSDBJNIConnector.setBindTableNameAndTags(TSDBJNIConnector.java:314) at com.taosdata.jdbc.TSDBPreparedStatement.columnDataAddBatch(TSDBPreparedStatement.java:816) at logics.UploadDataV3.$anonfun$batchInsertIOTV2$5(UploadDataV3.scala:348) at logics.UploadDataV3.$anonfun$batchInsertIOTV2$5$adapted(UploadDataV3.scala:331) at scala.collection.Iterator.foreach(Iterator.scala:943) at scala.collection.Iterator.foreach$(Iterator.scala:943) at scala.collection.AbstractIterator.foreach(Iterator.scala:1431) at logics.UploadDataV3.$anonfun$batchInsertIOTV2$1(UploadDataV3.scala:331) at logics.UploadDataV3.$anonfun$batchInsertIOTV2$1$adapted(UploadDataV3.scala:311) at play.api.db.DefaultDatabase.withConnection(Databases.scala:180) at play.api.db.DefaultDatabase.withConnection(Databases.scala:174) at logics.UploadDataV3.batchInsertIOTV2(UploadDataV3.scala:311) at logics.UploadDataV3.uploadHelper(UploadDataV3.scala:521) at logics.UploadDataV3.uploadV3(UploadDataV3.scala:178) at controllers.ApplicationV3Sink.$anonfun$uploadDataV3$1(ApplicationV3Sink.scala:79) at scala.Function1.$anonfun$andThen$1(Function1.scala:57) at play.api.mvc.ActionBuilderImpl.invokeBlock(Action.scala:441) at play.api.mvc.ActionBuilderImpl.invokeBlock(Action.scala:439) at play.api.mvc.ActionBuilder$$anon$9.apply(Action.scala:379) at play.api.mvc.Action.$anonfun$apply$4(Action.scala:82) at scala.concurrent.Future.$anonfun$flatMap$1(Future.scala:307) at scala.concurrent.impl.Promise.$anonfun$transformWith$1(Promise.scala:41)

Is your feature request related to a problem? Please describe. A clear and concise description of what the circumstance is and what the associated problem is. Ex. I'm using TDengine for this use case: [...]. But I'm always frustrated when [...]

Describe your desired behavior A clear and concise description of what you want to happen. Ex. I want TDengine to be able to do [...] when I try to do [...] with it.

Describe your solutions/suggestions if you've any A clear and concise description of any solutions/suggestions to this problem or features you've considered.

Additional context Add any other context or screenshots about the feature request here.

qihuagaosh avatar Aug 31 '22 08:08 qihuagaosh