[GitHub] [druid] 8823Senior opened a new issue #11132: Query by Avatica encounter AvaticaSqlException occasional

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

8823Senior opened a new issue #11132:
URL: https://github.com/apache/druid/issues/11132


   encounter exception when query by Avatica 
   AvaticaSqlException: Error -1 (00000) : while preparing SQL
   
   ### 0.20
   
   The Druid version where the problem was encountered.
   
   ### Description
   
   when my springboot service query data of druid by Avatica-core , could got exception occasional 
   this exception does't appear everytime. it's occasional. 
   although i got the exception now , it is normal that query again after a few seconds.
   but, the query params is same. could anyone know why it is ?
   
   ```xml
   <dependency>
               <groupId>org.apache.calcite.avatica</groupId>
               <artifactId>avatica-core</artifactId>
               <version>1.17.0</version>
           </dependency>
   ```
   
   ### this is spring log   
   although i got the exception now , it is normal that query again after a few seconds.
   by spring log, it seems that spring guess that the SQL Preparestatement appear exception, but , it is not exact.
   because, when i query again with same sql after a few seconds, it's normal and not have exception.
   
   ```properties
   org.springframework.jdbc.UncategorizedSQLException: 
   ### Error querying database.  Cause: org.apache.calcite.avatica.AvaticaSqlException: Error -1 (00000) : while preparing SQL: SELECT
           productLine,
           SUM(gpuQuantityNew)	AS gpuQuantityNew
           FROM instance_stat4
            WHERE  dataType = ? 
           GROUP BY 1
   ### The error may exist in URL [jar:file:/app.jar!/BOOT-INF/classes!/mapper/stat/InstanceStatMapper.xml]
   ### The error may involve com.data.mapper.stat.InstanceStatMapper.selectSumGroupByProductLine
   ### The error occurred while executing a query
   ### SQL: SELECT         productLine,                   SUM(gpuQuantityNew) AS gpuQuantityNew              FROM instance_stat4                    WHERE  dataType = ?                GROUP BY 1
   ```
   


-- 
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.

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org