Purged output DB and now can't execute SpineOpt

[kirawest]

Describe your problem

A rookie mistake - I purged an output DB that I shouldn't have, and now get an error when I try to run SpineOpt (also when I start over with a clean DB and load template).

The error that appears in the Julia console appears below. This is within the hands-on project built for the last Mopo meeting (https://github.com/aporrasc/Mopo_HandsOn_Tutorial/tree/main). Thanks in advance for any advice you can offer :)

Running SpineOpt...
[SpineOpt version 0.10.2 (git hash: 465148b)]
[SpineInterface version 0.15.2 (git hash: 9bf05d62d636a76f9c21916772bc5d28e15ec460)]
Execution started at 2025-07-21T13:57:20.140
Reading input data from sqlite:///c:\users\westkj\documents\spinetools\projects\test_.spinetoolbox\items\spineopt_model\spineopt_model.sqlite?spinedbfilter=cfg%3Ascenario%3Ay2030...
Initializing data structure from db...ERROR: LoadError: invalid redefinition of constant total_costs
Stacktrace:
[1] top-level scope
@ C:\Users\westkj.local\pipx\venvs\spinetoolbox-dev\Scripts\Mopo_HandsOn_Tutorial\spinetools\SpineInterface.jl\src\api\db.jl:305
[2] eval
@ .\boot.jl:368 [inlined]
[3] _generate_convenience_functions(data::Dict{String, Any}, mod::Module; filters::Nothing, extend::Bool)
@ SpineInterface C:\Users\westkj.local\pipx\venvs\spinetoolbox-dev\Scripts\Mopo_HandsOn_Tutorial\spinetools\SpineInterface.jl\src\api\db.jl:304
[4] #using_spinedb#104
@ C:\Users\westkj.local\pipx\venvs\spinetoolbox-dev\Scripts\Mopo_HandsOn_Tutorial\spinetools\SpineInterface.jl\src\api\db.jl:44 [inlined]
[5] macro expansion
@ .\timing.jl:262 [inlined]
[6] (::SpineOpt.var"#78#84"{String, Bool, Tuple{}, Dict{String, String}})()
@ SpineOpt C:\Users\westkj.local\pipx\venvs\spinetoolbox-dev\Scripts\Mopo_HandsOn_Tutorial\spinetools\SpineOpt.jl\src\util\misc.jl:60
[7] (::Base.RedirectStdStream)(thunk::SpineOpt.var"#78#84"{String, Bool, Tuple{}, Dict{String, String}}, stream::Pipe)
@ Base .\stream.jl:1427
[8] macro expansion
@ C:\Users\westkj.local\pipx\venvs\spinetoolbox-dev\Scripts\Mopo_HandsOn_Tutorial\spinetools\SpineOpt.jl\src\util\misc.jl:59 [inlined]
[9] _init_data_from_db(url_in::String, log_level::Int64, upgrade::Bool, templates::Tuple{}, filters::Dict{String, String}, scenario::String) (repeats 2 times)
@ SpineOpt C:\Users\westkj.local\pipx\venvs\spinetoolbox-dev\Scripts\Mopo_HandsOn_Tutorial\spinetools\SpineOpt.jl\src\run_spineopt.jl:298
[10] prepare_spineopt(url_in::String; log_level::Int64, upgrade::Bool, filters::Dict{String, String}, templates::Tuple{}, mip_solver::Nothing, lp_solver::Nothing, use_direct_model::Bool, use_model_names::Bool, add_bridges::Bool)
@ SpineOpt C:\Users\westkj.local\pipx\venvs\spinetoolbox-dev\Scripts\Mopo_HandsOn_Tutorial\spinetools\SpineOpt.jl\src\run_spineopt.jl:265
[11] _run_spineopt(f::SpineOpt.var"#64#65", url_in::String, url_out::String; upgrade::Bool, filters::Dict{String, String}, templates::Tuple{}, mip_solver::Nothing, lp_solver::Nothing, use_direct_model::Bool, use_model_names::Bool, add_bridges::Bool, log_level::Int64, alternative::String, kwargs::Base.Pairs{Symbol, Union{Nothing, Integer}, NTuple{4, Symbol}, NamedTuple{(:optimize, :update_names, :write_as_roll, :resume_file_path), Tuple{Bool, Bool, Int64, Nothing}}})
@ SpineOpt C:\Users\westkj.local\pipx\venvs\spinetoolbox-dev\Scripts\Mopo_HandsOn_Tutorial\spinetools\SpineOpt.jl\src\run_spineopt.jl:149
[12] #67
@ C:\Users\westkj.local\pipx\venvs\spinetoolbox-dev\Scripts\Mopo_HandsOn_Tutorial\spinetools\SpineOpt.jl\src\run_spineopt.jl:104 [inlined]
[13] _log_to_file
@ C:\Users\westkj.local\pipx\venvs\spinetoolbox-dev\Scripts\Mopo_HandsOn_Tutorial\spinetools\SpineOpt.jl\src\util\misc.jl:246 [inlined]
[14] #run_spineopt#66
@ C:\Users\westkj.local\pipx\venvs\spinetoolbox-dev\Scripts\Mopo_HandsOn_Tutorial\spinetools\SpineOpt.jl\src\run_spineopt.jl:103 [inlined]
[15] run_spineopt
@ C:\Users\westkj.local\pipx\venvs\spinetoolbox-dev\Scripts\Mopo_HandsOn_Tutorial\spinetools\SpineOpt.jl\src\run_spineopt.jl:83 [inlined]
[16] #run_spineopt#63
@ C:\Users\westkj.local\pipx\venvs\spinetoolbox-dev\Scripts\Mopo_HandsOn_Tutorial\spinetools\SpineOpt.jl\src\run_spineopt.jl:67 [inlined]
[17] run_spineopt(url_in::String, url_out::String)
@ SpineOpt C:\Users\westkj.local\pipx\venvs\spinetoolbox-dev\Scripts\Mopo_HandsOn_Tutorial\spinetools\SpineOpt.jl\src\run_spineopt.jl:66
[18] top-level scope
@ C:\Users\westkj.spinetoolbox\plugins\SpineOpt\specifications\Tool\run_spineopt.jl:3
[19] include(fname::String)
@ Base.MainInclude .\client.jl:476
[20] top-level scope
@ none:1
in expression starting at C:\Users\westkj.spinetoolbox\plugins\SpineOpt\specifications\Tool\run_spineopt.jl:3

Attach your model as a JSON file (encouraged)

No response

What versions are you using?

SpineOpt: 0.10.2
SpineInterface: 0.15.2
SpineToolbox: 0.11.0.dev2
Julia: 1.8.5

[tarskul]

In a mail we discussed resetting the workflow.

This discussion can be reopened if that didn't work.