Both SQLite files in the reproduced lab returned quick_check=ok. Only one contained all four committed rows. The raw copy of live.db held IDs 1,2 and a total of 300; the file created through SQLite’s Online Backup API held IDs 1,2,3,4 and the declared total of 1000.
That is ...