v3.8.1, SQLite; DB is inconsistent

[PSLLSP]

v3.8.1

I tried to sync from block 0. After about a day I see errors that DB is inconsistent. I have simple setup, I reported details in issue #823 that was already closed.

This issue could be a duplicate to #821...

$ du -sh db/
4.8G    db/

$ ls -l db/
total 4940436
drwxrwxr-x 2 user user       4096 May 14 02:54 ./
drwxrwxr-x 5 user user       4096 May 14 02:54 ../
-rw-rw-r-- 1 user user 4933681152 May 14 22:59 signum.sqlite.db
-rw-rw-r-- 1 user user     262144 May 14 22:58 signum.sqlite.db-shm
-rw-rw-r-- 1 user user  124774232 May 14 22:59 signum.sqlite.db-wal

Console with errors:

...
WARNING] 2024-05-14 22:41:38 brs.BlockchainProcessorImpl - Auto popping off as failed to push block
[WARNING] 2024-05-14 22:41:38 brs.BlockchainProcessorImpl - Popping off 243 blocks due to previous failures to push this block
[INFO] 2024-05-14 22:41:38 brs.BlockchainProcessorImpl - Rollback from 672382 to 672139
[WARNING] 2024-05-14 22:41:39 brs.BlockchainProcessorImpl - Block height 672139, total mined 207088570000000000, total effective
+burnt 207088556799981112
[WARNING] 2024-05-14 22:41:39 brs.BlockchainProcessorImpl - Database is inconsistent, try to pop off to block height 669600 or s
ync from empty.
[INFO] 2024-05-14 22:41:44 brs.BlockchainProcessorImpl - Error: lastBlock is null
[INFO] 2024-05-14 22:41:52 brs.statistics.StatisticsManagerImpl - handling 11.36 blocks/s account_balance cache hit ratio now/total:91.83%/97.29% account cache hit ratio now/total:92.99%/97.42%
[SEVERE] 2024-05-14 22:41:52 brs.BlockchainProcessorImpl - Block not accepted
brs.BlockchainProcessor$TransactionNotAcceptedException: Transaction not accepted: 18375910234290820363 transaction: {"type":0,"subtype":0,"timestamp":162616961,"deadline":1440,"senderPublicKey":"b8a83f749be6e0c5bd6205118edb3bbd71f14a55bcdd5977566821dedaac5030","recipient":"13383190289605706987","amountNQT":70383121760,"feeNQT":1470000,"ecBlockHeight":672374,"ecBlockId":"1014574692688231313","cashBackId":"0","signature":"d32c27f194a56bd485d08b4c55920455759fae984ec8b1005724c1b6633e8e0795afe27ab08db905f6de51265b12dfd1d1cfaa4a9a9d5269886a9919d46a00f9","attachment":{"version.Message":1,"message":"b6c444564ab64cc18a082bfa4e77a815f02b203906ad458da680ef4ab93c6cb4","messageIsText":true},"version":1}
        at brs.BlockchainProcessorImpl.accept(BlockchainProcessorImpl.java:1195)
        at brs.BlockchainProcessorImpl.pushBlock(BlockchainProcessorImpl.java:1150)
        at brs.BlockchainProcessorImpl.lambda$new$5(BlockchainProcessorImpl.java:696)
        at brs.util.ThreadPool.lambda$start$0(ThreadPool.java:104)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
        at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
        at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
        at java.base/java.lang.Thread.run(Thread.java:833)
[SEVERE] 2024-05-14 22:41:52 brs.peer.PeerImpl - Reason for following blacklist: Transaction not accepted: 18375910234290820363 transaction: {"type":0,"subtype":0,"timestamp":162616961,"deadline":1440,"senderPublicKey":"b8a83f749be6e0c5bd6205118edb3bbd71f14a55bcdd5977566821dedaac5030","recipient":"13383190289605706987","amountNQT":70383121760,"feeNQT":1470000,"ecBlockHeight":672374,"ecBlockId":"1014574692688231313","cashBackId":"0","signature":"d32c27f194a56bd485d08b4c55920455759fae984ec8b1005724c1b6633e8e0795afe27ab08db905f6de51265b12dfd1d1cfaa4a9a9d5269886a9919d46a00f9","attachment":{"version.Message":1,"message":"b6c444564ab64cc18a082bfa4e77a815f02b203906ad458da680ef4ab93c6cb4","messageIsText":true},"version":1}
[INFO] 2024-05-14 22:41:52 brs.peer.PeerImpl - Blacklisting 213.221.57.86 (v3.8.0) because of: found invalid pull/push data during importing the block
[WARNING] 2024-05-14 22:41:52 brs.BlockchainProcessorImpl - Auto popping off as failed to push block
[WARNING] 2024-05-14 22:41:52 brs.BlockchainProcessorImpl - Popping off 244 blocks due to previous failures to push this block
[INFO] 2024-05-14 22:41:52 brs.BlockchainProcessorImpl - Rollback from 672382 to 672138
[WARNING] 2024-05-14 22:41:54 brs.BlockchainProcessorImpl - Block height 672138, total mined 207088528500000000, total effective+burnt 207088515299981112
[WARNING] 2024-05-14 22:41:54 brs.BlockchainProcessorImpl - Database is inconsistent, try to pop off to block height 669600 or sync from empty.
...

Few hours later:

...
[INFO] 2024-05-15 05:05:25 brs.BlockchainProcessorImpl - Error in blockchain download thread
java.lang.NullPointerException
[INFO] 2024-05-15 05:05:25 brs.BlockchainProcessorImpl - Error in blockchain download thread
java.lang.NullPointerException
...

[ohager]

Can you reproduce the error? Did you try a second or third time?