No Code Attached Yet bug
avatar MacJoom
MacJoom
17 Nov 2024

Steps to reproduce the issue

On a website with a lot of articles (in my case >88000)

Go to Smart Seach, Index
Either do:

  • Index, the index process takes a few hours but works, in the end there is no success message because the optimise process is run at the end times out (in the background)

  • Optimise, the process times out (e.g. 504 Gateway Time-out)

Expected result

Optimise works

Actual result

Optimise times out

System information (as much as possible)

PHP 8.2 Joomla 5.2.1
max_execution_time set to 720 (maximum)

Additional comments

I'm working on a CLI solution with new queries (tests show that the query in question runs 32 minutes...)

avatar MacJoom MacJoom - open - 17 Nov 2024
avatar MacJoom MacJoom - change - 17 Nov 2024
Labels Removed: ?
avatar MacJoom MacJoom - labeled - 17 Nov 2024
avatar joomla-cms-bot joomla-cms-bot - change - 17 Nov 2024
Labels Added: No Code Attached Yet
avatar joomla-cms-bot joomla-cms-bot - labeled - 17 Nov 2024
avatar Hackwar
Hackwar - comment - 19 Nov 2024

Please have a look at #44485, which should solve the issue actually.

avatar Hackwar Hackwar - close - 24 Nov 2024
avatar Hackwar
Hackwar - comment - 24 Nov 2024

Since #44485 is already RTC and should indeed greatly improve this issue, I'm closing this ticket for now. If #44485 doesn't solve your issue, please open it again.

avatar Hackwar Hackwar - change - 24 Nov 2024
Status New Closed
Closed_Date 0000-00-00 00:00:00 2024-11-24 09:50:49
Closed_By Hackwar
avatar MacJoom
MacJoom - comment - 25 Nov 2024

I have tested unsuccessfully with the prebuilt package on my local test website. I found the culprit query in the onFinderGarbageCollection() routine in administrator/components/com_finder/src/Indexer/Adapter.php . The query before the loop takes very long with a lot of items in the finder_links table.

avatar MacJoom MacJoom - change - 25 Nov 2024
Status Closed New
Closed_Date 2024-11-24 09:50:49
Closed_By Hackwar
avatar MacJoom MacJoom - reopen - 25 Nov 2024
avatar mrownicki
mrownicki - comment - 12 Dec 2024

I have 45k article. Indexing literally takes 6-7 hours

Add a Comment

Login with GitHub to post a comment