mynodebtc/mynode

Mempool.service not creat the symbolic link when i execute systemctl enable --now mempool.service and return this error

bitecorner opened this issue · 2 comments

bitecorner commented

Hello everybody,

Describe the bug
journactl -fu mempool result :
juin 27 08:01:59 ubuntu node[46586]: Jun 27 08:01:59 [46586] DEBUG: MIGRATIONS: Running migrations
juin 27 08:01:59 ubuntu node[46586]: Jun 27 08:01:59 [46586] DEBUG: MIGRATIONS: Database engine version '10.6.12-MariaDB-0ubuntu0.22.04.1'
juin 27 08:01:59 ubuntu node[46586]: Jun 27 08:01:59 [46586] DEBUG: MIGRATIONS: Current state.schema_version 47
juin 27 08:01:59 ubuntu node[46586]: Jun 27 08:01:59 [46586] DEBUG: MIGRATIONS: Latest DatabaseMigration.version is 62
juin 27 08:01:59 ubuntu node[46586]: Jun 27 08:01:59 [46586] DEBUG: MIGRATIONS: Execute query:
juin 27 08:01:59 ubuntu node[46586]: ALTER TABLE channels ADD source_checked tinyint(1) DEFAULT 0
juin 27 08:01:59 ubuntu node[46586]: Jun 27 08:01:59 [46586] ERR: MIGRATIONS: Unable to create required tables, aborting in 10 seconds. Error: Duplicate column name 'source_checked'
juin 27 08:02:09 ubuntu systemd[1]: mempool.service: Main process exited, code=exited, status=255/EXCEPTION
juin 27 08:02:09 ubuntu systemd[1]: mempool.service: Failed with result 'exit-code'.
juin 27 08:02:09 ubuntu systemd[1]: mempool.service: Consumed 2.013s CPU time.

Did someone had any idea what i should do to fix this issue.
Thanks for any help.
Best regards.
Jorge

tehelsper commented

You could try the clear mempool cache option on the settings page. It will reset the mempool data.

joshmatix commented

You could try the clear mempool cache option on the settings page. It will reset the mempool data.

Didn't work