Oh, sorry, forgot that mysql doesn't have ANALYZE - please replace it with EXTENDED.
It doesn't look like the issue from the other thread affected something that requires a reindex, so I doubt it is the issue - more likely one of the related tables has a lot of rows causing the join result to be very large. On Wed, Nov 2, 2016 at 10:27 PM, 'Konstantin Orekhov' via Foreman users < [email protected]> wrote: > Hmm, MySQL DB complains about the syntax of those queries: > > You have an error in your SQL syntax; check the manual that corresponds to > your MySQL server version for the right syntax to use near 'ANALYZE SELECT > DISTINCT `hosts`.`id` FROM `hosts` LEFT OUTER JOIN `host_status` ' at line 1 > > You have an error in your SQL syntax; check the manual that corresponds to > your MySQL server version for the right syntax to use near 'ANALYZE SELECT > COUNT(DISTINCT `hosts`.`id`) FROM `hosts` LEFT OUTER JOIN `host_s' at line 1 > > BTW, is there something like "foreman-rake db:index" or similar that would > rebuild the indexes? This particular DB had issues that Dominic helped me > to resolve (see https://groups.google.com/d/msg/foreman-users/qkmfeP2R-ss/ > vUE3FJHsBQAJ for more details), but I wonder if I need to rebuild the > indexes after that fix. > > Thanks! > > Konstantin Orekhov > > > > -- > You received this message because you are subscribed to the Google Groups > "Foreman users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/foreman-users. > For more options, visit https://groups.google.com/d/optout. > -- Have a nice day, Tomer Brisker Red Hat Engineering -- You received this message because you are subscribed to the Google Groups "Foreman users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/foreman-users. For more options, visit https://groups.google.com/d/optout.
