so many rows in tables, last version in 'clusterconfigmapping ' table mysql>select * from clusterconfig WHERE type_name in ('kerberos-env', 'krb5-conf');
| 1059 | version1490153129291 | 41 | krb5-conf | 2 | 5 | {"domains":"","manage_krb5_conf":"false","conf_dir":"/etc","content":" ***** | 1490153128147 |
*******
82 rows in set (0.02 sec)
mysql> select * from clusterconfigmapping WHERE type_name in ('kerberos-env', 'krb5-conf'); +--------------+------------------+------------+----------+----------------------+-----------+
| type_name | create_timestamp | cluster_id | selected | version_tag | user_name | +--------------+------------------+------------+----------+----------------------+-----------+ | krb5-conf | 1490153128175 | 2 | 0 | version1490153129291 | admin | +--------------+------------------+------------+----------+----------------------+-----------+
mysql> select ccm.type_name, ccm.version_tag, ccm.selected, cc.version_tag from clusterconfigmapping ccm left join clusterconfig cc on ccm.version_tag = cc.version_tag where ccm.selected = 1 and cc.version_tag is NULL; Empty set (0.00 sec)
should i change table 'clusterconfigmapping' ,the column 'selected=1' like this update clusterconfigmapping set select=1 where version_tag='version1490153129291'and type_name='krb5-conf'
... View more
