• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tGreenplumOutput fails with writer gang busy

#1 2011-07-14 02:45:17

chandra1
New member
Registered: 2010-10-22
Posts: 9

tGreenplumOutput fails with writer gang busy

Hi All,

I am getting the below error in greenplum output component

Exception in component tGreenplumOutput_7
org.postgresql.util.PSQLException: ERROR: Statement Error, writer gang busy: possible attempt to execute volatile function in unsupported context (cdbdisp.c:496)
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
        at zq.page_views_job_1_1.page_views_job.tPostgresqlInput_4Process(page_views_job.java:4010)
        at zq.page_views_job_1_1.page_views_job.tGreenplumInput_1Process(page_views_job.java:1360)
        at zq.page_views_job_1_1.page_views_job.tPrejob_1Process(page_views_job.java:546)
        at zq.page_views_job_1_1.page_views_job.runJobInTOS(page_views_job.java:6370)
        at zq.page_views_job_1_1.page_views_job.runJob(page_views_job.java:6257)
        at zq.page_view_main_0_1.page_view_main.tWaitForSqlData_1Process(page_view_main.java:508)
        at zq.page_view_main_0_1.page_view_main.tGreenplumConnection_1Process(page_view_main.java:343)
        at zq.page_view_main_0_1.page_view_main$1.run(page_view_main.java:746)

Please help

Offline

#2 2011-07-14 04:39:28

shong
Talend team
Registered: 2007-08-29
Posts: 10350
Website

Re: tGreenplumOutput fails with writer gang busy

Hi
it was a bug on Gleenplum database, issue 6632 and 6867, see
http://media.gpadmin.me/wp-content/uplo … README.pdf

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2011-07-14 06:25:45

chandra1
New member
Registered: 2010-10-22
Posts: 9

Re: tGreenplumOutput fails with writer gang busy

Thanks for reply.
I am using Greenplum 4.0.4.0

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tGreenplumOutput fails with writer gang busy

Board footer

Powered by FluxBB