I downloaded the .rpm for redhat 5.2 for the mysql server, client:

The client installed ok with no errors, next I went to install the
server, these are the errors I get, what's up ?

localhost /aaa]# glint
Glint Graphical Package Manager -- version 2.6.2
Copyright (C) 1998 - Red Hat Software
This may be freely redistributed under the terms of the GNU Public
License
Exception in Tkinter callback
Traceback (innermost last):
File "/var/tmp/python-root/usr/lib/python1.5/lib-tk/Tkinter.py", line
752, in
__call__
return apply(self.func, args)
File "./glint.py", line 62, in available
availablePackageSet = PackagePathSet(currentPackagePath)
File "./packageset.py", line 157, in __init__
self.setPath(path)
File "./packageset.py", line 152, in setPath
w.setAmount(num)
File "./packageset.py", line 174, in setAmount
self.scale.set(amount)
File "./scale.py", line 44, in set
self.C.delete(self.bar)
File "/var/tmp/python-root/usr/lib/python1.5/lib-tk/Tkinter.py", line
1191, in
delete
self._do('delete', args)
File "/var/tmp/python-root/usr/lib/python1.5/lib-tk/Tkinter.py", line
1059, in
_do
return apply(self.tk.call, (self._w, name) + args)
TclError: invalid command name
".142273304.147906544.147880880.142267512"
read failed: Is a directory (21)
read failed: Is a directory (21)
^[[B^[[B^[[B

Hi,

That is the exact error message I got when testing on a MySQL-using
website!!!!

So you say that it is not for sure that it came from MySQL?

Ritschie

http://ludens.elte.hu/~krichard
On Thu, 3 Jun 1999, Tomislav Petrovic wrote:
> I get every now and then the following error on my MySQL + PHP web page:
> Warning: MySQL Connection Failed: Can't create a new thread (errno 11). If
> you are not out of available memory, you can consult the manual for any
> possible OS dependent bug in global.inc on line 49.

I'm sure it gor from MySQL......
I was also warned that older version of glibc (from REDHAT 5.1)
could be the reason and that I should upgrade glibc to one from REDHAT 5.2
or 6.0
and then recompile server.....

Tomy.
-----Original Message-----
From: Ritschie <krichard@[Protected]>
To: mysql@[Protected] <mysql@[Protected]>
Cc: Monty@[Protected] <Monty@[Protected]>
Date: etvrtak, lipanj 03, 1999 12:29
Subject: Re: Error


>Hi,
>
>That is the exact error message I got when testing on a MySQL-using
>website!!!!
>
>So you say that it is not for sure that it came from MySQL?
>
>Ritschie
>
>http://ludens.elte.hu/~krichard
>On Thu, 3 Jun 1999, Tomislav Petrovic wrote:
>> I get every now and then the following error on my MySQL + PHP web page:
>> Warning: MySQL Connection Failed: Can't create a new thread (errno 11).
If
>> you are not out of available memory, you can consult the manual for any
>> possible OS dependent bug in global.inc on line 49.
>
>
>----------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread4464@[Protected]
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@[Protected] instead.

Actually, the problem does not come from MySQL, it is a bug in
glibc/threads (commonly found in Redhat), I had it myself until I updated
my glibc library.
Before you insist that MySQL lies at the heart of every problem, you should
consider that many things come into play with such an application
(including, WOW, your operating system and libraries, who would have
guessed!@).

John <test@[Protected]>

At 12:29 PM 6/3/99 +0200, you wrote:
>Hi,
>
>That is the exact error message I got when testing on a MySQL-using
>website!!!!
>
>So you say that it is not for sure that it came from MySQL?
>
>Ritschie
>
>http://ludens.elte.hu/~krichard
>On Thu, 3 Jun 1999, Tomislav Petrovic wrote:
>> I get every now and then the following error on my MySQL + PHP web page:
>> Warning: MySQL Connection Failed: Can't create a new thread (errno 11). If
>> you are not out of available memory, you can consult the manual for any
>> possible OS dependent bug in global.inc on line 49.
>
>
>----------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread4464@[Protected]
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@[Protected] instead.

Sanjeeb Bhuyan wrote:
>
> Hi,
> I get an error messagea bout mysqld when i start it...
> gives "mysqld start....unexpected error,etc..then mysld daemon stopped.
> i look into data/.err file, and all it says is..
> /network/msql/mysql-version/binmysqld: 1 : ")" unexpected
> mysqld ended at..
>
> help!!
> sanjeeb
>

Go to the terminal, re-type all the commands, then copy and paste
everything you've typed along with all shell responses, and the tail of
the errror log, and post it.

--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)

AFAIK you have to include the driver in your CLASSPATH environment otherwise
your java app will never find the JDBC driver.

hope this helps.

-Robert

> -----Original Message-----
> From: M. Priya [mailto:priya@[Protected]]
> Sent: Monday, January 24, 2000 5:57 AM
> To: mysql@[Protected]
> Subject: Error
>
>
> Respected sir,
>
> I have installed mysql in usr/local directory and the jdbc driver
> that you had recommended namely the twz1 driver was also installed in
> usr/local/mysql directory as told. But when i ran the sample test programs
> i was not able to initialize the driver and that i am getting both CLASS
> NOT FOUND EXCEPTION and SQL EXCEPTION saying the class
> twz1.jdbc.mysql.jdbcMysqlDriver not found
>
> Kindly help me out as soon as possible
>
> Expecting your reply,
>
> bye
> priya
>
>
> --
> ----------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread25181@[Protected]
>
> To unsubscribe, send a message to:
> <mysql-unsubscribe-rschott=schott-memsys.com@[Protected]>

> I have a question for you if you have some free time :-)
>
> Does the configure hang for a bit normally? I do not remember this last
> time I installed.....
>
> DSHAREDIR="\"/usr/share/mysql\"" -DHAVE_CONFIG_H -I./
> ../include -I./../regex -I. -I../include -I..
> -I. -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -O3
> -DDBUG_OFF -fno-implicit-templates -DMYSQLD_NET_RETRY_COUNT=1000000 -c
> sql_yacc.cc
>
> This is the last line shown and....
>
> root p0 c258070-c.decatu 8:48AM 10
> /usr/libexec/cc1plus /tmp/ccN33470.ii -quiet -dumpbase sql_yacc.cc -O3 -fn
>
> This is what it says im doing.

On Mon, Aug 28, 2000 at 08:10:41AM -0700, Gary wrote:

> I installed the newest stable version of MySQL on windows 98 and
> everything worked fine. This weekend I installed Apache and now
> MySQL doesn't run. I have tried to reinstall with no luck. The error
> I am getting is the following. ERROR 2003: Can't connect to MYSQL
> server on 'localhost' (10061) It looks like it can't find the right
> port to connect. What steps should I take to correct the problem.

Verify that MySQL is running.

Verify that MySQL is listening to the proper port.

Verify that the client and server agree on which port to use.
--
Jeremy D. Zawodny, <jzawodn@[Protected]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951

>Hi ,
>
>I've got a problem with the following script.
>
>$mysql_link = mysql_connect("$host","$user","$passwd") OR
>DIE("Impossible de trouver la serveur de donne");
>mysql_select_db($db ,$mysql_link ) or die("<b><font color=#990000>erreur
>MySQL: ".mysql-error()."</font></b>");
>
>$mysql_result = mysql_query( $db
>,"SELECT * FROM $table") OR DIE("ca plante");

Sir, try
$mysql_result = mysql_query("SELECT * FROM $table", $mysql_link)
This is obviously a PHP problem, not a MySQL problem. Future PHP
questions should probably be posted to the PHP database list.

Bob Hall

Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

What did you do to get the error

Adrian

On Fri, 30 Mar 2001, Lebrun Jonathan wrote:

> What's error 1062 ?
>
> Thanks.
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.2 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE6xYp3/f1mUNueu/oRAqP4AJ0Z0So1MmNobXAD+AxXRi4nWgigoACfYvhO
erKMiznCDqCPMBUIyzOh+EQ=
=gYyX
-----END PGP SIGNATURE-----

Firstly, I'm using mysql_connect() without anyproblems.

>From what I can tell, you have not built php with mysql support. Please
consult the php manual and php list on how to fix this.


----- Original Message -----
From: "Jim Witt" <JWitt@[Protected]>
To: "Help MySQL" <mysql@[Protected]>
Sent: Wednesday, May 16, 2001 3:49
Subject: Error


> I have installed MySQL 3.23.32
>
> Other apps: PHP 4.0.5, Xitami
>
> Machine: Athlon 1 GHz, Win98, 256K RAM
>
>
> Manual indicates 'mysql_connect()' is deprecated. So I try
> 'mysql_real_connect()' and get that nasty:
>
> Fatal error: Call to undefined function: mysql_init() in
> c:/xitami/cgi-bin/dbProc1.php on line 717
>
>
> Can anyone help?
>
> Thanks,
>
> Jim Witt
>
>
> ----------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread73863@[Protected]>
> To unsubscribe, e-mail
<mysql-unsubscribe-rhopkins=mail.waytech.com.tw@[Protected]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Hi,

You are missing the ; at the end of the SQL statement
try $query = "SELECT * FROM question WHERE answer<>'1' AND id>250 ORDER BY
id;";
instead of $query = "SELECT * FROM question WHERE answer<>'1' AND id>250
ORDER BY id";

CPereira

----- Original Message -----
From: "Martin Kampherbeek" <m.kampherbeek@[Protected]>
To: <mysql@[Protected]>
Sent: Saturday, August 25, 2001 8:17 AM
Subject: Error


> I still get this error. Can someone help me to solve this?
> MySQL Query Failed. Error 1030: Got error -1 from table handler
>
>
> $query = "SELECT * FROM question WHERE answer<>'1' AND id>250 ORDER BY
id";
>
> $result = mysql_query($query) or die('MySQL Query Failed. Error
> '.mysql_errno().':
> '.mysql_error());
>
> $number = mysql_num_rows($result);
>
>
> ----------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread83566@[Protected]>
> To unsubscribe, e-mail
<mysql-unsubscribe-carlospereira=netvisao.pt@[Protected]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

At 11:24 PM +0100 8/25/01, Carlos Pereira wrote:
>Hi,
>
>You are missing the ; at the end of the SQL statement
>try $query = "SELECT * FROM question WHERE answer<>'1' AND id>250 ORDER BY
>id;";
>instead of $query = "SELECT * FROM question WHERE answer<>'1' AND id>250
>ORDER BY id";

No. A semicolon statement terminator is a mysql convention, and is
not needed when issuing queries from within an API. For some APIs,
it will even cause queries to fail.

An error from the table handler may indicate a more serious problem,
perhaps requiring a table repair.

>
>CPereira
>
>----- Original Message -----
>From: "Martin Kampherbeek" <m.kampherbeek@[Protected]>
>To: <mysql@[Protected]>
>Sent: Saturday, August 25, 2001 8:17 AM
>Subject: Error
>
>
>> I still get this error. Can someone help me to solve this?
>> MySQL Query Failed. Error 1030: Got error -1 from table handler
>>
>>
>> $query = "SELECT * FROM question WHERE answer<>'1' AND id>250 ORDER BY
>id";
>>
>> $result = mysql_query($query) or die('MySQL Query Failed. Error
>> '.mysql_errno().':
>> '.mysql_error());
>>
> > $number = mysql_num_rows($result);
>>
> >


--
Paul DuBois, paul@[Protected]

> Hi,
>
> Could somebody tell me what is this?
>
> SQL select * from users limit 0,25 failed : Got error 127 from table
handler
>
> TIA
>
> Alex

http://www.mysql.com/doc/manual.php?search_query=Got+error+127+from+table+ha
ndler&submit=Search&depth=0

jason

Bauer, Rich writes:
> I am building mysql 3.22.26a with gnu cc 2.95.3 and gnu make under solaris 8
> and get the following error. How do I fix this ?
>
> # make
> make all-recursive
> make[1]: Entering directory `/opt/ftp/mysql-3.22.26a'
> Making all in Docs
> make[2]: Entering directory `/opt/ftp/mysql-3.22.26a/Docs'
> make[2]: Nothing to be done for `all'.
> make[2]: Leaving directory `/opt/ftp/mysql-3.22.26a/Docs'
> Making all in readline
> make[2]: Entering directory `/opt/ftp/mysql-3.22.26a/readline'
> make[2]: Nothing to be done for `all'.
> make[2]: Leaving directory `/opt/ftp/mysql-3.22.26a/readline'
> Making all in client
> make[2]: Entering directory `/opt/ftp/mysql-3.22.26a/client'
> c++ -DUNDEF_THREADS_HACK -I./../include -I../include
> -I./.. -I.. -I.. -O -fno-implicit-templates -DDBUG_OFF
> -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -c mysql.cc
> In file included from mysql.cc:54:
> /usr/include/term.h:1060: syntax error before `,'
> /usr/include/term.h:1081: syntax error before `;'
> /usr/include/term.h:1082: syntax error before `;'
> /usr/include/term.h:1101: syntax error before `['
> /usr/include/term.h:1108: syntax error before `*'
> /usr/include/term.h:1111: syntax error before `;'
> /usr/include/term.h:1115: syntax error before `;'
> /usr/include/term.h:1116: syntax error before `;'
> /usr/include/term.h:1207: `chtype' was not declared in this scope
> /usr/include/term.h:1207: parse error before `('
> make[2]: *** [mysql.o] Error 1
> make[2]: Leaving directory `/opt/ftp/mysql-3.22.26a/client'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory `/opt/ftp/mysql-3.22.26a'
> *** Error code 2
> make: Fatal error: Command failed for target `all-recursive-am'
> # pwd
> /opt/ftp/mysql-3.22.26a
> #

Hi!

Solution for the above problem is thoroughly described in our fine
manual.

If your Solaris is on SPARC, you are better of by using our binary.

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sinisa@[Protected]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Look in archive:
http://www.geocrawler.com/archives/3/8/2001/6/0/6076299/


----- Original Message -----
From: "Saulius Kavoliunas" <sauliui@[Protected]>
To: <mysql@[Protected]>
Sent: Saturday, January 19, 2002 9:14 PM
Subject: error


> Hello mysql,
>
> I have a problem with starting mysql, I'm using winXP and when I try
> to start mysql on administrative tools\services I get a box with an
> error 1067, nothing else is written :(, what is the problem can you
> suggest me waht to do.
> Tkank you,
> --
> Best regards,
> Saulius mailto:sauliui@[Protected]
>
>
> ----------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread96815@[Protected]>
> To unsubscribe, e-mail
<mysql-unsubscribe-ventor=teamnet.ws@[Protected]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

At 22:14 19/01/2002 0200, Saulius Kavoliunas wrote:
>Hello mysql,
>
> I have a problem with starting mysql, I'm using winXP and when I try
> to start mysql on administrative tools\services I get a box with an
> error 1067, nothing else is written :(, what is the problem can you
> suggest me waht to do.
> Tkank you,
>--

The above error means that the service was started and the server
aborted for some reason.
Take a look in the \mysql\data\mysql.err file and try to find what
is the reason, or try to start the server as standalone for to see
the reason:
open a DOS prompt screen:

mysqld-max-nt --standalone --console

in the above command if you want to use other server, change the
executable name.

Regards,
Miguel

>Best regards,
> Saulius mailto:sauliui@[Protected]
>
>
>----------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <mysql-thread96815@[Protected]>
>To unsubscribe, e-mail <mysql-unsubscribe-solor=uol.com.br@[Protected]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel A. Solrzano <miguel@[Protected]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - So Paulo, Brazil
<___/ www.mysql.com

I m franch a little latin,
no u re not an error.

see at www.mysql.com if u can found doc into your language have a look at
grant / revoke command to make 'fire1.uniube.br' allowed to query the
server.

GRANT ALL ON database.* TO user@[Protected] IDENTIFIED BY "password"

"all" is too much u can try :

ALL PRIVILEGES FILE RELOAD
ALTER INDEX SELECT
CREATE INSERT SHUTDOWN
DELETE PROCESS UPDATE
DROP REFERENCES USAGE

insert,select,update,delete is well
----- Original Message -----
From: "Joabe Fuzaro" <joabe.fuzaro@[Protected]>
To: <mysql@[Protected]>
Sent: Tuesday, January 29, 2002 7:37 PM
Subject: Error


> Hi,
>
> I'm brasiliam, so..
>
> my english is very bad....
>
> I'm a error:
> Warning: Host 'fire1.uniube.br' is not allowed to connect to this MySQL
> server
>
> Tanks
>
> Joabe
>
>
>
> ----------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread97876@[Protected]>
> To unsubscribe, e-mail
<mysql-unsubscribe-david_devidal=yahoo.fr@[Protected]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



_________________________________________________________

Do You Yahoo!?

Get your free @yahoo.com address at http://mail.yahoo.com

No, those are termcap database entries.
Configure is looking for libtermcap or libterminfo int .the /lib directory.
If you are running RedHat Linux you need to install the ncurses rpm.

David Johnston wrote:

>When running ./configure I am getting the error no termcap libraries but in
>/usr/lib/termcap the libs are there. What should I do? I have my mysqlbug
>file attached.
>



----------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysql-thread114288@[Protected]>
To unsubscribe, e-mail <mysql-unsubscribe-archiver=blueworld.com@[Protected]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

The key words are "over which I have no control". See if you can figure it.


----- Original Message -----
From: "Andrew Conkling" <andrewski@[Protected]>
To: <mysql@[Protected]>
Sent: Thursday, August 22, 2002 12:36 PM
Subject: Error


Hey, I'm trying to create a db on a server (over which I have no
control) and I keep getting this error:

mysqladmin: CREATE DATABASE failed; error: 'Access denied for user:
'@localhost' to database 'musica''

Any suggestions?
Andrew

My homepage
http://www.andrewski.fr.st



----------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysql-thread117816@[Protected]>
To unsubscribe, e-mail
<mysql-unsubscribe-terencel=sunway.edu.my@[Protected]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


----------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysql-thread117830@[Protected]>
To unsubscribe, e-mail <mysql-unsubscribe-archiver=blueworld.com@[Protected]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Andrew,
Thursday, August 22, 2002, 7:36:35 AM, you wrote:

AC> Hey, I-m trying to create a db on a server (over which I have no
AC> control) and I keep getting this error:
AC> =
AC> mysqladmin: CREATE DATABASE failed; error: 'Access denied for user:
AC> '@localhost' to database 'musica''
AC> =
AC> Any suggestions?

If you don't have permissions to create database ask database
administrator to create a user with appropriate privileges.

You can also start MySQL server with --skip-grant-tables option:
http://www.mysql.com/doc/en/Command-line_options.html
http://www.mysql.com/doc/en/Resetting_permissions.html






--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@[Protected]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com



----------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysql-thread117833@[Protected]>
To unsubscribe, e-mail <mysql-unsubscribe-archiver=blueworld.com@[Protected]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

At 19:10 27/11/2002 -0200, Marco Querini wrote:
Hi,

When you install MySQL in another directory than the default
C:\mysql, you need to create the c:\winnt\my.ini file and to
edit the variables:

[mysqld]
basedir=d:/mysql #for example
datadir=d:/mysql/data #for example

>Dear Sirs,
>
>I installed the Mysql 3.23.51 in my Windows NT 4.0 with service pack 6. The
>directory that I used was c:\mysql. After that I saw that the C:\mysql was
>to small. I uninstalled using the command mysqld-max-nt --remove and after
>that I used the option add/remove program from control panel to uninstall
>the mysql. I restarted the server and reinstalled the software mysql but now
>in the d:\ directory. After that when I try to start the mysql like a
>service it show a error message: Could not start the MySql service on
>//bioserver1 and just return to work when I reinstall in the c:\mysql. How
>can I solve this?
>
>Thanks,
>
>Marco Querini
>---
>O e-mail enviado est certificado de no conter vrus.
>
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.423 / Virus Database: 238 - Release Date: 25/11/2002
>
>
>
>
>----------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <mysql-thread126001@[Protected]>
>To unsubscribe, e-mail <mysql-unsubscribe-solor=terra.com.br@[Protected]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel Angel Solrzano <miguel@[Protected]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ So Paulo - Brazil
<___/ www.mysql.com


----------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysql-thread126011@[Protected]>
To unsubscribe, e-mail <mysql-unsubscribe-archiver=blueworld.com@[Protected]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

At 3:16 +0000 3/14/03, Patrick Geary wrote:
>Hi
>I am a new user of Mysql and have received an error.
>I enter my C drive using the MS-DOS prompt. I then access the mysql\bin
>directory.
>I then type "mysql". which welcomes me to Mysql Monitor.
>I then try to create a database called "database01" by typing "mysqladmin
>create database01\g" but i get the following error:-
> Error 1064:You have an error in your SQL syntax near
>'mysqladmin create database01' at line 1.
>
>I would be very grateful if you could get back to me about this as i am
>using it for a college project.
>

mysqladmin is not a command that you enter at the mysql> prompt from
within the mysql program. It's a separate program that you invoke
from the DOS prompt.

You can either create the database from within mysql like this:

mysql> CREATE DATABASE database01;

or from the command line using mysqladmin like this:

C:\> mysqladmin create database01

>Thanks
>Patrick Geary


--
Paul DuBois
http://www.kitebird.com/
sql, query

----------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysql-thread134963@[Protected]>
To unsubscribe, e-mail <mysql-unsubscribe-archiver=blueworld.com@[Protected]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Hi,

You should run mysqladmin from DOS prompt, not within mysql client.
If you want to create a database from mysql client, you should use:
create database database01;

Regards,
Joseph Bueno

Patrick Geary wrote:
> Hi
> I am a new user of Mysql and have received an error.
> I enter my C drive using the MS-DOS prompt. I then access the mysql\bin
> directory.
> I then type "mysql". which welcomes me to Mysql Monitor.
> I then try to create a database called "database01" by typing "mysqladmin
> create database01\g" but i get the following error:-
> Error 1064:You have an error in your SQL syntax near
> 'mysqladmin create database01' at line 1.
>
> I would be very grateful if you could get back to me about this as i am
> using it for a college project.
>
> Thanks
> Patrick Geary


----------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysql-thread134964@[Protected]>
To unsubscribe, e-mail <mysql-unsubscribe-archiver=blueworld.com@[Protected]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

You don't want to use any calls to 'mysqladmin' inside of the MySQL Monitor,
as mysqladmin is for command line functions (outside the command line)...you
may want to reread some of the documentation on this, starting here:
http://www.mysql.com/doc/en/Connecting-disconnecting.html

Brian McCain

----- Original Message -----
From: "Patrick Geary" <GearyP@[Protected]>
To: <mysql@[Protected]>
Sent: Thursday, March 13, 2003 7:16 PM
Subject: error


> Hi
> I am a new user of Mysql and have received an error.
> I enter my C drive using the MS-DOS prompt. I then access the mysql\bin
> directory.
> I then type "mysql". which welcomes me to Mysql Monitor.
> I then try to create a database called "database01" by typing "mysqladmin
> create database01\g" but i get the following error:-
> Error 1064:You have an error in your SQL syntax near
> 'mysqladmin create database01' at line 1.
>
> I would be very grateful if you could get back to me about this as i am
> using it for a college project.
>
> Thanks
> Patrick Geary
>
> ----------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread134961@[Protected]>
> To unsubscribe, e-mail
<mysql-unsubscribe-brian=digitalmarch.com@[Protected]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


----------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysql-thread134966@[Protected]>
To unsubscribe, e-mail <mysql-unsubscribe-archiver=blueworld.com@[Protected]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

John,

what do

SHOW CREATE TABLE user_new;

and

explain select count(*) from user_new where list_code = 18;

and

CHECK TABLE user_new; (this may last hours and will also print to the
..err log)

say?

Which MySQL version you are running and on what Linux distro?

Best regards,

Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/


----- Original Message -----
From: "John Brooks" <john@[Protected]>
Newsgroups: mailing.database.mysql
Sent: Friday, June 06, 2003 3:59 AM
Subject: error


> Using InnoDB on a large table (> 100,000,000 rows)...
> Trying to get a count that should equal about 25,000,000.
> Wasn't using that much memory.
> Database crashes....
> Any idea?
>
> 030605 19:38:27 InnoDB: Assertion failure in thread 45068 in file
> row0sel.c line 1977
> InnoDB: Failing assertion: len == DATA_ROW_ID_LEN
> InnoDB: We intentionally generate a memory trap.
> InnoDB: Send a detailed bug report to mysql@[Protected]
> mysqld got signal 11;
> This could be because you hit a bug. It is also possible that this binary
> or one of the libraries it was linked against is corrupt, improperly
built,
> or misconfigured. This error can also be caused by malfunctioning
hardware.
> We will try our best to scrape up some info that will hopefully help
> diagnose
> the problem, but since we have already crashed, something is definitely
> wrong
> and this may fail.
>
> key_buffer_size=419430400
> read_buffer_size=104853504
> sort_buffer_size=2097144
> max_used_connections=3
> max_connections=100
> threads_connected=3
> It is possible that mysqld could use up to
> key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
> = 2465391 K
> bytes of memory
> Hope that's ok; if not, decrease some variables in the equation.
>
> thd=0x87626c0
> Attempting backtrace. You can use the following information to find out
> where mysqld died. If you see no messages after this, something went
> terribly wrong...
> Cannot determine thread, fp=0xbfe3e7b8, backtrace may not be correct.
> Stack range sanity check OK, backtrace follows:
> 0x80741ea
> 0x829c1e8
> 0x814db1b
> 0x80d1a58
> 0x80d4cbc
> 0x80a6abd
> 0x80a0e29
> 0x80a0ad3
> 0x80998e0
> 0x80a630d
> 0x807ecfa
> 0x808273b
> 0x807de2d
> 0x8083c5e
> 0x807cfff
> 0x829999c
> 0x82cd0aa
> New value of fp=(nil) failed sanity check, terminating stack trace!
> Please read http://www.mysql.com/doc/en/Using_stack_trace.html and
> follow instructions on how to resolve the stack trace. Resolved
> stack trace is much more helpful in diagnosing the problem, so please do
> resolve it
> Trying to get some variables.
> Some pointers may be invalid and cause the dump to abort...
> thd->query at 0x8773000 = select count(*) from user_new where list_code =
18
> thd->thread_id=3
>
> Successfully dumped variables, if you ran with --log, take a look at the
> details of what thread 3 did to cause the crash. In some cases of really
> bad corruption, the values shown above may be invalid.
>
> The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains
> information that should help you find out what is causing the crash.
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=mysql@[Protected]
>



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

did you 1. read the manual and
2. run mysql_install_db ?

Regards, Thomas Spahni

On Wed, 3 Mar 2004, Liew Toh Seng wrote:

> > How to fix this problem
> >
> >
> > 040303 17:40:51 mysqld started
> > InnoDB: The first specified data file ./ibdata1 did not exist:
> > InnoDB: a new database to be created!
> > 040303 17:40:51 InnoDB: Setting file ./ibdata1 size to 10 MB
> > InnoDB: Database physically writes the file full: wait...
> > 040303 17:40:52 InnoDB: Log file ./ib_logfile0 did not exist: new to
> > be created
> > InnoDB: Setting log file ./ib_logfile0 size to 5 MB
> > InnoDB: Database physically writes the file full: wait...
> > 040303 17:40:52 InnoDB: Log file ./ib_logfile1 did not exist: new to
> > be created
> > InnoDB: Setting log file ./ib_logfile1 size to 5 MB
> > InnoDB: Database physically writes the file full: wait...
> > InnoDB: Doublewrite buffer not found: creating new
> > InnoDB: Doublewrite buffer created
> > InnoDB: Creating foreign key constraint system tables
> > InnoDB: Foreign key constraint system tables created
> > 040303 17:40:53 InnoDB: Started; log sequence number 0 0
> > 040303 17:40:54 Fatal error: Can't open privilege tables: Table
> > 'mysql.host' doesn't exist
> > 040303 17:40:54 mysqld ended
>
>
> ----------------------------------------------------------
> -------
> Best Regards
> Liew Toh Seng
> Icq No: >> 36835809 <<
> MSN: >> tohseng@[Protected] <<
> * .--.
> * |o_o |
> * |:_/ |
> * //
> * (| | )
> * /'\_ _/` The Internet Solution Company
> * \___)=(___ My Directory Sdn Bhd


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

sure that isn't c:\winnt\system32? see if you can find the libmysql.dll
file on your computer and copy it into c:\winnt\system. It's not the most
elegant solution...but it'll work.

----- Original Message -----
From: <dtfanatic247@[Protected]>
To: <mysql@[Protected]>
Sent: Monday, May 31, 2004 7:38 PM
Subject: error


I've installed mysql on my windows 2000 system, with the windows installer.
When it's done and I double click on winmysql admin I get this error -

The dynamic link library LIBMYSQL.dll could not be found in the specified
path
C:\mysql\bin;.;C:\WINNET\system32;C:\WINNT\system

etc


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

i had the same problem,

for me it was here:
c:\mysql\lib\opt

and I copied it to
c:\mysql\bin\

that got me up and running. maybe it'll work for you.

cheers

----- Original Message -----
From: <dtfanatic247@[Protected]>
To: <mysql@[Protected]>
Sent: Tuesday, June 01, 2004 10:38 AM
Subject: error


I've installed mysql on my windows 2000 system, with the windows installer.
When it's done and I double click on winmysql admin I get this error -

The dynamic link library LIBMYSQL.dll could not be found in the specified
path
C:\mysql\bin;.;C:\WINNET\system32;C:\WINNT\system

etc


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

Scott Hamm <ScottHam@[Protected]> wrote on 17/09/2004 13:15:30:

> mysql> create table list_admin (
> -> admin_id int(11) default '0' not null auto_increment
> -> );
> ERROR 1067 (42000): Invalid default value for 'admin_id'
>
> How can I set default value to 0?

I don't think you can have a default with auto-increment. Essentially,
auto_increment means "default ++counter", so you are assigning two
defaults. Which do you want, 0 or auto_increment?

Alec


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

You can't - auto_increment cannot have a default value, AFAIAA.

Terry

----- Original Message -----

> mysql> create table list_admin (
> -> admin_id int(11) default '0' not null auto_increment
> -> );
> ERROR 1067 (42000): Invalid default value for 'admin_id'
>
> How can I set default value to 0?
>



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

Alec.Cawley@[Protected] wrote:

> Scott Hamm <ScottHam@[Protected]> wrote on 17/09/2004 13:15:30:
>
>
>>mysql> create table list_admin (
>> -> admin_id int(11) default '0' not null auto_increment
>> -> );
>>ERROR 1067 (42000): Invalid default value for 'admin_id'
>>
>>How can I set default value to 0?
>
>
> I don't think you can have a default with auto-increment. Essentially,
> auto_increment means "default ++counter", so you are assigning two
> defaults. Which do you want, 0 or auto_increment?
>
> Alec

Right. You can't have both, because both makes no sense.

Also, if you do want the default to be 0, set it to 0, not to the string
'0'. Your admin_id column is an int, not a string.

So, either

admin_id INT NOT NULL AUTO_INCREMENT

or

admin_id INT DEFAULT 0 NOT NULL

Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

Hi Jim,

Your advice is indeed correct for the access denied problem. For your own problem, you might consider taking a look at max_allowed_packet variable of MySQL, as this error is common when you are sending a large blob update and the variable is too small for the update SQL, i.e. max_allowed is 1Mb and you are sending a 2Mb SQL statement. Also the client write and read timeout also causes this error, i.e. when you are doing a query which takes longer than say 60 seconds and your read timeout is set for a default 30 seconds.

Kind Regards
SciBit MySQL Team
http://www.scibit.com
MySQL Products:
http://www.scibit.com/products/mycon
http://www.scibit.com/products/mysqlcomponents
http://www.scibit.com/products/mysqlx
http://www.scibit.com/products/mascon

>
> -----Original Message-----
> From: "Jim Zipper" <jimzipper@[Protected]>
> To: "Emmanuel d" <edange@[Protected]>
> CC: "myodbc@[Protected]" <myodbc@[Protected]>
> Subject: Re: error
> Sent: Thu, 23 Dec 2004 03:58:55 GMT
> Received: Thu, 23 Dec 2004 04:01:35 GMT
> Read: Thu, 23 Dec 2004 09:05:20 GMT
> I am no expert by any means but over the last week I have been trying to
> solve why I can't connect from W XP as well. I keep getting the error
> message 2013 "lost connection during SQL query." But what I have learned I
> think is that the error message you have received indicates that you have
> not set up the proper MySQL user access privileges. As I understand it you
> need to define access privileges for the client host, user and password.
> There are wildcard settings and defaults when these fields are left blank. I
> learned allot from these sections of the MySQL manual
> http://dev.mysql.com/doc/mysql/en/Privilege_system.html &
> http://dev.mysql.com/doc/mysql/en/User_Account_Management.html but
> unfortuantely I have still not solved my problem.
>
> I don't know if this helps or not but I thought I would try to help. If
> there is anything you can suggest to solve my problem please respond as well
>
> TTFN
>
> ----- Original Message -----
> From: "Emmanuel d'Ange" <edange@[Protected]>
> To: <myodbc@[Protected]>
> Sent: Wednesday, December 22, 2004 3:26 PM
> Subject: error
>
>
> Hi,
> I've install odbc 3.51driver on win XP. I've already configure the
> connector with the correct parameter but when I try to test the connection,
> I've got this message : [MySQL][ODBC 3.51 Driver]Access denied for user:
> '.@.' (using password: yes)
> I don't know what to do.
> thanks
> Best regard
>
> e.d'Ange
>
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc?unsub=mysql@[Protected]
>
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

The package you sent me was infected, so send me one by mail.Thank you:James B.Runaku, P.O.Box 190-50100, Kakamega, Kenya.

mysql@[Protected] wrote: The message contains Unicode characters and has been sent as a binary attachment.




---------------------------------
How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates.

On 7/10/07, Octavian Rasnita <orasnita@[Protected]> wrote:
>
> I have exported a database using mysqldump from MySQL 5.0.27, and I have
> tried importing it in a MySQL 5.0.41, but it gives the following error:
>
> ERROR 1071 (42000) at line 483: Specified key was too long; max key length
> is 1000 bytes


Hint: Please post line 483 as well as the lines that give the offending
table design.

Hi,

Post the error.

Saravanan


--- On Wed, 1/16/08, Pastor Steve <smarquez@[Protected]> wrote:

> From: Pastor Steve <smarquez@[Protected]>
> Subject: Error
> To: "MySQL List" <mysql@[Protected]>
> Date: Wednesday, January 16, 2008, 3:32 AM
> Greetings,
>
> I am trying to enter this information into a database
> called cms_md, with a
> table called sections.
>
> INSERT INTO sections (order,edit,remove,section,type)
> VALUES
> ('blah','blah','blah','blah','blah');
>
> I am getting an error whenever I use this.
>
> --
> Steve M


__________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

Thanks,

Here it is:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'order,edit,remove,section,type) VALUES
('blah','blah','blah','blah','blah')' at line 1

--
Steve M.


on 1/15/08 3:06 PM Saravanan (suzuki_babu@[Protected]) wrote:

> Hi,
>
> Post the error.
>
> Saravanan
>
>
> --- On Wed, 1/16/08, Pastor Steve <smarquez@[Protected]> wrote:
>
>> > From: Pastor Steve <smarquez@[Protected]>
>> > Subject: Error
>> > To: "MySQL List" <mysql@[Protected]>
>> > Date: Wednesday, January 16, 2008, 3:32 AM
>> > Greetings,
>> >
>> > I am trying to enter this information into a database
>> > called cms_md, with a
>> > table called sections.
>> >
>> > INSERT INTO sections (order,edit,remove,section,type)
>> > VALUES
>> > ('blah','blah','blah','blah','blah');
>> >
>> > I am getting an error whenever I use this.
>> >
>> > --
>> > Steve M
>
>
>
> __________________________________________________________
> ______
> Never miss a thing. Make Yahoo your home page.
> http://www.yahoo.com/r/hs

ORDER is a reserved word in standard SQL

Example : SELECT FirstName,LastName FROM Names ORDER BY LastName,FirstName;

If the column name in the table is ORDER, then put backquotes (`) around the word ORDER when using it as a column name

INSERT INTO sections (`order`,edit,remove,section,type) VALUES
('blah','blah','blah','blah','blah');


-----Original Message-----
From: Pastor Steve [mailto:smarquez@[Protected]]
Sent: Tuesday, January 15, 2008 4:02 PM
To: MySQL List
Subject: Error

Greetings,

I am trying to enter this information into a database called cms_md, with a
table called sections.

INSERT INTO sections (order,edit,remove,section,type) VALUES
('blah','blah','blah','blah','blah');
I am getting an error whenever I use this.

--
Steve M

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

On Jan 15, 2008 4:10 PM, Pastor Steve <smarquez@[Protected]> wrote:
> Thanks,
>
> Here it is:
>
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to use
> near 'order,edit,remove,section,type) VALUES
> ('blah','blah','blah','blah','blah')' at line 1

'order' is a reserved word. Quote it with backticks:

`order`

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

Best practice: Don't use reserved words for object (table, column,
constraint, etc.) names.
Here's your complete reserved word list for MySQL 5:
http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-refe
rence-reservedwords-5-0.html

-----Original Message-----
From: Rolando Edwards [mailto:redwards@[Protected]]
Sent: Tuesday, January 15, 2008 1:17 PM
To: Pastor Steve; MySQL List
Subject: RE: Error

ORDER is a reserved word in standard SQL

Example : SELECT FirstName,LastName FROM Names ORDER BY
LastName,FirstName;

If the column name in the table is ORDER, then put backquotes (`) around
the word ORDER when using it as a column name

INSERT INTO sections (`order`,edit,remove,section,type) VALUES
('blah','blah','blah','blah','blah');


-----Original Message-----
From: Pastor Steve [mailto:smarquez@[Protected]]
Sent: Tuesday, January 15, 2008 4:02 PM
To: MySQL List
Subject: Error

Greetings,

I am trying to enter this information into a database called cms_md,
with a table called sections.

INSERT INTO sections (order,edit,remove,section,type) VALUES
('blah','blah','blah','blah','blah');
I am getting an error whenever I use this.

--
Steve M

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=nicole.garris@[Protected]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

Here is corrent sql sentence.

INSERT INTO sections (`order`,`edit`,`remove`,`section`,`type`) VALUES
('blah','blah','blah','blah','blah');
The best habit is to use backquotes beside every column you used.

the oom-killer is a kernel function that shoots down [large|random]
processes when you start running out of memory. Google is your friend, as
are RAM vendors :-)


On Mon, Feb 8, 2010 at 8:22 AM, Krishna Chandra Prajapati <
prajapatikc@[Protected]> wrote:

> Hi List,
>
> I am getting the below error on my rhel server. Mysql is running on this
> box.
>
> Due to below error server hangs and stop responding. After system reboot
> it's working.
>
> Feb 7 02:38:29 DCTNMVH1 kernel: mysqld invoked oom-killer:
> gfp_mask=0x201d2,
> order=0, oomkilladj=0
> Feb 7 02:39:16 DCTNMVH1 kernel:
> Feb 7 02:39:54 DCTNMVH1 kernel: Call Trace:
> Feb 7 02:40:01 DCTNMVH1 kernel: [<ffffffff800c6076>]
> out_of_memory+0x8e/0x2f3
> Feb 7 02:40:06 DCTNMVH1 kernel: [<ffffffff8002e2f2>] __wake_up+0x38/0x4f
> Feb 7 02:40:06 DCTNMVH1 kernel: [<ffffffff8009fc0d>]
> autoremove_wake_function+0x0/0x2e
> Feb 7 02:40:06 DCTNMVH1 kernel: [<ffffffff8000f487>]
> __alloc_pages+0x245/0x2ce
> Feb 7 02:40:07 DCTNMVH1 kernel: [<ffffffff80012e03>]
> __do_page_cache_readahead+0x96/0x179
> Feb 7 02:40:07 DCTNMVH1 kernel: [<ffffffff80013765>]
> filemap_nopage+0x14c/0x360
> Feb 7 02:40:07 DCTNMVH1 kernel: [<ffffffff8000898c>]
> __handle_mm_fault+0x1fa/0xf99
> Feb 7 02:40:07 DCTNMVH1 kernel: [<ffffffff80066b25>]
> do_page_fault+0x4cb/0x830
> Feb 7 02:40:07 DCTNMVH1 kernel: [<ffffffff8009fc0d>]
> autoremove_wake_function+0x0/0x2e
> Feb 7 02:40:07 DCTNMVH1 kernel: [<ffffffff80128659>]
> file_has_perm+0x48/0xa3
> Feb 7 02:40:07 DCTNMVH1 kernel: [<ffffffff8005dde9>] error_exit+0x0/0x84
> Feb 7 02:40:07 DCTNMVH1 kernel: Node 1 Normal per-cpu:
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 0 hot: high 186, batch 31 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 0 cold: high 62, batch 15 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 1 hot: high 186, batch 31 used:40
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 1 cold: high 62, batch 15 used:15
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 2 hot: high 186, batch 31 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 2 cold: high 62, batch 15 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 3 hot: high 186, batch 31 used:56
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 3 cold: high 62, batch 15 used:14
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 4 hot: high 186, batch 31 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 4 cold: high 62, batch 15 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 5 hot: high 186, batch 31 used:61
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 5 cold: high 62, batch 15 used:14
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 6 hot: high 186, batch 31 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 6 cold: high 62, batch 15 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 7 hot: high 186, batch 31 used:2
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 7 cold: high 62, batch 15 used:58
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 8 hot: high 186, batch 31 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 8 cold: high 62, batch 15 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 9 hot: high 186, batch 31 used:25
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 9 cold: high 62, batch 15 used:44
>
> Is the error related to mysql. Any body else facing similar issues.
>
> Thanks,
> Krishna
>



--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

the oom-killer is a kernel function that shoots down [large|random]
processes when you start running out of memory. Google is your friend, as
are RAM vendors :-)


On Mon, Feb 8, 2010 at 8:22 AM, Krishna Chandra Prajapati <
prajapatikc@[Protected]> wrote:

> Hi List,
>
> I am getting the below error on my rhel server. Mysql is running on this
> box.
>
> Due to below error server hangs and stop responding. After system reboot
> it's working.
>
> Feb 7 02:38:29 DCTNMVH1 kernel: mysqld invoked oom-killer:
> gfp_mask=0x201d2,
> order=0, oomkilladj=0
> Feb 7 02:39:16 DCTNMVH1 kernel:
> Feb 7 02:39:54 DCTNMVH1 kernel: Call Trace:
> Feb 7 02:40:01 DCTNMVH1 kernel: [<ffffffff800c6076>]
> out_of_memory+0x8e/0x2f3
> Feb 7 02:40:06 DCTNMVH1 kernel: [<ffffffff8002e2f2>] __wake_up+0x38/0x4f
> Feb 7 02:40:06 DCTNMVH1 kernel: [<ffffffff8009fc0d>]
> autoremove_wake_function+0x0/0x2e
> Feb 7 02:40:06 DCTNMVH1 kernel: [<ffffffff8000f487>]
> __alloc_pages+0x245/0x2ce
> Feb 7 02:40:07 DCTNMVH1 kernel: [<ffffffff80012e03>]
> __do_page_cache_readahead+0x96/0x179
> Feb 7 02:40:07 DCTNMVH1 kernel: [<ffffffff80013765>]
> filemap_nopage+0x14c/0x360
> Feb 7 02:40:07 DCTNMVH1 kernel: [<ffffffff8000898c>]
> __handle_mm_fault+0x1fa/0xf99
> Feb 7 02:40:07 DCTNMVH1 kernel: [<ffffffff80066b25>]
> do_page_fault+0x4cb/0x830
> Feb 7 02:40:07 DCTNMVH1 kernel: [<ffffffff8009fc0d>]
> autoremove_wake_function+0x0/0x2e
> Feb 7 02:40:07 DCTNMVH1 kernel: [<ffffffff80128659>]
> file_has_perm+0x48/0xa3
> Feb 7 02:40:07 DCTNMVH1 kernel: [<ffffffff8005dde9>] error_exit+0x0/0x84
> Feb 7 02:40:07 DCTNMVH1 kernel: Node 1 Normal per-cpu:
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 0 hot: high 186, batch 31 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 0 cold: high 62, batch 15 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 1 hot: high 186, batch 31 used:40
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 1 cold: high 62, batch 15 used:15
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 2 hot: high 186, batch 31 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 2 cold: high 62, batch 15 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 3 hot: high 186, batch 31 used:56
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 3 cold: high 62, batch 15 used:14
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 4 hot: high 186, batch 31 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 4 cold: high 62, batch 15 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 5 hot: high 186, batch 31 used:61
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 5 cold: high 62, batch 15 used:14
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 6 hot: high 186, batch 31 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 6 cold: high 62, batch 15 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 7 hot: high 186, batch 31 used:2
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 7 cold: high 62, batch 15 used:58
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 8 hot: high 186, batch 31 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 8 cold: high 62, batch 15 used:0
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 9 hot: high 186, batch 31 used:25
> Feb 7 02:40:07 DCTNMVH1 kernel: cpu 9 cold: high 62, batch 15 used:44
>
> Is the error related to mysql. Any body else facing similar issues.
>
> Thanks,
> Krishna
>



--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel