APT_Buffer_Operator: Add block to queue failed.

itznitin · Post by **itznitin** » Thu Oct 06, 2005 6:27 am

Below is the error that i get when i run a PX job -
APT_Buffer_Operator: Add block to queue failed. This means that your buffer filesystems all ran out of space. Please ensure that you have sufficient scratchdisks.

Can you please let me know how I can and where i need to change the parameter so that i can assign a different(larger) filesystem for the PX scratchdisk?

ArndW · Post by **ArndW** » Thu Oct 06, 2005 7:03 am

Have you looked at your APT_CONFIG file?

fridge · Post by **fridge** » Thu Oct 06, 2005 3:53 pm

this often means that it cant write a scratch file (used in merge, sorting etc)
check disk space - when job running - we hit this and an 'annoyying thing about px is it can clean up nicely if job aborts' so removed tmp files - so cant always see if disk full once job completes.

also can be caused (i think) on aix if heap not configured as px halts at 1 gig files