Vertica goes down when I execute a query that has INTERSECT, with a PreparedStatement from a JDBC co

Carlos_Santos

Overview description

Vertica goes down when I execute a query with INTERSECT, as a PreparedStatement from a JDBC connection.

The query that I execute is:

SELECT u1.iinc_id FROM ((SELECT t0.iinc_id FROM VMart.public.internet_inc t0 INTERSECT SELECT (t1.iinc_id  * count( *) + ?) AS iinc_id FROM VMart.public.internet_inc t1 GROUP BY t1.iinc_id)  INTERSECT SELECT t2.iinc_id  * count( *)  * ? AS iinc_id FROM VMart.public.internet_inc t2 GROUP BY t2.iinc_id) u1

Steps to Reproduce

Create a Java class that does the following:

- Opens a JDBC connection with Vertica
- Creates a PreparedStatement with the query above
- Set the parameters of the query with

preparedStatement.setInt(1, 1);
preparedStatement.setInt(2, 2);

- Execute the query.
Vertica returns the following and dies.

java.sql.SQLException: [Vertica][VJDBC](100024) IOException while communicating with server: null. Refer to the inner exception for more detail.
    at com.vertica.io.ProtocolStream.readMessage(Unknown Source)
    at com.vertica.core.VConnection.handleError(Unknown Source)
    at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source)
    at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
    at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
    at com.vertica.jdbc.SPreparedStatement.<init>(Unknown Source)
    at com.vertica.jdbc.VerticaPreparedStatementImpl.<init>(Unknown Source)
    at com.vertica.jdbc.VJDBCObjectFactory.createPreparedStatement(Unknown Source)
    at com.vertica.jdbc.SConnection.prepareStatement(Unknown Source)
Caused by: com.vertica.support.exceptions.GeneralException: [Vertica][VJDBC](100024) IOException while communicating with server: null. Refer to the inner exception for more detail.
    ... 9 more
Caused by: java.io.EOFException
    at com.vertica.io.VStream.ReceiveChar(Unknown Source)
    at com.vertica.io.ProtocolStream.readMessage(Unknown Source)
    at com.vertica.core.VConnection.handleError(Unknown Source)
    at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source)
    at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
    at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
    at com.vertica.jdbc.SPreparedStatement.<init>(Unknown Source)
    at com.vertica.jdbc.VerticaPreparedStatementImpl.<init>(Unknown Source)
    at com.vertica.jdbc.VJDBCObjectFactory.createPreparedStatement(Unknown Source)
    at com.vertica.jdbc.SConnection.prepareStatement(Unknown Source)
    at com.denodo.test.vertica.VerticaBasicTest.main(VerticaBasicTest.java:80)
    

The file ~/VMart/v_mart_node0001_catalog/vertica.log, at the end, has this:

2014-10-09 21:06:42.979 Init Session:0x197da450-a000000004f5a6 [Txn] <INFO> Begin Txn: a000000004f5a6 'SELECT u1.iinc_id FROM ((SELECT t0.iinc_id FROM VMart.public.internet_inc t0 INTERSECT SELECT (t1.iinc_id * count( *) + ?) AS iinc_id FROM VMart.public.internet_inc t1 GROUP BY t1.iinc_id) INTERSECT SELECT t2.iinc_id * count( *) * ? AS iinc_id FROM VMart.public.internet_inc t2 GROUP BY t2.iinc_id) u1'
2014-10-09 21:06:42.981 Init Session:0x197da450-a000000004f5a6 <PANIC> @v_vmart_node0001: VX001/5422: VAssert(ltypmod != -1 && rtypmod != -1) failed
    LOCATION:  transformSetOperationTreeImpl, analyze.c:4498
2014-10-09 21:06:43.701 Init Session:0x197da450-a000000004f5a6 [Main] <PANIC> Wrote backtrace to ErrorReport.txt

Reproducibility

