[TRAFODION-1202] LP Bug: 1447826 - Select query sees error 8887 about explain buffer too small

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 2.0-incubating
• Component/s: connectivity-dcs
• External issue URL: https://bugs.launchpad.net/bugs/1447826
• Assignee: Tharak Capirala
• Reporter: Weishiun Tsai
• Created: 22/Jul/15 18:20
• Updated: 31/Aug/15 04:36
• Resolved: 31/Aug/15 04:36

Description

The following select query now sees error 8887 at the execution time complaining that the explain buffer is too small and the query execution fails.

• • • ERROR[8887] The provided buffer to retrieve generated code or explain data is either null or not big enough. [2015-04-23 21:26:32]

When it happens, the log file master*.log has entries look like the following:

2015-04-23 21:26:32,635, ERROR, MXOSRVR, Node Number: 1, CPU: 1, PIN:20878, Process Name:$Z010H1I , , ,A NonStop Process Service error Packed explain greater than table column size: 50000 has occurred.

2015-04-23 21:26:32,641, ERROR, SQL, Node Number: 0, CPU: 1, PIN: 20878, Process Name: $Z010H1I, SQLCODE: 8887, QID: MXID11001020878212296562883822389000000000806U3333400_1662_XX, *** ERROR[8887] The provided buffer to retrieve generated code or explain data is either null or not big enough.

This is a regression introduced in the v1.1.0 rc2 build. The same query still worked fine in the v1.1.1 rc1 build. The error also only happens in trafci; the same query runs fine in sqlci. All evidences right now point to the check-in to turn on the explain plan collection by default in DCS.

This is seen on the v1.1.0 rc2 (v0422) build. To reproduce it will require QA’s g_arkcasedb table.

-------------------------------------------------------------

Here is the entire script to reproduce it:

prepare xx from select * from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
)))))))))) ))))))))))
)))))))))) )))))))))) )))))))))) ))))))))))
)))))))))) )))))))))) )))))))))) ))))))))) ;

explain options 'f' xx;

execute xx;

-------------------------------------------------------------

Here is the execution output:

SQL>prepare xx from select * from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
where pic_x_1 in (select pic_x_1 from trafodion.g_arkcasedb.btsel02
)))))))))) ))))))))))
)))))))))) )))))))))) )))))))))) ))))))))))
)))))))))) )))))))))) )))))))))) ))))))))) ;

— SQL command prepared.

SQL>explain options 'f' xx;

LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------

