You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

Timothy Messier 3609658edd perf(session): Avoid select when canceling session (#5140) ... When a resource relating to a session is deleted, notably a target, host, or auth_token, the corresponding sessions are marked as canceled via a database trigger that calls the cancel_session function. This function was performing a select as part of the insert call to ensure that it would not attempt to insert a session_sate of canceled if it was an invalid state transition. However, since this function was first introduced, there has been additional constraints added that would prevent an invalid state transition. In addition, performing a select as part of an insert increases the chances for contention with other queries that interact with the session_state table, especially since a large number of sessions and session_state rows can be included in a single transaction when things like auth_tokens or targets get deleted. Now, the cancel_function will perform the insert, and catch any of the potential violations, allowing the query to continue without needing to perform the select, thus reduction the potential for contention.		2 years ago
..
cancel_session.sql	perf(session): Avoid select when canceling session (#5140)	2 years ago
delete_session_auth_token.sql	[COMPLIANCE] License changes (#3567)	3 years ago
delete_session_host.sql	[COMPLIANCE] License changes (#3567)	3 years ago
delete_session_host_set.sql	[COMPLIANCE] License changes (#3567)	3 years ago
delete_session_project.sql	[COMPLIANCE] License changes (#3567)	3 years ago
delete_session_target.sql	[COMPLIANCE] License changes (#3567)	3 years ago
delete_session_target_address.sql	[COMPLIANCE] License changes (#3567)	3 years ago
delete_session_user.sql	[COMPLIANCE] License changes (#3567)	3 years ago
invalid_state_transition.sql	[COMPLIANCE] License changes (#3567)	3 years ago
session_connection_ipv6.sql	add tests for sql ip address columns to ensure ipv6 capabiltiy (#5062)	2 years ago
session_connection_state_transition.sql	refact(session connection): remove session connection state table (#4617)	2 years ago
session_credential_canceling.sql	[COMPLIANCE] License changes (#3567)	3 years ago
session_credential_terminated.sql	[COMPLIANCE] License changes (#3567)	3 years ago
valid_state_transition_canceling.sql	[COMPLIANCE] License changes (#3567)	3 years ago
valid_state_transition_pending_active.sql	[COMPLIANCE] License changes (#3567)	3 years ago
valid_state_transition_pending_canceling.sql	[COMPLIANCE] License changes (#3567)	3 years ago
valid_state_transition_terminated.sql	[COMPLIANCE] License changes (#3567)	3 years ago