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

[Anton Vinogradov (Jira)]

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)

[Dmitry Pavlov]

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) <[hidden email]>:

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