OpenVZ Forum


Home » General » Support » mysql installation faillure
mysql installation faillure [message #23628] Wed, 21 November 2007 09:51 Go to next message
mccharlet is currently offline  mccharlet
Messages: 15
Registered: October 2007
Location: Switzerland
Junior Member
Hi,

I'm installed mysql5 in a VE, but i have this error

Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.0; however:
Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-server-5.0
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Thanks for your help


Thanks

Sorry for my english

mccharlet

http://www.ateliernetcreation.com
Re: mysql installation faillure [message #23629 is a reply to message #23628] Wed, 21 November 2007 09:53 Go to previous messageGo to next message
kir is currently offline  kir
Messages: 1645
Registered: August 2005
Location: Moscow, Russia
Senior Member

Please check your /proc/user_beancounters as per http://wiki.openvz.org/Resource_shortage

Kir Kolyshkin
http://static.openvz.org/userbars/openvz-developer.png
Re: mysql installation faillure [message #23633 is a reply to message #23629] Wed, 21 November 2007 10:41 Go to previous messageGo to next message
mccharlet is currently offline  mccharlet
Messages: 15
Registered: October 2007
Location: Switzerland
Junior Member
no failcnt for my VE 102

102: kmemsize 434184 1161431 2752512 2936012 0
lockedpages 0 0 32 32 0
privvmpages 7463 26301 32768 32768 0
shmpages 0 0 8192 8192 0
dummy 0 0 0 0 0
numproc 8 24 65 65 0
physpages 1049 4330 32768 32768 0
vmguarpages 0 0 32768 32768 0
oomguarpages 1049 4330 32768 32768 0
numtcpsock 6 7 80 80 0
numflock 1 4 100 110 0
numpty 0 1 16 16 0
numsiginfo 0 2 256 256 0
tcpsndbuf 0 0 319488 524288 0
tcprcvbuf 0 0 319488 524288 0
othersockbuf 11160 38640 132096 336896 0
dgramrcvbuf 0 0 132096 132096 0
numothersock 8 11 120 120 0
dcachesize 0 0 1048576 1097728 0
numfile 197 481 2048 2048 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
numiptent 10 10 128 128 0




Thanks

Sorry for my english

mccharlet

http://www.ateliernetcreation.com
Re: mysql installation faillure [message #23646 is a reply to message #23633] Wed, 21 November 2007 13:01 Go to previous messageGo to next message
ugob is currently offline  ugob
Messages: 271
Registered: March 2007
Senior Member
Do you see something in the logs?

Please read the manual before asking questions:
http://download.openvz.org/doc/OpenVZ-Users-Guide.pdf

Please have a look at the wiki before asking questions:
http://wiki.openvz.org/Main_Page
Re: mysql installation faillure [message #23650 is a reply to message #23646] Wed, 21 November 2007 13:46 Go to previous messageGo to next message
mccharlet is currently offline  mccharlet
Messages: 15
Registered: October 2007
Location: Switzerland
Junior Member
This is syslog when i installed mysql

Nov 21 15:44:05 102 init: no more processes left in this runlevel
Nov 21 15:51:16 102 mysqld_safe[7878]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Nov 21 15:51:16 102 mysqld_safe[7878]: To do so, start the server, then issue the following commands:
Nov 21 15:51:16 102 mysqld_safe[7878]: /usr/bin/mysqladmin -u root password 'new-password'
Nov 21 15:51:16 102 mysqld_safe[7878]: /usr/bin/mysqladmin -u root -h 102.home.charlet.ch password 'new-password'
Nov 21 15:51:16 102 mysqld_safe[7878]: See the manual for more instructions.
Nov 21 15:51:16 102 mysqld_safe[7878]:
Nov 21 15:51:16 102 mysqld_safe[7878]: Please report any problems with the /usr/bin/mysqlbug script!
Nov 21 15:51:16 102 mysqld_safe[7878]:
Nov 21 15:51:16 102 mysqld_safe[7878]: The latest information about MySQL is available on the web at
Nov 21 15:51:16 102 mysqld_safe[7878]: http://www.mysql.com
Nov 21 15:51:16 102 mysqld_safe[7878]: Support MySQL by buying support/licenses at http://shop.mysql.com
Nov 21 15:51:19 102 mysqld_safe[8020]: started
Nov 21 15:51:19 102 mysqld[8023]: InnoDB: The first specified data file ./ibdata1 did not exist:
Nov 21 15:51:19 102 mysqld[8023]: InnoDB: a new database to be created!
Nov 21 15:51:19 102 mysqld[8023]: 071121 15:51:19 InnoDB: Setting file ./ibdata1 size to 10 MB
Nov 21 15:51:19 102 mysqld[8023]: InnoDB: Database physically writes the file full: wait...
Nov 21 15:51:21 102 mysqld[8023]: 071121 15:51:21 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
Nov 21 15:51:21 102 mysqld[8023]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB
Nov 21 15:51:21 102 mysqld[8023]: InnoDB: Database physically writes the file full: wait...
Nov 21 15:51:21 102 mysqld[8023]: 071121 15:51:21 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
Nov 21 15:51:21 102 mysqld[8023]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB
Nov 21 15:51:21 102 mysqld[8023]: InnoDB: Database physically writes the file full: wait...
Nov 21 15:51:22 102 mysqld[8023]: InnoDB: Error: pthread_create returned 12
Nov 21 15:51:22 102 mysqld_safe[8048]: ended
Nov 21 15:51:34 102 /etc/init.d/mysql[8167]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov 21 15:51:34 102 /etc/init.d/mysql[8167]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov 21 15:51:34 102 /etc/init.d/mysql[8167]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov 21 15:51:34 102 /etc/init.d/mysql[8167]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov 21 15:51:34 102 /etc/init.d/mysql[8167]:

Thanks


Thanks

Sorry for my english

mccharlet

http://www.ateliernetcreation.com
Re: mysql installation faillure [message #23653 is a reply to message #23650] Wed, 21 November 2007 14:06 Go to previous messageGo to next message
ugob is currently offline  ugob
Messages: 271
Registered: March 2007
Senior Member
Have you googled about "pthread_create returned 12"?

http://forums.vpslink.com/archive/index.php/t-405.html


Please read the manual before asking questions:
http://download.openvz.org/doc/OpenVZ-Users-Guide.pdf

Please have a look at the wiki before asking questions:
http://wiki.openvz.org/Main_Page
Re: mysql installation faillure [message #23654 is a reply to message #23653] Wed, 21 November 2007 14:21 Go to previous messageGo to next message
mccharlet is currently offline  mccharlet
Messages: 15
Registered: October 2007
Location: Switzerland
Junior Member
I
mysql.err and mysql.log is empty

No error 12 find

Thanks


Thanks

Sorry for my english

mccharlet

http://www.ateliernetcreation.com
Re: mysql installation faillure [message #23655 is a reply to message #23654] Wed, 21 November 2007 14:23 Go to previous messageGo to next message
kir is currently offline  kir
Messages: 1645
Registered: August 2005
Location: Moscow, Russia
Senior Member

Could it be the case that you are out of disk quota? Please check df -h and df -hi output inside a VE, and increase the quota accordingly if the usage is close to the limit.

Kir Kolyshkin
http://static.openvz.org/userbars/openvz-developer.png
Re: mysql installation faillure [message #23656 is a reply to message #23654] Wed, 21 November 2007 14:28 Go to previous messageGo to next message
ugob is currently offline  ugob
Messages: 271
Registered: March 2007
Senior Member
I took this error from the logs you posted.

Please read the manual before asking questions:
http://download.openvz.org/doc/OpenVZ-Users-Guide.pdf

Please have a look at the wiki before asking questions:
http://wiki.openvz.org/Main_Page
Re: mysql installation faillure [message #23658 is a reply to message #23655] Wed, 21 November 2007 14:41 Go to previous messageGo to next message
mccharlet is currently offline  mccharlet
Messages: 15
Registered: October 2007
Location: Switzerland
Junior Member
This the result from my host server

openvz:~# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 7.5G 1.7G 5.5G 23% /
tmpfs 94M 0 94M 0% /lib/init/rw
udev 10M 52K 10M 1% /dev
tmpfs 94M 0 94M 0% /dev/shm
openvz:~# df -hi
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/sda1 975K 66K 909K 7% /
tmpfs 24K 2 24K 1% /lib/init/rw
udev 24K 389 24K 2% /dev
tmpfs 24K 1 24K 1% /dev/shm
openvz:~#

This is in my VE

root@102:/# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/simfs 1.0G 445M 580M 44% /
tmpfs 94M 0 94M 0% /lib/init/rw
tmpfs 94M 0 94M 0% /dev/shm
root@102:/# df -hi
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/simfs 196K 16K 180K 9% /
tmpfs 24K 2 24K 1% /lib/init/rw
tmpfs 24K 1 24K 1% /dev/shm
root@102:/#

Thanks


Thanks

Sorry for my english

mccharlet

http://www.ateliernetcreation.com
Re: mysql installation faillure [message #23659 is a reply to message #23656] Wed, 21 November 2007 14:44 Go to previous messageGo to next message
mccharlet is currently offline  mccharlet
Messages: 15
Registered: October 2007
Location: Switzerland
Junior Member
This a problem of ressource

I have change skip-innodb in my.cnf file

Mysql started

Why i have this problem?

Disk is OK
Memory is OK

Mem: 131072k total, 70780k used, 60292k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached



Thanks

Sorry for my english

mccharlet

http://www.ateliernetcreation.com
Re: mysql installation faillure [message #23661 is a reply to message #23659] Wed, 21 November 2007 15:05 Go to previous messageGo to next message
kir is currently offline  kir
Messages: 1645
Registered: August 2005
Location: Moscow, Russia
Senior Member

Quote:

This a problem of ressource
I have change skip-innodb in my.cnf file
Mysql started
Why i have this problem?


You have 5.5G free disk space. If MySQL's InnoDB setup tries to allocate, say, 10GB in advance, it fails.

To check that, you have to use tools such strace, or understand what does innodb setup involves, how it is configured etc.


Kir Kolyshkin
http://static.openvz.org/userbars/openvz-developer.png
Re: mysql installation faillure [message #23662 is a reply to message #23661] Wed, 21 November 2007 15:08 Go to previous message
ugob is currently offline  ugob
Messages: 271
Registered: March 2007
Senior Member
Or increase the VE diskspace and test again.

Please read the manual before asking questions:
http://download.openvz.org/doc/OpenVZ-Users-Guide.pdf

Please have a look at the wiki before asking questions:
http://wiki.openvz.org/Main_Page
Previous Topic: Problem with lockedpages failcnt 192, limit 344
Next Topic: what about ipt_owner
Goto Forum:
  


Current Time: Sun Jul 14 03:54:45 GMT 2024

Total time taken to generate the page: 0.02188 seconds