LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 08-17-2012, 05:13 AM   #1
mccabec123
LQ Newbie
 
Registered: Jul 2012
Posts: 4

Rep: Reputation: Disabled
Unhappy Issue Starting MySQL Daemon


I have just come across the most random error I've seen my MySQL daemon spew out yet, everything was working fine, then all of a sudden it randomly crashed and it now outputting this when I start it up, not sure if it's because my 'my.cnf' file is minimal

Here's my 'my.cnf':

Code:
[mysqld]
    # Settings user and group are ignored when systemd is used.
    # If you need to run mysqld under different user or group,
    # customize your systemd unit file for mysqld according to the
    # instructions in http://fedoraproject.org/wiki/Systemd
    datadir=/var/lib/mysql/
    socket=/var/lib/mysql/mysql.sock
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
Here's the errors:

Code:
120817  3:47:26 [Note] Plugin 'FEDERATED' is disabled.
    120817  3:47:26 InnoDB: The InnoDB memory heap is disabled
    120817  3:47:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    120817  3:47:26 InnoDB: Compressed tables use zlib 1.2.5
    120817  3:47:26 InnoDB: Using Linux native AIO
    120817  3:47:26 InnoDB: Initializing buffer pool, size = 128.0M
    120817  3:47:26 InnoDB: Completed initialization of buffer pool
    InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
    InnoDB: 384 pages (rounded down to MB) than specified in the .cnf file:
    InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
    120817  3:47:26 InnoDB: Could not open or create data files.
    120817  3:47:26 InnoDB: If you tried to add new data files, and it failed here,
    120817  3:47:26 InnoDB: you should now edit innodb_data_file_path in my.cnf back
    120817  3:47:26 InnoDB: to what it was, and remove the new ibdata files InnoDB created
    120817  3:47:26 InnoDB: in this failed attempt. InnoDB only wrote those files full of
    120817  3:47:26 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
    120817  3:47:26 InnoDB: remove old data files which contain your precious data!
    120817  3:47:26 [ERROR] Plugin 'InnoDB' init function returned error.
    120817  3:47:26 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    120817  3:47:26 [ERROR] mysqld: unknown variable 'max_used_connections=0'
    120817  3:47:26 [ERROR] Aborting
    
    120817  3:47:26 [Note] mysqld: Shutdown complete
Any help would be greatly appreciated, thanks guys!
 
Old 08-17-2012, 06:14 AM   #2
dinkus223
LQ Newbie
 
Registered: Aug 2010
Location: Memphis, 10
Distribution: Rotates on weekly or monthly basis
Posts: 22

Rep: Reputation: 3
With a minimum config file and sudden crash, I suspect that it is something simple, without reviewing your config file. A little googling brought up https://forums.mysql.com/read.php?22...055#msg-241055. [URL="http://onaxer.com/blog/blog/tag/error-plugin-innodb-init-function-returned-error/"]. For confirmation, http://onaxer.com/blog/blog/tag/erro...eturned-error/ has a more detailed, if you will, explanation. Also make sure that only one config file is referenced: /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf.
 
  


Reply

Tags
daemon, dedicated, fedora, mysql, server


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
problem starting mysql daemon linuxandtsm Linux - Newbie 3 04-05-2012 01:32 PM
error in starting mysql daemon after installation possimpible Linux - Software 6 09-10-2009 01:08 AM
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 06:23 AM
Starting mysql daemon as user rather than root arubin Slackware 8 05-10-2004 04:03 PM
Starting Up MySQL daemon tuka Linux - Software 2 08-06-2003 11:45 AM


All times are GMT -5. The time now is 05:15 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration