Infobright.org Forums

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’

how can we execute .sql file in InfoBright msql> editor

2012-02-01T18:56:30-04:00

taken a backup of existing database schema from mysql query browser .sql file. Trying to execute the file in InfoBright mysql>

Usage: . <filename> | source <filename>
-> . IFMBackup.sql

Request you to suggest how can we execute the .sql file in InfoBright.

Problem with loading data with UTF8

2012-01-31T11:05:54-04:00

Hi.
I am testing ICE 4.0.5 and i am having problem with loading CSV data from a different Mysql Database.

My table :

CREATE TABLE `Test` (
`ID` BIGINT(20) NOT NULL ,
`carrier` VARCHAR(50) CHARSET utf8 COLLATE utf8_general_ci DEFAULT NULL
) DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

the data i am loading is in a file that was created by using SELECT * INTO OUTFILE “/mnt/mysql/test.sql” FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘“’ LINES TERMINATED BY ‘n’ from test , here is the file data:
“112”,“Compañía Dominicana de Teléfonos, C. por A. - CODE”

once this data is in a UTF8 file i am getting :

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

If i change the file coding to ANSI i am able to load the data.

What can i do to load the data >

Problems with running Infobright Service

2011-11-29T11:37:41-04:00

I’ve installed IEE 4.0.5 win32.

I can not start the Infobright service. I’m getting message:

Could not start the Infobright service in Local Computer.
Error 1067: The process terminated unexpectedly.

Any suggestions what need to be fixed?

Thanks in advance.

getting error on infobrite mysql server as “Incorrect information in file: ‘./sdh/temp_229637.frm” Please help me why it is comming?

2011-08-04T07:04:42-04:00

getting error on infobrite mysql server as “Incorrect information in file: ‘./sdh/temp_229637.frm” Please help me why it is comming?

Application details

Server version: 5.1.40 build number (revision)=IB_3.5.2_r11794_12393(ice)
We are trying for around 40 parallel load data commands into the database.
We create a table load the data into the table and then query the table for the required data and export it to an outfile and then drop the table.
Again we create a a new table now we load the data from the out file into this newly created table.

please find attached error log file.
could you please help me on this bug

Application details
Loading configuration for Infobright instance ...
Option: AllowMySQLQueryPath, value: 0.
Option: AutoConfigure, value: 0.
Option: CacheFolder, value: /usr/local/infobright-3.5.2-x86_64/cache.
Option: ControlMessages, value: 0.
Option: InternalMessages, value: 0.
Option: KNFolder, value: BH_RSI_Repository.
Option: KNLevel, value: 99.
Option: LicenseFile, value: <unknown>.
Option: LoaderMainHeapSize, value: 800.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 10000.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
110803 11:54:33 [Note] Event Scheduler: Loaded 0 events
110803 11:54:33 [Note] Infobright Community Edition is ready for connections.
socket: ‘/tmp/mysql-ib.sock’ port: 5029 build number (revision)=IB_3.5.2_r11794_12393(ice)
110803 12:37:00 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/summary_temp_condition_207306.frm’
110803 12:37:01 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/temp_229637.frm’
110803 14:25:21 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/summary_temp_condition_207306.frm’
110803 14:25:22 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/temp_229637.frm’
110803 16:22:44 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/summary_temp_condition_207306.frm’
110803 16:22:44 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/temp_229637.frm’
110803 16:55:55 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/summary_temp_condition_207306.frm’
110803 16:55:56 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/temp_229637.frm’
110803 16:58:11 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/summary_temp_condition_207306.frm’
110803 16:58:11 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/temp_229637.frm’
110803 17:05:34 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/summary_temp_condition_207306.frm’
110803 17:05:34 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/temp_229637.frm’
110803 17:28:05 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh
110803 17:29:25 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/temp_229637.frm’
110803 17:32:31 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/summary_temp_condition_207306.frm’
110803 17:32:31 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/temp_229637.frm’
110803 17:52:42 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/summary_temp_condition_207306.frm’
110803 17:52:42 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/temp_229637.frm’
110803 18:03:20 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/summary_temp_condition_207306.frm’
110803 18:03:20 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/temp_229637.frm’
110803 18:13:14 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/summary_temp_condition_207306.frm’
110803 18:13:14 [ERROR] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Incorrect information in file: ‘./sdh/temp_229637.frm’
110803 18:17:14 - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=16777216
read_buffer_size=1048576
max_used_connections=26
max_threads=151
threads_connected=22
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 327166 K
bytes of memory
Hope that’s ok; if not, decrease some variables in the equation.

