Hi there,
My cron job stopped working like tree days ago. I have used the devel module with the backtrace mode to track down the issue and it seems like it's failing on a node that has 4396 comments at this point. Here is the output of the cron.php page:
... (Array, 12 elements)
backtrace_error_handler (Array, 2 elements)
trigger_error (Array, 4 elements)
_db_query (Array, 4 elements)
db_query (Array, 4 elements)
search_index (Array, 4 elements)
_node_index_node (Array, 4 elements)
file (String, 48 characters ) /home/spdba/public_html/modules/node/node.module
line (Integer) 1801
function (String, 16 characters ) _node_index_node | (Callback) _node_index_node();
args (Array, 1 element)
0 (Object) stdClass
nid (String, 5 characters ) 38633
node_update_index (Array, 2 elements)
call_user_func_array (Array, 4 elements)
module_invoke (Array, 4 elements)
search_cron (Array, 2 elements)
module_invoke_all (Array, 4 elements)
drupal_cron_run (Array, 4 elements)
Krumo version 0.2a | http://krumo.sourceforge.net
Warning: Got a packet bigger than 'max_allowed_packet' bytes query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:1318249:\"Got a packet bigger than 'max_allowed_packet' bytes\nquery: INSERT INTO search_dataset (sid, type, data, reindex) VALUES (38633, 'node', ' auxiliares de conversación 20092010 bienvenidos al nuevo hilo de auxiliares de conversación 20092010 speremos que los auxiliares veteranos nos echen una mano en todo lo que puedan ya que algunos andamos muy verdes jeje un saludo ah ok ok ah ok ok por aquí una vetera por aquí una veterana auxiliar actualmente en kent inglaterra por aquí otra yo e por aquí otra yo estoy en wilmslow en la fría inglaterra también hola pues yo también hola pues yo tambié in /home/spdba/public_html/includes/database.mysql.inc on line 128
Any ideas how to fix this issue? I'm thinking on closing the thread an moving some comments to a new thread, but I want to save that for last. I think Drupal should handle 4k and more comments without any issues.
Thanks in advanced
Comments
=-=
make backup of database
truncate the watchdog table
try increasing max_allowed_packet
4K comments on a single node is ALOT of comments on any one node.
Any ideas where the
Any ideas where the max_allowed_packet setting is and what are the implications? Thanks for you help.
=-=
http://www.google.com/search?hl=en&q=max_allowed_packet+mysql&aq=0&oq=ma...
Well, I have updated the
Well, I have updated the max_allowed_packet mysql setting to 32MB (set global max_allowed_packet=33554432) and it looks like cron is running now (is still not done, but does not hang).
Looking at the query above, I'm kind of concerned about the way the search module works. How is it possible that it is inserting on a table field the text of the node concatenated with the text of all comments? That is ALOT of text, specially if the number of comments is very large like in my case.
I think the content of the field should be split in multiple db rows, although I can't see why is needed at all. At least all duplicate words should be removed by the php code before the insertion, right?
I guess this should be an issue for the search module (is there a way to move this thread to that module?)
=-=
forum threads can't be moved to the issue queues.