Error when running with `read_only=True`

[parkervg]

Hi,

I'm trying to use flock in the code below:

with duckdb.connect(DUCKDB_DB_PATH, read_only=True) as con:
    con.install_extension("flock", repository="community", version=FLOCK_VERSION)
    con.load_extension("flock")

    con.execute(
        """
        CREATE SECRET (
            TYPE OPENAI,
            BASE_URL 'http://localhost:11434/v1',
            API_KEY 'N.A.'
        )
        """
    )

    # Create model configuration
    con.execute(
        f"""
        CREATE MODEL(
            '{MODEL_CONFIG.ollama_model_name}',
            '{MODEL_CONFIG.ollama_model_name}', 
            'openai',
            {{"tuple_format": "JSON", "batch_size": {SYSTEM_PARAMS['batch_size']}, "model_parameters": {{"temperature": {MODEL_PARAMS['temperature']}}}}}
        )
        """
    )

In the con.execute under # Create model configuration, I get the following error:

_duckdb.CatalogException: Catalog Error: Table with name FLOCKMTL_MODEL_USER_DEFINED_INTERNAL_TABLE does not exist!
Did you mean "flock_storage.flock_config.FLOCKMTL_MODEL_USER_DEFINED_INTERNAL_TABLE"?

When I change read_only=False, the error does not occur.

System info:

• Ubuntu 25.04
• flock@7f1c36a

[anasdorbani]

@parkervg We’ve completed a major refactor to address the related issues. Could you verify that the problem no longer occurs by running the following?

pip install duckdb==1.4.4

import duckdb

conn = duckdb.connect(":memory:")

conn.execute("FORCE INSTALL flock FROM community")
conn.execute("LOAD flock")

conn.execute("GET PROMPTS;")
print(conn.fetchall())

conn.execute("select * from duckdb_extensions() where extension_name = 'flock'")
print(conn.fetchall())

If everything works properly you can then check your script. Please let me know if you run into any problems so we can address them.