From: muayad y <mua...@ya...> - 2015-09-11 00:15:25
|
Add/delete node works fine when table has ~ 9million rows, but segfault in heap_update when table gets bigger, any idea help ? thanks in advance Core was generated by `postgres: pgxl test [local] ALTER TABLE '. Program terminated with signal 11, Segmentation fault. #0 0x00000000004949f0 in heap_update () (gdb) bt #0 0x00000000004949f0 in heap_update () #1 0x0000000000495f12 in simple_heap_update () #2 0x00000000004fd3c0 in PgxcClassAlter () #3 0x00000000005763c8 in ATExecCmd () #4 0x0000000000578d56 in ATController () #5 0x000000000068ab1d in ProcessUtilitySlow.isra.8 () #6 0x0000000000688dc8 in standard_ProcessUtility () #7 0x0000000000685a07 in PortalRunUtility () #8 0x000000000068668d in PortalRunMulti () #9 0x0000000000687272 in PortalRun () #10 0x0000000000684970 in PostgresMain () #11 0x000000000046d1f9 in ServerLoop () #12 0x00000000006429d6 in PostmasterMain () #13 0x000000000046da8d in main () (gdb) table info: CREATE TABLE sbtest (id int NOT NULL, k int NOT NULL DEFAULT '0', c char(120) NOT NULL DEFAULT '', pad char(60) NOT NULL DEFAULT '', PRIMARY KEY (id)) DISTRIBUTE BY hash(id); user limits: core file size (blocks, -c) unlimited data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 3101645 max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files (-n) 131072 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) unlimited cpu time (seconds, -t) unlimited max user processes (-u) 3101645 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited Thanks MU |