I can reproduce the problema every time I execute this query.

Environment

HP Vertica 7.0.1 VMWare vSphere 4.0(OVF) (downloaded from the Vertica's website) running on Windows 7 64 bits

Carlos_Santos

I just realised I am connecting to Vertica with the 6.1.3 JDBC driver.
I will update to say if the same happens with the newest JDBC driver.

Carlos_Santos

I get the same error using the vertica-jdbc-7.0.2-1.jar JDBC driver.

From vertica.log:

  2014-10-09 21:30:41.118 Init Session:0x2aaab0001370 <LOG> @v_vmart_node0001: 00000/2705: Connection received: host=192.168.1.166 port=62788 (connCnt 3)
2014-10-09 21:30:41.123 Init Session:0x2aaab0001370 <LOG> @v_vmart_node0001: 00000/4686: sendAuthRequest: user=dbadmin database=VMart host=192.168.1.166 authType=0
2014-10-09 21:30:41.123 Init Session:0x2aaab0001370 <LOG> @v_vmart_node0001: 00000/2703: Connection authenticated: user=dbadmin database=VMart host=192.168.1.166
2014-10-09 21:30:41.123 Init Session:0x2aaab0001370 <LOG> @v_vmart_node0001: 00000/2609: Client pid: 13576
2014-10-09 21:30:41.123 Init Session:0x2aaab0001370 <LOG> @v_vmart_node0001: 00000/2608: Client label: jdbc-06.01.0300-92e99d1d-1904-4175-9fe2-6750d8a9023f
2014-10-09 21:30:41.147 Init Session:0x2aaab0001370 [Session] <INFO> [PQuery] TX:0(vertica-31472:0x8a) select * from (select type_name as data_type_name, case odbc_type when 9 then odbc_subtype when 10 then 1111 else odbc_type end as data_type, column_size, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_prefix, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_suffix, creation_parameters as create_param, 1 as nullable, 1 as case_sensitive, 3 as searchable, 0 as unsigned_attribute, case odbc_type when 2 then 1 else 0 end as fixed_prec_scale, 0 as auto_unique, type_name as local_type_name, min_scale as minimum_scale, max_scale as maximum_scale, odbc_type as sql_data_type, odbc_subtype as sql_datetime_sub, 10 as num_prec_radix from v_catalog.types order by odbc_type, odbc_subtype) as vmd 
2014-10-09 21:30:41.168 Init Session:0x2aaab0001370 [Session] <INFO> [Query] TX:0(vertica-31472:0x8a) select * from (select type_name as data_type_name, case odbc_type when 9 then odbc_subtype when 10 then 1111 else odbc_type end as data_type, column_size, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_prefix, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_suffix, creation_parameters as create_param, 1 as nullable, 1 as case_sensitive, 3 as searchable, 0 as unsigned_attribute, case odbc_type when 2 then 1 else 0 end as fixed_prec_scale, 0 as auto_unique, type_name as local_type_name, min_scale as minimum_scale, max_scale as maximum_scale, odbc_type as sql_data_type, odbc_subtype as sql_datetime_sub, 10 as num_prec_radix from v_catalog.types order by odbc_type, odbc_subtype) as vmd 
2014-10-09 21:30:41.169 Init Session:0x2aaab0001370-a000000004f5ca [Txn] <INFO> Begin Txn: a000000004f5ca 'select * from (select type_name as data_type_name, case odbc_type when 9 then odbc_subtype when 10 then 1111 else odbc_type end as data_type, column_size, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_prefix, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_suffix, creation_parameters as create_param, 1 as nullable, 1 as case_sensitive, 3 as searchable, 0 as unsigned_attribute, case odbc_type when 2 then 1 else 0 end as fixed_prec_scale, 0 as auto_unique, type_name as local_type_name, min_scale as minimum_scale, max_scale as maximum_scale, odbc_type as sql_data_type, odbc_subtype as sql_datetime_sub, 10 as num_prec_radix from v_catalog.types order by odbc_type, odbc_subtype) as vmd '
2014-10-09 21:30:41.202 Init Session:0x2aaab0001370-a000000004f5ca [Session] <INFO> [PQuery] TX:a000000004f5ca(vertica-31472:0x8a) set session autocommit to on
2014-10-09 21:30:41.203 Init Session:0x2aaab0001370-a000000004f5ca [Session] <INFO> [Query] TX:a000000004f5ca(vertica-31472:0x8a) set session autocommit to on
2014-10-09 21:30:41.204 Init Session:0x2aaab0001370-a000000004f5ca [Txn] <INFO> Starting Commit: Txn: a000000004f5ca 'select * from (select type_name as data_type_name, case odbc_type when 9 then odbc_subtype when 10 then 1111 else odbc_type end as data_type, column_size, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_prefix, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_suffix, creation_parameters as create_param, 1 as nullable, 1 as case_sensitive, 3 as searchable, 0 as unsigned_attribute, case odbc_type when 2 then 1 else 0 end as fixed_prec_scale, 0 as auto_unique, type_name as local_type_name, min_scale as minimum_scale, max_scale as maximum_scale, odbc_type as sql_data_type, odbc_subtype as sql_datetime_sub, 10 as num_prec_radix from v_catalog.types order by odbc_type, odbc_subtype) as vmd '
2014-10-09 21:30:41.205 Init Session:0x2aaab0001370 [Txn] <INFO> Commit Complete: Txn: a000000004f5ca at epoch 0x38af
2014-10-09 21:30:41.229 Init Session:0x2aaab0001370 [Session] <INFO> [PQuery] TX:0(vertica-31472:0x8a) SELECT u1.iinc_id FROM ((SELECT t0.iinc_id FROM VMart.public.internet_inc t0 INTERSECT SELECT (t1.iinc_id * count( *) + ?) AS iinc_id FROM VMart.public.internet_inc t1 GROUP BY t1.iinc_id) INTERSECT SELECT t2.iinc_id * count( *) * ? AS iinc_id FROM VMart.public.internet_inc t2 GROUP BY t2.iinc_id) u1
2014-10-09 21:30:41.229 Init Session:0x2aaab0001370-a000000004f5cc [Txn] <INFO> Begin Txn: a000000004f5cc 'SELECT u1.iinc_id FROM ((SELECT t0.iinc_id FROM VMart.public.internet_inc t0 INTERSECT SELECT (t1.iinc_id * count( *) + ?) AS iinc_id FROM VMart.public.internet_inc t1 GROUP BY t1.iinc_id) INTERSECT SELECT t2.iinc_id * count( *) * ? AS iinc_id FROM VMart.public.internet_inc t2 GROUP BY t2.iinc_id) u1'
2014-10-09 21:30:41.231 Init Session:0x2aaab0001370-a000000004f5cc <PANIC> @v_vmart_node0001: VX001/5422: VAssert(ltypmod != -1 && rtypmod != -1) failed
    LOCATION:  transformSetOperationTreeImpl, analyze.c:4498
2014-10-09 21:30:43.006 LowDiskSpaceCheck:0x7ffb6a0-a000000004f5cd [Txn] <INFO> Begin Txn: a000000004f5cd 'LowDiskSpaceCheck'
2014-10-09 21:30:43.008 LowDiskSpaceCheck:0x7ffb6a0-a000000004f5cd [Txn] <INFO> Rollback Txn: a000000004f5cd 'LowDiskSpaceCheck'
2014-10-09 21:30:43.009 LowDiskSpaceCheck:0x7ffb6a0 [Util] <INFO> Task 'LowDiskSpaceCheck' enabled
2014-10-09 21:30:43.835 Init Session:0x2aaab0001370-a000000004f5cc [Main] <PANIC> Wrote backtrace to ErrorReport.txt

Carlos_Santos

I get the same error using the vertica-jdbc-7.0.2-1.jar JDBC driver.
After switching to the new driver, I get the following in vertica.log:

  2014-10-09 21:30:41.118 Init Session:0x2aaab0001370  @v_vmart_node0001: 00000/2705: Connection received: host=192.168.1.166 port=62788 (connCnt 3)  2014-10-09 21:30:41.123 Init Session:0x2aaab0001370  @v_vmart_node0001: 00000/4686: sendAuthRequest: user=dbadmin database=VMart host=192.168.1.166 authType=0  2014-10-09 21:30:41.123 Init Session:0x2aaab0001370  @v_vmart_node0001: 00000/2703: Connection authenticated: user=dbadmin database=VMart host=192.168.1.166  2014-10-09 21:30:41.123 Init Session:0x2aaab0001370  @v_vmart_node0001: 00000/2609: Client pid: 13576  2014-10-09 21:30:41.123 Init Session:0x2aaab0001370  @v_vmart_node0001: 00000/2608: Client label: jdbc-06.01.0300-92e99d1d-1904-4175-9fe2-6750d8a9023f  2014-10-09 21:30:41.147 Init Session:0x2aaab0001370 [Session]  [PQuery] TX:0(vertica-31472:0x8a) select * from (select type_name as data_type_name, case odbc_type when 9 then odbc_subtype when 10 then 1111 else odbc_type end as data_type, column_size, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_prefix, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_suffix, creation_parameters as create_param, 1 as nullable, 1 as case_sensitive, 3 as searchable, 0 as unsigned_attribute, case odbc_type when 2 then 1 else 0 end as fixed_prec_scale, 0 as auto_unique, type_name as local_type_name, min_scale as minimum_scale, max_scale as maximum_scale, odbc_type as sql_data_type, odbc_subtype as sql_datetime_sub, 10 as num_prec_radix from v_catalog.types order by odbc_type, odbc_subtype) as vmd   2014-10-09 21:30:41.168 Init Session:0x2aaab0001370 [Session]  [Query] TX:0(vertica-31472:0x8a) select * from (select type_name as data_type_name, case odbc_type when 9 then odbc_subtype when 10 then 1111 else odbc_type end as data_type, column_size, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_prefix, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_suffix, creation_parameters as create_param, 1 as nullable, 1 as case_sensitive, 3 as searchable, 0 as unsigned_attribute, case odbc_type when 2 then 1 else 0 end as fixed_prec_scale, 0 as auto_unique, type_name as local_type_name, min_scale as minimum_scale, max_scale as maximum_scale, odbc_type as sql_data_type, odbc_subtype as sql_datetime_sub, 10 as num_prec_radix from v_catalog.types order by odbc_type, odbc_subtype) as vmd   2014-10-09 21:30:41.169 Init Session:0x2aaab0001370-a000000004f5ca [Txn]  Begin Txn: a000000004f5ca 'select * from (select type_name as data_type_name, case odbc_type when 9 then odbc_subtype when 10 then 1111 else odbc_type end as data_type, column_size, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_prefix, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_suffix, creation_parameters as create_param, 1 as nullable, 1 as case_sensitive, 3 as searchable, 0 as unsigned_attribute, case odbc_type when 2 then 1 else 0 end as fixed_prec_scale, 0 as auto_unique, type_name as local_type_name, min_scale as minimum_scale, max_scale as maximum_scale, odbc_type as sql_data_type, odbc_subtype as sql_datetime_sub, 10 as num_prec_radix from v_catalog.types order by odbc_type, odbc_subtype) as vmd '  2014-10-09 21:30:41.202 Init Session:0x2aaab0001370-a000000004f5ca [Session]  [PQuery] TX:a000000004f5ca(vertica-31472:0x8a) set session autocommit to on  2014-10-09 21:30:41.203 Init Session:0x2aaab0001370-a000000004f5ca [Session]  [Query] TX:a000000004f5ca(vertica-31472:0x8a) set session autocommit to on  2014-10-09 21:30:41.204 Init Session:0x2aaab0001370-a000000004f5ca [Txn]  Starting Commit: Txn: a000000004f5ca 'select * from (select type_name as data_type_name, case odbc_type when 9 then odbc_subtype when 10 then 1111 else odbc_type end as data_type, column_size, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_prefix, case when odbc_type in (-5, 2, 8) then null else E'\'' end as literal_suffix, creation_parameters as create_param, 1 as nullable, 1 as case_sensitive, 3 as searchable, 0 as unsigned_attribute, case odbc_type when 2 then 1 else 0 end as fixed_prec_scale, 0 as auto_unique, type_name as local_type_name, min_scale as minimum_scale, max_scale as maximum_scale, odbc_type as sql_data_type, odbc_subtype as sql_datetime_sub, 10 as num_prec_radix from v_catalog.types order by odbc_type, odbc_subtype) as vmd '  2014-10-09 21:30:41.205 Init Session:0x2aaab0001370 [Txn]  Commit Complete: Txn: a000000004f5ca at epoch 0x38af  2014-10-09 21:30:41.229 Init Session:0x2aaab0001370 [Session]  [PQuery] TX:0(vertica-31472:0x8a) SELECT u1.iinc_id FROM ((SELECT t0.iinc_id FROM VMart.public.internet_inc t0 INTERSECT SELECT (t1.iinc_id * count( *) + ?) AS iinc_id FROM VMart.public.internet_inc t1 GROUP BY t1.iinc_id) INTERSECT SELECT t2.iinc_id * count( *) * ? AS iinc_id FROM VMart.public.internet_inc t2 GROUP BY t2.iinc_id) u1  2014-10-09 21:30:41.229 Init Session:0x2aaab0001370-a000000004f5cc [Txn]  Begin Txn: a000000004f5cc 'SELECT u1.iinc_id FROM ((SELECT t0.iinc_id FROM VMart.public.internet_inc t0 INTERSECT SELECT (t1.iinc_id * count( *) + ?) AS iinc_id FROM VMart.public.internet_inc t1 GROUP BY t1.iinc_id) INTERSECT SELECT t2.iinc_id * count( *) * ? AS iinc_id FROM VMart.public.internet_inc t2 GROUP BY t2.iinc_id) u1'  2014-10-09 21:30:41.231 Init Session:0x2aaab0001370-a000000004f5cc  @v_vmart_node0001: VX001/5422: VAssert(ltypmod != -1 && rtypmod != -1) failed   LOCATION:  transformSetOperationTreeImpl, analyze.c:4498  2014-10-09 21:30:43.006 LowDiskSpaceCheck:0x7ffb6a0-a000000004f5cd [Txn]  Begin Txn: a000000004f5cd 'LowDiskSpaceCheck'  2014-10-09 21:30:43.008 LowDiskSpaceCheck:0x7ffb6a0-a000000004f5cd [Txn]  Rollback Txn: a000000004f5cd 'LowDiskSpaceCheck'  2014-10-09 21:30:43.009 LowDiskSpaceCheck:0x7ffb6a0 [Util]  Task 'LowDiskSpaceCheck' enabled  2014-10-09 21:30:43.835 Init Session:0x2aaab0001370-a000000004f5cc [Main]  Wrote backtrace to ErrorReport.txt  

