[Opendnssec-develop] Key shananigans in 1.1.[12]

[Rick van Rein]

Hey Sion,

Thanks for willing to help with this problem.

Our database contains keys that are generated and backed up, so we know that our
patch of the backup mechanisms is not the root of the problem.  It would appear
that the key publication logic needs a hint of some sort.  Any suggestion how we
could accomplish that?

mysql> select id,policy_id,size,state,generate,backup,publish,ready from
keypairs where policy_id=24;
+-----+-----------+------+-------+---------------------+---------------------+---------------------+---------------------+
| id  | policy_id | size | state | generate            | backup              |
publish             | ready               |
+-----+-----------+------+-------+---------------------+---------------------+---------------------+---------------------+
| 163 |        24 | 2048 |     6 | 2010-08-04 12:30:04 | 2010-08-04 12:31:00 |
2010-08-04 12:31:01 | 2010-08-05 02:45:02 | 
| 164 |        24 | 1024 |     6 | 2010-08-04 12:30:04 | 2010-08-04 12:31:00 |
2010-08-04 12:31:01 |                NULL | 
| 165 |        24 | 1024 |     6 | 2010-08-04 12:30:04 | 2010-08-04 12:31:00 |
2010-08-04 12:31:01 | 2010-08-05 02:45:02 | 
| 184 |        24 | 2048 |     1 | 2010-08-23 13:45:59 | 2010-08-23 17:05:23 |
NULL |                NULL | 
| 185 |        24 | 1024 |     1 | 2010-08-23 13:45:59 | 2010-08-23 17:05:23 |
NULL |                NULL | 
| 186 |        24 | 1024 |     1 | 2010-08-23 13:45:59 | 2010-08-23 17:05:23 |
NULL |                NULL | 
+-----+-----------+------+-------+---------------------+---------------------+---------------------+---------------------+


Thanks,
 -Rick