thd: 0x2b82dc0513c0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong…
stack_bottom = 0x2b82d9330f50 thread_stack 0x80000
[0x9519c9]
[0x4027da]
[0xa82a60]
[0x7676aa]
[0x6e5428]
[0x652ee4]
[0x58ef1a]
[0x4a2878]
[0x4eb90a]
[0x4b8761]
[0x4b9d13]
[0x4ac4a1]
[0xa7dc7d]
[0xac29f9]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort…
thd->query at 0x2b82dc0bd850 is an invalid pointer

Issues upgrading from 3.5.2 to 3.5.2-P1 on Linux

2011-05-31T20:01:51-04:00

Hi,

On Linux I have a 3.5.2 32-bit Infobright [IB_3.5.2_r11794_12019(ice)] running with millions of rows. To upgrade to 3.5.2-P1 [IB_3.5.2_r11794_12393(ice)], since it is a bug-fix upgrade, I simply replaced the older versions of the following folders from 3.5.2 with the new ones from 3.5.2-P1: “bin”, “include”, “lib”, “libexec”, “scripts”, “share”, “support-files”. However, when I start Infobright, it comes up with errors:-

110531 17:01:48 mysqld_safe mysqld from pid file /var/lib/infobright/ajitsuma.devlab.com.pid ended
110531 17:03:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/infobright
Loading configuration for Infobright instance ...
Option: AllowMySQLQueryPath, value: 0.
Option: AutoConfigure, value: 0.
Option: CacheFolder, value: /var/lib/infobright/cache.
Option: ControlMessages, value: 1.
Option: InternalMessages, value: 0.
Option: KNFolder, value: BH_RSI_Repository.
Option: KNLevel, value: 99.
Option: LicenseFile, value: <unknown>.
Option: LoaderMainHeapSize, value: 320.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 600.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
110531 17:03:22 [ERROR] Plugin ‘BRIGHTHOUSE’ init function returned error.
110531 17:03:22 [ERROR] Plugin ‘BRIGHTHOUSE’ registration as a STORAGE ENGINE failed.
110531 17:03:22 [ERROR] Unknown/unsupported table type: brighthouse
110531 17:03:22 [ERROR] Aborting

110531 17:03:22 [Note] /opt/GMSVP/infobright/bin/mysqld: Shutdown complete

110531 17:03:22 mysqld_safe mysqld from pid file /var/lib/infobright/ajitsuma.devlab.com.pid ended

The brighthouse.log file has the following entries:-

2011-05-31 17:03:22 Brighthouse: Fatal error: Unable to start IB Updater (/opt/GMSVP/infobright/bin/updater).

I tried the same approach in Windows, and it worked just fine.

Any tips?

Thanks,
Prasad

ICE EC2 Instructions Typo

2011-02-07T21:29:34-04:00

http://www.infobright.org/downloads/contributions/Amazon_Cloud_EC2_Instructions.pdf+Amazon&hl=en&gl=us&pid=bl&srcid=ADGEESglr8T24jo8_Nv9_fmNfp3QuMpAeCEkaCNQm4_0vkCV-YlFpyp65-eLrIJZ67qLNnFo1jfg4-_BWGiZlS-TohIsDCkDvji1VLgO4Vu3SwH8irclv-CHsuJOy11ocBioA8sa-kw1&sig=AHIEtbR-VMEAvx2DnNoTcjItEGHLOzOV4Q&pli=1 says:

electronic block storage.

I think it should say:

elastic block store.

i want to use innodb plugin and get following errmsg

2011-01-16T22:23:54-04:00

i add following under [mysqld] of d:ice35my-ib.ini
then put ha_innodb.dll into D:ICE35libplugin

ignore_builtin_innodb
   plugin_load=innodb=ha_innodb.dll;innodb_trx=ha_innodb.dll;innodb_locks=ha_innodb.dll;innodb_lock_waits=ha_innodb.dll;innodb_cmp=ha_innodb.dll;innodb_cmp_reset=ha_innodb.dll;innodb_cmpmem=ha_innodb.dll;innodb_cmpmem_reset=ha_innodb.dll 

D:ICE35>sc start infobright

D:ICE35>binmysql -uroot

