Summary | Primary key on all tables of horde database |
Queue | Horde Groupware Webmail Edition |
Queue Version | 5.2.20 |
Type | Bug |
State | Feedback |
Priority | 1. Low |
Owners | |
Requester | limperis (at) cti (dot) gr |
Created | 05/10/2017 (2926 days ago) |
Due | |
Updated | 11/18/2024 (177 days ago) |
Assigned | 05/10/2017 (2926 days ago) |
Resolved | |
Milestone | |
Patch | No |
php 8.1 and up, cluster sql server compatibility is not a priority, is
there anyone still develping Horde ?
sync sync. I cannot Delete Mails on my active sync device. The cause
seem here to be duplicate key error on device. After emptying
activesync tables in mysql and readding the active sync device it
works for a couple of hours and after i cannot delete again.
ok
I created the primary keys on all the tables that they did not exist
and after that it became possible work on Galera Spin and Mysql Innodb
cluster.
I think the development team might consider it for one of the next updates
implementation based on mysql cluster, without primary key on all
tables!
cannot deploy certain horde tables on a cluster when using a
combination of InnoDB table, MariaDB, and Galera. Which is a
completely different thing.
content_schema_info
gollem_schema_info
gollem_sharesng_groups
gollem_sharesng_users
horde_activesync_cache
horde_activesync_device_users
horde_activesync_mailmap
horde_activesync_map
horde_activesync_schema_info
horde_alarm_schema_info
horde_auth_schema_info
horde_cache_schema_info
horde_core_schema_info
horde_dav_collections
horde_dav_objects
horde_dav_schema_info
horde_group_schema_info
horde_groups_members
horde_history_schema_info
horde_imap_client_message
horde_imap_client_metadata
horde_imap_client_schema_info
horde_lock_schema_info
horde_perms_schema_info
horde_prefs_schema_info
horde_queue_schema_info
horde_service_weather_schema_info
horde_sessionhandler_schema_info
horde_syncml_anchors
horde_syncml_map
horde_syncml_schema_info
horde_token_schema_info
horde_vfs_schema_info
imp_schema_info
ingo_forwards
ingo_lists
ingo_schema_info
ingo_sharesng_groups
ingo_sharesng_users
kronolith_schema_info
kronolith_sharesng_groups
kronolith_sharesng_users
mnemo_schema_info
mnemo_sharesng_groups
mnemo_sharesng_users
nag_schema_info
nag_shares_groups
nag_shares_users
nag_sharesng_groups
nag_sharesng_users
schinfo_schema_info
trean_schema_info
turba_schema_info
turba_sharesng_groups
turba_sharesng_users
whatsnew_schema_info
wicked_schema_info
It is not possible to deploy the horde database on a large scale
implementation based on mysql cluster, without primary key on all
tables!
State ⇒ Feedback
has a primary key, and there are lots of those, much more than in your
list. Thus I assume that the list is incomplete. We would have decide
on a case by case basis if adding primary keys would make sense though.
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ Primary key on all tables of horde database
Queue ⇒ Horde Groupware Webmail Edition
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
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