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
