External_search_in_use problem

Sharetribe Go Community Edition
14

Appears to be a problem with connection to mysql:

  1. check if your server has enough CPU, and RAM resources, maybe it goes out of memory/swap
  2. check your database connection configuration in config/database.yml
  3. launch mysql console, and check limits show variables like '%max_conn%'; and show processlist to see if there are excessive connections.
  4. in shell launch ps -aufwx to see if you have some extra processes that should not be there
  5. recheck your apache passenger settings https://www.phusionpassenger.com/library/config/apache/optimization/
15

1/ IDK how to check that :confused:

2/ Connected!

3/ @max_conn = NULL

4/There’s a lot of apache2 process

16

use top to get overview of server load http://man7.org/linux/man-pages/man1/top.1.html

17

CPU = between 48 and 87%
MEM = 14%

18

Sometimes ruby take 99% CPY

19

seems your server is somewhat overloaded and performing too slow sometimes, so you can temporary increase connection time timeout: 15000 in config/database.yml

20

What can be the cause of the overload ? :confused:

21

I modify the timeout but it’s still broken

23

I just a new thing

Jun 06 18:02:08 ip-172-31-15-131 sharetri2[1152]: App 2379 stdout: {"method":"HEAD","path":"/","format":"html","controller":"HomepageController","action":"index","status":301,"duration":82.4
Jun 06 18:03:29 ip-172-31-15-131 sharetri2[1152]: App 2379 stdout: {"method":"GET","path":"/","format":"html","controller":"HomepageController","action":"index","status":200,"duration":26429
Jun 06 18:03:42 ip-172-31-15-131 sharetri2[1152]: App 2379 stdout: {"marketplace_id":1,"tag":"listing_index_service","free":"Error connecting to Sphinx via the MySQL protocol. Error connecti
Jun 06 18:03:47 ip-172-31-15-131 sharetri2[1152]: App 2379 stdout: {"method":"GET","path":"/","format":"html","controller":"HomepageController","action":"index","status":500,"duration":7789.

“Error connecting to Sphinx via the MySQL protocol” I don’t know how to resolve it, I know the server is good, I just test to connect to it (Being a AWS server, It’s an external database)

24

Does anyone know how to solve this problem?

25

You should do following:

  1. stop running sphinx processes
    killall -9 searchd
  2. restart sphinx
    RAILS_ENV=production rake ts:rebuild
26

That works ! Thank you !

Do you know how to put a popup on the main page ?

I’d like to give an information to my community and I don’t know how to write something on the main page

I also would like to put my chatbox on my website, so know how to modify html file is mandatory for me :confused:

27

I tried to use the patch but when I restart Sphinx I get this error:

ERROR: index ‘listing_delta’: sql_range_query: Expression #20 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘sharetribe_production.locations.latitude’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (DSN=mysql://sharetribe:***@localhost:3306/sharetribe_production).
ERROR: index ‘listing_delta’: sql_range_query: Expression #20 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘sharetribe_production.locations.latitude’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (DSN=mysql://sharetribe:***@localhost:3306/sharetribe_production).

I guess this is related to the mysql database.

28

see this fix for group by https://github.com/sharetribe/sharetribe/pull/3256#issuecomment-400919987

29

Thanks for this awesome patch, what is the radius size used, and is it possible to change the radius size?

30

Hello,

I would like to use this most essential patch with Sharetribe 10, but I believe it’s not compatible anymore (patch fails to apply)… Would anyone know if there is a way to get through with that ? @zenik, I believe you were the one who came up with this solution ?

Thanks a lot for your help !

EDIT : in the end I managed to get through, sorry ! I had to apply the patch manually for one of the files, then I had to follow the instructions given in this post https://www.sharetribe.com/community/t/will-the-new-improved-search-function-on-sharetribe-com-come-to-the-open-source-version/107/27 to get the search working again

1 Like
32

Good to hear, @Pierre-Louis_de_Lapo!

And thanks a lot for sharing the solution, that surely will help other visitors of that forum :slight_smile: Great spirit here, much appreciated!

33

Applying the patch worked like a charm. Funny thing is that when I set location to private to show listing locations approximate wit a radius, the whole map disappears. On the homepage looking on the map, it still shows the map with exact locations.

Applying the patch, feedback is given that 1 of 4 parts where already part of an upstream patch.

Any thoughts on what causes this problem?

34

Hi @Lennard
You need to enable Google Maps static API for your google maps API key. Hopefully, this will work.
Please let me know if I can still assist you with any issues or implementations in your marketplace application.

Regards,
Aman
Email - mailtoamanam@gmail.com
https://www.upwork.com/freelancers/~0186c7b9e674fc8699

35

That was indeed the problem. Static API was not allowed in Google cloud console. Much appreciated Aman. Thank you