Mercurial > p > roundup > code
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 5136:602d544e3a93 | 5137:98fdc1f98194 |
|---|---|
| 15 installation MUST support InnoDB tables (or Berkeley DB (BDB) tables | 15 installation MUST support InnoDB tables (or Berkeley DB (BDB) tables |
| 16 if you have no other choice). If you're running < 4.0.18 (but not <4.0) | 16 if you have no other choice). If you're running < 4.0.18 (but not <4.0) |
| 17 then you'll need to use BDB to pass all unit tests. Edit the | 17 then you'll need to use BDB to pass all unit tests. Edit the |
| 18 ``roundup/backends/back_mysql.py`` file to enable DBD instead of InnoDB. | 18 ``roundup/backends/back_mysql.py`` file to enable DBD instead of InnoDB. |
| 19 2. Python MySQL interface - http://sourceforge.net/projects/mysql-python | 19 2. Python MySQL interface - http://sourceforge.net/projects/mysql-python |
| 20 | |
| 21 | |
| 22 Other Configuration | |
| 23 =================== | |
| 24 | |
| 25 If you are indexing large documents (e.g attached file contents) | |
| 26 using MySQL, you may need to increase the max_allowed_packet size. | |
| 27 If you don't you can see the error:: | |
| 28 | |
| 29 'MySql Server has gone away (2006)' | |
| 30 | |
| 31 To do this edit /etc/my.conf and change:: | |
| 32 | |
| 33 [mysqld] | |
| 34 max_allowed_packet = 1M | |
| 35 | |
| 36 the 'max_allowed_packet' value from '1M' to '64M' or | |
| 37 larger. | |
| 38 | |
| 39 Alternatively you can install an alternate indexer (whoosh, xapian | |
| 40 etc.) and force the tracker to use it by setting the ``indexer`` | |
| 41 setting in the tracker's ``config.ini``. | |
| 42 | |
| 43 This fix was supplied by telsch. See issue | |
| 44 http://issues.roundup-tracker.org/issue2550743 for further info or if | |
| 45 you are interested in developing a patch to roundup to help work | |
| 46 around this issue. | |
| 20 | 47 |
| 21 Running the MySQL tests | 48 Running the MySQL tests |
| 22 ======================= | 49 ======================= |
| 23 | 50 |
| 24 Roundup tests expect an empty MySQL database. Two alternate ways to provide | 51 Roundup tests expect an empty MySQL database. Two alternate ways to provide |