[MADLIB-889] MADlid association rules limitiaon

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Workaround
• Assignee: Rahul Iyer
• Reporter: George
• Created: 15/May/15 06:30
• Updated: 19/Sep/18 18:38
• Resolved: 19/Sep/18 18:38

Description

<SQL>
–
SELECT * FROM madlib.assoc_rules(
.02, – support
.1, – confidence
'trans_id', – trans_id
'trans', – trans
'madlib.APR_D1_0511', – input table
'apriori_out_0511', – output schema
TRUE);
<output>
–
INFO: finished checking parameters
CONTEXT: PL/Python function "assoc_rules"
INFO: finished removing duplicates
CONTEXT: PL/Python function "assoc_rules"
INFO: finished encoding items
CONTEXT: PL/Python function "assoc_rules"
INFO: finished encoding input table: 28.8922719955
CONTEXT: PL/Python function "assoc_rules"
INFO: Beginning iteration #1
CONTEXT: PL/Python function "assoc_rules"
INFO: 248 Frequent itemsets found in this iteration
CONTEXT: PL/Python function "assoc_rules"
INFO: Completed iteration # 1. Time: 15.6718640327
CONTEXT: PL/Python function "assoc_rules"
INFO: Beginning iteration # 2
CONTEXT: PL/Python function "assoc_rules"
INFO: time of preparing data: 1.1467320919
CONTEXT: PL/Python function "assoc_rules"
INFO: 5343 Frequent itemsets found in this iteration
CONTEXT: PL/Python function "assoc_rules"
INFO: Completed iteration # 2. Time: 17.6499559879
CONTEXT: PL/Python function "assoc_rules"
INFO: Beginning iteration # 3
CONTEXT: PL/Python function "assoc_rules"
INFO: time of preparing data: 3.88985896111
CONTEXT: PL/Python function "assoc_rules"
INFO: 60508 Frequent itemsets found in this iteration
CONTEXT: PL/Python function "assoc_rules"
INFO: Completed iteration # 3. Time: 52.9074699879
CONTEXT: PL/Python function "assoc_rules"
INFO: Beginning iteration # 4
CONTEXT: PL/Python function "assoc_rules"
INFO: time of preparing data: 237.640460968
CONTEXT: PL/Python function "assoc_rules"
INFO: 457880 Frequent itemsets found in this iteration
CONTEXT: PL/Python function "assoc_rules"
INFO: Completed iteration # 4. Time: 957.164274931
CONTEXT: PL/Python function "assoc_rules"
INFO: Beginning iteration # 5
CONTEXT: PL/Python function "assoc_rules"
INFO: time of preparing data: 9426.02343702
CONTEXT: PL/Python function "assoc_rules"
ERROR: plpy.SPIError: could not write to temporary file: No space left on device (seg24 slice2 sdw04:40000 pid=62587) (plpython.c:4648)
CONTEXT: Traceback (most recent call last):
PL/Python function "assoc_rules", line 36, in <module>
verbose
PL/Python function "assoc_rules", line 367, in assoc_rules
PL/Python function "assoc_rules"

• • • • • • • • • • Error **********

ERROR: plpy.SPIError: could not write to temporary file: No space left on device (seg24 slice2 sdw04:40000 pid=62587) (plpython.c:4648)
SQL state: XX000
Context: Traceback (most recent call last):
PL/Python function "assoc_rules", line 36, in <module>
verbose
PL/Python function "assoc_rules", line 367, in assoc_rules
PL/Python function "assoc_rules"