Re: Mysql não sobe no lenny

2007/10/8, Ademir Lima <adellima@gmail.com>:

Instalei o mysql (aptitude install mysql-server) no lenny, instalou
sem erro algum, inciou o serviço sem erros também, mas logo apos o
primeiro boot, não levanta de maneira alguma.

root#/etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

e se faço assim:

root#mysqld
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11

repete isto vaaaarias vezes e no final:

InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
071008 22:24:08 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
071008 22:24:08 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
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!
071008 22:24:08 [ERROR] Can't start server: Bind on TCP/IP port:
Address already in use
071008 22:24:08 [ERROR] Do you already have another mysqld server
running on port: 3306 ?
071008 22:24:08 [ERROR] Aborting

nos logs não aparecem nada. Já alterei o my.cnf para:

.
.
.
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/mysql/
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

Mas sem nenhum sucesso.

--
Porque dele, por ele, para ele são todas as coisas;
a Ele a glória eternamente.
Amém.
---------