[ZBX-10860] XML failed to import template where application name case was changed Created: 2016 May 31  Updated: 2019 Mar 15  Resolved: 2019 Mar 15

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 3.0.3
Fix Version/s: None

Type: Incident report Priority: Trivial
Reporter: Vitaly Zhuravlev Assignee: Unassigned
Resolution: Won't fix Votes: 0
Labels: import, xml
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File screenshot-1.png    

 Description   

Failed to import(updating) XML Template where Application name case was changed.

To reproduce:

  • Export default Linux OS Template
  • Change Application name from 'Cpu' to 'CPu'
  • Save xml and Import back

Error is produced.

Import failed
Application "CPu" already exists.



 Comments   
Comment by Aleksandrs Saveljevs [ 2016 May 31 ]

Could it be a yet another case of a case-insensitive database?

Comment by Vitaly Zhuravlev [ 2016 May 31 ]
Server version: 5.7.12 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Comment by Aleksandrs Saveljevs [ 2016 May 31 ]

I meant ZBX-6323, its duplicates, and other related issues like ZBX-10307. How was the database created?

Comment by richlv [ 2016 May 31 ]

or show create database zabbix / show create table applications

Comment by Vitaly Zhuravlev [ 2016 May 31 ]

Yes.database probably was created without case aware option.

Generated at Thu Apr 25 20:29:08 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.