#168 ipsilon-upgrade-database idx_association_uuid
Opened 9 years ago by kshi. Modified 8 years ago

We tried to run ipsilon-upgrade-database to upgrade from 1.0.0 to 1.1.0 and getting the following error

(OperationalError) index idx_association_uuid already exists u'CREATE
INDEX idx_association_uuid ON association (uuid)' ()

Is there something that needs to be done before the script is ran?


What version of Ipsilon are you running now, and what were you running previously?
If it's an RPM release, please include the RPM subversions.

Did you follow master in between releases, or did you upgrade from releases?

owner: => puiterwijk
status: new => accepted

We are currently running 1.0.0. We were not running anything else previously

not using any RPMs. We are downloading release tarballs.

_comment0: We are currently running 1.0.0 currently. We were not running anything else previously

not using any RPMs. We are downloading release tarballs.

=> 1442418035880727

This should work, since 1.0.0 did not create the indices.
Could you change the logging verbosity in the upgrade tool by changing line 16 in ipsilon-upgrade-database from logging.ERROR to logging.DEBUG, rerun the tool, and attach the output?

setting logging.DEBUG didn't do anything. It looksllike the exception occurs before any logging.DEBUG calls are made.

Could you give me a schema dump of the various databases?

You should be able to get this by running: sqlite3 /var/lib/ipsilon/<instance>/<database>.sqlite .schema.

Metadata Update from @puiterwijk:
- Issue assigned to puiterwijk

8 years ago

Log in to comment on this ticket.

Metadata