Can’t update any cores on any sites error included

soaringeagle
@soaringeagle
3 years ago
3,304 posts
Hey guys it’s been a long long time but I still here with several sites but none are updating now
In debug is the same on all sites
  (2021-09-17T20:02:01-04:00.0.53413000 : 67.802)-(mem: 12MB)-(pid: 5934)-(ip: 54.36.149.16)-(sid: 258a4ad1rrgp5oaneh42k3g1bc)-(url: https://www.dreadlockssite.com/spiritual/) |jrCore_db_query: /* 6.5.11b5:greentec_jam:1631923321:system:54.36.149.16:/spiritual/ */ UPDATE jr_jrcore_queue_info SET queue_depth = (queue_depth - 1) WHERE queue_name = 'jrImage_prune_cache' AND queue_depth >= 1|  (2021-09-17T20:02:01-04:00.0.53413000 : 67.802)-(mem: 12MB)-(pid: 5934)-(ip: 54.36.149.16)-(sid: 258a4ad1rrgp5oaneh42k3g1bc)-(url: https://www.dreadlockssite.com/spiritual/) mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] =>  [errno] => 2006 [error] => MySQL server has gone away [error_list] => Array ( [0] => Array ( [errno] => 2006 [sqlstate] => HY000 [error] => MySQL server has gone away )  [1] => Array ( [errno] => 2006 [sqlstate] => HY000 [error] => MySQL server has gone away )  )  [field_count] => 0 [host_info] => Localhost via UNIX socket [info] =>  [insert_id] => 0 [server_info] => 5.5.5-10.1.48-MariaDB [server_version] => 50505 [stat] =>  [sqlstate] => HY000 [protocol_version] => 10 [thread_id] => 879775 [warning_count] => 0 )



--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities

updated by @soaringeagle: 01/10/22 02:43:36AM
michael
@michael
3 years ago
7,646 posts
This looks like the important part:
[error] => MySQL server has gone away

Something is wrong with Mysql on the server, try to restart mysql.
soaringeagle
@soaringeagle
3 years ago
3,304 posts
We did it’s Maria db we restarted it and it still causes it


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
michael
@michael
3 years ago
7,646 posts
The URL in that error is this one:
https://www.dreadlockssite.com/spiritual/

Its up, I can see it.

The query thats trying to be run is this one:
UPDATE jr_jrcore_queue_info SET queue_depth = (queue_depth - 1) 
WHERE queue_name = 'jrImage_prune_cache' 
AND queue_depth >= 1

That shouldn't break Mysql, but thats what its saying: "When I try to run this query I find that there is no mysql server, its gone away."
soaringeagle
@soaringeagle
3 years ago
3,304 posts
Hmm that’s pruning the image cache let me try emptying the image cache 1st then run


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
3 years ago
3,304 posts
Just noticed this massive latency on a queue worker


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
3 years ago
3,304 posts
For the win after deleting that repair module, the update no longer showed the core, which I guess was installed
1 site down anyway. Hopefully the other sites the same


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
3 years ago
3,304 posts
Ok www.freedomswings.org has a similar but diferent issue and error
I cleared image cache saw no stuck queue workers but still have an error
 	
 (2021-09-19T02:13:54+01:00.0.89790000 : 90.035)-(mem: 26MB)-(pid: 18743)-(ip: 71.175.94.65)-(sid: u4060n451kio54e412bkrpqtdr)-(user: pete golden)-(url: https://www.freedomswings.org/marketplace/update_item/module/jrCore/id=32/__ajax=1) |jrCore_db_query: /* fwi_freedom:1632014034:pete golden:71.175.94.65:/marketplace/update_item/module/jrCore/id=32/__ajax=1 */ INSERT INTO jr_jruser_session (session_id,session_updated,session_user_id,session_user_name,session_user_group,session_profile_id,session_quota_id,session_user_ip,session_data) VALUES ('u4060n451kio54e412bkrpqtdr',UNIX_TIMESTAMP(),'1','pete golden','master','1','5','71.175.94.65','_item_id|i:1;_created|s:10:\"1473997078\";_profile_id|i:1;_updated|s:10:\"1631769477\";_user_id|i:1;profile_active|s:1:\"1\";profile_bg_image_extension|s:3:\"jpg\";profile_bg_image_name|s:22:\"194_1spread_eagle_.jpg\";profile_bg_image_size|s:6:\"345494\";profile_bg_image_time|s:10:\"1481042148\";profile_bg_image_type|s:10:\"image/jpeg\";profile_bg_tile|s:3:\"off\";profile_bio|s:0:\"\";profile_disk_usage|s:9:\"290598152\";profile_humancheck|s:0:\"\";profile_id|s:1:\"1\";profile_image_extension|s:3:\"jpg\";profile_image_height|s:4:\"3456\";profile_image_name|s:20:\"DSCN3418 (1).JPG.jpg\";profile_image_size|s:7:\"6264662\";profile_image_time|s:10:\"1477709526\";profile_image_type|s:10:\"image/jpeg\";profile_image_width|s:4:\"4608\";profile_index_page|s:1:\"0\";profile_jrAction_item_count|s:3:\"590\";profile_jrBlog_item_count|s:1:\"2\";profile_jrComment_item_count|s:2:\"54\";profile_jrCustomForm_item_count|s:1:\"1\";profile_jrEmailCourse_item_count|s:1:\"2\";profile_jrEvent_item_count|s:2:\"30\";profile_jrFile_item_count|s:1:\"5\";profile_jrFollower_approve|s:3:\"off\";profile_jrFollower_item_count|s:1:\"2\";profile_jrForum_item_count|s:2:\"16\";profile_jrGallery_item_count|s:2:\"28\";profile_jrImage_item_count|s:1:\"1\";profile_jrLike_dislike_home_item_count|s:2:\"30\";profile_jrLike_like_home_item_count|s:2:\"48\";profile_jrNewsLetter_item_count|s:1:\"1\";profile_jrPage_item_count|s:1:\"1\";profile_jrRating_home_item_count|s:2:\"27\";profile_jrRating_item_count|s:2:\"31\";profile_jrSubscribe_item_count|s:1:\"1\";profile_jrTags_item_count|s:2:\"56\";profile_jrUpimg_item_count|s:2:\"94\";profile_jrUrlScan_item_count|s:1:\"3\";profile_jrVimeo_item_count|s:1:\"4\";profile_jrYouTube_item_count|s:3:\"234\";profile_name|s:11:\"pete golden\";profile_private|s:1:\"1\";profile_quota_change_date|s:0:\"\";profile_quota_change_id|s:1:\"0\";profile_quota_id|s:1:\"5\";profile_url|s:12:\"soaringeagle\";profile_view_count|s:6:\"133403\";profile_why|s:0:\"\";quota_jrAction_allowed|s:2:\"on\";quota_jrAction_can_post|s:2:\"on\";quota_jrAction_pending|s:1:\"0\";quota_jrAction_show_add|s:2:\"on\";quota_jrAction_show_detail|s:2:\"on\";quota_jrAkismet_allowed|s:2:\"on\";quota_jrAudio_allowed|s:2:\"on\";quota_jrAudio_allowed_audio_types|s:32:\"aac,aif,flac,m4a,mp3,ogg,wav,wma\";quota_jrAudio_audio_conversions|s:2:\"on\";quota_jrAudio_audio_tag|s:2:\"on\";quota_jrAudio_conversion_bitrate|s:3:\"320\";quota_jrAudio_max_items|s:1:\"0\";quota_jrAudio_pending|s:1:\"0\";quota_jrBlog_allowed|s:2:\"on\";quota_jrBlog_max_items|s:1:\"0\";quota_jrBlog_pending|s:1:\"0\";quota_jrCharts_allowed|s:2:\"on\";quota_jrChat_allowed|s:2:\"on\";quota_jrChat_create_chats|s:2:\"on\";quota_jrChat_create_emails|s:3:\"off\";quota_jrChat_create_rooms|s:2:\"on\";quota_jrChat_file_types|s:41:\"png,jpg,jpeg,jfif,gif,zip,mp4,mp3,doc,txt\";quota_jrChat_followers_only|s:2:\"on\";quota_jrChat_max_size|s:8:\"67108864\";quota_jrCombinedVideo_allowed|s:2:\"on\";quota_jrComment_allowed|s:2:\"on\";quota_jrComment_allowed_file_types|s:28:\"png,jpg,jpeg,gif,txt,zip,pdf\";quota_jrComment_attachments|s:2:\"on\";quota_jrComment_pending|s:1:\"0\";quota_jrComment_profile_delete|s:3:\"off\";quota_jrComment_show_detail|s:2:\"on\";quota_jrCore_active_formatters|s:226:\"jrCore_format_string_bbcode,jrCore_format_string_allowed_html,jrCore_format_string_convert_at_tags,jrUrlScan_format_string,jrSmiley_format_string_smiley,jrEmbed_format_string_embed_tags,jrAction_format_string_convert_hash_tags\";quota_jrCore_allow_all_html|s:2:\"on\";quota_jrCore_allowed_tags|s:92:\"span,strong,em,a,b,u,i,p,div,br,img,h1,h2,h3,h4,pre,hr,ul,ol,li,sub,sup,table,tbody,th,tr,td\";quota_jrCore_disk|s:1:\"0\";quota_jrCore_max_upload_size|s:8:\"13631488\";quota_jrDisqus_allowed|s:2:\"on\";quota_jrDisqus_show_detail|s:2:\"on\";quota_jrEmbed_allowed|s:2:\"on\";quota_jrEvent_allowed|s:2:\"on\";quota_jrEvent_allowed_attending|s:2:\"on\";quota_jrEvent_allowed_recurring|s:3:\"off\";quota_jrEvent_max_items|s:1:\"0\";quota_jrEvent_pending|s:1:\"0\";quota_jrFile_allowed|s:2:\"on\";quota_jrFile_allowed_file_types|s:19:\"zip,doc,txt,pdf,rar\";quota_jrFile_max_items|s:1:\"0\";quota_jrFile_pending|s:1:\"2\";quota_jrFollower_share_type|s:0:\"\";quota_jrForum_allowed|s:2:\"on\";quota_jrForum_bbcode_signature|s:2:\"on\";quota_jrForum_can_post|s:2:\"on\";quota_jrForum_file_attachments|s:2:\"on\";quota_jrForum_signature|s:2:\"on\";quota_jrFoxyCart_active|s:3:\"off\";quota_jrFoxyCart_allowed|s:3:\"off\";quota_jrFoxyCart_expire_quota|s:1:\"1\";quota_jrFoxyCart_payout_percent|s:3:\"100\";quota_jrFoxyCart_show_my_files|s:2:\"on\";quota_jrFoxyCart_show_sb|s:2:\"on\";quota_jrFoxyCart_subscription_allow|s:3:\"off\";quota_jrFoxyCart_subscription_desc|s:0:\"\";quota_jrFoxyCart_subscription_length|s:2:\"1m\";quota_jrFoxyCart_subscription_price|s:4:\"0.00\";quota_jrFoxyCart_subscription_trial|s:1:\"0\";quota_jrGallery_allowed|s:2:\"on\";quota_jrGallery_gallery_group|s:2:\"on\";quota_jrGallery_gallery_order|s:2:\"on\";quota_jrGallery_max_items|s:1:\"0\";quota_jrGallery_pending|s:1:\"0\";quota_jrImage_allowed_image_types|s:16:\"png,gif,jpg,jpeg\";quota_jrImage_max_image_size|s:8:\"10485760\";quota_jrImage_watermark|s:3:\"off\";quota_jrImage_watermark_cutoff|s:2:\"80\";quota_jrImage_watermark_sale_only|s:3:\"off\";quota_jrImage_watermark_x_offset|s:2:\"-5\";quota_jrImage_watermark_y_offset|s:2:\"-5\";quota_jrInvite_allowed|s:3:\"off\";quota_jrInvite_invitee_type|s:1:\"1\";quota_jrInvite_max_items|s:1:\"0\";quota_jrInvite_pending|s:1:\"0\";quota_jrLandingPage_allowed|s:3:\"off\";quota_jrLike_allow_self_likings|s:2:\"on\";quota_jrLike_allowed|s:2:\"on\";quota_jrLike_show_detail|s:2:\"on\";quota_jrPage_allowed|s:2:\"on\";quota_jrPage_max_items|s:1:\"0\";quota_jrPage_pending|s:1:\"0\";quota_jrPayment_allowed|s:3:\"off\";quota_jrPayment_include_shipping|s:2:\"on\";quota_jrPayment_include_tax|s:2:\"on\";quota_jrPayment_payout_percent|s:3:\"100\";quota_jrPayment_show_purchases|s:2:\"on\";quota_jrPhotoAlbum_allowed|s:2:\"on\";quota_jrPhotoAlbum_max_items|s:1:\"0\";quota_jrPhotoAlbum_pending|s:1:\"0\";quota_jrPlaylist_allowed|s:2:\"on\";quota_jrPlaylist_max_items|s:1:\"0\";quota_jrPlaylist_pending|s:1:\"0\";quota_jrPoll_allowed|s:2:\"on\";quota_jrPoll_max_items|s:1:\"0\";quota_jrPoll_pending|s:1:\"0\";quota_jrPoll_voter|s:2:\"on\";quota_jrPrivateNote_allowed|s:2:\"on\";quota_jrPrivateNote_followers_only|s:2:\"on\";quota_jrProfile_admin_note|s:0:\"\";quota_jrProfile_cap_type|s:4:\"hard\";quota_jrProfile_default_privacy|s:1:\"1\";quota_jrProfile_name|s:8:\"students\";quota_jrProfile_privacy_changes|s:2:\"on\";quota_jrProfile_profile_count|s:1:\"9\";quota_jrProfile_url_changes|s:3:\"off\";quota_jrProfileTweaks_allow_background_image|s:2:\"on\";quota_jrProfileTweaks_allow_index_redirect|s:2:\"on\";quota_jrProfileTweaks_allow_logo|s:2:\"on\";quota_jrProfileTweaks_allow_skin|s:8:\"jrNingja\";quota_jrProfileTweaks_allowed|s:2:\"on\";quota_jrProfileTweaks_default_index|s:1:\"0\";quota_jrProfileTweaks_default_skin|s:8:\"jrNingja\";quota_jrRating_allow_self_ratings|s:2:\"on\";quota_jrRating_allowed|s:2:\"on\";quota_jrShareThis_allowed|s:2:\"on\";quota_jrShareThis_show_detail|s:2:\"on\";quota_jrShareThis_show_reaction|s:3:\"off\";quota_jrSmiley_allowed|s:2:\"on\";quota_jrSmiley_show_selector|s:3:\"off\";quota_jrSoundCloud_allowed|s:2:\"on\";quota_jrSoundCloud_max_items|s:1:\"0\";quota_jrSoundCloud_pending|s:1:\"0\";quota_jrTags_allowed|s:2:\"on\";quota_jrTags_own_items_only|s:3:\"off\";quota_jrTags_show_detail|s:2:\"on\";quota_jrTOS_show_tos|s:1:\"0\";quota_jrUpimg_allowed|s:2:\"on\";quota_jrUser_add_to_timeline|s:2:\"on\";quota_jrUser_allow_signups|s:3:\"off\";quota_jrUser_device_notice|s:2:\"on\";quota_jrUser_login_page|s:7:\"profile\";quota_jrUser_power_user|s:3:\"off\";quota_jrUser_power_user_max|s:1:\"2\";quota_jrUser_power_user_quotas|s:1:\"0\";quota_jrUser_signup_method|s:5:\"admin\";quota_jrUser_signup_page|s:7:\"profile\";quota_jrVideo_allowed|s:2:\"on\";quota_jrVideo_allowed_video_types|s:52:\"3g2,3gp,avi,f4v,flv,m4v,mkv,mov,mp4,mpg,ogv,webm,wmv\";quota_jrVideo_max_items|s:1:\"0\";quota_jrVideo_pending|s:1:\"0\";quota_jrVideo_video_conversions|s:2:\"on\";quota_jrVimeo_allowed|s:2:\"on\";quota_jrVimeo_max_items|s:1:\"0\";quota_jrVimeo_pending|s:1:\"0\";quota_jrYouTube_allowed|s:2:\"on\";quota_jrYouTube_channel_sync|s:2:\"on\";quota_jrYouTube_max_items|s:1:\"0\";quota_jrYouTube_pending|s:1:\"0\";quota_jrYouTube_youtube_search|s:2:\"on\";profile_jrCombinedVideo_item_count|i:238;user_active|s:1:\"1\";user_active_room_id|i:1;user_campaign_total_sent|s:1:\"1\";user_chat_message_sound|s:2:\"on\";user_chat_notifications|s:2:\"on\";user_chat_online_status|s:4:\"auto\";user_chat_state|s:6:\"closed\";user_chat_width|s:3:\"310\";user_email|s:26:\"iriesoaringeagle@gmail.com\";user_group|s:6:\"master\";user_image_extension|s:3:\"jpg\";user_image_height|s:4:\"3456\";user_image_name|s:14:\"user_image.jpg\";user_image_size|s:7:\"6264662\";user_image_time|s:10:\"1477709526\";user_image_type|s:10:\"image/jpeg\";user_image_width|s:4:\"4608\";user_jrAction_item_count|s:3:\"607\";user_jrBlog_item_count|s:1:\"2\";user_jrComment_item_count|s:2:\"54\";user_jrCustomForm_item_count|s:1:\"1\";user_jrEmailCourse_item_count|s:1:\"2\";user_jrEvent_item_count|s:2:\"30\";user_jrFile_item_count|s:1:\"5\";user_jrFollower_share|s:2:\"on\";user_jrForum_item_count|s:2:\"16\";user_jrForum_settings|s:277:\"{\"enable_signature\":\"on\",\"signature\":\"soaringeagle\\r\\nhead dreadhead at [url=http:\\/\\/www.dreadlockssite.com]dreadlocks site[\\/url]\\r\\nglider pilot student with [url=http:\\/\\/www.freedomswings.org]freedoms wings international soaring for people with disabilities [\\/url] \\r\\n\"}\";user_jrGallery_item_count|s:4:\"3051\";user_jrGoogleAnalytics_cid|s:36:\"a249fa69-cc01-4ca0-84f4-7dd3d7296d3f\";user_jrImage_item_count|s:1:\"3\";user_jrLike_like_count|s:2:\"28\";user_jrNewsLetter_item_count|s:1:\"1\";user_jrPage_item_count|s:1:\"1\";user_jrRating_item_count|s:2:\"31\";user_jrSmiley_item_count|s:1:\"8\";user_jrSubscribe_item_count|s:1:\"1\";user_jrTags_item_count|s:2:\"66\";user_jrTips_enabled|s:3:\"off\";user_jrUpimg_item_count|s:3:\"125\";user_jrUrlScan_item_count|s:1:\"7\";user_jrVimeo_item_count|s:1:\"4\";user_jrYouTube_item_count|s:3:\"302\";user_language|s:5:\"en-US\";user_last_login|s:10:\"1631974087\";user_name|s:11:\"pete golden\";user_password|s:60:\"$2a$12$zjo.JN3EmWXwBz6gRQepAua2nasidVKb3Mncrl9VSJ2Dbjzrz/5ti\";user_validate|s:32:\"72d46366479db5a5d3a3e7346bc4f847\";user_validated|s:1:\"1\";user_why|s:0:\"\";user_linked_profile_ids|s:5:\"1,3,4\";profile_created|s:10:\"1473997078\";profile_updated|s:10:\"1631769477\";user_active_profile_id|i:1;is_logged_in|s:3:\"yes\";search_token|s:32:\"9d44037c8748992d7cd1f208edc259a3\";session_updated|i:1632013941;jrcore_form_notices|a:0:{}JRMARKET_RELEASE_SYSTEM|s:225:\"{\"system_id\":\"1\",\"system_name\":\"Jamroom Network\",\"system_url\":\"http:\\/\\/www.jamroom.net\",\"system_email\":\"iriesoaringeagle@gmail.com\",\"system_code\":\"da3d540859188e1f1c35acc86b5b8482\",\"system_active\":\"on\",\"system_default\":\"on\"}\";jrcore_url_history|a:1:{s:47:\"https://www.freedomswings.org/image/cache_reset\";s:55:\"https://www.freedomswings.org/marketplace/system_update\";}jrcore_form_notice_last_token|s:32:\"62b770af9d523bdc280c6d056f37b4ef\";') ON DUPLICATE KEY UPDATE session_updated = UNIX_TIMESTAMP(),session_user_id = '1',session_user_name = 'pete golden',session_user_group = 'master', session_profile_id = '1',session_quota_id = '5',session_user_ip = '71.175.94.65',session_sync = 0,session_data = VALUES(session_data)|  (2021-09-19T02:13:54+01:00.0.89790000 : 90.035)-(mem: 26MB)-(pid: 18743)-(ip: 71.175.94.65)-(sid: u4060n451kio54e412bkrpqtdr)-(user: pete golden)-(url: https://www.freedomswings.org/marketplace/update_item/module/jrCore/id=32/__ajax=1) mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] =>  [errno] => 2006 [error] => MySQL server has gone away [error_list] => Array ( [0] => Array ( [errno] => 2006 [sqlstate] => HY000 [error] => MySQL server has gone away )  )  [field_count] => 17 [host_info] => Localhost via UNIX socket [info] =>  [insert_id] => 0 [server_info] => 5.5.5-10.1.48-MariaDB [server_version] => 100148 [stat] =>  [sqlstate] => HY000 [protocol_version] => 10 [thread_id] => 1263826 [warning_count] => 0 )



--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
michael
@michael
3 years ago
7,646 posts
Its the same error:
[error] => MySQL server has gone away

Maybe increase mysql's resources?
soaringeagle
@soaringeagle
3 years ago
3,304 posts
Ok wil try it doues have a huge database but i have a ton of ram mistly for db


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
alt=
@luis789
3 years ago
88 posts
I'm having the same issue on my site. The Queue Viewer will will just hang. In increased MySQL, the sever site started working a little faster but the error did not get fixed.
I tried to run integrity check it hangs for ever on "jr_jraction_hash_tag". I tried to open the Timeline module to disabled it, but, it just hangs as well. I even updated to the latest beta version 6.5.11b7 the integrity check is still hanging.
I run out of options.
michael
@michael
3 years ago
7,646 posts
@luis789 if you're not getting
[error] => MySQL server has gone away
in your error logs its not the same issue. Open another thread with the contents of your error log and we can look at what your issue is.

Tags