Backslash (Oct 07 2009) |
![]() |
| log in |
Message boards : Technical News : Backslash (Oct 07 2009)
| Author | Message |
|---|---|
|
The replica recovery is on hold for a while. We've experiencing random, intermittent issues when trying to recover one database with a mysqldump from another. This used to always work perfectly, but then something in mysql 5.1 screwed up the quoting and backslashing. I was able to get around this before by writing a script that parsed the large dump files one line at a time, but even that isn't working now. Bob has found other complaints on the web about this, so maybe there's a bug fix somewhere (we're certainly not going to pore through 20GB of ascii looking for missing backslashes and whatnot). We might have to do another dump from scratch, which won't happen until next week, which means the replica may be offline until then. Still, when we recover from the outage (and the weekend backlog) I might still turn on the "show results" flag so users can see recent result history, etc. | |
| ID: 938179 · | |
|
Thanks, Matt and the rest of the team, for all the hard work. | |
| ID: 938182 · | |
|
Can just the daily BoincStat dump be re-pointed at Mork for this week? Or would that mess up the stats worse than waiting? | |
| ID: 938199 · | |
|
As far as I know everything is pointing at mork right now. Let me know if it seems like I'm wrong about that. | |
| ID: 938201 · | |
|
Dump has appeared on schedule, and gross total credit has gone up from 57,096,271,778 to 57,184,239,144 - looks A-OK from here. | |
| ID: 938229 · | |
...when we recover from the outage (and the weekend backlog) I might still turn on the "show results" flag so users can see recent result history, etc. If the "Cricket graph" is considered to be a good indicator of current workload, it looks like we're out of the woods... or maybe not? ____________ Who the hell is General Failure and why is he reading my harddisk?¿ | |
| ID: 938230 · | |
|
I use 'mysqldump -O net_buffer_length=32760 --opt -Q' for dumps, but I just noticed I'm still on 5.0, so that will probably be why I haven't come across the backslash/quoting issue. | |
| ID: 938257 · | |
... It would be nice to have the task list/s available. Maybe also the pending credits.. Everytime I change/do something on my PCs this isn't available.. ;-) ____________ >Das Deutsche Cafe. The German Cafe.< | |
| ID: 938288 · | |
(unless I suddenly disappear on an impromptu vacation, which is known to happen from time to time) Last chance before it all turns white.____________ | |
| ID: 938447 · | |
(unless I suddenly disappear on an impromptu vacation, which is known to happen from time to time) Are you trying to tempt the man? ____________ BOINC WIKI | |
| ID: 938524 · | |
(unless I suddenly disappear on an impromptu vacation, which is known to happen from time to time) ____________ | |
| ID: 938565 · | |
Are you trying to tempt the man? Some times you need to run away from it all. You think better when you get back. ____________ | |
| ID: 938796 · | |
|
Nice pic of Crater Lake. | |
| ID: 938798 · | |
|
******* run out of spare holiday :-( | |
| ID: 938940 · | |
Are you trying to tempt the man? Some times you need to run away from it all. Then you think "better get back." ____________ | |
| ID: 939011 · | |
|
why not post what a 100,000 watt am broadcast would look like if spotted on 4 light years away. people would have a clue what this is all about. | |
| ID: 939245 · | |
why not post what a 100,000 watt am broadcast would look like if spotted on 4 light years away. people would have a clue what this is all about. Couldn't detect such a signal as far out as you think. http://www.faqs.org/faqs/astronomy/faq/part6/section-12.html ____________ "Gentlemen, there are only two types of naval vessels..........Submarines, and Targets" -- U.S. Navy Submarine SONAR Instructor. | |
| ID: 939414 · | |
Message boards : Technical News : Backslash (Oct 07 2009)
| Copyright © 2013 University of California |