cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-10195) CloudStack MySQL HA problem -- No database selected
Date Mon, 18 Dec 2017 18:37:00 GMT

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-10195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16295399#comment-16295399
] 

ASF GitHub Bot commented on CLOUDSTACK-10195:
---------------------------------------------

rafaelweingartner commented on issue #2364: [CLOUDSTACK-10195] CloudStack MySQL HA problem
-- No database selected
URL: https://github.com/apache/cloudstack/pull/2364#issuecomment-352518710
 
 
   Because it was testing the method   `txn.transitToUserManagedConnection(getHeartbeatConnection())`.
   I replaced the use of this method by `txn.transitToAutoManagedConnection(TransactionLegacy.CLOUD_DB);`
   
   If you see in that code at line 600, after "trying" to reuse a connection if something
goes wrong, it will try to transit to a transaction using schema "Cloud_DB", and then it will
close the transaction. The only place where the transaction was "reused" is there. So, when
I changed `txn.transitToUserManagedConnection(getHeartbeatConnection())` to `txn.transitToAutoManagedConnection(TransactionLegacy.CLOUD_DB);`,
the first method could be deleted. After that, I inspected and this method is not used anywhere
else. Therefore, I also removed the method and its test cases.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> CloudStack MySQL HA problem -- No database selected
> ---------------------------------------------------
>
>                 Key: CLOUDSTACK-10195
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-10195
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>    Affects Versions: 4.9.0, 4.9.2.0, 4.9.3.0
>            Reporter: Rafael Weingärtner
>            Assignee: Rafael Weingärtner
>            Priority: Minor
>
> When using CloudStack with database HA configuration user receives warnings constantly
saying “No database selected”.
> This problem happens at com.cloud.cluster.ClusterManagerImpl.getHeartbeatTask().new ManagedContextRunnable()
{...}.runInContext(), line 550. The scheme of the database is not properly set in the transaction
when database HA options are enabled.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message