Re: Error while running Mysql
check the error log,and you know the 5.5.8 enable the innodb by default,make sure that you have enough RAM. Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2010/12/23 Krishna Chandra Prajapati : > HI Adarsh, > > Try memtester command > > #memtester 5 1 > > It' a linux tool to check ram for errors. > > http://krishna-mysql.blogspot.com/2010/12/faulty-physical-ram.html > > Krishna > > > On Thu, Dec 23, 2010 at 6:08 PM, Adarsh Sharma > wrote: > >> Dear all, >> >> I am able o successfully build Mysql 5.5.8 from its source code on CentOS >> but when I issued the following command , it doesn't shows the mysql> >> prompt, there is no error in log file. >> >> >> [r...@ws-test mysql-5.5.8]# bin/mysql -p >> Enter password: >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 2 >> Server version: 5.5.8 Source distribution >> >> Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights >> reserved. >> >> Oracle is a registered trademark of Oracle Corporation and/or its >> affiliates. Other names may be trademarks of their respective >> owners. >> >> Segmentation fault >> [r...@ws-test mysql-5.5.8]# >> >> Don't know what to do.Please help. >> >> >> Thanks & Regards >> >> Adarsh Sharma >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com >> >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Error while running Mysql
HI Adarsh, Try memtester command #memtester 5 1 It' a linux tool to check ram for errors. http://krishna-mysql.blogspot.com/2010/12/faulty-physical-ram.html Krishna On Thu, Dec 23, 2010 at 6:08 PM, Adarsh Sharma wrote: > Dear all, > > I am able o successfully build Mysql 5.5.8 from its source code on CentOS > but when I issued the following command , it doesn't shows the mysql> > prompt, there is no error in log file. > > > [r...@ws-test mysql-5.5.8]# bin/mysql -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 2 > Server version: 5.5.8 Source distribution > > Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights > reserved. > > Oracle is a registered trademark of Oracle Corporation and/or its > affiliates. Other names may be trademarks of their respective > owners. > > Segmentation fault > [r...@ws-test mysql-5.5.8]# > > Don't know what to do.Please help. > > > Thanks & Regards > > Adarsh Sharma > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com > >
Re: Error while running Mysql
Hi! Johan De Meersman wrote: > Probably one for the guys with the compilers, but have you tried running it > with dtrace and seeing where it explodes ? TTBOMK, "dtrace" is a Solaris tool, and I haven't heard about it being available on CentOS. I assume this is a typo, and Johan meant "strace". I agree this might provide some helpful info. > > On Thu, Dec 23, 2010 at 1:38 PM, Adarsh Sharma > wrote: > >> Dear all, >> >> I am able o successfully build Mysql 5.5.8 from its source code on CentOS >> but when I issued the following command , it doesn't shows the mysql> >> prompt, there is no error in log file. >> >> >> [r...@ws-test mysql-5.5.8]# bin/mysql -p Before researching that any further: Do you have any specific reason to work as root? If not (or if your only reason is laziness), please do your operations as non-root, "normal" user: It is safer for you, and it may alter program behavior. Also, is "/usr" your current directory? In that case, I propose you "cd" to some other place where it may make more sense to do your work and to keep your files. >> Enter password: >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 2 >> Server version: 5.5.8 Source distribution >> >> Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights >> reserved. >> >> Oracle is a registered trademark of Oracle Corporation and/or its >> affiliates. Other names may be trademarks of their respective >> owners. >> >> Segmentation fault I am used to SIGSEGV causing a core dump, and in this case a stack backtrace would definitely be interesting. You may need to install a debugger for this, preferably "gdb". >> [r...@ws-test mysql-5.5.8]# >> >> Don't know what to do.Please help. So if this issue persists for non-root in (or below) a home directory, and you get a core dump there, a call gdb /PATH/TO/mysql 2>&1 | tee TRACE (capital words replaced as appropriate) will start the debugger, typing bt will create the backtrace, and quit will get you out again. Then, post again here, and paste the contents of file "TRACE". Also, don't forget to include your "configure" (or rather: "cmake") line and the exact versions of CentOS and gcc. HTH, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@oracle.com ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven Amtsgericht Muenchen: HRA 95603 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Error while running Mysql
have u over allocated RAM/ process regards anandkl On Thu, Dec 23, 2010 at 6:15 PM, Glyn Astill wrote: > I've no idea of the status of dtrace on linux, as I've never tried, but > failing that you could run it through gdb to get some insight into the > issue. > > --- On Thu, 23/12/10, Johan De Meersman wrote: > > > From: Johan De Meersman > > Subject: Re: Error while running Mysql > > To: "Adarsh Sharma" > > Cc: mysql@lists.mysql.com > > Date: Thursday, 23 December, 2010, 12:39 > > Probably one for the guys with the > > compilers, but have you tried running it > > with dtrace and seeing where it explodes ? > > > > On Thu, Dec 23, 2010 at 1:38 PM, Adarsh Sharma >wrote: > > > > > Dear all, > > > > > > I am able o successfully build Mysql 5.5.8 from its > > source code on CentOS > > > but when I issued the following command , it doesn't > > shows the mysql> > > > prompt, there is no error in log file. > > > > > > > > > [r...@ws-test mysql-5.5.8]# bin/mysql -p > > > Enter password: > > > Welcome to the MySQL monitor. Commands end with > > ; or \g. > > > Your MySQL connection id is 2 > > > Server version: 5.5.8 Source distribution > > > > > > Copyright (c) 2000, 2010, Oracle and/or its > > affiliates. All rights > > > reserved. > > > > > > Oracle is a registered trademark of Oracle Corporation > > and/or its > > > affiliates. Other names may be trademarks of their > > respective > > > owners. > > > > > > Segmentation fault > > > [r...@ws-test mysql-5.5.8]# > > > > > > Don't know what to do.Please help. > > > > > > > > > Thanks & Regards > > > > > > Adarsh Sharma > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be > > > > > > > > > > > > -- > > Bier met grenadyn > > Is als mosterd by den wyn > > Sy die't drinkt, is eene kwezel > > Hy die't drinkt, is ras een ezel > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=anan...@gmail.com > >
Re: Error while running Mysql
I've no idea of the status of dtrace on linux, as I've never tried, but failing that you could run it through gdb to get some insight into the issue. --- On Thu, 23/12/10, Johan De Meersman wrote: > From: Johan De Meersman > Subject: Re: Error while running Mysql > To: "Adarsh Sharma" > Cc: mysql@lists.mysql.com > Date: Thursday, 23 December, 2010, 12:39 > Probably one for the guys with the > compilers, but have you tried running it > with dtrace and seeing where it explodes ? > > On Thu, Dec 23, 2010 at 1:38 PM, Adarsh Sharma > wrote: > > > Dear all, > > > > I am able o successfully build Mysql 5.5.8 from its > source code on CentOS > > but when I issued the following command , it doesn't > shows the mysql> > > prompt, there is no error in log file. > > > > > > [r...@ws-test mysql-5.5.8]# bin/mysql -p > > Enter password: > > Welcome to the MySQL monitor. Commands end with > ; or \g. > > Your MySQL connection id is 2 > > Server version: 5.5.8 Source distribution > > > > Copyright (c) 2000, 2010, Oracle and/or its > affiliates. All rights > > reserved. > > > > Oracle is a registered trademark of Oracle Corporation > and/or its > > affiliates. Other names may be trademarks of their > respective > > owners. > > > > Segmentation fault > > [r...@ws-test mysql-5.5.8]# > > > > Don't know what to do.Please help. > > > > > > Thanks & Regards > > > > Adarsh Sharma > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be > > > > > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Error while running Mysql
Probably one for the guys with the compilers, but have you tried running it with dtrace and seeing where it explodes ? On Thu, Dec 23, 2010 at 1:38 PM, Adarsh Sharma wrote: > Dear all, > > I am able o successfully build Mysql 5.5.8 from its source code on CentOS > but when I issued the following command , it doesn't shows the mysql> > prompt, there is no error in log file. > > > [r...@ws-test mysql-5.5.8]# bin/mysql -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 2 > Server version: 5.5.8 Source distribution > > Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights > reserved. > > Oracle is a registered trademark of Oracle Corporation and/or its > affiliates. Other names may be trademarks of their respective > owners. > > Segmentation fault > [r...@ws-test mysql-5.5.8]# > > Don't know what to do.Please help. > > > Thanks & Regards > > Adarsh Sharma > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Error while running Mysql
Dear all, I am able o successfully build Mysql 5.5.8 from its source code on CentOS but when I issued the following command , it doesn't shows the mysql> prompt, there is no error in log file. [r...@ws-test mysql-5.5.8]# bin/mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.5.8 Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Segmentation fault [r...@ws-test mysql-5.5.8]# Don't know what to do.Please help. Thanks & Regards Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org