Carlos_Santos

I get the same error using the vertica-jdbc-7.0.2-1.jar JDBC driver.
After switching to the new driver, I get the following in vertica.log:

2014-10-09 21:30:41.229 Init Session:0x2aaab0001370 [Session]  [PQuery] TX:0(vertica-31472:0x8a) SELECT u1.iinc_id FROM ((SELECT t0.iinc_id FROM VMart.public.internet_inc t0 INTERSECT SELECT (t1.iinc_id * count( *) + ?) AS iinc_id FROM VMart.public.internet_inc t1 GROUP BY t1.iinc_id) INTERSECT SELECT t2.iinc_id * count( *) * ? AS iinc_id FROM VMart.public.internet_inc t2 GROUP BY t2.iinc_id) u1 2014-10-09 21:30:41.229 Init Session:0x2aaab0001370-a000000004f5cc [Txn]  Begin Txn: a000000004f5cc 'SELECT u1.iinc_id FROM ((SELECT t0.iinc_id FROM VMart.public.internet_inc t0 INTERSECT SELECT (t1.iinc_id * count( *) + ?) AS iinc_id FROM VMart.public.internet_inc t1 GROUP BY t1.iinc_id) INTERSECT SELECT t2.iinc_id * count( *) * ? AS iinc_id FROM VMart.public.internet_inc t2 GROUP BY t2.iinc_id) u1' 2014-10-09 21:30:41.231 Init Session:0x2aaab0001370-a000000004f5cc  @v_vmart_node0001: VX001/5422: VAssert(ltypmod != -1 && rtypmod != -1) failed  LOCATION:  transformSetOperationTreeImpl, analyze.c:4498 2014-10-09 21:30:43.006 LowDiskSpaceCheck:0x7ffb6a0-a000000004f5cd [Txn]  Begin Txn: a000000004f5cd 'LowDiskSpaceCheck' 2014-10-09 21:30:43.008 LowDiskSpaceCheck:0x7ffb6a0-a000000004f5cd [Txn]  Rollback Txn: a000000004f5cd 'LowDiskSpaceCheck' 2014-10-09 21:30:43.009 LowDiskSpaceCheck:0x7ffb6a0 [Util]  Task 'LowDiskSpaceCheck' enabled 2014-10-09 21:30:43.835 Init Session:0x2aaab0001370-a000000004f5cc [Main]  Wrote backtrace to ErrorReport.txt

