Mercurial > p > roundup > code
comparison doc/upgrading.txt @ 6599:39189dd94f2c
issue2551189 - increase size of words in full text index.
Increased indexed word maxlength to 50
DB migration code is written and tests work.
Restructured some tests to allow for code reuse.
Docs.
If this passes CI without errors 2551189 should be done. However,
testing on my system generates errors. Encoding (indexer unicode
russian unicode string invalid) and collation errors (utf8_bin not
valid) when running under python2. No issues with python3 and I
haven't changed code that should cause these since the last successful
build in CI. So if this fails in CI we will have more checkins.
| author | John Rouillard <rouilj@ieee.org> |
|---|---|
| date | Wed, 26 Jan 2022 15:04:09 -0500 |
| parents | feab8c878d08 |
| children | 0d99ae7c8de6 |
comparison
equal
deleted
inserted
replaced
| 6598:27a4ab499189 | 6599:39189dd94f2c |
|---|---|
| 36 ============================= | 36 ============================= |
| 37 | 37 |
| 38 Rdbms version change from 6 to 7 (required) | 38 Rdbms version change from 6 to 7 (required) |
| 39 ------------------------------------------- | 39 ------------------------------------------- |
| 40 | 40 |
| 41 To add support for database supported full-text search (FTS), the | 41 This release includes two changes that require updates to the database |
| 42 rdbms database schema has to be upgraded. | 42 schema: |
| 43 | |
| 44 1. The size of words included in the Roundup FTS indexers have been | |
| 45 increased from 25 to 50. This requires changes to the database | |
| 46 columns used by the native indexer. This also affect the whoosh | |
| 47 and xapian indexers. | |
| 48 2. Some databases that include native full-text search (native-fts | |
| 49 indexer) searching are now supported. | |
| 43 | 50 |
| 44 You should run the ``roundup-admin migrate`` command for your | 51 You should run the ``roundup-admin migrate`` command for your |
| 45 tracker once you've installed the latest codebase. | 52 tracker once you've installed the latest codebase. |
| 46 | 53 |
| 47 Do this before you use the web, command-line or mail interface | 54 Do this before you use the web, command-line or mail interface |
| 49 | 56 |
| 50 If successful, this command will respond with either "Tracker | 57 If successful, this command will respond with either "Tracker |
| 51 updated" (if you've not previously run it on an RDBMS backend) or | 58 updated" (if you've not previously run it on an RDBMS backend) or |
| 52 "No migration action required" (if you have run it, or have used | 59 "No migration action required" (if you have run it, or have used |
| 53 another interface to the tracker, or are using anydbm). | 60 another interface to the tracker, or are using anydbm). |
| 61 | |
| 62 See `below for directions on enabling native-fts`_. | |
| 63 | |
| 64 .. _below for directions on enabling native-fts: \ | |
| 65 #enhanced-full-text-search-optional | |
| 66 | |
| 67 The increase in indexed word length also affects whoosh and xapian | |
| 68 backends. You may want to run ``roundup-admin -i tracker_home | |
| 69 reindex`` if you want to index or search for longer words in your full | |
| 70 text searches. Re-indexing make take some time. | |
| 54 | 71 |
| 55 Check compression settings (optional) | 72 Check compression settings (optional) |
| 56 ------------------------------------- | 73 ------------------------------------- |
| 57 | 74 |
| 58 Read the `administration guide`_ section on `Configuring Compression`_. | 75 Read the `administration guide`_ section on `Configuring Compression`_. |