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

[jira] [Created] (IGNITE-11429) rror on queryng IGNITE.LOCAL_SQL_RUNNING_QUERIES SQL view

Yury Gerzhedovich created IGNITE-11429:
------------------------------------------

             Summary: rror on queryng IGNITE.LOCAL_SQL_RUNNING_QUERIES SQL view
                 Key: IGNITE-11429
                 URL: https://issues.apache.org/jira/browse/IGNITE-11429
             Project: Ignite
          Issue Type: Bug
            Reporter: Yury Gerzhedovich


Need to fix TIMESTAMP_WITH_TIMEZONE issue in the LOCAL_SQL_RUNNING_QUERIES view.

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)

Re: [jira] [Created] (IGNITE-11429) rror on queryng IGNITE.LOCAL_SQL_RUNNING_QUERIES SQL view

Posted by Dmitriy Pavlov <dp...@apache.org>.
Hi Igniters,

please be careful with ticket creation, In case you creating a ticket by
mistake, resolve and close it as won't fix.

Now I see two https://issues.apache.org/jira/browse/IGNITE-11429 and
https://issues.apache.org/jira/browse/IGNITE-11430 - it is the same ticket.

Also if you expect an issue to be picked up by someone, please discuss it
here. Without it, created tasks will probably become useless objects
hanging in JIRA forever.

Sincerely,
Dmitriy Pavlov

ср, 27 февр. 2019 г. в 11:49, Yury Gerzhedovich (JIRA) <ji...@apache.org>:

> Yury Gerzhedovich created IGNITE-11429:
> ------------------------------------------
>
>              Summary: rror on queryng IGNITE.LOCAL_SQL_RUNNING_QUERIES SQL
> view
>                  Key: IGNITE-11429
>                  URL: https://issues.apache.org/jira/browse/IGNITE-11429
>              Project: Ignite
>           Issue Type: Bug
>             Reporter: Yury Gerzhedovich
>
>
> Need to fix TIMESTAMP_WITH_TIMEZONE issue in the
> LOCAL_SQL_RUNNING_QUERIES view.
>
> 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)
>