[
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)
