Greenplum - Related information

  • Greenplum failed to start, cdbtm.c:1529

    problem description failure at startup after greenplum installation is completed prompt: DTM initialization: failure during startup recovery, retry failed, check segment status (cdbtm.c:1529) the platform version of the problem and what methods you...

    May.10,2022
  • Greenplum character type

    recently, the problems encountered in learning greenplum, before testing are as follows: 1.character varying(80):value too long for type character varying(80); 2.gpfdist; 3.delimiter.so; I don t know how to solve the first problem first ...

    Mar.10,2021
  • Greenplumn failed to build index: No space left on device

    when you look at the error prompt, it feels like there is not enough space, but it is not. 5 machines each have 20T disks, each with 8T left. But every time the index is created for about a day or so, an error will be reported. error log is as follows...

    Mar.04,2021
  • Unreasonable problem: the performance of a simple statement of greenplum is much lower than that of postgresql?.

    GreenPlum environment: 1 master host (memory: 16G), 2 segment host (2 segments, memory: 16G), version: 5.3.0 postgresql environment: 1 (hardware configuration with GreenPlum), version: 8.3.23 Table: alert_log_sm_http is the same size as gp in pg, wit...

    Mar.02,2021
  • MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
    MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e5f47a-44550.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
    MySQL Errno : 1021
    Message : Disk full (/tmp/#sql-temptable-64f5-1e5f47a-44550.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
    Need Help?