max_allowed_packet-error with blob in 3.3.4

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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.

> SELECT sum(length(intag00)) FROM bdicti;

56881618

> SHOW VARIABLES LIKE 'max_allowed_packet';

1073740800

I already tried to increase max_allowed_packet in my.cnf but
any value
above 1 GB is ignored and the limit stays at 1 GB...

I'm thankful for any hint!

Regards,
Kilian
- --
____________________________________________________________
__

      Kilian Huber  |  kilgnu.ch  |  GPG Key
0xBBBE7BA5
____________________________________________________________
__
Writing about music is like dancing about architecture.
                                         -- Frank Zappa
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org


iD8DBQFHBkKbGqu1bLu+e6URAmXCAJ4uJHmxQtRLScMowGsDpE8fBsbk/gCf
Sfvn
uTrainingq3K9QmeuHev/X1RYz7s=
=aVOk
-----END PGP SIGNATURE-----

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