search

atviriduomenys / spinta

Spinta is a framework to describe, extract and publish data (a DEP Framework).
MIT License
10 stars 4 forks source link

OperationalError: out of shared memory #521

Closed sirex closed 8 months ago

sirex commented 9 months ago

When running:

spinta bootstrap

I get following error:

OperationalError: (psycopg2.errors.OutOfMemory) out of shared memory
HINT:  You might need to increase max_locks_per_transaction.

Resources

sirex commented 9 months ago

After changing this line:

backend.schema.create_all(checkfirst=True)

to:

with (
    backend.engine.connect().
    execution_options(isolation_level='AUTOCOMMIT')
) as conn:
    backend.schema.create_all(conn, checkfirst=True)

Error is gone.