How can I track down an issue with a locked table, endless query?

I have a table that is periodically getting locked in a manner that I don’t quite understand. I cannot do the following:

select * from thetable select count(*) from thetable 

There are roughly 2,000 records.

I can do the following:

select top 2000 * from thetable select * from thetable where ID = etc. 

Going backwards to find a new record that perhaps was problematic, incrementing the count in chunks until I can finally reproduce it again:

select top 1500 * from thetable order by ID desc select top 1550.... etc. and eventually it gets locked and never finishes the query. 

Query never finishes… have waited 10 minutes. Only resolution is to restart the service.

The related stored procedure that I thought caused the problem I ran manually (it interacts with this table) and the longest time it took was roughly 45 seconds. This particular procedure goes through many phases and is wrapped in a transaction with a try/catch/rollback/commit. There is no explicit locking set on the procedure.

Any direction or guidance to track down the root issue is greatly appreciated.

What are the potential risks of leaving a device in public, but locked?

Let’s say you’re in a public cafĂ©, or conference, where you trust your device won’t be stolen if you go to the bathroom for 5 minutes, but you don’t trust it might not be tampered with.

What are the potential security risks I might run into here, assuming I lock/log off my laptop’s (windows / mac / linux) user session, maybe even turn it off? Similar question for locked android/mobile devices as well.

It would be nice to include even unlikely but realistic scenarios, such as attacks that might take more than an hour or similar.

Which way locks? / Which way is locked?

This is in regards to every lock that turns 90-degrees. Meaning, not combination locks and unconventional locks. Let’s just restrict it to:

  • Deadlocks
  • Door locks
  • The keyhole on the other side of a door lock
  • keyholes in general

I guess this is two questions:

  1. Which way is locked? Vertical or horizontal?
  2. Which way locks? Clockwise or counter-clockwise?

I’ve seen doorknobs have all sorts of configurations of this, so it never feels natural to lock or unlock someone else’s door. The best thing for UX would be to have it be consistent across all locks. Are locks mostly consistent in these configurations or not?

[ Politics ] Open Question : Should the deep state generals be locked up for mocking the Chosen One?

Locked out of dedicated server because of chmod

So, I accidentally ran chmod -x / instead of what I meant to, and therefore broke a load of stuff on my server. Because of this, I can’t do things like log into the normal way, and am having to use other methods.

I tried this Fix permissions of server after accidental chmod but just got tons of permission issues that look a bit like “changing permission of ‘/proc/sys/net/etc..” and then it still does not work. I also get this for a lot of other directories.

If you could let me know how to fix this or any other information you need, that would be great.

How do I communicate to my players that a door is, for the time being, absolutely locked to them?

I have a small dungeon in my campaign, a temple, that is a significant location for the broader story of my world. The players might very well enter this temple pretty early on in their adventuring. There is a door in this temple, however, that must remain securely locked from to all intruders until a much later date – this temple, particularly what lies inside the locked door, will come back as an important location in the future. Ideally, for now this door will evoke mystery and intrigue for my players. However, I am worried that my players will be convinced that the locked door is some type of puzzle. How do I effectively communicate that this door is 100% locked to them, something to be revisited at a later date? How do I stop my players from wasting excessive time guessing passwords and looking for keys?

This is a question that probably fits many tabletop rpgs, but if it matters, we are playing D&D 5e in an pretty standard medieval fantasy setting.

Ubuntu 18.04 does not suspend using power button the the computer when screen is locked

I have a HTPC and it needs to be suspended with the convenience of the power button. Even when the screen lock appears on the display!After leaving the ubuntu 18.04 system idle for a while, it activates the screen lock. After doing so, the single press of the physical power button on the computer does not suspend it anymore.

How do attacks on password locked accounts work?

A lot of questions here are about the safety of passwords e.g a Login Password to an account on site X. But how can attackers get in the account when they have to guess the passwords? I know there is the “brute-force” method but most sites will simply lock the account, when there are too many false tries. So how get hackers access to the account?

Ubuntu 18.04 micro sd card locked readonly

I am running Ubuntu 18.04 on one desktop, and Windows 10 (19 something the latest version), on an old Dell Vostro-220 on another desktop. The mission is to flash an android OS onto a micro SD card for use in a Raspberry Pi 3B.

The SD card is a Samsung 32 Evo+ that has the Raspbian Stretch OS on it and the Pi works fine. I powered off the Pi and removed the Samsung SD card. I had the downloaded Android OS in a folder in my Dowloads directory. I plugged the card into an adapter (that has NO readolny switch), into the Ubuntu desktop. The card is found and the files are readable.

I am using Etcher to flash the OS onto the SD card. Etcher shows the card as “Locked”. The card is locked in a readonly state

I can not remove the folders, format, delete the partition, or write to the micro SD card. I tried:

  • gparted
  • disks
  • parted
  • guidus
  • dd commands
  • Changing permissions and ownership
  • disk manager in Windows
  • diskpart in windows
  • formatting in my Samsung Galaxy phone
  • maybe a few more “fixes” I can’t remember

Nothing has worked. I have created a ticket at Samsung but there is no one in customer service today, Saturday. Then I tried another used 32 gig mirco SD card that I had taken out of an old phone. I got the same result. I thought maybe because it was formatted in a phone that it was locked in readonly.

So I plugged in a brand new micro SD card. I opened Etcher to flash the Android OS to the brand new, never used, just out of the package, micro SD card, that has no switch, and got the same result. Etcher says the SD card is locked. It is in “readonly”. Nothing I have tried can make it writable. Three different cards, three different brands, 1 new, 2 used (but working fine before), I plugged them into the 18.04 desktop.

I have spent several hours searching for a solution, and tried many things. Has anyone actually solved this problem? Please advise.