In Which I Am Stressed & Frustrated
Nov. 12th, 2018 10:51 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
shannon_aRPGnet. I hate doing big upgrades on RPGnet. I'm currently working on what I think is the third, after vB2->3, vB3->4, and now vB4->XF2. The problem is that the forum is huge, so when any changes are made to the table of posts (which was somewhere north of 10M posts last time I converted and is now closer to 20M), it takes a long time. The last conversion I did was awful because there was at least one "ALTER TABLE" which took 12 or 14 hours to do all on its own, with no milestones or save points along the way. Ayyyy.
This time around I testbedded our conversion and it ran 32-33 hours on that test machine. It was also a much better conversion, constantly saving its state. So, you could see it crawl along, but you knew if it halted at any point (and it did here and there), it could just restart.
But now that we're onto the REAL conversion, which I started Saturday night, things are going slower, likely because of the difference in the machine setups between my testbed and my real setup. We're almost 40 hours in, and the post table is likely to be about 64% when we hit that milestone. It could easily run into Tuesday night, which is much longer than planned.
I mean, there's nothing I can do about it, and this far in, it's best to let it finish, but I hate sitting here, knowing our very popular forums are down, and not being able to do anything about it. At least it's still the (long) Veteran's Day holiday.
Oh, and that's not even speaking of how I woke up at 2.30 last night certain that something was wrong. I stumbled into my office, logged into my computer ... and found the upgrade process had died! (Is it really paranoia when they are out to get you?) For some mysterious reason, it had created a duplicate post and gotten stuck. I fumbled with it for several minutes and managed to get it going again, but the rest of the night I slept somewhat fitfully. Now I just hope that nothing is corrupted. I just need to test that the forwards from the old forums line up correctly when we're (finally) done. (Boy, that would suck if after all of this, the conversion didn't work right.)
Dark Skies. We continue to have crap out in the air for the fourth day running. Yeah, things are clearly worse north of here, where the worst fire in recorded Californian history continues to burn, but I'm going stir crazy. I feel stuck in the house, and even here I'm aware that we're breathing crap because about half of our windows are old and don't seal as well as modern windows. Today the AQI is still 175, which is square middle of the "unhealthy" range.
Endgame. And it's now been three days since I learned about Endgame closing. I wrote about it in Mechanics & Meeples today, but it's wasn't particularly cathartic, as I'd hoped it would be. Really, I think, I need to talk with friends there and see if there are any alternatives to see folks from that community and to get in my day of most freeform board gaming, where I'm most likely to play new and interesting and strategic stuff. But I can't do that until Wednesday, so for that moment it looms.
Really, this should all be looking better by the end of the week, and none of it's horrible for me, but you put it all together and it's a dark cloud looming over the new week.
This time around I testbedded our conversion and it ran 32-33 hours on that test machine. It was also a much better conversion, constantly saving its state. So, you could see it crawl along, but you knew if it halted at any point (and it did here and there), it could just restart.
But now that we're onto the REAL conversion, which I started Saturday night, things are going slower, likely because of the difference in the machine setups between my testbed and my real setup. We're almost 40 hours in, and the post table is likely to be about 64% when we hit that milestone. It could easily run into Tuesday night, which is much longer than planned.
I mean, there's nothing I can do about it, and this far in, it's best to let it finish, but I hate sitting here, knowing our very popular forums are down, and not being able to do anything about it. At least it's still the (long) Veteran's Day holiday.
Oh, and that's not even speaking of how I woke up at 2.30 last night certain that something was wrong. I stumbled into my office, logged into my computer ... and found the upgrade process had died! (Is it really paranoia when they are out to get you?) For some mysterious reason, it had created a duplicate post and gotten stuck. I fumbled with it for several minutes and managed to get it going again, but the rest of the night I slept somewhat fitfully. Now I just hope that nothing is corrupted. I just need to test that the forwards from the old forums line up correctly when we're (finally) done. (Boy, that would suck if after all of this, the conversion didn't work right.)
Dark Skies. We continue to have crap out in the air for the fourth day running. Yeah, things are clearly worse north of here, where the worst fire in recorded Californian history continues to burn, but I'm going stir crazy. I feel stuck in the house, and even here I'm aware that we're breathing crap because about half of our windows are old and don't seal as well as modern windows. Today the AQI is still 175, which is square middle of the "unhealthy" range.
Endgame. And it's now been three days since I learned about Endgame closing. I wrote about it in Mechanics & Meeples today, but it's wasn't particularly cathartic, as I'd hoped it would be. Really, I think, I need to talk with friends there and see if there are any alternatives to see folks from that community and to get in my day of most freeform board gaming, where I'm most likely to play new and interesting and strategic stuff. But I can't do that until Wednesday, so for that moment it looms.
Really, this should all be looking better by the end of the week, and none of it's horrible for me, but you put it all together and it's a dark cloud looming over the new week.
no subject
Date: 2018-11-13 03:17 am (UTC)no subject
Date: 2018-11-13 03:28 am (UTC)