Skip to content

Resetting database on regtest fails due to FOREIGN KEY constraint violation #32

@AustEcon

Description

@AustEcon

This is a todo task that I don't want to fix right this minute as there are other tasks that take precidence

PS C:\Users\donha> electrumsv-sdk start --inline reference_server
2022-08-01 16:30:17 INFO     runners                  Starting reference_server ...
2022-08-01 16:30:19 DEBUG    logs                     File logging path=C:\Users\donha\AppData\Local\ElectrumSV-SDK\remote_repos\electrumsv-reference-server\localdata\logs\esv_reference_server.log
2022-08-01 16:30:19 DEBUG    server                   Running in regtest mode
2022-08-01 16:30:19 DEBUG    server                   Datastore location C:\Users\donha\AppData\Local\ElectrumSV-SDK\remote_repos\electrumsv-reference-server\localdata\esv_reference_server.sqlite
2022-08-01 16:30:19 INFO     app-state                Dropping database tables
2022-08-01 16:30:19 ERROR    server                   unexpected exception in __main__
Traceback (most recent call last):
  File "C:\Users\donha\AppData\Local\ElectrumSV-SDK\remote_repos\electrumsv-reference-server\server.py", line 159, in <module>
    asyncio.run(main())
  File "C:\Users\donha\AppData\Local\Programs\Python\Python310\lib\asyncio\runners.py", line 44, in run
    return loop.run_until_complete(main)
  File "C:\Users\donha\AppData\Local\Programs\Python\Python310\lib\asyncio\base_events.py", line 646, in run_until_complete
    return future.result()
  File "C:\Users\donha\AppData\Local\ElectrumSV-SDK\remote_repos\electrumsv-reference-server\server.py", line 122, in main
    application_state = ApplicationState(which_network, datastore_location, internal_host,
  File "C:\Users\donha\AppData\Local\ElectrumSV-SDK\remote_repos\electrumsv-reference-server\esv_reference_server\application_state.py", line 116, in __init__
    self.database_context.run_in_thread(_setup_database)
  File "C:\Users\donha\AppData\Local\ElectrumSV-SDK\python_libs\reference_server\electrumsv_database\sqlite.py", line 314, in run_in_thread
    return cast(T1, future.result())
  File "C:\Users\donha\AppData\Local\Programs\Python\Python310\lib\concurrent\futures\_base.py", line 446, in result
    return self.__get_result()
  File "C:\Users\donha\AppData\Local\Programs\Python\Python310\lib\concurrent\futures\_base.py", line 391, in __get_result
    raise self._exception
  File "C:\Users\donha\AppData\Local\ElectrumSV-SDK\python_libs\reference_server\electrumsv_database\sqlite.py", line 362, in __call__
    result = self._fn(*self._args, **self._kwargs, db=db)
  File "C:\Users\donha\AppData\Local\ElectrumSV-SDK\remote_repos\electrumsv-reference-server\esv_reference_server\application_state.py", line 108, in _setup_database
    self.msg_box_repository.drop_tables(db)
  File "C:\Users\donha\AppData\Local\ElectrumSV-SDK\remote_repos\electrumsv-reference-server\esv_reference_server\msg_box\repositories.py", line 53, in drop_tables
    db.execute("DROP TABLE IF EXISTS msg_box_api_token")
sqlite3.IntegrityError: FOREIGN KEY constraint failed

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions