This worked for me, i can now query z_getsubtreesbyindex as i wanted.
The problem i am facing now is that i have a blockchain folder twice the blockchain size:
oxarbitrage@oxarbitrage:/media/oxarbitrage/4eb53770-4e4f-4d80-a830-0914f3f5b89a/chain/zcash/blocks$ du -h
27G ./index
502G .
oxarbitrage@oxarbitrage:/media/oxarbitrage/4eb53770-4e4f-4d80-a830-0914f3f5b89a/chain/zcash/blocks$
I have very old data files in my HD, a lot older than the ones created after the resync files:
oxarbitrage@oxarbitrage:/media/oxarbitrage/4eb53770-4e4f-4d80-a830-0914f3f5b89a/chain/zcash/blocks$ ls -lh
total 476G
-rw------- 1 oxarbitrage oxarbitrage 128M Aug 17 2022 blk00000.dat
-rw------- 1 oxarbitrage oxarbitrage 128M Aug 17 2022 blk00001.dat
-rw------- 1 oxarbitrage oxarbitrage 128M Aug 17 2022 blk00002.dat
...
Can i just safely delete those files ? I am asking before taking any action as i will not want to be a week more for a new sync after i finally got it working but i also need to make some space.
Any help is appreciated. I posted here in the forum as i think this could also benefit others in a similar situation at some point.
I believe this is because the -lightwalletd flag also flags the -txindex option for the ‘getrawtransaction’ call and that historically creates a very large database file. zcash/doc/man/zcashd.1
The large disk space usage with -experimentalfeatures -lightwalletd is expected for the reason @Autotunafish said.
I don’t know, sorry. However, it should be safe to stop zcashd, move them aside and restart (remember to use -experimentalfeatures -lightwalletd but not -reindex). If zcashd needs to access those files, it will crash during LoadBlockIndex. You can tell when LoadBlockIndex has finished because "block index " followed by a time in milliseconds will be logged afterward. At that point it should be ok to delete the files that you moved aside.
An oldy but a goody! You can move the older files as @daira mentioned but be careful to not mix these databases per those conf flags, as it will cause the full node to not function. I dealt with this many times and if possible you should make golden back up now that the chain is so large. Also pay attention to */chainstate that exists on the /blocks dir.