Jimmy Jiang
- Total activity 50
- Last activity
- Member since
- Following 0 users
- Followed by 1 user
- Votes 16
- Subscriptions 20
Activity overview
Latest activity by Jimmy Jiang-
Jimmy Jiang created an article,
Dropping a User-Defined Function when the Function Argument Types can not be Remembered
Environment Pivotal Greenplum all versions Purpose Unlike other relational databases, dropping of user-defined functions in Postgresql/Greenplum needs the argument type of the function for the DRO...
-
Jimmy Jiang created an article,
Greenplum Error: "libjvm.so: cannot open shared object file: No such file or directory" when installing pl/java language extension
Environment Pivotal Greenplum Database (GPDB) 4.3.x Symptom When we attempt to enable pl/java for a database, it returns the following error: psql -d adw -f $GPHOME/share/postgresql/pljava/install...
-
Jimmy Jiang created an article,
GPSTART Error "Failed Segment starts, from Mirroring Connection between Primary and Mirror"
Environment Pivotal Greenplum Database (GPDB) 4.3.x Operating System- All supported Symptom Sometimes, when we start the database, it will fail returning a double fault error: "No segment st...
-
Jimmy Jiang created an article,
Greenplum Error "No Equality Operator for Typid 705(cdbmutate.c:1187)"
Environment Pivotal Greenplum Database (GPDB) 4.3.x Operating System ()OS- All supported OS Symptom Sometimes, when we create a table, we see the following error: testDB=# create table test_error...
-
Jimmy Jiang created an article,
Greenplum Error "RelfileNode XXX Already in Use in pg_class"
Environment Pivotal Greenplum Database (GPDB) 4.3.x Operating System- All supported Symptom Sometimes, when we create or truncate a table, the action can fail because the Relfilenode generated ha...
-
Jimmy Jiang created an article,
Greenplum Error "Failed to Create Array for Composite Type"
Environment Pivotal Greenplum Database (GPDB) 4.3.x Operating System- All supported Symptom When creating a table with an array, the command would fail and generate the following error: testDB=# ...
-
Jimmy Jiang created an article,
gp_restore/gpdbrestore Error "Protocal ""gpfdist" does not exist."
Environment Pivotal Greenplum Database (GPDB) 4.3.x Operating System- All supported Symptom While creating an external table using the statement below, restore fails due to extra space in LOCATI...
-
Jimmy Jiang created an article,
GPEXPANSION Error "Missing Data for Column 'Rank'"
Environment Pivotal Greenplum Database (GPDB) 4.3.x Operating System- All supported Symptom Sometimes GPEXPANSION will fail giving an error like "missing data for column 'rank'". The ...
-
Jimmy Jiang created an article,
Connection to gpfdist Server Fails with Connection Refused Error
Environment Pivotal Greenplum Database (GPDB) 4.3.x Operating System- All supported Symptom Sometimes, when executing a query against an external table, gpfdist will fail with connection refused...
-
Jimmy Jiang created an article,
Configuration Reloading (gpstop -u) is hung with message "gpadmin@sdwX's password"
Environment Pivotal Greenplum Database (GPDB) 4.3.x Operating System- All supported Symptom "gpstop -u" becomes hung and never finishes with below messages. Warning Message: gpadmin@sd...