 |
hellevil9@gmail.com gave me the correct hint, thanks a lot! edited /usr/lib/bareos/scripts/ddl/updates/mysql.2171_2191.sql changed line 6 old: CREATE INDEX IF NOT EXISTS jobdate_idx ON Job (JobTDate); new: CREATE INDEX jobdate_idx ON Job (JobTDate); now my database upgrade runs without any errors thanks to hellevil9 !! Thanks thanks thanks Thomas |
|
|
Some of our customers may already have that specific named index in place, so "CREATE INDEX jobtdate_idx ON Job (JobTDate);" can end up in a duplicate key name error. "ALTER TABLE Job ADD INDEX (JobTDate);" should be a better alternative for the update script, compatible to MySQL and MariaDB, unfortunately you may end up with multiple indexes and a manual clean up is required. MariaDB [test]> CREATE INDEX jobtdate_idx ON Job (JobTDate); ERROR 1061 (42000): Duplicate key name 'jobtdate_idx' MariaDB [test]> ALTER TABLE Job ADD INDEX (JobTDate); Query OK, 0 rows affected, 1 warning (0.028 sec) Records: 0 Duplicates: 0 Warnings: 1 MariaDB [test]> SHOW INDEXES FROM Job; +-------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Job | 0 | PRIMARY | 1 | JobId | A | 0 | NULL | NULL | | BTREE | | | | Job | 1 | Name | 1 | Name | A | 0 | 128 | NULL | | BTREE | | | | Job | 1 | JobTDate | 1 | JobTDate | A | 0 | NULL | NULL | YES | BTREE | | | | Job | 1 | jobtdate_idx | 1 | JobTDate | A | 0 | NULL | NULL | YES | BTREE | | | | Job | 1 | JobTDate_5 | 1 | JobTDate | A | 0 | NULL | NULL | YES | BTREE | | | +-------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 8 rows in set (0.001 sec) MariaDB [test]> DROP INDEX JobTDate_5 ON Job; Query OK, 0 rows affected (0.021 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [test]> SHOW INDEXES FROM Job; +-------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Job | 0 | PRIMARY | 1 | JobId | A | 0 | NULL | NULL | | BTREE | | | | Job | 1 | Name | 1 | Name | A | 0 | 128 | NULL | | BTREE | | | | Job | 1 | JobTDate | 1 | JobTDate | A | 0 | NULL | NULL | YES | BTREE | | | | Job | 1 | jobtdate_idx | 1 | JobTDate | A | 0 | NULL | NULL | YES | BTREE | | | +-------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 7 rows in set (0.001 sec) [...] |
|
|
Thanks! It is Work! |
|
|
Fix committed to bareos master branch with changesetid 12820. |
|
|
Fix committed to bareos bareos-19.2 branch with changesetid 12840. |
|
|
Fixed in Bareos 19.2.6 |
- Anonymous
