У кого MySQL 5.0.45 и до последний 5.0.x - проверьте плиз на разных OS
Проверьте плиз на разных OS
CREATE TABLE IF NOT EXISTS `bug` (
`id1` int(11) NOT NULL,
`id2` int(11) NOT NULL,
`id3` int(11) NOT NULL,
`info` char(10) NOT NULL,
PRIMARY KEY (`id1`,`id2`,`id3`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;
select info from bug
where id1=4 and (id2=354 or id2=0)
order by id2 desc
у меня вызывает
#2006 - MySQL server has gone away
thd=0x20b1700
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0x440ca0f0, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
(nil)
New value of fp=0x20b1700 failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Red
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x20b78a0 = select info from bug where id1 = 13489827 and id3 = 191283 and ( id2 = 354 or id2 = 0 ) order by id2 desc
LIMIT 0, 30
thd->thread_id=4
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
Number of processes running now: 0
080213 18:43:05 mysqld restarted
Проверьте плиз на разных OS
CREATE TABLE IF NOT EXISTS `bug` (
`id1` int(11) NOT NULL,
`id2` int(11) NOT NULL,
`id3` int(11) NOT NULL,
`info` char(10) NOT NULL,
PRIMARY KEY (`id1`,`id2`,`id3`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;
select info from bug
where id1=4 and (id2=354 or id2=0)
order by id2 desc
у меня вызывает
#2006 - MySQL server has gone away
thd=0x20b1700
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0x440ca0f0, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
(nil)
New value of fp=0x20b1700 failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Red
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x20b78a0 = select info from bug where id1 = 13489827 and id3 = 191283 and ( id2 = 354 or id2 = 0 ) order by id2 desc
LIMIT 0, 30
thd->thread_id=4
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
Number of processes running now: 0
080213 18:43:05 mysqld restarted
