Modify

Opened 7 years ago

Closed 6 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 6 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 6 years ago by anonymous

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

Add Comment

Modify Ticket

Action
as closed .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from bobbysmith007. Next status will be '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.