Skip Navigation

Home › Support › English Support › [Closed] Too many SQL commands and crashing website

[Closed] Too many SQL commands and crashing website

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 10:00 – 17:00 10:00 – 17:00 10:00 – 17:00 10:00 – 17:00 10:00 – 17:00 -
- 18:00 – 19:00 18:00 – 19:00 18:00 – 19:00 18:00 – 19:00 18:00 – 19:00 -

Supporter timezone: Asia/Kathmandu (GMT+05:45)

This topic contains 24 replies, has 2 voices.

Last updated by Shekhar Bhandari 1 year, 2 months ago.

Assisted by: Shekhar Bhandari.

Author Posts
November 23, 2023 at 11:23 am #14907109

jonC-13

Getting this in the logs and crashing the website

executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |

over and over until the site crashes.
November 24, 2023 at 9:20 am #14914829

Shekhar Bhandari
Supporter

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello JonC-13,

Welcome to WPML support. I'd be happy to help you with this.

- Are you using the latest versions of WPML plugins?
- Which version of PHP/MYSQL are you using?

You can easily send this information using the Debug information settings from WPML.

Could you please go to WPML > Support > Debug Information and give me the information in the next reply? You can read the detailed instructions here:
http://wpml.org/faq/provide-debug-information-faster-support/

Further, If you disable all non-related WPML plugins, and switch to one of the default themes, does the problem persist or not?

NOTE:
+ Make a backup (both files and database) for your site before updating/proceeding with anything (Always a good practice!).

Look forward to your reply.

Thanks
November 24, 2023 at 9:26 am #14914907

jonC-13

it's difficult to test another theme, this is a very big site and high traffic.

November 24, 2023 at 10:27 am #14915821

Shekhar Bhandari
Supporter

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

You can create a test site and perform the tests, these tests are very important to know the depth of the issue.

Also, can you consult the host and ask if they have any queries that have been recorded for this issue?

Look forward to your reply.

Thanks
November 24, 2023 at 10:32 am #14915945

jonC-13

yes the last ticket I have on here your developer tried to copy the website but was too large.

I have spoken with my hosting and they say a server upgrade wouldn't help. That the plugin needs to be optimised as the logs are filling up with these constant SQL commands and crashing the website.

What do you suggest?
November 27, 2023 at 2:27 am #14926135

Shekhar Bhandari
Supporter

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

I have spoken with my hosting and they say a server upgrade wouldn't help. The plugin needs to be optimized as the logs are filling up with these constant SQL commands and crashing the website.

I would suggest choosing an upgrade, and once upgraded check the logs again.

Also, it will be helpful if we can receive the full details logs.

Look forward to your reply.

Thanks
November 27, 2023 at 8:22 am #14927237

jonC-13

| Id | User | Host | db | Command | Time | State | Info |
+---------+-----------------+-----------+----------------+---------+---------+------------------------+------------------------------------------------------------------------------------------------------+
| 5 | event_scheduler | localhost | | Daemon | 1285033 | Waiting on empty queue | |
| 3804826 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 53 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804827 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 49 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804828 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 55 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804833 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 49 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804835 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 49 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804837 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 45 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804839 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 49 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804842 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 42 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804844 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 41 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804846 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 44 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804847 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 44 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804849 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 43 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804850 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 46 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804851 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 39 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804853 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 42 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804855 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 42 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804856 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 41 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804858 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 44 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804860 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 42 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804861 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 38 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804864 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 34 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804867 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 28 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804872 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 23 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804874 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 21 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804878 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 17 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804879 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 19 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804887 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 19 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804892 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 15 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804893 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 14 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804895 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 8 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804896 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 15 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804897 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 14 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804901 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 13 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804902 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 12 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804905 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 60 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804907 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 55 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804909 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 53 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804911 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 51 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804915 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 48 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804916 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 46 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804917 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 46 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804918 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 46 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804919 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 45 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804920 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 44 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804923 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 39 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804924 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 32 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804926 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 11 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804928 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 6 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804929 | theolive_wrdp1 | localhost | theolive_wrdp1 | Query | 4 | executing | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translatio |
| 3804930 | theolive_wrdp1 | localhost | theolive_wrdp1 | Sleep | 0 | | |
| 3804931 | root | localhost | | Query | 0 | init | show processlist |
November 27, 2023 at 8:22 am #14927245

jonC-13

they are saying this SQL commands need optimising and upgrade wouldn't help.
November 27, 2023 at 8:29 am #14927311

Shekhar Bhandari
Supporter

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

To debug this issue further, I would need to check your site settings once, for this I would need temporary access (wp-admin and ftp) to your site.

So could you please provide me with those details, you will find the needed fields for this below the comment area when you log in to leave your next reply.
hidden link

This info is private and available to you and WPML supporters only.
Read more about this: https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/

Note:
Backup your sites before providing the credentials or if possible provide credentials for the test site

Look forward to your reply.

Thanks
November 27, 2023 at 8:43 am #14927571

Shekhar Bhandari
Supporter

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

hidden link

Can you follow the suggestions mentioned there?

Further, I enabled the WPML plugins and it seems to be working for me, does it take some time before it crashes completely, do I need to follow any steps?

Also, I would be unable to escalate this issue unless we test the minimal setup tests considering there are a lot of plugins installed, we would need to disable all plugins and themes and see if the problem exists.

Since you mentioned it's a large site, I think the only way this is possible is with the help of your host, they can set up a test site and we can run all our tests there. Can you consult with them and ask if this is possible?

I have kept WPML plugins enabled at the moment.

Look forward to your reply.

Thanks
November 27, 2023 at 8:54 am #14927677

jonC-13

yes after about 10 mins it starts to slow until it crashes completely. I will monitor over the next 10 mins. I will check the list you sent also, thanks
November 27, 2023 at 10:22 am #14928749

jonC-13

I have to disable plugins as problem happening again

The slow log entries are still there, please have a look at /var/lib/mysql/theolivepress-slow.log.

---------------------
# Time: 2023-11-27T09:19:37.332754Z
# User@Host: theolive_wrdp1[theolive_wrdp1] @ localhost [] Id: 4778136
# Query_time: 3.161827 Lock_time: 0.000005 Rows_sent: 26 Rows_examined: 310298
SET timestamp=1701076774;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( YEAR( wp_posts.post_date ) = 2006 AND MONTH( wp_posts.post_date ) = 11 )
) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','mc4wp-form' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','mc4wp-form' ) )

ORDER BY wp_posts.post_date DESC
LIMIT 0, 26;
November 28, 2023 at 4:28 am #14935655

Shekhar Bhandari
Supporter

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

As mentioned previously, we need a test site to debug this further, did you talk with your host about a possibility of test site where we can perform multiple tests?

Look forward to your reply.

Thanks
November 28, 2023 at 2:27 pm #14940885

jonC-13

\ok the hosting has set up a test server if you can send me private form to send you the logins
November 29, 2023 at 2:20 am #14945547

Shekhar Bhandari
Supporter

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

Sure, enabled the private reply for you.

Can you also check if the problem exists on the test server? Also, test it by disabling everything except WPML.

Look forward to your reply.

Thanks

The topic ‘[Closed] Too many SQL commands and crashing website’ is closed to new replies.