Error while running Mysql

Error while running Mysql

am 23.12.2010 13:38:40 von Adarsh Sharma

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.


[root@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
[root@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=gcdmg-mysql-2@m.gmane.org

Re: Error while running Mysql

am 23.12.2010 13:39:51 von Johan De Meersman

--0022152d604d7c38550498132a65
Content-Type: text/plain; charset=ISO-8859-1

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.
>
>
> [root@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
> [root@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=vegivamp@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

--0022152d604d7c38550498132a65--

Re: Error while running Mysql

am 23.12.2010 13:45:33 von Glyn Astill

I've no idea of the status of dtrace on linux, as I've never tried, but fai=
ling 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 =0A> Subject: Re: Error=
while running Mysql=0A> To: "Adarsh Sharma" =0A>=
Cc: mysql@lists.mysql.com=0A> Date: Thursday, 23 December, 2010, 12:39=0A>=
Probably one for the guys with the=0A> compilers, but have you tried runni=
ng it=0A> with dtrace and seeing where it explodes ?=0A> =0A> On Thu, Dec 2=
3, 2010 at 1:38 PM, Adarsh Sharma wrote:=0A> =0A>=
> Dear all,=0A> >=0A> > I am able o successfully build Mysql 5.5.8 from it=
s=0A> source code on CentOS=0A> > but when I issued the following command ,=
it doesn't=0A> shows the mysql>=0A> > prompt, there is no error in log fil=
e.=0A> >=0A> >=0A> > [root@ws-test mysql-5.5.8]# bin/mysql -p=0A> > Enter p=
assword:=0A> > Welcome to the MySQL monitor.=A0 Commands end with=0A> ; or =
\g.=0A> > Your MySQL connection id is 2=0A> > Server version: 5.5.8 Source =
distribution=0A> >=0A> > Copyright (c) 2000, 2010, Oracle and/or its=0A> af=
filiates. All rights=0A> > reserved.=0A> >=0A> > Oracle is a registered tra=
demark of Oracle Corporation=0A> and/or its=0A> > affiliates. Other names m=
ay be trademarks of their=0A> respective=0A> > owners.=0A> >=0A> > Segmenta=
tion fault=0A> > [root@ws-test mysql-5.5.8]#=0A> >=0A> > Don't know what to=
do.Please help.=0A> >=0A> >=0A> > Thanks & Regards=0A> >=0A> > Adarsh Shar=
ma=0A> >=0A> >=0A> > --=0A> > MySQL General Mailing List=0A> > For list arc=
hives: http://lists.mysql.com/mysql=0A> > To unsubscribe:=A0 =A0 http://lis=
ts.mysql.com/mysql?unsub=3Dvegivamp@tuxera.be=0A> >=0A> >=0A> =0A> =0A> -- =
=0A> Bier met grenadyn=0A> Is als mosterd by den wyn=0A> Sy die't drinkt, i=
s eene kwezel=0A> Hy die't drinkt, is ras een ezel=0A> =0A

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Error while running Mysql

am 23.12.2010 13:48:53 von Ananda Kumar

--20cf3002569cc5b91f0498134a63
Content-Type: text/plain; charset=ISO-8859-1

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.
> > >
> > >
> > > [root@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
> > > [root@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=vegivamp@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=anandkl@gmail.com
>
>

--20cf3002569cc5b91f0498134a63--

Re: Error while running Mysql

am 23.12.2010 14:09:13 von Joerg Bruehe

Hi!


Johan De Meersman wrote:
> Probably one for the guys with the compilers, but have you tried runnin=
g 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.

>=20
> On Thu, Dec 23, 2010 at 1:38 PM, Adarsh Sharma m>wrote:
>=20
>> Dear all,
>>
>> I am able o successfully build Mysql 5.5.8 from its source code on Cen=
tOS
>> but when I issued the following command , it doesn't shows the mysql>
>> prompt, there is no error in log file.
>>
>>
>> [root@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".


>> [root@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

--=20
Joerg Bruehe, MySQL Build Team, joerg.bruehe@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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Error while running Mysql

am 23.12.2010 14:17:15 von Krishna Chandra Prajapati

--001636c92375427f4f049813b05e
Content-Type: text/plain; charset=ISO-8859-1

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-ra m.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.
>
>
> [root@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
> [root@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=prajapatikc@gmail.com
>
>

--001636c92375427f4f049813b05e--

Re: Error while running Mysql

am 25.12.2010 04:39:49 von amoiz.shine

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-ra m.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 CentO=
S
>> but when I issued the following command , it doesn't shows the mysql>
>> prompt, there is no error in log file.
>>
>>
>> [root@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
>> [root@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=3Dprajapatikc@gmail.com
>>
>>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg