Nico Sabbi wrote:
Hi,
with mysql 4.1[234], importing a dump of Innodb tables containing at
least a blob field
I invariably get_
ERROR 1030 (HY000) at line 21027: Got error 139 from storage engine
I read in the bugzilla that this problem is due to low memory
conditions, but
surely it's not my case: the server has 2 GB ram, and it doesn't have
anything else
running than mysql.
I also tried to raise
set-variable = innodb_buffer_pool_size=120M
set-variable = innodb_additional_mem_pool_size=120M
but with no improvent.
The content of the err file is:
050920 11:46:31 mysqld started
050920 11:46:31 InnoDB: Started; log sequence number 0 18025704
/usr/sbin/mysqld-max: ready for connections.
Version: '4.1.14-Max' socket: '/var/lib/mysql/mysql.sock' port:
3306 MySQL Community Edition - Max (GPL)
Is there a way to fix this behaviour or should I revert to 4.0?
Thanks,
If it can help, seems that the largest value I can store in a blob field
without triggering that error is 192 characters long.
--
Nico Sabbi - Officine Digitali - Bologna
Tel. 051 - 4187565
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]