[jira] [Commented] (IGNITE-17561) SQLException: Hexadecimal string with odd number of characters

["Dren (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-17561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17599383#comment-17599383 ] 

Dren commented on IGNITE-17561:
-------------------------------

Hi [~jooger] 

A few more updates:
 # the issue occurs only on SQL tables that have PK with more than one column
 # the issue occurs only when using one of these columns (that are part of PK) in WHERE part of query
 # we are not using cache API for managing data in SQL tables
 # we have tried rebuilding indexes with control utility as described in docs, rebuilding finished OK (command exists properly and log shows "Finished indexes rebuilding" entries), but it did not solve the problem
 # we have stumbled across this Jira issue: https://issues.apache.org/jira/browse/IGNITE-11252 that suggests deleting index.bin files for affected caches/tables. Following this procedure finally solved the problem

 

Also, it is possible for us to provide you with our sample data if you would like to reproduce it yourself. We were able to reproduce it by ourselves by repeating all upgrade steps.

> SQLException: Hexadecimal string with odd number of characters
> --------------------------------------------------------------
>
>                 Key: IGNITE-17561
>                 URL: https://issues.apache.org/jira/browse/IGNITE-17561
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 2.13
>         Environment: Ignite 2.13.0
>            Reporter: Dren
>            Priority: Critical
>         Attachments: CREATE_TABLE_STAT_ENRICH_PROCESSOR.sql, Ignite_log.txt, data_sample_in_table.jpg, error_sql1.jpg, ok_sql2.jpg
>
>
> After in place upgrade from 2.7.6 to 2.13.0  SQL failed with error.
> {code:java}
> // 
> Caused by: org.h2.jdbc.JdbcSQLException: Hexadecimal string with odd number of characters: "2022-08-22 10:30:58.938" [90003-197]
>         at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
>         ... 57 more {code}
> After creation of new table with same columns and same data SQL return result without error.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)