[cinder] db sync error upgrading from pike to queens

iain MacDonnell iain.macdonnell at oracle.com
Thu Jan 10 19:11:36 UTC 2019


Different issue, I believe (DB sync vs. online migrations) - it just 
happens that both pertain to shared targets.

Brandon, might you have a very large number of rows in your volumes 
table? Have you been purging soft-deleted rows?

     ~iain


On 1/10/19 11:01 AM, Jay Bryant wrote:
> Brandon,
> 
> I am thinking you are hitting this bug: 
> https://urldefense.proofpoint.com/v2/url?u=https-3A__bugs.launchpad.net_cinder_-2Bbug_1806156&d=DwIDaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=RxYkIjeLZPK2frXV_wEUCq8d3wvUIvDPimUcunMwbMs&m=FHjmiBaQPWLNzGreplNmZfCZ0MkpV5GLaqD2hcs5hwg&s=AvAoszuVyGkd2_1hyCnQjwGEw9dUNfEoqsUcxdHYZqU&e= 
> 
> 
> I think you can work around it by retrying the migration with the volume 
> service running.  You may, however, want to check with Iain MacDonnell 
> as he has been looking at this for a while.
> 
> Thanks!
> Jay
> 
> 
> On 1/10/2019 12:34 PM, Brandon Caulder wrote:
>> Hi,
>>
>> I am receiving the following error when performing an offline upgrade 
>> of cinder from RDO openstack-cinder-1:11.1.0-1.el7 to 
>> openstack-cinder-1:12.0.3-1.el7.
>>
>> # cinder-manage db version
>> 105
>>
>> # cinder-manage --debug db sync
>> Error during database migration: (pymysql.err.OperationalError) (2013, 
>> 'Lost connection to MySQL server during query') [SQL: u'UPDATE volumes 
>> SET shared_targets=%(shared_targets)s'] [parameters: 
>> {'shared_targets': 1}]
>>
>> # cinder-manage db version
>> 114
>>
>> The db version does not upgrade to queens version 117.  Any help would 
>> be appreciated.
>>
>> Thank you
> 



More information about the openstack-discuss mailing list