Hi, I use ICE 3.2 for some time. This day a mysql error is encountered frequently when I query a common sql as before. I recorded the error message in the bh.err which is list below. Can you tell me is it a problem of ICE, mysql or file system?
Thanks a lot.
2010-02-23 10:55:41 [1] T:-1 = TABLE_ALIAS(T:0,“weblog”)
T:-2 = TMP_TABLE(T:-1)
VC:-2.0 = CREATE_VC(T:-2,PHYS_COL(T:-1,A:2))
A:-1 = T:-2.ADD_COLUMN(VC:-2.0,COUNT,“count(distinct uid)”,“DISTINCT”)
VC:-2.1 = CREATE_VC(T:-2,PHYS_COL(T:-1,A:0))
VC:-2.2 = CREATE_VC(T:-2,EXPR(“2010-02-22”))
F:0 = CREATE_FILTER(T:-2,VC:-2.1,=,VC:-2.2,<null>,WHERE)
T:-2.FILTER(F:0)
RESULT(T:-2)
2010-02-23 10:55:41 Type conversion for VC:2
2010-02-23 10:55:41 [1] Initial execution plan (non-join):
2010-02-23 10:55:41 [1] Cnd(0): VC:1(t0a0) BET. VC:4 AND VC:5 (0)
2010-02-23 10:55:41 [1] Packs/packrows after KN evaluation:
2010-02-23 10:55:41 [1] (t0) Pckrows: 125680, susp. 597 (124731 empty 352 full). Packs opened in 1 cond.: 597
2010-02-23 10:55:43 [1] Packrows after exact evaluation (WHERE):
2010-02-23 10:55:43 [1] (t0): 125680 all packrows, 949 to open (including 352 full)
2010-02-23 10:55:43 [1] Adding dist. column, min = 1000001, max = 35747407, dist = 34747408
2010-02-23 10:55:43 GroupDistinctTable initialized as Filter(34747407)
2010-02-23 10:55:43 [1] Aggregating: 38387434 tuples left.
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=1044480
max_used_connections=1
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 220783 K
bytes of memory
Hope that’s ok; if not, decrease some variables in the equation.
thd: 0xf3c2f0
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…
Cannot determine thread, fp=0x80000, backtrace may not be correct.
Bogus stack limit or frame pointer, fp=0x80000, stack_bottom=0x7f9430610000, thread_stack=524288, aborting backtrace.
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort…
thd->query at 0xf5dd10 = select count(distinct uid) from weblog where date=‘2010-02-22’
thd->thread_id=1
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
Number of processes running now: 0
100223 10:55:46 mysqld restarted
nohup: ignoring input
Loading configuration for Infobright instance ...
Option: AllowMySQLQueryPath, value: 1.
Option: BufferingLevel, value: 2.
Option: CacheFolder, value: /backup2/infobright/cache.
Option: CachingLevel, value: 1.
Option: ClusterSize, value: 2000.
Option: ControlMessages, value: 2.
Option: HugefileDir, value: .
Option: InternalMessages, value: 0.
Option: KNFolder, value: BH_RSI_Repository.
Option: KNLevel, value: 99.
Option: LicenseFile, value: <unknown>.
Option: LoaderMainHeapSize, value: 800.
Option: LoaderSaveThreadNumber, value: 16.
Option: PushDown, value: 1.
Option: ServerCompressedHeapSize, value: 1000.
Option: ServerMainHeapSize, value: 10000.
Infobright instance configuration loaded.
2010-02-23 10:55:46 [0] Brighthouse engine started, KNs: ok
100223 10:55:46 [Note] Infobright Community Edition 3.2 is ready for connections.
socket: ‘/var/run/mysqld/mysqld-ib.sock’ port: 4406 Source distribution
100223 10:55:46 [Note] SCHEDULER: Loaded 0 events
