Uploaded image for project: 'CloudStack'
  1. CloudStack
  2. CLOUDSTACK-9284

CloudStack usage service tries to get access to "cloud.event_usage" table only via IP from cloud.usage.host field in db.properties

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 4.2.1, 4.5.2
    • None
    • Usage
    • Security Level: Public (Anyone can view this level - this is the default.)
    • None
    • OS - centos6

    Description

      Have tried to separate cloud and cloud_usage databases on two different servers. db.properties file was updated in following way:

      db.usage.host=IP_of_remote_server1
      db.cloud.host=localhost

      Database of cloud_usage was dumped from localhost and imported to the remote mysql server. After that both services cloudstack-usage and cloudstack-management were restarted. Both services started properly, but during next usage running logs shown following error message:

      com.cloud.utils.exception.CloudRuntimeException: SELECT command denied to user 'cloud'@'XX.XX.XX.XX' for table 'usage_event'
      at com.cloud.event.dao.UsageEventDaoImpl.getMaxEventId(UsageEventDaoImpl.java:209)
      at com.cloud.event.dao.UsageEventDaoImpl.getRecentEvents(UsageEventDaoImpl.java:101)
      at com.cloud.event.dao.UsageEventDaoImpl_EnhancerByCloudStack_c0063fe7.CGLIB$getRecentEvents$3(<generated>)
      at com.cloud.event.dao.UsageEventDaoImpl_EnhancerByCloudStack_c0063fe7_FastClassByCloudStack_48924ead.invoke(<generated>)
      at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
      at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
      at com.cloud.event.dao.UsageEventDaoImpl_EnhancerByCloudStack_c0063fe7.getRecentEvents(<generated>)
      at com.cloud.usage.UsageManagerImpl.parse(UsageManagerImpl.java:582)
      at com.cloud.usage.UsageManagerImpl.runInContextInternal(UsageManagerImpl.java:376)
      at com.cloud.usage.UsageManagerImpl$1.runInContext(UsageManagerImpl.java:318)
      at org.apache.cloudstack.managed.context.ManagedContextRunnable$1.run(ManagedContextRunnable.java:49)
      at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:56)
      at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:103)
      at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:53)
      at org.apache.cloudstack.managed.context.ManagedContextRunnable.run(ManagedContextRunnable.java:46)
      at com.cloud.usage.UsageManagerImpl.run(UsageManagerImpl.java:315)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
      at java.util.concurrent.FutureTask.run(FutureTask.java:262)
      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      at java.lang.Thread.run(Thread.java:745)

      After mysql query logging was enabled I found that usage service was trying to access cloud.usage_event table (from 'cloud' database, not cloud_usage) on the remote mysql server where I want to keep only one database 'cloud_usage'. Same error was reproduce on CS 4.2.1 and CS 4.5.2 versions.
      The main question is why usage service tries to get information from 'cloud' database using IP address which was configured in db.usage.host field in place of db.cloud.host ?

      Have posted this issue to user's mail list, but got only suggestion to place a bug http://mail-archives.apache.org/mod_mbox/cloudstack-users/201601.mbox/browser

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            dethmix Dmitriy Pavlov

            Dates

              Created:
              Updated:

              Slack

                Issue deployment