Autarchy of the Private Cave

• Categories

  Select Category*nixAffiliate programsArtificial Intelligence   Agents   Machine learning   Robotics   TechnologiesBooksComparisonHardwarehow-toHumourKyivLifeLinksMiscMoviesNotepadPersonalProgramming   Ada   OS   PHP   Python   XHTML/CSSqotdRantScience   Bioinformatics   Systems BiologySocietySoftware   SecurityStartupsUkraineWeb   CMS   Drupal   WP PlugInsWelfare

• Tags list

  blog btrfs bug CMS convert data database Debian development drupal example ffmpeg FireFox fix free gallery2 git google HDD hosting how-to http linux microarray module mysql package performance PHP plugin problem project management Python R repository server shared hosting spam statistics tool Ukraine update upgrade windows wordpress

• Related entries

  No related content found.

• Subscribe

  

  Subscribe to RSS feed.

  Desktop Reader Bloglines Feedly Live Netvibes Yahoo!

• Archives

  Select Month December 2022 October 2022 October 2018 August 2018 July 2018 September 2017 August 2017 February 2017 December 2016 June 2016 May 2016 April 2016 March 2016 February 2016 January 2016 December 2015 July 2015 May 2015 April 2015 March 2015 February 2015 October 2014 September 2014 August 2014 April 2014 March 2014 January 2014 December 2013 November 2013 October 2013 August 2013 July 2013 June 2013 August 2012 June 2012 May 2012 February 2012 January 2012 December 2011 October 2011 August 2011 May 2011 April 2011 March 2011 February 2011 January 2011 December 2010 November 2010 October 2010 September 2010 August 2010 July 2010 June 2010 May 2010 April 2010 March 2010 February 2010 January 2010 December 2009 November 2009 October 2009 September 2009 August 2009 July 2009 June 2009 May 2009 April 2009 March 2009 February 2009 January 2009 December 2008 November 2008 October 2008 September 2008 August 2008 July 2008 June 2008 May 2008 April 2008 March 2008 February 2008 December 2007 November 2007 October 2007 September 2007 August 2007 July 2007 June 2007 May 2007 April 2007 March 2007 February 2007 January 2007 December 2006 November 2006 October 2006 September 2006 August 2006 July 2006 June 2006

• Recent comments

  • JT on How to truncate git history (sample script included)
  • Charlotte Semaan on How to fix: Xiaomi Mi Band stopped tracking steps and sleep
  • SAM on How to fix: Xiaomi Mi Band stopped tracking steps and sleep
  • SY on Convert MySQL database from one encoding/collation into another
  • Bogdan on Citation and reference managers for Linux: short overview

• Meta

  • Log in

Gallery2 ERROR_STORAGE_FAILURE fix

1st October 2006

I do not know why, but I’m getting this error from time to time in my gallery… It seems to behave like a measure of entropy
To fix it when “entropy broke loose” the first time, I did some searching and found the solution in different topics of the official gallery2 forum. The text below was prepared based on forum searches and the official gallery2 FAQ.

If you get ERROR_STORAGE_FAILURE from your Gallery2 installation, when adding new photos or creating albums, then most probably there is a problem in a mysql database with the g2_SequenceId table.

To fix this, find the g2_SequenceId table (using any method you like – mysql command-line interface, phpMyAdmin, SQLyog etc) and list table rows.

• If there are multiple rows – delete all the rows except the one with the largest value.
• If there is a single row:
  1. run the query: select max(g_id) from g2_Entity;
  2. edit the one row you have in g2_SequenceId – change the value to be one larger than the maximum id reported in the query above.

Note that the errors received previously may have left directories and files inside your g2data/albums directory that are not displayed by Gallery. To complete the cleanup from this problem the items not shown when browsing the gallery as a site admin should be removed (backup recommended before proceeding).

This entry was posted on Sunday, October 1st, 2006 at 1:10 and is filed under Programming, Web. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

3 Responses to “Gallery2 ERROR_STORAGE_FAILURE fix”

1. Damien Says:
   July 8th, 2009 at 0:44

   I was having a similar error and it turned out that one of my log files grew too large and corrupted the mysql data_base_ for the gallery, which was on the same partition. I was getting this error in the mysql log:
   090707 10:38:04 [ERROR] /usr/libexec/mysqld: Can't open file: 'g2_CacheMap.MYI' (errno: 145)

   I was fortunately able to repair the table and the gallery worked fine.
   REPAIR TABLE g2_CacheMap;

   Hope this helps someone. I wasn’t able to find a similar error with google for the Gallery2.

2. sujon Says:
   May 6th, 2010 at 9:43

   Damien, u are a life saver

3. Bry Says:
   February 16th, 2011 at 11:24

   Brilliant. Solved the problem for me.

Leave a Reply