Webboard: max_allowed_packet with blob in 3.3.4

Author: Kilian
Email: 
Message:
Hi all,

I'm trying to set up a search DB with mnoGoSearch 3.3.4, in
the indexer.conf I've set dbmode=blob, Deflate=yes and
zint4=yes in DBAddr.

After running indexer.conf -a the first time, I run
indexer.conf -Eblob which fails with the following error:

indexer[10336]: MySQL driver: #2020: Got packet bigger than
'max_allowed_packet'

It does so after a HUGE insert statement:

{sql.c:2554} Query: INSERT INTO bdict_tmp
VALUES('à', 1, 0xFFFFFFFF0100000078DA.....

The MySQL database in question is about 3 GB and it seems I
can not raise the max_allowed_packet higher than 1 GB...
what do I do about this? What have others with such a big
database done?

Running MySQL 4.0.24 on Debian Linux.

I'm thankful for any hint!

Regards,
Kilian

Reply: <http://www.mnogosearch.org/board/message.php?id=19634&g
t;


------------------------------------------------------------
---------
To unsubscribe, e-mail: general-unsubscribemnogosearch.org
For additional commands, e-mail: general-helpmnogosearch.org