Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
JonBorno826y@alexbrooklyn A transaction is the propagation of one or more changes to the database. E.g., if you are deleting a record from the table, then you are performing a transaction on that table. Most clients like sqldeveloper can rollback that transaction. But if its commited its commited.
-
gnog3166y@boese
haha Basically erased all recruiters' jobs done.
Kinda fucked all the recruiters from the company. -
bahua128016y@alexbrooklyn
Yes it was an accident. I was preparing for weekend maintenance that would be performed on some production storage volumes, and screwed up a copy and paste. That screw-up blew away said production volumes during business hours.
A highly placed executive made the decision to fire me. I never met him. -
gnog3166y@rutee07
Shit! I haven't thought about that. You gave me a little breath of possibility.
@scor
At the beginning of this year I implemented it, and it was a little relief to recover that part. I hadn't thought of db log (I don't think it is enabled), but I will check.
Ty for remembering me about that! -
@gnog oh, in that case.. Flashback on ORACLE DB saved my ass once. It allows you to run queries like
`select * from USER as of timestamp SYSTIMESTAMP - 1/24`
to see what the table looked like X time ago (1hour ago in my example).
In your case `FLASHBACK TABLE HR.REG_HIST TO BEFORE DROP;` could be handy :)
ref.: https://docs.oracle.com/database/...
It's one of the reasons I actually like Oracle DB -
bahua128016y@gnog
I mean, not great. But I liked the jobs I had since then much better. That was over ten years ago. -
JonBorno826y@gnog btw since we're talking about mistakes... i once forgot the where clause in my update statement :D luckily auto-commit was enabled ^^
-
Condor323326yMaybe this was the table drop by an intern that @netikras was talking about earlier? 🤔
-
Well, start thinking about how to explain that a hacker went into the system and did some mess, but u saved all the tables in this database but only one... And that u will finally be able to fix that security hole, thanx to this hacker lol
After all those goodnews, u can tell them that, infortunately, some collateral damage include loss of content of recreuiters
Fuck hackers -
What rdbms are you using? It sounds kinky to drop a fist table. Didn't know there are dbs out there that support fisting tables.
-
Quirinus7526yWe need some sort of git for dbs. XD
I know theres some similar elements to git in some db management systems. It would be cool to review the changes before commiting and having the ability to revert changes. There's problems ofc: big changes (tons of rows) and all real time changes would have to go trough this git-like system automatically, making it a mess to revert basically concurrent changes in high traffic dbs.
Anyone know of any system like that?
Please tag me if you have any insight! -
Does your server have any kind of recovery points? Like the one that windows got? I'm an absolute noob with server stuff but thats what I would thinking about
-
Maer16876yIf you get the sense they aim to replace you for that - just drop the recruiter's data again.
Related Rants
-
rephiscorth38Everyone here ranting about a fucking missing semicolon. I can't remember the last time a missing semicolon wa...
-
CodesNotHot11-Laughed at Gitlab the other day -Accidentally dropped my db today. fuck karma
-
CCAtAlvis16Shit happens... but never let your shit go to far... specially while in production or drunk.
Well... My fist table drop in prod... Cheers 🍻
Fuck.
rant
bd
life
fuck
shit