MySQL backend defaults to BLOB, wich is not large enough for some images

Bug #1496687 reported by Martin Paulo
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
First App Application For OpenStack
Fix Released
Undecided
Martin Paulo

Bug Description

If you run the faafo application with a MySQL back end, some of the images are not shown by the api server. It turns out that this is caused by MySQL truncating the images as they are not large enough to fit into the BLOB column generated by SqlAlchemy. A larger type is needed for the this column.

Changed in faafo:
assignee: nobody → Martin Paulo (martin-paulo)
summary: - MySQL backend defaults to BLOB, wich is not large enough for some image
+ MySQL backend defaults to BLOB, wich is not large enough for some images
Revision history for this message
Martin Paulo (martin-paulo) wrote :

I have submitted a fix via gerrit. It's not horribly elegant, but not knowing the technology stack it serves to at least illustrate one solution to the problem

Tom Fifield (fifieldt)
Changed in faafo:
status: New → Fix Committed
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to faafo (master)

Reviewed: https://review.openstack.org/224443
Committed: https://git.openstack.org/cgit/stackforge/faafo/commit/?id=d62251c1a5a99daf1e471d59d73eeb8b671c4e15
Submitter: Jenkins
Branch: master

commit d62251c1a5a99daf1e471d59d73eeb8b671c4e15
Author: Martin Paulo <email address hidden>
Date: Thu Sep 17 15:46:29 2015 +1000

    Use MEDIUMBLOB column when storing fractals in MySQL

    Closes-bug: #1496687

    Change-Id: I7e1298c3362f73c43900ac82b14958afa217f02b

Revision history for this message
Tom Fifield (fifieldt) wrote :
Changed in faafo:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.