Exception in simple insert

Question

select col1 from mytab1 where col1=12402196;

col1

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

12402196

insert into mytab2 select * from mytab1 where col1=12402196;

INSERT 0 0

mytab1 and mytab2 have same data structures (columns and data types) and mytab1 have the data (you can see in the above select query) but data is not being loaded in mytab2 without giving error but the following exception caught in /pg_log/*.csv

2018-12-06 20:02:17.542026 PKT,,,p7605,th-231192800,,,,0,,,seg-1,,,,,"LOG","00000","3rd party error log:

Unexpected exception reached top of execution stack: major=200 minor=",,,,,,,,"SysLoggerMain","syslogger.c",618,

Please guide me to resolve this error.

Answer

Hi Muhammad,

These exceptions can be ignored and can happen when catalog queries are executed on ORCA enabled clusters. By default planner is used for catalog queries . Refer below link for more information :

http://gpdb.docs.pivotal.io/latest/ref_guide/config_params/guc-list.html#optimizer_enable_master_only_queries

VMware Tanzu Greenplum

Exception in simple insert