littlebloke

Hi,

Thanks that’s helpful… i’ll go away and do some investigation updating the thread further with any results.

Hi,

Thanks for the info,

This was a few of the log entries that I was able to get from our IT team, there may be others… is there anything specific that I could look for that may be of help?

Here are the plugin/version details I forgot to include in my last email, a full list of plugins we use:

– WordPress 3.9

– Advanced Access Manager 2.6
– Akismet 3.0.0
– BackUpWordPress 2.6.2
– bbPress 2.5.3
– bbPress Enable TinyMCE Visual Tab 1.0.1
– Buddy Plugin 1.2 (associated with theme)
– BuddyPress 2.0.1
– BuddyPress Community Stats 0.5.1
– BuddyPress Docs 1.7.0
– BuddyPress Group Email Subscription 3.4
– BuddyPress Profile Visibility Manager 1.0.5
– Easy WP SMTP 1.07
– Email Login 4.6.3
– GB bbPress Attachments 2.1
– Google Analyticatoor 6.4.7.3
– Invite Anyone 1.2.1
– Jetpack by WordPress.com 2.9.3
– Prevent Password Reset 0.2.0
– Twitter Widget Pro 2.6.0
– WP Email Template PRO 1.1.3.1

Theme is:

– Buddy (by Ghostpool)

In terms of numbers we have 52 Groups, and a total of 103 buddy press docs, which can themselves contain between 2 and up to 30 items (we have a total of around 1500 media files).

Not all these groups are ‘active’. but a number of groups contain say, 10 docs each containing around 20 items.

Hope this helps.

LB.

Hi,

we have a similar issue which is effecting our site. Our site is large and we use bp_docs extensively within a number of groups.

We have discovered that when we add a featured image to a post and submit the post we get an ‘error establishing database connection’ for around 20-40 mins.

Our IT department has indicated that this is due to “multiple apache worker processes are created when trying to set the featured image”.

We worked extensively to identify the issue, initially we believed the theme to be at fault but we have ruled that out by a process of elimination.

By disabling and re-enabling plugins and re-running the process of setting a featured image we have determined that ‘buddypress docs’ is somehow putting enough of a strain on the system to take it down.

Here are some log entries (edited to remove certain references) that have occurred around the time of the system going down, BP_docs and bp_docs are mentioned a lot:

[error] [client ***.***.***.***] PHP Warning: in_array() expects parameter 2 to be array, null given in /var/www/wp-content/plugins/buddypress-docs/includes/integration-groups.php on line 264

Above repeated multiple times (~20)

[error] [client ***.***.***.***] WordPress database error Lost connection to MySQL server during query for query SELECT option_value FROM wp_options WHERE option_name = 'bp-docs-enable-attachments' LIMIT 1 made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), call_user_func_array, BP_Docs->load_hook, do_action('bp_docs_load'), call_user_func_array, BP_Docs->do_integration, BP_Docs_Component->__construct, BP_Docs_Component->setup_hooks, BP_Docs_Attachments->__construct, bp_docs_enable_attachments, get_option, referer: https://***/wp-admin/post.php?post=583&action=edit

[error] [client ***.***.***.***] WordPress database error Lost connection to MySQL server during query for query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1569) ORDER BY meta_id ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/buddy-2014-01/page.php'), the_content, apply_filters('the_content'), call_user_func_array, bp_replace_the_content, apply_filters('bp_replace_the_content'), call_user_func_array, BP_Docs_Theme_Compat->single_content, bp_buffer_template_part, bp_get_template_part, bp_locate_template, load_template, require('/plugins/buddypress-docs/includes/templates/docs/single/index.php'), include('/plugins/buddypress-docs/includes/templates/docs/single/attachments.php'), bp_docs_attachment_item_markup, bp_docs_get_attachment_url, get_attached_file, get_post_meta, get_metadata, update_meta_cache, referer: https://***/wp-admin/post.php?post=583&action=edit

Above repeated multiple times

[error] [client ***.***.***.***] WordPress database error Lost connection to MySQL server during query for query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND ( wp_posts.ID NOT IN (\n\t\t\t\t\tSELECT object_id\n\t\t\t\t\tFROM wp_term_relationships\n\t\t\t\t\tWHERE term_taxonomy_id IN (39)\n\t\t\t\t) ) AND wp_posts.post_type = 'bp_doc' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/buddy-2014-01/homepage.php'), get_footer, locate_template, load_template, require_once('/themes/buddy-2014-01/footer.php'), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Recent_Posts->widget, WP_Query->__construct, WP_Query->query, WP_Query->get_posts, do_action_ref_array, call_user_func_array, bp_docs_general_access_protection, BP_Docs_Access_Query->get_doc_ids, get_posts, WP_Query->query, WP_Query->get_posts

We have a large user base (20,000+ members) but far fewer concurrent users (typically 20-50). The system running wordpress is designed for robust usage and should theoretically be taken out by one active user posting a featured image to a blog post.

I hope this helps in some way. Please let me know if we can provide any further material to help rectify the problem. It should be noted that when we activate/deactivate the plugin there is general very notable change in site responsiveness.

Good luck finding a solution, full list of plugins used is available below.

LB

Sorry for the delay in getting back to you, our IT Crowd are always very busy. This is the response I had:

It seems like multiple Apache worker processes are created when trying to set the featured image using this theme. It seems strange that on the normal theme there is no problem, so I’m bit reluctant to blame MySQL straight away as this WP installation has been live for sometime before this error started to occur.

unfortunately they did not supply any logs for me to scrutinise.

I’m going to take another look at the theme specifically to ensure that this is defiantly not the culprit, there have been a host of recent updates to a number of the plugins we are using so hopefully something will to the trick.

I’m hoping that this is not a corruption issue!

Thanks for the advice, I’ll ask and get back to you.

[NOT RESOLVED!]

Hello Steve,

Around a month ago, as you requested we posted this issue on your site, we did and heard nothing. Despite following up this post with a bump again requesting support I’ve since had no response:

https://a3rev.com/forums/topic/outlook-issues-header-style-and-some-other-changes-not-showing-in-outlook/#post-13829

This is a real issue, but without your help we are unable to determine whether it’s your plugin or something else.

This is a last ditch attempt to get any kind of support, I’m willing to provide whatever details you require so we can assist in getting this issue resolved.

I appreciate you may be busy, but at the very least some lead time
for response to any support requests on your own support forums might be an idea.

So currently, nice plugin, no support!