199 . 200 root 8.00E+000
198 197 199 hybrid_hash_semi_joi 8.00E+000
. . 198 trafodion_scan BTSEL02 8.00E+000
196 195 197 hybrid_hash_semi_joi 8.00E+000
. . 196 trafodion_scan BTSEL02 8.00E+000
194 193 195 hybrid_hash_semi_joi 8.00E+000
. . 194 trafodion_scan BTSEL02 8.00E+000
192 191 193 hybrid_hash_semi_joi 8.00E+000
. . 192 trafodion_scan BTSEL02 8.00E+000
190 189 191 hybrid_hash_semi_joi 8.00E+000
. . 190 trafodion_scan BTSEL02 8.00E+000
188 187 189 hybrid_hash_semi_joi 8.00E+000
. . 188 trafodion_scan BTSEL02 8.00E+000
186 185 187 hybrid_hash_semi_joi 8.00E+000
. . 186 trafodion_scan BTSEL02 8.00E+000
184 183 185 hybrid_hash_semi_joi 8.00E+000
. . 184 trafodion_scan BTSEL02 8.00E+000
182 181 183 hybrid_hash_semi_joi 8.00E+000
. . 182 trafodion_scan BTSEL02 8.00E+000
180 179 181 hybrid_hash_semi_joi 8.00E+000
. . 180 trafodion_scan BTSEL02 8.00E+000
178 177 179 hybrid_hash_semi_joi 8.00E+000
. . 178 trafodion_scan BTSEL02 8.00E+000
176 175 177 hybrid_hash_semi_joi 8.00E+000
. . 176 trafodion_scan BTSEL02 8.00E+000
174 173 175 hybrid_hash_semi_joi 8.00E+000
. . 174 trafodion_scan BTSEL02 8.00E+000
172 171 173 hybrid_hash_semi_joi 8.00E+000
. . 172 trafodion_scan BTSEL02 8.00E+000
170 169 171 hybrid_hash_semi_joi 8.00E+000
. . 170 trafodion_scan BTSEL02 8.00E+000
168 167 169 hybrid_hash_semi_joi 8.00E+000
. . 168 trafodion_scan BTSEL02 8.00E+000
166 165 167 hybrid_hash_semi_joi 8.00E+000
. . 166 trafodion_scan BTSEL02 8.00E+000
164 163 165 hybrid_hash_semi_joi 8.00E+000
. . 164 trafodion_scan BTSEL02 8.00E+000
162 161 163 hybrid_hash_semi_joi 8.00E+000
. . 162 trafodion_scan BTSEL02 8.00E+000
160 159 161 hybrid_hash_semi_joi 8.00E+000
. . 160 trafodion_scan BTSEL02 8.00E+000
158 157 159 hybrid_hash_semi_joi 8.00E+000
. . 158 trafodion_scan BTSEL02 8.00E+000
156 155 157 hybrid_hash_semi_joi 8.00E+000
. . 156 trafodion_scan BTSEL02 8.00E+000
154 153 155 hybrid_hash_semi_joi 8.00E+000
. . 154 trafodion_scan BTSEL02 8.00E+000
152 151 153 hybrid_hash_semi_joi 8.00E+000
. . 152 trafodion_scan BTSEL02 8.00E+000
150 149 151 hybrid_hash_semi_joi 8.00E+000
. . 150 trafodion_scan BTSEL02 8.00E+000
148 147 149 hybrid_hash_semi_joi 8.00E+000
. . 148 trafodion_scan BTSEL02 8.00E+000
146 145 147 hybrid_hash_semi_joi 8.00E+000
. . 146 trafodion_scan BTSEL02 8.00E+000
144 143 145 hybrid_hash_semi_joi 8.00E+000
. . 144 trafodion_scan BTSEL02 8.00E+000
142 141 143 hybrid_hash_semi_joi 8.00E+000
. . 142 trafodion_scan BTSEL02 8.00E+000
140 139 141 hybrid_hash_semi_joi 8.00E+000
. . 140 trafodion_scan BTSEL02 8.00E+000
138 137 139 hybrid_hash_semi_joi 8.00E+000
. . 138 trafodion_scan BTSEL02 8.00E+000
136 135 137 hybrid_hash_semi_joi 8.00E+000
. . 136 trafodion_scan BTSEL02 8.00E+000
134 133 135 hybrid_hash_semi_joi 8.00E+000
. . 134 trafodion_scan BTSEL02 8.00E+000
132 131 133 hybrid_hash_semi_joi 8.00E+000
. . 132 trafodion_scan BTSEL02 8.00E+000
130 129 131 hybrid_hash_semi_joi 8.00E+000
. . 130 trafodion_scan BTSEL02 8.00E+000
128 127 129 hybrid_hash_semi_joi 8.00E+000
. . 128 trafodion_scan BTSEL02 8.00E+000
126 125 127 hybrid_hash_semi_joi 8.00E+000
. . 126 trafodion_scan BTSEL02 8.00E+000
124 123 125 hybrid_hash_semi_joi 8.00E+000
. . 124 trafodion_scan BTSEL02 8.00E+000
122 121 123 hybrid_hash_semi_joi 8.00E+000
. . 122 trafodion_scan BTSEL02 8.00E+000
120 119 121 hybrid_hash_semi_joi 8.00E+000
. . 120 trafodion_scan BTSEL02 8.00E+000
118 117 119 hybrid_hash_semi_joi 8.00E+000
. . 118 trafodion_scan BTSEL02 8.00E+000
116 115 117 hybrid_hash_semi_joi 8.00E+000
. . 116 trafodion_scan BTSEL02 8.00E+000
114 113 115 hybrid_hash_semi_joi 8.00E+000
. . 114 trafodion_scan BTSEL02 8.00E+000
112 111 113 hybrid_hash_semi_joi 8.00E+000
. . 112 trafodion_scan BTSEL02 8.00E+000
110 109 111 hybrid_hash_semi_joi 8.00E+000
. . 110 trafodion_scan BTSEL02 8.00E+000
108 107 109 hybrid_hash_semi_joi 8.00E+000
. . 108 trafodion_scan BTSEL02 8.00E+000
106 105 107 hybrid_hash_semi_joi 8.00E+000
. . 106 trafodion_scan BTSEL02 8.00E+000
104 103 105 hybrid_hash_semi_joi 8.00E+000
. . 104 trafodion_scan BTSEL02 8.00E+000
102 101 103 hybrid_hash_semi_joi 8.00E+000
. . 102 trafodion_scan BTSEL02 8.00E+000
100 99 101 hybrid_hash_semi_joi 8.00E+000
. . 100 trafodion_scan BTSEL02 8.00E+000
98 97 99 hybrid_hash_semi_joi 8.00E+000
. . 98 trafodion_scan BTSEL02 8.00E+000
96 95 97 hybrid_hash_semi_joi 8.00E+000
. . 96 trafodion_scan BTSEL02 8.00E+000
94 93 95 hybrid_hash_semi_joi 8.00E+000
. . 94 trafodion_scan BTSEL02 8.00E+000
92 91 93 hybrid_hash_semi_joi 8.00E+000
. . 92 trafodion_scan BTSEL02 8.00E+000
90 89 91 hybrid_hash_semi_joi 8.00E+000
. . 90 trafodion_scan BTSEL02 8.00E+000
88 87 89 hybrid_hash_semi_joi 8.00E+000
. . 88 trafodion_scan BTSEL02 8.00E+000
86 85 87 hybrid_hash_semi_joi 8.00E+000
. . 86 trafodion_scan BTSEL02 8.00E+000
84 83 85 hybrid_hash_semi_joi 8.00E+000
. . 84 trafodion_scan BTSEL02 8.00E+000
82 81 83 hybrid_hash_semi_joi 8.00E+000
. . 82 trafodion_scan BTSEL02 8.00E+000
80 79 81 hybrid_hash_semi_joi 8.00E+000
. . 80 trafodion_scan BTSEL02 8.00E+000
78 77 79 hybrid_hash_semi_joi 8.00E+000
. . 78 trafodion_scan BTSEL02 8.00E+000
76 75 77 hybrid_hash_semi_joi 8.00E+000
. . 76 trafodion_scan BTSEL02 8.00E+000
74 73 75 hybrid_hash_semi_joi 8.00E+000
. . 74 trafodion_scan BTSEL02 8.00E+000
72 71 73 hybrid_hash_semi_joi 8.00E+000
. . 72 trafodion_scan BTSEL02 8.00E+000
70 69 71 hybrid_hash_semi_joi 8.00E+000
. . 70 trafodion_scan BTSEL02 8.00E+000
68 67 69 hybrid_hash_semi_joi 8.00E+000
. . 68 trafodion_scan BTSEL02 8.00E+000
66 65 67 hybrid_hash_semi_joi 8.00E+000
. . 66 trafodion_scan BTSEL02 8.00E+000
64 63 65 hybrid_hash_semi_joi 8.00E+000
. . 64 trafodion_scan BTSEL02 8.00E+000
62 61 63 hybrid_hash_semi_joi 8.00E+000
. . 62 trafodion_scan BTSEL02 8.00E+000
60 59 61 hybrid_hash_semi_joi 8.00E+000
. . 60 trafodion_scan BTSEL02 8.00E+000
58 57 59 hybrid_hash_semi_joi 8.00E+000
. . 58 trafodion_scan BTSEL02 8.00E+000
56 55 57 hybrid_hash_semi_joi 8.00E+000
. . 56 trafodion_scan BTSEL02 8.00E+000
54 53 55 hybrid_hash_semi_joi 8.00E+000
. . 54 trafodion_scan BTSEL02 8.00E+000
52 51 53 hybrid_hash_semi_joi 8.00E+000
. . 52 trafodion_scan BTSEL02 8.00E+000
50 49 51 hybrid_hash_semi_joi 8.00E+000
. . 50 trafodion_scan BTSEL02 8.00E+000
48 47 49 hybrid_hash_semi_joi 8.00E+000
. . 48 trafodion_scan BTSEL02 8.00E+000
46 45 47 hybrid_hash_semi_joi 8.00E+000
. . 46 trafodion_scan BTSEL02 8.00E+000
44 43 45 hybrid_hash_semi_joi 8.00E+000
. . 44 trafodion_scan BTSEL02 8.00E+000
42 41 43 hybrid_hash_semi_joi 8.00E+000
. . 42 trafodion_scan BTSEL02 8.00E+000
40 39 41 hybrid_hash_semi_joi 8.00E+000
. . 40 trafodion_scan BTSEL02 8.00E+000
38 37 39 hybrid_hash_semi_joi 8.00E+000
. . 38 trafodion_scan BTSEL02 8.00E+000
36 35 37 hybrid_hash_semi_joi 8.00E+000
. . 36 trafodion_scan BTSEL02 8.00E+000
34 33 35 hybrid_hash_semi_joi 8.00E+000
. . 34 trafodion_scan BTSEL02 8.00E+000
32 31 33 hybrid_hash_semi_joi 8.00E+000
. . 32 trafodion_scan BTSEL02 8.00E+000
30 29 31 hybrid_hash_semi_joi 8.00E+000
. . 30 trafodion_scan BTSEL02 8.00E+000
28 27 29 hybrid_hash_semi_joi 8.00E+000
. . 28 trafodion_scan BTSEL02 8.00E+000
26 25 27 hybrid_hash_semi_joi 8.00E+000
. . 26 trafodion_scan BTSEL02 8.00E+000
24 23 25 hybrid_hash_semi_joi 8.00E+000
. . 24 trafodion_scan BTSEL02 8.00E+000
22 21 23 hybrid_hash_semi_joi 8.00E+000
. . 22 trafodion_scan BTSEL02 8.00E+000
20 19 21 hybrid_hash_semi_joi 8.00E+000
. . 20 trafodion_scan BTSEL02 8.00E+000
18 17 19 hybrid_hash_semi_joi 8.00E+000
. . 18 trafodion_scan BTSEL02 8.00E+000
16 15 17 hybrid_hash_semi_joi 8.00E+000
. . 16 trafodion_scan BTSEL02 8.00E+000
14 13 15 hybrid_hash_semi_joi 8.00E+000
. . 14 trafodion_scan BTSEL02 8.00E+000
12 11 13 hybrid_hash_semi_joi 8.00E+000
. . 12 trafodion_scan BTSEL02 8.00E+000
10 9 11 hybrid_hash_semi_joi 8.00E+000
. . 10 trafodion_scan BTSEL02 8.00E+000
8 7 9 hybrid_hash_semi_joi 8.00E+000
. . 8 trafodion_scan BTSEL02 8.00E+000
6 5 7 hybrid_hash_semi_joi 8.00E+000
. . 6 trafodion_scan BTSEL02 8.00E+000
4 3 5 hybrid_hash_semi_joi u 8.00E+000
. . 4 trafodion_scan BTSEL02 8.00E+000
2 1 3 hybrid_hash_semi_joi u 8.00E+000
. . 2 trafodion_scan BTSEL02 8.00E+000
. . 1 trafodion_scan BTSEL02 8.00E+000

— SQL operation complete.

SQL>execute xx;

• • • ERROR[8887] The provided buffer to retrieve generated code or explain data is either null or not big enough. [2015-04-23 21:26:32]