And the database still dies. I would attach the ErrorReport.txt file, but I cannot find the option to attach files and it is too big to paste it here. I can send the file by email.

wwong2

Hi Carlos - is this happening only in JDBC as PreparedStatement?  What if you ran same query via vsql?  Same results? 
Can you also post what is shown in the ErrorReport.txt specifically at the end, Backtrace
Regards

wwong2

Disregard last update.  Issue is being investigated.  In the meantime, a suggestion, try casting the question mark to see if it helps

Carlos_Santos

This is the schema of the view that I used in my query:

  create table internet_inc (      iinc_id         number(16) not null,      summary         varchar2(500),      ttime           timestamp,      taxId           varchar2(15),      specific_field1 varchar2(100),      specific_field2 varchar2(100)  );  

Carlos_Santos

This is the content of the ErrorReport.txt file

BEGIN BACKTRACE Vertica Backtrace at Fri Oct 10 17:45:30 2014 ------------------------- Vertica Analytic Database v7.0.1-0 $BrandId$ vertica(v7.0.1-0) built by release@build2.verticacorp.com from releases/VER_7_0_RELEASE_BUILD_1_0_20140212@130255 on 'Wed Feb 12 19:00:56 America/New_York 2014' $BuildId$ 00400000-0498a000 r-xp 00000000 08:03 7471387                            /opt/vertica/bin/vertica 04b89000-04e15000 rw-p 04589000 08:03 7471387                            /opt/vertica/bin/vertica 04e15000-04f25000 rw-p 04e15000 00:00 0  10142000-10570000 rw-p 10142000 00:00 0                                  [heap] 2ae287599000-2ae2875b5000 r-xp 00000000 08:03 8781828                    /lib64/ld-2.5.so 2ae2875b5000-2ae2875ca000 rw-p 2ae2875b5000 00:00 0  2ae2875cb000-2ae2875d8000 rw-p 2ae2875cb000 00:00 0  2ae2877b4000-2ae2877b5000 r--p 0001b000 08:03 8781828                    /lib64/ld-2.5.so 2ae2877b5000-2ae2877b6000 rw-p 0001c000 08:03 8781828                    /lib64/ld-2.5.so 2ae2877b6000-2ae287804000 r-xp 00000000 08:03 859643                     /usr/lib64/libncurses.so.5.5 2ae287804000-2ae287a04000 ---p 0004e000 08:03 859643                     /usr/lib64/libncurses.so.5.5 2ae287a04000-2ae287a12000 rw-p 0004e000 08:03 859643                     /usr/lib64/libncurses.so.5.5 2ae287a12000-2ae287a13000 rw-p 2ae287a12000 00:00 0  2ae287a13000-2ae287a1a000 r-xp 00000000 08:03 8781863                    /lib64/librt-2.5.so 2ae287a1a000-2ae287c1a000 ---p 00007000 08:03 8781863                    /lib64/librt-2.5.so 2ae287c1a000-2ae287c1b000 r--p 00007000 08:03 8781863                    /lib64/librt-2.5.so 2ae287c1b000-2ae287c1c000 rw-p 00008000 08:03 8781863                    /lib64/librt-2.5.so 2ae287c1c000-2ae287d6a000 r-xp 00000000 08:03 8781835                    /lib64/libc-2.5.so 2ae287d6a000-2ae287f69000 ---p 0014e000 08:03 8781835                    /lib64/libc-2.5.so 2ae287f69000-2ae287f6d000 r--p 0014d000 08:03 8781835                    /lib64/libc-2.5.so 2ae287f6d000-2ae287f6e000 rw-p 00151000 08:03 8781835                    /lib64/libc-2.5.so 2ae287f6e000-2ae287f74000 rw-p 2ae287f6e000 00:00 0  2ae287f74000-2ae287f76000 r-xp 00000000 08:03 8781841                    /lib64/libdl-2.5.so 2ae287f76000-2ae288176000 ---p 00002000 08:03 8781841                    /lib64/libdl-2.5.so 2ae288176000-2ae288177000 r--p 00002000 08:03 8781841                    /lib64/libdl-2.5.so 2ae288177000-2ae288178000 rw-p 00003000 08:03 8781841                    /lib64/libdl-2.5.so 2ae288178000-2ae28818e000 r-xp 00000000 08:03 8781859                    /lib64/libpthread-2.5.so 2ae28818e000-2ae28838d000 ---p 00016000 08:03 8781859                    /lib64/libpthread-2.5.so 2ae28838d000-2ae28838e000 r--p 00015000 08:03 8781859                    /lib64/libpthread-2.5.so 2ae28838e000-2ae28838f000 rw-p 00016000 08:03 8781859                    /lib64/libpthread-2.5.so 2ae28838f000-2ae288393000 rw-p 2ae28838f000 00:00 0  2ae288393000-2ae2883a0000 r-xp 00000000 08:03 8781826                    /lib64/libgcc_s-4.1.2-20080825.so.1 2ae2883a0000-2ae2885a0000 ---p 0000d000 08:03 8781826                    /lib64/libgcc_s-4.1.2-20080825.so.1 2ae2885a0000-2ae2885a1000 rw-p 0000d000 08:03 8781826                    /lib64/libgcc_s-4.1.2-20080825.so.1 2ae2885a1000-2ae2885a3000 rw-p 2ae2885a1000 00:00 0  2ae2885a3000-2ae2885ad000 r-xp 00000000 08:03 8781851                    /lib64/libnss_files-2.5.so 2ae2885ad000-2ae2887ac000 ---p 0000a000 08:03 8781851                    /lib64/libnss_files-2.5.so 2ae2887ac000-2ae2887ad000 r--p 00009000 08:03 8781851                    /lib64/libnss_files-2.5.so 2ae2887ad000-2ae2887ae000 rw-p 0000a000 08:03 8781851                    /lib64/libnss_files-2.5.so 2ae2887ae000-2ae288bae000 rw-p 2ae2887ae000 00:00 0  2ae288bae000-2ae298d0e000 rw-p 2ae288bae000 00:00 0  2ae298d0e000-2ae299c53000 r--s 00000000 08:03 7603582                    /opt/vertica/share/icu/icudt42l.dat 2ae299c53000-2ae29d22f000 r--p 00000000 08:03 855922                     /usr/lib/locale/locale-archive 7fff75f9f000-7fff75fb7000 rw-p 7ffffffe7000 00:00 0                      [stack] ffffffffff600000-ffffffffffe00000 ---p 00000000 00:00 0                  [vdso]  Backtrace Requested /opt/vertica/bin/vertica(_ZN6Basics9Backtrace11DoBacktraceEiiPvS1_+0x8cc)[0x33a011e] /opt/vertica/bin/vertica(_ZN6Basics20GlobalSignalHandlers20logBacktraceFromHereEb+0xb7)[0x341e90b] /opt/vertica/bin/vertica(errthrow+0x5a)[0x2d0d226] /opt/vertica/bin/vertica[0x3516110] /opt/vertica/bin/vertica[0x102dedf] /opt/vertica/bin/vertica[0x102d8fe] /opt/vertica/bin/vertica[0x102e13e] /opt/vertica/bin/vertica[0x102f31a] /opt/vertica/bin/vertica[0x103280d] /opt/vertica/bin/vertica(parse_sub_analyze+0x2d)[0x1032927] /opt/vertica/bin/vertica[0x1036eec] /opt/vertica/bin/vertica(transformFromClause+0x33)[0x1037eda] /opt/vertica/bin/vertica[0x102ca26] /opt/vertica/bin/vertica[0x102f03c] /opt/vertica/bin/vertica[0x103280d] /opt/vertica/bin/vertica(parse_analyze_varparams+0x5a)[0x103299a] /opt/vertica/bin/vertica(_ZN7Session13ClientSession18exec_parse_messageEPKcS2_NS_13ProtocolStateEb+0x348)[0x32a23bc] /opt/vertica/bin/vertica(_ZN7Session13ClientSession31exec_describe_statement_messageEPKc+0xb2f)[0x32ac635] /opt/vertica/bin/vertica(_ZN7Session13ClientSession8describeEv+0x3fb)[0x32ad67d] /opt/vertica/bin/vertica(_ZN7Session13ClientSession10runSessionEv+0x7bc)[0x32b42b6] /opt/vertica/bin/vertica(_Z10SessionRunP4Port+0x20a)[0x324a68e] /opt/vertica/bin/vertica(_ZNK5boost9function0IvEclEv+0x1bb)[0x135f28b] /opt/vertica/bin/vertica(_ZN7Session13ThreadManager12launchThreadERKN5boost9function0IvEE+0x57)[0x327229f] /opt/vertica/bin/vertica(thread_proxy+0x80)[0x3a179c0] /lib64/libpthread.so.0[0x2ae28817e73d] /lib64/libc.so.6(clone+0x6d)[0x2ae287cefd1d] END BACKTRACE THREAD CONTEXT Thread type: Initiator Session Thread Request: SELECT u1.iinc_id FROM ((SELECT t0.iinc_id FROM VMart.public.internet_inc t0 INTERSECT SELECT (t1.iinc_id * count( *) + ?) AS iinc_id FROM VMart.public.internet_inc t1 GROUP BY t1.iinc_id) INTERSECT SELECT t2.iinc_id * count( *) * ? AS iinc_id FROM VMart.public.internet_inc t2 GROUP BY t2.iinc_id) u1 Transaction: [0x00a000000004f622] END THREAD CONTEXT