Re: INSERT DELAYED still keeps CRUSHING (trying everything)
On Thursday 01 March 2001 11:03, Artem Koutchine wrote: Sinisa, i thought i pointed out that mysql ALWAYS crashes on any single INSERT DELAY anytime, any database, under any conditions and during any weather. NO single INSERT DELAY can be executed successfully. This looks like a bug in the thread library. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERT DELAYED still keeps CRUSHING (trying everything)
Artem Koutchine writes:
Hello again!
In the prev episode i said that when i do INSERT DELAYED
mysql just catches sig 11, crashes and restarts. No record
inserted whatsoever. Nothing is written into the update log.
Here is a sample (even though it says 1 row affected, it is
actually not affected. nothing is inserted):
mysql insert delayed into aaa (aid, aname) values (111,'hello');
Query OK, 1 row affected (0.00 sec)
mysql 010301 20:17:22 mysqld restarted
In the error log:
010301 20:16:27 mysqld started
/usr/local/mysql/bin/mysqld: ready for connections
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that
may
help in finding out why mysqld died
010301 20:17:22 mysqld restarted
/usr/local/mysql/bin/mysqld: ready for connections
I use FreeBSD 4.2-STABLE (cvsupped and rebuild last sunday),
MySQL 3.23.33. Compiled using the options which are used in the
FreeBSD port of mysql to make it stable on high loads. But it is build
from the original tar ball taken from www.mysql.com. That does not
matter, since patches for mysql on FreeBSD
are minimal and not really needed.
Sinisa recommended to try precompiled binary for FreeBSD. I did.
Same story - keeps crashing on INSERT DELAYED. (not to mention
that i hate to use precompiled stuff, because it is never configured
as i want it to be).
What's going on? I really need INSERT DELAYED since i need
to insert millions of records in a short time for development and
testing purposes.
Regards,
Artem
Hi!
Can you make a test case that would always crash MySQL ??
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERT DELAYED still keeps CRUSHING (trying everything)
Sinisa, i thought i pointed out that mysql ALWAYS
crashes on any single INSERT DELAY anytime,
any database, under any conditions and during any
weather. NO single INSERT DELAY can be executed
successfully.
Regards,
Artem
- Original Message -
From: "Sinisa Milivojevic" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 8:58 PM
Subject: Re: INSERT DELAYED still keeps CRUSHING (trying everything)
Artem Koutchine writes:
Hello again!
In the prev episode i said that when i do INSERT DELAYED
mysql just catches sig 11, crashes and restarts. No record
inserted whatsoever. Nothing is written into the update log.
Here is a sample (even though it says 1 row affected, it is
actually not affected. nothing is inserted):
mysql insert delayed into aaa (aid, aname) values (111,'hello');
Query OK, 1 row affected (0.00 sec)
mysql 010301 20:17:22 mysqld restarted
In the error log:
010301 20:16:27 mysqld started
/usr/local/mysql/bin/mysqld: ready for connections
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to
use a
stack trace and/or the core file to produce a readable backtrace
that
may
help in finding out why mysqld died
010301 20:17:22 mysqld restarted
/usr/local/mysql/bin/mysqld: ready for connections
I use FreeBSD 4.2-STABLE (cvsupped and rebuild last sunday),
MySQL 3.23.33. Compiled using the options which are used in the
FreeBSD port of mysql to make it stable on high loads. But it is
build
from the original tar ball taken from www.mysql.com. That does
not
matter, since patches for mysql on FreeBSD
are minimal and not really needed.
Sinisa recommended to try precompiled binary for FreeBSD. I did.
Same story - keeps crashing on INSERT DELAYED. (not to mention
that i hate to use precompiled stuff, because it is never
configured
as i want it to be).
What's going on? I really need INSERT DELAYED since i need
to insert millions of records in a short time for development and
testing purposes.
Regards,
Artem
Hi!
Can you make a test case that would always crash MySQL ??
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
