Create table not finishing - Query with 10 subqueries with joins/union/transformation

[jgrover21]

Description

I have a query built that has 10 subqueries which are running just fine independently...but when I want to create a table it keeps running for full day and half and still not return...

DBeaver Version

23.0.5

Operating System

windows

Database and driver

postgresql 14.0

Steps to reproduce

No response

Additional context

No response

[E1izabeth]

Probably, connected with #20060

[E1izabeth]

Thank you for bug report.

Could you send log files? You can find instructions here https://dbeaver.com/docs/wiki/Log-files/

[astroalph]

SQL Error [57014]: ERROR: canceling statement due to user request.
Query is taking long time to execute so cancelling to terminate the process.

[E1izabeth]

Thank you. I'm closing this issue as a duplicate of #20060
You can follow that issue to be notified on updates.

[jgrover21]

Is there any solution out there? I noticed this issue listed. Respectfully, Jyoti Grover

[E1izabeth]

@jgrover21
Unfortunately, I don't see any workaround. Hope we will fix it soon. The issue is related to JSQLParser library which we use.

[jgrover21]

Ok thank you. Respectfully, Jyoti Grover

[E1izabeth]

By the way, DBeaver 23.0.0 doesn't have this bug.

[jgrover21]

Can we revert back to this version? Respectfully, Jyoti Grover

[E1izabeth]

You can find this version in our versions archive and install it, while the issue is not solved
https://dbeaver.io/files/23.0.0/

[jgrover21]

This is even slower to export. Respectfully, Jyoti Grover

[E1izabeth]

Does your case similar to provided in this comment?
#20060 (comment)

[E1izabeth]

@jgrover21 could you try Early Access version https://dbeaver.io/files/ea/? Does the issue is solved there?