Hi,

We have a process that launches multiple BCP process.
In this scenario, we have observed the following error:

"
Start loading, table="FOO",
file="./FOO_1.dmp":
Fatal error: memory allocation failed.
End loading.


"

Now, when we run bcp manually, the problem does not appear.

Can anyone explain why we would be getting this problem?
I understand that there was a problem with bcp on 12.5.1 and the patc
has been applied.

Any help would be most appreciated.

thanks

Pipon
-
piponist
-----------------------------------------------------------------------
Posted via http://www.webservertalk.co
-----------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message328992.htm

Hi There,

I recently encountered this problem (it was intermittent) ... it seems
to be a known BUG ... you do not mention the version of SYBASE nor
platform but here is the write-up ... look up the below BUG number and
see if you can upgrade your Open Client ... I upgraded to SDK
12.5/P-EBF11488 ESD #14 on Solaris and the problem disappeared ...

Hope this helps!!

Sara ...

Case Description:
Receiving the error message "Fatal error: memory
allocation failed"
when running the 'bcp in' utility with the batch size of
10000.

Tip or Workaround:
Workarounds:

1) Use a smaller batch size. In other words, use -b1000
or -b100
instead of -b10000.

2) Remove any restrictions for memory allocation. In
other words,
"ulimit -v unlimited" or "limit memorysize unlimited".

3) Revert to a version of bcp that does not have this
problem.

Resolution:
This problem relates to Sybase bugs CR 261087 and CR
299879.

CR 261087 reads, "BCP: eliminates memory allocation errors
for large
batch sizes (when doing BCP IN)". This bug was fixed in
Open Client/
bcp 12.5 ESD#3, but that solution only partially fixed the
problem
in bcp 12.5. That fix existed in version 12.5 ESD#3 -
ESD#7 of Open
Client/ bcp. It was removed in ESD#8 and ESD#9, and a new
CR 299879
was issued.

CR 299879 reads: "bcp allocates huge chunks of memory when
large
batch size specified w/ -b flag". This bug is fixed as of
Open
Client/ bcp 12.5 ESD#10.

Resolutions: EBF workaround upgrade


piponista <piponista.1a6g9o (AT) mail (DOT) webservertalk.com> wrote