Initial backup stuck at 100%

projeculatort · September 18, 2020, 8:18pm

I ended up killing Duplicati since it seemed unlikely to finish. I tested running ANALYZE on the database and the query went from hanging indefinitely to completing in seconds. Doing this changed the query plan from SCAN to SEARCH.

I see that Duplicati is already using PRAGMA optimize:

github.com

duplicati/duplicati/blob/174edf422ec828cf0802366470c9e39ad2293930/Duplicati/Library/Main/Database/LocalDatabase.cs#L1379




if (ShouldCloseConnection && m_connection != null)

{

    if (m_connection.State == System.Data.ConnectionState.Open)

    {

        using (IDbTransaction transaction = m_connection.BeginTransaction())

        {

            using (IDbCommand command = m_connection.CreateCommand(transaction))

            {

                // SQLite recommends that PRAGMA optimize is run just before closing each database connection.

                command.ExecuteNonQuery("PRAGMA optimize");

                transaction.Commit();

            }

        }



        m_connection.Close();

    }



    m_connection.Dispose();

}

Maybe this needs the chance to run earlier?

After restarting Duplicati, it verified successfully and did not need to reupload any data.