Donnchadh McAuliffe

    Donnchadh McAuliffe

    7 months ago
    Hey guys, I've upgraded from prefect orion
    2.0a9
    to
    2.0a12
    . When I try run the server
    prefect orion start
    it throws this error:
    sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table flow already exists
    how do I get around this?
    Anna Geller

    Anna Geller

    7 months ago
    Try:
    prefect orion database reset
    This page explains it more: https://orion-docs.prefect.io/getting-started/installation/#upgrading-the-database
    Donnchadh McAuliffe

    Donnchadh McAuliffe

    7 months ago
    "Resetting the database with the CLI command 
    prefect orion database reset
     is not compatible a database from 2.0a9 or earlier. Instead, delete the database file 
    ~/.prefect/orion.db
    " Deleting the database manually worked
    thanks again for your help