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