List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:August 2 1999 7:22pm
Subject:Basic Blob insert gets lost
View as plain text  
>>>>> "Steve" == Steve Ruby <stever@stripped> writes:

Steve> I have a table
mysql> show columns from amrcache
-> ;
Steve> +-------------+---------------+------+-----+---------+-------+
Steve> | Field       | Type          | Null | Key | Default | Extra |
Steve> +-------------+---------------+------+-----+---------+-------+
Steve> | FullURL     | varchar(255)  |      | PRI |         |       |
Steve> | CachedAt    | timestamp(14) | YES  |     | NULL    |       |
Steve> | Content     | longblob      | YES  |     | NULL    |       |
Steve> | ContentType | varchar(30)   | YES  |     | NULL    |       |
Steve> +-------------+---------------+------+-----+---------+-------+
Steve> 4 rows in set (0.20 sec)

Steve> daemon looks like
Steve> | max_allowed_packet | 1047552                 |
Steve> | max_connections    | 90                      |
Steve> | max_join_size      | 4294967295              |
Steve> | max_sort_length    | 1024                    |
Steve> | net_buffer_length  | 8192                    |

Steve> when I try to do
Steve> mysql -O max_allowed_packet=1M servletcache < inserttest.sql

Steve> it appears to work fine but then
Steve> select * from amrcache;

Steve> returns 0 rows

Steve> and 
Steve> select count(*) from amrcache;
Steve> returns 1

Steve> what am I doing wrong. Inserttest.sql looks like

Steve> INSERT INTO AmrCache (FullURL,Content) VALUES
Steve> ('test','1999/01/01 00:00:00,22.159999,415.799989,
Steve> 1999/01/01 00:15:00,24.319998,416.679994,
Steve> 1999/01/01 00:30:00,27.919998,411.279994,
Steve> 1999/01/01 00:45:00,19.999999,412.199989,
Steve> ')

Steve> where ther eare actually serveral rows of date data
Steve> but the total file (according to vi) only has 127,000 characters


Steve> using:
Steve> mysql  Ver 9.27 Distrib 3.22.14-gamma, for Win95/Win98 (i586)

Steve> maybe this has been fixed in the current distribution?
Steve> problem with redirect buffer on windows? I'm realy trying to
Steve> do this insert from the mm JDBC driver but when I started
Steve> getting bad results there I cam back to this to test it.

Steve> BTW if I make it so inserttest.sql only has fewer lines of
Steve> data it all works fine.


Hi!

I am not aware of any such bug in any MySQL version.

Try using:

mysql -vvv < inserttest.sql

You can also verify with isamchk that the database file is correctly
updated.

mysqladmin flush-tables
isamchk \mysql\data\servletcache\*.ISM

Regards,
Monty
Thread
Basic Blob insert gets lostSteve Ruby29 Jul
  • Basic Blob insert gets lostMichael Widenius2 Aug