keyword search broken on RT #31

New Issue

sb10q · 2023-05-15T08:44:57+08:00

sb10q commented

2023-05-15 08:44:57 +08:00

always returns 0 tickets

sb10q commented

2023-05-15 08:54:22 +08:00

May 14 02:00:01 nixbld RT[2808860]: [2808860] DBD::Pg::db selectrow_array failed: ERROR:  relation "attachmentsindex" does not exist
                                    LINE 1: SELECT MAX(id) FROM AttachmentsIndex
                                                                ^ at /nix/store/b939hn2mrdydc7avxfzbdf3zn9v0acj7-rt-5.0.3/bin/.rt-fulltext-indexer-wrapped line 288.
May 14 02:00:01 nixbld RT[2808860]: [2808860] DBD::Pg::db selectrow_array failed: ERROR:  relation "attachmentsindex" does not exist
                                    LINE 1: SELECT MAX(id) FROM AttachmentsIndex
                                                                ^ at /nix/store/b939hn2mrdydc7avxfzbdf3zn9v0acj7-rt-5.0.3/bin/.rt-fulltext-indexer-wrapped line 288.
May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: [2808860] [Sat May 13 18:00:01 2023] [warning]: DBD::Pg::db selectrow_array failed: ERROR:  relation "attachmentsindex>
May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: LINE 1: SELECT MAX(id) FROM AttachmentsIndex
May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]:                             ^ at /nix/store/b939hn2mrdydc7avxfzbdf3zn9v0acj7-rt-5.0.3/bin/.rt-fulltext-indexer-wrapped>
May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: [2808860] [Sat May 13 18:00:01 2023] [critical]: DBD::Pg::db selectrow_array failed: ERROR:  relation "attachmentsinde>
May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: LINE 1: SELECT MAX(id) FROM AttachmentsIndex
May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]:                             ^ at /nix/store/b939hn2mrdydc7avxfzbdf3zn9v0acj7-rt-5.0.3/bin/.rt-fulltext-indexer-wrapped>
May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: DBD::Pg::db selectrow_array failed: ERROR:  relation "attachmentsindex" does not exist
May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: LINE 1: SELECT MAX(id) FROM AttachmentsIndex
May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]:                             ^ at /nix/store/b939hn2mrdydc7avxfzbdf3zn9v0acj7-rt-5.0.3/bin/.rt-fulltext-indexer-wrapped>
May 14 02:00:01 nixbld systemd[1]: rt-fulltext-indexer.service: Main process exited, code=exited, status=255/EXCEPTION
May 14 02:00:01 nixbld systemd[1]: rt-fulltext-indexer.service: Failed with result 'exit-code'.

Could be yet another bug from RT's crippled database migration script.

``` May 14 02:00:01 nixbld RT[2808860]: [2808860] DBD::Pg::db selectrow_array failed: ERROR: relation "attachmentsindex" does not exist LINE 1: SELECT MAX(id) FROM AttachmentsIndex ^ at /nix/store/b939hn2mrdydc7avxfzbdf3zn9v0acj7-rt-5.0.3/bin/.rt-fulltext-indexer-wrapped line 288. May 14 02:00:01 nixbld RT[2808860]: [2808860] DBD::Pg::db selectrow_array failed: ERROR: relation "attachmentsindex" does not exist LINE 1: SELECT MAX(id) FROM AttachmentsIndex ^ at /nix/store/b939hn2mrdydc7avxfzbdf3zn9v0acj7-rt-5.0.3/bin/.rt-fulltext-indexer-wrapped line 288. May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: [2808860] [Sat May 13 18:00:01 2023] [warning]: DBD::Pg::db selectrow_array failed: ERROR: relation "attachmentsindex> May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: LINE 1: SELECT MAX(id) FROM AttachmentsIndex May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: ^ at /nix/store/b939hn2mrdydc7avxfzbdf3zn9v0acj7-rt-5.0.3/bin/.rt-fulltext-indexer-wrapped> May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: [2808860] [Sat May 13 18:00:01 2023] [critical]: DBD::Pg::db selectrow_array failed: ERROR: relation "attachmentsinde> May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: LINE 1: SELECT MAX(id) FROM AttachmentsIndex May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: ^ at /nix/store/b939hn2mrdydc7avxfzbdf3zn9v0acj7-rt-5.0.3/bin/.rt-fulltext-indexer-wrapped> May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: DBD::Pg::db selectrow_array failed: ERROR: relation "attachmentsindex" does not exist May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: LINE 1: SELECT MAX(id) FROM AttachmentsIndex May 14 02:00:01 nixbld rt-fulltext-indexer[2808860]: ^ at /nix/store/b939hn2mrdydc7avxfzbdf3zn9v0acj7-rt-5.0.3/bin/.rt-fulltext-indexer-wrapped> May 14 02:00:01 nixbld systemd[1]: rt-fulltext-indexer.service: Main process exited, code=exited, status=255/EXCEPTION May 14 02:00:01 nixbld systemd[1]: rt-fulltext-indexer.service: Failed with result 'exit-code'. ``` Could be yet another bug from RT's crippled database migration script.

esavkin commented

2024-01-22 11:26:06 +08:00

It is not related to any of the upgrades, it feels just like no rt-setup-fulltext-index was ever run.
Now it is working and shows pretty much tickets on query "artiq".
Also the doc says that it will work properly only with Latin-ish (preferably English) words.
The rt-fulltext-indexer seems to be already running every 2 hours (?).

It is not related to any of the upgrades, it feels just like no `rt-setup-fulltext-index` was ever run. Now it is working and shows pretty much tickets on query "artiq". Also the doc says that it will work properly only with Latin-ish (preferably English) words. The `rt-fulltext-indexer` seems to be already running every 2 hours (?).

esavkin closed this issue

2024-01-22 11:26:07 +08:00

Sign in to join this conversation.

No Label

No Milestone

No Assignees

2 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: M-Labs/it-infra#31