Honestly, robots would have an easier time passing those at this point. I don’t even know why anyone would use them, unless it’s specifically to filter out humans 
3 Likes
We have a fancy house IT now.
BiL helped my partner set it up. BiL does this kind of network stuff for a living. So it is extra fancy with layers upon layers of sec…complications.
Dumb details
I should have been there.
I am the tech person in the house. But I am not good with networks. Not at all. And now we have a router, a hardware firewall (I didn’t even know that existed), a switch with oh so many ports, LAN everywhere, and no internet. We have no documentation of the setup. I can see that my computer is connected to the netgear switch via LAN by the green blinkenlights. I can see that my fritzbox (router) has the zyxel firewall listed as a device. But dhcp is not working nor can I figure out how to access the management interfaces of anything but the router (which is our old one and I configured it and know how it works).
Right now we are leeching my dad’s wifi.
3 Likes
This sounds like just the sort of situation I can be dropped into and Sort Things Out. (I suspect @pillbox too.) But we aren’t there. Sympathies!
4 Likes
Thanks. I will need to become the person who can do this stuff. Because I cannot live in a house where I do not understand the tech. But when it was set up I was too tired from all the other stuff to be present. We‘ve figured out a way to get at the management consoles—probably. From there I should be able to find out more tomorrow. BiL is coming over next Wednesday after his return from vacationland.
3 Likes
I’d be glad to help out. It’s literally what I do all day (I mean, if you don’t count all the other things I do that aren’t really in my job description)
3 Likes
The mistake was that the switch has 2 management ports, one for connecting with a laptop and the other as uplink to the firewall. And they were… switched. BiL is here fixing everything 
If someone had told me about those ports I might have checked both of them. But I am only hearing about them today.
2 Likes
It is my work anniversary today and as a present I’ve been given a laptop upgrade. (The two are totally not related.)
I’ve done no actual work today and instead I’ve been installing numerous applications.
8 Likes
3 Likes
i had the worst 2 days at work. well after the meme anyway. but after the meme most of my workday happened.
i blame hibernate. hibernate sucks. it is not the first time I blame hibernate. hibernate is software, software has errors. this one may be less of an error than a misconception but it is definitely behaving in a different way now than it used to.
our data model is gigantic. we have some very complex not always well-implemented relations. some relations not even explicit. things are so complicated we have custom delete commands that work with “to-delete” views and database triggers and giant stored procedures doing a “manual” cascade.
(these are leftovers from the days when database experts ruled, I would go far out of my way to avoid database convolutions like that in modern software)
it would all work if between then and now the “removeOrphans” feature hibernate/jpa provides had not changed its bevhavior to ALSO trigger before an entity is deleted because the children will soon be orphans. this pre-emptive deletion made for a very difficult to track bug.
I felt like an idiot for the better part of 24 hours until we figured out what was going on. it took 3 people one of which an absolute expert on our database model and setup.
We had to rollback my changes for today’s release because it was unclear what kind of followup-issues this might cause and it was also leaving orphaned records in the database…
There are 2 options both with hard to anticipate side effects:
- remove the orphans manually when dissolving relations
- remove the orphaned records from the implicit relation in java code before deleting the entity
The software is huge. Today we were unable to figure out which way is safer. But suck. RemoveOrphans should not trigger before deletion if CascadeType.REMOVE is not set. RemoveOrphans is not the same as CascadeType.REMOVE.
Well…
at least I feel like less of an idiot now. This was not something anyone here understood easily. Everyone else here would have made the same mistake in my place I am reasonably sure. And had similar difficulty debugging.
Lessons learned:
- hibernate bad
- turn on sql logging asap when debugging database stuff (my excuse was that it was late, I was freaking out and I felt like one of my colleagues was being unusually blamey)
4 Likes
While I will admit that these have their uses, I try to avoid them, even if I’m using a decent database like Postgres. It’s a separate place for code to live.
(Is there a way of auto-deploying all the stored procedures etc. from git to make sure they match up with the actual code that’s also being deployed? Probably there is. I haven’t had to do a lot with SQL lately.)
3 Likes
we use liquibase to level up the (Oracle) database via Jenkins.
i know flask alchemy has a leveling mechanism…
2 Likes
Related to turning on logging, do you have a set of documented procedures to follow when trouble shooting? Even just a check list of steps is a great help. automation and scripts are great, but that can be a next step.
Such proceedures (we call them ‘runbooks’) are excellent for making sure things are done, done in the right order, and can be a big help in getting new people up to speed. one of my teammates is working on automating a bunch of them, which has meant we’ve been figuring out what we’re missing and what the common elements are. Just that effort has helped improve our reliablity and maturity. (I just gave the network team a bunch of stuff for something they broke, which was trivial, because we know what we need, and how to gather the data. )
2 Likes
Living in the future is weird, part 644 in series:
I called my wife to tell her my car (which she was driving) had emailed me to inform me that it had a flat tire.
9 Likes
Damn, the future keeps getting weird. I just saw a battery ad, the selling point of which was “our batteries taste worse than theirs”. That is actually true, not a joke (I’m not that funny), though the phrasing in the ad was rather different.
4 Likes
Seen that one. Duracell coin shaped batteries, right?
Reminded me of when Nintendo announced that their Switch game cartridges would taste bad to keep children from eating them.
And, of course, I think everyone I know who has a Switch has tasted one to verify that they do, indeed, taste bad.
3 Likes
Huh, I just got an error report from my wife’s printer while I was thirty miles away playing games.
3 Likes
I couldn’t have told you the brand, but yes.
I’m not rushing out to taste test, but there has to be some cool technology there, to have a lasting coating that comes off in the mouth and not the hand.
1 Like
They’ve obviously been working with the people who make M&Ms
2 Likes