BUG: Soft lockup CPU – CentOS

 

 

BUG: soft lockup – CPU#0 stuck for 67s! [migration/0:5].

I got this error a couple of times on centos server just after restarting  it . It just  stuck at boot screen .

I dont know what is the exact cause for this but  it booted normally when I did  powercycle the server at first time .

I think  this error is something related to device driver or something like  device driver uses spinlocks improperly.

But  the second time when it happend , i logged in to the server by booting from the grub menu with  acpi=off   switch at the end of kernel arguments

s

We can also increase the  kernel.softlockup_thresh  . for this ,

#sysctl -w kernel.softlockup_thresh=120

or edit

etc/sysctl.conf  to make it active at next reboot.

 

 

 

 

 

 

 

 

 

 

 

 

 

mysql command prompt backup on windows

Open command prompt  by typing cmd in windows run window

locate mysql installation directory if mysql bin path is not added on your system .

for example ,

command_prompt>cd  C:\Program Files\MySQL\MySQL Server 5.0\bin

command_prompt>mysqldump -uUSERNAME -pPASSWORD DATABASE_NAME >  PATH_TO_BAKUP

command_prompt>mysqldump.exe -uROOT -pMYPASSWORD MY_DATABASE > c:\backup.sql

to bakup all the databases  just type the command mysqldump.exe -uROOT -pMYPASSWORD –all-databases > c:\backup.sql