emergency after core update mysql uses 100% cpu

@soaringeagle
7 years ago
3,304 posts

i cant be absolutely certain its the cause but repairing tables in phpmyadmin get a gateway timeout
running repair.php gets connection timeout
(renaming the filer in plesk failed with mv command failure had to edit in nano save with new filename)

ran

myisamchk -r /var/lib/mysql/greentec_jam/*

it said it fixed a bunch of errors
still can't run repair.php (if integrity checks a must after core updates like it was upgrading to 6.0 can't it be enforced to run before any other updates?)
i'm scared to update my other sites core now

--
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: 12/01/17 10:07:30PM

@brian
7 years ago
10,148 posts

If you have checked the "repair modules" option, the DB tables are all upgraded to InnoDB - this could take a bit on the server if you have a very large amount of data - you want to just let it run - don't jump in there and restart stuff. You can do:

SHOW PROCESSLIST;

when logged in to MySQL as the root user and see what queries are being run - make sure any ALTER TABLE queries are complete before you shutdown or restart the server.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@soaringeagle
7 years ago
3,304 posts

cant even get into MySQL
for some weird reason it wont let me login i even changed root password to be certain i could but its still not letting me in

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

@soaringeagle
7 years ago
3,304 posts

OK was able to login as that database user
not root only as the user
heres what the procvesslist looks like

| 13822 | greentec_jam | localhost | greentec_jam | Query   |   65 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'jen-hookah'  |    0.000 |
| 13823 | greentec_jam | localhost | greentec_jam | Query   |   62 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'dreadlocks-f |    0.000 |
| 13826 | greentec_jam | localhost | greentec_jam | Query   |   42 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 85         |    0.000 |
| 13827 | greentec_jam | localhost | greentec_jam | Query   |   60 | Waiting for table level lock | SELECT `_item_id` AS i, `value` AS v FROM jr_jrprofile_item_key WHERE `key` = 'profile_private' AND  |    0.000 |
| 13828 | greentec_jam | localhost | greentec_jam | Query   |   60 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 85         |    0.000 |
| 13829 | greentec_jam | localhost | greentec_jam | Query   |   58 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'heather-b' L |    0.000 |
| 13830 | greentec_jam | localhost | greentec_jam | Query   |   42 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 6228       |    0.000 |
| 13833 | greentec_jam | localhost | greentec_jam | Query   |   42 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 7800       |    0.000 |
| 13836 | greentec_jam | localhost | greentec_jam | Query   |   43 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'heather' LIM |    0.000 |
| 13837 | greentec_jam | localhost | greentec_jam | Query   |   43 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'dreadlocks-f |    0.000 |
| 13839 | greentec_jam | localhost | greentec_jam | Query   |   42 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'britt' LIMIT |    0.000 |
| 13843 | greentec_jam | localhost | greentec_jam | Query   |   42 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'soaring-eagl |    0.000 |
| 13845 | greentec_jam | localhost | greentec_jam | Query   |   42 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'jen-hookah'  |    0.000 |
| 13852 | greentec_jam | localhost | greentec_jam | Query   |   42 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 5942       |    0.000 |
| 13855 | greentec_jam | localhost | greentec_jam | Query   |   42 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 85         |    0.000 |
| 13891 | greentec_jam | localhost | greentec_jam | Query   |   41 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'heather-b' L |    0.000 |
| 13892 | greentec_jam | localhost | greentec_jam | Query   |   41 | Waiting for table level lock | SELECT `_item_id` AS i, `value` AS v FROM jr_jrprofile_item_key WHERE `key` = 'profile_private' AND  |    0.000 |
| 13898 | greentec_jam | localhost | greentec_jam | Query   |   32 | Waiting for table level lock | SELECT `key` FROM jr_jrprofile_item_key GROUP BY `key` ORDER BY `key` ASC                            |    0.000 |
| 13904 | greentec_jam | localhost | greentec_jam | Query   |   30 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 14141      |    0.000 |
| 13906 | greentec_jam | localhost | greentec_jam | Query   |   29 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'heather' LIM |    0.000 |
| 13909 | greentec_jam | localhost | greentec_jam | Query   |   27 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'photo' LIMIT |    0.000 |
| 13910 | greentec_jam | localhost | greentec_jam | Query   |   27 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'britt' LIMIT |    0.000 |
| 13911 | greentec_jam | localhost | greentec_jam | Query   |   27 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'taye' LIMIT  |    0.000 |
| 13912 | greentec_jam | localhost | greentec_jam | Query   |   26 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'ben' LIMIT 1 |    0.000 |
| 13913 | greentec_jam | localhost | greentec_jam | Query   |   25 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'soaring-eagl |    0.000 |
| 13919 | greentec_jam | localhost | greentec_jam | Query   |   23 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 85         |    0.000 |
| 13920 | greentec_jam | localhost | NULL         | Query   |    0 | init                         | SHOW PROCESSLIST                                                                                     |    0.000 |
| 13925 | greentec_jam | localhost | greentec_jam | Query   |   13 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'andrea2' LIM |    0.000 |
| 13929 | greentec_jam | localhost | greentec_jam | Query   |   10 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 14141      |    0.000 |

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

@brian
7 years ago
10,148 posts

All those processes are "Waiting for table level lock", which means the table has been locked. I'm guessing you are running a repair from the command line?

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@soaringeagle
7 years ago
3,304 posts

i am try ing to repair from phpmyadmin but in small chunks (1 oir 2 modules at a time) so thry complete 1 threw a serious error comments
oh wait yes in edge i was trying to run the repair.php

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

@soaringeagle
7 years ago
3,304 posts

BACKED OUT OF THAT AND NOW ONLY

| 14888 | greentec_jam | localhost | greentec_jam | Query   |  725 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 14904 | greentec_jam | localhost | greentec_jam | Query   |  723 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 17197 | greentec_jam | localhost | greentec_jam | Query   |  572 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 17961 | greentec_jam | localhost | greentec_jam | Query   |  541 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 21316 | greentec_jam | localhost | greentec_jam | Query   |  405 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 22171 | greentec_jam | localhost | greentec_jam | Query   |  357 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 22410 | greentec_jam | localhost | greentec_jam | Query   |  344 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 23141 | greentec_jam | localhost | greentec_jam | Query   |  294 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 23318 | greentec_jam | localhost | greentec_jam | Query   |  283 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 24811 | greentec_jam | localhost | greentec_jam | Query   |  192 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 25377 | greentec_jam | localhost | greentec_jam | Query   |   74 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 25745 | greentec_jam | localhost | greentec_jam | Query   |   16 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 25838 | greentec_jam | localhost | greentec_jam | Query   |    6 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 25917 | greentec_jam | localhost | greentec_jam | Sleep   |    0 |                      | NULL

rams creeping towards 100%
im going to try opening several putty sessions login to mysqwl as several users (any i suspect might be the issue) check all processes but i am having issues repairing the dreadlockssite 1 that's wjhy i think that's the 1

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

@brian
7 years ago
10,148 posts

I think you've got things in a bit of a mess - here's what I would do:

1) Put your site in maintenance mode so you don't have people hitting pages and lists on your site
2) Make sure you are not running a repair from the browser (repair.php) OR the command line
3) restart MySQL
4) log in to your site and do an Integrity Check with repair modules checked. This could take a bit to run if you have very large tables - i.e. give it 30 minutes if needed
5) when finished exit maintenance mode

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
updated by @brian: 08/30/17 10:27:50AM

@soaringeagle
7 years ago
3,304 posts

update.. sites responding theres 24 queue entries im doing a full integrity check all options if i gotta go through the queue and reset all till the core 1 is 1st i will but cpu and ram are still dangerously high..

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

@brian
7 years ago
10,148 posts

Pause the queues then - that won't hurt anything.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@soaringeagle
7 years ago
3,304 posts

i paused all queues and still get 72 rows of this and think this is using up asll the cpus

| 33087 | greentec_jam | localhost | NULL         | Query   |    0 | init                 | SHOW PROCESSLIST                                                                                     |    0.000 |
| 34408 | greentec_jam | localhost | greentec_jam | Query   | 5405 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 34489 | greentec_jam | localhost | greentec_jam | Query   | 5398 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 35284 | greentec_jam | localhost | greentec_jam | Query   | 5308 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 35749 | greentec_jam | localhost | greentec_jam | Query   | 5262 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 36338 | greentec_jam | localhost | greentec_jam | Query   | 5203 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 37627 | greentec_jam | localhost | greentec_jam | Query   | 5079 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 38081 | greentec_jam | localhost | greentec_jam | Query   | 5045 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 38273 | greentec_jam | localhost | greentec_jam | Query   | 5024 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 38297 | greentec_jam | localhost | greentec_jam | Query   | 5007 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 38328 | greentec_jam | localhost | greentec_jam | Query   | 5006 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 38731 | greentec_jam | localhost | greentec_jam | Query   | 4949 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 39149 | greentec_jam | localhost | greentec_jam | Query   | 4895 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 39201 | greentec_jam | localhost | greentec_jam | Query   | 4889 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 39262 | greentec_jam | localhost | greentec_jam | Query   | 4886 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 39616 | greentec_jam | localhost | greentec_jam | Query   | 4838 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 39819 | greentec_jam | localhost | greentec_jam | Query   | 4811 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 39999 | greentec_jam | localhost | greentec_jam | Query   | 4784 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 40090 | greentec_jam | localhost | greentec_jam | Query   | 4773 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 40178 | greentec_jam | localhost | greentec_jam | Query   | 4761 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 40634 | greentec_jam | localhost | greentec_jam | Query   | 4697 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 40694 | greentec_jam | localhost | greentec_jam | Query   | 4692 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 41000 | greentec_jam | localhost | greentec_jam | Query   | 4659 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 41615 | greentec_jam | localhost | greentec_jam | Query   | 4577 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 42142 | greentec_jam | localhost | greentec_jam | Query   | 4514 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 42822 | greentec_jam | localhost | greentec_jam | Query   | 4438 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 43038 | greentec_jam | localhost | greentec_jam | Query   | 4391 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 43209 | greentec_jam | localhost | greentec_jam | Query   | 4336 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 43623 | greentec_jam | localhost | greentec_jam | Query   | 4288 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 43666 | greentec_jam | localhost | greentec_jam | Query   | 4283 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 43871 | greentec_jam | localhost | greentec_jam | Query   | 4261 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 44195 | greentec_jam | localhost | greentec_jam | Query   | 4225 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 44202 | greentec_jam | localhost | greentec_jam | Query   | 4224 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 44345 | greentec_jam | localhost | greentec_jam | Query   | 4186 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 44706 | greentec_jam | localhost | greentec_jam | Query   | 4114 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 44937 | greentec_jam | localhost | greentec_jam | Query   | 4087 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 45010 | greentec_jam | localhost | greentec_jam | Query   | 4076 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 45437 | greentec_jam | localhost | greentec_jam | Query   | 4016 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 45514 | greentec_jam | localhost | greentec_jam | Query   | 4003 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 45663 | greentec_jam | localhost | greentec_jam | Query   | 3973 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 45754 | greentec_jam | localhost | greentec_jam | Query   | 3960 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 46422 | greentec_jam | localhost | greentec_jam | Query   | 3864 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 46490 | greentec_jam | localhost | greentec_jam | Query   | 3854 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 46527 | greentec_jam | localhost | greentec_jam | Query   | 3847 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 47197 | greentec_jam | localhost | greentec_jam | Query   | 3708 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 47895 | greentec_jam | localhost | greentec_jam | Query   | 3595 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 47958 | greentec_jam | localhost | greentec_jam | Query   | 3564 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 48008 | greentec_jam | localhost | greentec_jam | Query   | 3558 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 48135 | greentec_jam | localhost | greentec_jam | Query   | 3540 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 48664 | greentec_jam | localhost | greentec_jam | Query   | 3476 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 49041 | greentec_jam | localhost | greentec_jam | Query   | 3421 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
+-------+--------------+-----------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+----------+

thought it wasd from the integrity check stopping at the repair jr gallery item key (i think or item)

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

@brian
7 years ago
10,148 posts

Like I posted earlier - you need to restart your MySQL server so you kill those processes. See my list above and follow it.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@soaringeagle
7 years ago
3,304 posts

since that was stuck in the processlist.. without queues or repairs (and site in maintenance mode) ran badblocks found 10 on 1st drive scanned
that and the issue having restarting MySQL etc the place i collocate at is going to login and try to straighten it out... good thing a neighbour runs something like nearby geek or something and suggested might be a drive issue... which now totally makes sense...cpu prying to access data it cant
i dunno though since ram keeps climbing too
was getting too manmy connections like a dod attack

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

@soaringeagle
7 years ago
3,304 posts

i get this when i try

 service mysql stop
cat: /var/lib/mysql//server.dreadlockssite.com.pid: Permission denied
 ERROR! MySQL server process # is not running!
rm: remove write-protected regular file `/var/lib/mysql//server.dreadlockssite.com.pid'?

my instints to not rem,ove it?

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

@soaringeagle
7 years ago
3,304 posts

btw it absolutely is running despite saying its not
i'll see what the colocation gyuy can do then if i have to reboot and do integhrity check.. etc at least the ram will be cleared out for sa good 30 minutes or so

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

@soaringeagle
7 years ago
3,304 posts

i don't get this..

service mysql status
/etc/init.d/mysql: line 383: /var/lib/mysql//server.dreadlockssite.com.pid: Permission denied
 ERROR! MySQL is not running, but PID file exists

MySQL is running im logged in seeing the processlisytt and its using all the cpu furthermore cant restart it cause it cant delete that file?

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

@soaringeagle
7 years ago
3,304 posts

ok this is weird .. i dunno why it worked (shouldn't have) edited that pid added a . before the pid number ... and get this saved it as a diferent name (added 1 after pid so .pid1 so there were 2 files) the edited file only had that . the original was unchanged.. get MySQL finaly restarted normally

that shouldn't matter but it worked..weirdness

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

@michael
7 years ago
7,715 posts

maybe this:
https://stackoverflow.com/questions/24831119/error-mysqld-dead-but-pid-file-exists#26440652
--edit--

 cd /var/run/mysqld
  rm -f mysqld.pid

updated by @michael: 08/30/17 04:14:11PM

@michael
7 years ago
7,715 posts

well done.

@soaringeagle
7 years ago
3,304 posts

i noticed improvements at least cosmetically in the integrity check
it seems to aslways get to jr gallery item key.. and stop there
but in processes i see alot of 1st waiting for table to lock then eventualy copying toi temp table all related to gallery
is it still running after an hour on that table? will the new integrity check alert you if it gets stuck
theres 1 mysql process using 500+% cpu that says its been running 7 hours
(in htop)

if this keeps up does it make sense to restart mysql go into phpmyadmin (instead of integrity check) and select only that table and repair//

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

@michael
7 years ago
7,715 posts

sounds like a good idea to me. unless your site is HUGE anything more than 5 min for the integrity check would have me thinking its crashed.

@soaringeagle
7 years ago
3,304 posts

its pretty huge
but images a severeal hundred thousand but gallery probly under 100,000

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

@soaringeagle
7 years ago
3,304 posts

underr rows it says -1,116,559 i assume its not a negative number so could it be 11 million? i see that in others that dont fit in the collumn

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

@michael
7 years ago
7,715 posts

yep, 11 million is huge, it will take a while.

@soaringeagle
7 years ago
3,304 posts

i keep getting a 304 gateway timeout in phpomyadmin
i read that might be caused by my isp bloicking requestsd that take too long/

its absolutely something in the gallery the processlist fills up with 1st waiting to lock then these

|  158 | greentec_jam | localhost | greentec_jam | Query   |  938 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
|  160 | greentec_jam | localhost | greentec_jam | Query   |  935 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 1013 | greentec_jam | localhost | greentec_jam | Query   |  865 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 2961 | greentec_jam | localhost | greentec_jam | Query   |  703 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 3071 | greentec_jam | localhost | greentec_jam | Query   |  684 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 3162 | greentec_jam | localhost | greentec_jam | Query   |  672 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 3173 | greentec_jam | localhost | greentec_jam | Query   |  669 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 3227 | greentec_jam | localhost | greentec_jam | Query   |  664 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 3743 | greentec_jam | localhost | greentec_jam | Query   |  590 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 4012 | greentec_jam | localhost | greentec_jam | Query   |  554 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 4140 | greentec_jam | localhost | greentec_jam | Query   |  544 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 4653 | greentec_jam | localhost | greentec_jam | Query   |  508 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 5359 | greentec_jam | localhost | greentec_jam | Query   |  453 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 5448 | greentec_jam | localhost | greentec_jam | Query   |  443 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 5879 | greentec_jam | localhost | greentec_jam | Query   |  370 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 6252 | greentec_jam | localhost | greentec_jam | Query   |  294 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 6293 | greentec_jam | localhost | greentec_jam | Query   |  283 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 6616 | greentec_jam | localhost | greentec_jam | Query   |  225 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 6724 | greentec_jam | localhost | greentec_jam | Query   |  200 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 6747 | greentec_jam | localhost | NULL         | Query   |    0 | init                 | SHOW PROCESSLIST                                                                                     |    0.000 |
| 7312 | greentec_jam | localhost | greentec_jam | Query   |   46 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 7459 | greentec_jam | localhost | greentec_jam | Query   |   16 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
+------+--------------+-----------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+----------+

even if i do nothing after restarting MySQL they stasart filling up till i get too many connections
had 160 some rows at times

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

@soaringeagle
7 years ago
3,304 posts

really feel stupid now (i think) seems theres some new required tools and such..required modules
i think not having them is causing all the issues
when were they added

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

@soaringeagle
7 years ago
3,304 posts

nope installed that got a green board on system check, sitemap crawler wont crawl at all 0-4 pages maybe 1 image and then get server commited a protocol violation section responcestatus
and back to pages not loading
evrerytime i think i got it figured out it takes a step backwards again

--
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: 08/30/17 11:26:37PM

@michael
7 years ago
7,715 posts

"System Tools" is a new module that needs to be installed.

doing a search for "server committed a protocol violation section response status" returns a lot of results, but they're all for a windows server.

@soaringeagle
7 years ago
3,304 posts

srry responcestatuslist

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

@soaringeagle
7 years ago
3,304 posts

but somehow got beyond that now front page (only 1 i know of) times out maxing cpu
and now the sitebuilder module page in acp comes up blank

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

@soaringeagle
7 years ago
3,304 posts

oh no crap dashboard works clicking acp get a 500 error..
all i did was re-upgrade sb
acp and sb goo blank instantly or give a 500 error
front page times out or gives a too many connections

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

@soaringeagle
7 years ago
3,304 posts

don't understand this at all
going throuigh the modules list
image support- blank page
graphs support- blsank
integrity check works
wait.. i think its mostly the info pages that don't...
let me keep investigating
it seemed ttotaly random like 1 worked the next didn't...
but might be only the info pages
will update when i confirm the patern

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

@soaringeagle
7 years ago
3,304 posts

is thiss any help at all

2017-08-31T03:52:00-04:00.0.21364700 : 249.734)-(mem: 2MB)-(pid: 7398)-(ip: 71.225.6.155)-(user: !!emoji!!16!!emoji!! soaring eagle ॐ)-(uri: GET /)
Array
(
[error] => Query Error: Server shutdown in progress
[_post] => Array
(
[_uri] => /
)

[query] => SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AND a.`value` > 0
AND a.`_profile_id` IN (SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_active' AND `value` = '1') 
ORDER BY RAND() 
LIMIT 6 
)

(2017-08-31T03:52:00-04:00.0.21513200 : 184.937)-(mem: 2MB)-(pid: 7444)-(ip: 71.225.6.155)-(user: !!emoji!!16!!emoji!! soaring eagle ॐ)-(uri: GET /)
Array
(
[error] => Query Error: Server shutdown in progress
[_post] => Array
(
[_uri] => /
)

[query] => SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AND a.`value` > 0
AND a.`_profile_id` IN (SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_active' AND `value` = '1') 
ORDER BY RAND() 
LIMIT 6 
)

(2017-08-31T03:52:00-04:00.0.21591500 : 138.629)-(mem: 2MB)-(pid: 7445)-(ip: 71.225.6.155)-(user: !!emoji!!16!!emoji!! soaring eagle ॐ)-(uri: GET /)
Array
(
[error] => Query Error: Server shutdown in progress
[_post] => Array
(
[_uri] => /
)

[query] => SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AND a.`value` > 0
AND a.`_profile_id` IN (SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_active' AND `value` = '1') 
ORDER BY RAND() 
LIMIT 6 
)

(2017-08-31T03:52:00-04:00.0.21675200 : 252.91)-(mem: 2MB)-(pid: 7397)-(ip: 71.225.6.155)-(user: !!emoji!!16!!emoji!! soaring eagle ॐ)-(uri: GET /)
Array
(
[error] => Query Error: Server shutdown in progress
[_post] => Array
(
[_uri] => /
)

[query] => SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AND a.`value` > 0
AND a.`_profile_id` IN (SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_active' AND `value` = '1') 
ORDER BY RAND() 
LIMIT 6 
)

(2017-08-31T03:52:00-04:00.0.24239200 : 258.314)-(mem: 6MB)-(pid: 7401)-(ip: 96.39.203.162)-(uri: GET /)
Array
(
[error] => Query Error: Server shutdown in progress
[_post] => Array
(
[_uri] => /
)

[query] => SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AND a.`value` > 0
AND a.`_profile_id` NOT IN(212,354,12446,14384,14974)
AND a.`_profile_id` NOT IN(1081,1374,1414,1489,2225,2312,2336,2419,2699,2803,3091,3093,3938,3959,5172,5225,5626,6523,6741,6743,7452,7802,7845,8238,8343,8424,8664,8820,8852,9233,9667,9751,9865,10202,10860,10922,11183,11529,11848,12128,12182,12488,12516,13150,13167,13483,13589,13779,13858,13861,13879,13885,13930,13942,13973,13979,13980,14027,14094,14114,14146,14152,14161,14202,14240,14251,14275,14372,14377,14392,14524,14579,14647,14699,14715,14727,14767,14800,14829,14845,212,354,12446,14384,14974)
AND a.`_profile_id` IN (SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_active' AND `value` = '1') 
ORDER BY RAND() 
LIMIT 6 
)

its related to the front page images that rotate in the widget
that was 1 of my suspicions
(heads killin me but not givin up yet)

also got this

[31-Aug-2017 04:02:41 America/New_York] PHP Fatal error: Cannot redeclare jrSiteBuilder_daily_maintenance_listener() (previously declared in /var/www/vhosts/dreadlockssite.com/httpdocs/modules/jrSiteBuilder-release-2.1.1/include.php:1654) in /var/www/vhosts/dreadlockssite.com/httpdocs/modules/jrSiteBuilder-release-2.0.3/include.php on line 1631 [18]

but might have beren between down and upgrade attempts

--
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: 08/31/17 02:17:25AM

@soaringeagle
7 years ago
3,304 posts

made some 'progress'
weird progress
www.dread;lockssitecom doesn't load
www.dreadlockssite..com/index either
but www.dreadlockssite.com/indexc/edit lloads a non sb version with the sb button but that bgrings up a blank overlay with no layout options
restoringbacked up pages for index is no help

i am absolutely 100%% positive it is those images in the widget that cycle through 6 of them randomly

everything points to that now (the blank pages were screwed up symlinks i removed em all..which uninstalkled sb for all practical purposes i reinstalled it integrity check..got everything back but that front page

how can i get at it and remove that image widget..or can you release a fix asap

wait if they were uploaded to that widget they aren't actualy handled by jrgallery are they...

damn just when i thought it all made sense... unless they are hanled by jrgallery then that's got to be it
in fact gonna build a test page and see

https://www.dreadlockssite.com/testme/

wtf that worked
besides the images all there iss is text widgets lists and forums of activity feed and tag cloud

any way to edit widgets out from the db/

--
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: 08/31/17 03:11:01AM

@michael
7 years ago
7,715 posts

this one:

 Query Error: Server shutdown in progress

seems like shutdown is requested, then something else trys to use the server. happened at a reboot maybe.

this one:

....PHP Fatal error: Cannot redeclare jrSiteBuilder_daily_maintenance_listener() (previously declared in...

is saying that your symlinks aren't working and that all of the versions of the modules are being included.

Easiest way to fix that is to only have 1 version of each module. so rename the most recent version back to its base url and delete the old ones
jrSiteBuilder-release-2.1.1
back to
jrSiteBuilder

and delete any -release-x.x.x

@soaringeagle
7 years ago
3,304 posts

i fixed that somehow a simlink had 2 of the old version a d 1 new
i couldn't find that skin last night
yea ninja isn't in the marketplace and no download link either...why

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

@soaringeagle
7 years ago
3,304 posts

bought it uploaded and extracted its still not showing in my installed skins nor in marketplace

odd only way toi find and activate it ws development tools and clone to new skin

--
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: 08/31/17 07:15:51AM

@soaringeagle
7 years ago
3,304 posts

that's not it either
front pager still wont load even with unmodified elasstic

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

@soaringeagle
7 years ago
3,304 posts

can i delete index and then restore from a backup?
i think theres got to be some incompatability with a list call or something though..

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

@soaringeagle
7 years ago
3,304 posts

this is what i get when i click page builder on index/edit or index/repaitr or index?repair
just index wont load
in any skin
something in the core must have changed
my cache limiter code i dunno...i cant access the page at all to try disabling widgets

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

@douglas
7 years ago
2,790 posts

In the directory you have Jamroom installed, make sure to rename the repair.php.html to repair.php and then call that up in your browser.

yourwebsite.com/repair.php

Hope this helps!

--

Douglas Hackney
Jamroom Team - Designer/Developer/Support
FAQ-Docs-Help Videos

@soaringeagle
7 years ago
3,304 posts

its already repair ive done it b4 (at 1st it wouldn't run) ill put it in maintenance restart MySQL then run

again
i hope this helps and i appreciate that even though i worked on it 22 of the last 24 hours (had to nap) you guys always been there

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

@soaringeagle
7 years ago
3,304 posts

repair ran
https://www.dreadlockssite.com/
wont load
https://www.dreadlockssite.com/index?repair
will but a non sb built page but with the sb button.. but the sb button doesn't bring up the page editor

ps tried that from beta version that had a way to go straight into the edit mode with widgets collapsed
at least i found adding anything even another /directory
got the non sb page to load

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

@soaringeagle
7 years ago
3,304 posts

in sb page browser
1png
the layours there properly
2 and 3 they are in backups
but is that widget content too or only the layout
something wiuth the front page is just not processing watch it in developer tools and itsnot getting anythiing

--
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: 08/31/17 08:33:02AM

@douglas
7 years ago
2,790 posts

I don't think this:

https://www.dreadlockssite.com/index?repair

is a legit URL, I believe it is this:

https://www.dreadlockssite.com/repair.php

Or have you done that already?

Hope this helps!

--

Douglas Hackney
Jamroom Team - Designer/Developer/Support
FAQ-Docs-Help Videos

@soaringeagle
7 years ago
3,304 posts

i did the repair
as i said
i can only load index by appending anything onto it /edit ?repair (from beta i just was trying everything desprerately)
?whatever or /whatever after index will at least load the non sb page
its something in the new sb that's not loading something properly..or the new core

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

@soaringeagle
7 years ago
3,304 posts

tailing every log i can think of not seeing anything but the errors i posted above from access devbug and error logs in core
and then theres a whole lkotta this in the db

MariaDB [(none)]> SHOW PROCESSLIST;\
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    34034
Current database: *** NONE ***

+-------+--------------+-----------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+----------+
| Id    | User         | Host      | db           | Command | Time | State                | Info                                                                                                 | Progress |
+-------+--------------+-----------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+----------+
|   359 | greentec_jam | localhost | greentec_jam | Query   | 3393 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
|   501 | greentec_jam | localhost | greentec_jam | Query   | 3378 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
|  1275 | greentec_jam | localhost | greentec_jam | Query   | 3274 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
|  2291 | greentec_jam | localhost | greentec_jam | Query   | 3153 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
|  3778 | greentec_jam | localhost | greentec_jam | Query   | 3042 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
|  3782 | greentec_jam | localhost | greentec_jam | Query   | 3042 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
|  5205 | greentec_jam | localhost | greentec_jam | Query   | 2921 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
|  5221 | greentec_jam | localhost | greentec_jam | Query   | 2920 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
|  6920 | greentec_jam | localhost | greentec_jam | Query   | 2800 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
|  6952 | greentec_jam | localhost | greentec_jam | Query   | 2798 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
|  8256 | greentec_jam | localhost | greentec_jam | Query   | 2679 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
|  8288 | greentec_jam | localhost | greentec_jam | Query   | 2677 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
|  9528 | greentec_jam | localhost | greentec_jam | Query   | 2558 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
|  9556 | greentec_jam | localhost | greentec_jam | Query   | 2556 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 11027 | greentec_jam | localhost | greentec_jam | Query   | 2437 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 11045 | greentec_jam | localhost | greentec_jam | Query   | 2436 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 12320 | greentec_jam | localhost | greentec_jam | Query   | 2342 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 12553 | greentec_jam | localhost | greentec_jam | Query   | 2316 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 13568 | greentec_jam | localhost | greentec_jam | Query   | 2221 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 14947 | greentec_jam | localhost | greentec_jam | Query   | 2099 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 15526 | greentec_jam | localhost | greentec_jam | Query   | 2028 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 15564 | greentec_jam | localhost | greentec_jam | Query   | 2023 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 15730 | greentec_jam | localhost | greentec_jam | Query   | 2013 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 15988 | greentec_jam | localhost | greentec_jam | Query   | 1978 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 17049 | greentec_jam | localhost | greentec_jam | Query   | 1857 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 17739 | greentec_jam | localhost | greentec_jam | Query   | 1781 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 18114 | greentec_jam | localhost | greentec_jam | Query   | 1732 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 22952 | greentec_jam | localhost | greentec_jam | Query   | 1216 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 23697 | greentec_jam | localhost | greentec_jam | Query   | 1145 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 24996 | greentec_jam | localhost | greentec_jam | Query   | 1023 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 25159 | greentec_jam | localhost | greentec_jam | Query   | 1004 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 26405 | greentec_jam | localhost | greentec_jam | Query   |  883 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 27493 | greentec_jam | localhost | greentec_jam | Query   |  762 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 28235 | greentec_jam | localhost | greentec_jam | Query   |  676 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 29105 | greentec_jam | localhost | greentec_jam | Query   |  554 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 29723 | greentec_jam | localhost | greentec_jam | Query   |  496 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 30270 | greentec_jam | localhost | greentec_jam | Query   |  432 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 30279 | greentec_jam | localhost | greentec_jam | Query   |  432 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 30469 | greentec_jam | localhost | greentec_jam | Query   |  413 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 31098 | greentec_jam | localhost | greentec_jam | Query   |  341 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 31332 | greentec_jam | localhost | greentec_jam | Query   |  311 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 32501 | greentec_jam | localhost | greentec_jam | Query   |  189 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 32891 | greentec_jam | localhost | greentec_jam | Query   |  143 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 32930 | greentec_jam | localhost | greentec_jam | Query   |  139 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 33160 | greentec_jam | localhost | greentec_jam | Query   |  103 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 33446 | greentec_jam | localhost | greentec_jam | Query   |   67 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 33684 | greentec_jam | localhost | greentec_jam | Query   |   41 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 33720 | greentec_jam | localhost | greentec_jam | Query   |   31 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 33786 | greentec_jam | localhost | greentec_jam | Query   |   22 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN |    0.000 |
| 34008 | greentec_jam | localhost | greentec_jam | Query   |    2 | Writing to net       | select DISTINCT jr_cccometchat_cometchat_jamroom_users.userid userid, jr_cccometchat_cometchat_jamro |    0.000 |
| 34027 | greentec_jam | localhost | greentec_jam | Sleep   |    0 |                      | NULL                                                                                                 |    0.000 |
| 34034 | greentec_jam | localhost | NULL         | Query   |    0 | init                 | SHOW PROCESSLIST                                                                                     |    0.000 |
+-------+--------------+-----------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+----------+
52 rows in set (0.00 sec)

MariaDB [(none)]>

at times up to 160 rows with cpu maxxed
i don't get what on the front page could have been causing this

from wayback machine july 11
https://web.archive.org/web/20170711074843/http://www.dreadlockssite.com
so you see whats there was anything changed that would cause anything there to not work

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

@soaringeagle
7 years ago
3,304 posts

decided to try every browser i had
chrome gave me this clue
ERR_SPDY_PROTOCOL_ERROR

i was wondering why console never even showed a protocol

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

@michael
7 years ago
7,715 posts

Search results: Reddit: "Can someone find a fix for this shit? ERR_SPDY_PROTOCOL_ERROR"
https://www.reddit.com/r/chrome/comments/3ej5ua/err_spdy_protocol_error/

Which points to https://productforums.google.com/forum/#!topic/chrome/sfAqeo4hDy8

Which says:

Quote: EDIT -- Permanent fix:
Ok, I've figured out a permanent fix. It turns out it actually is Avast, Chrome and Avast don't play nice with each other for whatever reason. To fix this issue permanently, you have to go Into Avast ==> Settings (Gear icon) ==> Active Protection ==> Web Shield (Customize Button) ==> DESELECT "Enable HTTPS Scanning". Then click OK to all the menus and flush your sockets again. It's been a week or so since I did this and I haven't got the error since (with heavy browsing of the sites that most commonly threw the error before). Obviously the downside is Avast no longer scans HTTPS websites but I'd much rather have usability than that feature, at least until the problem is fixed. What's weird is disabling Web Shield or Avast entirely never did the trick for me, only turning off this one specific option worked. Hope this helps you guys. Maybe we can now go bother Avast to fix the issue.

@soaringeagle
7 years ago
3,304 posts

don't use avast but found the problem was code i used for the gallery i got it fixed

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

solved emergency after core update mysql uses 100% cpu

Tags