diff doc/mysql.txt @ 5137:98fdc1f98194

issue2550743 - Reindex with MySQL Server failed. It looks like indexing large documents may require increasing mysql's max_allowed_packet setting. Documented the issue in doc/mysql.txt.
author John Rouillard <rouilj@ieee.org>
date Sat, 09 Jul 2016 14:27:24 -0400
parents 33a1f03b9de0
children e2978ed3b550 64ceb9c14b28
line wrap: on
line diff
--- a/doc/mysql.txt	Sat Jul 09 13:34:02 2016 -0400
+++ b/doc/mysql.txt	Sat Jul 09 14:27:24 2016 -0400
@@ -18,6 +18,33 @@
    ``roundup/backends/back_mysql.py`` file to enable DBD instead of InnoDB.
 2. Python MySQL interface - http://sourceforge.net/projects/mysql-python
 
+
+Other Configuration
+===================
+
+If you are indexing large documents (e.g attached file contents)
+using MySQL, you may need to increase the max_allowed_packet size.
+If you don't you can see the error::
+
+   'MySql Server has gone away (2006)'
+
+To do this edit /etc/my.conf and change::
+
+    [mysqld]
+    max_allowed_packet = 1M
+
+the 'max_allowed_packet' value from '1M' to '64M' or
+larger.
+
+Alternatively you can install an alternate indexer (whoosh, xapian
+etc.) and force the tracker to use it by setting the ``indexer``
+setting in the tracker's ``config.ini``.
+
+This fix was supplied by telsch. See issue
+http://issues.roundup-tracker.org/issue2550743 for further info or if
+you are interested in developing a patch to roundup to help work
+around this issue.
+
 Running the MySQL tests
 =======================
 

Roundup Issue Tracker: http://roundup-tracker.org/