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.
]]>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’
Usage: \. <filename> | source <filename>
-> \. IFMBackup.sql
Request you to suggest how can we execute the .sql file in InfoBright.
]]>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 >
]]>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.
]]>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
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
electronic block storage.
I think it should say:
]]>elastic block store.
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>bin\mysql -uroot
error: Found option without preceding group in config file: D:\ICE35\my-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:\ICE35\lib/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 |
+-------------+--------+----------------+---------+-------------+
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.
]]>