Project

General

Profile

Actions

Feature #7728

closed

Fulltext searchable Description

Added by Pavel Kácha 8 months ago. Updated 27 days ago.

Status:
Closed
Priority:
Normal
Category:
Development - GUI
Target version:
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

Related to Mentat - Feature #7729: Description tab in timelineClosedJakub Maloštik04/11/2024

Actions
Actions #1

Updated by Pavel Kácha 8 months ago

Actions #2

Updated by Rajmund Hruška 5 months ago

  • Tracker changed from Bug to Feature
Actions #3

Updated by Jakub Maloštik 4 months ago

  • Assignee set to Jakub Maloštik
Actions #4

Updated by Jakub Maloštik 4 months ago

  • Status changed from New to In Progress
Actions #5

Updated by Jakub Maloštik 4 months ago

  • Status changed from In Progress to Resolved
Actions #6

Updated by Jakub Judiny 4 months ago

  • Target version changed from Backlog to 2.13.2
Actions #7

Updated by Rajmund Hruška 3 months ago

  • Target version changed from 2.13.2 to 2.14
Actions #8

Updated by Rajmund Hruška about 1 month ago

  • Status changed from Resolved to In Review
Actions #9

Updated by Rajmund Hruška about 1 month ago

  • Status changed from In Review to Closed
Actions #10

Updated by Rajmund Hruška about 1 month 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 #11

Updated by Jakub Maloštik about 1 month ago

  • Status changed from Feedback to Resolved
Actions #12

Updated by Rajmund Hruška about 1 month ago

  • Status changed from Resolved to In Review
Actions #13

Updated by Rajmund Hruška 27 days ago

  • Status changed from In Review to Closed
Actions

Also available in: Atom PDF