Pivotal Knowledge Base

Follow

gpbackup Error "slice bound out of range"

Environment

Pivotal Greenplum Database (GPDB) 4.3.17.x and above 

Symptom

gpbackup for the metadata is failing with the following error:

class="code-java">[gpadmin@gpdb tmp]$ gpbackup -dbname dbtest -metadata-only
20180112:10:32:17 gpbackup:gpadmin:gpdb:010452-[INFO]:-Starting backup of database dbtest
20180112:10:32:17 gpbackup:gpadmin:gpdb:010452-[INFO]:-Backup Timestamp = 20180112103217
20180112:10:32:17 gpbackup:gpadmin:gpdb:010452-[INFO]:-Backup Database = dbtest
20180112:10:32:17 gpbackup:gpadmin:gpdb:010452-[INFO]:-Backup Type = Unfiltered Compressed Full Metadata-Only Backup
20180112:10:32:18 gpbackup:gpadmin:gpdb:010452-[INFO]:-Acquiring ACCESS SHARE locks on tables
Locks acquired:  32431 / 32431 [=======================================================] 100.00% 14s
20180112:10:32:32 gpbackup:gpadmin:gpdb:010452-[INFO]:-Gathering table metadata
20180112:10:32:46 gpbackup:gpadmin:gpdb:010452-[INFO]:-Writing global database metadata to /data/master/gp_4.3.19.0_20171227113245-1/backups/20180112/20180112103217/gpbackup_20180112103217_global.sql
20180112:10:32:46 gpbackup:gpadmin:gpdb:010452-[INFO]:-Global database metadata backup complete
20180112:10:32:46 gpbackup:gpadmin:gpdb:010452-[INFO]:-Writing pre-data metadata to /data/master/gp_4.3.19.0_20171227113245-1/backups/20180112/20180112103217/gpbackup_20180112103217_predata.sql
runtime error: slice bounds out of range
20180112:10:33:19 gpbackup:gpadmin:gpdb:010452-[WARNING]:-Found neither /usr/local/greenplum-db-4.3.19.0/bin/mail_contacts nor /home/gpadmin/mail_contacts
20180112:10:33:19 gpbackup:gpadmin:gpdb:010452-[WARNING]:-Unable to send backup email notification

Cause 

This issue is caused by the external tables that run operating system commands, such as: 

class="code-java">dbtest=# \d ext.external_table_test
External table "ext.external_table_test"
  Column  | Type | Modifiers
----------+------+-----------
 filename | text |
Type: readable
Encoding: UTF8
Format type: text
Format options: delimiter ' ' null '\N' escape '\'
Command: ls -1
Execute on: 1 random segments

Resolution

This issue has been fixed and it will be included in the future release of GPDB 4.3.22.0. Check the issue number, 29192 to check for GPDB 4.3.21.0 in the release notes.

Comments

Powered by Zendesk