I tried some different retention-policy values but every try raised an error?
14D:0s,1M:1D,1Y:1W,99Y:2W
14D:0s,1M:1D,1Y:1W,U:2W
7D:1h,4W:1D,1Y:1W,99Y:2W
7D:U,4W:1D,1Y:1W,U:2W
What is the problem? If I change it back to “keep forever” the backups runs without failure?
Error:
Backup started at 30.07.2019 11:55:23
Checking remote backup ...
Listing remote folder ...
Scanning local files ...
931 files need to be examined (202,05 MB)
Fatal error => SQL logic error or missing database
too many SQL variables
System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
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 Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery(IDbCommand self, Boolean writeLog, String cmd, Object[] values)
at Duplicati.Library.Main.Database.LocalDeleteDatabase. <DropFilesetsFromTable>d__5.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Duplicati.Library.Main.Operation.DeleteHandler.DoRun(LocalDeleteDatabase db, IDbTransaction& transaction, Boolean hasVerifiedBacked, Boolean forceCompact,
BackendManager sharedManager)
at Duplicati.Library.Main.Operation.BackupHandler.CompactIfRequired(BackendManager backend, Int64 lastVolumeSize)
at Duplicati.Library.Main.Operation.BackupHandler.<RunAsync>d__19.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at CoCoL.ChannelExtensions.WaitForTaskOrThrow(Task task)
at Duplicati.Library.Main.Controller.<>c__DisplayClass13_0. <Backup>b__0(BackupResults result)
at Duplicati.Library.Main.Controller.RunAction[T](T result, String[]& paths, IFilter& filter, Action`1 method)
at Duplicati.Library.Main.Controller.Backup(String[] inputsources, IFilter filter)
at Duplicati.CommandLine.Commands.Backup(TextWriter outwriter, Action`1 setup, List`1 args, Dictionary`2 options, IFilter filter)
at Duplicati.CommandLine.Program.ParseCommandLine(TextWriter outwriter, Action`1 setup, Boolean& verboseErrors, String[] args)
at Duplicati.CommandLine.Program.RunCommandLine(TextWriter outwriter, TextWriter errwriter, Action`1 setup, String[] args)
And here the complete command line (without passwords aso), I use the Beta from November:
"C:\Program Files\Duplicati 2\Duplicati.CommandLine.exe"
backup
"googledrive:"
"\\server\share\folder"
--upload-verification-file="true"
--backup-test-samples="0"
--backup-name="google"
--dbpath="C:\Users\xxx\AppData\Local\Duplicati\jobdbs\xxxx.sqlite"
--encryption-module="aes"
--compression-module="zip"
--dblock-size="250MB"
--passphrase="xxx"
--retention-policy="7D:U,1M:1D,1Y:1W,U:1M"
--send-http-url="https://www.duplicati-monitoring.com/log/..."
--allow-missing-source="true"
--full-remote-verification="true"
--disable-module="console-password-input"
--exclude="*\dataConfig\\"
--exclude="*\dataEvents\\"
New Information: It seems that too many Backups should be deleted! So Duplicati should handle this and make a loop or so to delete. About 1700 backups are too much for a single statement.
ExecuteNonQuery: DELETE FROM "Fileset" WHERE "Timestamp" IN (1563865092,1563822395,1563729158,1563695977,1562786734,1562436921,1562417061,1562402801,1562366241,1562333663,1562267555,1562051374,1561968246,1561803775,1561725288,1561535803,1561488943,1561456353,1561413795,1561322160,1561193939,1561156302,1561122162,1561074808,1560980889,1560947129,1560901884,1560861459,1560818635,1560769289,1560732672,1560699530,1560646351,1560612734,1560523070,1560490478,1560426079,1560390338,1560357726,1560325146,1560289292,1560218369,1560185703,1560098146,1560013228,1559980322,1559917787,1559861340,1559828747,1559793005,1559758131,1559725474,1559682485,1559649881,1559613841,1559581243,1559548589,1559310042,1559277103,1559244495,1559211867,1559145328,1559112702,1558796985,1558755400,1558722581,1558689819,1558623595,1558590952,1558548888,1558516267,1558480816,1558447652,1558415051,1558382011,1558349359,1558279877,1558247286,1558155266,1558122628,1558088848,1558047430,1558014619,1557981664,1557948701,1557913906,1557864845,1557832221,1557796573,1557763938,1557731251,1557695726,1557493505,1557456148,1557423502,1557390880,1557355158,1557322490,1557289891,1557257308,1557224703,1557187796,1557155125,1557118888,1557086291,1556973121,1556933744,1556887482,1556851979,1556819341,1556786745,1556749901,1556629950,1556590210,1556557616,1556525037,1556497520,1556464750,1556423332,1556389921,1556357288,1556318957,1556286338,1556251757,1556219118,1556164227,1556097025,1556060025,1556027406,1555991790,1555959183,1555815082,1555782151,1555749551,1555713624,1555681035,1555648447,1555615846,1555583269,1555505126,1555469700,1555437102,1555402404,1555366522,1555333921,1555301343,1555268747,1555178434,1555145766,1555110390,1555077780,1554816075,1554780669,1554747518,1554714932,1554679158,1554641929,1554606635,1554574026,1554541374,1554506068,1554427296,1554394684,1554362079,1554297979,1554265325,1554225093,1554192490,1554132617,1553877554,1553844956,1553808091,1553751107,1553707506,1553674896,1553638015,1553605391,1553570038,1553516267,1553480921,1553411359,1553345665,1553310229,1553277598,1553245001,1553203808,1553171122,1553131149,1553098565,1552976708,1552914007,1552850913,1552814501,1552766662,1552657762,1552613660,1552573770,1552540960,1552508137,1552475356,1552403004,1552332152,1552299325,1552066402,1552033622,1552004243,1551968608,1551927194,1551883660,1551842245,1551800068,1551767289,1551730134,1551697258,1551465710,1551353538,1551279341,1551246483,1551213671,1551180860,1551145487,1551112587,1551079585,1551044538,1551011795,1550940909,1550900869,1550868248,1550835653,1550770856,1550702636,1550670043,1550632867,1550600254,1550567530,1550532427,1550499032,1550466437,1550427497,1550394892,1550357837,1550325239,1550239532,1550206932,1550170871,1550138286,1550103261,1550066813,1550034226,1550001604,1549968750,1549932107,1549892370,1549857208,1549824623,1549650283,1549617684,1549582695,1549550079,1549515073,1549482491,1549449916,1549381943,1549379989,1549347407,1549291566,1549258959,1549120802,1549088021,1549053621,1548976012,1548943431,1548908433,1548865756,1548829125,1548766931,1548731987,1548695507,1548662908,1548626657,1548515362,1548450119,1548235125,1548200216,1548160143,1548125212,1548092624,1548059708,1547926278,1547891489,1547814082,1547742162,1547685998,1547653347,1547595401,1547562822,1547530227,1547497615,1547462675,1547290617,1547010430,1546977793,1546945109,1546910194,1546877554,1546782207,1546718496,1546685781,1546635771,1546603156,1546553274,1546520694,1546452723,1546403632,1546353675,1546272503,1546086959,1546017707,1545912797,1545854610,1545839881,1545825256,1545810661,1545794130,1545777254,1545762660,1545748071,1545733493,1545718919,1545702345,1545685749,1545671094,1545655451,1545601676,1545495371,1545480769,1545466153,1545413808,1545398521,1545339452,1545324853,1545310251,1545295617,1545255743,1545236530,1545221935,1545207357,1545186722,1545169602,1545153503,1545137242,1545122455,1545066231,1545046824,1544984101,1544966737,1544917040,1544898824,1544881355,1544865447,1544820696,1544806087,1544759508,1544740360,1544718880,1544703983,1544689394,1544672894,1544656286,1544632542,1544617961,1544603381,1544581785,1544565299,1544543826,1544527287,1544512691,1544496216,1544479738,1544465124,1544448784,1544434140,1544417600,1544400946,1544386339,1544371288,1544294636,1544279920,1544205580,1544190012,1544175373,1544127957,1544113316,1544091591,1544075503,1544027384,1544012274,1543997606,1543868518,1543847915,1543830998,1543811643,1543794892,1543777814,1543762909,1543744704,1543704618,1543604098,1543589478,1543572863,1543534026,1543519413,1543504777,1543490154,1543475527,1543437355,1543422485,1543407832,1543393209,1543372736,1543352351,1543335548,1543320925,1543302989,1543286421,1543267828,1543250346,1543249432,1543240773,1543220109,1543171845,1543157275,1543142724,1543085297,1543067543,1543000871,1542986255,1542971683,1542957105,1542942539,1542927956,1542913383,1542889393,1542874824,1542860257,1542845704,1542831127,1542815814,1542801241,1542786681,1542772037,1542756071,1542741492,1542726351,1542711798,1542696671,1542646353,1542630613,1542626949,1542625129,1542471205,1542463872,1542449067,1542394487,1542306797,1542291893,1542275006,1542219037,1542204102,1542189252,1542145929,1542131279,1542048713,1542033039,1542018177,1542003291,1541988437,1541973573,1541884299,1541869622,1541854977,1541792311,1541777727,1541762452,1541711509,1541696471,1541681502,1541666684,1541624905,1541610312,1541595723,1541579788,1541565163,1541550588,1541535948,1541521341,1541506767,1541492190,1541445165,1541430488,1541404492,1541383776,1541369014,1541354442,1541339341,1541324744,1541278601,1541263617,1540646389,1540579146,1540564560,1540547690,1540499255,1540481039,1540466140,1540451494,1540436957,1540422352,1540407280,1540391416,1540376462,1540361545,1540345522,1540328903,1540312014,1540297073,1540280364,1540239257,1540224698,1540210152,1540195604,1540143674,1540129129,1540114591,1540057914,1540043355,1539975087,1539960546,1539945641,1539930536,1539915983,1539901412,1539886843,1539872216,1539857676,1539843135,1539828596,1539797015,1539782466,1539767855,1539707903,1539693058,1539678261,1539611419,1539596628,1539581721,1539566928,1539460376,1539445837,1539429207,1539374821,1539360280,1539345730,1539329894,1539315281,1539300008,1539285455,1539270913,1539256369,1539241791,1539227256,1539212705,1539197723,1539183178,1539168594,1539153952,1539137552,1539123006,1539108430,1539093844,1539079200,1539064638,1539050073,1539035458,1539020853,1539006286,1538990671,1538976110,1538961558,1538946846,1538932253,1538912596,1538898011,1538863340,1538848729,1538834148,1538769329,1538754363,1538739481,1538724596,1538688151,1538673193,1538658321,1538643550,1538628986,1538614409,1538598644,1538583274,1538567821,1538553066,1538514290,1538499706,1538485074,1538470488,1538400992,1538340333,1538325786,1538311210,1538296636,1538243878,1538229326,1538214740,1538200169,1538161058,1538146488,1538131932,1538117264,1538064752,1538050080,1538035057,1537980134,1537965543,1537950927,1537901725,1537884902,1537869991,1537855094,1537805126,1537790278,1537775334,1537637805,1537617373,1537556301,1537541750,1537524821,1537509894,1537495065,1537480238,1537465672,1537449904,1537435334,1537420792,1537406250,1537391698,1537376446,1537361173,1537346614,1537332038,1537317501,1537302957,1537285559,1537270757,1537255841,1537210499,1537195401,1537179375,1537164493,1537149542,1537031494,1536944438,1536929592,1536914737,1536867085,1536842476,1536827923,1536811939,1536797396,1536782855,1536768286,1536752123,1536737549,1536682918,1536668019,1536653382,1536615531,1536600955,1536585415,1536565933,1536551025,1536536274,1536521100,1536506220,1536491112,1536434398,1536419670,1536400005,1536240897,1536226237,1536173352,1536158811,1536144274,1536129727,1536115187,1536091076,1536065026,1535055761,1535041218,1535026666,1535012085,1534969833,1534955278,1534940724,1534926168,1534880834,1534866269,1534851638,1534837043,1534795785,1534778887,1534764330,1534749779,1534734844,1534720297,1534705750,1534691205,1534676647,1534662103,1534647524,1534632979,1534618363,1534405271,1534359480,1534271460,1534271281,1534270713,1534270472,1534193844,1533930882,1533916201,1533901633,1533887039,1533837439,1533822888,1533808320,1533792765,1533752830,1533738089,1533668570,1533653994,1533639451,1533624827,1533582954,1533568361,1533553803,1533539255,1533415415,1533400778,1533232776,1533206848,1533139637,1533124633,1533059066,1533044531,1533029973,1532979342,1532964801,1532950228,1532935671,1532880012,1532865451,1532850911,1532789829,1532774500,1532755939,1532741102,1532726224,1532711394,1532696294,1532681113,1532624963,1532609777,1532595001,1532544398,1532529456,1532514628,1532500077,1532461085,1532446168,1532431430,1532416467,1532377581,1532363035,1532348497,1532333750,1532191689,1532177144,1532162591,1532088891,1532002533,1531979983,1531932997,1531586770,1531507310,1531492784,1531478169,1531338193,1531323336,1531308787,1531294193,1531243416,1531228846,1531214310,1531100462,1531085936,1531071414,1531056874,1531042333,1530898681,1530882184,1530867632,1530819931,1530805393,1530790828,1530776292,1530718778,1530704243,1530689625,1530641148,1530626607,1530612039,1530596595,1530557495,1530542920,1530526741,1530512184,1530384153,1530369594,1530355048,1530339831,1530293270,1530278698,1530264019,1530218078,1530203552,1530189024,1530174494,1530159966,1530113144,1530098186,1530083607,1530040982,1530015986,1530001098,1529957500,1529942963,1529928438,1529913903,1529686647,1529670913,1529656097,1529610790,1529596271,1529581742,1529566901,1529525887,1529511293,1529496150,1529481422,1529439990,1529418389,1529403343,1529388584,1529347678,1529332050,1529317107,1529301840,1529265413,1529250880,1529235729,1529221199,1529206680,1529192151,1529177545,1528905259,1528890165,1528875379,1528831817,1528817286,1528802695,1528788163,1528715855,1528700845,1528655790,1528641078,1528626250,1528611177,1528138600,1528124065,1528109318,1528090401,1528075608,1528037662,1527862236,1527841065,1527013433,1526998783,1526923488,1526908367,1526887262,1526872638,1526857993,1526755571,1526741049,1526725917,1526671225,1526656139,1526641422,1526626209,1526570524,1526551691,1526536797,1526497751,1526482960,1526468037,1526453279,1526414491,1526399952,1526385399,1526370795,1526324519,1526229947,1526198110,1526195929,1526195762,1526140907,1526111728,1526091492,1526076982,1526037215,1526022690,1525986647,1525972133,1525943029,1525888581,1525874055,1525850979,1525805612,1525791102,1525776574,1525762061,1525714574,1525685517,1525670941,1525629691,1525594091,1525553951,1525536886,1525535759,1525533225,1525518537,1525467168,1525452767,1525423967,1525409566,1525353673,1525337907,1525323508,1525285653,1525271253,1525256820,1525242420,1525196096,1525181695,1525166943,1525112275,1525097884,1525083479,1525069068,1525029813,1525015391,1525000790,1524986391,1524937741,1524923383,1524908640,1524894238,1524862685,1524829173,1524631355,1524579958,1524565473,1524551076,1524505937,1524491535,1524477135,1524462737,1524423957,1524395156,1524380751,1524334776,1524320375,1524305975,1524291575,1524233848,1524219449,1524205037,1524161762,1524147361,1524132960,1524118560,1524073476,1524044674,1524030273,1523999623,1523985223,1523956115,1523941714,1523902955,1523888552,1523874153,1523859753,1523821896,1523792863,1523778463,1523764063,1523749656,1523639919,1523625505,1523596704,1523582304,1523539974,1523525574,1523510942,1523483842,1523469435,1523455035,1523426233,1523383143,1523368743,1523354342,1523339904,1523311082,1523296680,1523282280,1523267880,1523253478,1523221893,1523203778,1523189378,1523174977,1523127417,1523113015,1523098616,1523083561,1523041131,1523012331,1522997931,1522947690,1522933290,1522918890,1522904489,1522867507,1522838711,1522822603,1522765776,1522751374,1522736449,1522694925,1522666122,1522651722,1522610767,1522523369,1522508969,1522423407,1522337650,1522323250,1522265650,1522251248,1522236850,1522075521,1522046720,1521916494,1521902092,1521877571,1521840578,1521826177,1521797376,1521745937,1521729585,1521714368,1521705724,1521658881,1521644465,1521630062,1521615667,1521588666,1521574248,1521545449,1521531064,1521484209,1521469809,1521455284,1521440884,1521394512,1521316220,1521234825,1521217707,1521016386,1520844170,1520757189,1520670890,1520584477,1520498009,1520411589,1520325213,1520248618,1520233273,1520156012,1520065968,1519979504,1519893281,1519806747,1519720379,1519633924,1519548757,1519488313,1519476157,1519452540,1519447093,1519441381,1519435801,1519432161,1519426745,1519420181,1519413480,1519407902,1519402322,1519396740,1519391732,1519385580,1519380001,1519374421,1519369369,1519363307,1519357680,1519337313,1519332223,1519324201,1519318996,1519313040,1519309063,1519301880,1519296300,1519290720,1519285858,1519279631,1519274047,1519268400,1519262820,1519257438,1519251660,1519248197,1519244353,1519241583,1519231399,1519201440,1519195861,1519190280,1519185637,1519179121,1519173540,1519167960,1519162380,1519159795,1519151220,1519145640,1519140060,1519136546,1519128900,1519126303,1519117740,1519112160,1519106667,1519101003,1519095435,1519089847,1519084267,1519078682,1519073196,1519067632,1519062405,1519056547,1519050780,1519045200,1519040230,1519034040,1519028460,1519022882,1519017302,1519011722,1519006142,1519000568,1518994983,1518989401,1518983820,1518978240,1518972661,1518968118,1518961500,1518957585,1518950394,1518944779,1518939180,1518933600,1518928020,1518922440,1518916860,1518911388,1518906487,1518901446,1518896286,1518889738,1518883380,1518877831,1518872609,1518866640,1518861164,1518855480,1518849902,1518844328,1518838748,1518833168,1518827582,1518822060,1518816420,1518810840,1518805260,1518799680,1518795205,1518788599,1518782940,1518778188,1518771866,1518766200,1518760637,1518755048,1518749468,1518743882,1518738313,1518732725,1518723017,1518711935,1518700813,1518686877,1518684736,1518676925,1518671346,1518665763,1518660183,1518654604,1518649026,1518645527,1518637357,1518632994,1518622358,1518617310,1518609962,1518606683,1518605880,1518601032,1518587644,1518582067,1518576482,1518570907,1518565327,1518559742,1518554934,1518548580,1518545225,1518537420,1518531840,1518526260,1518520752,1518515333,1518509520,1518503954,1518498617,1518492782,1518487207,1518481628,1518476042,1518471481,1518464880,1518460231,1518456422,1518449448,1518442560,1518436980,1518431500,1518425820,1518420240,1518414660,1518409080,1518403500,1518397920,1518392572,1518389587,1518388351,1518386666,1518367561,1518342120,1518336540,1518330967,1518325382,1518319802,1518314234,1518308647,1518303067,1518297499,1518292307,1518286325,1518280740,1518277453,1518270672,1518264432,1518258836,1518252843,1518247267,1518241687,1518236102,1518230558,1518224942,1518219362,1518214683,1518208644,1518202620,1518198228,1518186145,1518180300,1518175029,1518170364,1518163560,1518157982,1518152402,1518146822,1518141247,1518135662,1518130082,1518125425,1518118920,1518113340,1518107760,1518102180,1518096600,1518091791,1518088987,1518085531,1518074586,1518001041,1517966136,1517943109,1517895767,1517890150,1517884570,1517878990,1517873410,1517867830,1517862240,1517858255,1517851586,1517845500,1517841788,1517834340,1517828760,1517823183,1517817614,1517812030,1517806445,1517800870,1517795290,1517789713,1517784125,1517778540,1517773004,1517767380,1517761800,1517759544,1517745233,1517739480,1517733900,1517728320,1517722917,1517717160,1517711580,1517706000,1517700420,1517694840,1517690375,1517683680,1517678354,1517672520,1517668184,1517661360,1517655974,1517650200,1517644620,1517639040,1517633460,1517627880,1517622300,1517616720,1517611140,1517608591,1517601139,1517594400,1517588820,1517583820,1517579700,1517573057,1517567218,1517560920,1517555340,1517549760,1517544563,1517538600,1517533020,1517527440,1517523149,1517522951,1517520776,1517505120,1517500175,1517493960,1517488827,1517482800,1517477760,1517477376,1517476625,1517476467,1517476149,1517475892,1517475477,1517474272,1517473634,1517472551,1517466060,1517460494,1517454900,1517449320,1517443740,1517439078,1517433236,1517428732,1517428457,1517425372,1517421199,1517404680,1517399100,1517394462,1517387940,1517382360,1517376780,1517371200,1517365620,1517360746,1517354460,1517349100,1517343300,1517337720,1517332930,1517326560,1517321034,1517315400,1517312839,1517304240,1517298660,1517293083,1517287502,1517281928,1517276342,1517270763,1517265182,1517263586,1517254020,1517248711,1517242860,1517237280,1517231700,1517226120,1517220687,1517214960,1517209380,1517203800,1517198220,1517192640,1517187060,1517181488,1517175900,1517170626,1517164937,1517159160,1517153580,1517149921,1517142420,1517136840,1517131260,1517125750,1517120100,1517114520,1517109258,1517103360,1517097780,1517092200,1517086620,1517081040,1517076677,1517069880,1517065785,1517058720,1517054413,1517047560,1517041980,1517036400,1517030820,1517025240,1517019694,1517014080,1517008500,1517002920,1516997340,1516991760,1516986180,1516980650,1516975040,1516969616,1516963860,1516959508,1516952700,1516947130,1516941540,1516935960,1516930380,1516924800,1516919233,1516913640,1516908060,1516902480,1516898296,1516891320,1516886790,1516880227,1516875001,1516869127,1516863420,1516857840,1516852260,1516846680,1516841100,1516835520,1516830081,1516824412,1516818780,1516814536,1516807620,1516802040,1516796460,1516791794,1516785300,1516779720,1516774184,1516768629,1516762980,1516757400,1516751883,1516751559,1516746568,1516740929,1516735247,1516730892,1516725417,1516718340,1516712773,1516707966,1516703614,1516701600,1516696020,1516691783,1516690440,1516684860,1516668120,1516662540,1516651380,1516645800,1516631039,1516601160,1516578840,1516567680,1516563711,1516556520,1516550940,1516534281,1516528620,1516511880,1516506331,1516489560,1516483980,1516467240,1516441107,1516434016,1516417020,1516411440,1516389120,1516372380,1516366800,1516361229,1516350064,1516344488,1516322162,1516317142,1516299840,1516283100,1516277520,1516271940,1516266360,1516255200,1516249620,1516232880,1516227300,1516204980,1516188240,1516182660,1516179170,1516160340,1516143600,1516138020,1516132440,1516115700,1516110120,1516098960,1516093380,1516087800,1516065480,1516043188,1516026420,1516020840,1516009680,1516004100,1515998522,1515992944,1515976207,1515970623,1515965186,1515953880,1515948365,1515931560,1515925980,1515909240,1515903660,1515881340,1515859020,1515842280,1515838607,1515814380,1515808800,1515793540,1515786480,1515780900,1515770467,1515764160,1515741894,1515725100,1515719528,1515702780,1515697200,1515680460,1515674880,1515655672,1515655193,1515652560,1515646980,1515630240,1515624660,1515607920,1515602340,1515585700,1515575819,1515540467,1515537758) took 0:00:00:00.046 Fatal error => SQL logic error or missing database
too many SQL variables