|
Due to some necessary server maintenance, there will be a short outage sometime after 8PM EST March 3, 2023.
I expect that this will only take 15 minutes but may take longer.
Sorry for the inconvenience.
Matthew
"Time flies like an arrow. Fruit flies like a banana."
|
|
|
|
|
Oh gawd. You're doing "essential maintenance" on a Friday?
There's a recipe for a long weekend at work ... 
Here's hoping you all manage to avoid that!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I'll be "observing". 🍷
cheers
Chris Maunder
|
|
|
|
|
Rather than a glass of wine, how about a screwdriver?
|
|
|
|
|
The backup plan is a hammer. But I see what you did there.
cheers
Chris Maunder
|
|
|
|
|
From a "safe distance" I hope? Say, Tasmania? 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
One has to do what one has to do. The rules.
How often does the site go offline for maintenance?
Not many.
I cannot recall the last time.
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
It's been years. This one is because we have to move our main database to a new file system due to a big cleanup Matthew did. It should only be 10-15 minutes but there was no easy way to keep everything online while we did it so we decided to bite the bullet.
In theory we can actually be without the database for that 15 mins, but we're not going to mess around for that short a period of time.
cheers
Chris Maunder
|
|
|
|
|
Understood. Thanx for working on this. CP is worth it.
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
That's OK, some of us will be fast asleep then. 
|
|
|
|
|
That's the plan.
"Time flies like an arrow. Fruit flies like a banana."
|
|
|
|
|
Matthew Dennis wrote: but may will take longer
I'm sorry but Murphy's Law demands that change. 
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
"How Hard Can It Be?"[^] 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
O'Toole's Law
"Murphy was an optimist."
"Time flies like an arrow. Fruit flies like a banana."
|
|
|
|
|
O'Toole, my man!
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
Gotta take the current server hamsters to a farm upstate, eh?
To err is human. Fortune favors the monsters.
|
|
|
|
|
Shhhhhh!
cheers
Chris Maunder
|
|
|
|
|
The one where they will all be very happy but we can never go visit them? 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Rule one: Never make any changes on a Friday.
|
|
|
|
|
I trust you to have informed the seismologists so there will be no false alarms about earthquakes when millions of CP members will stomp the ground when CP will be offline for 15...minutes 
|
|
|
|
|
I, personally thank you for helping CodeProject stay "On-Air" (or the internet if you want)
ed
|
|
|
|
|
So I'm on this project where everything is done using a no-code platform.
The platform itself is the worst of the worst, but the company who made it is my customer (or employer if you well, I'm a contractor for them).
The company I'm working for is great (so the customer of my customer), but unfortunately everything has to go through this no-code platform (they get paid by the task!  ).
So anyway, it works kind of like a queue.
A task starts, either manually (called from code) or automatically (through a timer), and is then queued.
The problem is, the queue is not persisted, so if the server restarts or anything else happens, the queue is empties and your tasks won't run.
Because of this, every task is triggered by a timer and all data a task needs is persisted to a database.
Things get convoluted pretty quickly...
They have a WebForms (VB.NET) front-end so we can run everything in code just as easily, but they have to be tasks in the no-code platform 
The thing is, we now have a simple super unnecissarily complicated import and export functionality.
The import is easy enough, every ten minutes I get all changes from the last ten minutes using an API and merge them in a SQL Server table.
The export is more difficult, as everything I want to export needs to be stored in the database (because of the non-persisted queue).
Now my employer wants to do this in the same table as the import 
So we have our table, SomeEntity, which contains entities, but which also contains jobs for the export.
The difference between the two is a column which specifies if it's "FROM" or "TO" the other system.
So if you now want SomeEntity you'd have to query like "SELECT Fields FROM SomeEntity WHERE ... AND Destination = 'FROM'"
If you forget the Destination filter you'll get all export rows as well, which you never want as they're basically one-off queue items
ALL of this is really super bad already, but apparently they've found ways to make it worse
I advised against it, but this is just the way they (want to) work and my opinion mattered little.
As you can imagine this is just the tip of the proverbial iceberg.
I want to tell my customer's customer just how screwed they are, but professionality is keeping me from screwing over my own customer.
Won't work anyway as the CEO's are school friends and they've been doing business for something like twenty years already.
Only a few more weeks and I'm done with this job, it's just not worth the money (no amount of money is!) 
|
|
|
|
|
|
Richard Deeming wrote: Run away! 
Yeah, that should've been a sign on the wall.
Still, didn't expect it to be this bad
Richard Deeming wrote: If not, I suspect the performance is going to suck donkey balls.
Not my problem anymore in a few weeks time 
|
|
|
|
|
Boo! VB is the best! Have you ever used it, or are you just going on what other people say?
But this is an example of the "Golden Rule". The man with the gold, makes the rules. 
ed
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
