Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Another server overload  (Read 3938 times)

0 Members and 1 Guest are viewing this topic.

drownedgod

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 19
    • TV Screencaps
Another server overload
« on: July 01, 2009, 08:54:20 am »

I am using IXWebhosting and they contacted me again that the website is causing a server overload. I searched for threads like this but I didn't find what I need to do. Here's what they said.

Quote
       We are notifying you that your account, or a portion or feature of your account has caused an overload on one of our servers. We have a shared hosting environment that we must maintain at a certain level of performance. This performance is monitored and balanced by us, however there are times when accounts can cause the server’s load to increase degrading the performance for all other customers on this server.

       To protect your account from further action you must agree to our request for compliance. Please respond to this message stating your intent to do so. You may either log into your control panel with us, and access this ticket via the 24/7 help desk, or provide this ticket number to our Live Chat or phone representatives.

       Please contact us to resolve this matter.

Most common query [db***user]:

Time: 99% (5638 sec)
Amount: 99% (580 queries)
Rows Examined/Sent: 189529964 / 11253
Avg. Query Exec/Lock Time: 9 / 0 sec.
Used databases: [db***name]
Query example: use db***name; SELECT * FROM cpg14x_pictures WHERE approved = 'YES' AND aid IN (5,6,7,8,9,10,11,12,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,54,55,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,134,135,136,137,138,139,140,141,142,143,144,145,146,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172 ... [too long]

db***name db chmoded to 0

Please note that this is the second time this problem occurred. Unfortunately, I have to bring to your attention that as per our terms of service a third instance will result in immediate account termination without notice. No backups will be provided. If you have any questions about how to avoid this from happening again our support team will be glad to advise.

HELP! I don't know what to do!
Logged

Fabricio Ferrero

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 1996
  • From San Juan, Argentina, to the World!
    • http://fabricioferrero.com/
Re: Another server overload
« Reply #1 on: July 01, 2009, 09:05:20 am »

A link to your gallery please.
Logged
Read Docs and Search the Forum before posting. - Soporte en español
--*--
Fabricio Ferrero's Website

Catching up! :)

drownedgod

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 19
    • TV Screencaps
Re: Another server overload
« Reply #2 on: July 01, 2009, 09:10:52 am »

Logged

drownedgod

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 19
    • TV Screencaps
Re: Another server overload
« Reply #3 on: July 01, 2009, 09:13:20 am »

They disabled the database that's why we are getting the error. I am asking them to re enable the database as of the moment. I don't know how long it will take them to take action on that.
Logged

Fabricio Ferrero

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 1996
  • From San Juan, Argentina, to the World!
    • http://fabricioferrero.com/
Re: Another server overload
« Reply #4 on: July 01, 2009, 09:17:22 am »

Yes, I can't see anything.
Logged
Read Docs and Search the Forum before posting. - Soporte en español
--*--
Fabricio Ferrero's Website

Catching up! :)

Nibbler

  • Guest
Re: Another server overload
« Reply #5 on: July 01, 2009, 11:27:33 am »

The random files block should not be used on large galleries. To advise more I need to see the  complete query they posted.
Logged

drownedgod

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 19
    • TV Screencaps
Re: Another server overload
« Reply #6 on: July 01, 2009, 11:51:45 am »

Thanks. I will remove the random photos block once the site is back. I will also let you know when the site is up so you guys can take a look.

thanks in advance
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Another server overload
« Reply #7 on: July 01, 2009, 01:38:26 pm »

Threatening to terminate you without notice and without backups is a bit of a worry. If possible and just in case you should make a backup of your entire site and database asap.

I don't like this attitude. Rather than acting like that a little help might be better or even limiting your resources to take the load off others on your shared hosting.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Another server overload
« Reply #8 on: July 01, 2009, 03:54:58 pm »

Seems to me like you have set up very complicated permissions settings. Once your site is back up, disable the random thumbs as suggested and then post here.

http://tvscreencaps.com/sql/update.sql shows that you're running an outdated version, so you should update immediately. Additionally, turn indexing off - it's not a bright idea that visitors are capable to browse the content of folders.
Logged

drownedgod

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 19
    • TV Screencaps
Re: Another server overload
« Reply #9 on: July 02, 2009, 03:37:27 am »

hey guys,

thanks for all the suggestions. the site is up again. i removed the random thumbs.

however, i think i got hacked. look http://tvscreencaps.com/albums/

how do i fix this?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Another server overload
« Reply #10 on: July 02, 2009, 11:15:28 am »

That's possible, as you are running an outdated version that contains known security flaws. Read the thread that people always get refered to when they ask about having been hacked. Search the board first before asking and respect the "one issue per thread" policy in the future.
Actual link is http://tvscreencaps.com/
Logged
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 20 queries.