View Issue Details

IDProjectCategoryView StatusLast Update
552RackTablesdefaultpublic2012-05-14 00:52
Reporteruser276Assigned Toandriyanov  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version0.19.12 
Target Version0.19.13Fixed in Version0.19.13 
Summary552: The following queries failed: during upgrade from 19.11 to 19.12
DescriptionWe use 19.11 version.
1. I created mysql dump:
/usr/bin/mysqldump --no-defaults --add-drop-table --allow-keywords --compress --create-options --extended-insert --flush-logs --flush-privileges --log-error=/root/backup/MySQL-backup-$dbname.log --routines --password='password' --user=backupuser racktables > /tmp/rack.dmp
2. Created second database.
3. Inserted info from dump
mysql -uroot -p rtnew < /tmp/rack.dmp
4. Opened html page by new URL
5. Upgrade status and saw error.
Current status Data version: 0.19.11
Code version: 0.19.12
Upgrade path 0.19.11 ? 0.19.12
Executing batch '0.19.12' The following queries failed:

UPDATE Config SET varvalue = CONCAT (varvalue, '; 10=1588') WHERE varname = 'DEFAULT_PORT_OIF_IDS' AND 0 = INSTR (varvalue, '10=') -- FUNCTION rtlab.INSTR does not exist
UPDATE Config SET varvalue = CONCAT (varvalue, '; 11=1668') WHERE varname = 'DEFAULT_PORT_OIF_IDS' -- FUNCTION rtlab.CONCAT does not exist

Executing batch 'dictionary' done
Summary Upgrade complete, it is Ok to enter the system.

6. Looks like system works well. All information is stored.
Additional InformationCentOS release 5.7 (Final)

TagsNo tags attached.

Activities

user292

2012-05-10 07:18

  ~0000668

Which version of mysql do you use? These functions are standard in at least since 4.1 .

Anyway: this affects only the default ports, the system is stable without this change.

user292

2012-05-10 07:26

  ~0000669

Sry, forgot: The space between the function name and the parathesis is the problem. By setting sql_mode to IGNORE_SPACE you can turn the errors into warnings.
adoom42

adoom42

2012-05-14 00:52

administrator   ~0000671

andriyanov fixed this in 0.19.13.

Issue History

Date Modified Username Field Change
2012-05-02 10:24 user276 New Issue
2012-05-10 07:18 user292 Note Added: 0000668
2012-05-10 07:26 user292 Note Added: 0000669
2012-05-14 00:52 adoom42 Note Added: 0000671
2012-05-14 00:52 adoom42 Assigned To => andriyanov
2012-05-14 00:52 adoom42 Status new => closed
2012-05-14 00:52 adoom42 Resolution open => fixed
2012-05-14 00:52 adoom42 Fixed in Version => 0.19.13
2012-05-14 00:52 adoom42 Target Version => 0.19.13