Hi,

  When i call the procedure, i got the following error…?

ERROR 9 (HY000): Brighthouse out of resources error: Too many tuples.

See the following log….

2009-08-12 15:27:29 Type conversion for VC:3
2009-08-12 15:27:29 Type conversion for VC:5
2009-08-12 15:27:29 [10] Initial execution plan (non-join):
2009-08-12 15:27:29 [10] Cnd(0):  VC:7(t1a0) BET. VC:17(378609) AND VC:18(378609)    (4.92)
2009-08-12 15:27:29 [10] Cnd(1):  VC:2(t0a0) BET. VC:11(378609) AND VC:12(378609)    (8.54)
2009-08-12 15:27:29 [10] Cnd(2):  VC:4(t0a2) BET. VC:13 AND VC:14     (16.64)
2009-08-12 15:27:29 [10] Cnd(3):  VC:0(t0a4) BET. VC:15(4.94066e-324) AND VC:16(1.79769e+308)  (20.42)
2009-08-12 15:27:29 [10] Packs/packrows after KN evaluation:
2009-08-12 15:27:29 [10] (t0) Pckrows: 11324, susp. 7 (11317 empty 0 full). Packs opened in 3 cond.: 263
2009-08-12 15:27:29 [10] (t1) Pckrows: 302, susp. 9 (293 empty 0 full). Packs opened in 1 cond.: 9
2009-08-12 15:27:29 [10] Packrows after exact evaluation (WHERE):
2009-08-12 15:27:29 [10] (t0): 11324 all packrows, 1 to open (including 0 full)
2009-08-12 15:27:29 [10] (t1): 302 all packrows, 1 to open (including 0 full)
2009-08-12 15:27:29 [10] Join execution plan:
2009-08-12 15:27:29 [10] Cnd(4):  VC:1(t0a1) = VC:8(t1a1)    (36.45)
2009-08-12 15:27:29 [10] Traversed all 502 rows.
2009-08-12 15:27:29 [10] Produced 502 tuples.
2009-08-12 15:27:29 [10] Tuples after inner join 0-1 [hash]: 502
2009-08-12 15:27:29 [10] Aggregating: 502 tuples left.
2009-08-12 15:27:29 [10] Aggregated (1 gr). Omitted packrows: 0 + 1 partially, out of 1 total.
2009-08-12 15:27:29 Type conversion for VC:35
2009-08-12 15:27:29 Type conversion for VC:37
2009-08-12 15:27:29 [10] Error: Too many tuples.

How to solve this error?

Regards,
S.Ashokkumar.

Hi,

What the query looks like?

Such error is usually caused by too general join condition (e.g. a query generating nearly full Cartesian product of two large tables). The error means that the result of join will be too large to be processed.

Regards,

Hi,

I had the same error, a solution that worked for me is the following :

change one of the inner joins to a left outer join.

regards.
Daan Blinde

I am also getting same error.

I have observed following error while doing some export in info bright. (NGMP info bright)

SELECT * INTO OUTFILE ‘/data/delivery_reports_09.txt’ FIELDS TERMINATED BY ‘^’  OPTIONALLY ENCLOSED BY ‘“’  ESCAPED BY ‘\\’ LINES TERMINATED BY ‘\r\n’  FROM delivery_reports_2011_09;

ERROR 9 (HY000): Brighthouse out of resources error: I/O operation on /usr/local/infobright-3.5.2-x86_64/cache/PS_CB_00000110B0C40x12144520.bh_tmp failed with error - No space left on device File name /usr/local/infobright-3.5.2-x86_64/cache/PS_CB_00000110B0C40x12144520.bh_tmp

Can you help me on how to solve this?
How to change I/O operation from /usr to other drive?

Hi !

Your error is a different one - no disk space. Which IB version you run ? I guess this error has been fixed…

Dear Janusz,
Very Thanks for fast reply,

Server version: 5.1.40 build number (revision)=IB_3.5.2_r11794_12393(ice).

Is it required to upgrate new version?

Definitely upgrade it. 4.0.3 is the current version.

Can you share steps to do this without losing any data?

http://www.infobright.org/wiki/Upgrade_Guide/