Jed Reynolds wrote:
I'm seeing errors in my application where I'm getting from simple
selects every few hours:
I do a flush table activity_profiles; check table activity_profiles;
and the table seems to have fixed itself.
Any thots?
Thanks for the thots, guys. It turns out one of my
have you checked with myisamchk?
On Thu, Nov 13, 2008 at 4:09 PM, Jed Reynolds [EMAIL PROTECTED] wrote:
Application in php 5.1.6.I'm running MySQL version 5.0.45 on CentOS5 using
a HP DL380 with 8G ram and 15krpm raid10 disks. Tables are myisam.
I'm seeing errors in my application where I'm
Application in php 5.1.6.I'm running MySQL version 5.0.45 on CentOS5
using a HP DL380 with 8G ram and 15krpm raid10 disks. Tables are myisam.
I'm seeing errors in my application where I'm getting from simple
selects every few hours:
SELECT id, host_id, uri_id, profile
FROM
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Today mysql 4.1.8 has a segmentation fault (signal 11), and crashed.
In the process one table was left corrupted, when it started back up.
An application continued to call insert...select on the corrupted table
as it wasn't realized this happened.
I'm remotely administering a fedora 2 snort box via ssh.
running snort with
snort -c /etc.snort/snort.conf is fine - that is everything is logged
to tables and shows in acid.
But if i leave it running for over about a minute it buggers up. I
lose my ssh and acid/apache service. I then have to get
Feedback [EMAIL PROTECTED] wrote:
Well.. I had the same issue 2 weeks ago with another server from my
DC. I told them it was their hardware, they didnt believe it, so i had to
order a new
server, and ... The same problem occurs...
The axioma is: a user-land binary CANNOT hang the kernel. And
Feedback [EMAIL PROTECTED] wrote:
Besides that, the server has also a lot of trouble with the fact that =
sometimes the MySQLd just stops functionizing somehow, and the only way =
to kill the (all child processes broke down, so i mean the parent) =
process is 'killall -9 mysqld'. 'kill pid'
Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 12, 2004 10:23 AM
Subject: Re: Corrupt table, mysqld crashes, server crashes. Looking for a
solution
Feedback [EMAIL PROTECTED] wrote:
Besides that, the server has also a lot of trouble with the fact that =
sometimes the MySQLd
Today it happened again. For the third time in the last two weeks, my user table got
corrupt. I don't know what the problem is
Besides that, the server has also a lot of trouble with the fact that sometimes the
MySQLd just stops functionizing somehow, and the only way to kill the (all child
on Red Hat 7.2 using the JDBC driver.
Periodically we get a corrupt table with an error message like:
From mysqlcheck kenobi --check-only-changed
kenobi.dg_analysis_reading
warning : Table is marked as crashed
error: Key in wrong position at page 1335379968
error: Corrupt
Doing
at
bugs.mysql.com (http://bugs.mysql.com/bug.php?id=1321)
You can follow the progress on this issue there.
Thanks!
-Mark
- Original Message -
From: Fredrick Bartlett
Sent: Tuesday, September 16, 2003 7:40 PM
Subject: Re: (4.0.14) Corrupt table on DELETE FROM ...
FYI, same
table on DELETE FROM ...
FYI, same bug continues with the new dist 4.0.15.
- Original Message -
From: Carlos Peix [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 10:52 AM
Subject: (4.0.14) Corrupt table on DELETE FROM ...
Description:
Table gets
Would it be possible to share with me the name and location of this Hex
editor and also the Perl script as I am having the same problem where I have
lost my SQL data. Would
appreciate it greatly.
Michael Krassos
Network Specialist
University of Miami
Department of Telecommunications
I recently posted about my corrupt table where no matter what options
I tried REPAIR TABLE and myisamchk would recover the table but in
the process reduce the size from 27,000 rows to just 1000. Not very
useful.
In the end I managed to get almost all my data back by using a hex
editor
Rolf,
Tuesday, September 03, 2002, 1:57:49 AM, you wrote:
RH I'm using MySQL 3.23.51. I have a table which started giving 127 errors.
[skip]
RH It recovers my table but I end up with only 1030 out of 27497 rows,
RH so that's not a log of help!
RH Running myisamchk -r -e gives a similar result
I'm using MySQL 3.23.51. I have a table which started giving 127 errors.
Running myisamchk -i on it gives:
Checking MyISAM file: /Users/rolf/WBD/back/clip.MYI
Data records: 27497 Deleted blocks: 0
./bin/myisamchk: warning: 9 clients is using or hasn't closed the
table properly
-
Rolf,
Monday, September 02, 2002, 3:38:06 PM, you wrote:
RH I'm using MySQL 3.23.51. I have a table which started giving 127 errors.
[skip]
RH It recovers my table but I end up with only 1030 out of 27497 rows,
RH so that's not a log of help!
RH Running myisamchk -r -e gives a similar result
RH I'm using MySQL 3.23.51. I have a table which started giving 127 errors.
[skip]
RH It recovers my table but I end up with only 1030 out of 27497 rows,
RH so that's not a log of help!
RH Running myisamchk -r -e gives a similar result (only 1030 rows are
RH recovered), as does truncating the
At 23:57 +0100 9/2/02, Rolf Howarth wrote:
RH I'm using MySQL 3.23.51. I have a table which started giving 127 errors.
[skip]
RH It recovers my table but I end up with only 1030 out of 27497 rows,
RH so that's not a log of help!
RH Running myisamchk -r -e gives a similar result (only 1030 rows
Hi.
I just saw that one of the tables in a pretty big MySQL-database here
was corrupted. Checked the table with isamchk (yes, it's an
ISD/ISM-database, not MYD/MYI), and found some errors, but corrected
them. But, still the content are pretty .. uh, bad, and the backup isn't
all that recent...
Hi,
I seem to be having a problem with a corrupt table.
# myisamchk --fast --silent /var/lib/mysql/HNCandidate/Candidate.MYI
myisamchk: MyISAM file /var/lib/mysql/HNCandidate/Candidate.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: error
Hi,
I seem to be having a problem with a corrupt table.
# myisamchk --fast --silent /var/lib/mysql/HNCandidate/Candidate.MYI
myisamchk: MyISAM file /var/lib/mysql/HNCandidate/Candidate.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: error
Hi!
I have a most peculiar problem with a corrupt table.
My situation:
I have a mysql server running with several databases, one of them a log
database that only have one table with several attributes. I have lots
of inserts into this table which grows continuously, now the table size
is about
Justin wrote:
I have a puzzle..
Frequently, about, weekly? our data server gets into a state
where
select distinct(keyfield) from table
hangs in the 'sending data' phase, or the 'sorting result' phase,
the client is left waiting for the result, no rows are returned,
no errors are in
24 matches
Mail list logo