Bug 153322 - www/trac-timingandestimation fails to install
Summary: www/trac-timingandestimation fails to install
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: Normal Affects Only Me
Assignee: Greg Larkin
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-12-20 20:00 UTC by Sergey Chernikov
Modified: 2011-01-03 20:24 UTC (History)
0 users

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Sergey Chernikov 2010-12-20 20:00:22 UTC 
DB backend is PostgreSQL 8.4.5.

Upgrading Database Creating bill_date table InternalError: current transaction is aborted, commands ignored until end of transaction block

trac.log warnings and errors for this trac-admin run:

2010-12-19 13:16:43,119 Trac[console] ERROR: Exception in trac-admin command: Traceback (most recent call last):

    File "build/bdist.freebsd-8.2-PRERELEASE-amd64/egg/trac/admin/console.py", line 107, in one cmd
    rv = cmd.Cmd.onecmd(self, line) or 0

    File "/usr/local/lib/python2.6/cmd.py", line 218, in onecmd
        return self.default(line)

    File "build/bdist.freebsd-8.2-PRERELEASE-amd64/egg/trac/admin/console.py", line 257, in default
    return cmd_mgr.execute_command(*args)

    File "build/bdist.freebsd-8.2-PRERELEASE-amd64/egg/trac/admin/api.py", line 123, in execute_command
    return f(*fargs)

    File "build/bdist.freebsd-8.2-PRERELEASE-amd64/egg/trac/env.py", line 790, in _do_upgrade
        self.env.upgrade(backup=no_backup is None)

    File "build/bdist.freebsd-8.2-PRERELEASE-amd64/egg/trac/env.py", line 533, in upgrade
        with_transaction(self)(participant.upgrade_environment)

    File "build/bdist.freebsd-8.2-PRERELEASE-amd64/egg/trac/db/api.py", line 77, in transaction_wrapper
        fn(ldb)

    File "build/bdist.freebsd-8.2-PRERELEASE-amd64/egg/timingandestimationplugin/api.py", line 266, in upgrade_environment
        self.do_db_upgrade()

    File "build/bdist.freebsd-8.2-PRERELEASE-amd64/egg/timingandestimationplugin/api.py", line 114, in do_db_upgrade
        dbhelper.set_system_value(self.env, self.db_version_key, self.db_version)

    File "build/bdist.freebsd-8.2-PRERELEASE-amd64/egg/timingandestimationplugin/dbhelper.py", line 104, in set_system_value
        value, key)

    File "build/bdist.freebsd-8.2-PRERELEASE-amd64/egg/timingandestimationplugin/dbhelper.py", line 20, in execute_non_query
        execute_in_trans(env, (sql, params))

    File "build/bdist.freebsd-8.2-PRERELEASE-amd64/egg/timingandestimationplugin/dbhelper.py", line 58, in execute_in_trans
        raise e

InternalError: current transaction is aborted, commands ignored until end of transaction block
InternalError: current transaction is aborted, commands ignored until end of transaction block

I've filled a ticket on trac-hacks.org (#8324) it was closed with resolution: "Inappropriate plugin version is used"

How-To-Repeat: cd /usr/ports/www/trac-timingandestimation && make install clean
trac-admin <env> upgrade
Comment 1 Edwin Groothuis freebsd_committer freebsd_triage 2010-12-20 20:00:30 UTC 
Responsible Changed
From-To: freebsd-ports-bugs->glarkin

Over to maintainer (via the GNATS Auto Assign Tool)
Comment 2 Greg Larkin freebsd_committer freebsd_triage 2010-12-22 22:24:57 UTC 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Sergey,

Can you confirm for me what version of trac-timingandestimation you are
attempting to install?  Please run the following command and post to
this PR:

cd /usr/ports/www/trac-timingandestimation && make -V PORTVERSION

My guess is that it's the current version in the ports tree, but I want
to be sure.  The upgrade process works fine on a SQLite-backed Trac
installation, and I am testing against PostgreSQL to see what could
cause the issue you reported.

Thank you,
Greg
- --
Greg Larkin

http://www.FreeBSD.org/           - The Power To Serve
http://www.sourcehosting.net/     - Ready. Set. Code.
http://twitter.com/sourcehosting/ - Follow me, follow you
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iD8DBQFNEnq50sRouByUApARAmCEAKC6JFoT2EXcqBpRNnPDorEnardfyACgix0e
5n4YugqVewkppl+Q9MVk8YA=
=caGk
-----END PGP SIGNATURE-----
Comment 3 Greg Larkin freebsd_committer freebsd_triage 2010-12-22 23:28:57 UTC 
State Changed
From-To: open->analyzed

I reopened the ticket at trac-hacks.org with a comment for the 
T&E plugin author: http://trac-hacks.org/ticket/8324#comment:5 

I have reproduced the problem, and I will work with him to resolve 
it.
Comment 4 dfilter service freebsd_committer freebsd_triage 2011-01-03 20:18:45 UTC 
glarkin     2011-01-03 20:18:40 UTC

  FreeBSD ports repository

  Modified files:
    www/trac-timingandestimation Makefile distinfo 
  Log:
  - Updated to 1.0.8b to fix PostgreSQL-related bug noted in PR and in
    http://trac-hacks.org/ticket/8324
  
  PR:             ports/153322
  Submitted by:   Sergey Chernikov <s dot bilberry at gmail dot com>
  Assisted by:    Russ Tyndall at Acceleration.net (upstream maintainer)
  
  Revision  Changes    Path
  1.6       +3 -2      ports/www/trac-timingandestimation/Makefile
  1.3       +2 -2      ports/www/trac-timingandestimation/distinfo
_______________________________________________
cvs-all@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/cvs-all
To unsubscribe, send any mail to "cvs-all-unsubscribe@freebsd.org"
Comment 5 Greg Larkin freebsd_committer freebsd_triage 2011-01-03 20:23:24 UTC 
State Changed
From-To: analyzed->closed

Committed update to new version 1.0.8b after upsteam maintainer fix. 
Thank you for your PR!