, but i thought i'd let you
guys know...
Thanks again for all the hints and help!
Kind regards,
Sander Smeenk.
--
| Just remember -- if the world didn't suck, we would all fall off.
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BDB D463 7E41 08CE C94D
--
MySQL General Mailing List
For list
Quoting Critters ([EMAIL PROTECTED]):
SELECT * FROM members WHERE name = '1' and '1' or '1' AND password = '1' and
'1' or '1'
And it returned all rows. Can someone explain to me why this happens,
and if the steps I took (replacing the ' with a blank space when the
user submits the login
Quoting sheeri kritzer ([EMAIL PROTECTED]):
Do a show status like 'uptime' after the script runs. See if the
server crashed (if so, uptime will be low) -- if the server crashed
you might get that error.
The server itself does not crash. Uptime shows that, besides the fact
that this would
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
What is happening is that when you start you perl script which
contains a lot of queries, you are first establishing a connection to
MySQL, and then you are running some queries, and somewhere in between
you are losing connection to the server,
Hi,
I'm running MySQL 5.0.19 (Debian sid, package revision 3) on a Dual
Opteron250 64 bit machine with 4gb memory.
The problem i'm experiencing is that at certain moments, the connection
between my perlscripts and the database gets disconnected:
| DBI connect('products','beheerv',...) failed:
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
Can anyone shed any light on this issue?
This might shed more light into your problem
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
I've read that :)
But still, the query returns the same data, if I run it alone, or in the
complete stats
Quoting Mohammed Abdul Azeem ([EMAIL PROTECTED]):
Then it hit a mysql bug with signal 6. The mysql db was throwing the
following errors on the shell prompt ie the OS shell prompt.
I had exactly the same behaviour on MySQL 5.0.19 running on AMD64.
What helped in my case was re-creating all the
Quoting Jacques Brignon ([EMAIL PROTECTED]):
1030 : Got error 28 from table handler
% perror 28
OS error code 28: No space left on device
Any idea of what might cause that, and what should be done to correct
this situation?
Aparently the disk that stores your MySQL datadirectory is full.
Quoting Pete Harlan ([EMAIL PROTECTED]):
MySQL version 5.0.18
| Mar 14 00:32:59 zwart mysqld[29820]: *** glibc detected *** double
| free or corruption (!prev): 0x012b1ab0 ***
You don't say which versions of glibc or the kernel you're running,
but if you're running
Hello!
I'm having a weird problem i'd like to hear your opinions about:
| [18:44] [EMAIL PROTECTED]:~] # mysqlcheck v games
| v.games
| error: Table './v/games' is marked as crashed and should be repaired
| [18:44] [EMAIL PROTECTED]:~] # mysqlcheck -r v games
| v.games
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
That usually means the table is corrupt beyond repair and nothing is really
fixing it or there is something one cannot easily comprehend ( this usually
happens with inconsistency among deleted records and some kind of mismatch
that occurs)
Quoting [EMAIL PROTECTED] ([EMAIL PROTECTED]):
Have you tried the following myisamchk option:
--extend-check, -e
Yup. But that won't even work at ALL:
# myisamchk -e games.MYI
Checking MyISAM file: games.MYI
Data records: 10644 Deleted blocks: 0
- check file-size
- check record
Quoting sheeri kritzer ([EMAIL PROTECTED]):
what's the result of
SHOW CREATE TABLE games
It gives me the create statement for that table.
All perfectly normal. MyISAM table, latin1 charset.
I'd drop the indexes on the games table, and then run repair tables,
and then put the indexes back
Quoting sheeri kritzer ([EMAIL PROTECTED]):
According to the manual, 64 to 32 bit shouldn't matter, it should work
fine as long as they're both little endian, or they're both big
endian.
This friend of mine said he also had major problems moving 32-64.
Crashing mysql's, but not corrupt
crashing.
Any hints are welcome!
Thanks in advance!
Kind regards,
Sander Smeenk.
--
| For security, this message has been encrypted with ROT13 twice.
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BDB D463 7E41 08CE C94D
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
15 matches
Mail list logo