Does the new assets system not let ComfyUI work offline anymore?

[taoofai]

Custom Node Testing

• I have tried disabling custom nodes and the issue persists (see how to disable custom nodes if you need help)

Expected Behavior

ComfyUI works offline as normal, which was working fine a few days ago before the new asset system PR yesterday.

Actual Behavior

ComfyUI will not load. The web interface will not load. There are errors in the console.

Steps to Reproduce

New ComfyUI install, run ComfyUI with all internet access disabled.

Debug Logs

Traceback (most recent call last):
  File "/home/appuser/.local/lib/python3.13/site-packages/aiohttp/web_protocol.py", line 510, in _handle_request
    resp = await request_handler(request)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/appuser/.local/lib/python3.13/site-packages/aiohttp/web_app.py", line 569, in _handle
    return await handler(request)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/appuser/.local/lib/python3.13/site-packages/aiohttp/web_middlewares.py", line 117, in impl
    return await handler(request)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/app/ComfyUI/middleware/cache_middleware.py", line 27, in cache_control
    response: web.Response = await handler(request)
                             ^^^^^^^^^^^^^^^^^^^^^^
  File "/app/ComfyUI/server.py", line 83, in deprecation_warning
    response: web.Response = await handler(request)
                             ^^^^^^^^^^^^^^^^^^^^^^
  File "/app/ComfyUI/server.py", line 173, in origin_only_middleware
    response = await handler(request)
               ^^^^^^^^^^^^^^^^^^^^^^
  File "/app/ComfyUI/server.py", line 689, in get_object_info
    seed_assets(["models"])
    ~~~~~~~~~~~^^^^^^^^^^^^
  File "/app/ComfyUI/app/assets/scanner.py", line 78, in seed_assets
    with create_session() as sess:
         ~~~~~~~~~~~~~~^^
  File "/app/ComfyUI/app/database/db.py", line 112, in create_session
    return Session()
TypeError: 'NoneType' object is not callable

Other

No response

[benlahouel-sketch]

Kill the manager and your good to go. disable the thing.

[taoofai]

How can I kill the manager if ComfyUI won't even load though?

Not exactly the same issue/error as mine, but like this issue #11792 my ComfyUI won't load since the PR #11315

Ever since that PR I have not been able to load ComfyUI in my docker container, and I have been using the same dockerfile config for months for generating the ComfyUI images and running ComfyUI

It seems since my ComfyUI docker container images don't have internet access that that PR mentioned above is failing to access the external DB or something and then never loading ComfyUI

[Kosinkadink]

Everything with the database is local, that error is very odd. The database is in user/comfyui.db file in ComfyUI directory. I will take a look.

[taoofai]

Everything with the database is local, that error is very odd. The database is in user/comfyui.db file in ComfyUI directory. I will take a look.

Thanks, I did notice this db initialization error above the error I posted above during the initial loading phase:

Import times for custom nodes:
   0.0 seconds: /app/ComfyUI/custom_nodes/websocket_image_save.py
   0.0 seconds: /app/ComfyUI/custom_nodes/ComfyUI-VideoHelperSuite
   0.1 seconds: /app/ComfyUI/custom_nodes/ComfyUI-KJNodes
   0.3 seconds: /app/ComfyUI/custom_nodes/ComfyUI-nunchaku
   0.7 seconds: /app/ComfyUI/custom_nodes/ComfyUI-SeedVR2_VideoUpscaler

Failed to initialize database. Please ensure you have installed the latest requirements. If the error persists, please report this as in future the database will be required: (sqlite3.OperationalError) unable to open database file
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Starting server

To see the GUI go to: http://0.0.0.0:8188

[taoofai]

Everything with the database is local, that error is very odd. The database is in user/comfyui.db file in ComfyUI directory. I will take a look.

Ok, played around with it all more:

    volumes:
      - ../../volumes/models:/app/ComfyUI/models:ro
      - ../../volumes/comfyui/input:/app/ComfyUI/input:rw
      - ../../volumes/comfyui/output:/app/ComfyUI/output:rw
      - ../../volumes/comfyui/user:/app/ComfyUI/user/default:rw

It turns out by removing that last external docker volume link to the ComfyUI user directory in my docker compose 'fixes' it:

    volumes:
      - ../../volumes/models:/app/ComfyUI/models:ro
      - ../../volumes/comfyui/input:/app/ComfyUI/input:rw
      - ../../volumes/comfyui/output:/app/ComfyUI/output:rw

I've had that there for months so it is now 'new' that I have to remove that to allow ComfyUI to be usable.

And when I remove that ComfyUI doesn't start up with that db initialization error but instead it shows this now and works again:

Import times for custom nodes:
   0.0 seconds: /app/ComfyUI/custom_nodes/websocket_image_save.py
   0.0 seconds: /app/ComfyUI/custom_nodes/ComfyUI-VideoHelperSuite
   0.1 seconds: /app/ComfyUI/custom_nodes/ComfyUI-KJNodes
   0.4 seconds: /app/ComfyUI/custom_nodes/ComfyUI-nunchaku
   0.9 seconds: /app/ComfyUI/custom_nodes/ComfyUI-SeedVR2_VideoUpscaler

Context impl SQLiteImpl.
Will assume non-transactional DDL.
Context impl SQLiteImpl.
Will assume non-transactional DDL.
Running upgrade  -> 0001_assets, Initial assets schema
Revision ID: 0001_assets
Revises: None
Create Date: 2025-12-10 00:00:00
Database upgraded from None to 0001_assets
Assets scan(roots=['models']) completed in 0.159s (created=242, skipped_existing=0, total_seen=242)
Starting server

To see the GUI go to: http://0.0.0.0:8188

So it seems it's not a 'no internet' or 'offline' issue, but more an issue with the db initialization and it seems I can't have the ComfyUI user dir as a volume share in docker anymore.

Perhaps a permission issue or something 'new' with the new db/assets scheme?

The fact I can still have volume links to the ComfyUI models, input, and output directories is fine enough for me, I don't really 'need' the user directory as a volume link.

[coavins]

I'm having the same problem. I use a bind mount for /app/ComfyUI/user/default/workflows to save the workflows on my host system, and the database fails to initialize somewhere under /app/ComfyUI/user if I keep this bind mount in my compose file.

[Kosinkadink]

I dont think database initialization changed with the initial assets PR. ill take a look

[coavins]

To clarify, my problem is only that the database fails to initialize if I use a bind mount on /app/ComfyUI/user/default/workflows. I have had this problem for around half a year, but only recently this has actually stopped me from using comfyui.