首页 > 数据库 >postgresql/lightdb ctas与no space available error

postgresql/lightdb ctas与no space available error

时间:2022-10-15 23:11:08浏览次数:45  
标签:available 06 lightdb 08 C++ gdb 2022 postgresql 07

ctas实现逻辑
>    log_newpage    C++ (gdb)
     _bt_blwritepage    C++ (gdb)
     _bt_uppershutdown    C++ (gdb)
     _bt_load    C++ (gdb)
     _bt_leafbuild    C++ (gdb)
     btbuild    C++ (gdb)
     index_build    C++ (gdb)
     index_create    C++ (gdb)
     create_toast_table    C++ (gdb)
     CheckAndCreateToastTable    C++ (gdb)
     NewRelationCreateToastTable    C++ (gdb)
     create_ctas_internal    C++ (gdb)
     intorel_startup    C++ (gdb)
     standard_ExecutorRun    C++ (gdb)
     pgss_ExecutorRun    C++ (gdb)
     ltsa_ExecutorRun    C++ (gdb)
     pgsp_ExecutorRun    C++ (gdb)
     ExecCreateTableAs    C++ (gdb)
     ProcessUtilitySlow    C++ (gdb)
     standard_ProcessUtility    C++ (gdb)
     pgss_ProcessUtility    C++ (gdb)
     ltsa_ProcessUtility    C++ (gdb)
     pgaudit_ProcessUtility_hook    C++ (gdb)
     pg_hint_plan_ProcessUtility    C++ (gdb)
     LtStandbyProcessUtility    C++ (gdb)
     pathman_process_utility_hook    C++ (gdb)
     ProcessUtility    C++ (gdb)
     PortalRunUtility    C++ (gdb)
     PortalRunMulti    C++ (gdb)
     PortalRun    C++ (gdb)
     exec_simple_query    C++ (gdb)
     PostgresMain    C++ (gdb)
     BackendRun    C++ (gdb)
     BackendStartup    C++ (gdb)
     ServerLoop    C++ (gdb)
     PostmasterMain    C++ (gdb)
     main    C++ (gdb)

     libc.so.6!raise    
     libc.so.6!abort    
     errfinish    C++ (gdb)
>    XLogFileInit    C++ (gdb)
     XLogWrite    C++ (gdb)
     XLogFlush    C++ (gdb)
     FlushBuffer    C++ (gdb)
     BufferAlloc    C++ (gdb)
     ReadBuffer_common    C++ (gdb)
     ReadBufferExtended    C++ (gdb)
     ReadBufferBI    C++ (gdb)
     RelationGetBufferForTuple    C++ (gdb)
     heap_insert    C++ (gdb)
     heapam_tuple_insert    C++ (gdb)
     table_tuple_insert    C++ (gdb)
     intorel_receive    C++ (gdb)
     ExecutePlan    C++ (gdb)
     standard_ExecutorRun    C++ (gdb)
     pgss_ExecutorRun    C++ (gdb)
     ltsa_ExecutorRun    C++ (gdb)
     pgsp_ExecutorRun    C++ (gdb)
     ExecCreateTableAs    C++ (gdb)
     ProcessUtilitySlow    C++ (gdb)
     standard_ProcessUtility    C++ (gdb)
     pgss_ProcessUtility    C++ (gdb)
     ltsa_ProcessUtility    C++ (gdb)
     pgaudit_ProcessUtility_hook    C++ (gdb)
     pg_hint_plan_ProcessUtility    C++ (gdb)
     LtStandbyProcessUtility    C++ (gdb)
     pathman_process_utility_hook    C++ (gdb)
     ProcessUtility    C++ (gdb)
     PortalRunUtility    C++ (gdb)
     PortalRunMulti    C++ (gdb)
     PortalRun    C++ (gdb)
     exec_simple_query    C++ (gdb)
     PostgresMain    C++ (gdb)
     BackendRun    C++ (gdb)
     BackendStartup    C++ (gdb)
     ServerLoop    C++ (gdb)
     PostmasterMain    C++ (gdb)
     main    C++ (gdb)

