I am using Infobright 4.0 ICE and the server stops every two weeks.

Version: Server version: 5.1.40-log build number (revision)=IB_4.0_r13151_13690(ice)

Please find full error log. It seems there is some crash. Please suggest me for avoiding this issue.

Error log indicates frequently server is restarted and some times the service is try to start before the server was not properly stop. Then we are getting the following error message.

Please let me know why the server is crashed and how to avoid this issue.

thd: 0x2b755cbed320
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 = 0x2b75593fcf50 thread_stack 0x80000
[0x996249]
[0x4027da]
[0xae5020]
[0x78b9ea]
[0x7047b8]
[0x653fe2]
[0x58f5da]
[0x4a2958]
[0x4eb9fa]
[0x4b8851]
[0x4b9e03]
[0x4ac581]
[0xae023d]
[0xb24fb9]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort…
thd->query at 0x2b755caf2700 is an invalid pointer
thd->thread_id=7526
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
pure virtual method called
terminate called without an active exception
Fatal signal 6 while backtracing
terminate called recursively
120110 13:12:19 mysqld_safe Number of processes running now: 0
120110 13:12:19 mysqld_safe mysqld restarted
120110 13:12:19 [Warning] The syntax ‘—log_slow_queries’ is deprecated and will be removed in MySQL 7.0. Please use ‘—slow_query_log’/’—slow_query_log_file’ instead.
Loading configuration for Infobright instance ...
Option: AllowMySQLQueryPath, value: 0.
Option: AutoConfigure, value: 0.
Option: CacheFolder, value: /usr/local/infobright-4.0.3-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: 6000.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.

120110 13:12:19 [ERROR] Can’t start server: Bind on TCP/IP port: Address already in use
120110 13:12:19 [ERROR] Do you already have another mysqld server running on port: 5029 ?
120110 13:12:19 [ERROR] Aborting

120110 13:12:19 [Note] /usr/local/infobright-4.0.3-x86_64/bin/mysqld: Shutdown complete

Regards

Sudheer.

Session (25M Rows)
————-
Session_ID       Integer
Session_Date     Date
Decimal_User_IP   Decimal(10,0)

IP_Range (200K records)
————
Start_IP           Decimal(10,0)
End_IP             Decimal(10,0)
Loc_ID             Integer

Select
A.Session_ID
B.Loc_ID
From
Session A,
IP_Range B
Where
A.Decimal_User_IP Between B.Start_IP AND B.End_IP

The query renders in no time (less than 10 secs) on MySQL Workbench since it fetches only 1000 recs. However, when I write the Select to an output file through ‘Select ... INTO OUTFILE .... etc.,), the query has been running for ever.  I tried to reduce the number of rows in Session Table by filtering on Session_Date, but its not helping.

Any suggestions on optimizing it.

Thanks

show processlist;

113957   root   localhost:4274   information_schema   Query   0   executing   select * from processlist
113412   root   localhost:3547   sdh   Query   689   System lock   check table datastoretwo
112559   root   srvtest:2404   sdh   Sleep   1     \N
110810   root   srvtest:3854   sdh   Sleep   0     \N
109486   root   srvtest:1667   sdh   Sleep   1     \N
106971   root   srvtest:3929   sdh   Query   9934   System lock   SELECT SUM(price),MONTH(datetime),MIN(price) FROM summary_temp_condition_51880 WHERE sno between ‘13’ and ‘14’  AND NAMES = ‘serome’  GROUP BY MONTH(datetime)  ORDER BY NAMES LIMIT 1
106146   root   srvtest:2564   sdh   Sleep   9934     \N
103671   root   srvtest:2418   sdh   Sleep   0     \N
102435   root   srvtest:4478   sdh   Sleep   7207     \N

We are getting the following error in application.

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

        at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)

        at com.mysql.jdbc.Connection.commit(Connection.java:2283)

        at com.imi.sdhetl.QuartzETLProcessor.createAndLoadTable(QuartzETLProcessor.java:3048)

        at com.imi.sdhetl.QuartzETLProcessor.runETLProcess(QuartzETLProcessor.java:1986)

        at com.imi.sdhetl.job.ETLJob.execute(ETLJob.java:39)

        at org.quartz.core.JobRunShell.run(JobRunShell.java:206)

        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:548)

I’m trying to load a huge table into Infobright through SQL Server Information Services (SSIS).

I’ve installed several connectors (MySQL ODBC Connnector, dotConnect).

No I can connecto to MySQL, create schema for table (ICE Breaker) but the problem is with load data.

Message I recieve:

Error: 0xC020844B at Data Flow Task, ADO NET Destination 1 [143]: An exception has occurred during data insertion, the message returned from the provider is:

ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.40]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘“curr” (“ID”, “NAME”, “ISOCODE”, “COUNTRY_ID”, “ISSUPPORTED”, “MINEVENTAMOUNT”, ’ at line 1

Does anyone have an idea, how to solve that problem? It is connected with the MySQL syntax, and I know that I need to remove the quotation marks. I just don’t know how…

I must say, that I can not export data through flat file - need to do it automatically.

Thanks in advance for Your help!

I use to Ice breaker tool for exporting ms sql data . I used everything default to create csv export . I create a database in ICE and then i start load data infile process. When finished process I checked my table and i didnt see turkish characters.
i tried i a few different process but no result. .
What should i do exactly see turkish character on on ICE ?

I’ve tried many tools but none seem to work right… I was able to remove PK’s, FKs, to get about 1/3 of the tables to move over using MySQL migration tool, and although the community ICE Breaker tool is nice and seems to work great, I can’t move anything over to the database because the tool doesn’t support DELETE, INSERT and I forget the last one.

So, I’m looking for a tool or some way to move the data over to infrobright from a MS SQL server 2003…. can anyone give me a suggestion or a hint?

I should preface this query by saying that I am very new to databases, and feel like there may be something egregious with what I am trying to do.

Experimenting with Infobright 3.5.2. So far so good on querying single tables, but joining seems very slow. I have two tables A and B. A is 8 million records long and B is 80 million records long.

A simple join on 3 columns takes 20 seconds, which is much too long for my application. Q1: is this a reasonable time given a decent server?

I decided to create a surrogate key of records in B. However, when I try to populate the corresponding value in A, my 32GB server runs out of memory after about 40 minutes, after which I kill the query. Here is the query I am running:

Q2: is this a terribly wrong way to accomplish this?

I have the following problem,
I am trying to create a table with 8000 columns with the following sentence:

create table test (col_1 tinyint(1), col_2 tinyint(1), ...., col_8000 tinyint(1)) engine= brighthouse;

But when i executed this statement i got this error: ERROR 1117 (HY000) at line 1: Too many columns

I hope someone can help me, i have googled a lot, but i have found nothing.

Regards,
Ivan