You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Yury Gerzhedovich (JIRA)" <ji...@apache.org> on 2019/02/27 08:44:00 UTC

[jira] [Updated] (IGNITE-11430) Error on querying IGNITE.LOCAL_SQL_RUNNING_QUERIES SQL view

     [ https://issues.apache.org/jira/browse/IGNITE-11430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yury Gerzhedovich updated IGNITE-11430:
---------------------------------------
    Ignite Flags:   (was: Docs Required)

> Error on querying IGNITE.LOCAL_SQL_RUNNING_QUERIES SQL view
> -----------------------------------------------------------
>
>                 Key: IGNITE-11430
>                 URL: https://issues.apache.org/jira/browse/IGNITE-11430
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>            Reporter: Yury Gerzhedovich
>            Assignee: Yury Gerzhedovich
>            Priority: Blocker
>             Fix For: 2.8
>
>
> Need to fix TIMESTAMP_WITH_TIMEZONE issue in the LOCAL_SQL_RUNNING_QUERIES view.
> It appears during quering through JSDBC client, like a Dbeaver
> SELECT * FROM IGNITE.LOCAL_SQL_RUNNING_QUERIES;
>  
> [2019-02-27 11:28:24,357][ERROR][client-connector-#56][ClientListenerNioListener] Failed to process client request [req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=200, sqlQry=SELECT * FROM IGNITE.LOCAL_SQL_RUNNING_QUERIES, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]]
> class org.apache.ignite.binary.BinaryObjectException: Custom objects are not supported
>  at org.apache.ignite.internal.processors.odbc.SqlListenerUtils.writeObject(SqlListenerUtils.java:219)
>  at org.apache.ignite.internal.processors.odbc.jdbc.JdbcUtils.writeItems(JdbcUtils.java:44)
>  at org.apache.ignite.internal.processors.odbc.jdbc.JdbcQueryExecuteResult.writeBinary(JdbcQueryExecuteResult.java:128)
>  at org.apache.ignite.internal.processors.odbc.jdbc.JdbcResponse.writeBinary(JdbcResponse.java:88)
>  at org.apache.ignite.internal.processors.odbc.jdbc.JdbcMessageParser.encode(JdbcMessageParser.java:91)
>  at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:198)
>  at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:48)
>  at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279)
>  at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109)
>  at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97)
>  at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120)
>  at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70)
>  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>  at java.lang.Thread.run(Thread.java:748)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)