1use std::collections::{BTreeMap, HashMap};
37use std::str::FromStr;
38use std::sync::atomic::{AtomicBool, Ordering};
39use std::sync::Arc;
40use std::time::{Duration, Instant, SystemTime, UNIX_EPOCH};
41
42use mongreldb_protocol::prepared::{PreparedStatementBinding, StatementId};
43use mongreldb_protocol::request::{AuthenticatedIdentity, IsolationLevel, SessionId};
44use mongreldb_protocol::session::{Session, TransactionState};
45use mongreldb_query::MongrelSession;
46use mongreldb_types::hlc::HlcTimestamp;
47use mongreldb_types::ids::{DatabaseId, TransactionId};
48
49pub struct SessionEntry {
51 session: std::sync::RwLock<Arc<MongrelSession>>,
56 pub owner: String,
59 last_used: std::sync::Mutex<Instant>,
60 pub lock: tokio::sync::Mutex<()>,
62 closed: AtomicBool,
67 record: std::sync::Mutex<Session>,
72 prepared_names: std::sync::Mutex<BTreeMap<String, StatementId>>,
76}
77
78impl SessionEntry {
79 pub fn session(&self) -> Arc<MongrelSession> {
82 self.session
83 .read()
84 .unwrap_or_else(|error| error.into_inner())
85 .clone()
86 }
87
88 pub(crate) fn replace_session(&self, session: MongrelSession) {
95 *self
96 .session
97 .write()
98 .unwrap_or_else(|error| error.into_inner()) = Arc::new(session);
99 }
100
101 pub(crate) fn touch(&self) {
102 if let Ok(mut t) = self.last_used.lock() {
103 *t = Instant::now();
104 }
105 if let Ok(mut record) = self.record.lock() {
106 record.last_activity_unix_micros = now_unix_micros();
107 }
108 }
109
110 pub(crate) fn is_closed(&self) -> bool {
112 self.closed.load(Ordering::Acquire)
113 }
114
115 fn mark_closed(&self) {
116 self.closed.store(true, Ordering::Release);
117 }
118
119 fn idle_for_at_least(&self, timeout: Duration) -> bool {
120 self.last_used
121 .lock()
122 .map(|t| t.elapsed() >= timeout)
123 .unwrap_or(false)
124 }
125
126 pub fn protocol_record(&self) -> Session {
129 self.record
130 .lock()
131 .map(|record| record.clone())
132 .unwrap_or_else(|error| error.into_inner().clone())
133 }
134
135 pub(crate) fn sync_record_after_request(&self, commit: Option<HlcTimestamp>) {
153 let Ok(mut record) = self.record.lock() else {
154 return;
155 };
156 record.last_activity_unix_micros = now_unix_micros();
157 let staging = self.session().staged_sql_operation_count().is_some();
158 match (&record.transaction_state, staging) {
159 (TransactionState::Idle, true) => {
160 record.transaction_state = TransactionState::Active {
161 transaction_id: TransactionId::new_random(),
162 isolation: IsolationLevel::Snapshot,
163 };
164 }
165 (TransactionState::Active { .. }, false) => {
166 record.transaction_state = TransactionState::Idle;
167 }
168 _ => {}
169 }
170 if let Some(commit_ts) = commit {
171 record.read_your_writes_token = Some(commit_ts);
172 }
173 }
174
175 pub(crate) fn allocate_statement_id(&self) -> StatementId {
178 let record = self
179 .record
180 .lock()
181 .unwrap_or_else(|error| error.into_inner());
182 let next = record
183 .prepared_statements
184 .keys()
185 .next_back()
186 .map_or(1, |id| id.get().saturating_add(1));
187 StatementId::new(next)
188 }
189
190 pub(crate) fn prepared_binding(
193 &self,
194 name: &str,
195 ) -> Option<(StatementId, PreparedStatementBinding)> {
196 let names = self
197 .prepared_names
198 .lock()
199 .unwrap_or_else(|error| error.into_inner());
200 let statement_id = names.get(name).copied()?;
201 let record = self
202 .record
203 .lock()
204 .unwrap_or_else(|error| error.into_inner());
205 record
206 .prepared_statements
207 .get(&statement_id)
208 .cloned()
209 .map(|binding| (statement_id, binding))
210 }
211
212 pub(crate) fn prepared_binding_by_id(
213 &self,
214 statement_id: u64,
215 ) -> Option<(String, PreparedStatementBinding)> {
216 let statement_id = StatementId::new(statement_id);
217 let name = self
218 .prepared_names
219 .lock()
220 .unwrap_or_else(|error| error.into_inner())
221 .iter()
222 .find_map(|(name, id)| (*id == statement_id).then(|| name.clone()))?;
223 let binding = self
224 .record
225 .lock()
226 .unwrap_or_else(|error| error.into_inner())
227 .prepared_statements
228 .get(&statement_id)
229 .cloned()?;
230 Some((name, binding))
231 }
232
233 pub(crate) fn insert_prepared_binding(&self, name: String, binding: PreparedStatementBinding) {
236 self.prepared_names
237 .lock()
238 .unwrap_or_else(|error| error.into_inner())
239 .insert(name, binding.statement_id);
240 self.record
241 .lock()
242 .unwrap_or_else(|error| error.into_inner())
243 .prepared_statements
244 .insert(binding.statement_id, binding);
245 }
246
247 pub(crate) fn remove_prepared_binding(&self, name: &str) -> Option<StatementId> {
249 let statement_id = self
250 .prepared_names
251 .lock()
252 .unwrap_or_else(|error| error.into_inner())
253 .remove(name)?;
254 self.record
255 .lock()
256 .unwrap_or_else(|error| error.into_inner())
257 .prepared_statements
258 .remove(&statement_id);
259 Some(statement_id)
260 }
261
262 #[cfg(test)]
264 pub(crate) fn prepared_statement_count(&self) -> usize {
265 self.record
266 .lock()
267 .map(|record| record.prepared_statements.len())
268 .unwrap_or(0)
269 }
270}
271
272pub(crate) fn now_unix_micros() -> u64 {
275 SystemTime::now()
276 .duration_since(UNIX_EPOCH)
277 .unwrap_or_default()
278 .as_micros()
279 .min(u128::from(u64::MAX)) as u64
280}
281
282pub struct SessionStore {
286 sessions: std::sync::Mutex<HashMap<String, Arc<SessionEntry>>>,
287 max_sessions: usize,
288 idle_timeout: Duration,
289 database_id: DatabaseId,
294}
295
296impl SessionStore {
297 pub fn new(max_sessions: usize, idle_timeout: Duration) -> Self {
300 Self::new_with_database_id(max_sessions, idle_timeout, DatabaseId::new_random())
301 }
302
303 pub fn new_with_database_id(
306 max_sessions: usize,
307 idle_timeout: Duration,
308 database_id: DatabaseId,
309 ) -> Self {
310 Self {
311 sessions: std::sync::Mutex::new(HashMap::new()),
312 max_sessions: max_sessions.max(1),
315 idle_timeout,
316 database_id,
317 }
318 }
319
320 pub fn database_id(&self) -> DatabaseId {
322 self.database_id
323 }
324
325 pub fn create(&self, session: MongrelSession, owner: String) -> Option<String> {
331 self.create_with_identity(session, owner, AuthenticatedIdentity::Credentialless)
332 }
333
334 pub fn create_with_identity(
337 &self,
338 session: MongrelSession,
339 owner: String,
340 principal: AuthenticatedIdentity,
341 ) -> Option<String> {
342 let mut guard = self.sessions.lock().ok()?;
343 if guard.len() >= self.max_sessions {
344 return None;
345 }
346 let token = random_token()?;
347 let session_id = SessionId::from_str(&token).unwrap_or(SessionId::ZERO);
350 let record = Session::new(session_id, principal, self.database_id, now_unix_micros());
351 guard.insert(
352 token.clone(),
353 Arc::new(SessionEntry {
354 session: std::sync::RwLock::new(Arc::new(session)),
355 owner,
356 last_used: std::sync::Mutex::new(Instant::now()),
357 lock: tokio::sync::Mutex::new(()),
358 closed: AtomicBool::new(false),
359 record: std::sync::Mutex::new(record),
360 prepared_names: std::sync::Mutex::new(BTreeMap::new()),
361 }),
362 );
363 Some(token)
364 }
365
366 pub fn get(&self, token: &str, owner: &str) -> Option<Arc<SessionEntry>> {
373 let guard = self.sessions.lock().ok()?;
374 let entry = guard.get(token)?;
375 if entry.owner != owner || entry.is_closed() {
376 return None;
377 }
378 Some(Arc::clone(entry))
379 }
380
381 pub(crate) fn get_by_token(&self, token: &str) -> Option<Arc<SessionEntry>> {
385 let guard = self.sessions.lock().ok()?;
386 let entry = guard.get(token)?;
387 (!entry.is_closed()).then(|| Arc::clone(entry))
388 }
389
390 pub(crate) fn close_by_token(&self, token: &str) -> bool {
391 let Ok(mut guard) = self.sessions.lock() else {
392 return false;
393 };
394 if let Some(entry) = guard.remove(token) {
395 entry.mark_closed();
396 true
397 } else {
398 false
399 }
400 }
401
402 pub fn close(&self, token: &str, owner: &str) -> bool {
406 self.take_for_close(token, owner).is_some()
407 }
408
409 pub(crate) fn take_for_close(&self, token: &str, owner: &str) -> Option<Arc<SessionEntry>> {
412 if let Ok(mut guard) = self.sessions.lock() {
413 if let Some(entry) = guard.get(token) {
414 if entry.owner != owner {
415 return None;
416 }
417 entry.mark_closed();
418 }
419 return guard.remove(token);
420 }
421 None
422 }
423
424 pub fn sweep_idle(&self) -> usize {
428 let Ok(mut guard) = self.sessions.lock() else {
429 return 0;
430 };
431 let timeout = self.idle_timeout;
432 let to_evict: Vec<String> = guard
437 .iter()
438 .filter_map(|(token, entry)| {
439 if entry.idle_for_at_least(timeout)
440 && entry.session().query_registry().active_for_session(token) == 0
441 && entry.lock.try_lock().is_ok()
442 {
443 Some(token.clone())
444 } else {
445 None
446 }
447 })
448 .collect();
449 let count = to_evict.len();
450 for token in &to_evict {
451 if let Some(entry) = guard.remove(token) {
452 entry.mark_closed();
453 }
454 }
455 count
456 }
457
458 pub fn len(&self) -> usize {
460 self.sessions.lock().map(|g| g.len()).unwrap_or(0)
461 }
462
463 pub fn is_empty(&self) -> bool {
464 self.len() == 0
465 }
466
467 pub(crate) fn close_all(&self) {
469 if let Ok(mut guard) = self.sessions.lock() {
470 for entry in guard.values() {
471 entry.mark_closed();
472 }
473 guard.clear();
474 }
475 }
476}
477
478pub fn spawn_session_reaper(store: Arc<SessionStore>) {
482 std::thread::Builder::new()
483 .name("mongreldb-session-reaper".into())
484 .spawn(move || loop {
485 std::thread::sleep(Duration::from_secs(30));
486 let evicted = store.sweep_idle();
487 if evicted > 0 {
488 eprintln!("[session-reaper] evicted {evicted} idle session(s)");
489 }
490 })
491 .expect("spawn session-reaper");
492}
493
494fn random_token() -> Option<String> {
500 let bytes = read_urandom(16)?;
501 let mut n = 0u128;
502 for &b in &bytes {
503 n = (n << 8) | b as u128;
504 }
505 Some(format!("{n:032x}"))
506}
507
508fn read_urandom(n: usize) -> Option<Vec<u8>> {
509 use std::io::Read;
510 let mut f = std::fs::File::open("/dev/urandom").ok()?;
511 let mut buf = vec![0u8; n];
512 f.read_exact(&mut buf).ok()?;
513 Some(buf)
514}
515
516#[cfg(test)]
517mod tests {
518 use super::*;
519 use mongreldb_core::Database;
520 use mongreldb_query::{RegisteredQueryGuard, SqlQueryOptions};
521 use tempfile::tempdir;
522
523 fn make_session() -> MongrelSession {
524 let dir = tempdir().unwrap();
525 let db = Arc::new(Database::create(dir.path()).unwrap());
526 std::mem::forget(dir);
529 MongrelSession::open(db).unwrap()
530 }
531
532 #[test]
533 fn create_and_get_roundtrip() {
534 let store = SessionStore::new(8, Duration::from_secs(60));
535 let token = store.create(make_session(), "alice".into()).unwrap();
536 assert!(store.get(&token, "alice").is_some());
537 assert!(store.get(&token, "eve").is_none());
539 assert_eq!(store.len(), 1);
540 }
541
542 #[test]
543 fn close_removes_session() {
544 let store = SessionStore::new(8, Duration::from_secs(60));
545 let token = store.create(make_session(), "alice".into()).unwrap();
546 assert!(store.close(&token, "alice"));
547 assert!(store.get(&token, "alice").is_none());
548 assert!(store.is_empty());
549 let t2 = store.create(make_session(), "bob".into()).unwrap();
551 assert!(!store.close(&t2, "alice"));
552 assert_eq!(store.len(), 1);
553 }
554
555 #[test]
556 fn capacity_limit_rejects_new_sessions() {
557 let store = SessionStore::new(1, Duration::from_secs(60));
558 assert!(store.create(make_session(), "a".into()).is_some());
559 assert!(store.create(make_session(), "b".into()).is_none());
561 assert_eq!(store.len(), 1);
562 }
563
564 #[test]
565 fn sweep_idle_evicts_stale_sessions() {
566 let store = SessionStore::new(8, Duration::from_millis(1));
567 let token = store.create(make_session(), "alice".into()).unwrap();
568 assert_eq!(store.len(), 1);
569 std::thread::sleep(Duration::from_millis(20));
571 let evicted = store.sweep_idle();
572 assert_eq!(evicted, 1);
573 assert!(store.get(&token, "alice").is_none());
574 assert!(store.is_empty());
575 }
576
577 #[test]
578 fn sweep_idle_keeps_active_queries() {
579 let store = SessionStore::new(8, Duration::from_millis(1));
580 let token = store.create(make_session(), "alice".into()).unwrap();
581 let entry = store.get(&token, "alice").unwrap();
582 let query = entry
583 .session()
584 .register_query(SqlQueryOptions {
585 session_id: Some(token.clone()),
586 ..SqlQueryOptions::default()
587 })
588 .unwrap();
589 let query = RegisteredQueryGuard::new(query);
590 std::thread::sleep(Duration::from_millis(20));
591
592 assert_eq!(store.sweep_idle(), 0);
593 assert!(store.get(&token, "alice").is_some());
594
595 drop(query);
596 assert_eq!(store.sweep_idle(), 1);
597 assert!(store.is_empty());
598 }
599
600 #[test]
601 fn protocol_record_carries_identity_database_and_session_id() {
602 let database_id = DatabaseId::new_random();
603 let store = SessionStore::new_with_database_id(8, Duration::from_secs(60), database_id);
604 let identity = AuthenticatedIdentity::CatalogUser {
605 username: "alice".to_owned(),
606 user_id: 42,
607 created_version: 7,
608 };
609 let token = store
610 .create_with_identity(make_session(), "alice".into(), identity.clone())
611 .unwrap();
612 let entry = store.get(&token, "alice").unwrap();
613 let record = entry.protocol_record();
614 assert_eq!(record.session_id, SessionId::from_str(&token).unwrap());
615 assert_eq!(record.principal, identity);
616 assert_eq!(record.current_database, database_id);
617 assert_eq!(record.transaction_state, TransactionState::Idle);
618 assert!(record.prepared_statements.is_empty());
619 assert!(record.settings.is_empty());
620 assert_eq!(record.read_your_writes_token, None);
621 assert!(record.last_activity_unix_micros > 0);
622 assert_eq!(store.database_id(), database_id);
623 }
624
625 #[test]
626 fn sync_record_tracks_commit_and_activity() {
627 let store = SessionStore::new(8, Duration::from_secs(60));
628 let token = store.create(make_session(), "alice".into()).unwrap();
629 let entry = store.get(&token, "alice").unwrap();
630 let before = entry.protocol_record().last_activity_unix_micros;
631 std::thread::sleep(Duration::from_millis(2));
632
633 let commit_ts = HlcTimestamp {
634 physical_micros: now_unix_micros().saturating_sub(1_000),
635 logical: 3,
636 node_tiebreaker: 0,
637 };
638 entry.sync_record_after_request(Some(commit_ts));
639 let record = entry.protocol_record();
640 assert!(record.last_activity_unix_micros >= before);
641 assert_eq!(
642 record.read_your_writes_token,
643 Some(commit_ts),
644 "a committed request must advance the read-your-writes token to the commit timestamp"
645 );
646
647 assert_eq!(record.transaction_state, TransactionState::Idle);
649
650 entry.sync_record_after_request(None);
652 assert_eq!(
653 entry.protocol_record().read_your_writes_token,
654 Some(commit_ts)
655 );
656 }
657
658 #[test]
659 fn prepared_bindings_are_tracked_by_name_and_id() {
660 let store = SessionStore::new(8, Duration::from_secs(60));
661 let token = store.create(make_session(), "alice".into()).unwrap();
662 let entry = store.get(&token, "alice").unwrap();
663
664 let first = entry.allocate_statement_id();
665 assert_eq!(first, StatementId::new(1));
666 let mut binding = PreparedStatementBinding {
667 statement_id: first,
668 sql: "SELECT 1".to_owned(),
669 parameter_types: vec![],
670 catalog_version: mongreldb_types::ids::MetadataVersion::new(3),
671 schema_versions: BTreeMap::new(),
672 feature_set: Default::default(),
673 };
674 entry.insert_prepared_binding("stmt_a".to_owned(), binding.clone());
675 assert_eq!(entry.prepared_statement_count(), 1);
676 assert_eq!(
677 entry.prepared_binding("stmt_a"),
678 Some((first, binding.clone()))
679 );
680
681 let second = entry.allocate_statement_id();
683 assert_eq!(second, StatementId::new(2));
684 binding.statement_id = second;
685 entry.insert_prepared_binding("stmt_b".to_owned(), binding);
686
687 assert_eq!(entry.remove_prepared_binding("stmt_a"), Some(first));
688 assert_eq!(entry.prepared_binding("stmt_a"), None);
689 assert_eq!(entry.prepared_statement_count(), 1);
690 assert_eq!(entry.protocol_record().prepared_statements.len(), 1);
691 assert_eq!(entry.remove_prepared_binding("stmt_a"), None);
693 }
694}