2022-08-06 16:07:51.083299T  @  postmaster  00000[2022-08-06 15:44:05 CST] 0 [165220] LOG:  server process (PID 167657) was terminated by signal 6: Aborted
2022-08-06 16:07:51.083299T  @  postmaster  00000[2022-08-06 15:44:05 CST] 0 [165220] DETAIL:  Failed process was running: create table big_table as select i, 'fewwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww' || i from generate_series(1,10000000) i;
2022-08-06 16:07:51.083339T  @  postmaster  00000[2022-08-06 15:44:05 CST] 0 [165220] LOG:  terminating any other active server processes
2022-08-06 16:07:51.083458T  @  autovacuum launcher  57P02[2022-08-06 15:44:05 CST] 0 [165229] WARNING:  terminating connection because of crash of another server process
2022-08-06 16:07:51.083458T  @  autovacuum launcher  57P02[2022-08-06 15:44:05 CST] 0 [165229] DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2022-08-06 16:07:51.083458T  @  autovacuum launcher  57P02[2022-08-06 15:44:05 CST] 0 [165229] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2022-08-06 16:07:51.084508T [unknown] zjh@postgres [local] client backend  57P03[2022-08-06 16:07:51 CST] 0 [9389] FATAL:  the database system is in recovery mode
2022-08-06 16:07:51.085146T  @  postmaster  00000[2022-08-06 15:44:05 CST] 0 [165220] LOG:  all server processes terminated; reinitializing
2022-08-06 16:07:51.172925T  @  startup  00000[2022-08-06 16:07:51 CST] 0 [9391] LOG:  database system was interrupted; last known up at 2022-08-06 15:44:05 CST
2022-08-06 16:07:51.184637T  @  startup  00000[2022-08-06 16:07:51 CST] 0 [9391] LOG:  database system was not properly shut down; automatic recovery in progress
2022-08-06 16:07:51.185106T  @  startup  00000[2022-08-06 16:07:51 CST] 0 [9391] LOG:  redo starts at 0/209C9FA0
2022-08-06 16:07:54.077694T  @  startup  00000[2022-08-06 16:07:51 CST] 0 [9391] LOG:  redo done at 0/3FFFFF68
2022-08-06 16:07:54.078338T  @  startup  00000[2022-08-06 16:07:51 CST] 0 [9391] LOG:  checkpoint starting: end-of-recovery immediate
2022-08-06 16:07:55.524716T  @  startup  53100[2022-08-06 16:07:51 CST] 0 [9391] PANIC:  could not write to file "lt_wal/xlogtemp.9391": No space left on device
2022-08-06 16:07:55.526168T  @  postmaster  00000[2022-08-06 15:44:05 CST] 0 [165220] LOG:  startup process (PID 9391) was terminated by signal 6: Aborted
2022-08-06 16:07:55.526177T  @  postmaster  00000[2022-08-06 15:44:05 CST] 0 [165220] LOG:  aborting startup due to startup process failure
2022-08-06 16:07:55.526615T  @  postmaster  00000[2022-08-06 15:44:05 CST] 0 [165220] LOG:  database system is shut down

  看起来是ctas语句导致了lightdb进程宕机,实际并非如此。业务进程并不会导致lightdb主进程退出,是后台进程写文件失败导致的进程异常退出。lightdb 22.3(已发布)已通过隔离方式实现空间满不会导致主进程宕机。

标签:available,06,lightdb,08,C++,gdb,2022,postgresql,07
From: https://www.cnblogs.com/zhjh256/p/16563091.html

相关文章

  • postgresql使用备忘
    打开postgresqlsudo-upostgrespsql语句执行时间EXPLAINANALYZEExecutionTime:SQL语句的执行时间Planningtime则是SQL语句生成查询计划所花费的时间参考:(31......
  • PostgreSQL 15 正式发布!工作负载、开发体验等方面有显著提升
       2022年10月13日-PostgreSQL全球开发组今天宣布发布 PostgreSQL15,这是世界上最先进的开源数据库的最新版本。 PostgreSQL15建立在最近版本的性能改......
  • PostgreSQL----运行02_insert_data
    ALTERTABLEdepartmentsALTERCONSTRAINTdept_mgr_fkDEFERRABLEINITIALLYDEFERRED;BEGIN;INSERTINTOdepartmentsVALUES(10,'Adminis......
  • PostgreSQL----四个快速脚本
    PostgreSQL----四个快速脚本运行01_create_table.sql创建示例表;--部门信息表CREATETABLEdepartments(department_idINTEGERNOTNULL--部门编......
  • PostgreSQL的流复制搭建
    单机版流复制测试环境搭建搭建规划主库备库数据目录/pgdata/12/data/pgdata/1202/data归档目录/pgdata/12/arch/pgdata/1202/arch端口54325433创建流复制用户createrolere......
  • postgresql-主备同步模式测试
    测试1:synchronous_standby_names=*是否等同于synchronous_standby_names=any1(s1,s2,s3)结论:不等同ANY2(s1,s2):quorum,quorum,asyncANY1(s1,s2,s3):quorum,quorum,q......
  • PostgreSQL的WAL日志管理
    wal日志介绍wal日志即writeaheadlog预写式日志,简称wal日志。wal日志可以说是PostgreSQL中十分重要的部分,相当于oracle中的redo日志。当数据库中数据发生变更时:(1)change发生......
  • ubuntu Error: You must install at least one postgresql-client-<version> package
    ubuntu系统上执行psql报错Warning:Noexistingclusterissuitableasadefaulttarget.Pleaseseemanpg_wrapper(1)howtospecifyone.Error:Youmustinsta......
  • PostgreSQL数据库用户权限管理ACL访问控制示例
    ACL权限缩写权限缩写适用对象类型​​SELECT​​​​r​​(“读”)​​LARGEOBJECT​​​,​​SEQUENCE​​​,​​TABLE​​(andtable-likeobjects),tablecolumn......
  • 路径分析—PostgreSQL+GeoServer+Openlayers(二)
    路径分析—QGIS+PostgreSQL+PostGIS+pgRouting(一)路径分析—PostgreSQL+GeoServer+Openlayers(二)前言上一篇文章中实现数据库层面的路径分析了,可以在数据库里面通过SQL......