[core] recreate offline database when it is deleted out from under our feet

3 files changed, 22 insertions, 14 deletions

diff --git a/platform/default/mbgl/storage/offline_database.cpp b/platform/default/mbgl/storage/offline_database.cpp
index 7516185f27..79bc3c8f27 100644
--- a/platform/default/mbgl/storage/offline_database.cpp
+++ b/platform/default/mbgl/storage/offline_database.cpp
@@ -79,8 +79,11 @@ void OfflineDatabase::initialize() {
 
 void OfflineDatabase::handleError(const mapbox::sqlite::Exception& ex, const char* action) {
     if (ex.code == mapbox::sqlite::ResultCode::NotADB ||
-        ex.code == mapbox::sqlite::ResultCode::Corrupt) {
-        // Corrupted; delete database so that we have a clean slate for the next operation.
+        ex.code == mapbox::sqlite::ResultCode::Corrupt ||
+        (ex.code == mapbox::sqlite::ResultCode::ReadOnly &&
+         ex.extendedCode == mapbox::sqlite::ExtendedResultCode::ReadOnlyDBMoved)) {
+        // The database was corruped, moved away, or deleted. We're going to start fresh with a
+        // clean slate for the next operation.
         Log::Error(Event::Database, static_cast<int>(ex.code), "Can't %s: %s", action, ex.what());
         try {
             removeExisting();
diff --git a/platform/default/sqlite3.cpp b/platform/default/sqlite3.cpp
index fed5a3a185..faaa85efd8 100644
--- a/platform/default/sqlite3.cpp
+++ b/platform/default/sqlite3.cpp
@@ -45,6 +45,10 @@ public:
     DatabaseImpl(sqlite3* db_)
         : db(db_)
     {
+        const int error = sqlite3_extended_result_codes(db, true);
+        if (error != SQLITE_OK) {
+            mbgl::Log::Warning(mbgl::Event::Database, error, "Failed to enable extended result codes: %s", sqlite3_errmsg(db));
+        }
     }
 
     ~DatabaseImpl()
diff --git a/platform/default/sqlite3.hpp b/platform/default/sqlite3.hpp
index 612e92acc6..16f76a0d1a 100644
--- a/platform/default/sqlite3.hpp
+++ b/platform/default/sqlite3.hpp
@@ -15,7 +15,7 @@ enum OpenFlag : int {
     ReadWriteCreate = 0b110,
 };
 
-enum class ResultCode : int {
+enum class ResultCode : uint8_t {
     OK = 0,
     Error = 1,
     Internal = 2,
@@ -40,24 +40,25 @@ enum class ResultCode : int {
     NoLFS = 22,
     Auth = 23,
     Range = 25,
-    NotADB = 26
+    NotADB = 26,
+};
+
+enum class ExtendedResultCode : uint8_t {
+    Unknown = 0,
+    ReadOnlyDBMoved = 4,
 };
 
 class Exception : public std::runtime_error {
 public:
-    Exception(int err, const char* msg)
-        : std::runtime_error(msg), code(static_cast<ResultCode>(err)) {
-    }
-    Exception(ResultCode err, const char* msg)
-        : std::runtime_error(msg), code(err) {
-    }
+    Exception(ResultCode err, const char* msg) : Exception(static_cast<int>(err), msg) {}
+    Exception(int err, const char* msg) : Exception(err, std::string{ msg }) {}
     Exception(int err, const std::string& msg)
-        : std::runtime_error(msg), code(static_cast<ResultCode>(err)) {
-    }
-    Exception(ResultCode err, const std::string& msg)
-        : std::runtime_error(msg), code(err) {
+        : std::runtime_error(msg),
+          code(static_cast<ResultCode>(err)),
+          extendedCode(static_cast<ExtendedResultCode>(err >> 8)) {
     }
     const ResultCode code = ResultCode::OK;
+    const ExtendedResultCode extendedCode = ExtendedResultCode::Unknown;
 };
 
 class DatabaseImpl;