adnanhamdussalam commented on issue #1708:
URL: https://github.com/apache/cloudberry/issues/1708#issuecomment-4387131516
# on the segment host where the PANIC happened
grep -A 25 'received signal SIGSEGV'
/data/cbdtabase/primary/gpseg*/log/*.csv | head -120
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv:2026-04-28
17:07:00.877342 CEST,,,p2884481,th123456,,,2026-04-28 17:06:56
CEST,0,con17033,cmd18,seg0,slice2,,,,"PANIC","XX000","Unexpected internal
error: Segment process received signal SIGSEGV",,,,,,,0,,,,"1 0xd704a5
postgres StandardHandlerForSigillSigsegvSigbus_OnMainThread + 0x155
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-2
0x7fe368e3fc30 libc.so.6 <symbol not found> + 0x68e3fc30
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-3 0xa090c2
postgres <symbol not found> + 0xa090c2
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-4 0xa0b14e
postgres slot_getsomeattrs_int + 0x1e
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-5 0x9f9139
postgres <symbol not found> + 0x9f9139
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-6 0xa371d7
postgres <symbol not found> + 0xa371d7
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-7 0xa0584d
postgres <symbol not found> + 0xa0584d
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-8 0xa4b25a
postgres <symbol not found> + 0xa4b25a
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-9 0xa0584d
postgres <symbol not found> + 0xa0584d
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-10 0x9fc32a
postgres <symbol not found> + 0x9fc32a
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-11 0x9fd001
postgres standard_ExecutorRun + 0x751
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-12 0x9fd1a5
postgres ExecutorRun + 0xc5
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-13 0xc1b571
postgres <symbol not found> + 0xc1b571
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-14 0xc1c541
postgres <symbol not found> + 0xc1c541
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-15 0xc1ca03
postgres PortalRun + 0x2a3
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-16 0xc16c62
postgres <symbol not found> + 0xc16c62
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-17 0xc1a648
postgres PostgresMain + 0x2358
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-18 0xb78390
postgres <symbol not found> + 0xb78390
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-19 0xb7939c
postgres PostmasterMain + 0xe0c
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-20 0x7c45eb
postgres main + 0x56b
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-21
0x7fe368e2a610 libc.so.6 <symbol not found> + 0x68e2a610
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-22
0x7fe368e2a6c0 libc.so.6 __libc_start_main + 0x80
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-23 0x7d5075
postgres _start + 0x25
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-"
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-2026-04-28
17:07:00.877444
CEST,,,p2081152,th1761700032,,,,0,,,seg0,,,,,"LOG","00000","server process (PID
2884481) was terminated by signal 11: Segmentation fault","Failed process was
running: /* {""app"": ""dbt"", ""dbt_version"": ""1.7.17"", ""profile_name"":
""airo-dev-profile"", ""target_name"": ""dev"", ""node_id"":
""model.airodbt.aca""} */
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-
--
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv:2026-04-28
18:10:33.684545 CEST,,,p2933859,th123456,,,2026-04-28 18:10:30
CEST,0,con17611,cmd18,seg0,slice2,,,,"PANIC","XX000","Unexpected internal
error: Segment process received signal SIGSEGV",,,,,,,0,,,,"1 0xd704a5
postgres StandardHandlerForSigillSigsegvSigbus_OnMainThread + 0x155
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-2
0x7fe368e3fc30 libc.so.6 <symbol not found> + 0x68e3fc30
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-3 0xa090c2
postgres <symbol not found> + 0xa090c2
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-4 0xa0b14e
postgres slot_getsomeattrs_int + 0x1e
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-5 0x9f9139
postgres <symbol not found> + 0x9f9139
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-6 0xa371d7
postgres <symbol not found> + 0xa371d7
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-7 0xa0584d
postgres <symbol not found> + 0xa0584d
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-8 0xa4b25a
postgres <symbol not found> + 0xa4b25a
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-9 0xa0584d
postgres <symbol not found> + 0xa0584d
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-10 0x9fc32a
postgres <symbol not found> + 0x9fc32a
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-11 0x9fd001
postgres standard_ExecutorRun + 0x751
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-12 0x9fd1a5
postgres ExecutorRun + 0xc5
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-13 0xc1b571
postgres <symbol not found> + 0xc1b571
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-14 0xc1c541
postgres <symbol not found> + 0xc1c541
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-15 0xc1ca03
postgres PortalRun + 0x2a3
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-16 0xc16c62
postgres <symbol not found> + 0xc16c62
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-17 0xc1a648
postgres PostgresMain + 0x2358
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-18 0xb78390
postgres <symbol not found> + 0xb78390
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-19 0xb7939c
postgres PostmasterMain + 0xe0c
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-20 0x7c45eb
postgres main + 0x56b
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-21
0x7fe368e2a610 libc.so.6 <symbol not found> + 0x68e2a610
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-22
0x7fe368e2a6c0 libc.so.6 __libc_start_main + 0x80
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-23 0x7d5075
postgres _start + 0x25
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-"
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-2026-04-28
18:10:33.685773
CEST,,,p2081152,th1761700032,,,,0,,,seg0,,,,,"LOG","00000","server process (PID
2933859) was terminated by signal 11: Segmentation fault","Failed process was
running: /* {""app"": ""dbt"", ""dbt_version"": ""1.7.17"", ""profile_name"":
""airo-dev-profile"", ""target_name"": ""dev"", ""node_id"":
""model.airodbt.aca""} */
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-28_000000.csv-
--
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv:2026-04-29
12:06:49.057129 CEST,,,p3775798,th123456,,,2026-04-29 12:06:45
CEST,0,con35066,cmd18,seg0,slice2,,,,"PANIC","XX000","Unexpected internal
error: Segment process received signal SIGSEGV",,,,,,,0,,,,"1 0xd704a5
postgres StandardHandlerForSigillSigsegvSigbus_OnMainThread + 0x155
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-2
0x7fe368e3fc30 libc.so.6 <symbol not found> + 0x68e3fc30
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-3 0xa090c2
postgres <symbol not found> + 0xa090c2
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-4 0xa0b14e
postgres slot_getsomeattrs_int + 0x1e
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-5 0x9f9139
postgres <symbol not found> + 0x9f9139
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-6 0xa371d7
postgres <symbol not found> + 0xa371d7
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-7 0xa0584d
postgres <symbol not found> + 0xa0584d
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-8 0xa4b25a
postgres <symbol not found> + 0xa4b25a
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-9 0xa0584d
postgres <symbol not found> + 0xa0584d
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-10 0x9fc32a
postgres <symbol not found> + 0x9fc32a
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-11 0x9fd001
postgres standard_ExecutorRun + 0x751
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-12 0x9fd1a5
postgres ExecutorRun + 0xc5
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-13 0xc1b571
postgres <symbol not found> + 0xc1b571
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-14 0xc1c541
postgres <symbol not found> + 0xc1c541
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-15 0xc1ca03
postgres PortalRun + 0x2a3
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-16 0xc16c62
postgres <symbol not found> + 0xc16c62
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-17 0xc1a648
postgres PostgresMain + 0x2358
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-18 0xb78390
postgres <symbol not found> + 0xb78390
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-19 0xb7939c
postgres PostmasterMain + 0xe0c
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-20 0x7c45eb
postgres main + 0x56b
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-21
0x7fe368e2a610 libc.so.6 <symbol not found> + 0x68e2a610
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-22
0x7fe368e2a6c0 libc.so.6 __libc_start_main + 0x80
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-23 0x7d5075
postgres _start + 0x25
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-"
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-2026-04-29
12:06:49.057295
CEST,,,p2081152,th1761700032,,,,0,,,seg0,,,,,"LOG","00000","server process (PID
3775798) was terminated by signal 11: Segmentation fault","Failed process was
running: /* {""app"": ""dbt"", ""dbt_version"": ""1.7.17"", ""profile_name"":
""airo-dev-profile"", ""target_name"": ""dev"", ""node_id"":
""model.airodbt.aca""} */
/data/cbdatabase/primary/gpseg0/log/gpdb-2026-04-29_000000.csv-
2- Can you share the command to enable core dumps?
3- will try with set optimizer off and will update you.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
