@brennen: I assume you don't remember any details either? (Which is fine ofc. Just wondering.)

Offhand, I don't remember anything about this one. If @20after4 happens to see this, he might remember specifics... I'm guessing it's probably safe to drop by now.

@Aklapper just to make sure we are on the same page, you mentioned phab1004, but the table is on db1213 (the database) or there's a backup file there in phab1004 too?
I wasn't able to find that one.

Regarding the database one, the table seems to be from 2022

root@db1213:/srv# find . | grep search_documentfield_BKUP -i | xargs ls -lh
-rw-rw---- 1 mysql mysql 1.3K Sep 23  2022 ./sqldata/phabricator_search/search_documentfield_BKUP.frm
-rw-rw---- 1 mysql mysql 1.3G Sep 23  2022 ./sqldata/phabricator_search/search_documentfield_BKUP.ibd

If you want me to take a backup of it (to a text file) and drop it, we can also do that.

Sorry, I just have been clearer in my choice of words. I only ssh into phab1004, you are very likely completely right about it using db1213. :)

If you want me to take a backup of it (to a text file) and drop it, we can also do that.

In my (so far very limited) understanding of Phab's Search we will not need a backup as that's a now unused (as in "no code exists anymore to ever read it") index of some search terms.

It is also very likely it was renamed (and not removed) to see if anything would break and if nothing broke it does probably means it is safe to drop (if the data isn't needed).

@Aklapper should we go ahead then?

@Marostegui Yes please

Mentioned in SAL (#wikimedia-operations) [2025-03-06T10:16:10Z] <marostegui> Drop phabricator_search.search_documentfield_BKUP T387174