pvinodp
asked on
service mysqld restart FAILS
On my linux Red hat when i type
service mysqld restart, it fails. I tried changing many settings. Then finally i tried removing the sentence
[mysqld]
default_storage_engine=Inn oDB
from /etc/my.cnf and it worked. WOW.
But this seems to be the issue in my system alone.
My colleague's system does not have such problems. I can restart mysqld service on his system with the above sentence in /etc/my.cnf. Both are running the same version of mysql 5.0.77.
Any help?
service mysqld restart, it fails. I tried changing many settings. Then finally i tried removing the sentence
[mysqld]
default_storage_engine=Inn
from /etc/my.cnf and it worked. WOW.
But this seems to be the issue in my system alone.
My colleague's system does not have such problems. I can restart mysqld service on his system with the above sentence in /etc/my.cnf. Both are running the same version of mysql 5.0.77.
Any help?
Did you check the logs in /var/log if an error is mentioned there?
ASKER
Hi,
I checked the mysqld.log. Following is the error i see when i cannot restart mysqld service:
110322 15:27:19 mysqld started
110322 15:27:19 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
110322 15:27:19 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
110322 15:27:19 Default storage engine (InnoDB) is not available
110322 15:27:19 Aborting
110322 15:27:19 [Note] /usr/libexec/mysqld: Shutdown complete
110322 15:27:19 mysqld ended
I checked the mysqld.log. Following is the error i see when i cannot restart mysqld service:
110322 15:27:19 mysqld started
110322 15:27:19 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
110322 15:27:19 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
110322 15:27:19 Default storage engine (InnoDB) is not available
110322 15:27:19 Aborting
110322 15:27:19 [Note] /usr/libexec/mysqld: Shutdown complete
110322 15:27:19 mysqld ended
Please show your mysql config file
ASKER
It is the same as my coleague's:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysq l.sock
user=mysql
old_passwords=1
[mysqld_safe]
log-error=/var/log/mysqld. log
pid-file=/var/run/mysqld/m ysqld.pid
[mysqld]
default_storage_engine=Inn oDB
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysq
user=mysql
old_passwords=1
[mysqld_safe]
log-error=/var/log/mysqld.
pid-file=/var/run/mysqld/m
[mysqld]
default_storage_engine=Inn
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
But my colleagues system works without these..
how is it possible..this app has to be deployed in thousands of client systems... most of the my.cnf
which i have see do not have more information than mine.
Is there any other setting which has changed in my system?
how is it possible..this app has to be deployed in thousands of client systems... most of the my.cnf
which i have see do not have more information than mine.
Is there any other setting which has changed in my system?
copy working config from your colleague`s and try
ASKER
tried.. dint work
ASKER
i assume that you are talking about /etc/my.cnf file.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
if my.cnf is having problem, try to locate .cnf file in the system,
by default .cnf file is located in /usr/share/doc/MySQL-serve r-communit y-5.0.83/m y-medium.c nf
rename my-medium.cnf to my.cnf in /etc/ folder...try to start the mysql service.
if my.cnf is having problem, try to locate .cnf file in the system,
by default .cnf file is located in /usr/share/doc/MySQL-serve
rename my-medium.cnf to my.cnf in /etc/ folder...try to start the mysql service.
ASKER
Thanks all