Re: Problem with indexer -Eblob
| Newsgroups | gmane.comp.web.mnogosearch.general |
|---|---|
| Message-ID | <[email protected]> |
Hi Thanks for your help If i take select @@max_allowed_packet; i have this result : +----------------------+ | @@max_allowed_packet | +----------------------+ | 16777216 | +----------------------+ 1 row in set (0.00 sec) So, after i have recompile mnogoseearch 3.3.15 by adding --with-debug i have run make and make install i have add DebugSQL=yes in indexer.conf at the end of line DBAddr mysql://root:mypasswd@localhost/test/?dbmode=blob&DebugSQL=yes and i have run indexer -Eblob 2>LOG.txt the message in LOG.txt is : ---------------------------------------------- indexer[13250]: Indexing indexer[13250]: Loading URL list ---------------------------------------------- the process terminated on the console by 'Killed' message i do not understand nothing ? is my databases corrupted ? can you help me ? Le 18/03/2014 03:18, Alexander Barkov a écrit : > 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 --- 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