error: Found option without preceding group in config file: D:ICE35my-ib.ini at line: 1
Fatal error in defaults handling. Program aborted
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.1.40 build number (revision)=IB_3.5.0_r9686_9787(ice)

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> INSTALL PLUGIN innodb SONAME 'ha_innodb.dll';
ERROR 1126 (HY000): Can't open shared library 'd:ICE35lib/plugin/ha_innodb.dll (errno: 2 )
mysql> show plugins;
+-------------+--------+----------------+---------+-------------+
| Name        | Status | Type           | Library | License     |
+-------------+--------+----------------+---------+-------------+
| binlog      | ACTIVE | STORAGE ENGINE | NULL    | GPL         |
| CSV         | ACTIVE | STORAGE ENGINE | NULL    | GPL         |
| MEMORY      | ACTIVE | STORAGE ENGINE | NULL    | GPL         |
| MyISAM      | ACTIVE | STORAGE ENGINE | NULL    | GPL         |
| MRG_MYISAM  | ACTIVE | STORAGE ENGINE | NULL    | GPL         |
| partition   | ACTIVE | STORAGE ENGINE | NULL    | GPL         |
| BRIGHTHOUSE | ACTIVE | STORAGE ENGINE | NULL    | PROPRIETARY |
+-------------+--------+----------------+---------+-------------+ 

Installing multiple instances of ICE with RPM

2010-07-30T18:07:39-04:00

I have developed and tested the following method for installing a second instance of ICE (and/or IEE) on a single physical server after an initial installation with the RPM installer as RPM is not designed to install multiple copies of the same package. (It can be easily repeated for more than two instances or modified for multiple versions of ICE/IEE.) Similar efforts would be required for DEB and PKG installations but not necessary with the install-infobright.sh script included in the TAR packages.

There are really no sequential dependencies here so any of the steps can be done in any order but I find the following to be the most logical to me. If your second installation fails to start, review the server log, bh.err by default, in the data directory for your 2nd installation. It will point out what can’t be found, read, or rationalized.

Good luck!

1. install 1st instance with the rpm command per instructions found here (click link to be taken to the wiki page)


# rpm -i infobright_<version_name>.rpm

2. if you started the infobright server after installation, be sure to shut down the server for the 1st installed instance


# /etc/init.d/mysqld-ib stop

3. create 2nd symbolic link in /usr/local to infobright software directory


# ln -s /usr/local/<infobright softare> <new link>

4. create new data & cache directories (can be a copy of existing directories), be sure to preserve the mysql ownership and privileges


# cp -rp /<path>/<1dir> /<path>/<2dir>

By default, the data and cache directories are located in /usr/local/infobright. Many users run the postconfig.sh script to relocate them to somewhere like /opt/infobright so their paths are /opt/infobright/data and /opt/infobright/cache. In this case the command would look like this:


# cp -rp /opt/infobright /opt/<2dir>

5. edit new /<2dir>/data/brighthouse.ini
- change ‘CacheFolder’ value from CacheFolder = /<1dir>/cache to CacheFolder = /<2dir>/cache

NOTE: If you plan to run both instances simultaneously, you may also need to adjust the amount of memory specified for ServerManHeapSize such that the combined amounts do not exceed the total memory of the physical server.

6. copy mysql config file to a new file


# cp /etc/my-ib.cnf /etc/my-<name>.cnf

7. edit the new mysql config file, /etc/my-<name>.cnf
- change every occurrence of ‘port’ value from 5029 to a different, unused port number, say, 5030 (3 times)
- change every occurrence of ‘socket’ value from /etc/mysql-ib.sock to /etc/mysql-<name>.sock (2 times)

- change ‘infobright’ in the following line to <new link>
- basedir=/usr/local/<new link>

- change every occurrence of ‘infobright’ in the following lines to <2dir>
- datadir = /<2dir>/data
- log-error = /<2dir>/data/bh.err
- general_log_file=/<2dir>/data/general_query.log
- slow_query_log_file=/<2dir>/data/slow_query.log

8. copy infobright start/stop script to new file


# cp /etc/init.d/mysqld-ib /etc/init.d/mysqld-<name>

9. edit new start/stop script, /etc/init.d/mysqld-<name>
- change ‘conf’ value from conf=/etc/my-ib.cnf to conf=/etc/my-<name>.cnf

10. copy client script to new file


# cp /usr/bin/mysql-ib /usr/bin/mysql-<name>

11. edit new client script, /usr/bin/mysql-<name>
- change path to use new link name - /usr/local/<new link>/bin/mysql
- change defaults-file to new mysql config file -—defaults-file=/etc/my-<name>.cnf

12. restart 1st server and start 2nd server

# /etc/init.d/mysqld-ib start
# /etc/init.d/mysqld-<name> start 

UPDATE: If one uses the same string for <name>, <new link> and <2dir> (as I did), this is greatly simplified.