[ https://issues.apache.org/jira/browse/IGNITE-17561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17597706#comment-17597706 ]
Dren commented on IGNITE-17561: ------------------------------- Hi [~jooger] , after in place upgrade from 2.7.6 to 2.13 this problem happened to me on development environment. I solved the problem by dropping the table and re-creating it. For data insert I use the Python module pyignite. {code:java} // code placeholder SQL_STORE_ENRICH_PROCESSOR_STAT = ''' INSERT INTO STAT_ENRICH_PROCESSOR (SAMPLE_TIME, CACHE_NAME, CACHE_SIZE, ACTIVE_THREADS, THREAD_QUEUE, PROC_TIME ) VALUES (CURRENT_TIMESTAMP(3), ?, ?, ?, ?, ? ) ''' try: client.sql(SQL_STORE_ENRICH_PROCESSOR_STAT, query_args=data) except Exception as e: logger.error('ERROR in SQL_STORE_ENRICH_PROCESSOR_STAT: %s ' % (e)) {code} > 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)