RESOLVED!! - ERROR_OBSOLETE_DATA error that started as an ERROR_LOCK_TIMEOUT error

This issue is RESOLVED. See the last post for information on what I did to fix it. (THANKS JOE7 FOR YOUR HELP!)

The problem: When trying to access my gallery2 site, I get the below error message.

The steps leading up to the problem: I uploaded about 50 pictures via ftp to my server. I then added them all to an album. Next, I went to transfer about half of them to a new album. That process blew up and threw an error titled "ERROR_LOCK_TIMEOUT." After several attempts, I did manage to transfer the photos to the new album. However, two remained stuck in the original album AND appeared in the new one. I tried to delete the files from the original album. No luck. I got the same lock timeout error. I tried from the new album. No luck. Same thing. Further, when I tried to delete them from the original album, I would be taken to the delete screen for the new album images. Looking on the server using an FTP program, I discovered that those two files had never made their way from the upload folder over to either the original or the new album. I tried moving them from the upload folder to the new album. Doing that allowed me to delete them from the new album. They still appeared in the original album, though. Trying to delete them out of the original album brought me to where I am now.

The things I have tried since I received the obsolete_data error:
Clearing the cache both through the lib/support/?cache route and the site administration panel. The only thing I didn't clear was the thumbnails and resizes since I have several thousand photos on my site.

Deleting the data in the g2_lock table. No change.

Looking through the support literature and the forums. Didn't find anything that seemed to be directly related to what I'm having troubles with at the moment.

IRC channel. No one responded in the last hour.

Here on the forums. I'm writing this now!

Error Message:
Error (ERROR_OBSOLETE_DATA) : UPDATE g2_Derivative SET g_isBroken=? WHERE g_id=? (1|18496)

* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 364 (GalleryCoreApi::error)
* in modules/core/classes/GalleryStorage.class at line 309 (GalleryStorageExtras::saveEntity)
* in modules/core/classes/GalleryEntity.class at line 294 (GalleryStorage::saveEntity)
* in modules/core/classes/GalleryDerivative.class at line 240 (GalleryEntity::save)
* in modules/core/classes/helpers/GalleryDerivativeHelper_advanced.class at line 845 (GalleryDerivative::save)
* in modules/core/classes/GalleryCoreApi.class at line 914 (GalleryDerivativeHelper_advanced::rebuildCache)
* in modules/core/classes/GalleryTheme.class at line 1552 (GalleryCoreApi::rebuildDerivativeCache)
* in themes/carbon/theme.inc at line 177 (GalleryTheme::loadCommonTemplateData)
* in modules/core/classes/GalleryTheme.class at line 926 (CarbonTheme::showAlbumPage)
* in modules/core/classes/GalleryView.class at line 308 (GalleryTheme::loadTemplate)
* in main.php at line 445 (GalleryView::doLoadTemplate)
* in main.php at line 94
* in main.php at line 83

System Information
Gallery version 2.2.5
PHP version 5.2.6 cgi-fcgi
Webserver Apache/2.2.9 (Unix) PHP/4.4.7 mod_ssl/2.2.9 OpenSSL/0.9.8c mod_fastcgi/2.4.6 DAV/2
Database mysqli 5.0.67-log
Toolkits ImageMagick, NetPBM, Gd
Operating system Linux scalise 2.6.24.5-serf-xeon-c6.1-grsec #2 SMP Fri Aug 1 14:00:32 PDT 2008 x86_64
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1

Website URL: http://www.douglasvanbossuyt.com/gallery2/

Gallery information:
Gallery version = 2.2.5 core 1.2.0.7
PHP version = 5.2.6 cgi-fcgi
Webserver = Apache/2.2.9 (Unix) PHP/4.4.7 mod_ssl/2.2.9 OpenSSL/0.9.8c mod_fastcgi/2.4.6 DAV/2
Database = mysqli 5.0.67-log, lock.system=database
Toolkits = ArchiveUpload, Exif, Ffmpeg, NetPBM, Gd, ImageMagick, jpegtran
Acceleration = none, none
Operating system = Linux scalise 2.6.24.5-serf-xeon-c6.1-grsec #2 SMP Fri Aug 1 14:00:32 PDT 2008 x86_64
Default theme = carbon
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1
Rows in GalleryAccessMap table = 36
Rows in GalleryAccessSubscriberMap table = 1542
Rows in GalleryUser table = 2
Rows in GalleryItem table = 1541
Rows in GalleryAlbumItem table = 27
Rows in GalleryCacheMap table = 0

File integrity info: I deleted the "upgrade" folder so that shows up as an error. I do get this error, however. Warning: Output buffering is enabled in your PHP by the output_buffering parameter(s) in php.ini. Gallery can function with this setting - downloading files is even faster - but Gallery might be unable to serve large files (e.g. large videos) and run into the memory limit. Also, some features like the progress bars might not work correctly if output buffering is enabled unless ini_set() is allowed. I am hosted on Dreamhost who turns that on for all users to speed their servers up.

PHPINFO: Available if needed. (Are there any security concerns with posting that information publicly?)

RESOLVED!!!

Joe7 (THANKS!) helped me out in the IRC channel.

What we did to resolve the issue:

Looking at the error messages, Joe7 suggested that I run a query on my database. I opened up phpmyadmin, logged in, and ran the following query: SELECT * FROM g2_Derivative WHERE g_id=YOURIDNUMBERHERE where YOURIDNUMBERHERE comes from the error information as to which ID is having a problem.

The result showed up as one of my entries having an error. The g2_isBroken was already set to "1" which was throwing the error (although I am informed that it should not). I reset it to "0" and all of my problems went away! Well, actually then a second ID popped up with the same problem. I followed the same procedure and it, too, was vanquished.

Thanks again, Joe7!