The WAL is now 0 bytes:

db.sqlite-wal  0B\n

Current DB files:

db.sqlite         4.0G\ndb.sqlite-shm     8.0M\ndb.sqlite-wal     0B\ndb.sqlite.backup  4.0G\n

So PRAGMA wal_checkpoint(TRUNCATE); worked for the WAL.

Recap

The WAL has been successfully truncated to 0B.

Main DB is still ~4.0 GB.
Backup exists at db.sqlite.backup.
This cleaned the WAL, but it does not by itself solve writer contention.

","enableWebSigning","https://nodosdeconocimiento.es","origin","homeMetadata",{"_158":1280,"_365":55,"_366":1281,"_368":1276,"_1264":1282,"_370":8,"_371":372},"Nodos de Conocimiento","ipfs://bafybeici4e4shhiim2mwufsaypj7n6qltsllppzuyy6bel2gvj7vzuoddm","ipfs://bafkreidtocm3drhlggo6euxr4bbxusmtztjdtoq4h5fdoyptq2p6pqtrn4","originHomeId",{"_177":1285,"_37":1286,"_151":1287,"_145":-5,"_179":-5,"_180":-5,"_181":-5,"_182":-5},"z6MkhGQJc96o3UNQ3JyUbCKfQo2bvaQ9KDNa9xxYHJFWWTwg","hm://z6MkhGQJc96o3UNQ3JyUbCKfQo2bvaQ9KDNa9xxYHJFWWTwg",[],"meta",{"_1290":1291,"_1637":1638},"values",{"_1292":1293,"_1295":1296,"_1297":1298,"_1299":1300,"_1302":1303,"_1304":1305,"_1306":1307,"_1309":1310,"_1311":1312,"_1313":1314,"_1315":1316,"_1317":1318,"_1319":1320,"_1321":1322,"_1323":1324,"_1325":1326,"_1327":1328,"_1329":1330,"_1331":1332,"_1333":1334,"_1335":1336,"_1337":1338,"_1339":1340,"_1341":1342,"_1343":1344,"_1345":1346,"_1347":1348,"_1349":1350,"_1351":1352,"_1353":1354,"_1355":1356,"_1357":1358,"_1359":1360,"_1361":1362,"_1363":1364,"_1365":1366,"_1367":1368,"_1369":1370,"_1371":1372,"_1373":1374,"_1375":1376,"_1377":1378,"_1379":1380,"_1381":1382,"_1383":1384,"_1385":1386,"_1387":1388,"_1389":1390,"_1391":1392,"_1393":1394,"_1395":1396,"_1397":1398,"_1399":1400,"_1401":1402,"_1403":1404,"_1405":1406,"_1407":1408,"_1409":1410,"_1411":1412,"_1413":1414,"_1415":1416,"_1417":1418,"_1419":1420,"_1421":1422,"_1423":1424,"_1425":1426,"_1427":1428,"_1429":1430,"_1431":1432,"_1433":1434,"_1435":1436,"_1437":1438,"_1439":1440,"_1441":1442,"_1443":1444,"_1445":1446,"_1447":1448,"_1449":1450,"_1451":1452,"_1453":1454,"_1455":1456,"_1457":1458,"_1459":1460,"_1461":1462,"_1463":1464,"_1465":1466,"_1467":1468,"_1469":1470,"_1471":1472,"_1473":1474,"_1475":1476,"_1477":1478,"_1479":1480,"_1481":1482,"_1483":1484,"_1485":1486,"_1487":1488,"_1489":1490,"_1491":1492,"_1493":1494,"_1495":1496,"_1497":1498,"_1499":1500,"_1501":1502,"_1503":1504,"_1505":1506,"_1507":1508,"_1509":1510,"_1511":1512,"_1513":1514,"_1515":1516,"_1517":1518,"_1519":1520,"_1521":1522,"_1523":1524,"_1525":1526,"_1527":1528,"_1529":1530,"_1531":1532,"_1533":1534,"_1535":1536,"_1537":1538,"_1539":1540,"_1541":1542,"_1543":1544,"_1545":1546,"_1547":1548,"_1549":1550,"_1551":1552,"_1553":1554,"_1555":1556,"_1557":1558,"_1559":1560,"_1561":1562,"_1563":1564,"_1565":1566,"_1567":1568,"_1569":1570,"_1571":1572,"_1573":1574,"_1575":1576,"_1577":1578,"_1579":1580,"_1581":1582,"_1583":1584,"_1585":1586,"_1587":1588,"_1589":1590,"_1591":1592,"_1593":1594,"_1595":1596,"_1597":1598,"_1599":1600,"_1601":1602,"_1603":1604,"_1605":1606,"_1607":1608,"_1609":1610,"_1611":1612,"_1613":1614,"_1615":1616,"_1617":1618,"_1619":1620,"_1621":1622,"_1623":1624,"_1625":1626,"_1627":1628,"_1629":1630,"_1631":1632,"_1633":1634,"_1635":1636},"document.generationInfo.generation",[1294],"bigint","dehydratedState.queries.0.state.data.document.generationInfo.generation",[1294],"dehydratedState.queries.1.state.data.document.generationInfo.generation",[1294],"dehydratedState.queries.1.queryKey.2",[1301],"undefined","dehydratedState.queries.2.state.data.0.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.0.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.0.sortTime",[1308],"Date","dehydratedState.queries.2.state.data.0.activitySummary.latestCommentTime",[1301],"dehydratedState.queries.2.state.data.0.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.0.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.0.redirectInfo",[1301],"dehydratedState.queries.2.state.data.1.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.1.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.1.sortTime",[1308],"dehydratedState.queries.2.state.data.1.activitySummary.latestCommentTime.seconds",[1294],"dehydratedState.queries.2.state.data.1.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.1.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.1.redirectInfo",[1301],"dehydratedState.queries.2.state.data.2.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.2.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.2.sortTime",[1308],"dehydratedState.queries.2.state.data.2.activitySummary.latestCommentTime",[1301],"dehydratedState.queries.2.state.data.2.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.2.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.2.redirectInfo",[1301],"dehydratedState.queries.2.state.data.3.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.3.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.3.sortTime",[1308],"dehydratedState.queries.2.state.data.3.activitySummary.latestCommentTime.seconds",[1294],"dehydratedState.queries.2.state.data.3.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.3.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.3.redirectInfo",[1301],"dehydratedState.queries.2.state.data.4.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.4.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.4.sortTime",[1308],"dehydratedState.queries.2.state.data.4.activitySummary.latestCommentTime",[1301],"dehydratedState.queries.2.state.data.4.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.4.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.4.redirectInfo",[1301],"dehydratedState.queries.2.state.data.5.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.5.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.5.sortTime",[1308],"dehydratedState.queries.2.state.data.5.activitySummary.latestCommentTime.seconds",[1294],"dehydratedState.queries.2.state.data.5.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.5.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.6.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.6.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.6.sortTime",[1308],"dehydratedState.queries.2.state.data.6.activitySummary.latestCommentTime.seconds",[1294],"dehydratedState.queries.2.state.data.6.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.6.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.6.redirectInfo",[1301],"dehydratedState.queries.2.state.data.7.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.7.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.7.sortTime",[1308],"dehydratedState.queries.2.state.data.7.activitySummary.latestCommentTime.seconds",[1294],"dehydratedState.queries.2.state.data.7.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.7.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.7.redirectInfo",[1301],"dehydratedState.queries.2.state.data.8.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.8.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.8.sortTime",[1308],"dehydratedState.queries.2.state.data.8.activitySummary.latestCommentTime",[1301],"dehydratedState.queries.2.state.data.8.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.8.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.8.redirectInfo",[1301],"dehydratedState.queries.2.state.data.9.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.9.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.9.sortTime",[1308],"dehydratedState.queries.2.state.data.9.activitySummary.latestCommentTime.seconds",[1294],"dehydratedState.queries.2.state.data.9.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.9.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.9.redirectInfo",[1301],"dehydratedState.queries.2.state.data.10.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.10.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.10.sortTime",[1308],"dehydratedState.queries.2.state.data.10.activitySummary.latestCommentTime",[1301],"dehydratedState.queries.2.state.data.10.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.10.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.10.redirectInfo",[1301],"dehydratedState.queries.2.state.data.11.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.11.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.11.sortTime",[1308],"dehydratedState.queries.2.state.data.11.activitySummary.latestCommentTime.seconds",[1294],"dehydratedState.queries.2.state.data.11.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.11.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.11.redirectInfo",[1301],"dehydratedState.queries.2.state.data.12.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.12.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.12.sortTime",[1308],"dehydratedState.queries.2.state.data.12.activitySummary.latestCommentTime.seconds",[1294],"dehydratedState.queries.2.state.data.12.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.12.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.12.redirectInfo",[1301],"dehydratedState.queries.2.state.data.13.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.13.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.13.sortTime",[1308],"dehydratedState.queries.2.state.data.13.activitySummary.latestCommentTime.seconds",[1294],"dehydratedState.queries.2.state.data.13.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.13.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.13.redirectInfo",[1301],"dehydratedState.queries.2.state.data.14.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.14.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.14.sortTime",[1308],"dehydratedState.queries.2.state.data.14.activitySummary.latestCommentTime",[1301],"dehydratedState.queries.2.state.data.14.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.14.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.14.redirectInfo",[1301],"dehydratedState.queries.2.state.data.15.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.15.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.15.sortTime",[1308],"dehydratedState.queries.2.state.data.15.activitySummary.latestCommentTime",[1301],"dehydratedState.queries.2.state.data.15.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.15.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.15.redirectInfo",[1301],"dehydratedState.queries.2.state.data.16.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.16.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.16.sortTime",[1308],"dehydratedState.queries.2.state.data.16.activitySummary.latestCommentTime",[1301],"dehydratedState.queries.2.state.data.16.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.16.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.16.redirectInfo",[1301],"dehydratedState.queries.2.state.data.17.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.17.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.17.sortTime",[1308],"dehydratedState.queries.2.state.data.17.activitySummary.latestCommentTime",[1301],"dehydratedState.queries.2.state.data.17.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.17.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.17.redirectInfo",[1301],"dehydratedState.queries.2.state.data.18.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.18.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.18.sortTime",[1308],"dehydratedState.queries.2.state.data.18.activitySummary.latestCommentTime",[1301],"dehydratedState.queries.2.state.data.18.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.18.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.18.redirectInfo",[1301],"dehydratedState.queries.2.state.data.19.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.19.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.19.sortTime",[1308],"dehydratedState.queries.2.state.data.19.activitySummary.latestCommentTime.seconds",[1294],"dehydratedState.queries.2.state.data.19.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.19.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.19.redirectInfo",[1301],"dehydratedState.queries.2.state.data.20.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.20.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.20.sortTime",[1308],"dehydratedState.queries.2.state.data.20.activitySummary.latestCommentTime",[1301],"dehydratedState.queries.2.state.data.20.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.20.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.20.redirectInfo",[1301],"dehydratedState.queries.2.state.data.21.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.21.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.21.sortTime",[1308],"dehydratedState.queries.2.state.data.21.activitySummary.latestCommentTime.seconds",[1294],"dehydratedState.queries.2.state.data.21.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.21.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.21.redirectInfo",[1301],"dehydratedState.queries.2.state.data.22.createTime.seconds",[1294],"dehydratedState.queries.2.state.data.22.updateTime.seconds",[1294],"dehydratedState.queries.2.state.data.22.sortTime",[1308],"dehydratedState.queries.2.state.data.22.activitySummary.latestCommentTime.seconds",[1294],"dehydratedState.queries.2.state.data.22.activitySummary.latestChangeTime.seconds",[1294],"dehydratedState.queries.2.state.data.22.generationInfo.generation",[1294],"dehydratedState.queries.2.state.data.22.redirectInfo",[1301],"dehydratedState.queries.5.state.data.document.generationInfo.generation",[1294],"dehydratedState.queries.5.queryKey.2",[1301],"dehydratedState.queries.6.state.data.document.generationInfo.generation",[1294],"dehydratedState.queries.6.queryKey.2",[1301],"dehydratedState.queries.7.state.data.document.generationInfo.generation",[1294],"dehydratedState.queries.7.queryKey.2",[1301],"dehydratedState.queries.8.state.data.metadata.summary",[1301],"referentialEqualities",{"_1292":1639,"_1304":1640,"_1319":1641,"_1327":1642,"_1333":1643,"_1347":1644,"_1359":1645,"_1361":1646,"_1369":1647,"_1375":1648,"_1387":1649,"_1401":1650,"_1415":1651,"_1429":1652,"_1443":1653,"_1457":1654,"_1471":1655,"_1485":1656,"_1499":1657,"_1513":1658,"_1527":1659,"_1541":1660,"_1555":1661,"_1569":1662,"_1583":1663,"_1597":1664,"_1611":1665},[1295],[1311],[1325],[1623],[1339],[1353],[1373],[1367],[1383,1521,1591],[1381],[1393],[1407],[1421],[1435],[1449],[1463],[1477],[1491],[1505],[1519],[1533],[1547],[1561],[1575],[1589],[1603],[1617],"actionData","errors"]