Actions
Feature #7728
openFulltext searchable Description
Start date:
04/11/2024
Due date:
% Done:
0%
Estimated time:
To be discussed:
No
Description
We have Description in 'events' table, we are able to search it, but only by exact search. As it is possibly longer text, it would make sense to search through it as fulltext.
Arguably, we could extract all meaningful text fields from the event and do fulltext over all of them, possibly while renaming Description search field more generally.
Related issues
Updated by Pavel Kácha 6 months ago
- Related to Feature #7729: Description tab in timeline added
Updated by Jakub Maloštik 3 months ago
- Status changed from In Progress to Resolved
Updated by Jakub Judiny 3 months ago
- Target version changed from Backlog to 2.13.2
Updated by Rajmund Hruška about 2 months ago
- Target version changed from 2.13.2 to 2.14
Updated by Rajmund Hruška 2 days ago
- Status changed from Closed to Feedback
I came across an issue when building vagrant from devel branch:
default: ==========> Bootstraping database schema and configuration
default: 2024-11-06 13:11:40,621 INFO: Executing script command 'init'
default: 2024-11-06 13:11:40,622 INFO: Initializing main database.
default: 2024-11-06 13:11:40,797 INFO: Initializing event database.
default: 2024-11-06 13:11:40,881 INFO: Initializing event database indices.
default: Traceback (most recent call last):
default: File "/vagrant/lib/mentat/services/eventstorage.py", line 1099, in exc_handle_wrapper
default: return func(self, *args, **kwargs) # pylint: disable=locally-disabled,not-callable
default: ^^^^^^^^^^^^^^^^^^^^^^^^^^^
default: File "/vagrant/lib/mentat/services/eventstorage.py", line 1299, in index_create
default: self.cursor.execute(query)
default: File "/var/mentat/venv/lib/python3.11/site-packages/psycopg2/extras.py", line 312, in execute
default: return super().execute(query, vars)
default: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
default: psycopg2.errors.UndefinedObject: operator class "gin_trgm_ops" does not exist for access method "gin"
default:
default:
default: The above exception was the direct cause of the following exception:
default:
default: Traceback (most recent call last):
default: File "/vagrant/bin/mentat-dbmngr.py", line 47, in <module>
default: MentatDbmngrScript().run()
default: File "/var/mentat/venv/lib/python3.11/site-packages/pyzenkit/baseapp.py", line 1559, in run
default: self._stage_process()
default: File "/var/mentat/venv/lib/python3.11/site-packages/pyzenkit/baseapp.py", line 1472, in _stage_process
default: self._sub_stage_process()
default: File "/var/mentat/venv/lib/python3.11/site-packages/pyzenkit/zenscript.py", line 353, in _sub_stage_process
default: self.execute_script_command(cmdname)
default: File "/var/mentat/venv/lib/python3.11/site-packages/pyzenkit/zenscript.py", line 410, in execute_script_command
default: self.runlog[command_name] = cbk() # pylint: disable=locally-disabled,not-callable
default: ^^^^^
default: File "/vagrant/lib/mentat/module/dbmngr.py", line 276, in cbk_command_init
default: self.eventservice.index_create()
default: File "/vagrant/lib/mentat/services/eventstorage.py", line 1120, in exc_handle_wrapper
default: raise EventStorageException(str(err)) from err
default: mentat.services.eventstorage.EventStorageException: operator class "gin_trgm_ops" does not exist for access method "gin"
default:
default: [2024-11-06 13:11:43,905] INFO in base: Connected to event database
default: INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
default: INFO [alembic.runtime.migration] Will assume transactional DDL.
default: INFO [alembic.runtime.migration] Running stamp_revision -> 9c4e85c45a1b
default: INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
default: INFO [alembic.runtime.migration] Will assume transactional DDL.
default: INFO [alembic.runtime.migration] Running stamp_revision -> bd66f22e2e4e
default: Optimizing AUTOVACUUM for database 'mentat_events'
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: Optimizing AUTOANALYZE for database 'mentat_events'
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: Optimizing CLUSTERs for database 'mentat_events'
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ERROR: index "enum_targabuses_data_key" for table "enum_targetabuses" does not exist
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: Optimizing CLUSTERs for database 'mentat_main'
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
default: ALTER TABLE
Actions