keylock | Golang utility package which provides a way to lock a set | Keyboard library

Yesterday we lost contact with 10 identically configured servers, after some investigation the conclusion was that a reboot after security updates had failed.

We have so far not been able to get any of the servers back online, but were lucky enough to be able to reinstall the instances without data loss.

I will paste the console log below, can anyone help me determine the root cause and perhaps give me some advice on if there is a better way to configure the server to make recovery easier (like getting past the "Press Enter to continue." prompt, that it seems to hang in).

The full log is too big for SO, so I put it on pastebin and pasted a redacted version below. I have removed the escape sequences that colorize the output and removed some double new lines, but besides that it is complete.

I guess most deadlocks are unexpected, but even looking at the deadlock graph I still find the deadlock unexpected.

• Azure SQL Server.
• Table is very simple. Clustered index on primary key (Id) and no other indexes.
• All updates are on a single row identified by primary key.
• Multiple servers may be updating the table at the same time (usually only two, though).

Deadlock graph image:

This one deadlocks on page lock. I since added WITH (rowlock) hint, but I still get deadlocks, just on rows instead of pages. I used this example because it was the simplest graph I found.

It seems like the query is running in parallel (Exchange Event) and the different parallel processors are deadlocking each other, but I really wouldn't expect that to happen on something so simple.

Deadlock graph XML:

I'm currently investigating a deadlock issue on a heavily used database but still wasn't able to reproduce it even using concurrent ostress sessions or WHILE 1=1 EXEC StoredProcs. I'd be really glad anyone could shed some light on ways to reproduce it and also help me understand it's behavior.

There are two tables involved and they're partitioned by a hash in a computed column based on the original PK. They were partitioned due to page latch issues on INSERTs in the past.

Thanks to this nice article (Found it to be easier to do this way when doing several times - don't have to issue SELECTs and DBCC PAGE), while trying to reproduce the scenario, I found out that the INSERT statement acquires the following locks:

1. Obj-IS on tConn
2. Obj-IX on tVarConn
3. Page-IX on page from tVarConn
4. Key-RI_NL to the next %%lockres%% from tVarConn
5. Key-X on the %%lockres%% for the row being INSERTed
6. Page-IS on a page from tConn
7. Key-S on a %%lockres%% for the parent key value from tConn

And the DELETE's:

1. Obj-IX on tVarConn
2. Page-IX on tVarConn
3. Key-X on tVarConn (Several of them with different %%lockres%% since I have multiple rows for the nConn/HashID pair)

Plans: Insert Plan Delete Plan

Deadlock graph:

I am trying to solve a deadlock exception in a spring-boot application running with JPA. I get the following error in the spring boot log.

Lately, I am playing with keylock server. I have an application which has a bit of complication in the registration flow, and I need to change the basic flow of keycloak. Is this possible? For example, when a user fills the needed data, and clicks to register, I want to redirect him directly to my site and not to keycloak server ( profile manager ).

Also, I am trying to add a user via API, using 'node.js', which would be the easiest way. However, it seems I can't get it done. Does anyone have or know of some kind of tutorial, that can help me, or point me in the right direction?

EDIT:

What I tried is create bash script and add user via rest

I am working on a side project(student, not homework, just holiday curiosity), which would be my simple personal password manager/vault. It will be a windows app. I want it to support more than just one user. Now that i have my login screen and other functionalities, i struggle to find a simple and effective way to check if login and password of the user are correct. I store the information in a simple SQL table called Users(picture below). Now, i want to get the bool result, whether are these two strings (username,password) in database. i will include some code and screenshots below. Any help appreciated!

P.S.: I am pretty familiar with mySQL(Oracle), i just can´t fin a good way to do this without being ridiculous. :)

I am seeing all types of strange errors when running a dataflow job (Beam 2.12).

The job basically takes input from pubsub, read/writes from/to Datastore writes the result to pubsub.

Several Warnings W and Errors E appear in the Stackdriver logs. It is unclear how to resolve these. Up to now we were using Beam 2.9 and were not experiencing any of these issues.

A partial (redacted) log dump is available below.

I'm using Azure SQL + Java + Spring Boot 2. Currently I'm trying to understand the reason why deadlocks occur. In transaction I'm doing insert and later update on the same table but different rows. As far as I understood, SQL Server by default uses rowlock and the read_commited isolation.

Here is the deadlock details :

I need a monthly distribution of my data by using one single mysql statement. Expected result of the statement below: A table with 12 rows. If in one month no data is available it should return 0 for this month. However in the result of the current SQL Statement one or more rows are missing if data is missing. What I am Missing?