installation of 1.4.7 with postgres database not possible

[podskalsky]

The installation of 1.4.7 (unpatched) on a new trac project with postgres database is not possible!

TracGenericClass ... OK TracGenericWorkflow ... FAILED

# trac-admin /data/trac/newt upgrade --no-backup
InternalError: current transaction is aborted, commands ignored until end of transaction block

[podskalsky]

trac.log:

2011-09-09 11:31:10,855 Trac[model] DEBUG: Need to create db tables for class 'resourceworkflowstate'.
2011-09-09 11:31:10,855 Trac[env] WARNING: Component <tracgenericworkflow.model.GenericWorkflowModelProvider object at 0x8bd492c> requires environment upgrade
2011-09-09 11:31:10,857 Trac[model] DEBUG: Need to create db tables for class 'resourceworkflowstate'.
2011-09-09 11:31:10,858 Trac[env] INFO: tracgenericworkflow.model.GenericWorkflowModelProvider upgrading...
2011-09-09 11:31:10,859 Trac[model] DEBUG: Need to create db tables for class 'resourceworkflowstate'.
2011-09-09 11:31:10,860 Trac[model] INFO: Upgrading DB...
2011-09-09 11:31:10,861 Trac[model] INFO: Creating base table resourceworkflowstate...
2011-09-09 11:31:10,861 Trac[model] DEBUG: CREATE TABLE "resourceworkflowstate" (
    "id" text,
    "res_realm" text,
    "state" text,
    CONSTRAINT "resourceworkflowstate_pk" PRIMARY KEY ("id","res_realm")
)
2011-09-09 11:31:10,864 Trac[model] ERROR: ('InternalError', '<no args>', ['  File "build/bdist.linux-i686/egg/tracgenericclass/model.py", line 1286, in upgrade_db\n    cursor.execute(stmt)\n', '  File "/usr/lib/python2.6/site-packages/Trac-0.12.2-py2.6.egg/trac/db/util.py", line 66, in execute\n    return self.cursor.execute(sql)\n'])
2011-09-09 11:31:10,864 Trac[model] ERROR: Exception during database creation.
2011-09-09 11:31:10,867 Trac[console] ERROR: Exception in trac-admin command:
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/Trac-0.12.2-py2.6.egg/trac/admin/console.py", line 107, in onecmd
    rv = cmd.Cmd.onecmd(self, line) or 0
  File "/usr/lib/python2.6/cmd.py", line 218, in onecmd
    return self.default(line)
  File "/usr/lib/python2.6/site-packages/Trac-0.12.2-py2.6.egg/trac/admin/console.py", line 266, in default
    return cmd_mgr.execute_command(*args)
  File "/usr/lib/python2.6/site-packages/Trac-0.12.2-py2.6.egg/trac/admin/api.py", line 123, in execute_command
    return f(*fargs)
  File "/usr/lib/python2.6/site-packages/Trac-0.12.2-py2.6.egg/trac/env.py", line 782, in _do_upgrade
    self.env.upgrade(backup=no_backup is None)
  File "/usr/lib/python2.6/site-packages/Trac-0.12.2-py2.6.egg/trac/env.py", line 525, in upgrade
    with_transaction(self)(participant.upgrade_environment)
  File "/usr/lib/python2.6/site-packages/Trac-0.12.2-py2.6.egg/trac/db/api.py", line 77, in transaction_wrapper
    fn(ldb)
  File "build/bdist.linux-i686/egg/tracgenericworkflow/model.py", line 138, in upgrade_environment
    upgrade_db(self.env, self.SCHEMA, db)
  File "build/bdist.linux-i686/egg/tracgenericclass/model.py", line 1286, in upgrade_db
    cursor.execute(stmt)
  File "/usr/lib/python2.6/site-packages/Trac-0.12.2-py2.6.egg/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
InternalError: current transaction is aborted, commands ignored until end of transaction block
InternalError: current transaction is aborted, commands ignored until end of transaction block

[Roberto Longobardi]

Hi, I found some time to work on this plugin today and I have attached a development 1.4.8 version to ticket #9208 that also contains a rewritten, more robust installation and upgrade mechanism, derived from the Trac one.

It only upgrades from 1.4.7 to 1.4.8, it does not work as an upgrade form previous versions, anyway if you could try it out on PostgreSQL it would help.

You may also want to take a look at ​this post and maybe give your opinion.

Please, let me know if the basic installation and the upgrade from 1.4.7 work with the 1.4.8 dev version.

Ciao, Roberto

[podskalsky]

Hy,

I've tested the installation of your 1.4.8 plugin:

from > to > result

1.4.6 > 1.4.8 = update installation ok
1.4.7 > 1.4.8 = update installation ok
none  > 1.4.8 = initial installation ok

Ciao, Andreas

[Roberto Longobardi]

Fixed with ​1.4.8.