Explanation to g2_SequenceEventLog table?

RaWeN
RaWeN's picture

Joined: 2003-06-02
Posts: 11
Posted: Sat, 2012-02-11 10:49

Ive got a problem with mysql crashing when gallery is accessing some table in the gallery2 database. (see mysqld error log below). From what i understand of the log file is that the g2_sequenceEventLog is crashed, but i cant seem to recover it.

For some reason theres only one value in the table (se mysql readout below), is that normal or just because gallery cant put any more values in the table? What can i do to fix this problem?


mysql readout of g2_SequenceEventLog:

mysql> SELECT * FROM g2_SequenceEventLog;
+--------+
| id |
+--------+
| 908748 |
+--------+
1 row in set (0.00 sec)

mysql>


mysqld-error.log:

120211 11:07:49 InnoDB: Rollback of non-prepared transactions completed
120211 11:10:14 [ERROR] /usr/sbin/mysqld: Table './gallery2/g2_SequenceEventLog' is marked as crashed and should be repaired
120211 11:10:14 [Warning] Checking table: './gallery2/g2_SequenceEventLog'
120211 11:11:41 InnoDB: Assertion failure in thread 140585757865728 in file ../../../storage/innobase/btr/btr0pcur.c line 402
InnoDB: Failing assertion: btr_page_get_prev(next_page, mtr) == buf_frame_get_page_no(page)


Gallery version = 2.3.1 core 1.3.0.1
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.3.3-7+squeeze7 apache2handler
Webserver = Apache/2.2.16 (Debian)
Database = mysqli 5.1.49-3-log, lock.system=flock
Toolkits = ArchiveUpload, Exif, Getid3, ImageMagick, LinkItemToolkit, Thumbnail, Ffmpeg, jpegtran, Dcraw
Acceleration = full/900, none/0
Operating system = Linux 2.6.32-5-amd64 #1 SMP Mon Jan 16 16:22:28 UTC 2012 x86_64
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows NT 5.1; rv:10.0) Gecko/20100101 Firefox/10.0
Rows in GalleryAccessMap table = 4306
Rows in GalleryAccessSubscriberMap table = 103901
Rows in GalleryUser table = 43
Rows in GalleryItem table = 103835
Rows in GalleryAlbumItem table = 2103
Rows in GalleryCacheMap table = 33458
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Sat, 2012-02-11 14:08

If you cannot repair that table, try dropping it.

To re-create assumes your table prefix is "g2_"

DROP TABLE IF EXISTS `g2_SequenceEventLog`;
CREATE TABLE IF NOT EXISTS `g2_SequenceEventLog` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2