Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How can i extend the query timeout properties??

edited July 2021 in General Discussion

i use the kafkaexport query in the java programming. As the sended data is Big, KafkaExport funtion's execute time is too long..

beacuase of long time of function execute the vertica jdbc show this error message

Cause: java.sql.SQLNonTransientException: [Vertica]VJDBC ERROR: Error calling processPartition() in User Function KafkaExport at [src/KafkaExport.cpp:351], error code: 0, message: Exception while processing partition row: [413324] : [Fatal kafka error: kafka:9092/1001: 5 request(s) timed out: disconnect]
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
at com.sun.proxy.$Proxy59.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:93)
at com.sun.proxy.$Proxy76.kafkaExportTotalProducts(Unknown Source)
at

(......)
com.wmp.ep.index.manager.config.db.MybatisPrintSqlInterceptor.intercept(MybatisPrintSqlInterceptor.java:47)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy98.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
... 60 common frames omitted
Caused by: com.vertica.support.exceptions.NonTransientException: [Vertica]VJDBC ERROR: Error calling processPartition() in User Function KafkaExport at [src/KafkaExport.cpp:351], error code: 0, message: Exception while processing partition row: [413324] : [Fatal kafka error: kafka:9092/1001: 5 request(s) timed out: disconnect]
... 86 common frames omitted

How can i extend the query timeout ??

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.