Since our 3.1.0 update today, our Search is no longer working. Our sysadmin team identified a problem and provided us with this log stating this is an application error. Does anyone else experience this problem and what may the clues be for us to be able to resolve the problem ourselves? I see search works perfectly at Discourse Meta. Started GET "/search?q=37%20%20realm&page=1" for [IP_REDACTED] at 2023-01-13 11:19:36 +0000 Processing by SearchController#show as JSON Parameters: {"q"=>"37 realm", "page"=>"1"} Completed 500 Internal Server Error in 4ms (ActiveRecord: 0.0ms | Allocations: 1555) ArgumentError (wrong number of arguments (given 1, expected 0)) lib/search.rb:285:in `execute' app/controllers/search_controller.rb:73:in `show' app/controllers/application_controller.rb:414:in `block in with_resolved_locale' app/controllers/application_controller.rb:414:in `with_resolved_locale' lib/middleware/omniauth_bypass_middleware.rb:74:in `call' lib/content_security_policy/middleware.rb:12:in `call' lib/middleware/anonymous_cache.rb:366:in `call' config/initializers/008-rack-cors.rb:24:in `call' config/initializers/100-quiet_logger.rb:20:in `call' config/initializers/100-silence_logger.rb:29:in `call' lib/middleware/enforce_hostname.rb:24:in `call' lib/middleware/request_tracker.rb:228:in `call' Failed to handle exception in exception app middleware : ArgumentError : wrong number of arguments (given 1, expected 0) Screenshots of the problem [Screenshot 2023-01-13 at 11.31.38@2x] [Screenshot 2023-01-13 at 11.31.07@2x] [Screenshot 2023-01-13 at 11.30.15@2x]

any chance that you use the private replies plugin ? [image] Discourse Private Replies Plugin Hi Richard, it seems there is an issue with the search patch (rebuilt with latest) [image] def execute(readonly_mode: @readonly_mode) seems to solve it though

We see the search doesn’t work for Topics/Posts, but works for Categories/Tags and Users.

Are you using an external instance of PostgreSQL? If so what is the version?

Yes, we are using the external PostgreSQL. The version is 14.6-1

Our search is completely broken when running against PostgreSQL 14, which is why we are still shipping PostgreSQL 13 for everyone following our standard install. We will eventually fix it since we will upgrade to PostgreSQL 15 (or 16) someday, but it may take a while.

Thank you. We’re investigating how that may have happened IF we have previously had other PostgreSQL version. Will get back to you once we identify the issue.

I’ve checked the discourse/docs/INSTALL.md at main · discourse/discourse · GitHub documentation instead, as Cloud documentation doesn’t have server requirements at all. We see “Postgres 13+” requirement here. May I be wrong by suggesting to your team to add a notice that Discourse supports 13.X versions only? Maybe, explicit notice of 14/15/… versions are not supported would be helpful too in such cases like ours. You see, we had Version 14 for at least since December, and we had Stable version of Discourse installed since months earlier. Recently we moved back to tests-passed version, searched worked as expected. Today, we updated from 2.9.0.beta14 to 3.1.0.beta1 and now it’s broken.

We have it installed, it is disabled in Admin settings We also tried and reproduced the issue in Safe Mode. Should it matter anyway?

Unclear, but that was the issue in my case (same symptoms - although with PostgreSQL13) I’m sure Richard will patch it up shortly, in the mean time a fork and a simple edit is a solution.

[image] Falco: Our search is completely broken when running against PostgreSQL 14 Oh. Bummer. I’ve got one site that I mostly accidentally upgraded to PG14 a while back, and figured it would be fine. I just did a few searches and they weren’t obviously terribly broken. And the site is mostly in Chinese, so I wouldn’t really be able to tell anyway. Just how broken is it and how hard is it going to be to fix it?

Search no longer works after 3.1.0.beta1 update

Product Support

Stephen (Stephen) January 13, 2023, 1:47pm 9

Whether you previously had 14 isn’t really material, Discourse isn’t compatible with PostgreSQL 14. That’s your issue.

Topic		Replies	Views
Update from 2.8.4 to 3.1.1 Self-hosting unsupported-install	4	435	October 18, 2023
Update problem : Broken Forum Self-hosting server-resources	26	2889	May 12, 2022
Internal error on search and after upgrade Product Support	2	475	August 17, 2020
Today error when upgrade from 2.5.1 to 2.5.2, discourse-assign Self-hosting	4	1017	October 7, 2020
Error upgrading from 3.0.1 to 3.1.0 Self-hosting	14	1006	March 28, 2023

Search no longer works after 3.1.0.beta1 update

Related topics