Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007360opensim[REGION] OpenSim Corepublic2014-10-24 05:592015-03-03 17:12
ReporterGavin Hird 
Assigned To 
PrioritynormalSeverityminorReproducibilityN/A
StatusconfirmedResolutionopen 
PlatformOSOS Version
Product Versionmaster (dev code) 
Target VersionFixed in Version 
Summary0007360: 14 tables without primary key PGSQL
DescriptionI ran a synchronization procedure between the production database and a backup database, and the sync product complains that 14 tables are not sinkable because they miss primary keys. ... which I guess is quite fundamental for reliable syncs.

The tables in question are:

Table `public.auth' is not synchronizable since it does not have primary key
Table `public.estate_groups' is not synchronizable since it does not have primary key
Table `public.estate_managers' is not synchronizable since it does not have primary key
Table `public.estate_map' is not synchronizable since it does not have primary key
Table `public.estate_settings' is not synchronizable since it does not have primary key
Table `public.estate_users' is not synchronizable since it does not have primary key
Table `public.estateban' is not synchronizable since it does not have primary key
Table `public.landaccesslist' is not synchronizable since it does not have primary key
Table `public.migrations' is not synchronizable since it does not have primary key
Table `public.presence' is not synchronizable since it does not have primary key
Table `public.regionban' is not synchronizable since it does not have primary key
Table `public.terrain' is not synchronizable since it does not have primary key
Table `public.tokens' is not synchronizable since it does not have primary key
Table `public.usernotes' is not synchronizable since it does not have primary key

I guess it should be doable to set a key for all these tables for all database implementations?
Additional InformationThis was running off master at r/25377
TagsNo tags attached.
Git Revision or version number
Run Mode Grid (Multiple Regions per Sim)
Physics EngineODE
Script Engine
EnvironmentMono / OSX
Mono Version3.6
Viewer
Attached Files

- Relationships
related to 0004380patch feedbackmelanie Several MySQL tables have no index keys 

-  Notes
(0027712)
hack13 (reporter)
2015-03-03 17:12

I am working on fixing this now, I will attach the patch when I am finished.

- Issue History
Date Modified Username Field Change
2014-10-24 05:59 Gavin Hird New Issue
2014-10-29 20:08 kcozens Relationship added related to 0004380
2015-03-03 17:12 hack13 Note Added: 0027712
2015-03-03 17:12 hack13 Status new => confirmed


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker