View Issue Details

IDProjectCategoryView StatusLast Update
945RackTablesdefaultpublic2013-11-24 22:53
Reporterxoggy Assigned Toandriyanov  
PrioritynormalSeveritymajorReproducibilityhave not tried
Status closedResolutionunable to reproduce 
PlatformPC - LinuxOSUbuntu 64-bitOS Version12.04
Product Version0.20.5 
Summary945: Upgrade to 0.20.5 from 0.20.4 failed
DescriptionExecuting batch '0.20.5'
The following queries failed:
ALTER TABLE `UserConfig` DROP FOREIGN KEY `UserConfig-FK-user` -- Error on rename of './racktables/UserConfig' to './racktables/#sql2-125-97d5' (errno: 152)
Additional InformationPlatform check status

PDO extension PASSED
PDO-MySQL extension PASSED
PCRE extension PASSED
PCRE compiled with
--enable-unicode-properties PASSED
SNMP extension PASSED
GD extension PASSED
Multibyte string extension PASSED
LDAP extension PASSED
PCNTL extension NOT PRESENT
JSON extension PASSED
cURL extension PASSED
BC Math extension PASSED
accessed over HTTPS PASSED


Upgrade status

Current status Data version: 0.20.4
Code version: 0.20.5
Upgrade path 0.20.4 ? 0.20.5
Release notes for 0.20.5
TagsNo tags attached.

Activities

andriyanov

andriyanov

2013-07-20 18:10

reporter   ~0001605

Please show the 'show create table UserConfig' SQL command output.
Also, try to upgrade again, and after you get the SQL error, execute the SQL command 'show innodb status', and show the "last foreign key error" section.
adoom42

adoom42

2013-11-24 22:53

administrator   ~0001975

Closing due to lack of feedback.

Issue History

Date Modified Username Field Change
2013-07-17 11:33 xoggy New Issue
2013-07-20 13:26 infrastation Assigned To => andriyanov
2013-07-20 13:26 infrastation Status new => assigned
2013-07-20 18:10 andriyanov Note Added: 0001605
2013-07-20 18:10 andriyanov Status assigned => feedback
2013-11-24 22:53 adoom42 Note Added: 0001975
2013-11-24 22:53 adoom42 Status feedback => closed
2013-11-24 22:53 adoom42 Resolution open => unable to reproduce