Re: Problem with indexer -Eblob

Hi,


On 03/13/2014 08:51 PM, [email protected] wrote:
> hi
> when i try this command, i have an error message : mysql_stmt_execute()
> failed: Lost connection to MySQL server during query
>
> here is the result of my command :
> ------------------------------------------------------------------------------------------------------------------------------------------------------
>
> root@bot:/usr/local/mnogosearch/sbin# ./indexer -Eblob
> /usr/local/mnogosearch/etc/indexer.conf
> indexer[22039]: Indexing
> indexer[22039]: Loading URL list
> indexer[22039]: Converting intag00
> indexer[22039]: Converting intag01
> indexer[22039]: Converting intag02
> indexer[22039]: Converting intag03
> indexer[22039]: Converting intag04
> indexer[22039]: Converting intag05
> indexer[22039]: Converting intag06
> indexer[22039]: Converting intag07
> indexer[22039]: Converting intag08
> indexer[22039]: Converting intag09
> indexer[22039]: Converting intag0A
> indexer[22039]: Converting intag0B
> indexer[22039]: Converting intag0C
> indexer[22039]: Converting intag0D
> indexer[22039]: Converting intag0E
> indexer[22039]: Converting intag0F
> indexer[22039]: Converting intag10
> indexer[22039]: Converting intag11
> indexer[22039]: Converting intag12
> indexer[22039]: Converting intag13
> indexer[22039]: Converting intag14
> indexer[22039]: Converting intag15
> indexer[22039]: Converting intag16
> indexer[22039]: Converting intag17
> indexer[22039]: Converting intag18
> indexer[22039]: Converting intag19
> indexer[22039]: Converting intag1A
> indexer[22039]: Converting intag1B
> indexer[22039]: Converting intag1C
> indexer[22039]: Converting intag1D
> indexer[22039]: Converting intag1E
> indexer[22039]: Converting intag1F
> indexer[22039]: Total converted: 32554167 records, 78081117 bytes
> indexer[22039]: Converting url data
> indexer[22039]: mysql_stmt_execute() failed: Lost connection to MySQL
> server during query
> ------------------------------------------------------------------------------------------------------------------------------------------------------
>
>
> have you an idea?

Try this:

select @@max_allowed_packet;

If the maximum packet size is small enough, try to increase it in
the server side.


If this does not help, then compile mnogoseearch again by adding
  --with-debug to the configure command line,
then add "DebugSQL=yes" parameter into DBAddr, like this:

DBAddr mysql://root@localhost/test/?DebugSQL=yes

and run "indexer -Eblob 2>LOG.txt".

It will print all SQL queries to the log file.
Check the last few lines in the log.

>
> --------------------
> my config :
>
> Debian 3.2.51-1 x86_64 GNU/Linux
> mnogosearch 3.3.15
>
>
>
>
> ---
> Ce courrier électronique ne contient aucun virus ou logiciel malveillant
> parce que la protection avast! Antivirus est active.
> http://www.avast.com
>
> _______________________________________________
> General mailing list
> [email protected]
> http://lists.mnogosearch.org/listinfo/general
_______________________________________________
General mailing list
[email protected]
http://lists.mnogosearch.org/listinfo/general