GP - Error related to pg_aocsseg

Error:
gp_relation_node(x) has more entries than pg_aocsseg(1) for relation tblname (aocssegfiles.c:1917) (seg# slice# xx.xx.xx.xx:port# pid=#) (cdbdisp.c:254)

 Identify table which is affected
Try to run select count(*) on the same, this is done to see if it errors.
This is consider to be a catalog issue. - For which we are in need to get in touch with Pivotal

 Log collection:
  1. Master/Segment logs
  2. metadata of affected table
  3. Transaction logs
  4. Invisible row count of table from affected segment(s)
  5. Collect gp_transaction_log and gp_distributed_log from both master and affected segment(s)
  6. Run offline gpcheckcat on affected database
  7. With all above said logs raise a case with Pivotal
Work around to fix:
  1. Rename affected table, Create a new table and load data.
  2. Truncate and Reload affect table - This is a quick fix if you can't wait for Pivotal intervention

Comments

Post a Comment

Popular posts from this blog

How to set Optimizer at database level in greenplum

How can I turn ON optimizer at Database level? You can set the optimier ON at database level using below command; ALTER DATABASE databasename SET OPTIMIZER = ON; Once this is done, kindly do reconnect to Database to see the change. How do I check if optimizer is set (ON/OFF) in a given database? You can use the show command as below to check psql -d databasename -c 'show optimizer'
Read more

Changing the gpmon Password

Greenplum Command Center manages the gpperfmon database using the gpmon database role. To change the gpmon password, follow these steps: 1. Log in to Greenplum Database as a superuser and change the gpmon password with the ALTER ROLE command: # ALTER ROLE gpmon WITH PASSWORD 'new_password'; 2. Update the password in the .pgpass file, which is used by Greenplum Command Center. The default location for this file is the gpadmin home directory (~/.pgpass). The .pgpass file contains a line with the gpmon password. Replace the existing password with the new password. *:5432:gpperfmon:gpmon:new_password The file should be owned by gpadmin and RW-accessible by gpadmin only. 3. Restart Greenplum Command Center with the gpcmdr utility. $ gpcmdr --restart
Read more

IPMI Tool | IPMI Cheatsheet

To have a better understanding about IPMI Explanation: The Intelligent Platform Management Interface (IPMI) is a standardized computer system interface used by System Administrators for out-of-band management of computer systems and monitoring of their operation. Out-of-band is also referred to the LOM (Lights-Out Management) involves the use of a dedicated management channel for device maintenance. A numbers of options are available to manage the device remotely. There are vendor-specific server management technologies available. HP’s Integrated Lights-out or iLO, Dell’s Dell Remote Access Controller or DRAC and IBM’s Remote Supervisor Adapter (RSA) are a few to list. The above listed modules are vendor specific and proprietary. IPMI whereas is vendor-neutral and cross-platform. It is available on Linux distros. The functionality of IPMI can be accessed via IPMItool. IPMItool is a command prompt, which is used to manage IPMI-enabled devices. IPMItool helps in managing the
Read more