Modify

Opened 7 years ago

Closed 7 years ago

#2437 closed defect (fixed)

trac-admin upgrade fails

Reported by: anonymous Owned by: bobbysmith007
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords:
Cc: gunnar_thielebein@… Trac Release: 0.11

Description

When I install t&e plugin it fails to upgrade
the (pg) database.

Message that appears:

trac-admin sandbox/ upgrade --no-backup
Timing and Estimation needs an upgrade
Upgrading Database
Upgrading reports
Upgrading fields
Done Upgrading
Upgrade done.

but no tables/columns are created.

for note: This trac environment was migrated from 0.10.4 to current 0.11dev-r6397.
t&e is from trunk: r3094

I have dumped a sql log of the upgrade process here: http://pastebin.com/f11557992

Attachments (0)

Change History (6)

comment:1 Changed 7 years ago by anonymous

  • Cc gunnar_thielebein@… added

comment:2 Changed 7 years ago by bobbysmith007

I am working on this. I dont run trac with postgres so it may take me a couple tries to guess what is going wrong. Hopefully though, given the log you sent I should be able to spot whats wrong.

comment:3 Changed 7 years ago by anonymous

hm, so you think its database related?
please tell me if you need some further info...

cheers

comment:4 Changed 7 years ago by bobbysmith007

I am not actually sure why it is in the state it is in (perhaps a different setting of auto commit or something).

Try executing:

UPDATE system SET value=0 WHERE name='custom_report_manager_version'

and running the upgrade again with it recording. Currently, it sees that it isn't missing the table 'custom_report', due to the version number. With a sqllog of the first call to upgrade after executing that statement, I might be able to spot what is going wrong.

Thanks,

Russ

comment:5 Changed 7 years ago by tekknokrat

Sorry for the delay. I was today able to test this.
The upgrade process wents fine with setting the value to 0!
I see no other error messages so far...

comment:6 Changed 7 years ago by anonymous

  • Resolution set to fixed
  • Status changed from new to closed

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.