The `generateExposedTask` has been stuck for more ...

# exposed

[dave08]

The generateExposedTask has been stuck for more than half-an-hour without crashing nor telling me what's wrong... how can I debug this?

[dave08]

It seems like it does take hours to process the tables but it doesn't spit out any code in the meantime? Sp in the end I just stop it, and I'm left with nothing...

[dave08]

I used --debug to see the progress...

[Bogdan]

can you provide DDL? Also worth making an issue

[tapac]

How much tables do you have in a schema? Did you run task for all table or only for some of them?

[dave08]

151 tables, ran for all of them, but with limited permissions

[dave08]

Since most depend on each other, I can't import them separately

[dave08]

And most are created by the frontend "OroPlatform" ui.

[tapac]

I guess there can by cyclic bug in that case.
Do you have cyclic dependencies in your tables?

[dave08]

Don't think so, at least not in our tables, but I can't promise that the OroPlatform didn't have any.

[dave08]

But the db is very big, (maybe 30gb). And there might be latency since the db's running on our k8s cluster, and I'm using kubectl port-forward to communicate.

[tapac]

The db size should not matter as only db metadata (like tables/columns/indices names) will be extracted.

[dave08]

SELECT and SHOW_VIEW privileges are enough?