spacemesh didn' t start after migration 1.7.1

[ludolinde]

Environment

• Smapp version: 0.xx.x | develop
• Node version: v1.7.1
• OS: Windows 10

Describe the bug

i have this message
THE SPACEMESH NODE SOFTWARE HAS UNEXPECTEDLY QUIT. CLICK ON 'RESTART NODE' TO START IT

Steps to reproduce

i restart spacemesh but i have already this message :

THE SPACEMESH NODE SOFTWARE HAS UNEXPECTEDLY QUIT. CLICK ON 'RESTART NODE' TO START IT

Expected behavior

spacemesh start

Actual behavior

spacemesh didn' t start

Attach screenshots or GIF’s of what’s going on if it makes the issue more illustrative.

Logs

2024-09-27T13:49:30.120+0200 INFO node app cleanup completed
Error: open sqlite db: vacuum into C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql_migrate: step 0: sqlite.Stmt.Step: SQLITE_FULL: database or disk is full (VACUUM INTO ?1)
Error: open sqlite db: vacuum into C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql_migrate: step 0: sqlite.Stmt.Step: SQLITE_FULL: database or disk is full (VACUUM INTO ?1)
2024-09-28T00:13:07.821+0200 INFO node App version: v1.7.1. Git: 2983c71 - 2983c7135bbfb143c7eb7c73162771de16aeb0b8 . Go Version: go1.22.4. OS: windows-amd64 . Genesis 9eebff023abb17ccb775c602daade8ed708f0a50
2024-09-28T00:13:07.821+0200 INFO node Welcome to Spacemesh. Spacemesh full node is starting...
2024-09-28T00:13:07.827+0200 INFO node Loaded existing identity {"filename": "local.key", "public_key": "7b5b7", "name": ""}
2024-09-28T00:13:08.009+0200 INFO node starting spacemesh {"data-dir": "C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b", "post-dir": "D:\", "hostname": "DESKTOP-HU5T7KO", "name": ""}
2024-09-28T00:13:08.009+0200 INFO node.clock converting genesis time to local time {"genesis": "2023-07-14T08:00:00.000Z", "local": "2023-07-14T10:00:00.000+0200"}
2024-09-28T00:13:08.009+0200 INFO node initializing p2p services
2024-09-28T00:13:08.009+0200 INFO node.clock starting global clock {"now": "2024-09-28T00:13:08.009+0200", "genesis": "2023-07-14T10:00:00.000+0200", "layer_duration": "5m0s", "tick_interval": "1s"}
2024-09-28T00:13:08.359+0200 INFO node.stateDb running migrations {"uri": "file:C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql", "current version": 19, "target version": 23}
2024-09-28T00:13:08.359+0200 INFO node.stateDb making a temporary copy of the database {"path": "C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql", "target": "C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql_migrate"}
2024-09-28T00:32:07.382+0200 INFO node App version: v1.7.1. Git: 2983c71 - 2983c7135bbfb143c7eb7c73162771de16aeb0b8 . Go Version: go1.22.4. OS: windows-amd64 . Genesis 9eebff023abb17ccb775c602daade8ed708f0a50
2024-09-28T00:32:07.382+0200 INFO node Welcome to Spacemesh. Spacemesh full node is starting...
2024-09-28T00:32:07.414+0200 INFO node Loaded existing identity {"filename": "local.key", "public_key": "7b5b7", "name": ""}
2024-09-28T00:32:07.469+0200 INFO node starting spacemesh {"data-dir": "C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b", "post-dir": "D:\", "hostname": "DESKTOP-HU5T7KO", "name": ""}
2024-09-28T00:32:07.469+0200 INFO node.clock converting genesis time to local time {"genesis": "2023-07-14T08:00:00.000Z", "local": "2023-07-14T10:00:00.000+0200"}
2024-09-28T00:32:07.469+0200 INFO node initializing p2p services
2024-09-28T00:32:07.474+0200 INFO node.clock starting global clock {"now": "2024-09-28T00:32:07.474+0200", "genesis": "2023-07-14T10:00:00.000+0200", "layer_duration": "5m0s", "tick_interval": "1s"}
2024-09-28T00:32:07.565+0200 WARN node.stateDb incomplete migration detected, deleting the temporary DB {"path": "C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql_migrate"}
2024-09-28T00:32:09.772+0200 INFO node.stateDb running migrations {"uri": "file:C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql", "current version": 19, "target version": 23}
2024-09-28T00:32:09.775+0200 INFO node.stateDb making a temporary copy of the database {"path": "C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql", "target": "C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql_migrate"}
2024-09-28T01:43:04.536+0200 ERROR node failed to start App {"errmsg": "open sqlite db: vacuum into C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql_migrate: step 0: sqlite.Stmt.Step: SQLITE_FULL: database or disk is full (VACUUM INTO ?1)", "name": ""}
2024-09-28T01:43:04.757+0200 INFO node app cleanup starting...
2024-09-28T01:43:05.190+0200 INFO node app cleanup completed
Error: open sqlite db: vacuum into C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql_migrate: step 0: sqlite.Stmt.Step: SQLITE_FULL: database or disk is full (VACUUM INTO ?1)
Error: open sqlite db: vacuum into C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql_migrate: step 0: sqlite.Stmt.Step: SQLITE_FULL: database or disk is full (VACUUM INTO ?1)
2024-09-28T09:40:52.501+0200 INFO node App version: v1.7.1. Git: 2983c71 - 2983c7135bbfb143c7eb7c73162771de16aeb0b8 . Go Version: go1.22.4. OS: windows-amd64 . Genesis 9eebff023abb17ccb775c602daade8ed708f0a50
2024-09-28T09:40:52.501+0200 INFO node Welcome to Spacemesh. Spacemesh full node is starting...
2024-09-28T09:40:52.501+0200 INFO node Loaded existing identity {"filename": "local.key", "public_key": "7b5b7", "name": ""}
2024-09-28T09:40:52.585+0200 INFO node starting spacemesh {"data-dir": "C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b", "post-dir": "D:\", "hostname": "DESKTOP-HU5T7KO", "name": ""}
2024-09-28T09:40:52.585+0200 INFO node.clock converting genesis time to local time {"genesis": "2023-07-14T08:00:00.000Z", "local": "2023-07-14T10:00:00.000+0200"}
2024-09-28T09:40:52.585+0200 INFO node initializing p2p services
2024-09-28T09:40:52.585+0200 INFO node.clock starting global clock {"now": "2024-09-28T09:40:52.585+0200", "genesis": "2023-07-14T10:00:00.000+0200", "layer_duration": "5m0s", "tick_interval": "1s"}
2024-09-28T09:40:52.963+0200 INFO node.stateDb running migrations {"uri": "file:C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql", "current version": 19, "target version": 23}
2024-09-28T09:40:52.963+0200 INFO node.stateDb making a temporary copy of the database {"path": "C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql", "target": "C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql_migrate"}

How to fix

If you have an idea of how the bug can be fixed, provide a short description.

[brusherru]

Hey @ludolinde,

The actual problem is mentioned in the logs you have attached:

Error: open sqlite db: vacuum into C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\state.sql_migrate: step 0: sqlite.Stmt.Step: SQLITE_FULL: database or disk is full (VACUUM INTO ?1)

It tells that you don't have enough disk space to migrate the database.

You can check that you don't have a lot of stale backups there C:\Users\DARD\AppData\Roaming\Spacemesh\node-data\7c8cef2b\. Delete if you have some to free disk space

If you cannot get enough free disk space, then the only option is to remove current db and run quicksync (to download already migrated db).