fix: omit explicit transaction in ConfirmLoginSession and add tracing #2024

Job	Run time
Run OIDC conformity tests	12m 29s
Generate SDKs	3m 35s
Run tests and lints	17m 16s
Run HSM tests	6m 52s
Run end-to-end tests (memory)	4m 53s
Run end-to-end tests (memory, --jwt)	5m 8s
Run end-to-end tests (postgres)	5m 3s
Run end-to-end tests (postgres, --jwt)	5m 7s
Run end-to-end tests (mysql)	5m 37s
Run end-to-end tests (mysql, --jwt)	5m 15s
Run end-to-end tests (cockroach)	5m 59s
Run end-to-end tests (cockroach, --jwt)	5m 27s
Build CLI docs	1m 0s
Generate changelog	0s
Generate release	0s
Draft newsletter	0s
Release SDKs	0s
Render version schema	0s
Pending approval Slack notification	0s
Send newsletter	0s
	1h 23m 41s

Provide feedback