Forum Activity for @soaringeagle

soaringeagle
@soaringeagle
08/30/17 11:55:28PM
3,304 posts

could thiss be caused by my skin and sb?


Installation and Configuration

that is it!!! my forums no longer exist (they were a profile though wtf) my sitemap crawlker only crawls 256 out of 1 million pages
because many many pages now say they need to be built..wtf i need serious help
soaringeagle
@soaringeagle
08/30/17 11:52:53PM
3,304 posts

could thiss be caused by my skin and sb?


Installation and Configuration

its related to my other post, but might be the corre issue
my front page wont load at all
i am using the discontinued ningja skin
been meaning to upgrade to ninja (wasn't there 1 to replace ningja) but now i cant find ninjas anymore
my front page wont load now since the sb and core update

i get all thoser weirdo errors from the other thgread
it seems like maybe its related to the skins incompatability with new sb (other sb pages load so guessing its either the rotating image thing..or the tag cloud)
updated by @soaringeagle: 12/02/17 01:27:37AM
soaringeagle
@soaringeagle
08/30/17 11:24:37PM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

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
updated by @soaringeagle: 08/30/17 11:26:37PM
soaringeagle
@soaringeagle
08/30/17 11:04:09PM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

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
@soaringeagle
08/30/17 10:52:23PM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

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
@soaringeagle
08/30/17 07:41:20PM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

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
@soaringeagle
08/30/17 07:33:38PM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

its pretty huge
but images a severeal hundred thousand but gallery probly under 100,000
soaringeagle
@soaringeagle
08/30/17 06:16:01PM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

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
@soaringeagle
08/30/17 04:09:07PM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

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
@soaringeagle
08/30/17 03:56:21PM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

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?
  60