Hi,
We have been using MYSQL in our dedicated server for long time without
problem, Suddenly we noticed an error stating Can't open file error
number 24.
When we rebooted the machine , MYSQL started working again fine. We have to
fix this problem not to happen again,
We have
Opened
problem, Suddenly we noticed an error stating Can't open file error
number 24.
If I recall correctly, error 24 means the disk partition is full.
Neil
--
Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
MySQL pre-installed on a virtual private server for $25/mo
Unmetered
In the last episode (Jan 11), Sathish said:
We have been using MYSQL in our dedicated server for long time without
problem, Suddenly we noticed an error stating Can't open file error
number 24.
When we rebooted the machine , MYSQL started working again fine. We have
to fix this problem
Hi.
My Linux server has just restarted due to memory problems.
Browsing mySQL logs, I've found out 5,000 lines like these in less
than one hour:
--
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't
On 8/8/06, thomas Armstrong [EMAIL PROTECTED] wrote:
Hi.
My Linux server has just restarted due to memory problems.
Browsing mySQL logs, I've found out 5,000 lines like these in less
than one hour:
--
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno
open file:
'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno: 145
Hi there,
After having installed the Mysql Ver. 5.0.22-standard for sun-solaris2.10
(SPARC) I get the error below when I try to start the mysql server:
Sun-solaris# /usr/sbin/mysqld -u mysql
Error #60718 Can't open and lock privilege tables: Table 'mysql.host' doesn't
exist
What am I doing
On Tuesday 18 July 2006 08:23 am, Calselli, Fabrizio WI wrote:
Hi there,
After having installed the Mysql Ver. 5.0.22-standard for sun-solaris2.10
(SPARC) I get the error below when I try to start the mysql server:
Sun-solaris# /usr/sbin/mysqld -u mysql
Error #60718 Can't open and lock
I'm getting the following error
ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
This is the output from mysqld
060613 19:59:34 InnoDB error:
Cannot find table sfgnew/agent from the internal data dictionary
of InnoDB though the .frm file for the table exists. Maybe
ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
This is the output from mysqld
060613 19:59:34 InnoDB error:
Cannot find table sfgnew/agent from the internal data dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB
, or 775/770 if
owned by mysql user) on your new directory ('sfgnew')? If you don't
have execute permission for the mysql user on that dir, MySQL can't list
the contents ...
Dan
murthy gandikota wrote:
I'm getting the following error
ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1
1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
This is the output from mysqld
060613 19:59:34 InnoDB error:
Cannot find table sfgnew/agent from the internal data dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted
have execute permission for the mysql user on that dir, MySQL can't
list
the contents ...
Dan
murthy gandikota wrote:
I'm getting the following error
ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
This is the output from mysqld
060613 19:59:34 InnoDB error
can't
list
the contents ...
Dan
murthy gandikota wrote:
I'm getting the following error
ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
This is the output from mysqld
060613 19:59:34 InnoDB error:
Cannot find table sfgnew/agent from the internal data dictionary
of InnoDB though
Cc: mysql@lists.mysql.com
Subject: Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
Murthy, doing some quick reading on InnoDB table definitions, it appears
that MySQL itself keeps some info in the .frm file, while InnoDB keeps some
info within the tablespace.
While you can
to recreate your tables and move them. HTH.
-phpninja
-Original Message-
From: Dan Buettner
[*mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14, 2006 8:12 AM
To: murthy gandikota
Cc: mysql@lists.mysql.com
Subject: Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
Murthy
: Wednesday, June 14, 2006 8:12 AM
To: murthy gandikota
Cc: mysql@lists.mysql.com
Subject: Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
Murthy, doing some quick reading on InnoDB table definitions, it appears
that MySQL itself keeps some info in the .frm file, while InnoDB keeps
At 6:14 -0700 6/14/06, murthy gandikota wrote:
I'm getting the following error
ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
This is the output from mysqld
060613 19:59:34 InnoDB error:
Cannot find table sfgnew/agent from the internal data dictionary
of InnoDB
Murthy, if you want to dump database A and restore into database B, it's
basically a 3-step process. You have to first create B, then dump A,
then pipe the dump of A into B. Using the --no-data option with
mysqldump will dump only structure, no data.
something like this:
mysql -u root
murthy gandikota wrote:
snip
Here are some pertinent facts:
a) stopped mysqld
b) copied files from sfg to sfgnew in the var directory
c) set the permissions to 777 (read, write, execute) for all the files in
sfgnew
d) restarted mysqld
Dan Buettner wrote:
Murthy, do you have
Hi Micheal
Thanks for your suggestions. I use mysqldump to restore the DB's. Apparently
mysqldump doesn't create forward declarations for views. So I had to manually
feed the views in correct order to avoid errors. Also to import the DB sfg into
sfgnew I had to substitute all of the `sfg`
Using 4.0.20 on Slack 10.0
New setup. mysql_install_db was run.
On startup, the error log shows the following error message:
Fatal error: Can't open privilege tables: Can't find file:
'./mysql/host.frm' (errno: 13)
It would appear the paths are not being set
setup. mysql_install_db was run.
On startup, the error log shows the following error message:
Fatal error: Can't open privilege tables: Can't find file:
'./mysql/host.frm' (errno: 13)
It would appear the paths are not being set
message:
Fatal error: Can't open privilege tables: Can't find file:
'./mysql/host.frm' (errno: 13)
It would appear the paths are not being set.
-
Need advice on what to do next. URLs of documentation would
be appreciated
Tim Johnson wrote:
* Gleb Paharenko [EMAIL PROTECTED] [050711 07:17]:
Hello Gleb:
Check that you have correct permissions set on MySQL datadir.
See:
http://dev.mysql.com/doc/mysql/en/mysql-install-db.html
I will add to the comments above. I had to set the owner
and group to mysql
hmm! mysql.sock was created at var/lib/mysql.
owner=mysql, permissions=777
So again, is there paths/permissions problems?
Since this is where your my.cnf says to put it, it would be a problem if
it was not there.
If you are going to override the default location of the socket for
Hello,
I hope that you have not destroyed the ibdata file. The tables are
there. Did you edit the my.cnf in the upgrade? What does mysqld print to
the .err log?
when we changed from 4.0.20 to 4.1.9 we moved to a new server and copied
only the database directories, but no error-logs or ibdata
Hello,
some weeks ago we switched from mysql 4.0.20 to 4.18 and later to 4.1.9.
A customer now told us, that he can't access his old InnoDB-tables. He gets
#1016 - Can't open file: 'Autor.ibd' (errno: 1)
if he tries to access the table Autor. This happens to other
InnoDB-tables created
Marten,
- Original Message -
From: Marten Lehmann [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, January 20, 2005 5:47 PM
Subject: 4.0.20 - 4.1.9 Can't open file: 'Autor.ibd'
Hello,
some weeks ago we switched from mysql 4.0.20 to 4.18 and later to 4.1.9
trying to run mysql 4.0.21 server on a freeBSD 5.3 box. I tried
to run mysqld_safe to add a root password but i can't seem to run the
safe command because it shuts down immediately.
The following error is presented to me:
Fatal error: Can't open privilege tables: File
'/usr/local/share
Hi
I am trying to run mysql 4.0.21 server on a freeBSD 5.3 box. I tried
to run mysqld_safe to add a root password but i can't seem to run the
safe command because it shuts down immediately.
The following error is presented to me:
Fatal error: Can't open privilege tables: File
'/usr/local/share
is presented to me:
Fatal error: Can't open privilege tables: File
'/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)
I would like it to load the latin1.conf charset.
I can't find any variable that influences this choice. Probably there
is something not configured or the configuration isn't
Michael Arndt [EMAIL PROTECTED] wrote:
a) what could be reason /solution for the following Problem:
ERROR 1016: Can't open file: '#sql-407f_f.MRG'. (errno: 144)
[EMAIL PROTECTED] egor]$ perror 144
Error code 144: Unknown error 144
144 = Table is crashed and last repair failed
So, running
yes mr egor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello *,
a) what could be reason /solution for the following Problem:
ERROR 1016: Can't open file: '#sql-407f_f.MRG'. (errno: 144)
b) in which directory the below reported intermediate file should
be generated
mysql use syslog
Database changed
mysql ALTER TABLE logs UNION
Hello,
I run into a problem after re-installing mySQL 4.1.1 today. When I
tried to start the service on my Windows2K, I got the following error:
040527 15:37:49 Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
Can some one tell me how to solve
mySQL 4.1.1 today. When I
tried to start the service on my Windows2K, I got the following error:
040527 15:37:49 Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
Can some one tell me how to solve the problem?
Thanks in advance!
Michael Wu
--
MySQL General
Since the database I created was not critical, I could simply throw it away.
Therefore,
delete the whole MySql installation directory and unzip the alpha release
zip file again
to create the installation directory tree. However, the following error
persists:
Fatal error: Can't open
persists:
Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't
exist
Everything should be wiped out I thought. Does MySQL saves some data
somewhere other than
the installation directory? More help, please?
Michael Wu
-Original Message-
From: Robert J Taylor [mailto:[EMAIL
To: MICHAEL_WU
Cc: [EMAIL PROTECTED]
Subject: Re: FW: Could not start MySQL after reinstall - Can't open
privilege tables: Table 'mysql.host' doesn't exist
Did you change the permissions for the files to include
read/write/change for the user/account MySQL uses on your system? This
doesn't require
Hi!
May I have the reason why this error occured in my Localhost.
When I try to connect to MySQL on the Localhost I met the error
*Can't open named pipe to host: . pipe: MySQL (2)*
I have used;
Windows 2000 SP 4
MySQL Server 4.0.17 max-debug
Upon looking the documentation
Hello!
I get this error from my MySQL-database:
Error: 1016 Can't open file: 'tablename.MYI.
(errno: 145).
I know what to do to fix this, but I need to know what causes this error.
If anyone know, please respond.
Best regards, Marius R
At 11:14 -0700 9/25/03, [EMAIL PROTECTED] wrote:
Description:
bin/mysqld_safe --user=mysql fails with the following error
(from data/host.err file)
030925 10:58:58 mysqld started
030925 10:58:59 InnoDB: Started
030925 10:58:59 Fatal error: Can't open
Description:
bin/mysqld_safe --user=mysql fails with the following error
(from data/host.err file)
030925 10:58:58 mysqld started
030925 10:58:59 InnoDB: Started
030925 10:58:59 Fatal error: Can't open privilege tables:
Out
Dear all,
what is the meaning of
Can't open file: 'products_description.MYI'. (errno: 145)
in mysql?
Regards,
_DT
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Deependra b. Tandukar [EMAIL PROTECTED] wrote:
what is the meaning of
Can't open file: 'products_description.MYI'. (errno: 145)
in mysql?
$ perror 145
Error code 145: Unknown error 145
145 = Table was marked as crashed and should be repaired
You should repair table with REPAIR TABLE
Deependra b. Tandukar wrote:
Dear all,
what is the meaning of
Can't open file: 'products_description.MYI'. (errno: 145)
in mysql?
Regards,
_DT
$ perror 145
145 = Table was marked as crashed and should be repaired
Hope this helps
--
Joseph Bueno
--
MySQL General Mailing List
For list archives
Hi There,
errno 145 means:
'Table was marked as crashed and should be repaired'
You can Type on the commandline (dosbox, bash, etc-): perror ErrorNumber
to get information about errors.
prosit
Klaus
P.S.:REPAIR TABLE (manual chapter 4.4.5) might help.
--
MySQL General Mailing
Hello all,
My /var partition has become full, and now when I try load my db (the files
are in /var/lib/mysql/db/) I get the following message for the table
my_table:
use db;
Didn't find any fields in table 'my_table'
I then do describe my_table and I get:
ERROR 1016: Can't open file
:
ERROR 1016: Can't open file: 'my_table.MYD'. (errno: 145).
I freed up some space under /var but I still recieve the above
messages. Does this mean that my table has been corrupted? Is there
any way to recover this table?
Thanks in advance,
Vikas
AM
Subject: Re: Can't open privilege tables: Table 'mysql.host' doesn't exist
Sorry, I should have given more details.=20
Its Mysql 4.1 alpha on a Suse Linux system Version 8.1.
=2E..and yes, the mysql.host table and the other 5 exist and are well
alive=
;-).
If I replace my.cnf
Nils,
most probably you have some other difference in the my.cnf files.
Regards,
Heikki
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 6:22 PM
Subject: Re: Can't open privilege tables
-
From: Nils Valentin [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, June 04, 2003 7:05 AM
Subject: Re: Can't open privilege tables: Table 'mysql.host' doesn't exist
Sorry, I should have given more details.=20
Its Mysql 4.1 alpha on a Suse Linux system Version 8.1
Hi Mysql list members,
I added a Innodb database to the existing MyISAM databases and now MySQL
doesnt start up. From the InnoDB logfile I saw this error message
Can't open privilege tables: Table 'mysql.host' doesn't exist
Does any body know what this error comes from ?
innodb logfile
, perhaps my.cnf and/or mysql itself.
Best regards
Nils Valentin
2003 6 4 12:36Nils Valentin :
Hi Mysql list members,
I added a Innodb database to the existing MyISAM databases and now MySQL
doesnt start up. From the InnoDB logfile I saw this error message
Can't open privilege tables: Table
Nils,
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, June 04, 2003 7:05 AM
Subject: Re: Can't open privilege tables: Table 'mysql.host' doesn't exist
Sorry, I should have given more details.=20
Its Mysql 4.1 alpha
hollen,
Saturday, July 13, 2002, 7:07:30 AM, you wrote:
h In using MySQLGui v 1.75, I get the following message when I try to
h connect to the database:
h Can't connect to local MySQL server through socket (111)
h What can I do in addition to following the configuration for .my.sql
h in
In using MySQLGui v 1.75, I get the following message when I try to
connect to the database:
Can't connect to local MySQL server through socket (111)
What can I do in addition to following the configuration for .my.sql
in MySQL.help? I can access the database through the text based mysql
Liu,
Wednesday, June 05, 2002, 5:59:53 AM, you wrote:
LQq I am making use of mySQL to provide my client a solution. However, one of tables
often crash and produces the folloing error message when I try to use the table in a
query:
LQq mysql select * from action;
LQq error 1016: Can't open
Hi, everyone,
I am making use of mySQL to provide my client a solution. However, one of tables often
crash and produces the folloing error message when I try to use the table in a query:
mysql select * from action;
error 1016: Can't open file: 'action.MYD'. (errno: 145).
The record
the table in a
query:
mysql select * from action;
error 1016: Can't open file: 'action.MYD'. (errno: 145).
The record in this table is temporary, after I delete all record from action.
Everything is seem to ok. But it will repeat same problem soon.
How can I fix it?
Best Regards
http://www.mysql.com/doc/W/i/Windows_vs_Unix.html
Can't open named pipe error
If you use a MySQL 3.22 version on NT with the newest mysql-clients you will
get the following error:
error 2017: can't open named pipe to host: . pipe...
This is because the release version of MySQL uses named
Ansgar,
what could cause the problem Brent reports in MySQL-Front?
InnoDB returns the error Can't open file mytable.InnoDB
when it cannot find the table in its internal data
dictionary. Maybe the case of letters in the database name
is wrong?
Brent,
if you look at the MySQL server error log
Hi *.*
what could cause the problem Brent reports in MySQL-Front?
InnoDB returns the error Can't open file mytable.InnoDB
when it cannot find the table in its internal data
dictionary. Maybe the case of letters in the database name
is wrong?
Sorry, I don't know..
On win32-hosts letter
the error Can't open file mytable.InnoDB
when it cannot find the table in its internal data
dictionary. Maybe the case of letters in the database name
is wrong?
Brent,
if you look at the MySQL server error log, something like
'hostname'.err, what does InnoDB say in it?
You could try the MySQL-4.0.0
on the left. If I try and select one of
my InnoDb tables from underneath the database node, I'll get an error
window saying MySQL Error - 1016 Can't open file mytable.InnoDB'. (errno:
1). Clicking on the database name says one or more of the InnoDb tables
are 0KB. I know there is data
Hi,
I have a table:
CREATE TABLE WI_PICTUREFILES (
SECTIONID VARCHAR(50) BINARY NOT NULL,
PICTUREID VARCHAR(50) BINARY,
PICTUREFILE VARCHAR(200) BINARY NOT NULL,
PICFILEXT VARCHAR(5) BINARY NOT NULL,
SHEETNO VARCHAR(2) BINARY,
Check for /etc/my.cnf or .my.cnf in mysql's var directory.
One of these must have a line misdefining the socket as mysqld.sock.
Chad Nantais wrote:
Description: on start, MySQL creates a socket (mysqld.sock), in the /tmp directory
by default, and tries to start
by opening socket
Description: on start, MySQL creates a socket (mysqld.sock), in the /tmp directory by
default, and tries to start
by opening socket mysql.sock. this might be a configuration error. the
following fix worked.
How-To-Repeat:
try to start mysql by running ./safe_mysqld
Fix:
a mirror-ed DB at our end.
We were successful in mirroring our tables initially using
LOAD TABLE FROM MASTER.
But some of the tables on Slave server have very short life. They
presumabely die, giving this sort of Error :
Error 1016: Can't open file: 'ftp_customer.MYD'. errno: 144
This also happens
70 matches
Mail list logo
