MySQL error to syslog
HI, I am running MySQL 5.5.31 on FreeBSD 9.2. I have a web server with a miss-configured service that generates faulty connections. After a while, MySQl blocks any connection from the web server. At some stage, I had set-up a script that would browse syslog log and look for a string like Host 'xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' and would then issue a mysqladmin flush-hosts. But after an upgrade, MySQl stopped reporting to syslog. MySQL process is: databaseroot: ps auwwx | grep mysql mysql 81063 0.0 0.1 9852 1172 ?? Is3Dec14 0:00.18 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/database/mysql/my.cnf --user=mysql --datadir=/database/mysql --pid-file=/database/mysql/database.cs.ait.ac.th.pid --syslog mysql 81386 0.0 2.0 314712 42180 ?? I 3Dec14 8:19.75 /usr/local/libexec/mysqld --defaults-extra-file=/database/mysql/my.cnf --basedir=/usr/local --datadir=/database/mysql --plugin-dir=/usr/local/lib/mysql/plugin --user=mysql --pid-file=/database/mysql/database.cs.ait.ac.th.pid --socket=/tmp/mysql.sock --port=3306 Any help will be greatly appreciated. TIA, Olivier -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: MySQL Error#: 2002
Assuming you copied and pasted the error, it looks like the host made a typo in the config file: '/var/lib/myswl/mysql.sock' Should probably be mysql, not myswl. -Original Message- From: Rick James [mailto:rja...@yahoo-inc.com] Sent: Monday, March 18, 2013 3:32 PM To: Patrice Olivier-Wilson; mysql@lists.mysql.com Subject: RE: MySQL Error#: 2002 Check directory permissions, and check out the 'answers' in here: http://forums.mysql.com/read.php?10,284776,284936 -Original Message- From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] Sent: Monday, March 18, 2013 12:05 PM To: mysql@lists.mysql.com Subject: MySQL Error#: 2002 I have about 60 websites based on mysql and php. Suddenly they have all gone blank, just white pages. The files are still on the server and I can see the tables in all the databases via myphpadmin interfact. I'm not getting any response from hosting gods yet. When I try to connect to server via Dreamweaver, the error message is: MySQL Error#: 2002 Can't connect to local MySQL server through socket '/var/lib/myswl/mysql.sock'(111). I have one site that uses a different IP number that that site is ok. My static sites, ie, no database inclusion, are ok. Any ideas what to look for, most appreciated. Regards, Patrice Olivier-Wilson 828-628-0500 http://Biz-comm.com b...@biz-comm.com Everything will be alright in the end, so if it is not alright, it is not yet the end. - Quote from movie: The Best Exotic Marigold Hotel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LBI may, for any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: MySQL Error#: 2002
Check directory permissions, and check out the 'answers' in here: http://forums.mysql.com/read.php?10,284776,284936 -Original Message- From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] Sent: Monday, March 18, 2013 12:05 PM To: mysql@lists.mysql.com Subject: MySQL Error#: 2002 I have about 60 websites based on mysql and php. Suddenly they have all gone blank, just white pages. The files are still on the server and I can see the tables in all the databases via myphpadmin interfact. I'm not getting any response from hosting gods yet. When I try to connect to server via Dreamweaver, the error message is: MySQL Error#: 2002 Can't connect to local MySQL server through socket '/var/lib/myswl/mysql.sock'(111). I have one site that uses a different IP number that that site is ok. My static sites, ie, no database inclusion, are ok. Any ideas what to look for, most appreciated. Regards, Patrice Olivier-Wilson 828-628-0500 http://Biz-comm.com b...@biz-comm.com Everything will be alright in the end, so if it is not alright, it is not yet the end. - Quote from movie: The Best Exotic Marigold Hotel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
MySQL Error#: 2002
I have about 60 websites based on mysql and php. Suddenly they have all gone blank, just white pages. The files are still on the server and I can see the tables in all the databases via myphpadmin interfact. I'm not getting any response from hosting gods yet. When I try to connect to server via Dreamweaver, the error message is: MySQL Error#: 2002 Can't connect to local MySQL server through socket '/var/lib/myswl/mysql.sock'(111). I have one site that uses a different IP number that that site is ok. My static sites, ie, no database inclusion, are ok. Any ideas what to look for, most appreciated. Regards, Patrice Olivier-Wilson 828-628-0500 http://Biz-comm.com b...@biz-comm.com Everything will be alright in the end, so if it is not alright, it is not yet the end. - Quote from movie: The Best Exotic Marigold Hotel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
DBD::mysql error
MySQL 5.5.11 Perl 5.14.0 DBI 1.616 DBD::mysql 4.018 Installing the DBD::mysql on OS X Snow Leopard 10.6.6, I ran `perl Makefile.PL` fine but `make test` produced: # make test cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm /usr/bin/gcc-4.2 -c -I/sw/lib/perl5/site_perl/5.14.0/darwin-multi-2level/auto/DBI -I/usr/local/mysql/include -Os -g -fno-common -fno-strict-aliasing -arch x86_64 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -O2 -arch x86_64 -fno-common -DPERL_DARWIN -I/sw/include -no-cpp-precomp -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -I/opt/local/include -O3 -DVERSION=\4.018\ -DXS_VERSION=\4.018\ -I/sw/lib/perl5/5.14.0/darwin-multi-2level/CORE dbdimp.c dbdimp.c: In function 'mysql_db_FETCH_attrib': dbdimp.c:2447: error: 'sv_undef' undeclared (first use in this function) dbdimp.c:2447: error: (Each undeclared identifier is reported only once dbdimp.c:2447: error: for each function it appears in.) dbdimp.c: In function 'mysql_st_internal_execute41': dbdimp.c:3298: warning: format '%d' expects type 'int', but argument 3 has type 'my_ulonglong' dbdimp.c: In function 'mysql_describe': dbdimp.c:3517: warning: format '%d' expects type 'int', but argument 5 has type 'long unsigned int' dbdimp.c:3521: warning: format '%d' expects type 'int', but argument 3 has type 'long unsigned int' dbdimp.c: In function 'mysql_st_fetch': dbdimp.c:3738: warning: format '%d' expects type 'int', but argument 3 has type 'long int' dbdimp.c:3780: warning: format '%08lx' expects type 'long unsigned int', but argument 3 has type 'struct MYSQL_RES *' dbdimp.c:3782: warning: format '%llu' expects type 'long long unsigned int', but argument 3 has type 'unsigned int' dbdimp.c: In function 'mysql_st_FETCH_attrib': dbdimp.c:4365: warning: format '%d' expects type 'int', but argument 3 has type 'my_ulonglong' dbdimp.c: In function 'mysql_bind_ph': dbdimp.c:4571: warning: format '%d' expects type 'int', but argument 3 has type 'IV' dbdimp.c:4583: warning: format '%d' expects type 'int', but argument 3 has type 'IV' dbdimp.c:4595: warning: format '%d' expects type 'int', but argument 3 has type 'IV' dbdimp.c:4609: warning: format '%d' expects type 'int', but argument 3 has type 'IV' dbdimp.c:4630: warning: format '%d' expects type 'int', but argument 5 has type 'IV' make: *** [dbdimp.o] Error 1 What could be the cause of the errors? gvim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: [PHP] mysql error
On Thu, May 5, 2011 at 10:29, Grega Leskovšek legr...@gmail.com wrote: Can smbd please look at this sentence - I got an error and do not know how to fix it - I am still very unfamiliar with MYSQL: CREATE TABLE log ( idlog int auto_increment not null, imepriimek varchar(50), clock timestamp, action varchar(30), onfile varchar(100), filesize float(6,2), uniqueid(idlog) ); 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 '(idlog) )' at line 1 This is by no means a PHP question, and should not be asked on the PHP General mailing list. Please ask questions in the appropriate place; for this, the MySQL General list is the correct forum, and they've been CC'd. In the future, if it relates to a PHP database issue, you may want to use the PHP Database mailing list, also CC'd. This not only means you'll get more on-target help faster, but also helps in archiving data in the proper location for future searchers. -- /Daniel P. Brown Network Infrastructure Manager http://www.php.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: [PHP] mysql error
CREATE TABLE log ( idlog int auto_increment not null, imepriimek varchar(50), clock timestamp, action varchar(30), onfile varchar(100), filesize float(6,2), uniqueid(idlog) ); -- here is your mistake the syntax for that should be 'unique key(idlog)' if you only wanted to specify a unique key, but this is a mistake. as 'idlog' is marked auto-increment so I assume this is supposed to be the primary which is inherently unique. What you want is: CREATE TABLE log ( idlog int auto_increment primary key, imepriimek varchar(50), clock timestamp, action varchar(30), onfile varchar(100), filesize float(6,2)); On Thu, May 5, 2011 at 10:49 AM, Daniel Brown danbr...@php.net wrote: On Thu, May 5, 2011 at 10:29, Grega Leskovšek legr...@gmail.com wrote: Can smbd please look at this sentence - I got an error and do not know how to fix it - I am still very unfamiliar with MYSQL: CREATE TABLE log ( idlog int auto_increment not null, imepriimek varchar(50), clock timestamp, action varchar(30), onfile varchar(100), filesize float(6,2), uniqueid(idlog) ); 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 '(idlog) )' at line 1 This is by no means a PHP question, and should not be asked on the PHP General mailing list. Please ask questions in the appropriate place; for this, the MySQL General list is the correct forum, and they've been CC'd. In the future, if it relates to a PHP database issue, you may want to use the PHP Database mailing list, also CC'd. This not only means you'll get more on-target help faster, but also helps in archiving data in the proper location for future searchers. -- /Daniel P. Brown Network Infrastructure Manager http://www.php.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL Error 1045
Hello, A few days ago I ran into Error 1045 when attempting to add a new database user to my development machine. The error only occurred when trying to connect to the database as a new user which I found a little odd. After searching Google I discovered that this error is caused by a timeout - I should probably mention that my development machine is Win7 Ultimate 64-bit; I was using MySQL 5.1.45. Having no luck solving error 1045 I chose to uninstall MySQL and re-install the most up to date version from mysql.com being 5.1.50, again choosing Windows 64-bit. To uninstall I first went to the control panel to remove MySQL, however this did not remove the Windows service. I did find that running the installer file will remove existing services - which is how I was finally able to remove it. I believe I've now gotten as close to a clean uninstall of MySQL as I can at this point. When I run the installer now it gets up to the final processing configuration stage, but when it attempts to apply security settings I'm again presented with the dreaded error 1045 Access denied for user 'r...@localhost' (using password: YES). The error message goes on to suggest that I open TCP port 3306 in my firewall. This machine came pre-installed with McAfee AntiVirus Plus - for good or bad it's worked fine for me up until this point. I've opened port 3306 under Ports and System Services; yet the error still persists. Any thoughts on what I can do now? TIA, -Tim
Re: MySQL Error 1045
Ignore that ... it's amazing how you can solve problems with enough caffeine and enough time away from a computer screen . On 9/20/2010 10:58 PM, Tim Thorburn wrote: Hello, A few days ago I ran into Error 1045 when attempting to add a new database user to my development machine. The error only occurred when trying to connect to the database as a new user which I found a little odd. After searching Google I discovered that this error is caused by a timeout - I should probably mention that my development machine is Win7 Ultimate 64-bit; I was using MySQL 5.1.45. Any thoughts on what I can do now? TIA, -Tim
Re: MySQL Error 1045
Hi, On 21-9-2010 5:25, Tim Thorburn wrote: Ignore that ... it's amazing how you can solve problems with enough caffeine and enough time away from a computer screen . It's also amazing how frustrating it is for those who are searching for the problem you mentioned to only find threads with 'solutions' such as ignore this, found it myself, never mind, solved, etc. -- Kind regards / met vriendelijke groet, Jigal van Hemert. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql error causing database to not accept threads
Hi!
Machiel Richards wrote:
[[...]]
We received an error on a MySQL database this morning which
caused it to be unavailable for connections.
Error:
ERROR 1135 (0): Can't create a new thread (errno 11); if
you are not out of available memory, you can consult the manual for a
possible OS-dependent bug
[[...]]
You don't say anything about the MySQL version you are running, or your
platform.
I hope this here will help you, though:
| u...@h:~ fgrep 11 /usr/include/asm-generic/errno-base.h
| #define EAGAIN 11 /* Try again */
| u...@h:~ man pthread_create
| PTHREAD_CREATE(3P) POSIX Programmer's Manual
PTHREAD_CREATE(3P)
|
|
|
| NAME
|pthread_create - thread creation
|
| [[...]]
|
| ERRORS
|The pthread_create() function shall fail if:
|
|EAGAIN The system lacked the necessary resources to create
another thread, or the system-imposed
| limit on the total number of threads in a process
{PTHREAD_THREADS_MAX} would be exceeded.
|
| [[...]]
Jörg
--
Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com
Sun Microsystems GmbH, Komturstrasse 18a, D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz
Amtsgericht Muenchen: HRB161028
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Mysql error causing database to not accept threads
Hi Joerg
Thank you very much for the response.
I found an answer this morning (about 15 minutes ago) where the
server's Thread cache was used up and the amount of max connections exceeded
causing the same error.
We have not yet been able to establish the source of the amount of
connections though.
Machiel Richards
MySQL DBA
Relational Database Consulting
-Original Message-
From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com]
Sent: 30 June 2010 10:53 AM
To: mysql@lists.mysql.com
Cc: Machiel Richards
Subject: Re: Mysql error causing database to not accept threads
Hi!
Machiel Richards wrote:
[[...]]
We received an error on a MySQL database this morning
which
caused it to be unavailable for connections.
Error:
ERROR 1135 (0): Can't create a new thread (errno 11);
if
you are not out of available memory, you can consult the manual for a
possible OS-dependent bug
[[...]]
You don't say anything about the MySQL version you are running, or your
platform.
I hope this here will help you, though:
| u...@h:~ fgrep 11 /usr/include/asm-generic/errno-base.h
| #define EAGAIN 11 /* Try again */
| u...@h:~ man pthread_create
| PTHREAD_CREATE(3P) POSIX Programmer's Manual
PTHREAD_CREATE(3P)
|
|
|
| NAME
|pthread_create - thread creation
|
| [[...]]
|
| ERRORS
|The pthread_create() function shall fail if:
|
|EAGAIN The system lacked the necessary resources to create
another thread, or the system-imposed
| limit on the total number of threads in a process
{PTHREAD_THREADS_MAX} would be exceeded.
|
| [[...]]
Jörg
--
Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com
Sun Microsystems GmbH, Komturstrasse 18a, D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz
Amtsgericht Muenchen: HRB161028
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Mysql error causing database to not accept threads
Good morning all Hope everyone is well We received an error on a MySQL database this morning which caused it to be unavailable for connections. Error: ERROR 1135 (0): Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug I checked the system memory but this seemed to be fine. When I tried to restart the database, the shutdown just kept on running the whole time without shutting down the database. We then went to the drastic measure of restarting the server itself which then seemed to have sorted out the problem. The amount of connections to via the website was very minimal at that stage, however there was a script running which takes a data dump from an oracle database and imports this into the Mysql database and I suspect that it has something to do with this. I am trying to find out which settings / variables/ etc... we should check to find out where the problem is. One forum suggested changing the thread_cache_size to 512 , currently this is on 256. Hoping that someone can assist with this and much appreciated. Regards Machiel
Re: Mysql error causing database to not accept threads
Note that some of the memory settings are per connection, if you have 63 connections, you may have up to 63 copies of the buffers, and you have pretty huge buffers even with 30GB of memory. Join buffers close to 1 G, tmp_table_size of 2 G, 63 connections could mean upto 63 copies of these, and if each connection uses the full buffers, thats close to 200GB! You should adjust these to cater to the maximum number of connections expected. Did you try to check how much free memory you have when the problem occurs? Am 29.06.2010 10:17, schrieb Machiel Richards: ERROR 1135 (0): Can't create a new thread -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Mysql error causing database to not accept threads
Hi Yes, we did check the amount of free O/S memory and this was the same as during normal operating times when the system is working. Even the load averages on the system was very low. At the moment of this incident there was only 300 odd connections from the website where there are usually about 2000 + connections. As stated, the only other process running at that stage was the oracle import process, however after speaking to the person who implemented the imports scripts / process it was stated that this import makes one single connection and then imports relevant data within a single transaction. This import runs every 30 minutes so the amount of data being import is not that much and have not increased drastically so I am not yet sue as to where else to look. The only log created was that there was that no more threads could be created, even when trying to shutdown the MySQL database. I am not sure whether this could make a difference, however, but the server also runs an oracle database on the same server (not the database being imported from, only a slave oracle database)... I have also checked the ulimit settings and it seems that all the options in forums found thus far has been set to unlimited or to more than what is being suggested. Machiel Richards -Original Message- From: Benedikt Schackenberg [mailto:schackenb...@termindoc.de] Sent: 29 June 2010 10:57 AM To: mysql@lists.mysql.com Subject: Re: Mysql error causing database to not accept threads Note that some of the memory settings are per connection, if you have 63 connections, you may have up to 63 copies of the buffers, and you have pretty huge buffers even with 30GB of memory. Join buffers close to 1 G, tmp_table_size of 2 G, 63 connections could mean upto 63 copies of these, and if each connection uses the full buffers, thats close to 200GB! You should adjust these to cater to the maximum number of connections expected. Did you try to check how much free memory you have when the problem occurs? Am 29.06.2010 10:17, schrieb Machiel Richards: ERROR 1135 (0): Can't create a new thread -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=machiel.richa...@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
XAMMP and Mysql error
Hi, From yesterday 2009-08-26 i have an error message when my computer start. The mysqld.exe crash blablabla I search on g**gle 006B8853mysqld.exe and i find somebody in this mailing with this problem!! I don't change anything in my mysql config file, cause i didn't use mysql during the last month. I make some tests : 1- I lanch the mysql service --- ERROR the service command launched : C:\Program Files\Quiz\mysql\bin\mysqld --defaults-file=C:\Program Files\Quiz\mysql\bin\my.cnf mysql The files mysqld and my.cnf are used bellow so the 2 files work fine. 2- I lanch the mysql in console : mysql\bin\mysqld --defaults-file=mysql\bin\my.cnf --standalone --console --- OK I have the following version : MySQL 5.1.30 (Community Server) Here the err file : 090827 10:26:54 - mysqld got exception 0xc005 ; 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=16777216 read_buffer_size=262144 max_used_connections=0 max_threads=151 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133305 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x0 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... 006B8853mysqld.exe!??? The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Thanks for any help. -- Regards. Gabriel TESSIER LOGOSAPIENCE 3, Rue Pierre et Marie CURIE 49070 ST JEAN DE LINIERES +33 (0)2.41.36.81.41 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL error
We are running MySQL 5.0.45 on a Linux machine. Today, when I tried to go into MySQL via the command line, I got an error message: Can't connect to local MySQL server through socket '/usr/local/mysql/tmp/mysql.sock' The error log was full of the following messages: InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. We stopped MySQL and started it again and everything seems to be working. However, we would like to understand what happened. The strange thing here is that we are not using InnoDB tables so we don't understand why we are getting InnoDB errors and what it is trying to do with the ibdata1 file. We do have an ibdata1 file and ib_logfile files. Could it be that we are using InnoDB tables and we don't realize it? Could we have made a mistake somewhere? Is there a way to check this? Can we erase these files? Any help will be appreciated. Malki Cymbalista Webmaster, Weizmann Institute of Science Rehovot, Israel 76100 Internet: malki.cymbali...@weizmann.ac.il -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: MySQL error
If you do not want to use InnoDB at all, add this line to /etc/my.cnf under the [mysqld] section skip_innodb Then do the following service mysql stop rm -f /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile[01] service mysql start This will totally and cleanly disable InnoDB on the DB server Give it a try !!! Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: malki.cymbali...@weizmann.ac.il [mailto:malki.cymbali...@weizmann.ac.il] Sent: Monday, June 08, 2009 10:02 AM To: mysql@lists.mysql.com Cc: shlomit.af...@weizmann.ac.il Subject: MySQL error We are running MySQL 5.0.45 on a Linux machine. Today, when I tried to go into MySQL via the command line, I got an error message: Can't connect to local MySQL server through socket '/usr/local/mysql/tmp/mysql.sock' The error log was full of the following messages: InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. We stopped MySQL and started it again and everything seems to be working. However, we would like to understand what happened. The strange thing here is that we are not using InnoDB tables so we don't understand why we are getting InnoDB errors and what it is trying to do with the ibdata1 file. We do have an ibdata1 file and ib_logfile files. Could it be that we are using InnoDB tables and we don't realize it? Could we have made a mistake somewhere? Is there a way to check this? Can we erase these files? Any help will be appreciated. Malki Cymbalista Webmaster, Weizmann Institute of Science Rehovot, Israel 76100 Internet: malki.cymbali...@weizmann.ac.il -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: It happened agaIn this morning, but slightly different: [snip] thd=0x7fe0140c7e00 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=0xb, backtrace may not be correct. Bogus stack limit or frame pointer, fp=0xb, stack_bottom=0x4514, thread_stack=262144, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x1355140 = INSERT IGNORE INTO quarantine_archive SELECT * FROM quarantine WHERE state=1 AND domain='example.com' thd-thread_id=1493537 The context is the same as previously, except the query: INSERT IGNORE INTO quarantine_archive SELECT * FROM quarantine WHERE state=1 AND domain='example.com' This is not exactly reproducable, but it is fairly predictable - happens every morning towards 0600 - I have an archive job starting at 0500. For the last three days, the query has been roughly the same, except the 'example.com' varies. Is there nothing I can do to attempt to diagnose crashes such as this? Still no suggestions? /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: I have just discovered that my mysql server was restarted this morning, which is what gave me the 2013. In the log I found this: [snip] It happened agaIn this morning, but slightly different: [snip] thd=0x7fe0140c7e00 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=0xb, backtrace may not be correct. Bogus stack limit or frame pointer, fp=0xb, stack_bottom=0x4514, thread_stack=262144, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x1355140 = INSERT IGNORE INTO quarantine_archive SELECT * FROM quarantine WHERE state=1 AND domain='example.com' thd-thread_id=1493537 The context is the same as previously, except the query: INSERT IGNORE INTO quarantine_archive SELECT * FROM quarantine WHERE state=1 AND domain='example.com' It's getting to be a bit annoying - not all our apps were written to be able to handle the database connection disappearing at any time. Yes, they should have been, but it is a pretty unusual situation after all. Is there nothing I can do to attempt to diagnose crashes such as this? /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysql error 2013 Lost connection to MySQL server during query
This weekend we completed migrating a large(ish) mysql server from 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively smoothly, until this morning when I noticed an application had choked on getting Error 2013 Lost connection to MySQL server during query. The application is running remotely on 32bit using mysql library from version 5.0.67. I've been googling quite a bit, but haven't really found anything of any use. I've checked the two configurations, and they are the same. Can anyone help point me in the right direction? Thanks. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: This weekend we completed migrating a large(ish) mysql server from 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively smoothly, until this morning when I noticed an application had choked on getting Error 2013 Lost connection to MySQL server during query. I have just discovered that my mysql server was restarted this morning, which is what gave me the 2013. In the log I found this: 090525 6:04:35 - 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=6442450944 read_buffer_size=258048 max_used_connections=43 max_connections=100 threads_connected=26 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 6367855 Kbytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x7fa6fc0173e0 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=0xb, backtrace may not be correct. Bogus stack limit or frame pointer, fp=0xb, stack_bottom=0x41a6, thread_stack=262144, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x1340aa0 = SELECT domain,domain FROM dodgy_domain,spamdns_ipaddr WHERE dodgy_domain.ipaddr=spamdns_ipaddr.ipaddr group by domain having min(first)='2009-05-25 00:00:00' thd-thread_id=434983 /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Michael Dykman wrote: It might be helpful if you could tell us how you affected your data migration Sorry, I'm not familiar with reporting problems in/on mysql. The data migration was done with a full database dump (mysqldump) from the 32bit system, then a reload on the new 64bit system. I think it took 6-8 hours. and what kind of job was running at the time it went down. The job executing the SQL mentioned in the log ran on another server. It is a SELECT running from the command line (in a Makefile). I'm not sure what else to tell you. Having the server go away mid-query generally does mean you have run into a bug of some sort but, more often than not, you were doing something ill-advised at the time. The setup has been running for at least two years with no such problems. Let me know what other info would be interesting. best regards Per Jessen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
just a thought: Did you run mysql_upgrade after the import? On Mon, May 25, 2009 at 10:19 AM, Per Jessen p...@computer.org wrote: Michael Dykman wrote: It might be helpful if you could tell us how you affected your data migration Sorry, I'm not familiar with reporting problems in/on mysql. The data migration was done with a full database dump (mysqldump) from the 32bit system, then a reload on the new 64bit system. I think it took 6-8 hours. and what kind of job was running at the time it went down. The job executing the SQL mentioned in the log ran on another server. It is a SELECT running from the command line (in a Makefile). I'm not sure what else to tell you. Having the server go away mid-query generally does mean you have run into a bug of some sort but, more often than not, you were doing something ill-advised at the time. The setup has been running for at least two years with no such problems. Let me know what other info would be interesting. best regards Per Jessen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mikeisgr...@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: mysql error 2013 Lost connection to MySQL server during query
Michael Steinfeld wrote: just a thought: Did you run mysql_upgrade after the import? No, I didn't - I didn't think of it as I really only moved the data across. best regards Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: Michael Steinfeld wrote: just a thought: Did you run mysql_upgrade after the import? No, I didn't - I didn't think of it as I really only moved the data across. Okay, have done a mysqlcheck --check-upgrade - came back all clean. I don't see a need to run mysql_fix_privilege as I manually copied the necessary privilege data. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Have you tried running the offending SQL manually against you new installation? Does it come back clean in the isolated case? Is there anything else which runs against this database at night? crons? Could you post the script that you are running to give some context to the statement which winds up in your error log? Considering that you did use mysqldump to manually inject your data, cross-version incompatibilities are pretty much out of the question. - michael On Mon, May 25, 2009 at 11:19 AM, Per Jessen p...@computer.org wrote: Per Jessen wrote: Michael Steinfeld wrote: just a thought: Did you run mysql_upgrade after the import? No, I didn't - I didn't think of it as I really only moved the data across. Okay, have done a mysqlcheck --check-upgrade - came back all clean. I don't see a need to run mysql_fix_privilege as I manually copied the necessary privilege data. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
On Mon, May 25, 2009 at 11:19 AM, Per Jessen p...@computer.org wrote: Per Jessen wrote: Michael Steinfeld wrote: just a thought: Did you run mysql_upgrade after the import? No, I didn't - I didn't think of it as I really only moved the data across. I suspect that will solve your issue. Keep me posted. Okay, have done a mysqlcheck --check-upgrade - came back all clean. I don't see a need to run mysql_fix_privilege as I manually copied the necessary privilege data. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mikeisgr...@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: mysql error 2013 Lost connection to MySQL server during query
Michael Dykman wrote: Have you tried running the offending SQL manually against you new installation? Does it come back clean in the isolated case? No, not manually, but the job/the SQL is run several times a day, maybe 2-3 times per hour. Is there anything else which runs against this database at night? crons? Yes, lots of stuff. Cron-jobs, jobs submitted by daemons, etc. Could you post the script that you are running to give some context to the statement which winds up in your error log? I'm generating a zonefile for rbldnsd with entries from my table since midnight. Entries from before midnight are put in a main-table, entries after are in this regular diff. The statement is this: SELECT domain,domain FROM dodgy_domain,spamdns_ipaddr WHERE dodgy_domain.ipaddr=spamdns_ipaddr.ipaddr group by domain having min(first)='midnight' Tonight it will be changed to: (single domain, not domain,domain) SELECT domain FROM dodgy_domain,spamdns_ipaddr WHERE dodgy_domain.ipaddr=spamdns_ipaddr.ipaddr group by domain having min(first)='midnight' Additional context: The server is brandnew, an HP Proliant with dual quad-core Xeons and 10Gb RAM. The filesystem is JFS on hardware RAID6. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: Michael Dykman wrote: Have you tried running the offending SQL manually against you new installation? Does it come back clean in the isolated case? No, not manually, but the job/the SQL is run several times a day, maybe 2-3 times per hour. I've also just run the query manually a couple of times, no problems. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Given the new hardware, I'm now suspecting the RAID controller. I have seen misconfigured RAIDs or bad RAID drivers take out a server in just such a manner. I had a debian server connected to an EMC SAN.. As debian isn't supported, we had this open-source driver which gave us no end of problems. If a logical drive acts up or does something unexpected, MySQL could react to that in a manner consistent with what you are seeing in your log. I would be tempted to put the hardware through a stress test. I know that's not much help. - michael On Mon, May 25, 2009 at 12:02 PM, Per Jessen p...@computer.org wrote: Per Jessen wrote: Michael Dykman wrote: Have you tried running the offending SQL manually against you new installation? Does it come back clean in the isolated case? No, not manually, but the job/the SQL is run several times a day, maybe 2-3 times per hour. I've also just run the query manually a couple of times, no problems. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Michael Dykman wrote: Given the new hardware, I'm now suspecting the RAID controller. I have seen misconfigured RAIDs or bad RAID drivers take out a server in just such a manner. I had a debian server connected to an EMC SAN.. As debian isn't supported, we had this open-source driver which gave us no end of problems. If a logical drive acts up or does something unexpected, MySQL could react to that in a manner consistent with what you are seeing in your log. Shouldn't/wouldn't the filesystem complain first? There is a lot of activity on the filesystem, mysql is just a tiny part of it. I would be tempted to put the hardware through a stress test. I know that's not much help. I really have no reason to suspect the hardware. It's new, but it's been running in burn-in mode for about a month (although not with much load, mostly idling). I might as well suspect the mysql build and try upgrading to a newer one. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
The issues that we saw only came to light under stress. The application I am referring to ran under a fair bit of load at the best of times but it was during sustained spikes that the flaws in our driver made themselves apparent. Mind you, we weren't using JFS, so I'm not sure how that would have reacted. - michael On Mon, May 25, 2009 at 12:19 PM, Per Jessen p...@computer.org wrote: Michael Dykman wrote: Given the new hardware, I'm now suspecting the RAID controller. I have seen misconfigured RAIDs or bad RAID drivers take out a server in just such a manner. I had a debian server connected to an EMC SAN.. As debian isn't supported, we had this open-source driver which gave us no end of problems. If a logical drive acts up or does something unexpected, MySQL could react to that in a manner consistent with what you are seeing in your log. Shouldn't/wouldn't the filesystem complain first? There is a lot of activity on the filesystem, mysql is just a tiny part of it. I would be tempted to put the hardware through a stress test. I know that's not much help. I really have no reason to suspect the hardware. It's new, but it's been running in burn-in mode for about a month (although not with much load, mostly idling). I might as well suspect the mysql build and try upgrading to a newer one. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Hi Per, Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf file. Are these queries appearing in your slow query logs?What is your LOG_QUERY_TIMES set too? Here are some other settings you may want to play around wtih CONNECT_TIMEOUT INTERACTIVE_TIMEOUT WAIT_TIMEOUT NET_WRITE_TIMEOUT NET_READ_TIMEOUT MAX_CONNECT_ERRORS On Mon, May 25, 2009 at 3:06 AM, Per Jessen p...@computer.org wrote: This weekend we completed migrating a large(ish) mysql server from 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively smoothly, until this morning when I noticed an application had choked on getting Error 2013 Lost connection to MySQL server during query. The application is running remotely on 32bit using mysql library from version 5.0.67. I've been googling quite a bit, but haven't really found anything of any use. I've checked the two configurations, and they are the same. Can anyone help point me in the right direction? Thanks. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dstepli...@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: mysql error 2013 Lost connection to MySQL server during query
Darryle Steplight wrote: Hi Per, Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf file. Are these queries appearing in your slow query logs?What is your LOG_QUERY_TIMES set too? Here are some other settings you may want to play around wtih CONNECT_TIMEOUT INTERACTIVE_TIMEOUT WAIT_TIMEOUT NET_WRITE_TIMEOUT NET_READ_TIMEOUT MAX_CONNECT_ERRORS Hi Darryle I did notice references to some of those when I was googling, but because I didn't change any settings in my migration except up the key_buffer space, I didn't really pay much attention. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL Error Number 1045 Access denied
Hi Andrew, I think he means re-install MySQL and provide a root password (you said when you originally installed it that you didn't give it a password.) After you've done this, try mysql from the command-line explicitly telling it to use the user root: mysql --user=root --password The --password here tells mysql to prompt you for a password, or alternatively you can provide the password on the command-line too: mysql --user=root --password=password Once you can login via the command-line there's no reason why the Admin GUI shouldn't be able to login too. Regards, Andy Quoting AndrewMcHorney [EMAIL PROTECTED]: How does one done this? At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote: Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release Date: 8/16/2008 5:12 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Andy Shellam Business Systems Architect Network Mail NetServe Support -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error Number 1045 Access denied
Alternatively you can try this if the box is unix/linux : sudo mysqld_safe --skip-grant-tables --user=root mysql -u root Change your root password Restart mysql after this. Cheers Sharad Andy Shellam wrote: Hi Andrew, I think he means re-install MySQL and provide a root password (you said when you originally installed it that you didn't give it a password.) After you've done this, try mysql from the command-line explicitly telling it to use the user root: mysql --user=root --password The --password here tells mysql to prompt you for a password, or alternatively you can provide the password on the command-line too: mysql --user=root --password=password Once you can login via the command-line there's no reason why the Admin GUI shouldn't be able to login too. Regards, Andy Quoting AndrewMcHorney [EMAIL PROTECTED]: How does one done this? At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote: Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release Date: 8/16/2008 5:12 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error Number 1045 Access denied
FYI,
I don't think this was sent to the list, forgive me if it was and I
didn't see it.
Andy
--
You probably don't have to reinstall it. If you never gave root a
password, just login as Andy says below and, when prompted for the
password, just press the ENTER key. Unless you gave root a password and
forgot it, you should find yourself in the mysql program. Enter
something like:
update mysql.user set password = password('new pwd') where user = 'root';
flush privileges;
There are other ways to change a pwd, but I use that since it's easier
for me to remember one way.
Jim
On Mon, Aug 18, 2008 at 3:07 AM, Andy Shellam
[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Hi Andrew,
I think he means re-install MySQL and provide a root password (you
said when you originally installed it that you didn't give it a
password.)
After you've done this, try mysql from the command-line explicitly
telling it to use the user root:
mysql --user=root --password
The --password here tells mysql to prompt you for a password, or
alternatively you can provide the password on the command-line too:
mysql --user=root --password=password
Once you can login via the command-line there's no reason why the
Admin GUI shouldn't be able to login too.
Regards,
Andy
Quoting AndrewMcHorney [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]:
How does one done this?
At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote:
Hi Andrew
As per your Question , you can test with the below
solution :-
Try to reconfigure MySQL by providing the root
password and then
try to run the
administer GUI. This should solve the problem.
CHAVA
On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]wrote:
Hello
I am still getting the MySQL Error Number 1045 Access
denied error message
when running the adminstrator gui. I attempted to start
mysql from the dos
command line via mysql and I am getting the following.
ERROR 1045 (28000):
Access denied for user 'ODBC'@'localhost' (using
password: NO). I am
logging in as root, locahost and no password because I
did not enter one
when I installed the software. I will be changing that.
For the command line
I just entered mysql and a return. How can I fix this. I
am off for the week
and I would like to get this working so I can create a
database or 2.
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Sreekanth CHAVA
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release
Date: 8/16/2008 5:12 PM
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Andy Shellam
Business Systems Architect
Network Mail
NetServe Support
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error Number 1045 Access denied
If you are desperate, you can also start mysqld with --skip-grant-tables
option.
Then use mysql, update root password using the update statement that Jim
wrote about.
-Paul
On Mon, 2008-08-18 at 17:25 +0100, Andy Shellam wrote:
FYI,
I don't think this was sent to the list, forgive me if it was and I
didn't see it.
Andy
--
You probably don't have to reinstall it. If you never gave root a
password, just login as Andy says below and, when prompted for the
password, just press the ENTER key. Unless you gave root a password and
forgot it, you should find yourself in the mysql program. Enter
something like:
update mysql.user set password = password('new pwd') where user = 'root';
flush privileges;
There are other ways to change a pwd, but I use that since it's easier
for me to remember one way.
Jim
On Mon, Aug 18, 2008 at 3:07 AM, Andy Shellam
[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Hi Andrew,
I think he means re-install MySQL and provide a root password (you
said when you originally installed it that you didn't give it a
password.)
After you've done this, try mysql from the command-line explicitly
telling it to use the user root:
mysql --user=root --password
The --password here tells mysql to prompt you for a password, or
alternatively you can provide the password on the command-line too:
mysql --user=root --password=password
Once you can login via the command-line there's no reason why the
Admin GUI shouldn't be able to login too.
Regards,
Andy
Quoting AndrewMcHorney [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]:
How does one done this?
At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote:
Hi Andrew
As per your Question , you can test with the below
solution :-
Try to reconfigure MySQL by providing the root
password and then
try to run the
administer GUI. This should solve the problem.
CHAVA
On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]wrote:
Hello
I am still getting the MySQL Error Number 1045 Access
denied error message
when running the adminstrator gui. I attempted to start
mysql from the dos
command line via mysql and I am getting the following.
ERROR 1045 (28000):
Access denied for user 'ODBC'@'localhost' (using
password: NO). I am
logging in as root, locahost and no password because I
did not enter one
when I installed the software. I will be changing that.
For the command line
I just entered mysql and a return. How can I fix this. I
am off for the week
and I would like to get this working so I can create a
database or 2.
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Sreekanth CHAVA
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release
Date: 8/16/2008 5:12 PM
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Andy Shellam
Business Systems Architect
Network Mail
NetServe Support
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul Choi [EMAIL PROTECTED]
Re: MySQL Error Number 1045 Access denied
Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA
Re: MySQL Error Number 1045 Access denied
How does one done this? At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote: Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release Date: 8/16/2008 5:12 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Error Number 1045 Access denied
Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Odd item in MySql error log
MySql 5.0.41 SUSE 10.2 Linux dbms-04-r1 2.6.18.2-34-default #1 SMP Mon Nov 27 11:46:27 UTC 2006 x86_64 x86_64 x86_64 GNU/Linux Dear MySql, I have an odd item in my error log, I wonder if you can tell me what this means? Also whether should do anything about it? (This table once corrupted before, I could not start MySql, and had several hours downtime recovering it...) 071219 0:00:15 InnoDB: Error: trying to declare trx to enter InnoDB, but InnoDB: it already is declared. TRANSACTION 0 3825296174, ACTIVE 0 sec, process no 6929, OS thread id 1141946688, thread declared inside InnoDB 0 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368 MySQL thread id 16, query id 158 fls-16-03.roadtech.private 172.16.14.12 sdi update INSERT INTO terminal_log (mem_code, terminal_id, last_call, latitude, longitude, speed_knots, course, cablink_string, ip_addr, temperature) VALUES ( NULL , '35126600409511509' , '2007-12-18 23:59:58' , '5.150556400501e+01' , '-3.696216681689e-01' , '8.00016653e-02' , '1.0 Many thanks! Ben Clewett. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Odd item in MySql error log
Good Morning Ben this is an acknowledged bug http://bugs.mysql.com/bug.php?id=20090 which was fixed in 5.1.22-beta + can you upgrade? Martin-- - Original Message - From: Ben Clewett [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, December 21, 2007 4:52 AM Subject: Odd item in MySql error log MySql 5.0.41 SUSE 10.2 Linux dbms-04-r1 2.6.18.2-34-default #1 SMP Mon Nov 27 11:46:27 UTC 2006 x86_64 x86_64 x86_64 GNU/Linux Dear MySql, I have an odd item in my error log, I wonder if you can tell me what this means? Also whether should do anything about it? (This table once corrupted before, I could not start MySql, and had several hours downtime recovering it...) 071219 0:00:15 InnoDB: Error: trying to declare trx to enter InnoDB, but InnoDB: it already is declared. TRANSACTION 0 3825296174, ACTIVE 0 sec, process no 6929, OS thread id 1141946688, thread declared inside InnoDB 0 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368 MySQL thread id 16, query id 158 fls-16-03.roadtech.private 172.16.14.12 sdi update INSERT INTO terminal_log (mem_code, terminal_id, last_call, latitude, longitude, speed_knots, course, cablink_string, ip_addr, temperature) VALUES ( NULL , '35126600409511509' , '2007-12-18 23:59:58' , '5.150556400501e+01' , '-3.696216681689e-01' , '8.00016653e-02' , '1.0 Many thanks! Ben Clewett. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: recovering from 'disk full' mysql error
stop slave;
change master to master_log_file='Relay_Master_Log_File' ,
master_log_pos=Exec_master_log_pos;
#Get the values for the above command from your show slave status output.
start slave;
The above process should fix your problem.
On 9/4/07, Russell E Glaue [EMAIL PROTECTED] wrote:
I had a disk full error on the master MySQL (4.1.22), which was
replicating to a
slave (4.1.22).
My question is, how do I recover a slave replica when the master had a
disk full
error, space was freed, but the 'disk full' issue left a corrupted master
binlog?
1) Do I have to reinitialize the slave from scratch,
2) or can I use some CLI tool to repair the damaged binlog (see below)
3) or can I skip to the next binlog
This is assuming I performed a stop and start of the master mysql, then
'purge
binary logs' from master.
And would the resolution be the same if I did not start and stop the
master mysql?
According to bug 9949 (http://bugs.mysql.com/bug.php?id=9949) this was
addressed
in 4.1.9.
I am running 4.1.22, and have experienced this issue as outlined.
I am not finding a good sum of reasoning and process to proceed with
resolving
this type of predicament. Can anyone clue me in to resolving this?
I purged enough binlogs to free up disk space on master, and then started
the
slave replica process on the slave.
I get this famous error:
-
070904 12:46:26 [Note] Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log '
master1-bin.54' at
position 138164107
070904 12:46:26 [ERROR] Error reading packet from server: binlog truncated
in
the middle of event (server_errno=1236)
070904 12:46:26 [ERROR] Got fatal error 1236: 'binlog truncated in the
middle of
event' from master when reading data from binary log
-
I do a binlog dump on 'master1-bin.54', and I get the below error
('Error in
log format or read error') at the end of the output:
-
#070904 11:46:22 server id 2 end_log_pos 137541177 Query
thread_id=48871
exec_time=0 error_code=0
#070904 11:46:22 server id 2 end_log_pos 137655584 Query
thread_id=48871
exec_time=0 error_code=0
#070904 11:46:22 server id 2 end_log_pos 137655719 Query
thread_id=48773
exec_time=0 error_code=0
#070904 11:46:22 server id 2 end_log_pos 137770204 Query
thread_id=48773
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 137770339 Query
thread_id=48870
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 137962851 Query
thread_id=48870
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 137962986 Query
thread_id=48871
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 138152129 Query
thread_id=48871
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 138152264 Query
thread_id=48773
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 138163972 Query
thread_id=48773
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 138164107 Query
thread_id=48870
exec_time=0 error_code=0
ERROR: Error in Log_event::read_log_event(): 'read error', data_len:
81904,
event_type: 2
Could not read entry at offset 138164107:Error in log format or read error
-
-RG
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Thanks
Alex
http://alexlurthu.wordpress.com
Re: recovering from 'disk full' mysql error
Ya, I did that.
I read elsewhere that this was recommended for 4.1.9+.
I did
stop slave;
change master to master_log_file='{Relay_Master_Log_File}',
master_log_pos={Exec_master_log_pos};
start slave
And it gave the same error.
That is when I checked the binlogs and saw that it was corrupted at
{Exec_master_log_pos}
MySQL does not want to move past that corrupted position in the binlogs.
Any attempt to start at a position after the corrupted position does not work
either.
I had to flush the logs on master and use the next incremented binlog. But I had
to completely reinitialize the slave because from the corrupted position to the
next new binlog there was additional data updates for master mysql that did not
get replicated to the slave due to the corrupted binlog issue I am referring to
in this post.
If you have personally verified these steps you outlined work, please list what
MySQL versions these steps successfully worked on.
I am using 4.1.22 in this scenario.
-RG
Alex Arul Lurthu wrote:
stop slave;
change master to master_log_file='Relay_Master_Log_File' ,
master_log_pos=Exec_master_log_pos;
#Get the values for the above command from your show slave status output.
start slave;
The above process should fix your problem.
On 9/4/07, *Russell E Glaue* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
wrote:
I had a disk full error on the master MySQL (4.1.22), which was
replicating to a
slave (4.1.22 ).
My question is, how do I recover a slave replica when the master had
a disk full
error, space was freed, but the 'disk full' issue left a corrupted
master binlog?
1) Do I have to reinitialize the slave from scratch,
2) or can I use some CLI tool to repair the damaged binlog (see below)
3) or can I skip to the next binlog
This is assuming I performed a stop and start of the master mysql,
then 'purge
binary logs' from master.
And would the resolution be the same if I did not start and stop the
master mysql?
According to bug 9949 (http://bugs.mysql.com/bug.php?id=9949) this
was addressed
in 4.1.9.
I am running 4.1.22, and have experienced this issue as outlined.
I am not finding a good sum of reasoning and process to proceed with
resolving
this type of predicament. Can anyone clue me in to resolving this?
I purged enough binlogs to free up disk space on master, and then
started the
slave replica process on the slave.
I get this famous error:
-
070904 12:46:26 [Note] Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log
'master1-bin.54' at
position 138164107
070904 12:46:26 [ERROR] Error reading packet from server: binlog
truncated in
the middle of event (server_errno=1236)
070904 12:46:26 [ERROR] Got fatal error 1236: 'binlog truncated in
the middle of
event' from master when reading data from binary log
-
I do a binlog dump on 'master1-bin.54', and I get the below
error ('Error in
log format or read error') at the end of the output:
-
#070904 11:46:22 server id 2 end_log_pos 137541177 Query
thread_id=48871
exec_time=0 error_code=0
#070904 11:46:22 server id 2 end_log_pos 137655584 Query
thread_id=48871
exec_time=0 error_code=0
#070904 11:46:22 server id 2 end_log_pos 137655719 Query
thread_id=48773
exec_time=0 error_code=0
#070904 11:46:22 server id 2 end_log_pos 137770204 Query
thread_id=48773
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 137770339 Query
thread_id=48870
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 137962851 Query
thread_id=48870
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 137962986 Query
thread_id=48871
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 138152129 Query
thread_id=48871
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 138152264 Query
thread_id=48773
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 138163972 Query
thread_id=48773
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 138164107 Query
thread_id=48870
exec_time=0 error_code=0
ERROR: Error in Log_event::read_log_event(): 'read error', data_len:
81904,
event_type: 2
Could not read entry at offset 138164107:Error in log format or read
error
-
-RG
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
http://lists.mysql.com/mysql
To
unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Thanks
Alex
recovering from 'disk full' mysql error
I had a disk full error on the master MySQL (4.1.22), which was replicating to a
slave (4.1.22).
My question is, how do I recover a slave replica when the master had a disk full
error, space was freed, but the 'disk full' issue left a corrupted master
binlog?
1) Do I have to reinitialize the slave from scratch,
2) or can I use some CLI tool to repair the damaged binlog (see below)
3) or can I skip to the next binlog
This is assuming I performed a stop and start of the master mysql, then 'purge
binary logs' from master.
And would the resolution be the same if I did not start and stop the master
mysql?
According to bug 9949 (http://bugs.mysql.com/bug.php?id=9949) this was addressed
in 4.1.9.
I am running 4.1.22, and have experienced this issue as outlined.
I am not finding a good sum of reasoning and process to proceed with resolving
this type of predicament. Can anyone clue me in to resolving this?
I purged enough binlogs to free up disk space on master, and then started the
slave replica process on the slave.
I get this famous error:
-
070904 12:46:26 [Note] Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log 'master1-bin.54' at
position 138164107
070904 12:46:26 [ERROR] Error reading packet from server: binlog truncated in
the middle of event (server_errno=1236)
070904 12:46:26 [ERROR] Got fatal error 1236: 'binlog truncated in the middle of
event' from master when reading data from binary log
-
I do a binlog dump on 'master1-bin.54', and I get the below error ('Error in
log format or read error') at the end of the output:
-
#070904 11:46:22 server id 2 end_log_pos 137541177 Query thread_id=48871
exec_time=0 error_code=0
#070904 11:46:22 server id 2 end_log_pos 137655584 Query thread_id=48871
exec_time=0 error_code=0
#070904 11:46:22 server id 2 end_log_pos 137655719 Query thread_id=48773
exec_time=0 error_code=0
#070904 11:46:22 server id 2 end_log_pos 137770204 Query thread_id=48773
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 137770339 Query thread_id=48870
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 137962851 Query thread_id=48870
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 137962986 Query thread_id=48871
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 138152129 Query thread_id=48871
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 138152264 Query thread_id=48773
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 138163972 Query thread_id=48773
exec_time=0 error_code=0
#070904 11:46:24 server id 2 end_log_pos 138164107 Query thread_id=48870
exec_time=0 error_code=0
ERROR: Error in Log_event::read_log_event(): 'read error', data_len: 81904,
event_type: 2
Could not read entry at offset 138164107:Error in log format or read error
-
-RG
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL ERROR on DELETE
Hi there ! Does anyone knows if there is a specific MySQL ERROR (SQLSATE) for DELETE of a not found key? I have tried MySQL Error 1032 e 1176 (SQLSTATE HY000) but it does not seems to work .. Thanks in advance Nilson
mysql error
Hello all. I noticed that the last entry in mysql error log was two weeks ago. Can some one tell me why mysql is not writing to this log This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql error
Have you had any errors in the last 2 weeks? Have you restarted your server in the last 2 weeks? Your problem might just be a symptom of no problem at all. - michael On 8/20/07, Brown, Charles [EMAIL PROTECTED] wrote: Hello all. I noticed that the last entry in mysql error log was two weeks ago. Can some one tell me why mysql is not writing to this log This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql error
A common issue a lot of people have is this rm logfile if the mysql server is still accessing that file it will not continue to write to that file again till mysql is restarted if that was the case the proper way to clear a log and keep the server running is cp /dev/null logfile On 8/20/07, Brown, Charles [EMAIL PROTECTED] wrote: Hello all. I noticed that the last entry in mysql error log was two weeks ago. Can some one tell me why mysql is not writing to this log This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql error.
Hi All, In my master db, bin-log was not getting generated due to space issue, so i shut it down using 'mysqladmin shutdown. I cleared some old bin-logs and when i restart mysql using mysqld_safe, i am getting below error. I checked for any other mysqld process, but did not find any. Please help ps -ef | grep mysqld mysql 9125 9019 0 22:57 pts/000:00:00 grep mysqld InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /data/mysql/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /data/mysql/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 070620 21:51:09 InnoDB: Unable to open the first data file InnoDB: Error in opening /data/mysql/ibdata1 070620 21:51:09 InnoDB: Operating system error number 11 in a file operation. InnoDB: Error number 11 means 'Resource temporarily unavailable'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html InnoDB: Could not open or create data files. InnoDB: If you tried to add new data files, and it failed here, InnoDB: you should now edit innodb_data_file_path in my.cnf back InnoDB: to what it was, and remove the new ibdata files InnoDB created InnoDB: in this failed attempt. InnoDB only wrote those files full of InnoDB: zeros, but did not yet use them in any way. But be careful: do not InnoDB: remove old data files which contain your precious data! 070620 21:51:09 [ERROR] Default storage engine (InnoDB) is not available 070620 21:51:09 [ERROR] Aborting
Re: mysql error.
very wisely taken topic mysql error. ... Ananda Kumar schrieb: [...] I cleared some old bin-logs and when i restart mysql using mysqld_safe [...] InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /data/mysql/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /data/mysql/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 070620 21:51:09 InnoDB: Unable to open the first data file InnoDB: Error in opening /data/mysql/ibdata1 070620 21:51:09 InnoDB: Operating system error number 11 in a file operation. InnoDB: Error number 11 means 'Resource temporarily unavailable'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html InnoDB: Could not open or create data files. InnoDB: If you tried to add new data files, and it failed here, InnoDB: you should now edit innodb_data_file_path in my.cnf back InnoDB: to what it was, and remove the new ibdata files InnoDB created InnoDB: in this failed attempt. InnoDB only wrote those files full of InnoDB: zeros, but did not yet use them in any way. But be careful: do not InnoDB: remove old data files which contain your precious data! did you do the above mentioned? remove old ibdata file? also check permissions -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql error.
Hi Sebastian, I did not remove any ibdata files. They are present. regards anandkl On 6/21/07, Sebastian Mendel [EMAIL PROTECTED] wrote: very wisely taken topic mysql error. ... Ananda Kumar schrieb: [...] I cleared some old bin-logs and when i restart mysql using mysqld_safe [...] InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /data/mysql/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /data/mysql/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 070620 21:51:09 InnoDB: Unable to open the first data file InnoDB: Error in opening /data/mysql/ibdata1 070620 21:51:09 InnoDB: Operating system error number 11 in a file operation. InnoDB: Error number 11 means 'Resource temporarily unavailable'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html InnoDB: Could not open or create data files. InnoDB: If you tried to add new data files, and it failed here, InnoDB: you should now edit innodb_data_file_path in my.cnf back InnoDB: to what it was, and remove the new ibdata files InnoDB created InnoDB: in this failed attempt. InnoDB only wrote those files full of InnoDB: zeros, but did not yet use them in any way. But be careful: do not InnoDB: remove old data files which contain your precious data! did you do the above mentioned? remove old ibdata file? also check permissions -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Error for Blobs
I got an error while entering an BMP image of 1.7MB size in a mediumblob field through MS Access 2003 with MyODBC 3.51.12 on Windows XP SP2 also with MySQL Query Browser and Navicat GUI tool. Navicat returned the error as 'Got a packet bigger than Max_allowed_packet bytes'. What this means?. Access and Query browser simple gives error as MySQL has gone away? Why? please help. Also please give a solution if we have to insert images/Other Objects of size more than 1 MB what we have to do using ODBC driver with/without MS Access VB.net? Thanks CPK
Re: MySQL Error for Blobs
max_allowed_packet is the maximum size of a single SQL statement. It's a setting on the server, as well as for the mysql command line interface. See http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html I think 1 MB is the default; the maximum setting for MySQL 5 is 1 GB. You can adjust this setting in the server config files (my.cnf or my.ini). I do not know if you need to adjust anything in Navicat, ODBC, Query Browser or Access - sorry! Dan On 11/16/06, C K [EMAIL PROTECTED] wrote: I got an error while entering an BMP image of 1.7MB size in a mediumblob field through MS Access 2003 with MyODBC 3.51.12 on Windows XP SP2 also with MySQL Query Browser and Navicat GUI tool. Navicat returned the error as 'Got a packet bigger than Max_allowed_packet bytes'. What this means?. Access and Query browser simple gives error as MySQL has gone away? Why? please help. Also please give a solution if we have to insert images/Other Objects of size more than 1 MB what we have to do using ODBC driver with/without MS Access VB.net? Thanks CPK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Error for Blobs
When a query exceeds the size of the maximum allowed packet, mysqld closes the connection. It assumes something has gone wrong with the client. There are two max_allowed_packet variables, one for the server and one for the client. This is documented in section A.2.9 of the documentation http://www.mysql.org/doc/refman/4.1/en/packet-too-large.html Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: C K [mailto:[EMAIL PROTECTED] Sent: Thursday, November 16, 2006 12:46 PM To: mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: MySQL Error for Blobs I got an error while entering an BMP image of 1.7MB size in a mediumblob field through MS Access 2003 with MyODBC 3.51.12 on Windows XP SP2 also with MySQL Query Browser and Navicat GUI tool. Navicat returned the error as 'Got a packet bigger than Max_allowed_packet bytes'. What this means?. Access and Query browser simple gives error as MySQL has gone away? Why? please help. Also please give a solution if we have to insert images/Other Objects of size more than 1 MB what we have to do using ODBC driver with/without MS Access VB.net? Thanks CPK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql Error Number 1130
Wow, I found the problem! I think this may be a bug. In my case, I've got three instances running on ports 3306, 3307, and 3320. On the local machine, I connect to them via mysql -p --port-3306 --host=localhost mysql -p --port-3307 --host=localhost mysql -p --port-3320 --host=localhost Except that connecting to port 3307 doesn't really happen. It seems that the command line client connects to the main instance via the default socket when the host is not specified, or is the value localhost. So, even though I've specified the host and port, I wind up connecting to the main instance. I found this out by stopping the main instance on 3306, and then I issue: LX09:/etc # mysql --port=3307 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib /mysql/mysql.sock' (2) LX09:/etc # mysql --port=3307 --host=localhost ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib /mysql/mysql.sock' (2) LX09:/etc # mysql --port=3307 --host=127.0.0.1 -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. LX09:/etc # mysql --port=3307 --host=nnn.nnn.nnn.nnn -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Note that /var/lib/mysql/mysql.sock is the socket associated with the main instance, not the alternates. It seems that if I *specify* a port, then mysql ought to use that port. It only seems to be an issue when not specifying a --host, or when using the value 'localhost'. It's a bit terrifying because during all my testing, I am thinking I am connected to the correct instance, when in fact, I was not. It will be very easy to blow away the main instance data by mistake. Can I somehow convince the mysql command line client to use the specified parms, rather than the (incorrect) socket? Thank you. Regards, Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 12, 2006 6:00 PM To: mysql@lists.mysql.com Subject: Re: MySql Error Number 1130 When you are trying to connect to port 3307, for example, are you specifying that port from your remote machine? Or are you connecting to the mysqld listening on port 3306? You could try shutting down the server listening on port 3306, and then connecting to port 3307. See if the error message changes or goes away. shell# mysql -h host_name -u root -px --port=3307 I think you may need to specify the absolute IP address in the user table, instead of a wildcard '%'. See if this helps. Use your root username and password in place of 'tommy'. I did not want to mess up my root user account! Use the IP address of your remote machine you want to connect to mysql with, in place of 10.0.0.5. mysql create user 'tommy'@'10.0.0.5' - identified by '12345'; Query OK, 0 rows affected (0.00 sec) mysql grant all on *.* - to 'tommy'@'10.0.0.5' - identified by '12345'; Query OK, 0 rows affected (0.00 sec) mysql select * from user where user = 'tommy' \G ** 1. row * Host: 10.0.0.5 User: tommy Password: snipped Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: N References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y Create_view_priv: Y Show_view_priv: Y Create_routine_priv: Y Alter_routine_priv: Y Create_user_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 max_user_connections: 0 1 row in set (0.00 sec) HTH Keith In theory, theory and practice are the same; in practice they are not. On Wed, 12 Apr 2006, Duzenbury, Rich wrote: To: mysql@lists.mysql.com From: Duzenbury, Rich [EMAIL PROTECTED] Subject: MySql Error Number 1130 Hi all, I am setting up two additional instances of mysql on my mysql server, which is running version 5.0.18-standard-log. I've got the additional instances set up, and they are running. I can see that they are bound to the proper ports. I can connect to them locally like mysql -p --port=3306 mysql -p --port=3307 mysql -p --port=3320 I have always been able to connect remotely from my workstation to the base server on 3306. My problem is that I cannot connect remotely to either of the new additional instances running on 3307 or 3320. Anytime I attempt to do so, I receive MySQL Error Number 1130, Host
Re: MySql Error Number 1130
Duzenbury, Rich wrote: Wow, I found the problem! I think this may be a bug. In my case, I've got three instances running on ports 3306, 3307, and 3320. On the local machine, I connect to them via mysql -p --port-3306 --host=localhost mysql -p --port-3307 --host=localhost mysql -p --port-3320 --host=localhost Except that connecting to port 3307 doesn't really happen. It seems that the command line client connects to the main instance via the default socket when the host is not specified, or is the value localhost. So, even though I've specified the host and port, I wind up connecting to the main instance. I found this out by stopping the main instance on 3306, and then I issue: LX09:/etc # mysql --port=3307 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib /mysql/mysql.sock' (2) LX09:/etc # mysql --port=3307 --host=localhost ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib /mysql/mysql.sock' (2) localhost means socket. LX09:/etc # mysql --port=3307 --host=127.0.0.1 -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. LX09:/etc # mysql --port=3307 --host=nnn.nnn.nnn.nnn -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Note that /var/lib/mysql/mysql.sock is the socket associated with the main instance, not the alternates. It seems that if I *specify* a port, then mysql ought to use that port. It only seems to be an issue when not specifying a --host, or when using the value 'localhost'. It's a bit terrifying because during all my testing, I am thinking I am connected to the correct instance, when in fact, I was not. It will be very easy to blow away the main instance data by mistake. Can I somehow convince the mysql command line client to use the specified parms, rather than the (incorrect) socket All of the above is the correct and documented behavior. This is covered in the manual, and can be found many times in the archives. Thank you. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql Error Number 1130
localhost means socket. Hmm, I don't believe it does. localhost is a DNS shortcut to the IP address of the local machine. If that is how mysql wants to treat things, then it should issue an error message on connect because --host=localhost and --port=anything would then be mutually exclusive. Thanks. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql Error Number 1130
Duzenbury, Rich wrote: localhost means socket. Hmm, I don't believe it does. localhost is a DNS shortcut to the IP address of the local machine. If that is how mysql wants to treat things, then it should issue an error message on connect because --host=localhost and --port=anything would then be mutually exclusive. Thanks. Regards, Rich Wasn't it something like on local machines MySQL doesn't open a socket port because it works directly in program and not going the loop out of mysql and back in through the socket? -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql Error Number 1130
-Original Message- From: Barry [mailto:[EMAIL PROTECTED] Sent: Thursday, April 13, 2006 9:41 AM To: mysql@lists.mysql.com Subject: Re: MySql Error Number 1130 Duzenbury, Rich wrote: localhost means socket. Hmm, I don't believe it does. localhost is a DNS shortcut to the IP address of the local machine. If that is how mysql wants to treat things, then it should issue an error message on connect because --host=localhost and --port=anything would then be mutually exclusive. Thanks. Regards, Rich Wasn't it something like on local machines MySQL doesn't open a socket port because it works directly in program and not going the loop out of mysql and back in through the socket? I'm not sure I understand your statement. It's wise to use a unix domain socket where possible because they perform better than network sockets. However, it's misleading for the mysql client to ignore a command line directive as important as --port or --host without warning. Especially since this can cause connection to the wrong instance. Another way this would have been made more obvious is if the welcome message in the client were a bit more descriptive. Currently, I see 'Your mysql connection id is 2 to server version: 5.0.18-standard-log'. Perhaps the client should indicate the socket or ip/port that was actually used in the welcome message. Thanks. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql Error Number 1130
--- Duzenbury, Rich [EMAIL PROTECTED] wrote: -Original Message- From: Barry [mailto:[EMAIL PROTECTED] Sent: Thursday, April 13, 2006 9:41 AM To: mysql@lists.mysql.com Subject: Re: MySql Error Number 1130 Duzenbury, Rich wrote: localhost means socket. Hmm, I don't believe it does. localhost is a DNS shortcut to the IP address of the local machine. If that is how mysql wants to treat things, then it should issue an error message on connect because --host=localhost and --port=anything would then be mutually exclusive. Thanks. Regards, Rich Wasn't it something like on local machines MySQL doesn't open a socket port because it works directly in program and not going the loop out of mysql and back in through the socket? I'm not sure I understand your statement. It's wise to use a unix domain socket where possible because they perform better than network sockets. However, it's misleading for the mysql client to ignore a command line directive as important as --port or --host without warning. Especially since this can cause connection to the wrong instance. Another way this would have been made more obvious is if the welcome message in the client were a bit more descriptive. Currently, I see 'Your mysql connection id is 2 to server version: 5.0.18-standard-log'. Perhaps the client should indicate the socket or ip/port that was actually used in the welcome message. Thanks. Regards, Rich I couldn't find it with a quick trip through the docs but I seem to remember that using a single period for your host name will force an election to either use the socket or use the IP stack. I'm sorry but I don't remember which way it forces the client to connect but I do know it's only for local connections. shellmysql -u -p -h. -P3307 HTH! Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql Error Number 1130
Interesting. I have never heard of that option. LX09:/home/rduz/backup # mysql -p -h. --port=3307 Enter password: ERROR 2005 (HY000): Unknown MySQL server host '.' (1) Perhaps it no longer functions? Thanks. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql Error Number 1130
Hi all, I am setting up two additional instances of mysql on my mysql server, which is running version 5.0.18-standard-log. I've got the additional instances set up, and they are running. I can see that they are bound to the proper ports. I can connect to them locally like mysql -p --port=3306 mysql -p --port=3307 mysql -p --port=3320 I have always been able to connect remotely from my workstation to the base server on 3306. My problem is that I cannot connect remotely to either of the new additional instances running on 3307 or 3320. Anytime I attempt to do so, I receive MySQL Error Number 1130, Host 'nnn.nnn.nnn.nnn' is not allowed to connect to this MySQL server. I've been googling and reading manuals all day, and haven't made a dent. User Table *** 1. row *** Host: % User: root Password: (redacted) Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: Y References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 *** 2. row *** Host: localhost User: root Password: (redacted) Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: Y References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 db Table: *** 1. row *** Host: % Db: mysql User: root Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Grant_priv: Y References_priv: Y Index_priv: Y Alter_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Host table is empty. Here is one of the processes: mysql 5972 5960 0 16:17 pts/000:00:00 /usr/sbin/mysqld --no-defaults - -port=3307 --socket=/srv/mysql/lx07/mysql.sock --pid-file=/srv/mysql/lx07/lx09.p id07 --datadir=/srv/mysql/lx07/data --log=/srv/mysql/lx07/mysql.log --skip-locki ng --key_buffer=256M --max_allowed_packet=16M --table_cache=256 --sort_buffer_si ze=16M --read_buffer_size=8M --read_rnd_buffer_size=4M --myisam_sort_buffer_size =64M --thread_cache_size=8 --query_cache_size=16M --thread_concurrency=8 --tmpdi r=/tmp/ --innodb_file_per_table --innodb_data_home_dir=/srv/mysql/lx07 --innodb_ data_file_path=ibdata1:100M:autoextend --innodb_log_group_home_dir=/srv/mysql/lx 07/ --innodb_log_arch_dir=/srv/mysql/lx07/ --innodb_buffer_pool_size=128M --inno db_additional_mem_pool_size=20M --innodb_log_file_size=32M --innodb_log_buffer_s ize=8M --innodb_flush_log_at_trx_commit=1 --innodb_lock_wait_timeout=50 I have made sure to flush privileges, and I've restarted the server several times, to no avail. I am running out of things to try, and hoping someone can see my (what is most likely) obvious error. Thank you. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql Error Number 1130
When you are trying to connect to port 3307, for example, are you specifying that port from your remote machine? Or are you connecting to the mysqld listening on port 3306? You could try shutting down the server listening on port 3306, and then connecting to port 3307. See if the error message changes or goes away. shell# mysql -h host_name -u root -px --port=3307 I think you may need to specify the absolute IP address in the user table, instead of a wildcard '%'. See if this helps. Use your root username and password in place of 'tommy'. I did not want to mess up my root user account! Use the IP address of your remote machine you want to connect to mysql with, in place of 10.0.0.5. mysql create user 'tommy'@'10.0.0.5' - identified by '12345'; Query OK, 0 rows affected (0.00 sec) mysql grant all on *.* - to 'tommy'@'10.0.0.5' - identified by '12345'; Query OK, 0 rows affected (0.00 sec) mysql select * from user where user = 'tommy' \G ** 1. row * Host: 10.0.0.5 User: tommy Password: snipped Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: N References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y Create_view_priv: Y Show_view_priv: Y Create_routine_priv: Y Alter_routine_priv: Y Create_user_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 max_user_connections: 0 1 row in set (0.00 sec) HTH Keith In theory, theory and practice are the same; in practice they are not. On Wed, 12 Apr 2006, Duzenbury, Rich wrote: To: mysql@lists.mysql.com From: Duzenbury, Rich [EMAIL PROTECTED] Subject: MySql Error Number 1130 Hi all, I am setting up two additional instances of mysql on my mysql server, which is running version 5.0.18-standard-log. I've got the additional instances set up, and they are running. I can see that they are bound to the proper ports. I can connect to them locally like mysql -p --port=3306 mysql -p --port=3307 mysql -p --port=3320 I have always been able to connect remotely from my workstation to the base server on 3306. My problem is that I cannot connect remotely to either of the new additional instances running on 3307 or 3320. Anytime I attempt to do so, I receive MySQL Error Number 1130, Host 'nnn.nnn.nnn.nnn' is not allowed to connect to this MySQL server. I've been googling and reading manuals all day, and haven't made a dent. User Table *** 1. row *** Host: % User: root Password: (redacted) Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: Y References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 *** 2. row *** Host: localhost User: root Password: (redacted) Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: Y References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 db Table: *** 1. row *** Host: % Db: mysql User: root Select_priv: Y Insert_priv: Y
Re: MySQL Error
john simms wrote: Hello MySQL! Hello User! At last! It has taken a couple of days - but, I have, at last, found you. *hides* haha, you think so ... You have invaded my computer without being requested, or invited. Did i? Man, my schedules are really weird nowadays. Whenever I try to access a local (to my home) message board, I get a black 'page' on my monitor screen with the above message (MySQL Error) on the top left of the black page. Local message board? Ethernet one or really local like 127.0.0.1? I guess the font color is white because otherwise it would be hard to read , er and it's not usually a fault of MySQL it also could be bad coded PHP/JSP whatever your board is written in causing that Error. What Error are you exactly getting? It is driving me NUTS!! I want it off. But how do I remove it? Tried a rubber? Advice and step-by-step guidance/instructions please? 1. Give us more info about the MySQL version, Type of Board and any other Info you can get helping find that Error causing Problem. 2. Adress us as Humans not as a software 3. Let somone else, who might have knowledge of coding, have a look at it. Greets Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Difficult Problem: SQLDescribeCol call on MySQL Error
Hello. I'm not a MyODBC expert and not completely sure if it is your case, but it seems that there're several bugs similar to your. See: http://bugs.mysql.com/bug.php?id=10148 You can find more by searching on the 'SQLDescribeCol' keyword in the bugs database. Check that you're using the latest version of MyODBC. Daxin Zuo wrote: This call works fine on Oracle, Access, MS SQL. But Not works on MySQL. MySQL 5.0.15, MySQL ODBC drive 3.51, The OP is Windows 2000/2003, Program in VC++ In my SQLDescribeCol call on MySQL I get correct value on: ColumnName, BufferLength, NameLengthPtr, NullablePtr I get corect value on DataTypePtr if the type is not Text. For Text, it return -1. I get correct value on ColumnSizePtr only if the column type is varchar, and datetime , I get all 0 on DecimalDigitsPtr. The SQLRETURN always 0. Any Instruction is welcome. Thanks. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Difficult Problem: SQLDescribeCol call on MySQL Error
This call works fine on Oracle, Access, MS SQL. But Not works on MySQL. MySQL 5.0.15, MySQL ODBC drive 3.51, The OP is Windows 2000/2003, Program in VC++ In my SQLDescribeCol call on MySQL I get correct value on: ColumnName, BufferLength, NameLengthPtr, NullablePtr I get corect value on DataTypePtr if the type is not Text. For Text, it return -1. I get correct value on ColumnSizePtr only if the column type is varchar, and datetime , I get all 0 on DecimalDigitsPtr. The SQLRETURN always 0. Any Instruction is welcome. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION' -- again
Hello. MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION' -- again Check the character set of fields in you tables with 'SHOW CREATE TABLE' statement. I recommend you to test if the problem remains in 4.1.14 version, because the similar bug was fixed in 4.1.11. See: http://bugs.mysql.com/bug.php?id=6519 Jeff Kolber [EMAIL PROTECTED] wrote: I recently converted the entire database to utf8 - made sure all the connections are utf8 etc -- made php use utf8 - set the doctype on the page to utf8 -- when I run the same query in the mysql monitor it runs fine - when apache/php run it it fails to deal with the collation. the data was converted via mysqldump to text file and reimporting changing all tables/database to utf. fwiw: the query looks like this: ( SELECT meetings.id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , meetings.date_start , meetings.parent_id , meetings.parent_type , meetings.time_start , 'meetings' panel_name FROM meetings where ( meetings.parent_id= '63301596-6175-1b89-75df-431283170495' AND meetings.parent_type='Opportunities' AND meetings.deleted=0 AND (meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT tasks.id , tasks.name , tasks.status , CONCAT(CONCAT(jt0.first_name , ' '), CONCAT(jt0.last_name , ' ')) contact_name, tasks.contact_id , tasks.date_due , tasks.parent_id , tasks.parent_type , tasks.time_due , 'tasks' panel_name FROM tasks LEFT JOIN contacts jt0 ON jt0.id= tasks.contact_id AND jt0.deleted=0 where ( tasks.parent_id= '63301596-6175-1b89-75df-431283170495' AND tasks.parent_type='Opportunities' AND tasks.deleted=0 AND (tasks.status='Not Started' OR tasks.status='In Progress' OR tasks.status='Pending Input')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , calls.status , ' ' contact_name , ' ' contact_id , calls.date_start , calls.parent_id , calls.parent_type , calls.time_start , 'calls' panel_name FROM calls where ( calls.parent_id= '63301596-6175-1b89-75df-431283170495' AND calls.parent_type='Opportunities' AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 ) and in this case it doesn't return anything - which is correct given the data. we are using: mysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i386) Server characterset:utf8 Db characterset:utf8 Client characterset:utf8 Conn. characterset:utf8 I've seen some stuff that versions before 4.1.11 suffered from collation issues - is this likely to my case or can anyone see some other path through this - we have a single production database that we are very reluctant to update at this time. should i just switch back to latin1 ? thanks mysql list - you guys rock, lost in translation Jeff -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION' -- again
Hi list, I've got a query coming out of sugarCRM that is generating this error: MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION' I recently converted the entire database to utf8 - made sure all the connections are utf8 etc -- made php use utf8 - set the doctype on the page to utf8 -- when I run the same query in the mysql monitor it runs fine - when apache/php run it it fails to deal with the collation. the data was converted via mysqldump to text file and reimporting changing all tables/database to utf. fwiw: the query looks like this: ( SELECT meetings.id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , meetings.date_start , meetings.parent_id , meetings.parent_type , meetings.time_start , 'meetings' panel_name FROM meetings where ( meetings.parent_id= '63301596-6175-1b89-75df-431283170495' AND meetings.parent_type='Opportunities' AND meetings.deleted=0 AND (meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT tasks.id , tasks.name , tasks.status , CONCAT(CONCAT(jt0.first_name , ' '), CONCAT(jt0.last_name , ' ')) contact_name, tasks.contact_id , tasks.date_due , tasks.parent_id , tasks.parent_type , tasks.time_due , 'tasks' panel_name FROM tasks LEFT JOIN contacts jt0 ON jt0.id= tasks.contact_id AND jt0.deleted=0 where ( tasks.parent_id= '63301596-6175-1b89-75df-431283170495' AND tasks.parent_type='Opportunities' AND tasks.deleted=0 AND (tasks.status='Not Started' OR tasks.status='In Progress' OR tasks.status='Pending Input')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , calls.status , ' ' contact_name , ' ' contact_id , calls.date_start , calls.parent_id , calls.parent_type , calls.time_start , 'calls' panel_name FROM calls where ( calls.parent_id= '63301596-6175-1b89-75df-431283170495' AND calls.parent_type='Opportunities' AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 ) and in this case it doesn't return anything - which is correct given the data. we are using: mysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i386) Server characterset:utf8 Db characterset:utf8 Client characterset:utf8 Conn. characterset:utf8 I've seen some stuff that versions before 4.1.11 suffered from collation issues - is this likely to my case or can anyone see some other path through this - we have a single production database that we are very reluctant to update at this time. should i just switch back to latin1 ? thanks mysql list - you guys rock, lost in translation Jeff
RE: AMD64 Linux MySQL Error 1041 Out of Memory
On Thu, 2005-06-16 at 21:06, Richard Dale wrote: So we have recently started stress testing Mysql on an Opteron dual CPU machine running Ubuntu Hoary. We are using the 64-bit GCC 4.0.24-standard binary from mysql. The stress test that I'm currently running on it involves inserting a large database (from a mysqldump) ... Which linux kernel are you running? 2.6.10, specifically the ubuntu compile: 2.6.10-5-amd64-k8-smp Why not consider MySQL 4.1? It's now a stable production release. Unfortunately when we tried to run our application on MySQL 4.1, we were bit by a number of features of MySQL 4.1. MySQL 4.1 now silently returns Long objects instead of Integers for most functions (COUNT), causing class cast exceptions in Java... Also a number of our queries which used to compare binary and non-binary fields, now nolonger cast automatically... Requiring some additional SQL which our database abstraction layer is not aware of needing. A lengthy porting process ensued... and has been completed, but our application is still quite a ways from being fully certified to run on MySQL 4.1. :( The MySQL 4.1 upgrade was 10x nastier than our 3.23-4.0 upgrade. Also, consider visiting: http://hashmysql.org/index.php?title=Opteron_HOWTO We would welcome a section on there about Ubuntu and x86-64. Yes, I will be updating that wiki once I've got it running stably. I ran into some libc issues with Ubuntu already, as seen here: http://bugzilla.ubuntu.com/show_bug.cgi?id=11730 However I've compiled my own replacement libc with patches applied to fix the issues, which I will make available to all. Except for this memory problem, the machine is ready for our burnin testing. -Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: AMD64 Linux MySQL Error 1041 Out of Memory
On Thu, 2005-06-16 at 21:06, Richard Dale wrote: So we have recently started stress testing Mysql on an Opteron dual CPU machine running Ubuntu Hoary. We are using the 64-bit GCC 4.0.24-standard binary from mysql. The stress test that I'm currently running on it involves inserting a large database (from a mysqldump) ... So I don't think this has anything to do memory consumption anymore. I've been able to get the problem to repeat with mysqld's memory footprint being about 800+megs (545M resident). I also was able to get it to happen with the ubuntu stock mysqld my.cnf aswell... which uses ridiculously conservative memory settings. (The key cache is so small it takes 4x as long to run the test). With an identical configuration as my normal setup, running the 32bit binary doesn't appear to trigger the problem. I'll try 64bit with linuxthreads next. Somebody asked for a show processlist and show status... Here's the data pretty close to when it happened... +--++ | Variable_name| Value | +--++ | Aborted_clients | 4 | | Aborted_connects | 0 | | Bytes_received | 3638957151 | | Bytes_sent | 18427266 | | Com_admin_commands | 5 | | Com_alter_table | 10996 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin| 0 | | Com_change_db| 9 | | Com_change_master| 0 | | Com_check| 193| | Com_commit | 0 | | Com_create_db| 57 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_table | 5505 | | Com_delete | 0 | | Com_delete_multi | 0 | | Com_drop_db | 57 | | Com_drop_function| 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_flush| 3 | | Com_grant| 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_insert | 334612 | | Com_insert_select| 0 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table| 0 | | Com_lock_tables | 5505 | | Com_optimize | 0 | | Com_purge| 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace | 0 | | Com_replace_select | 0 | | Com_reset| 0 | | Com_restore_table| 0 | | Com_revoke | 0 | | Com_rollback | 0 | | Com_savepoint| 0 | | Com_select | 1 | | Com_set_option | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_create | 0 | | Com_show_databases | 2 | | Com_show_fields | 0 | | Com_show_grants | 0 | | Com_show_keys| 0 | | Com_show_logs| 0 | | Com_show_master_status | 0 | | Com_show_new_master | 0 | | Com_show_open_tables | 0 | | Com_show_processlist | 2 | | Com_show_slave_hosts | 0 | | Com_show_slave_status| 0 | | Com_show_status | 1 | | Com_show_innodb_status | 0 | | Com_show_tables | 9 | | Com_show_variables | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_truncate | 0 | | Com_unlock_tables| 5491 | | Com_update | 0 | | Com_update_multi | 0 | | Connections | 182| | Created_tmp_disk_tables | 0 | | Created_tmp_tables | 0 | | Created_tmp_files| 43 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_commit | 0 | | Handler_delete | 0 | | Handler_read_first | 1 | | Handler_read_key | 0 | | Handler_read_next| 0 | | Handler_read_prev| 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next| 9 | | Handler_rollback | 0 | | Handler_update | 0 | | Handler_write| 617450860 | | Key_blocks_used | 478697 | |
Re: AMD64 Linux MySQL Error 1041 Out of Memory
Hello. MySQL on 64-bit AMD rises lots of questions. There is an Opteron HOWTO at: http://hashmysql.org/index.php?title=Opteron_HOWTO I can't give any advice except sending to the list the output of SHOW STATUS and SHOW PROCESSLIST statements performed when MySQL uses a lot of memory. If you able check your test on MySQL 4.1.12. Joe Kislo [EMAIL PROTECTED] wrote: So we have recently started stress testing Mysql on an Opteron dual CPU machine running Ubuntu Hoary. We are using the 64-bit GCC 4.0.24-standard binary from mysql. The stress test that I'm currently running on it involves inserting a large database (from a mysqldump) from three separate windows (so three imports running simultaneously). The database dump is about 3.7 gigs uncompressed, or 580megs compressed. It was dumped using the following dump parameters: --add-locks --extended-insert --quick --lock-tables --all --disable-keys Each window has as script that creates a database, imports the data, dumps the database, and repeats. After about 12 cycles (each take about an hour) mysql starts spewing these errors: ERROR 1041 at line 195: Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space I, unfortunately, have not been at the server when this actually happens, however when I come in in the morning top is reporting mysqld taking up between 2.7 gigs and 3.2 gigs of memory. I have had a vmstat running all night, and at no point saw the system run out of swap space (it did over the course of the 15 hours or so, slowly hit swap up for about 60megs out of 2 gigs though). Obviously checking ulimit was my first stop, however I believe MySQLd does it's own setuid... And I'm not sure it uses PAM to get it's initial ulimits. Either way, I do this: su mysql -s /bin/sh sh-3.00$ ulimit -a core file size(blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files(-n) 8192 pipe size (512 bytes, -p) 8 stack size(kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes(-u) unlimited virtual memory(kbytes, -v) unlimited Which implies it should be able to alloc quite a bit of memory without problem. So my first question, is it appears to be konking out around 4 gigs of memory. Is there some reason why mysqld can't allocate more than 4gigs? I confirmed I *am* running the 64-bit binary: file /usr/sbin/mysqld /usr/sbin/mysqld: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared libs), stripped This system has 4 gigs of memory in it. So if it tried to allocate 4gigs, it would have had to hit swap up harder than 60megs. It seems like mysqld is hitting the 32bit allocation limit, but that doesn't particularly make sense to me. Anybody have their mysqld allocating 4gigs? Anything else I can try here? The second thing is, I have no idea why mysql is taking up so much memory. For the first 5 runs or so, mysql only allocates about 800 megs. Sometime during the night, is when it jumps up in memory.. I don't really understand why if it didn't need 3+ gigs of memory after the first 5 complete runs (x3 of course... since there's 3 running in parallel), it would suddenly need more later. Either way, lets do some math. Mysql is 2.7 gigs this morning, which is about half a gig less than yesterday morning. 2.7 gigs Key buffer: 512m Tmp Table: 128m sort buffer size: 512m join buffer size: 512m query cache: 256m KeyBuffer=512m, I could see that possibly not being returned.. So lets assume 512M there. There are no threads connected at the moment because I have shutdown the test, so tmptable should take up 0, but lets say it didn't return 3x128M (384M). Sort buffer size is 512M, well it may have used that for the alter table activate keys... and never returned it, so 512M there. Join buffer size, not a single select query was used ever, 0M. Query cache, 0M. 3x16M max packet. So I see 512M+384+512M+48M=1.4gigs. I have no idea why mysql is using this much memory... especially after it successfully performs 5 cycles with considerably less. Any ideas? here's the my.cnf [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port= 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language= /usr/share/mysql/english skip-external-locking key_buffer =
AMD64 Linux MySQL Error 1041 Out of Memory
So we have recently started stress testing Mysql on an Opteron dual CPU machine running Ubuntu Hoary. We are using the 64-bit GCC 4.0.24-standard binary from mysql. The stress test that I'm currently running on it involves inserting a large database (from a mysqldump) from three separate windows (so three imports running simultaneously). The database dump is about 3.7 gigs uncompressed, or 580megs compressed. It was dumped using the following dump parameters: --add-locks --extended-insert --quick --lock-tables --all --disable-keys Each window has as script that creates a database, imports the data, dumps the database, and repeats. After about 12 cycles (each take about an hour) mysql starts spewing these errors: ERROR 1041 at line 195: Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space I, unfortunately, have not been at the server when this actually happens, however when I come in in the morning top is reporting mysqld taking up between 2.7 gigs and 3.2 gigs of memory. I have had a vmstat running all night, and at no point saw the system run out of swap space (it did over the course of the 15 hours or so, slowly hit swap up for about 60megs out of 2 gigs though). Obviously checking ulimit was my first stop, however I believe MySQLd does it's own setuid... And I'm not sure it uses PAM to get it's initial ulimits. Either way, I do this: su mysql -s /bin/sh sh-3.00$ ulimit -a core file size(blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files(-n) 8192 pipe size (512 bytes, -p) 8 stack size(kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes(-u) unlimited virtual memory(kbytes, -v) unlimited Which implies it should be able to alloc quite a bit of memory without problem. So my first question, is it appears to be konking out around 4 gigs of memory. Is there some reason why mysqld can't allocate more than 4gigs? I confirmed I *am* running the 64-bit binary: file /usr/sbin/mysqld /usr/sbin/mysqld: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared libs), stripped This system has 4 gigs of memory in it. So if it tried to allocate 4gigs, it would have had to hit swap up harder than 60megs. It seems like mysqld is hitting the 32bit allocation limit, but that doesn't particularly make sense to me. Anybody have their mysqld allocating 4gigs? Anything else I can try here? The second thing is, I have no idea why mysql is taking up so much memory. For the first 5 runs or so, mysql only allocates about 800 megs. Sometime during the night, is when it jumps up in memory.. I don't really understand why if it didn't need 3+ gigs of memory after the first 5 complete runs (x3 of course... since there's 3 running in parallel), it would suddenly need more later. Either way, lets do some math. Mysql is 2.7 gigs this morning, which is about half a gig less than yesterday morning. 2.7 gigs Key buffer: 512m Tmp Table: 128m sort buffer size: 512m join buffer size: 512m query cache: 256m KeyBuffer=512m, I could see that possibly not being returned.. So lets assume 512M there. There are no threads connected at the moment because I have shutdown the test, so tmptable should take up 0, but lets say it didn't return 3x128M (384M). Sort buffer size is 512M, well it may have used that for the alter table activate keys... and never returned it, so 512M there. Join buffer size, not a single select query was used ever, 0M. Query cache, 0M. 3x16M max packet. So I see 512M+384+512M+48M=1.4gigs. I have no idea why mysql is using this much memory... especially after it successfully performs 5 cycles with considerably less. Any ideas? here's the my.cnf [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port= 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language= /usr/share/mysql/english skip-external-locking key_buffer = 512M tmp_table_size = 128M max_connections = 2000 max_connect_errors = 9 table_cache = 1024 myisam_max_sort_file_size=2048M myisam_sort_buffer_size =512M join_buffer_size=512M sort_buffer =512M max_allowed_packet = 16M thread_stack= 128K query_cache_limit = 1M query_cache_size= 256M query_cache_type= 1 skip-innodb and a show variables from a running server after a night's testing: mysql show variables;
RE: AMD64 Linux MySQL Error 1041 Out of Memory
So we have recently started stress testing Mysql on an Opteron dual CPU machine running Ubuntu Hoary. We are using the 64-bit GCC 4.0.24-standard binary from mysql. The stress test that I'm currently running on it involves inserting a large database (from a mysqldump) ... Which linux kernel are you running? Why not consider MySQL 4.1? It's now a stable production release. Also, consider visiting: http://hashmysql.org/index.php?title=Opteron_HOWTO We would welcome a section on there about Ubuntu and x86-64. Also, perhaps this bug is related: http://bugs.mysql.com/bug.php?id=10829 Best regards, Richard Dale. Norgate Investor Services - Premium quality Stock, Futures and Foreign Exchange Data for markets in Australia, Asia, Canada, Europe, UK USA - www.premiumdata.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: stability of mysql error strings
- Original Message - From: Scott Haneda on 5/4/05 7:22 PM, Paul DuBois at [EMAIL PROTECTED] wrote: Error strings do change format sometimes. And they won't necessarily be in English. :-) I had a feeling, what is the general method most use to deal with the above scenario? I really don't want to test error strings every time I update mysql, I suppose the safe road is to hand select ahead of time? Or use: INSERT new record with username retrieve record id (if it is an autoincrement field) UPDATE record with email You can now handle the 1062 errors of the insert and update seperately. The scenario with select, insert requires transactions (other processes could insert a matching record between your select and insert), which are currently only supported by InnoDB (and BDB) tables. http://dev.mysql.com/doc/mysql/en/ansi-diff-transactions.html Another approach would be to do an insert with username and email and in case of an error do one or two selects to check which field caused the duplicate error (most of the time there won't be an error, so it would save you some queries). Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stability of mysql error strings
I have a unique key on username and email address in mysql. In my application logic, I want to test for that response on failed insert. Error number 1062 tells me there is a duplicate key, but no way to tell what key that is. The error string returned is more telling, but seems less than ideal to use for stability and upgrade issues. It tells me username is key 2 and email is key 3. So, if error_string ends with 'key 2' etc etc I took care to lowercase the error string, so that's covered. What is not, is that it may not always 'ends with', so I could move to 'contains'. Anyway, I think you see what my concern is, wonder what the preferred method to fix is, or if someone can tell me when, if ever, the error string has ever changed format in mysql. I could run a insert ahead of time and parse the returned results, but I would rather not add the overhead of another select ahead of time. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: stability of mysql error strings
At 19:09 -0700 5/4/05, Scott Haneda wrote: I have a unique key on username and email address in mysql. In my application logic, I want to test for that response on failed insert. Error number 1062 tells me there is a duplicate key, but no way to tell what key that is. The error string returned is more telling, but seems less than ideal to use for stability and upgrade issues. It tells me username is key 2 and email is key 3. So, if error_string ends with 'key 2' etc etc I took care to lowercase the error string, so that's covered. What is not, is that it may not always 'ends with', so I could move to 'contains'. Anyway, I think you see what my concern is, wonder what the preferred method to fix is, or if someone can tell me when, if ever, the error string has ever changed format in mysql. Error strings do change format sometimes. And they won't necessarily be in English. :-) -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: stability of mysql error strings
on 5/4/05 7:22 PM, Paul DuBois at [EMAIL PROTECTED] wrote: At 19:09 -0700 5/4/05, Scott Haneda wrote: I have a unique key on username and email address in mysql. In my application logic, I want to test for that response on failed insert. Error number 1062 tells me there is a duplicate key, but no way to tell what key that is. The error string returned is more telling, but seems less than ideal to use for stability and upgrade issues. It tells me username is key 2 and email is key 3. So, if error_string ends with 'key 2' etc etc I took care to lowercase the error string, so that's covered. What is not, is that it may not always 'ends with', so I could move to 'contains'. Anyway, I think you see what my concern is, wonder what the preferred method to fix is, or if someone can tell me when, if ever, the error string has ever changed format in mysql. Error strings do change format sometimes. And they won't necessarily be in English. :-) I had a feeling, what is the general method most use to deal with the above scenario? I really don't want to test error strings every time I update mysql, I suppose the safe road is to hand select ahead of time? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql error nr.0
Using MySQL version 4.0, I am trying to backup my database using MySQL Administrator. When executing the backup I get error mysql error nr.0 which doesn't tell me much. I did a Google search on the error and it didn't tell me much. Can anyone shed light on this error message? Thanks. Darin Vanatta [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql error...
Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql error...
From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Stay in touch with absent friends - get MSN Messenger http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql error...
Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql error...
Hi, I don't have an answer for you yet - but I encountered exactly the same situation with one of my systems last weekend. Unfortunately, the error file sheds no light at all on the situation. In my case: [EMAIL PROTECTED] mysql]# cat JackFish.intechgra.com.err 050304 07:30:36 mysqld started 050304 07:30:37 mysqld ended I downloaded a full binary distribution and it will fire right up using the files/directories in the tar. That being the case I came to the conclusion that this is a permissions problem of some kind, but didn't take it any further as this is a non-critical issue for me right now. Good luck with it. John J. Schmidt VP Technology/Principal intechgra Database System Specialists mailto:[EMAIL PROTECTED] www.intechgra.com -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 8:10 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql error...
If you're starting the process as a non-system user then the var directory and anything under it should be owned/writable by that user. If you're starting it as root then the var directory should be owned/writable by mysql:daemon. If you don't have the Mysql user setup then the mysqld daemon won't run. Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] -Original Message- From: jschmidt [mailto:[EMAIL PROTECTED] Sent: 08 March 2005 16:44 To: 'mel list_php'; [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, I don't have an answer for you yet - but I encountered exactly the same situation with one of my systems last weekend. Unfortunately, the error file sheds no light at all on the situation. In my case: [EMAIL PROTECTED] mysql]# cat JackFish.intechgra.com.err 050304 07:30:36 mysqld started 050304 07:30:37 mysqld ended I downloaded a full binary distribution and it will fire right up using the files/directories in the tar. That being the case I came to the conclusion that this is a permissions problem of some kind, but didn't take it any further as this is a non-critical issue for me right now. Good luck with it. John J. Schmidt VP Technology/Principal intechgra Database System Specialists mailto:[EMAIL PROTECTED] www.intechgra.com -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 8:10 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql error...
True. I forgot to mention, when doing the normal install from the tar, the files/databases for mysql and test both refused to create, although I see no error message indicating that. I believe that the root issue has something to do with the permissions during the make install. //jjs -Original Message- From: Kevin Cowley [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 9:12 AM To: mysql@lists.mysql.com Subject: RE: MySql error... If you're starting the process as a non-system user then the var directory and anything under it should be owned/writable by that user. If you're starting it as root then the var directory should be owned/writable by mysql:daemon. If you don't have the Mysql user setup then the mysqld daemon won't run. Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] -Original Message- From: jschmidt [mailto:[EMAIL PROTECTED] Sent: 08 March 2005 16:44 To: 'mel list_php'; [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, I don't have an answer for you yet - but I encountered exactly the same situation with one of my systems last weekend. Unfortunately, the error file sheds no light at all on the situation. In my case: [EMAIL PROTECTED] mysql]# cat JackFish.intechgra.com.err 050304 07:30:36 mysqld started 050304 07:30:37 mysqld ended I downloaded a full binary distribution and it will fire right up using the files/directories in the tar. That being the case I came to the conclusion that this is a permissions problem of some kind, but didn't take it any further as this is a non-critical issue for me right now. Good luck with it. John J. Schmidt VP Technology/Principal intechgra Database System Specialists mailto:[EMAIL PROTECTED] www.intechgra.com -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 8:10 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL
RE: MySql error...
If you downloaded the source tar and built Mysql doing a make/make install then you won't have a database. To create the baseline databases you need to run mysql_install_db which creates the mysql and test databases under the var directory. Its also worth copying one of the .cnf files from prefix/share/mysql as my.cnf into the var directory. Depending exactly on your setup you should end up with prefix/bin /include /info /share /lib /libexec /man /mysql-test /var/mysql /test Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] -Original Message- From: jschmidt [mailto:[EMAIL PROTECTED] Sent: 08 March 2005 17:40 To: Kevin Cowley; mysql@lists.mysql.com Subject: RE: MySql error... True. I forgot to mention, when doing the normal install from the tar, the files/databases for mysql and test both refused to create, although I see no error message indicating that. I believe that the root issue has something to do with the permissions during the make install. //jjs -Original Message- From: Kevin Cowley [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 9:12 AM To: mysql@lists.mysql.com Subject: RE: MySql error... If you're starting the process as a non-system user then the var directory and anything under it should be owned/writable by that user. If you're starting it as root then the var directory should be owned/writable by mysql:daemon. If you don't have the Mysql user setup then the mysqld daemon won't run. Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] -Original Message- From: jschmidt [mailto:[EMAIL PROTECTED] Sent: 08 March 2005 16:44 To: 'mel list_php'; [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, I don't have an answer for you yet - but I encountered exactly the same situation with one of my systems last weekend. Unfortunately, the error file sheds no light at all on the situation. In my case: [EMAIL PROTECTED] mysql]# cat JackFish.intechgra.com.err 050304 07:30:36 mysqld started 050304 07:30:37 mysqld ended I downloaded a full binary distribution and it will fire right up using the files/directories in the tar. That being the case I came to the conclusion that this is a permissions problem of some kind, but didn't take it any further as this is a non-critical issue for me right now. Good luck with it. John J. Schmidt VP Technology/Principal intechgra Database System Specialists mailto:[EMAIL PROTECTED] www.intechgra.com -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 8:10 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL
RE: MySql error...
Also, check to make sure the partition where your log directory is (ie. /var) isn't full. Move, compress, or delete some of the old logs, then restart mysql server. Reconfigure your log rotation scheme to avoid this in the future. HTH, Joey ~~ Joseph Karalius Research Associate - Bioinformatics Molecular Markers and Applied Genomics Seminis Vegetable Seeds, Inc 37437 State Highway 16 Woodland, CA 95695-9353 530-669-6131 joseph.karalius (a) seminis dot com ~~ -Original Message- From: Kevin Cowley [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 9:12 AM To: mysql@lists.mysql.com Subject: RE: MySql error... If you're starting the process as a non-system user then the var directory and anything under it should be owned/writable by that user. If you're starting it as root then the var directory should be owned/writable by mysql:daemon. If you don't have the Mysql user setup then the mysqld daemon won't run. Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] -Original Message- From: jschmidt [mailto:[EMAIL PROTECTED] Sent: 08 March 2005 16:44 To: 'mel list_php'; [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, I don't have an answer for you yet - but I encountered exactly the same situation with one of my systems last weekend. Unfortunately, the error file sheds no light at all on the situation. In my case: [EMAIL PROTECTED] mysql]# cat JackFish.intechgra.com.err 050304 07:30:36 mysqld started 050304 07:30:37 mysqld ended I downloaded a full binary distribution and it will fire right up using the files/directories in the tar. That being the case I came to the conclusion that this is a permissions problem of some kind, but didn't take it any further as this is a non-critical issue for me right now. Good luck with it. John J. Schmidt VP Technology/Principal intechgra Database System Specialists mailto:[EMAIL PROTECTED] www.intechgra.com -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 8:10 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible
RE: MySql error...
Thankx to all, I have solved the problem, the problem was with the permissions.We have to give the ownership of the mysql directory to mysql user and the run the configuration file. Regards, --Yousaf yousaf jschmidtYousaf Hi, I don't have an answer for you yet - but I encountered exactly the same situation with one of my systems last weekend. Unfortunately, the error file sheds no light at all on the situation. In my case: [EMAIL PROTECTED] mysql]# cat JackFish.intechgra.com.err 050304 07:30:36 mysqld started 050304 07:30:37 mysqld ended I downloaded a full binary distribution and it will fire right up using the files/directories in the tar. That being the case I came to the conclusion that this is a permissions problem of some kind, but didn't take it any further as this is a non-critical issue for me right now. Good luck with it. John J. Schmidt VP Technology/Principal intechgra Database System Specialists mailto:[EMAIL PROTECTED] www.intechgra.com -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 8:10 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql error logging
OK I've honestly banged my head against everying, but as far as I can tell MySQL has *NO* real logging support. You have three options, log everything as text, log all queries as binary, or nothing. What I want/NEED is connection logging and some sort of ERROR logging. I'm getting an increasingly large amount of client connections that get apparently dropped during queries to the mysql server (error 2013) but the timeout issue is not possible (first it's default hour long timeout, secondly the connections are NOT persistent) Is there anything that can be done to get mysql to log the errors as they occur with the clients? Or to get it to log when it opens/closes a connection with the client and the disposition of that connection? Something would be better than what it does now which is all-or-nothing. Makes diagnosing anything impossible since I'm handling ~2k queries/sec. We have a binary log (necessary for our slave replica) and aren't under any load crunch nor I/O crunch on the DB drives, we're not experiencing ANY performance issues, just theres a goodly number of these connection dropped by server messages being reported. There has *GOT* to be SOME sort of useful logging in MySQL without having to turn on *full* text logging, which completely kills the server. All I need are connect/disconnect and disconnect reasons, I also *NEED* authentication failures but the thing doesn't log those EITHER. I'm starting to have a hard time believing I'm the only one complaining about this so I must be missing something, but the only logging options I've found cause full logging which can not be done. MySQL Version is 4.0.23 -- Michael Loftis Modwest Operations Manager GPG/PGP -- 0xE736BD7E 5144 6A2D 977A 6651 DFBE 1462 E351 88B9 E736 BD7E -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql error logging
Under UNIX/linux use syslog, for me /var/log/messages shows login/auth error Mar 6 05:39:11 orion pdns[1865]: gmysql Connection failed: Unable to connect to database: Access denied for user 'root'@'localhost' (using password: NO) Now for dropped sockets/connections you need to enable logging for this kind of thing in your connector and/or pooling software. I don't think this exists on the server side as it is not so simple to determine the actual cause. Let's say your router/switch drops connections, to server this looks like TCP socket timeouts and eventually will try to close the connection as such, but was it dropped or was it just left open and not closed properly by the client. This is why it makes sense to track these things in your data connector/pooling, with your kind of load you should have this kind of connection tracing/logging enabled in the client side and/or middle tier anyway. Just my $0.02 worth. -Daniel. -Original Message- From: Michael Loftis [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 2:45 PM To: mysql@lists.mysql.com Subject: mysql error logging OK I've honestly banged my head against everying, but as far as I can tell MySQL has *NO* real logging support. You have three options, log everything as text, log all queries as binary, or nothing. What I want/NEED is connection logging and some sort of ERROR logging. I'm getting an increasingly large amount of client connections that get apparently dropped during queries to the mysql server (error 2013) but the timeout issue is not possible (first it's default hour long timeout, secondly the connections are NOT persistent) Is there anything that can be done to get mysql to log the errors as they occur with the clients? Or to get it to log when it opens/closes a connection with the client and the disposition of that connection? Something would be better than what it does now which is all-or-nothing. Makes diagnosing anything impossible since I'm handling ~2k queries/sec. We have a binary log (necessary for our slave replica) and aren't under any load crunch nor I/O crunch on the DB drives, we're not experiencing ANY performance issues, just theres a goodly number of these connection dropped by server messages being reported. There has *GOT* to be SOME sort of useful logging in MySQL without having to turn on *full* text logging, which completely kills the server. All I need are connect/disconnect and disconnect reasons, I also *NEED* authentication failures but the thing doesn't log those EITHER. I'm starting to have a hard time believing I'm the only one complaining about this so I must be missing something, but the only logging options I've found cause full logging which can not be done. MySQL Version is 4.0.23 -- Michael Loftis Modwest Operations Manager GPG/PGP -- 0xE736BD7E 5144 6A2D 977A 6651 DFBE 1462 E351 88B9 E736 BD7E -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] !DSPAM:422e00ff75662101317344! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Error 1251 / phpMyAdmin
I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error 1251 / phpMyAdmin
You have mysql 4.1.8, but your php was built with the library for an earlier version, which, as the error message says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error 1251 / phpMyAdmin
I am still new to the PHP scene could you tell me how I rebuild the PHP with the client library... On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen [EMAIL PROTECTED] wrote: You have mysql 4.1.8, but your php was built with the library for an earlier version, which, as the error message says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Error 1251 / phpMyAdmin
I don't know much about the windows side of things so these are the only
resources I could find.
From the http://www.phpadmin.net site FAQ
[1.17a] I cannot connect to the MySQL server. It always returns the
error message, Client does not support authentication protocol
requested by server; consider upgrading MySQL client
You tried to access MySQL with an old MySQL client library. The version
of your MySQL client library can be checked in your phpinfo() output.
In general, it should have at least the same minor version as your
server - as mentioned in FAQ 1.17.
The only way to fix this problem is manually compiling php and its MySQL
extension against a current MySQL client library.
If you still face this problem, please compile your MySQL client library
against the same or a newer MySQL release.
From the http://www.php.net site mysql_connect function, while not
exactly the same version, the same problem occurs.
maybe you have seen this (using PHP 4.3.9 and MySQL client/server 4.1)
Error w/ php: mysql_connect(): Client does not support authentication
protocol
Solution:
mysql -u root-p
SET PASSWORD FOR [EMAIL PROTECTED] = OLD_PASSWORD('password');
It is clearly that this is a bug in PHP's mysql module, perhaps it will
be upgraded in the next version
Resource: http://forums.mysql.com/read.php?11,6400,6701#msg-6701
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: GH [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 8 February 2005 3:12 AM
To: mysql@lists.mysql.com; php-general; PHP DB
Subject: MySQL Error 1251 / phpMyAdmin
I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP
Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8
I am receiving the enclosed error when I attempt to go into
phpMyAdmin and do not know how to solve the issue...
Any assistance would be greatful.
Thank you
Gary
//## ERROR RECIEVED //
Welcome to phpMyAdmin 2.6.1
phpMyAdmin tried to connect to the MySQL server, and the server
rejected the connection. You should check the host, username and
password in config.inc.php and make sure that they correspond to the
information given by the administrator of the MySQL server.
Error
MySQL said:
#1251 - Client does not support authentication protocol requested by
server
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cant connect to mysql error :20031 /10061
Hi I've a question I have a delphi program that connects to a mysql database via obdc, and works perfect in the lan and in the server, I want to know if I can enter the database if I have the program installed in another city or place, I know that I have to enter the IP of the server but I've tried this and it doesn´t work when I try to connect to mysql from outside de lan I receive the message error 2003: can´t connect to xxx..xxx.xxx (10061) I create a host in the user database of mysql with % Host User Password Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Reload_priv Shutdown_priv Process_priv File_priv Grant_priv References_priv Index_priv Alter_priv localhost root Y Y Y Y Y Y Y Y Y Y Y Y Y Y % root Y Y Y Y Y Y Y Y Y Y Y Y Y Y localhost Y Y Y Y Y Y Y Y Y Y Y Y Y Y % N N N N N N N N N N N N N N 200.87.51.XX prueba 1f3d25cd5ea79fae Y Y Y Y Y Y Y Y Y Y Y Y Y Y Revisar todos/as / Desmarcar todos Con marca: And i can´t connect to mysql . Is there something more that I have to do in order to work? Regards Marcelo
Re: Cant connect to mysql error :20031 /10061
First, check your my.cnf file to see if you have a 'bind-address' entry. Such an entry will constrain you system only responding to machines on the same network. Failing that, have you checked you firewall settings? Are you sure that can can even reach port 3306 on that machine from the outside world? You might try setting up a packet sniffer like Ethereal on the server to listen for connections to port 3306 and then try to connect from the outside. If you see no connection attempt being made, then very like your network configuration is not allowing these connections through to the server. - michael dykman On Fri, 2005-02-04 at 12:48, [EMAIL PROTECTED] wrote: Hi I've a question I have a delphi program that connects to a mysql database via obdc, and works perfect in the lan and in the server, I want to know if I can enter the database if I have the program installed in another city or place, I know that I have to enter the IP of the server but I've tried this and it doesnt work when I try to connect to mysql from outside de lan I receive the message error 2003: cant connect to xxx..xxx.xxx (10061) I create a host in the user database of mysql with % Host User Password Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Reload_priv Shutdown_priv Process_priv File_priv Grant_priv References_priv Index_priv Alter_priv localhost root Y Y Y Y Y Y Y Y Y Y Y Y Y Y % root Y Y Y Y Y Y Y Y Y Y Y Y Y Y localhost Y Y Y Y Y Y Y Y Y Y Y Y Y Y % N N N N N N N N N N N N N N 200.87.51.XX prueba 1f3d25cd5ea79fae Y Y Y Y Y Y Y Y Y Y Y Y Y Y Revisar todos/as / Desmarcar todos Con marca: And i cant connect to mysql . Is there something more that I have to do in order to work? Regards Marcelo -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help please !! [MySQL][ODBC 3.51Driver][mysqld-4.1.8-nt-log]Unknow MySQL error
Hello. You can enable logging on the server. See: http://dev.mysql.com/doc/mysql/en/log-files.html You need the error log, query log, slow log. But be careful! Heavy loaded server can produce a lot of messages and your files will grow quickly. If you use InnoDB, you can enable the InnoDB monitors. See: http://dev.mysql.com/doc/mysql/en/innodb-monitor.html You can enable ODBC trace, but it very slows down the system. See: http://dev.mysql.com/doc/mysql/en/myodbc-trace.html The clues can be in one of the log files. matias Castilla [EMAIL PROTECTED] wrote: I have a mysql server running on WIN-XP (in a critical health area) and it started to give me that error. At first, the problem ocurred in a machine and then started to scatter all over the system. On Saturday I reset the Server Machine and the problem disapeared. But today applications started to fail again. Sometimes showing this error messeges and sometimes not showing the content of some tables. mat?as. _ Do You Yahoo!? Informaci?n de Estados Unidos y Am?rica Latina, en Yahoo! Noticias. Vis?tanos en http://noticias.espanol.yahoo.com -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
help please !! [MySQL][ODBC 3.51Driver][mysqld-4.1.8-nt-log]Unknow MySQL error
I have a mysql server running on WIN-XP (in a critical health area) and it started to give me that error. At first, the problem ocurred in a machine and then started to scatter all over the system. On Saturday I reset the Server Machine and the problem disapeared. But today applications started to fail again. Sometimes showing this error messeges and sometimes not showing the content of some tables. matías. _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
