a problem about starting start_server.py

[iawe-UON]

Your project is awesome，but when I was trying to start the server，I got some trouble：

C:\Users\U03016034\Desktop\MIRIX\.venv\Scripts\python.exe C:\Users\U03016034\Desktop\MIRIX\mirix\server\rest_api.py 
2026-01-22 15:52:03 - Mirix - INFO - Logging to: console (level: INFO)
2026-01-22 15:52:04 - Mirix - INFO - DATABASE CONNECTION: SQLite mode
2026-01-22 15:52:04 - Mirix - INFO - Redis is disabled (MIRIX_REDIS_ENABLED=false)
2026-01-22 15:52:04 - Mirix - INFO - Redis integration disabled or unavailable
2026-01-22 15:52:04 - Mirix - INFO - Starting Mirix REST API server
2026-01-22 15:52:04 - Mirix - INFO - Creating SyncServer instance
INFO:     Started server process [22108]
INFO:     Waiting for application startup.
2026-01-22 15:52:04 - Mirix - ERROR - (sqlite3.IntegrityError) UNIQUE constraint failed: organizations.id
[SQL: INSERT INTO organizations (name, id, created_at, _created_by_id, _last_updated_by_id) VALUES (?, ?, ?, ?, ?)]
[parameters: ('default_org', 'org-00000000-0000-4000-8000-000000000000', '2026-01-22 07:52:04.896150', None, None)]
(Background on this error at: https://sqlalche.me/e/20/gkpj)
┌─────────────────────────────────────────────────────────────────────────────┐
│ Existing SQLite DB schema is invalid, and schema migrations are not         │
│ supported for SQLite. To have migrations supported between Mirix versions,  │
│ please run Mirix with Docker (https://docs.mirix.com/server/docker) or use  │
│ Postgres by setting MIRIX_PG_URI.                                           │
│                                                                             │
│ If you wish to keep using SQLite, you can reset your database by removing   │
│ the DB file with rm ~/.mirix/sqlite.db or downgrade to your previous        │
│ version of Mirix.                                                           │
└─────────────────────────────────────────────────────────────────────────────┘
ERROR:    Traceback (most recent call last):
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\services\organization_manager.py", line 79, in create_organization
    org = self.get_organization_by_id(pydantic_org.id)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\utils.py", line 630, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\services\organization_manager.py", line 57, in get_organization_by_id
    organization = OrganizationModel.read(db_session=session, identifier=org_id)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\orm\sqlalchemy_base.py", line 40, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\orm\sqlalchemy_base.py", line 113, in wrapper
    raise e
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\orm\sqlalchemy_base.py", line 75, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\orm\sqlalchemy_base.py", line 440, in read
    raise NoResultFound(f"{cls.__name__} not found with {conditions_str}")
mirix.orm.errors.NoResultFound: Organization not found with id='org-00000000-0000-4000-8000-000000000000', is_deleted=False

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\engine\default.py", line 952, in do_execute
    cursor.execute(statement, parameters)
sqlite3.IntegrityError: UNIQUE constraint failed: organizations.id

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\server\server.py", line 193, in db_error_handler
    yield
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\server\server.py", line 380, in wrapped_execute
    return original_execute(*args, **kwargs)
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\engine\base.py", line 1419, in execute
    return meth(
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\sql\elements.py", line 527, in _execute_on_connection
    return connection._execute_clauseelement(
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\engine\base.py", line 1641, in _execute_clauseelement
    ret = self._execute_context(
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\engine\base.py", line 1846, in _execute_context
    return self._exec_single_context(
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\engine\base.py", line 1986, in _exec_single_context
    self._handle_dbapi_exception(
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\engine\base.py", line 2363, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\engine\default.py", line 952, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: organizations.id
[SQL: INSERT INTO organizations (name, id, created_at, _created_by_id, _last_updated_by_id) VALUES (?, ?, ?, ?, ?)]
[parameters: ('default_org', 'org-00000000-0000-4000-8000-000000000000', '2026-01-22 07:52:04.896150', None, None)]
(Background on this error at: https://sqlalche.me/e/20/gkpj)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\starlette\routing.py", line 694, in lifespan
    async with self.lifespan_context(app) as maybe_state:
  File "C:\Users\U03016034\AppData\Roaming\uv\python\cpython-3.10.19-windows-x86_64-none\lib\contextlib.py", line 199, in __aenter__
    return await anext(self.gen)
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\fastapi\routing.py", line 153, in merged_lifespan
    async with original_context(app) as maybe_original_state:
  File "C:\Users\U03016034\AppData\Roaming\uv\python\cpython-3.10.19-windows-x86_64-none\lib\contextlib.py", line 199, in __aenter__
    return await anext(self.gen)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\server\rest_api.py", line 119, in lifespan
    await initialize()
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\server\rest_api.py", line 83, in initialize
    server = get_server()
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\server\rest_api.py", line 67, in get_server
    _server = SyncServer()
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\server\server.py", line 504, in __init__
    self.default_org = self.organization_manager.create_default_organization()
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\utils.py", line 630, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\services\organization_manager.py", line 101, in create_default_organization
    return self.create_organization(
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\utils.py", line 630, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\services\organization_manager.py", line 82, in create_organization
    return self._create_organization(pydantic_org=pydantic_org)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\utils.py", line 630, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\services\organization_manager.py", line 95, in _create_organization
    org.create_with_redis(session, actor=None)  # ⭐ Auto-caches to Redis
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\orm\sqlalchemy_base.py", line 40, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\orm\sqlalchemy_base.py", line 148, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\orm\sqlalchemy_base.py", line 740, in create_with_redis
    session.commit()
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\orm\session.py", line 2030, in commit
    trans.commit(_to_root=True)
  File "<string>", line 2, in commit
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\orm\state_changes.py", line 137, in _go
    ret_value = fn(self, *arg, **kw)
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\orm\session.py", line 1311, in commit
    self._prepare_impl()
  File "<string>", line 2, in _prepare_impl
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\orm\state_changes.py", line 137, in _go
    ret_value = fn(self, *arg, **kw)
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\orm\session.py", line 1286, in _prepare_impl
    self.session.flush()
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\orm\session.py", line 4331, in flush
    self._flush(objects)
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\orm\session.py", line 4466, in _flush
    with util.safe_reraise():
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 224, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\orm\session.py", line 4427, in _flush
    flush_context.execute()
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 466, in execute
    rec.execute(self)
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 642, in execute
    util.preloaded.orm_persistence.save_obj(
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\orm\persistence.py", line 93, in save_obj
    _emit_insert_statements(
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\sqlalchemy\orm\persistence.py", line 1048, in _emit_insert_statements
    result = connection.execute(
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\server\server.py", line 379, in wrapped_execute
    with db_error_handler():
  File "C:\Users\U03016034\AppData\Roaming\uv\python\cpython-3.10.19-windows-x86_64-none\lib\contextlib.py", line 153, in __exit__
    self.gen.throw(typ, value, traceback)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\server\server.py", line 199, in db_error_handler
    exit(1)
  File "C:\Users\U03016034\AppData\Roaming\uv\python\cpython-3.10.19-windows-x86_64-none\lib\_sitebuiltins.py", line 26, in __call__
    raise SystemExit(code)
SystemExit: 1

ERROR:    Application startup failed. Exiting.

I read the information and it seems that I need to deploy a Database at local environment，how can I solve it? Thanks

[wangyu-ustc]

I see, normally if you don't have important data stored already, you can run rm ~/.mirix/sqlite.db to delete the current db, then rerun this start server script.

[iawe-UON]

I see, normally if you don't have important data stored already, you can run rm ~/.mirix/sqlite.db to delete the current db, then rerun this start server script.

I have tried your advice，it still had problems shown below：

Starting Mirix server in DEVELOPMENT mode...
  Host: 0.0.0.0
  Port: 8531
  Log level: info
  Auto-reload: False
  App: mirix.server.rest_api:app

Server will be available at:
  http://0.0.0.0:8531
  http://localhost:8531 (if host is 0.0.0.0)

API documentation available at:
  http://localhost:8531/docs (Swagger UI)
  http://localhost:8531/redoc (ReDoc)

Press CTRL+C to stop the server

2026-01-25 21:13:23 - Mirix - INFO - Logging to: console (level: INFO)
2026-01-25 21:13:27 - Mirix - INFO - DATABASE CONNECTION: SQLite mode
2026-01-25 21:13:27 - Mirix - INFO - Redis is disabled (MIRIX_REDIS_ENABLED=false)
2026-01-25 21:13:27 - Mirix - INFO - Redis integration disabled or unavailable
INFO:     Started server process [16692]
INFO:     Waiting for application startup.
2026-01-25 21:13:27 - Mirix - INFO - Starting Mirix REST API server
2026-01-25 21:13:27 - Mirix - INFO - Creating SyncServer instance
ERROR:    Traceback (most recent call last):
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\services\user_manager.py", line 37, in create_admin_user
    OrganizationModel.read(db_session=session, identifier=org_id)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\orm\sqlalchemy_base.py", line 40, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\orm\sqlalchemy_base.py", line 113, in wrapper
    raise e
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\orm\sqlalchemy_base.py", line 75, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\orm\sqlalchemy_base.py", line 441, in read
    raise NoResultFound(f"{cls.__name__} not found with {conditions_str}")
mirix.orm.errors.NoResultFound: Organization not found with id='org-00000000-0000-4000-8000-000000000000', is_deleted=False

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\starlette\routing.py", line 694, in lifespan
    async with self.lifespan_context(app) as maybe_state:
  File "C:\Users\U03016034\AppData\Roaming\uv\python\cpython-3.10.19-windows-x86_64-none\lib\contextlib.py", line 199, in __aenter__
    return await anext(self.gen)
  File "C:\Users\U03016034\Desktop\MIRIX\.venv\lib\site-packages\fastapi\routing.py", line 153, in merged_lifespan
    async with original_context(app) as maybe_original_state:
  File "C:\Users\U03016034\AppData\Roaming\uv\python\cpython-3.10.19-windows-x86_64-none\lib\contextlib.py", line 199, in __aenter__
    return await anext(self.gen)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\server\rest_api.py", line 119, in lifespan
    await initialize()
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\server\rest_api.py", line 83, in initialize
    server = get_server()
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\server\rest_api.py", line 67, in get_server
    _server = SyncServer()
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\server\server.py", line 504, in __init__
    self.admin_user = self.user_manager.create_admin_user()
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\utils.py", line 630, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\U03016034\Desktop\MIRIX\mirix\services\user_manager.py", line 39, in create_admin_user
    raise ValueError(
ValueError: No organization with org-00000000-0000-4000-8000-000000000000 exists in the organization table.

I just wanna to run the test example and figure out the implementation of the source code. So all the operations I did was following the instructions.

[wangyu-ustc]

I just pushed a new commit in main branch, would you mind pulling the newest version and see if the problem persists? Thanks!