On Mon, Sep 3, 2018 at 7:31 PM Mingxing Tian <[email protected]> wrote:
> RjOllos於 2018年9月4日星期二 UTC+8上午10時00分41秒寫道： > >> >> On Monday, September 3, 2018 at 6:58:08 PM UTC-7, Mingxing Tian wrote: >>> >>> I confirm that the engine is already InnoDB, but it still detects errors. >>> >>> [image: 0001.png] >>> C:\Users\Administrator>trac-admin "D:\myproject" deploy >>> "D:\myproject_deploy" >>> Error: The current storage engine is MyISAM. It must be InnoDB or NDB >>> storage engine to support transactions. >>> >> >> >> Which version of Trac and which version of MySQL? >> >> - Ryan >> > > > I have found out that something went wrong. I changed the default engine > of the entire database instance to InnoDB. > Did you edit my.cnf to make that change? As in: https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_storage_engine > I think you should not check the engine of the entire instance, but one of > the specific database engines. This is an optimization. local. > The engine for each table and the default engine are both checked: https://trac.edgewall.org/browser/tags/trac-1.2.3/trac/db/mysql_backend.py?marks=308-315,336-341#L296 It was implemented in #10993: https://trac.edgewall.org/ticket/10993 I don't see a way to set a persistent default storage engine for each database/schema. However, rather than requiring the MySQL instance default storage engine to be set (in the system-wide my.cnf configuration), we could possibly have a trac.ini configuration option to specify the storage engine and explicitly set the default for the session before creating the tables, or use the ENGINE option when creating tables: https://dev.mysql.com/doc/refman/8.0/en/storage-engine-setting.html I'm not sure of the best solution, but we do need better documentation in: https://trac.edgewall.org/wiki/MySqlDb I will wait to see what Jun has to say before opening a new ticket. default-storage-engine=INNODB > > Unfortunately, configuration changes must be made to the database > instance, not the database. > - Ryan -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/d/optout.
