Difference: TroubleshootingGuide (21 vs. 22)

Revision 222012-03-23 - EricFrizziero

Line: 1 to 1
META TOPICPARENT name="SystemAdministratorDocumentation"

Troubleshooting guide for CREAM

Line: 386 to 386
  see: http://wiki.italiangrid.org/twiki/bin/view/CREAM/SystemAdministratorGuideForEMI1#3_3_MySQL_database_How_to_resize

0.1 InnoDB: Problem with the log file sizes.

If the following error occurs (see the mysql log file: /var/log/mysqld.log):

InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
or a similar one:
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 67108864 bytes! 

then the "innodb_log_file_size" property has been changed without moving the log files ib_log* to some place out of the the directory where the log files reside.

Follow these steps (see http://wiki.italiangrid.org/twiki/bin/view/CREAM/SystemAdministratorGuideForEMI1#3_3_MySQL_database_How_to_resize):

  • Stop the server.
    service mysqld stop
  • Move the log file sizes ib_log* to some place out of the the directory where the log files reside. Example:
    mv /var/lib/mysql/ib_logfile* /tmp
  • Start the server.
    service mysqld start
  • Check for errors in /var/log/mysqld.log file
  • Verify the correct size of the log files
    ls -lrth /var/lib/mysql/ib_logfile*

0.1 copyNewProxyToSandbox error: sudo: no tty present and no askpass program specified

This site is powered by the TWiki collaboration platformCopyright © 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback