Hello,
Could you please collect thread dumps from the servers and send them
together with the logs while the query is hanging?
-
Denis
On Tue, Feb 11, 2020 at 5:22 AM pg31 <singhhoneyyo...@gmail.com> wrote:
> Hi
>
> I am running a long query using JDBCThin Client.
> It is a CREATE INDEX query and it takes upto 20 minutes.
>
> After, that I see using DBeaver that the Index is created.
> I login into my Ignite Cluster and see that all the operations have been
> completed (i.e. there are NO WAL updates happening, Checkpoints are all
> done
> (since I see the message skipping checkpoints as there are no dirty pages))
>
> But the above Query does not exit i.e. it keeps on running for hours. Seems
> like the above query is kind of stuck.
>
> val conn = DriverManager.getConnection(jdbcURL)
> val stmt = conn.createStatement()
> Logger.LogInfo(s"Executing:${sqlQuery}")
> stmt.execute(sqlQuery)
>
>
> Running the same query on smaller tables succeeds.(i.e. it returns)
> The table on which I am running this query has around 60Million records
> (This is the query:
> CREATE INDEX IDX_V1 ON MY_TABLE (MY_COL ASC) PARALLEL 16)
>
> I have tried it both with and without parallel.
> Please let me know if anything else is required.
>
> Thank You
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
