Добрый день.
Есть база заббикса 1.6.5 сконвертированная в режим распределенного мониторинга.
запускаю скрип, который лежит в ...dbpatches/1.8/mysql/
он говорит,что "This script is not intended for distributed monitoring databases."
в процессе выполняет конвертации и слетает при применении патча с ошибками
"Patching the database
... patching of the database took 0:01:03
Adding 'Discovered Hosts' host group
./upgrade: line 63: 100100000000042
200100000000007+1: syntax error in expression (error token is "200100000000007+1")
./upgrade: line 68: 100100000000042
200100000000007+1: syntax error in expression (error token is "200100000000007+1")
ERROR 1062 (23000) at line 2: Duplicate entry '100100000000042' for key 1
Checking for 'Disabled' user group... found, not doing anything.
Checking for hosts not belonging to any group... found.
Group 'none' does not exist, creating it and adding all orphaned hosts to it.
./upgrade: line 63: 100100000000042
200100000000007+1: syntax error in expression (error token is "200100000000007+1")
./upgrade: line 68: 100100000000042
200100000000007+1: syntax error in expression (error token is "200100000000007+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000000042' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
Added 12 hosts to group 'none'. Move them to correct groups manually.
... checking for hosts not belonging to any group took 0:00:01
"
приплыли
вопрос - как вообще конвертить мастер ноду?
Есть база заббикса 1.6.5 сконвертированная в режим распределенного мониторинга.
запускаю скрип, который лежит в ...dbpatches/1.8/mysql/
он говорит,что "This script is not intended for distributed monitoring databases."
в процессе выполняет конвертации и слетает при применении патча с ошибками
"Patching the database
... patching of the database took 0:01:03
Adding 'Discovered Hosts' host group
./upgrade: line 63: 100100000000042
200100000000007+1: syntax error in expression (error token is "200100000000007+1")
./upgrade: line 68: 100100000000042
200100000000007+1: syntax error in expression (error token is "200100000000007+1")
ERROR 1062 (23000) at line 2: Duplicate entry '100100000000042' for key 1
Checking for 'Disabled' user group... found, not doing anything.
Checking for hosts not belonging to any group... found.
Group 'none' does not exist, creating it and adding all orphaned hosts to it.
./upgrade: line 63: 100100000000042
200100000000007+1: syntax error in expression (error token is "200100000000007+1")
./upgrade: line 68: 100100000000042
200100000000007+1: syntax error in expression (error token is "200100000000007+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000000042' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
./upgrade: line 63: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
./upgrade: line 68: 100100000001426
200100000000143+1: syntax error in expression (error token is "200100000000143+1")
ERROR 1062 (23000) at line 1: Duplicate entry '100100000001426' for key 1
Added 12 hosts to group 'none'. Move them to correct groups manually.
... checking for hosts not belonging to any group took 0:00:01
"
приплыли

вопрос - как вообще конвертить мастер ноду?