ty to Win | Act with Sensitivity | Unyielding
Integrity
From: Amarnath Shivashankar (WI01 - Services)
Sent: Tuesday, October 23, 2007 11:40 AM
To: 'mysql@lists.mysql.com'
Subject: Table crashes
Hi Friends,
I need a document on why tables crash in
I need a document on why tables crash in MYSQL and what are the repair
> methods?
>
> I would also like to know if there are any preventive measures to avoid
> table crashes?
>
>
>
> Regards,
> Amarnath Shivashankar
> SQL Database Management
>
>
>
>
>
>
&g
From: Amarnath Shivashankar (WI01 - Services)
Sent: Tuesday, October 23, 2007 11:40 AM
To: 'mysql@lists.mysql.com'
Subject: Table crashes
Hi Friends,
I need a document on why tables crash in MYSQL and what are the repair
methods?
I would also like to know if there are any
Hi Friends,
I need a document on why tables crash in MYSQL and what are the repair
methods?
I would also like to know if there are any preventive measures to avoid
table crashes?
Regards,
Amarnath Shivashankar
SQL Database Management
The information contained in this electronic
On Mon, 1 Aug 2005, Heikki Tuuri wrote:
> unfortunately, the bug fix was never made to 4.0. It is only in 4.1.12 and
> later.
Hi Heikki,
Thanks for your response. The fix seems to consists only of a few lines:
http://mysql.bkbits.net:8080/mysql-4.1/[EMAIL PROTECTED]|[EMAIL PROTECTED]
It look
;; <[EMAIL PROTECTED]>
Lähetetty: Monday, August 01, 2005 5:08 PM
Aihe: mysql bug 9670 OPTIMIZE TABLE crashes
Hi,
I am experiencing assertion failures described in the following bugreport:
http://bugs.mysql.com/bug.php?id=9670
The bug has been closed, but I'm running the most
On Mon, 1 Aug 2005, Mikhail Entaltsev wrote:
> in the bug report Heikki Tuuri wrote:
> ***
> [13 Apr 20:59] Heikki Tuuri
> The bug was introduced in 4.0.24 and 4.1.10. The fix will be in 4.1.12 and
> 5.0.5.
> ***
Hi Mikhail,
Thank you for your quick response. I had noticed myself that the fix
s
ot;MySQL mailing list"
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, August 01, 2005 4:08 PM
Subject: mysql bug 9670 OPTIMIZE TABLE crashes
> Hi,
>
> I am experiencing assertion failures described in the following bugreport:
>
> http://bugs.mysql.com/b
Hi,
I am experiencing assertion failures described in the following bugreport:
http://bugs.mysql.com/bug.php?id=9670
The bug has been closed, but I'm running the most current 4.0.25 version
of MySQL. The report mentions downgrading to 4.0.23 or upgrading to 4.1.
Is this really neccessary or s
Hi,
Recently I've been seeing the following kind of error message for several of
the MyISAM tables in my database:
General error: Can't open file: 'build_packages.MYI'. (errno: 145)
Running a simple repair operation on the corrupted table will make MySQL
happy again, even though the repair st
lost
Regards
Thierno6C - MySQL 4.0.15
- Original Message -
From: "Datatal AB - Gauffin, Jonas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 07, 2003 10:05 AM
Subject: SV: Table crashes
Hello
> crashes occurs for some reasons like :
> - unc
Hello
> crashes occurs for some reasons like :
> - unclean tables ( tables are closed improprely),
> - hardware problems
> - something goes wrong in the system
> - know bugs
> Check that your tables are clean, before start using them.
MyODBC 3.51 is the only way that I access the database. (MyODB
From: "Datatal AB - Gauffin, Jonas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 07, 2003 7:05 AM
Subject: Table crashes
Hello
Some one my tables have crashed (again). I had to repair them ASAP since
the db is in my production enviroment.
1. How can I fi
Hello
Some one my tables have crashed (again). I had to repair them ASAP since
the db is in my production enviroment.
1. How can I find the cause of the crashes?
2. I've created a my.cnf and added the following lines. Is the format
correct?
[mysqld]
set-variable = myisam-recover=BACKUP,FORCE
set-
On Thu, 25 Sep 2003 09:23:13 -0500
Ben Ricker <[EMAIL PROTECTED]> wrote:
> Here is the output we got this morning:
>
> test.MESSAGES optimizeerror 13 when fixing table
> test.MESSAGES optimizestatus Operation failed
# perror 13
Error code 13: Permission denied
check if
I am the admin of a Mysql 4.0.14-standard databas running on Solaris 9.
A developer and I created a shell script that does a mysqldump of the
database and then runs an optimize on the largest table we have. The
command line is as follows:
$EXECPATH/mysql --host=172.65.12.10 --user=user --password
Hello,
I have a table, not too large (200,000+). It crashes all the time. I
should qualifiy that: it crashes when I perform updates to it. I can
qualify that further, and say that it crashes when I update certain fields.
One more thing, the fields that it crashes seem to all be part of a fullt
Kalok Lo writes:
> I've had many problems with BDB table crashes.
> Up until now, I haven't really cared, running safe_mysqld, the database just
> restarts, and things proceed as normal.
>
> But recently I've had some strange behaviour, where table data is d
I've had many problems with BDB table crashes.
Up until now, I haven't really cared, running safe_mysqld, the database just
restarts, and things proceed as normal.
But recently I've had some strange behaviour, where table data is deleted
after an "alter table" statement.
Hi,
Having some problems with a particular BDB table, which crashes once in a
while. Just wondering if anyone has experienced such BDB table crashes?
The relevant info is included below for troubleshooting. Let me know if I
need to send anything else. Appreciate any help. Thanks
Heikki Tuuri wrote:
>
> Hi!
>
> >Michael Blood wrote:
> >
> >> I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram.
> >>
> >> I have been getting an table handler returns error 127 error
> >>
> >> If I fix the table with myisamchk -r or -o it will work for a while and then
> >> I will g
Hi!
>Michael Blood wrote:
>
>> I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram.
>>
>> I have been getting an table handler returns error 127 error
>>
>> If I fix the table with myisamchk -r or -o it will work for a while and then
>> I will get the same error again.
>
>Try dumping and
Michael Blood wrote:
> I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram.
>
> I have been getting an table handler returns error 127 error
>
> If I fix the table with myisamchk -r or -o it will work for a while and then
> I will get the same error again.
Try dumping and restroing the
I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram.
I have been getting an table handler returns error 127 error
If I fix the table with myisamchk -r or -o it will work for a while and then
I will get the same error again.
Here are some of the stats on the table
rows:1126904
index len
24 matches
Mail list logo
