From noreply at bugs.horde.org Mon Nov 18 11:59:22 2024 From: noreply at bugs.horde.org (noreply at bugs.horde.org) Date: Mon, 18 Nov 2024 11:59:22 +0000 Subject: [Tickets #14639] Re: Primary key on all tables of horde database In-Reply-To: References: Message-ID: <20241118115922.Horde.bJvDH1wNN7iK4NlodHdnRM_@bugs.horde.org> DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED. Ticket URL: https://bugs.horde.org/ticket/14639 ------------------------------------------------------------------------------ Ticket | 14639 Updated By | steveqwe at gmail.com Summary | Primary key on all tables of horde database Queue | Horde Groupware Webmail Edition Version | 5.2.20 Type | Bug State | Feedback Priority | 1. Low Milestone | Patch | Owners | ------------------------------------------------------------------------------ steveqwe at gmail.com (2024-11-18 11:59) wrote: Looks like Horde project is dead, php code has plenty of bugs using php 8.1 and up, cluster sql server compatibility is not a priority, is there anyone still develping Horde ? > Hello, Horde team > > I try to deplo horde on Mysql Innodb cluster or Galera cluster, but > these environments require primary key on all database tables. These > are the database logs that describe the problem: > > 'Table horde_auth_schema_info does not have any PRIMARY KEY. This is > not compatible with Group Replication' > 'Table horde_cache_schema_info does not have any PRIMARY KEY. This > is not compatible with Group Replication' > 'Table horde_core_schema_info does not have any PRIMARY KEY. This is > not compatible with Group Replication' > 'Table horde_dav_schema_info does not have any PRIMARY KEY. This is > not compatible with Group Replication' > 'Table horde_group_schema_info does not have any PRIMARY KEY. This > is not compatible with Group Replication' > 'Table horde_groups_members does not have any PRIMARY KEY. This is > not compatible with Group Replication' > 'Table horde_history_schema_info does not have any PRIMARY KEY. This > is not compatible with Group Replication' > 'Table horde_imap_client_schema_info does not have any PRIMARY KEY. > This is not compatible with Group Replication' > 'Table horde_lock_schema_info does not have any PRIMARY KEY. This is > not compatible with Group Replication' > 'Table horde_perms_schema_info does not have any PRIMARY KEY. This > is not compatible with Group Replication > > Is it predicted to add primary key to all tables at some subsequent > distribution of horde? > > If I add a primary key to all the tables, do you think the Horde > will work properly or will problems occur? > > You can see for this requirement for example in url: > https://mariadb.com/kb/en/mariadb/mariadb-galera-cluster-known-limitations/ > > Thank you. > Antonis Limperis > > >