Infobright.org Forums

Infobright DomainExpert error log

2012-02-07T04:10:09-04:00

I need some help.My English is poor.
ICE_User_Guide document”
A value inserted into a column with a decomposition defined does not have to match the rule. Such non-matching values are inserted into a separate subcollection. This subcollection of outliers is compressed and stored independently of other subcollections.
You can obtain the accuracy of decomposition rules by setting the ControlMessages parameter in the brighthouse.ini file to 2 (or higher):ControlMessages = 2
If the parameter is set on each COMMIT for each column, Infobright reports the number of outliers among the committed values (from INSERTs and LOADs).For example:
2011-05-25 16:59:03 Decomposition of ./network/connection.ip left 15 outliers.
“

I set ControlMessages = 4,but I didn’t find in bh.err

mysql> show variables like 'version_comment';
+-----------------+--------------------------------------------------+
| Variable_name   | Value                                            |
+-----------------+--------------------------------------------------+
| version_comment | build number (revision)=IB_4.0_r13151_13690(ice) |
+-----------------+--------------------------------------------------+

mysql> show variables like 'brighthouse_ini_controlmessages';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| brighthouse_ini_controlmessages | 4     |
+---------------------------------+-------+

mysql> desc t8;
+-------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| n     | char(10) | YES  |     | NULL    |       |
+-------+----------+------+-----+---------+-------+
1 row in set (0.00 sec)

mysql> CALL sys_infobright.SHOW_DECOMPOSITION('test','t8');                 
+---+-------------+-----------+---------------+--------+
| # | column name | data type | decomposition | rule   |
+---+-------------+-----------+---------------+--------+
| 1 | n           | char      | t8r           | :::.%d |
+---+-------------+-----------+---------------+--------+

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> load data infile '/tmp/b.txt' into table t8;
Query OK, 1 row affected (0.03 sec)
Records: 1  Deleted: 0  Skipped: 0  Warnings: 0

mysql> commit;
Query OK, 0 rows affected (0.00 sec)



[root@test /tmp]# cat b.txt
"abcde" 

rule is :::.%d
“abcde” is non-matching values
but I didn’t find in bh.err,why ?

Load Data Into Infobright Community Edition using Third Party ETL Tool Like Talend

2012-02-03T04:44:51-04:00

Hi All,

Can any one tell me How to load data Into Infobright Community Edition db using third party ETL tool like Talend ?

Regards,
Rajeev Kumar Mehta

Best ETL tool for Infobright

2010-07-05T20:01:15-04:00

Hi All,

Can you suggest me the BEST ETL tool which can be used to load data from SQL Server/DB2/Oracle (in scheduled manner) into Infobright?

Compilation issue in Infobright 4.0.3 with boost 1.42.0

2012-02-07T04:02:33-04:00

Hi,

I tried compiling infobright. I’ve installed all the required dependencies along with boost 1.42.0. So when I execute the command
make EDITION=community release, I get the following error.

checking whether the Boost::Program_Options library is available... yes
checking for exit in -lboost_program_options... no
checking for exit in -lboost_program_options... (cached) no
checking for exit in -lboost_program_options... (cached) no
configure: error: Could not link against boost_program_options !
make: *** [build/community/release/infobright/Makefile] Error 1 

After examining the config.log file in infobright-4.0.3/build/community/release/infobright
I find the following error.

configure:24792: gcc -o conftest  -O3  -finline-limit=32000     -D_THREAD_SAFE -D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS   -m64 -fprefetch-loop-arrays   -fno-strict-aliasing -fno-merge-constants -fno-gcse   -DNDEBUG   -I/usr/local/boost_1_42_0/include  -L/usr/local/boost_1_42_0/lib conftest.c -lboost_program_options  -lcrypt -ldl -lcrypt -lnsl -lm  >&5
conftest.c:54: warning: conflicting types for built-in function 'exit'
/usr/bin/ld: skipping incompatible /usr/local/boost_1_42_0/lib/libboost_program_options.so when searching for -lboost_program_options
/usr/bin/ld: skipping incompatible /usr/local/boost_1_42_0/lib/libboost_program_options.a when searching for -lboost_program_options
/usr/bin/ld: cannot find -lboost_program_options
collect2: ld returned 1 exit status 

Could you please help? Has this error been encountered before?

Unable to start up Inforbright server from linux

2012-02-02T19:33:59-04:00

/usr/local/infobright/bin/mysqld
120202 23:16:32 [ERROR] Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root!

120202 23:16:32 [ERROR] Aborting

120202 23:16:32 [Note] /usr/local/infobright/bin/mysqld: Shutdown complete

Now I am unable to restart the server. When I installed the database did not set the password. But when I tried to set the password using the following statement mentioned in the user guide

• When the Infobright server is first installed, an administrator account with no password is created. To connect to the administrator account, use the following command:
mysql-ib

mysql-ib
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql-ib.sock’ (2)

Request you to suggest point by point how to resolve the issues.

Trying to set mysql root user gives error unknown variable ‘loose-local-infile=1’

2012-02-02T17:08:57-04:00

I am trying to set password for the mysql root user. It gives the following error

i3nms-flt-o0818:~ # /usr/local/infobright-4.0.5-x86_64/bin/mysqladmin -u root password ‘infobright’
Warning: /usr/local/infobright-4.0.5-x86_64/bin/mysqladmin: unknown variable ‘loose-local-infile=1’

Question on ICM

2011-09-10T06:04:59-04:00

Hi ALL
I use the ICM to detect data block corruption, found that the first run takes longer,
after the test results are instantaneous output.
Does a shorter time-consuming will it affect the the correctness of test results?
Why would the first time took longer?

And then,I use UEdit to modify the data file, resulting in data corruption.
Does IB have such tools similar with dbv or DBMS_REPAIR in oracle can handle it?

ICE Data Loading using Telend

2012-02-03T08:56:04-04:00

Hi All,

Can any one tell me.
Is ICE supports Data Loading using Telend ?

Thanks,
Rajeev

Use Infobright Loader and ignore error

2012-01-10T11:51:57-04:00

Hi all,

I’m trying to load a file using infobright loader

LOAD DATA INFILE '/tmp/filetodump' INTO TABLE data_20120110 FIELDS TERMINATED BY ',' ENCLOSED BY ''; 

I got the following error

ERROR 2 (HY000): Wrong data or column definition. Row: 82, field: 36. 

If i check my file, there is indeed an error at row 82. However, i’d like to continue to load other part of my file. So my question is, do you think it’s possible to load a file, ignoring row in errors ?
I know it’s possible with oracle.

No Network in VM ICE + Talend + JasperSoft

2012-02-03T06:01:38-04:00

Hi All,

Can any one tell me how to browse internet on VM ICE + Talend + JasperSoft.
Any configuration needed ?
I have install this VM on windows XP machine with internet connection but i am unable to browse internet in the VM.

Thanks,
Rajeev Kumar Mehta