API call from AIrflow queuing the Matillion Job in Pending state

Matillion ETL
1

Hi,

I am trying to call Matillion via Airflow API call. The job is getting in to Pending state. It is not even triggering or queuing the job to run. Having this issue in the UAT server. API call in DEV was working right.

069Tm0000009FavIAE_0D5Tm000000keRZKAY
069Tm0000009FavIAE_0D5Tm000000keRZKAY828×128 9.13 KB

Would someone be able to help with explaining whats the issue and resolution.

Thanks!

2

Hi @prina.shah​

Looks like the job is in a queued state. This usually means:

  • The instance is already running the max jobs per instance (16), OR
  • The job is already running (see earlier tasks) and only one instance of a specific, named job can run at a given moment.

Cheers,

Chika

3

Thanks for the response Chika.

1.We dont have limit on the number of instance running should be 16.

2.Here, No jobs were running when this instance got into pending state. Irregardless if job is running or not, it was going into pending state.

Thanks!

4

Hi @prina.shah​

Do you have jobs running in other projects that you're not aware of? You can only see the tasks running the project you currently have open.

If none, definitely a bug, and opening support case would be best.

Thanks,

Chika