• Resolved lyassinel

    (@lyassinel)


    Hello,

    and first of all thank you for your plugin.
    I installed your plugin because my site gets a lot of random 500 errors. I.e. by making a refresh the page appears. It seems to be a memory problem but I have 1go allocated for the database and 18go in total on the server.

    I wanted to do a scan with your plugin (scan : pF3dGaTk ), but my site fell into error 500 on the frontend except for the home page. I was getting this error in the log:

    www.asiasport.be [Wed Dec 20 20:10:14.888395 2023] [core:error] [pid 1519843:tid 140275477362432] [client 109.236.138.120:0] AH00124: Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace., referer https://www.asiasport.be/
    
    www.asiasport.be [Wed Dec 20 20:10:13.598153 2023] [core:error] [pid 1519843:tid 140276559496960] [client 109.236.138.120:0] AH00124: Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace., referer https://www.asiasport.be/
    
    www.asiasport.be [Wed Dec 20 20:10:13.598122 2023] [core:error] [pid 1519843:tid 140276559496960] [client 109.236.138.120:0] AH00124: Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace., referer https://www.asiasport.be/

    and this one

    www.asiasport.be [Wed Dec 20 20:10:07.585666 2023] [fastcgi:error] [pid 1519843:tid 140276031018752] [client 109.236.138.120:0] FastCGI: server "/home/clients/71a55b7ebadabd8bd5686931089d322b/.config/apache/www.asiasport.be/.fpm/php5.external" stderr: PHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DESCRIBE wp_berocket_termmeta;/**imfs-query-tag*4544481759*/' at line 1 for query EXPLAIN DESCRIBE wp_berocket_termmeta;/**imfs-query-tag*4544481759*/ made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ImfsMonitor->imfsMonitorGather, ImfsMonitor->encodeQuery, referer https://www.asiasport.be/wp-admin/plugins.php

    I deactivated your plugin but it didn’t remove the error. When I tried to deactivate all the plugins, the error went away (there was a blank page during the attempt to deactivate the plugins and everything miraculously worked again).

    I’ve reinstalled your plugin and run a scan again, but I still get this error in the log:

    www.asiasport.be [Wed Dec 20 20:46:39.790405 2023] [fastcgi:error] [pid 1565528:tid 140276391642880] [client 2001:1600:13:100:f816:3eff:fed1:85b6:0] FastCGI: server "/home/clients/71a55b7ebadabd8bd5686931089d322b/.config/apache/www.asiasport.be/.fpm/php5.external" stderr: PHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DESCRIBE wp_berocket_termmeta;/**imfs-query-tag*2811991884*/' at line 1 for query EXPLAIN DESCRIBE wp_berocket_termmeta;/**imfs-query-tag*2811991884*/ made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ImfsMonitor->imfsMonitorGather, ImfsMonitor->encodeQuery
    

    I don’t dare run the process for the keys in the database. Could you tell me how to correct this error and analyze my scan, as I don’t really understand it, or how I can improve something.

    Thank you very much.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author OllieJones

    (@olliejones)

    Thank you for this report. This is definitely a defect.

    https://github.com/OllieJones/index-wp-mysql-for-speed/issues/71

    The query-monitoring code runs EXPLAIN on various queries to retrieve their query plans. You have a BeRocket plugin that itself uses the DESCRIBE SQL command. But attempts to EXPLAIN DESCRIBE don’t work, and throw errors.

    This problem only comes up when you run a monitor. So, until I fix the problem you can use the plugin to add high-performance keys.

    Thread Starter lyassinel

    (@lyassinel)

    Thank you for your responsiveness. Could you please analyze my Scan file before I run the key process. I’d like to know if I really have a problem with insufficient memory or if it’s something else.

    scan id. pF3dGaTk

    Kind regards
    Thank you

    Plugin Author OllieJones

    (@olliejones)

    In the monitor you uploaded, a plugin called WP-Cron Status Checker is responsible for the slowest queries. It seems likely that its wp_wcsc_logs table isn’t getting historical data removed.

    Your database’s buffer pool (2 GiB) has 17% free space, so that looks fine.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database error’ is closed to new replies.