View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
552 | RackTables | default | public | 2012-05-02 10:24 | 2012-05-14 00:52 |
Reporter | Assigned To | andriyanov | |||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 0.19.12 | ||||
Target Version | 0.19.13 | Fixed in Version | 0.19.13 | ||
Summary | 552: The following queries failed: during upgrade from 19.11 to 19.12 | ||||
Description | We 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 Information | CentOS release 5.7 (Final) | ||||
Tags | No tags attached. | ||||
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. |
|
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. | |
andriyanov fixed this in 0.19.13. | |
Date Modified | Username | Field | Change |
---|---|---|---|
2012-05-02 10:24 |
|
New Issue | |
2012-05-10 07:18 |
|
Note Added: 0000668 | |
2012-05-10 07:26 |
|
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 |