when I deleted a few rows, those rows did not get deleted on mariadb
cluster second node.
$ sudo grep "wsrep_certify_nonPK" /etc/mysql/my.cnf
wsrep_certify_nonPK=1
> show create table comp2012db.uni12_jevents_vevdetail;
+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table
|
+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| uni12_jevents_vevdetail | CREATE TABLE `uni12_jevents_vevdetail` (
`evdet_id` int(12) NOT NULL AUTO_INCREMENT,
`rawdata` longtext NOT NULL,
`dtstart` int(11) NOT NULL DEFAULT '0',
`dtstartraw` varchar(30) NOT NULL DEFAULT '',
`duration` int(11) NOT NULL DEFAULT '0',
`durationraw` varchar(30) NOT NULL DEFAULT '',
`dtend` int(11) NOT NULL DEFAULT '0',
`dtendraw` varchar(30) NOT NULL DEFAULT '',
`dtstamp` varchar(30) NOT NULL DEFAULT '',
`class` varchar(10) NOT NULL DEFAULT '',
`categories` varchar(120) NOT NULL DEFAULT '',
`color` varchar(20) NOT NULL DEFAULT '',
`description` longtext NOT NULL,
`geolon` float NOT NULL DEFAULT '0',
`geolat` float NOT NULL DEFAULT '0',
`location` varchar(120) NOT NULL DEFAULT '',
`priority` tinyint(3) unsigned NOT NULL DEFAULT '0',
`status` varchar(20) NOT NULL DEFAULT '',
`summary` longtext NOT NULL,
`contact` varchar(120) NOT NULL DEFAULT '',
`organizer` varchar(120) NOT NULL DEFAULT '',
`url` text NOT NULL,
`extra_info` varchar(240) NOT NULL DEFAULT '',
`created` varchar(30) NOT NULL DEFAULT '',
`sequence` int(11) NOT NULL DEFAULT '1',
`state` tinyint(3) NOT NULL DEFAULT '1',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`multiday` tinyint(3) NOT NULL DEFAULT '1',
`hits` int(11) NOT NULL DEFAULT '0',
`noendtime` tinyint(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`evdet_id`)
) ENGINE=InnoDB AUTO_INCREMENT=515 DEFAULT CHARSET=utf8 |
+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
It seems that there's a PK.
But what would cause this?
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp