Author Topic: linux qube supervisor 6.3.1 - errors in /var/log/messages  (Read 5332 times)

westernx

  • Hero Member
  • *****
  • Posts: 55
linux qube supervisor 6.3.1 - errors in /var/log/messages
« on: April 26, 2012, 05:01:23 PM »
I have a linux qube supervisor machine running 6.3.1.  So, far it is working well, and doing it's job,
but I am seeing repeated messages in /var/log/messages about a db table entry that doesn't exist ;

Code: [Select]
From: root@qbsupe02.keystone (Cron Daemon)
To: root@qbsupe02.keystone
Subject: Cron <root@qbsupe02> /usr/bin/mysql -u pfx_dw < /usr/local/pfx/qube/datawh/regular_globalResource.sql
Content-Type: text/plain; charset=UTF-8
Auto-Submitted: auto-generated
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/root>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=root>
X-Cron-Env: <USER=root>

ERROR 1146 (42S02) at line 20: Table 'pfx_dw.resource_dim' doesn't exist

I'm seeing this repeated over and over . . . . is it just as simple as manually created the mysql table pfx_dw.resource_dim?

thks,

ryjguy7
« Last Edit: April 26, 2012, 05:03:12 PM by ryjguy7 »

jburk

  • Administrator
  • *****
  • Posts: 493
Re: linux qube supervisor 6.3.1 - errors in /var/log/messages
« Reply #1 on: April 26, 2012, 05:39:52 PM »
This is a known issue and was fixed in 6.3-2.

==== CL 9239 ====
@FIX: global resource tables were not getting created in new instances of the datawarehouse db, only on upgrades.

Upgrade your supervisor to 6.3-4 to resolve it, or run the following SQL when logged into your mysql server instance as root:

Code: [Select]
USE pfx_dw;

DROP TABLE IF EXISTS globalresource_fact;

CREATE TABLE globalresource_fact (
    time_sk INT NOT NULL
    , resource_sk MEDIUMINT UNSIGNED NOT NULL
    , total MEDIUMINT UNSIGNED NOT NULL
    , used MEDIUMINT UNSIGNED NOT NULL
)
ENGINE=MyISAM
;

DROP TABLE IF EXISTS resource_dim;

CREATE TABLE resource_dim (
    resource_sk INT NOT NULL AUTO_INCREMENT PRIMARY KEY
    , name VARCHAR(255) NOT NULL UNIQUE
)
ENGINE=MyISAM
;

INSERT INTO resource_dim
    (resource_sk, name)
    VALUES('1', 'qube')
;

westernx

  • Hero Member
  • *****
  • Posts: 55
Re: linux qube supervisor 6.3.1 - errors in /var/log/messages
« Reply #2 on: April 26, 2012, 07:00:42 PM »
thanks! . . . .