List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 27 1999 2:03am
Subject:Re: ERROR 2013 when updating a table with a longblob in it.
View as plain text  
At 11:13 AM +1000 8/27/99, Cameron Just wrote:
>Hi,
>
>I am running
>Ver 7.11 Distrib 3.22.25, for pc-linux-gnu on i686
>
>
>I get an error when I try to do the following.
>update messages set status = 'read' where id = 1568;
>ERROR 2013: Lost connection to MySQL server during query
>
>It only happens when I try to update an record with a 'body' field greater
>than ~40K
>all other queries to records which have smaller 'body' fields work perfectly.
>
>
>Table Messages
>+--------------+--------------+------+-----+---------+----------------+
>| Field        | Type         | Null | Key | Default | Extra          |
>+--------------+--------------+------+-----+---------+----------------+
>| id           | int(11)      |      | PRI | 0       | auto_increment |
>| userid       | int(11)      |      | MUL | 0       |                |
>| headers      | blob         | YES  |     |         |                |
>| body         | longblob     | YES  |     |         |                |
>| popid        | varchar(64)  | YES  |     |         |                |
>| folderid     | int(11)      | YES  |     |         |                |
>| attachmentid | int(11)      | YES  |     |         |                |
>| recieveddate | int(11)      | YES  |     |         |                |
>| status       | varchar(255) | YES  |     |         |                |
>+--------------+--------------+------+-----+---------+----------------+


Is your server running with a small value of the max_allowed_packet
parameter?

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
ERROR 2013 when updating a table with a longblob in it.Cameron Just27 Aug
  • Re: ERROR 2013 when updating a table with a longblob in it.Paul DuBois27 Aug
    • Re: ERROR 2013 when updating a table with a longblob in it.Cameron Just27 Aug
      • Re: ERROR 2013 when updating a table with a longblob in it.Michael Widenius29 Aug
Re: ERROR 2013 when updating a table with a longblob in it.Michael Widenius30 Aug
Re: ERROR 2013 when updating a table with a longblob in it.Cameron Just31 Aug
  • Re: ERROR 2013 when updating a table with a longblob in it.Michael Widenius31 Aug