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 co-m
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 wher
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 activity_profiles
-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.
S
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 kern
;Egor 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 s
"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
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
pro
ql 3.23.56 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
at this behavior, and have filed a bug 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
Re: (4.0.14) Corrupt 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,
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
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 g
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 r
>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
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 r
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
>-
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...
I
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:
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:
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
No, it is not disk space.. it is not table corruption either..
it is server confusion, with no diagnostic information output.
Symptom again: hang on straight forward queries involving a total
index scan, with either count(*) or distinct(*), usually
stuck with 100% cpu use of the thread in 'sendi
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
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 the sql server error log
26 matches
Mail list logo
