Re: [Trac] Trac upgrade

Hello,

Thank you.  I had dropped and recreated the system table as part of the 
process to get everything using utfmb4_bin, and I did not realize that the 
restore for the system table didn't restore anything.  I added the lines 
and the upgrade succeeded.

I'm very glad I asked.  I could have spent a very, very long time looking 
into that.

Thank you,

Gordon

On Wednesday, December 4, 2024 at 7:58:10 PM UTC-5 Jun Omae wrote:

> Hi,
>
> On 2024/12/05 7:50, Gordon McKinnon wrote:
> > Hello,
> > 
> > I'm migrating a trac instance from Redhat 6 to Redhat 9.  Upgrading the 
> mysql database from 5.1 to 8.0.36 was interesting, imported to 5.7, 
> upgrade, mysqlsh, delete broken stuff, import to 8, update everything to 
> use utfmb4 and innodb, backup, modify, delete, and restore the system 
> table, but it seems to have worked out.
> > 
> > I'm trying to run TRAC 1.6 because I don't  want to compile python2 on 
> redhat 9.  
> > 
> > I installed some components via rpm, and I did a pip install.  I also 
> did an easy_install, so that might not be ideal, there are two tracd 
> binaries and two trac_admins, but they are pretty similar.  Using either 
> one I get:
> > 
> > 2024-12-04 17:30:43,029 Trac[api] INFO: Need to upgrade database_version 
> from 0 to 45
> > 2024-12-04 17:30:43,029 Trac[env] WARNING: Component <Component 
> trac.db.api.DatabaseManager> requires an environment upgrade
> > 2024-12-04 17:30:43,068 Trac[api] INFO: Need to upgrade database_version 
> from 0 to 45
> > 2024-12-04 17:30:43,068 Trac[env] WARNING: Component <Component 
> trac.db.api.DatabaseManager> requires an environment upgrade
> > 2024-12-04 17:30:43,069 Trac[api] INFO: Need to upgrade database_version 
> from 0 to 45
> > 2024-12-04 17:30:47,841 Trac[env] INFO: upgrading <Component 
> trac.db.api.DatabaseManager>...
> > 2024-12-04 17:30:47,845 Trac[env] WARNING: Component <Component 
> trac.db.api.DatabaseManager> failed with TracError: No upgrade module 
> trac.upgrades.db1.py
> > 
> > I don't see any reference to that module anywhere.  Has anyone 
> encountered this and resolved it?
> > 
> > Thank you,
> > 
> > Gordon
>
> It seems that your migrating MySQL database from 5.1 to 8.0.36 is wrong.
>
> > 2024-12-04 17:30:43,029 Trac[api] INFO: Need to upgrade database_version 
> from 0 to 45
>
> The `0` is retrieved from `database_version` record in `system` table but 
> the value is never `0`.
>
> The following is from database for Trac 0.12.x
> [[[
> mysql> SELECT * FROM `system`;
> +--------------------------+-------+
> | name | value |
> +--------------------------+-------+
> | database_version | 26 |
> | initial_database_version | 26 |
> +--------------------------+-------+
> 2 rows in set (0.03 sec)
> ]]]
>
> The value of `database_version` is depended on the Trac version:
>
> [[[
> | database_version
> ------------+------------------
> Trac 0.12.x | 26
> Trac 1.0.x | 29
> Trac 1.2.x | 41
> Trac 1.4.x | 45
> Trac 1.6.x | 45
> ]]]
>
> -- 
> Jun Omae <[email protected]> (大前 潤)
>

-- 
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected]
To view this discussion visit https://groups.google.com/d/msgid/trac-users/9b0adca2-349f-4944-95ed-d345f213effcn%40googlegroups.com.