@ |
Home | Help | Status | Forums | Glossary | Account
|
log in |
Message boards : Help! : Couldn't connect to database
Author | Message |
---|---|
During the last weeks I often received this error. Especially (It seems to me) while there is app. run.(Besides this no particular pattern visible to me. Mostly this occurs for five Minutes but sometimes last for hours). Is this due to the increased attempts to connect or are you trying something. | |
ID: 6186 | Rating: 0 | rate: / Reply Quote | |
Kalessin wrote: During the last weeks I often received this error. Especially (It seems to me) while there is app. run.(Besides this no particular pattern visible to me. Mostly this occurs for five Minutes but sometimes last for hours). Is this due to the increased attempts to connect or are you trying something. Yes, I've seen the same problem, and it's even impacted the I2U2 mock-up site I'm hosting here. Basically the DB server decides to stop working when the system load goes above a certain threshold, and there are semi-periodic spikes in load, which I've been trying to track down. The primary cause just seems to be the load on the database during an app run. But there may be other things that contribute, and I try to fix them when I find them. Thank you for the report, and any observations which might help track down any more contributing factors. ____________ -- Eric Myers "Education is not the filling of a pail, but the lighting of a fire." -- William Butler Yeats | |
ID: 6189 | Rating: 0 | rate: / Reply Quote | |
The missing DB caught me today for the first time, but multiple times and it took some minute-two. Error: 1045 multiple times, and Error: 1040 but only once (or twice?). This gave me the idea to take a look at the Project status. Initially it was a cached data of 17:25:05 up 54 days, 3:37, 4 users, load average: 3.87, 2.87, 2.59but then later I've got this nice 17:45:07 up 54 days, 3:57, 4 users, load average: 17.63, 9.39, 5.07 ____________ Peter .-) | |
ID: 6194 | Rating: 1 | rate: / Reply Quote | |
For the past several hours not only have I seen no database errors, but also all pirate pages load noticeably faster. | |
ID: 6199 | Rating: 0 | rate: / Reply Quote | |
Contact wrote: For the past several hours not only have I seen no database errors, but also all pirate pages load noticeably faster. I don't know if any credit is deserved for this. During that period I did just about nothing to the server. I've now ramped up the cushion to get lots of work out there, to try to reproduce the problem (yes, we now want it to happen). I'll then try a new version of the feeder, which might be the culprit. ____________ -- Eric Myers "Education is not the filling of a pail, but the lighting of a fire." -- William Butler Yeats | |
ID: 6201 | Rating: 0 | rate: / Reply Quote | |
Wormholio wrote: During that period I did just about nothing to the server. Hmmmm. Maybe then something has changed in the pipeline between here & there. Or could it be that someone has stopped running (or modified) a script against the pirate server? Before yesterday, and for many weeks before that, if I was trying to navigate from a pirate page to another pirate page (even the Glossary) it would take as long as 20 seconds for that page to load. At some point yesterday all pirate pages were loaded almost instantly. This is still the case now. I've also not seen any database errors since yesterday. A few days ago I got database error even when trying to enter the Glossary! I noticed this on two very different isp's that are many miles apart. Ha! Just got a database error during my 1st attempt to post this, but navigation is still fast. ____________ Click and enter your name for your BOINC Statistics | |
ID: 6202 | Rating: 0 | rate: / Reply Quote | |
Contact wrote: Before yesterday, and for many weeks before that, if I was trying to navigate from a pirate page to another pirate page (even the Glossary) it would take as long as 20 seconds for that page to load. As I was reading these lines, I've tried to open the Project Status page, in order to see, whether there is any excessive load. Some 20 minutes later, the page is still not yet opened! One minute later I've tried to open the page again in another window and yet another window with this reply - it took twoooooo long minutes. (I did see some 5-6 pages prior to comming here - it was regularly fast.) On the Status page, the system loads were around 2-3, seems OK. But I've noticed that the page was much older (maybe more than 20 minutes) than the last 10 minutes (there was smething like "CACHED 10:35 AM EDT on 12 Jul 2007 (updated every 10 minutes)" IIRC, but the page was later refreshed automatically, so I've lost the exact data). And, BTW, is the e-mail notification out of order? ____________ Peter .-) | |
ID: 6203 | Rating: 0 | rate: / Reply Quote | |
Pepo wrote: Some 20 minutes later, the page is still not yet opened! One minute later I've tried to open the page again in another window and yet another window with this reply - it took twoooooo long minutes. Now it is reasonally fast again, but until 3 minutes ago, everything was slow and I was also getting "CACHED 11:02 AM EDT...", then it got replaced with "CACHED 11:20 AM EDT...". So at least the 10 minutes of caching are not true. (The next update I've seen was 11:35 AM EDT, so possibly 15 minutes?) ____________ Peter .-) | |
ID: 6204 | Rating: 0 | rate: / Reply Quote | |
Pepo wrote:
It was, but that should be fixed now. My ISP changed servers on me and there are still some config issues, but I found a relay I can use (the old pirates server, in fact). The one problem I am aware of is we can't send to CERN right now. ____________ -- Eric Myers "Education is not the filling of a pail, but the lighting of a fire." -- William Butler Yeats | |
ID: 6205 | Rating: 0 | rate: / Reply Quote | |
Pepo wrote:
Here is how it works. If there is a cached copy less than 10 minutes old, then that is what you get, and it's fast. If the cached copy is more than 10 minutes old then it's regenerated, and you have to wait for it (and everybody else). It's slow, I know, but I've done what I can to speed it up. It's faster after the database has been preened. If your browser has the page open then after 20 minutes it will automatically refresh, which may or may not require building the page again, depending upon if someone else has done so in the past 10 minutes. This last bit is a new feature which I intend to submit to BOINC. The ratio between the inital cache period and the regeneration period is configurable (I've set it to 2.0). ____________ -- Eric Myers "Education is not the filling of a pail, but the lighting of a fire." -- William Butler Yeats | |
ID: 6206 | Rating: 0 | rate: / Reply Quote | |
Arrrr. Blast! | |
ID: 6207 | Rating: 0 | rate: / Reply Quote | |
I've noticed the low numbers for the past week also ... I can recall much higher numbers in the past months - just now: 22:20:03 up 2 days, 4:49, 2 users, load average: 0.46, 0.44, 0.39 | |
ID: 6208 | Rating: 0 | rate: / Reply Quote | |
CACHED 12:53 AM EDT | |
ID: 6213 | Rating: 0 | rate: / Reply Quote | |
| |
ID: 6219 | Rating: 0 | rate: / Reply Quote | |
10:45am EST - 4 users, load average: 1.91, 1.85, 1.41 | |
ID: 6221 | Rating: 0 | rate: / Reply Quote | |
Wormholio wrote: Good idea. If we are going to give it a test, let's give it a real test. I had increased the cushion to 7, but now I've raised it to 17, and we'll go higher if necessary. That's bringing in the nosy part of the dragon, again: How does it come to our particular settings, and did they have changed beside the changes within the last run? (It was very long and intensive even before these last variations before the crash, wasn't it?) WUs per host? WUs in the pillows cushions or wherever? Time and amount of app.run? ____________ Dragons can fly because they don't fit into pirate ships | |
ID: 6230 | Rating: 0 | rate: / Reply Quote | |
Getting this error right now: | |
ID: 6232 | Rating: 0 | rate: / Reply Quote | |
Gamma^Ray wrote: Getting this error right now: From the server status page: The Pirates@Home scheduler is currently restricted to our local domain for testing. I think we've done what was asked. Let's see what happens. What a blast! ____________ Click and enter your name for your BOINC Statistics | |
ID: 6234 | Rating: 0 | rate: / Reply Quote | |
Just had a real hard time trying to load pirate pages. | |
ID: 6289 | Rating: 0 | rate: / Reply Quote | |
Contact wrote: Just had a real hard time trying to load pirate pages. We've been having many this afternoon, after I raised the cushion to 20, and load jumped almost that high. I lowered the cushion to 5 to see if it will stabilize. I need the DB server to be stable during the day, but we'll load it up again later to try a few things. ____________ -- Eric Myers "Education is not the filling of a pail, but the lighting of a fire." -- William Butler Yeats | |
ID: 6290 | Rating: 0 | rate: / Reply Quote | |
It is happening now again. Either "Error: 1045 - Access denied for user 'apache'@'localhost' (using password: NO)" (mostly) or "Error: 1040 - Too many connections". | |
ID: 6291 | Rating: 0 | rate: / Reply Quote | |
Some hour-two ago the web pages were not very responsive. I've tried to open the Status on two pages, the first one opened a minute later than the second one, but the contents - pretty rapid load fall: | |
ID: 6309 | Rating: 0 | rate: / Reply Quote | |
Message boards : Help! : Couldn't connect to database
Home | Help | Status | Forums | Glossary | Account
|