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 aga
> 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
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 h
sqld: 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)
060808 1:27:39 [ERROR] /usr/
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 fil
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] /us
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` patt
murthy gandikota wrote:
> 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
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 -psec
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
*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, doing some quick reading on InnoDB table definitions, it appears
that MySQL itself keeps s
ing similar 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
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 some
info within the table
u 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)
This is the output from mysqld
060613 19:59:34
(777 works, 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:
> >
> >
rote:
>
> 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
(777 works, 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
> ER
tting 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. May
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
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 fil
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.
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 oth
yes mr egor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 cras
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> AL
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
t;describe my_table" and I get:
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 wa
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
1016: Can't open file: 'action.MYD'. (errno: 145).
LQq> 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.
LQq> How can I fix it?
$ perror 145
Error code 145: Unknown error 145
145
essage 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 in this table is temporary, after I delete all record from action.
>Everything is seem to ok.
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).
I'm running a simple master/slave configuration with mysql-3.23.29-gamma
under Solaris 2.6. Sometime last night, one of the tables disappeared
on the slave. I got thousands of errors like this:
Can't open file: 'netgroup.MYD'. (errno: 144)
I fixed it with `drop
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'.
This al
33 matches
Mail list logo
