Problem with BLOB image retrieval

[cinthara]

We are on Coldfusion 9,0,1,274733. I checked on "Enable binary large object retrieval (BLOB)" on the database but the image is still cut off (3/4 partly grey). On our dev server it works perfectly, our production server just gives off the partly grey images. I checked the CF database settings between dev and production and they are exactly the same. We restarted the server but still the same problem. It is like Coldfusion doesn't see the setting changes. Anyone else has this problem?

[insuractive]

Have you verified that the length of the data in the production database matches the length of the data in your dev database (i.e. that the problem is with CF and not the database itself)?

[cinthara]

Yes, the length of the data is exactly the same on both dev and production. If the image is really small like 20KB, it will render. It is so strange that it just doesn't see the setting change.

[cinthara · Accepted solution]

We found the solution. Our production servers are in a clustered environment. You have to enable "Enable binary large object retrieval (BLOB)" at the instance cluster level. You will have to do this change on all the instances in the cluster. I was only enabling it at the "local" level on each server in the cluster (which didn't work).

In CF Admin:

Enterprise Manager > Instance Manager > select the instance and enable BLOB

[insuractive]

cinthara - thanks for posting that solution.  That is probably going to save some poor soul hours of troubleshooting trying to figure out why his/her clustered servers are ruining the data.

[cinthara]

You will probably enjoy this then:

http://xkcd.com/979/

[insuractive]

I did. XKCD is awesome. Hopefully some other forum members saw that too. (unfortunately) too true.