Re: MySQL constantly crash on BLOB insertions...

2001-02-05 Thread Jani Tolonen
Huang-Ming writes: Hi! I just saw this question un-answered, so in case you already got a private answer, please just ignore. > hi Tim, > > thanks for the prompt response which is hard to be seen with Oracle > and Microsoft. > > sorry, i should have had studied hard the manual a year >

Re: MySQL constantly crash on BLOB insertions...

2001-01-23 Thread Michael Widenius
Hi! > "Benjamin" == Benjamin Pflugmann <[EMAIL PROTECTED]> writes: Benjamin> Hi. Benjamin> On Mon, Jan 22, 2001 at 11:37:23PM +0200, [EMAIL PROTECTED] wrote: >> > "Huang-Ming" == Huang-Ming <[EMAIL PROTECTED]> writes: >> Huang-Ming> hi Tim, >> Huang-Ming> thanks for the prompt respon

Re: MySQL constantly crash on BLOB insertions...

2001-01-22 Thread Benjamin Pflugmann
Hi. On Mon, Jan 22, 2001 at 11:37:23PM +0200, [EMAIL PROTECTED] wrote: > > "Huang-Ming" == Huang-Ming <[EMAIL PROTECTED]> writes: > > Huang-Ming> hi Tim, > > Huang-Ming> thanks for the prompt response which is hard to be seen with Oracle and >Microsoft. > > Huang-Ming> sorry, i should ha

Re: MySQL constantly crash on BLOB insertions...

2001-01-22 Thread Michael Widenius
> "Huang-Ming" == Huang-Ming <[EMAIL PROTECTED]> writes: Huang-Ming> hi Tim, Huang-Ming> thanks for the prompt response which is hard to be seen with Oracle and Microsoft. Huang-Ming> sorry, i should have had studied hard the manual a year ago. regarding the error, however, would the err

Re: MySQL constantly crash on BLOB insertions...

2001-01-22 Thread Huang-Ming
AIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 22, 2001 7:04 PM Subject: Re: MySQL constantly crash on BLOB insertions... > On Mon, Jan 22, 2001 at 12:33:46PM +0200, Thimble Smith wrote: > > I can repeat this problem; I'm looking into it and we'll hopefully &

Re: MySQL constantly crash on BLOB insertions...

2001-01-22 Thread Thimble Smith
On Mon, Jan 22, 2001 at 12:33:46PM +0200, Thimble Smith wrote: > I can repeat this problem; I'm looking into it and we'll hopefully > have a patch for it shortly. Well, the problem is simply that max_allowed_packet needs to be increased. Check the manual entry. http://mysql.tonnikala.org/doc/S/

Re: MySQL constantly crash on BLOB insertions...

2001-01-22 Thread Thimble Smith
On Mon, Jan 22, 2001 at 05:45:24PM +0800, Huang-Ming wrote: > to avoid further table corruption of my production database, i > created ebody into the MySQL-accompanying "test" database and > did the blob.pl test. the fault is still thereMySQL has > just gone away with the wind I can repea

Re: MySQL constantly crash on BLOB insertions...

2001-01-22 Thread Huang-Ming
  hi Monty,   i already ftp to ftp://support.mysql.com/pub/mysql/secret a zip of scripts for your kindly inspection at the "MySQL has gone away..." fault happening when i want to insert a big row to my ebody table which contains a LONGTEXT (or LONGBLOB) column. the scripts are blob.pl: a s

Re: MySQL constantly crash on BLOB insertions...

2001-01-22 Thread Huang-Ming
hi Monty, thanks for the response. i'm writing a small test script to insert similar big stuff to my table and if the "gone away" fault is still outstanding, i'll send it to you, along with current contents of my database. thanks again. peter - Original Message - From: Michael Wid

Re: MySQL constantly crash on BLOB insertions...

2001-01-22 Thread Huang-Ming
hi, the fatal "MySQL gone away..." error remains outstanding even after i upgraded 3.22.25 to 3.23.31 just now. i also run mysql_convert_table_format with my database, which should have converted all tables to MyISAM format. does anybody have good idea of working around this? i cannot go on an