Infobright.org Forums

Infobright 3.3.1 install fails on Ubuntu Lucid Lynx 64bit

2010-03-23T14:13:12Z

I am getting an error when executing (as root) install script:
======================================================
/usr/local/infobright/install-infobright.sh—datadir=”/home/mysql/data/db1”—cachedir=”/home/mysql/data/cache1”—port=3306—config=”/etc/my-ib.cnf”—socket=”/tmp/mysql-ib.sock”—user=mysql—group=mysql
Infobright installation script is running…
Checking system configuration…
Infobright license agreement…
System tool ‘Less’ - a text file viewer will be used to display license agreement.
Please only use up/down arrow keys for scrolling license text and press Q when finished reading.
Press R -Read license agreement, N -Exit the installation [R/N]:r
Press Y -I agree, Any other key -I do not agree [Y/*]:y
Creating user mysql…
useradd: user ‘mysql’ already exists
Failed on /usr/sbin/useradd mysql [ignored]
Installing default databases…
Installing MySQL system tables…
mysqld: relocation error: /lib/libnss_compat.so.2: symbol strcmp, version GLIBC_2.2.5 not defined in file libc.so.6 with link time reference

Installation of system tables failed! Examine the logs in
/home/mysql/data/db1 for more information.

You can try to start the mysqld daemon with:

shell> /usr/local/infobright/bin/mysqld—skip-grant &

and use the command line tool /usr/local/infobright/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /usr/local/infobright/bin/mysql -u root mysql
mysql> show tables

Try ‘mysqld—help’ if you have problems with paths. Using—log
gives you a log in /home/mysql/data/db1 that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com/. Please consult the MySQL manual section
‘Problems running mysql_install_db’, and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/local/infobright/scripts/mysqlbug script!

Failed on: scripts/mysql_install_db —defaults-file=/etc/my-ib.cnf —user=mysql —basedir=/usr/local/infobright —datadir=/home/mysql/data/db1 —cachedir=/home/mysql/data/cache1
Rolling back the installation due to unexpected failure…
Installation failed! Please investigate the error messages.
=========================================
I am using the latest Ubuntu Lucid Lynx 64bit Beta1.
I realize that it is a beta OS though the release is only a month away and I am curious if this problem will persist into the final release.

Thank you,
Yurx

Error on load

2009-06-04T14:20:18Z

Hi,

Just stumbled across Infobright and am really interested to see if if can replace my MyISAM based database. But at the moment I’m having problems trying to load some test data.

I am trying to load a very large datafile (~25GB).

My table is

CREATE TABLE `ifInOctets` (
  `iid` mediumint(9) NOT NULL,
  `dtime` datetime NOT NULL,
  `rate` bigint(20) NOT NULL,
  `counter` bigint(20) NOT NULL
) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=ascii COLLATE=ascii_bin 

and I’m loading with

load data infile '/home/griffa10/ifInOctets.dmp.1' into table ifInOctets fields terminated by '\t'; 

And I get the error

ERROR 2 (HY000): Wrong data or column definition. Row: 7474146, field: 3. 

However, if I load a file with a single row in it and then retry the larger file - it errors on a different line

ERROR 2 (HY000): Wrong data or column definition. Row: 7483133, field: 3. 

Which suggests to me that the problem is not with the data, at least not a specific line.

Would be grateful for any suggestions.

RHEL 5.3 x86_64, 2 x Intel E5450, 8GB RAM.
ServerMainHeapSize=3000
ServerCompressedHeapSize=400
LoaderMainHeapSize=400

Thanks,

Alan

UNION performance

2010-05-06T10:54:55Z

Hello Infobright community,

I’m at a point where I don’t know if I should partition my tables into months, weeks or days. Doing by day would require many unions when querying a large date range, but would reduce the rows on a single table. Is there any performance degradation for doing multiple unions in one query?

Thank you for your input

-Eric

Forum Activation Link seems broken

2008-10-22T07:04:35Z

Hi,

this is some info for the webdev team: It seems that the activation link, which is embedded in the activation email, is broken. When clicking on the mail in my email-app (Evolution on Ubuntu 8.04) the link is url_encoded: &‘s are represented as &‘s . I dont know if this is linux/evolution specific but I figured you guys wanted to be informed ...

CVH

Predictive Analytics World Conference Oct 19-20, 2010 - Washington, DC

2010-05-26T14:20:57Z

Hi Everyone,

Just a reminder to save the date: Predictive Analytics World conference, October 19-20, 2010 in Washington, D.C.

Includes keynote speakers Piyanka Jain of PayPal, Andrew Pole of Target and Program Chair Eric Siegel, Ph.D.—plus special sessions from industry heavy-weights Usama Fayyad, Ph.D. and John F. Elder, Ph.D.

Three pre- and post-event workshops complement the core conference program.

For a complete overview of the conference agenda, see:
http://www.predictiveanalyticsworld.com/sanfrancisco/2010/agenda_overview.php

For more info, visit http://www.pawcon.com, e-mail us at
registration at predictiveanalyticsworld dot com or call (718) 577-1202.

Thanks—Bobbe Cook, Predictive Analytics World

Quality of data on database

2010-05-19T10:17:01Z

Hello,

Thanks for the help on the last question.
We have looked at several open source offers in the field of data integration. We are now wanting data quality software to complete our data integration program.

Do packages exist to suit our needs? Would you know of innovative data quality programs?

Thanks to all!

Brighthouse specific error: Write operation to file or pipe failed.

2010-05-16T05:36:00Z

Hi all,

Today, my service threw an error look like:

Brighthouse specific error: Write operation to file or pipe failed.
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at VC.Analytic.Loyalty.Service.VCALoyaltyService.ExecMySQL(MySqlCommand cmd)

my query look like (executed in store procedure):

SET @bh_dataformat = 'txt_variable'; 
    
    SET @sql ='SELECT 0, bannerId, guid, SUM(view)v,''00-00-00''';
    SET @sql =CONCAT(@sql, ' FROM `loyalty_visitor_view_sum`');
    SET @sql =CONCAT(@sql, ' WHERE bannerId IN (SELECT bannerId FROM `activebanners`)');
    SET @sql =CONCAT(@sql, ' GROUP BY bannerId, guid');
    SET @sql = CONCAT(@sql,' INTO OUTFILE ''', pathOutFile, ''' FIELDS TERMINATED BY  '','' ENCLOSED BY ''NULL''');
    PREPARE stmt FROM @sql;
    EXECUTE stmt;     
    DEALLOCATE PREPARE stmt; 

The loyalty_visitor_view_sum table structure:

CREATE TABLE `loyalty_visitor_view_sum` (
  `campaignId` INTEGER(11) NOT NULL DEFAULT '0',
  `bannerId` INTEGER(11) NOT NULL DEFAULT '0',
  `guid` BIGINT(20) NOT NULL DEFAULT '0',
  `view` INTEGER(11) NOT NULL DEFAULT '0',
  `dt` DATE NOT NULL DEFAULT '0000-00-00'
)ENGINE=brighthouse
CHARACTER SET 'ascii' COLLATE 'ascii_bin'; 

the table has got 202,171,270 data rows with 597 distinct Ad bannerIds and 5,579,521 distinct guid

The activebanners table structure:

CREATE TABLE `activebanners` (   
  `campaignId` INTEGER(11) NOT NULL DEFAULT '0',     
  `bannerId` INTEGER(11) NOT NULL DEFAULT '0'     
)ENGINE=brighthouse
CHARACTER SET 'ascii' COLLATE 'ascii_bin'; 

the table has got only 598 data rows and 598 distinct active Ad bannerId too.

After about 2h querying time, the error thew like above. I’d know why the error threw and how to fix.

My server:
machine_type x86_64
os_name Linux
os_release 2.6.18-128.el5
cpu_num 8 CPUs
cpu_speed 2333 MHz
mem_total 32963028 KB
swap_total 9437176 KB

I’ll attach the brighhouse.ini & brighhouse.err later (I have no permission to access on these files) .

Thanks,
Thanh Nguyen.

mysql InnoDB and Infobright coexist in same server

2010-04-28T12:56:08Z

Can we install a MySQL community server and the Infobright MySQL on one server?
We are assuming that this is the only way we can have InnoDB tables for transactions and the Brighthouse tables for the warehouse.

Thanks.

Use LOAD DATA INFILE with Named Pipes in Java/Scala

2010-04-14T18:13:08Z

I am trying to set up using named pipes to load data into the db using the java connector. I am stuck at the fact that if I try to start writing to the pipe it waits for the read to finish, or if i start reading from the pipe first, it hangs waiting for the input. I have y sample code in scala below:

val query = "LOAD DATA INFILE '/ebs_raid/pipes/date_dim.pipe' INTO TABLE " + DB.t("tmp_date_dim") + " FIELDS TERMINATED BY '|';"   
val out = new OutputStreamWriter(new FileOutputStream("/ebs_raid/pipes/date_dim.pipe"))    
out.write(values)
out.flush();
out.close();            
st.asInstanceOf[com.mysql.jdbc.Statement].executeUpdate(query) 

errorcode 13 problem

2008-12-11T10:01:44Z

I have my brandnew redhat 64bit server running, which my provider setup for me. I have basic access and infobright 64 enterprise is installed and running.

I was able to access the database server, create a database and table and wanted to load data from a file (1million generated lines of ascii data seperated by ;).

mysql> load data infile ‘/home/SP_admin/tools/datagenerator/generated_data.csv’ into table test1 fields terminated by ‘;’;

when I do so, I get following error:

ERROR 13 (HY000): Can’t get stat of ‘/home/SP_admin/tools/datagenerator/generated_data.csv’ (Errorcode: 13)

can somebody point me to the error, please.

rgds,

uwe geercken