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
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
to comment on this ticket.