libsql
diff --git a/‎sqld/src/error.rs
Lines changed: 31 additions & 5 deletions b/‎sqld/src/error.rs
Lines changed: 31 additions & 5 deletions
diff --git a/‎sqld/src/namespace/mod.rs
Lines changed: 50 additions & 17 deletions b/‎sqld/src/namespace/mod.rs
Lines changed: 50 additions & 17 deletions
@@ -147,10 +147,32 @@ impl From<bincode::Error> for Error {
     }
 }
 
+macro_rules! internal_from {
+    ($to:ty  => { $($from:ty,)* }) => {
+        $(
+            impl From<$from> for $to {
+                fn from(v: $from) -> Self {
+                    <$to>::Internal(v.to_string())
+                }
+            }
+        )*
+        
+    };
+}
+
+internal_from! {
+    LoadDumpError => {
+        std::io::Error,
+        rusqlite::Error,
+        hyper::Error,
+        tokio::task::JoinError,
+    }
+}
+
 #[derive(Debug, thiserror::Error)]
 pub enum LoadDumpError {
-    #[error("IO error: {0}")]
-    Io(#[from] std::io::Error),
+    #[error("internal error: {0}")]
+    Internal(String),
     #[error("Cannot load a dump on a replica")]
     ReplicaLoadDump,
     #[error("cannot load from a dump if a database already exists")]
@@ -161,10 +183,12 @@ pub enum LoadDumpError {
     DumpFileDoesntExist,
     #[error("invalid dump url")]
     InvalidDumpUrl,
-    #[error("error fetching dump: {0}")]
-    Fetch(#[from] hyper::Error),
     #[error("unsupported dump url scheme `{0}`, supported schemes are: `http`, `file`")]
     UnsupportedUrlScheme(String),
+    #[error("a dump should execute within a transaction.")]
+    NoTxn,
+    #[error("the dump should commit the transaction.")]
+    NoCommit,
 }
 
 impl ResponseError for LoadDumpError {}
@@ -174,12 +198,14 @@ impl IntoResponse for LoadDumpError {
         use LoadDumpError::*;
 
         match &self {
-            Io(_) | Fetch(_) => self.format_err(StatusCode::INTERNAL_SERVER_ERROR),
+            Internal(_) => self.format_err(StatusCode::INTERNAL_SERVER_ERROR),
             ReplicaLoadDump
             | LoadDumpExistingDb
             | InvalidDumpUrl
             | DumpFileDoesntExist
             | UnsupportedUrlScheme(_)
+            | NoTxn
+            | NoCommit
             | DumpFilePathNotAbsolute => self.format_err(StatusCode::BAD_REQUEST),
         }
     }
 
@@ -4,19 +4,20 @@ use std::fmt;
 use std::path::{Path, PathBuf};
 use std::sync::{Arc, Weak};
 
-use anyhow::{bail, Context as _, ensure};
+use anyhow::Context as _;
 use async_lock::{RwLock, RwLockUpgradableReadGuard};
 use bottomless::replicator::Options;
 use bytes::Bytes;
 use chrono::NaiveDateTime;
 use enclose::enclose;
 use futures_core::Stream;
 use hyper::Uri;
+use parking_lot::Mutex;
 use rusqlite::ErrorCode;
 use sqld_libsql_bindings::wal_hook::TRANSPARENT_METHODS;
 use tokio::io::AsyncBufReadExt;
 use tokio::sync::watch;
-use tokio::task::{block_in_place, JoinSet};
+use tokio::task::JoinSet;
 use tokio::time::Duration;
 use tokio_util::io::StreamReader;
 use tonic::transport::Channel;
@@ -76,7 +77,10 @@ impl NamespaceName {
     }
 
     pub fn as_str(&self) -> &str {
-        std::str::from_utf8(&self.0).unwrap()
+        // Safety: the namespace is always valid UTF8
+        unsafe {
+            std::str::from_utf8_unchecked(&self.0)
+        }
     }
 
     pub fn from_bytes(bytes: Bytes) -> crate::Result<Self> {
@@ -476,6 +480,7 @@ impl<M: MakeNamespace> NamespaceStore<M> {
             )
             .await?;
 
+
         let mut lock = RwLockUpgradableReadGuard::upgrade(lock).await;
         tracing::info!("loaded namespace: `{namespace}`");
         lock.insert(namespace, ns);
@@ -640,6 +645,25 @@ impl Namespace<PrimaryDatabase> {
         name: NamespaceName,
         restore_option: RestoreOption,
         allow_creation: bool,
+    ) -> crate::Result<Self> {
+        // FIXME: make that truly atomic. explore the idea of using temp directories, and it's implications
+        match Self::try_new_primary(config, name.clone(), restore_option, allow_creation).await {
+            Ok(ns) => Ok(ns),
+            Err(e) => {
+                let path = config.base_path.join("dbs").join(name.as_str());
+                if let Err(e) = tokio::fs::remove_dir_all(path).await {
+                    tracing::error!("failed to clean dirty namespace: {e}");
+                }
+                Err(e)
+            }
+        }
+    }
+
+    async fn try_new_primary(
+        config: &PrimaryNamespaceConfig,
+        name: NamespaceName,
+        restore_option: RestoreOption,
+        allow_creation: bool,
     ) -> crate::Result<Self> {
         // if namespaces are disabled, then we allow creation for the default namespace.
         let allow_creation =
@@ -842,22 +866,24 @@ async fn load_dump<S>(
     dump: S,
     mk_ctx: impl Fn() -> ReplicationLoggerHookCtx,
     auto_checkpoint: u32,
-) -> anyhow::Result<()>
+) -> crate::Result<(), LoadDumpError>
 where
     S: Stream<Item = std::io::Result<Bytes>> + Unpin,
 {
     let mut retries = 0;
     // there is a small chance we fail to acquire the lock right away, so we perform a few retries
     let conn = loop {
-        match block_in_place(|| {
+        let ctx = mk_ctx();
+        let db_path = db_path.to_path_buf();
+        match tokio::task::spawn_blocking(move || {
             open_conn(
-                db_path,
+                &db_path,
                 &REPLICATION_METHODS,
-                mk_ctx(),
+                ctx,
                 None,
                 auto_checkpoint,
             )
-        }) {
+        }).await? {
             Ok(conn) => {
                 break conn;
             }
@@ -874,12 +900,12 @@ where
                 retries += 1;
                 tokio::time::sleep(Duration::from_millis(100)).await;
             }
-            Err(e) => {
-                bail!(e);
-            }
+            Err(e) => Err(e)?,
         }
     };
 
+    let conn = Arc::new(Mutex::new(conn));
+
     let mut reader = tokio::io::BufReader::new(StreamReader::new(dump));
     let mut curr = String::new();
     let mut line = String::new();
@@ -911,20 +937,27 @@ where
 
         if line.ends_with(';') {
             n_stmt += 1;
-            if n_stmt > 2 {
-                ensure!(!conn.is_autocommit(), "a dump should execute within a transaction.");
+            // dump must be performd within a txn
+            if n_stmt > 2  && conn.lock().is_autocommit() {
+                return Err(LoadDumpError::NoTxn);
             }
 
-            block_in_place(|| conn.execute(&line, ()))?;
+            line = tokio::task::spawn_blocking({
+                let conn = conn.clone();
+                move || -> crate::Result<String, LoadDumpError> { 
+                    conn.lock().execute(&line, ())?;
+                    Ok(line)
+                }
+            }).await??;
             line.clear();
         } else {
             line.push(' ');
         }
     }
 
-    if !conn.is_autocommit() {
-        let _ = conn.execute("rollback", ());
-        bail!("the dump should commit the transaction.");
+    if !conn.lock().is_autocommit() {
+        let _ = conn.lock().execute("rollback", ());
+        return Err(LoadDumpError::NoCommit);
     }
 
     Ok(())