Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
bitecorner opened this issue Jun 27, 2023 · 2 comments
Labels
bug Something isn't working

Comments

@bitecorner
Copy link

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

@bitecorner bitecorner added the bug Something isn't working label Jun 27, 2023
@tehelsper
Copy link
Collaborator

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

@joshmatix
Copy link

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

Didn't work

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants