Page 2 of 4

Re: 500 -Internal server error Again....

Posted: Sun May 10, 2009 9:15 pm
by eduo
:( :!: :oops: :cry: :shock: I faced the internal server error message for most of the time,
consider 9/10 trying ,refresh or any attempt to get through. Is there any way to avoid this? Pls advise...
:idea: :( Loyal fan from Qatar.
:P :lol: :o :) :D :?
So.Was there any emoticon you didn't include? :)

The errors seem to have disappeared since yesterday. Did you get any today?

Posted: Mon May 11, 2009 2:48 pm
by oss
we got some problems with connecting to DB server.

Code: Select all

error: 2013: Lost connection to MySQL server at 'reading initial communication packet', system error: 54
thats the error we are getting. anyway, still trying improve the service

[ADMIN] 500 and 503 errors

Posted: Wed May 13, 2009 9:02 pm
by oss
Hi,

I know site is almost unusable now. I am really sorry for that, but I am doing what I can. Basically we are facing to these problems:

1. for some unknown reason we got some connection errors to CACHE database server, resources:
http://forums.mysql.com/read.php?20,262042,262042#REPLY
http://bugs.mysql.com/bug.php?id=28359
(I increased connect_timeout...)

2. sometimes I get this error, when connecting to DB server:
CANNOT CONNECT TO DB: error: 0:
(that means it got error no. "0" and there is no description.)

We are working on fixing that, server without this cache is really slow, so I will temporary move cache to main db server.

Also I set up Slave DB (I mean DanGer set it up), but there are going some SQL queries already.

I am really sorry, but I am doing what I can :( (2am right now here).

Posted: Wed May 13, 2009 9:40 pm
by eduo
Ren Tor?

We now know Danger's full name, by the way ;)

So, the errors you're getting are connecting to MySQL? Ouch. That can't be avoided easily, then.

Any specific routine where this is happening more often?

Posted: Wed May 13, 2009 9:49 pm
by oss
I switched cache server to main database server, problem is slave is not working properly now, so I wrote danger to fix it. I put to slave server only suggest (when searching on website) and search1 (mysql search) - for example you dont specify any moviename and you want only "cd1 uploaded yesterday srt" for example...

Now it seems server is more stable and performing quite well, at least I see in the log only some connecting errors - only one error every 5 seconds :)

Now I will go sleep, continuing today morning...

[ADMIN] XML-RPC temporary off

Posted: Fri May 15, 2009 7:07 pm
by oss
it seems nothing doesnt help, at least, I will try to turn off xml-rpc (webservice). We will see, if it helps at least to web users.

I ordered next web server, I will hope it will hope, now loads are around 30 for webservers, which is really bad, and I think all those 500 and 503 are caused by high load.

Please be patient, this is temporary.

Posted: Fri May 15, 2009 9:18 pm
by eduo
This is a shame. I was hoping only some problematic services would be disabled but disabling all the API is a bad sign.

What a shame.

Posted: Sat May 16, 2009 5:45 am
by oss
yes it is a shame. What you would like to disable ? SearchSubtitles and UploadSubtitles ? Or some other service, which is not used so much ?

I can enable it, but as we can see, website and xmlrpc is not usable at all. I read you wrote it is better to have at least one service working (website), than 2 not working (website and xmlrpc). Should I disable website and XMLRPC working ?

This solution is temporary. We ordered next server, 2 CPUs, 8 cores, I hope it helps.

What about your help with servers ? I want try it with ads, if it works, we can continue on some smaller parts (suggestions and so on)

Posted: Sat May 16, 2009 11:55 am
by eduo
yes it is a shame. What you would like to disable ? SearchSubtitles and UploadSubtitles ? Or some other service, which is not used so much ?

I can enable it, but as we can see, website and xmlrpc is not usable at all. I read you wrote it is better to have at least one service working (website), than 2 not working (website and xmlrpc). Should I disable website and XMLRPC working ?

This solution is temporary. We ordered next server, 2 CPUs, 8 cores, I hope it helps.

What about your help with servers ? I want try it with ads, if it works, we can continue on some smaller parts (suggestions and so on)
I offered sharing hosting, this is Bandwidth and disk. I don't think this can be done for ads.

I understand your choice of stopping the API, since it's the non-paying part of the site. I just say it's a shame. I still think the API and the Web should be separate. More than half the activity is in the API now, so stopping it will have an impact on users, but usage will definitively go down.

I will not put ads in my webpages. I'm not sure if that was the proposal but my webpage is a personal blog and advertising has no place in it.

Posted: Sat May 16, 2009 1:29 pm
by Christofer
I'm still getting "500 - Internal Server Error" today but maybe not as frequent as before. So XML-RPC isn't the only cause. I'm willing to help out as I think the service is great and like many others I relie on it.

The forums are always fast, are they hosted on a different server?

same error

Posted: Sat May 16, 2009 2:34 pm
by Exhibit_dk
Hiya

I have same error. Haven't been able to use this site nor subdownloader2 - Know youre working hard :? - Is this still an error your end or should I look at my settings :?:

Posted: Sat May 16, 2009 3:14 pm
by oss
forum is on different server.

I dont know what is wrong, I turned off XMLRPC, but I still have load 20 on 3 webservers. And they are quite powerful servers:

Code: Select all

CPU: Intel(R) Xeon(R) CPU E5320 @ 1.86GHz (1861.92-MHz K8-class CPU) Origin = "GenuineIntel" Id = 0x6f7 Stepping = 7 usable memory = 8582840320 (8185 MB) FreeBSD/SMP: Multiprocessor System Detected: 8 CPUs runnnig @ FreeBSD 7.2-RELEASE
I hope, when there will be other server online, it will be much better.

Exhibit_dk: that means all programs can not work, coz they use XML-RPC.

eduo: it means hosting files - subtitles, right ? You can run there php, no database ?

Posted: Sat May 16, 2009 5:48 pm
by eduo
eduo: it means hosting files - subtitles, right ? You can run there php, no database ?
You tell me what you need. we'll see about providing help with it. I can create a subdomain in eduo.info to host files. I can use PHP and MySQL. What requirements do you have?

Posted: Sun May 17, 2009 5:16 pm
by mataka80
I switched cache server to main database server, problem is slave is not working properly now, so I wrote danger to fix it. I put to slave server only suggest (when searching on website) and search1 (mysql search) - for example you dont specify any moviename and you want only "cd1 uploaded yesterday srt" for example...

Now it seems server is more stable and performing quite well, at least I see in the log only some connecting errors - only one error every 5 seconds :)

Now I will go sleep, continuing today morning...
Just wondering are you using new db connection for every request or pooling db connections. Maybe pooling might help if you don't do that already?

Posted: Sun May 17, 2009 8:05 pm
by eduo
eduo: it means hosting files - subtitles, right ? You can run there php, no database ?
You tell me what you need. we'll see about providing help with it. I can create a subdomain in eduo.info to host files. I can use PHP and MySQL. What requirements do you have?
I haven't received anything about this. Anything else I can do to help?