[Agilo for Trac] OperationalError: table cache already exists" in sqlite

[Ricard Fusté]

Hi,

I'm trying to upgrade a sqlite database from database_Version = '21' and
I'm getting the following error when executing *trac-admin myproject
upgrade* command:

*The upgrade failed. Please fix the issue and try again.*

*OperationalError: table cache already exists*

Agilo log file shows the following error:
2014-09-25 00:02:16,825 Trac[console] ERROR: Exception in trac-admin
command:
Traceback (most recent call last):
File "D:\Python27\lib\site-packages\trac\admin\console.py", line 109, in
onecmd
rv = cmd.Cmd.onecmd(self, line) or 0
File "D:\Python27\lib\cmd.py", line 220, in onecmd
return self.default(line)
File "D:\Python27\lib\site-packages\trac\admin\console.py", line 285, in
default
return cmd_mgr.execute_command(*args)
File "D:\Python27\lib\site-packages\trac\admin\api.py", line 124, in
execute_command
return f(*fargs)
File "D:\Python27\lib\site-packages\trac\env.py", line 982, in _do_upgrade
self.env.upgrade(backup=no_backup is None)
File "D:\Python27\lib\site-packages\trac\env.py", line 713, in upgrade
participant.upgrade_environment(db)
File "D:\Python27\lib\site-packages\trac\env.py", line 780, in
upgrade_environment
script.do_upgrade(self.env, i, cursor)
File "D:\Python27\lib\site-packages\trac\upgrades\db22.py", line 11, in
do_upgrade
cursor.execute(stmt)
File "D:\Python27\lib\site-packages\trac\db\util.py", line 66, in execute
return self.cursor.execute(sql)
File "D:\Python27\lib\site-packages\trac\db\sqlite_backend.py", line 78,
in execute
result = PyFormatCursor.execute(self, *args)
File "D:\Python27\lib\site-packages\trac\db\sqlite_backend.py", line 56,
in execute
args or [])
File "D:\Python27\lib\site-packages\trac\db\sqlite_backend.py", line 48,
in _rollback_on_error
return function(self, *args, **kwargs)
*OperationalError: table cache already exists*

*NOTE:* The database I'm trying to upgrade is the database delivered with
Agilo Pro 1.3.13 in the test environment.

The releases used in my environment are:
Agilo PRO 1.3.13
Trac 1.0.1
Python 2.7.8
setuptools 5.4.1
pysqlite 2.6.0
sqlite database library 3.8.7
Windows 7

Any advice ?

Thanks in advance,

Ricard.
--
--
Follow Agilo on Twitter: http://twitter.com/agilofortrac
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-trac
http://freshmeat.net/projects/agiloforscrum

You have received this message because you are subscribed to
the "Agilo for Trac" Google Group. This group is focused on
supporting Agilo for Trac users and is moderated by
Agilo Software GmbH <http://www.agilosoftware.com>.

To post to this group, send email to agilo-/***@public.gmane.org
To unsubscribe from this group, send an email to
agilo+unsubscribe-/***@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/agilo

---
You received this message because you are subscribed to the Google Groups "Agilo for Trac" group.
To unsubscribe from this group and stop receiving emails from it, send an email to agilo+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/***@public.gmane.org
For more options, visit https://groups.google.com/d/optout.

[Stefano Rago]

Hi Ricard,
could you please try and reproduce the problem on a fresh environment? If you manage to do that, can you please post exact steps for reproducing it?

Thanks,
Stefano Rago
--
--
Follow Agilo on Twitter: http://twitter.com/agilofortrac
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-trac
http://freshmeat.net/projects/agiloforscrum

You have received this message because you are subscribed to
the "Agilo for Trac" Google Group. This group is focused on
supporting Agilo for Trac users and is moderated by
Agilo Software GmbH <http://www.agilosoftware.com>.

To post to this group, send email to agilo-/***@public.gmane.org
To unsubscribe from this group, send an email to
agilo+unsubscribe-/***@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/agilo

---
You received this message because you are subscribed to the Google Groups "Agilo for Trac" group.
To unsubscribe from this group and stop receiving emails from it, send an email to agilo+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/***@public.gmane.org
For more options, visit https://groups.google.com/d/optout.