cleverxiao001 commented on issue #1251: URL: https://github.com/apache/cloudberry/issues/1251#issuecomment-3116390262
error log in seg7: 2025-07-25 00:53:59.841934 EDT,"gpadmin","postgres",p268864,th1103079616,"168.160.18.164","59040",2025-07-25 00:53:59 EDT,0,con3,,seg7,,,,sx1,"LOG","00000","statement: select gid from pg_prepared_xacts where prepared < now() - interval'120 seconds'",,,,,,,0,,"postgres.c",1713, 2025-07-25 00:54:11.632398 EDT,,,p268891,th1103079616,"168.160.18.164","23646",2025-07-25 00:54:11 EDT,0,,,seg7,,,,,"LOG","00000","query finish request to process 268743",,,,,,,0,,"postmaster.c",2932, 2025-07-25 00:54:12.491000 EDT,,,p268743,th123456,,,2025-07-25 00:52:58 EDT,0,con3202,cmd2,seg7,slice1,,,,"PANIC","XX000","Unexpected internal error: Segment process received signal SIGSEGV",,,,,,,0,,,,"1 0x7fc543ffa92c libpostgres.so gp_backtrace + 0x3c 2 0x7fc543ffabd3 libpostgres.so StandardHandlerForSigillSigsegvSigbus_OnMainThread + 0x153 3 0x7fc54303ebf0 libc.so.6 <symbol not found> + 0x4303ebf0 4 0x7fc543ffe090 libpostgres.so pg_detoast_datum_packed + 0x0 5 0x7fc543fa7636 libpostgres.so <symbol not found> + 0x43fa7636 6 0x7fc54405aa69 libpostgres.so <symbol not found> + 0x4405aa69 7 0x7fc54405ae8b libpostgres.so <symbol not found> + 0x4405ae8b 8 0x7fc54405f86e libpostgres.so tuplesort_performsort + 0x5e 9 0x7fc543c4e9c1 libpostgres.so <symbol not found> + 0x43c4e9c1 10 0x7fc543c50e66 libpostgres.so <symbol not found> + 0x43c50e66 11 0x7fc543c3e8cd libpostgres.so <symbol not found> + 0x43c3e8cd 12 0x7fc543c8e3c2 libpostgres.so <symbol not found> + 0x43c8e3c2 13 0x7fc543c3eb0d libpostgres.so <symbol not found> + 0x43c3eb0d 14 0x7fc543c343da libpostgres.so <symbol not found> + 0x43c343da 15 0x7fc543c351a1 libpostgres.so standard_ExecutorRun + 0x811 16 0x7fc543c353a5 libpostgres.so ExecutorRun + 0xc5 17 0x7fc543e908df libpostgres.so <symbol not found> + 0x43e908df 18 0x7fc543e926af libpostgres.so PortalRun + 0x1af 19 0x7fc543e8c427 libpostgres.so <symbol not found> + 0x43e8c427 20 0x7fc543e8fdc4 libpostgres.so PostgresMain + 0x20e4 21 0x7fc543dd5b62 libpostgres.so <symbol not found> + 0x43dd5b62 22 0x7fc543dd6c41 libpostgres.so PostmasterMain + 0xe61 23 0x4027eb postgres main (main.c:200) 24 0x7fc5430295d0 libc.so.6 <symbol not found> + 0x430295d0 25 0x7fc543029680 libc.so.6 __libc_start_main + 0x80 26 0x402985 postgres _start + 0x25 " 2025-07-25 00:54:13.510607 EDT,,,p4005057,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","server process (PID 268743) was terminated by signal 11: Segmentation fault","Failed process was running: select country, ref_year, count() as ref_frequency, count(distinct ref_uid) as ref_quantity from reference_info group by country, ref_year",,,,,,0,,"postmaster.c",4280, 2025-07-25 00:54:13.510647 EDT,,,p4005057,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","terminating any other active server processes",,,,,,,0,,"postmaster.c",3995, 2025-07-25 00:54:13.510746 EDT,,,p268442,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","ic-proxy: received signal 3",,,,,,,0,,"ic_proxy_main.c",484, 2025-07-25 00:54:13.510756 EDT,,,p268442,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","ic-proxy: server closing",,,,,,,0,,"ic_proxy_main.c",585, 2025-07-25 00:54:13.510779 EDT,,,p268442,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","ic-proxy: server closed with code 1",,,,,,,0,,"ic_proxy_main.c",599, 2025-07-25 00:54:13.513116 EDT,,,p4005057,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","background worker ""ic proxy process"" (PID 268442) exited with exit code 1",,,,,,,0,,"postmaster.c",4259, 2025-07-25 00:54:13.513301 EDT,,,p4005057,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","all server processes terminated; reinitializing",,,,,,,0,,"postmaster.c",4571, 2025-07-25 00:54:13.589507 EDT,,,p268902,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","database system was interrupted; last known up at 2025-07-25 00:51:50 EDT",,,,,,,0,,"xlog.c",6822, 2025-07-25 00:54:13.589534 EDT,,,p268902,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","Synchronization of the wal directory starts.",,,,,,,0,,"fd.c",3452, 2025-07-25 00:54:13.589586 EDT,,,p268902,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","synchronization of the wal directory finishes.",,,,,,,0,,"fd.c",3454, 2025-07-25 00:54:13.589883 EDT,,,p268902,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","database system was not properly shut down; automatic recovery in progress",,,,,,,0,,"xlog.c",7391, 2025-07-25 00:54:13.592357 EDT,,,p268902,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","redo starts at 5/3B21C628",,,,,,,0,,"xlog.c",7671, 2025-07-25 00:54:13.592373 EDT,,,p268902,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","invalid record length at 5/3B21C660: wanted 24, got 0",,,,,,,0,,"xlog.c",4488, 2025-07-25 00:54:13.592379 EDT,,,p268902,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","redo done at 5/3B21C628 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s",,,,,,,0,,"xlog.c",7959, 2025-07-25 00:54:13.595957 EDT,,,p268902,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","end of transaction log location is 5/3B21C660",,,,,,,0,,"xlog.c",8048, 2025-07-25 00:54:13.596305 EDT,,,p268902,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","checkpoint starting: end-of-recovery immediate",,,,,,,0,,"xlog.c",9239, 2025-07-25 00:54:13.597124 EDT,,,p268902,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.002 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB",,,,,,,0,,"xlog.c",9320, 2025-07-25 00:54:13.597140 EDT,,,p268902,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","latest completed transaction id is 492382 and next transaction id is 492383",,,,,,,0,,"xlog.c",8446, 2025-07-25 00:54:13.597377 EDT,,,p268902,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","database system is ready",,,,,,,0,,"xlog.c",8473, 2025-07-25 00:54:13.602248 EDT,,,p4005057,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","PostgreSQL 14.4 (Apache Cloudberry 2.0.0-incubating-rc2 build dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5), 64-bit compiled on Jul 8 2025 03:25:08 (with assert checking)",,,,,,,0,,"postmaster.c",3564, 2025-07-25 00:54:13.602271 EDT,,,p4005057,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","database system is ready to accept connections","PostgreSQL 14.4 (Apache Cloudberry 2.0.0-incubating-rc2 build dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5), 64-bit compiled on Jul 8 2025 03:25:08 (with assert checking)",,,,,,0,,"postmaster.c",3566, 2025-07-25 00:54:13.602863 EDT,,,p268910,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","ic-proxy: server setting up",,,,,,,0,,"ic_proxy_main.c",531, 2025-07-25 00:54:13.603244 EDT,,,p268910,th1103079616,,,,0,,,seg7,,,,,"LOG","00000","ic-proxy: server running",,,,,,,0,,"ic_proxy_main.c",572, 2025-07-25 00:54:59.968285 EDT,"gpadmin","postgres",p268993,th1103079616,"168.160.18.164","50728",2025-07-25 00:54:59 EDT,0,con3,,seg7,,,,sx1,"LOG","00000","statement: select gid from pg_prepared_xacts where prepared < now() - interval'120 seconds'",,,,,,,0,,"postgres.c",1713, -- 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: commits-unsubscr...@cloudberry.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cloudberry.apache.org For additional commands, e-mail: commits-h...@cloudberry.apache.org
