Help - how to stop a script running?
-
Ben
MemberHowdy
Was just doing a CSV import test on a site (only 4 records) and somehow the script has fudged the server up, as everything is timing out & not loading.
I've restarted mysql, nginx and finally rebooted the VPS, them
free -mwas showing 95% used and everything is back up but going very slow.........so somthing is still whiring away.Anyone any ideas?
Cheers
Ben.Posted 1 year ago # -
Ben
MemberI've managed to isolate, but not fix the issue.
I've restart mysql again, and going on the site that I ran the initial script on makes mysql go nuts again - something isnt right. There are about 5/6 mysql processes running, all on that site's DB - killing each process just spawn's new ones, so I guess the script is in some sort of loop on mysql?
All the other sites are fine, but if I visit the site - they all go down. Just thankful its not a live site that regular vistors can trigger.
Any ideas on how to fins & stop this??
Think it's wise to get together a crib sheet - "thing to do when things go tits up"
Cheers
Posted 1 year ago # -
Ben
MemberJust to follow up on this, as its baking my head in........
After booting everything, the site in question still brings the VPS to its knees if you visit the URL, as I assume the query is stuck somewhere and this triggers it to run again? For the time being I've disabled the site.
This is a screenshot of what happens in the CLI to mysql. A bunch of sleep queries, all running on the same user & database.
Any thoughts anyone?
Cheers
Ben.Posted 1 year ago # -
sounds like a malicious script, Ben, else one that is out-of-date/incompatible with MySQL.
Posted 1 year ago # -
Ben
MemberHi Olly,
Hows things?
Nothing malicious, it was a kosher plugin from expression engine.
In the end, I had to delete the php plugin file from the server and that stop the loop.
Would be good to know if there was a way to see what was causing this & how to stop it?
Killing the mysql processes didnt work, it kept spawning new ones - which is why I think something was stuck in a big loop.
Cheers
Ben.Posted 1 year ago #
Reply
You must log in to post.
Want HTML?
a blockquote code em strong ul ol liPlace code between backticks `codeHere`
You've got it.