Error: too many SQL variables

Support
1

**System was rebooted and duplicati didn’t auto-run for whatever reason. Now that I have launched duplicati, I’ve noticed I haven’t had a good backup in quite some time. I’m receiving this error message each time.

[Error-Duplicati.Library.Main.Controller-FailedOperation]: The operation Backup has failed\r\nSqliteException: SQLite Error 1: ‘too many SQL variables’."

I tried updating to the newest canary build, but not luck. Is there anything in particular I can check to see why I’m receiving this message?**

2

Hi @Kingme024, welcome to the forum :waving_hand:

Can you try to look in “About Duplicati” → “Logs” and see if you can get a longer error message?
There should be an error logged with a full stack trace that we can use to figure out where the error occurs specifically, and hopefully then reproduce+fix the issue.

3

Hello,

Here is the most recent error:
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: ‘too many SQL variables’.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)
— End of stack trace from previous location —
at Duplicati.Library.Main.Database.LocalDatabase.RemoveRemoteVolumes(IEnumerable1 names, CancellationToken token) at Duplicati.Library.Main.Database.LocalDatabase.RemoveRemoteVolumes(IEnumerable1 names, CancellationToken token)
at Duplicati.Library.Main.Operation.FilelistProcessor.RemoteListAnalysis(IBackendManager backendManager, Options options, LocalDatabase database, IBackendWriter log, IEnumerable1 protectedFiles, IEnumerable1 strictExcemptFiles, VerifyMode verifyMode, CancellationToken cancellationToken)
at Duplicati.Library.Main.Operation.FilelistProcessor.VerifyRemoteList(IBackendManager backend, Options options, LocalDatabase database, IBackendWriter log, IEnumerable1 protectedFiles, IEnumerable1 strictExcemptFiles, Boolean logErrors, VerifyMode verifyMode, CancellationToken cancellationToken)
at Duplicati.Library.Main.Operation.BackupHandler.PreBackupVerify(Options options, BackupResults result, IBackendManager backendManager)
at Duplicati.Library.Main.Operation.BackupHandler.RunAsync(String sources, IBackendManager backendManager, IFilter filter)
at Duplicati.Library.Main.Controller.<>c__DisplayClass22_0.<b__0>d.MoveNext()
— End of stack trace from previous location —
at Duplicati.Library.Utility.Utility.Await(Task task)
at Duplicati.Library.Main.Controller.RunAction[T](T result, String& paths, IFilter& filter, Func`3 method)
at Duplicati.Library.Main.Controller.Backup(String inputsources, IFilter filter)
at Duplicati.Server.Runner.RunInternal(Connection databaseConnection, EventPollNotify eventPollNotify, INotificationUpdateService notificationUpdateService, IProgressStateProviderService progressStateProviderService, IApplicationSettings applicationSettings, IRunnerData data, Boolean fromQueue)
Feb 8, 2026, 12:08:47 AM

Thank you

4

Thanks for reporting the stack trace!

I have now found and fixed the issue:

This will be included in the next canary build.

5

@kenkendk Thank you!

6

I wonder if my case would be also covered

code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error
too many SQL variables
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at Duplicati.Library.Main.Database.LocalDatabase.RemoveRemoteVolumes(IEnumerable`1 names, IDbTransaction transaction)
   at Duplicati.Library.Main.Operation.FilelistProcessor.RemoteListAnalysis(IBackendManager backendManager, Options options, LocalDatabase database, IDbTransaction transaction, IBackendWriter log, IEnumerable`1 protectedFiles, IEnumerable`1 strictExcemptFiles, VerifyMode verifyMode)
   at Duplicati.Library.Main.Operation.FilelistProcessor.VerifyRemoteList(IBackendManager backend, Options options, LocalDatabase database, IDbTransaction transaction, IBackendWriter log, IEnumerable`1 protectedFiles, IEnumerable`1 strictExcemptFiles, Boolean logErrors, VerifyMode verifyMode)
   at Duplicati.Library.Main.Operation.BackupHandler.PreBackupVerify(Options options, BackupResults result, IBackendManager backendManager)
   at Duplicati.Library.Main.Operation.BackupHandler.RunAsync(String[] sources, IBackendManager backendManager, IFilter filter)
   at Duplicati.Library.Main.Controller.<>c__DisplayClass22_0.<<Backup>b__0>d.MoveNext()
--- End of stack trace from previous location ---
   at Duplicati.Library.Utility.Utility.Await(Task task)
   at Duplicati.Library.Main.Controller.RunAction[T](T result, String[]& paths, IFilter& filter, Func`3 method)
   at Duplicati.Library.Main.Controller.Backup(String[] inputsources, IFilter filter)
   at Duplicati.Server.Runner.RunInternal(Connection databaseConnection, EventPollNotify eventPollNotify, INotificationUpdateService notificationUpdateService, IProgressStateProviderService progressStateProviderService, IApplicationSettings applicationSettings, IRunnerData data, Boolean fromQueue)
7

Hi @airart320, welcome to the forum :waving_hand:

Yes, that is the same issue. It is fixed in the latest canary build