search db cache conflicts

[qkkas]

I click the run.bat bt no application is opened

[anacrolix]

Have you checked in the system tray for the icon?

Can you send me cove.log?

[qkkas]

I have checked it before commit
[2025-02-05 16:44:53 +0800 WRN github.com/anacrolix/torrent portfwd.go:24]
msg="error: AddPortMapping: 500 Internal Server Error"
[2025-02-05 16:44:53 +0800 WRN github.com/anacrolix/torrent portfwd.go:24]
msg="error: AddPortMapping: 500 Internal Server Error"
[2025-02-05 16:44:56 +0800 CRT github.com/anacrolix/gostdapp app.go:47]
msg="error in main: initializing local DHT indexer: creating search conn factory: opening caterwaul db: pebble: merger name from file "dht-indexer-bitmap-merger" != merger name from options "caterwaul-merger""

[qkkas]

how can i do to solve the probelm ?

[anacrolix]

Ah yes, please remove the cache directory. It will be in %LocalAppData%/cove/caterwaul-pebble-search. You can delete all of %LocalAppData%/cove if that doesn't work, and also %AppData%/cove if that still doesn't work.

[anacrolix]

As a fallback, run with -workDir to put all files in the directory you run from so you can see everything. I made that not the default because too many people got confused.

[qkkas]

neither of the way worked.and the cove.log is changed.
[2025-02-10 15:17:09 +0800 WRN github.com/anacrolix/dht-indexer/sqlite/datadb open.go:110]
msg="upgrading database" "from version"=1 "to version"=2
[2025-02-10 15:17:11 +0800 WRN github.com/anacrolix/torrent portfwd.go:24]
msg="error: AddPortMapping: 500 Internal Server Error"
[2025-02-10 15:17:14 +0800 CRT github.com/anacrolix/gostdapp app.go:47]
msg="error in main: initializing local DHT indexer: initing search db maintainer: creating writable search conn: opening sqlite db: initing data db: error upgrading from version 1: executing script from "schemas/torrents/2/0-views.sql": sqlite.Conn.Prepare: SQLITE_ERROR: view info_file already exists (create view info_file as\n select * from info_json_lz4\n join info_files_each(decompress(info_json_lz4, 'lz4-sp'));\n\ncreate view human_info as\n select\n info_id,\n lower(hex(info_hash)),\n datetime(first_seen_unixepoch, 'unixepoch', 'localtime') as first_seen_localtime\n from info;\n\ncreate view info_state as\n select\n ,\n info_json_lz4 is not null as have_info,\n filter_reason_id is not null as filtered,\n filter_reason_id is null and info_json_lz4 is null as missing_info\n from info left join info_json_lz4 using (info_id);\n\n-- anything that: hasn't been scraped by this tracker or is the most stale and is scoring badly, and we don't have the info for.\ncreate view next_scrape_stale as\n select \n from info_tracking\n left join tracker using (tracker_id)\n where next_scrape_unixepoch <= unixepoch('now') or next_scrape_unixepoch is null\n order by\n next_scrape_unixepoch nulls first;\n\ncreate view active_scrapers as\n select tracker_id from tracker where active and scrape;\n\ncreate view raw_search_boost as\n select info_id, avg(seeders) as search_boost from info_tracking where tracker_id in active_scrapers group by info_id;\n\ncreate view raw_stale_info_count_before as\n select count() as count_before from info_tracking join active_scrapers using (tracker_id)\n where next_scrape_unixepoch<(select last_now_unixepoch from stale_info_counts);\n\ncreate view raw_stale_info_counts as\n select\n unixepoch('now') as last_now_unixepoch,\n ( select count() from info_tracking join active_scrapers using (tracker_id)\n where next_scrape_unixepoch < unixepoch('now') ) as count_before;)"

[anacrolix]

Strange. You'll need to delete %AppData%/cove as well for the above error. So make sure to delete all the directories I mentioned, then start it again.