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.

[image] kinetiksoft: IF Whether you previously had 14 isn’t really material, Discourse isn’t compatible with PostgreSQL 14. That’s your 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?

La recherche ne fonctionne plus après la mise à jour 3.1.0.beta1

Assistance produit

Stephen (Stephen) Janvier 13, 2023, 3:28 19

Avez-vous consulté la documentation sur l’exécution de PostgreSQL externe ? Elle se trouve ici sur Meta, pas sur github. Toute la documentation est visible sur Documentation - Discourse Meta

Sujet		Réponses	Vues
Update from 2.8.4 to 3.1.1 Self-hosting unsupported-install	4	431	Octobre 18, 2023
Update problem : Broken Forum Self-hosting server-resources	26	2876	Mai 12, 2022
Internal error on search and after upgrade Product Support	2	475	Août 17, 2020
Today error when upgrade from 2.5.1 to 2.5.2, discourse-assign Self-hosting	4	1009	Octobre 7, 2020
Error upgrading from 3.0.1 to 3.1.0 Self-hosting	14	992	Mars 28, 2023

La recherche ne fonctionne plus après la mise à jour 3.1.0.beta1

Sujets connexes