Archiver errors rusk 1.0.0-rc.0 (8e6bb493 2024-12-30)

[TurtleSnail]

Describe the bug

Jan 01 18:02:42 Dusk-T1 rusk[148194]: 2025-01-01T18:02:42.595965Z ERROR node::archive::archivist: Failed to finalize block in archive: error returned from database: (code: 275) CHECK constraint failed: id = block_height
Jan 01 18:02:42 Dusk-T1 rusk[148194]: Caused by:
Jan 01 18:02:42 Dusk-T1 rusk[148194]:     (code: 275) CHECK constraint failed: id = block_height
Jan 01 18:02:42 Dusk-T1 rusk[148194]: Stack backtrace:
Jan 01 18:02:42 Dusk-T1 rusk[148194]:    0: anyhow::error::<impl core::convert::From<E> for anyhow::Error>::from
Jan 01 18:02:42 Dusk-T1 rusk[148194]:    1: node::archive::sqlite::<impl node::archive::Archive>::finalize_archive_data::{{closure}}
Jan 01 18:02:42 Dusk-T1 rusk[148194]:    2: <node::archive::archivist::ArchivistSrv as node::LongLivedService<N,DB,VM>>::execute::{{closure}}
Jan 01 18:02:42 Dusk-T1 rusk[148194]:    3: node::Node<N,DB,VM>::spawn_all::{{closure}}::{{closure}}
Jan 01 18:02:42 Dusk-T1 rusk[148194]:    4: std::panicking::try
Jan 01 18:02:42 Dusk-T1 rusk[148194]:    5: tokio::runtime::task::harness::Harness<T,S>::poll
Jan 01 18:02:42 Dusk-T1 rusk[148194]:    6: tokio::runtime::scheduler::multi_thread::worker::Context::run_task
Jan 01 18:02:42 Dusk-T1 rusk[148194]:    7: tokio::runtime::scheduler::multi_thread::worker::Context::run
Jan 01 18:02:42 Dusk-T1 rusk[148194]:    8: tokio::runtime::context::runtime::enter_runtime
Jan 01 18:02:42 Dusk-T1 rusk[148194]:    9: tokio::runtime::scheduler::multi_thread::worker::run
Jan 01 18:02:42 Dusk-T1 rusk[148194]:   10: <tokio::runtime::blocking::task::BlockingTask<T> as core::future::future::Future>::poll
Jan 01 18:02:42 Dusk-T1 rusk[148194]:   11: tokio::runtime::task::core::Core<T,S>::poll
Jan 01 18:02:42 Dusk-T1 rusk[148194]:   12: tokio::runtime::task::harness::Harness<T,S>::poll
Jan 01 18:02:42 Dusk-T1 rusk[148194]:   13: tokio::runtime::blocking::pool::Inner::run
Jan 01 18:02:42 Dusk-T1 rusk[148194]:   14: std::sys_common::backtrace::__rust_begin_short_backtrace
Jan 01 18:02:42 Dusk-T1 rusk[148194]:   15: core::ops::function::FnOnce::call_once{{vtable.shim}}
Jan 01 18:02:42 Dusk-T1 rusk[148194]:   16: <alloc::boxed::Box<F,A> as core::ops::function::FnOnce<Args>>::call_once
Jan 01 18:02:42 Dusk-T1 rusk[148194]:              at /rustc/0f44eb32f1123ac93ab404d74c295263ce468343/library/alloc/src/boxed.rs:2007:9
Jan 01 18:02:42 Dusk-T1 rusk[148194]:   17: <alloc::boxed::Box<F,A> as core::ops::function::FnOnce<Args>>::call_once
Jan 01 18:02:42 Dusk-T1 rusk[148194]:              at /rustc/0f44eb32f1123ac93ab404d74c295263ce468343/library/alloc/src/boxed.rs:2007:9
Jan 01 18:02:42 Dusk-T1 rusk[148194]:   18: std::sys::unix::thread::Thread::new::thread_start
Jan 01 18:02:42 Dusk-T1 rusk[148194]:              at /rustc/0f44eb32f1123ac93ab404d74c295263ce468343/library/std/src/sys/unix/thread.rs:108:17
Jan 01 18:02:42 Dusk-T1 rusk[148194]:   19: <unknown>
Jan 01 18:02:42 Dusk-T1 rusk[148194]:   20: <unknown>

To Reproduce

1. Compile archive variant of rusk node,
2. run the node with RUST_BACKTRACE=full

Platform

# /home/dusk/bin/rusk -V
rusk 1.0.0-rc.0 (8e6bb493 2024-12-30)

# lsb_release -a
No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 24.04.1 LTS
Release:	24.04
Codename:	noble

[TurtleSnail]

also the case in build f300b38