diff options
author | Andris Zeila <andris.zeila@zabbix.com> | 2022-11-09 11:42:02 +0300 |
---|---|---|
committer | Andris Zeila <andris.zeila@zabbix.com> | 2022-11-09 11:42:33 +0300 |
commit | 922528ac421d61214ad2047791f899abf8476c73 (patch) | |
tree | fa115ea54f2a7f90cffabddb5e3772b9c2f4494b | |
parent | aa33e3078a6ccc94c8406b5dc09c1ad72965af3b (diff) |
.......... [ZBX-21869] fixed database upgrade from 5.0 on setups requiring primary keys for tables
Merge in ZBX/zabbix from feature/ZBX-21869-6.0 to release/6.0
* commit '94ed6d554f2faea1576437cea95b18e94e7b9976':
.D........ [ZBX-21869] added changelog entry
.......... [ZBX-21869] added primary key to the initial trigger_queue table creation patch
(cherry picked from commit fc92ce1021f3f3760b8e651ab423bf070a1f5057)
-rw-r--r-- | ChangeLog.d/bugfix/ZBX-21869 | 1 | ||||
-rw-r--r-- | src/libs/zbxdbupgrade/dbupgrade_5010.c | 3 |
2 files changed, 3 insertions, 1 deletions
diff --git a/ChangeLog.d/bugfix/ZBX-21869 b/ChangeLog.d/bugfix/ZBX-21869 new file mode 100644 index 00000000000..3591d2cbc09 --- /dev/null +++ b/ChangeLog.d/bugfix/ZBX-21869 @@ -0,0 +1 @@ +.......... [ZBX-21869] fixed database upgrade from 5.0 on setups requiring primary keys for tables (wiper) diff --git a/src/libs/zbxdbupgrade/dbupgrade_5010.c b/src/libs/zbxdbupgrade/dbupgrade_5010.c index 7c982585efc..4c5a690be0e 100644 --- a/src/libs/zbxdbupgrade/dbupgrade_5010.c +++ b/src/libs/zbxdbupgrade/dbupgrade_5010.c @@ -329,8 +329,9 @@ static int DBpatch_5010036(void) static int DBpatch_5010037(void) { const ZBX_TABLE table = - {"trigger_queue", "", 0, + {"trigger_queue", "trigger_queueid", 0, { + {"trigger_queueid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, {"objectid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, |