[Building Sakai] problem with BLOB table in Sakai DB

[Jim Eng]

Yes. The content bodies are copied to files in the filesystem, and once the conversion is complete, Content Hosting starts using those files instead of the content bodies in the database.  Once you are confident that the conversion succeeded, you should do two things:

1) remove the convertToFile property from sakai.properties for your next restart.

2) null out the database table containing the binaries.  

Jim


On May 11, 2010, at 9:46 AM, Patrick Coleman wrote:

> 
> Thanks guys for all the info on doing this. When I do the changes mentioned
> below, including the patch
> will the content that is now in the DB be moved to the file system?
> 
> Pat.
> 
> 
> There is also this patch you can apply to the kernel to get the fix in your
> environment:
> http://jira.sakaiproject.org/secure/attachment/20141/KNL-164-1.0.x.patch
> 
> You'll need to check out the source and build it though, since the kernel is
> a binary deploy by default.
> 
> cheers,
> Steve
> 
> 
> On 11/05/2010, at 11:31 PM, Steve Swinsburg wrote:
> 
>> As Jim mentioned, you should be able to set this in sakai.properties:
>> 
>> convertToFile at org.sakaiproject.content.api.ContentHostingService = true
>> bodyPath at org.sakaiproject.content.api.ContentHostingService =
>> /usr/local/sakai/kernel/bodyContent/
>> bodyVolumes at org.sakaiproject.content.api.ContentHostingService =
>> vol1,vol2,vol3,vol4,vol5
>> 
>> startup and be on your way.
>> 
>> However:
>> 
>> There is a bug that manifested itself under certain conditions, so
>> resources didn't convert out properly, see comments in KNL-164 and
>> SAK-16146. This is fixed in 2.5.7 and kernel 1.0.14 and later.
>> 
>> What release of Sakai 2.6 are you on? The same issue above affects 2.6
>> however the kernel version for previous 2.6 releases are less than 1.0.14
>> so won't contain the fix... You may need to manually adjust your
>> SAKAI-SRC/master/pom.xml <sakai.kernel.version> to 1.0.14 to get the
>> updated kernel.
>> 
>> cheers,
>> Steve
> 
> -- 
> View this message in context: http://old.nabble.com/problem-with-BLOB-table-in-Sakai-DB-tp28523391p28524283.html
> Sent from the Sakai - Development mailing list archive at Nabble.com.
> 
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
> 
>