Thread: Segment error
Hello! I got segfault error on on my PostgreSQL 9.6.20 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
Can you help me?
I have core_backtrace.
{ "signal": 11
, "executable": "/usr/pgsql-9.6/bin/postgres"
, "stacktrace":
[ { "crash_thread": true
, "frames":
[ { "address": 7322026
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 3127722
, "function_name": "EA_get_flat_size"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 4907451
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 713147
, "function_name": "heap_tuple_fetch_attr"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 7322617
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 3128313
, "function_name": "expand_array"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 140071953772724
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 106676
, "function_name": "plpgsql_exec_function"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 140071953726871
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 60823
, "function_name": "plpgsql_call_handler"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 6061074
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1866770
, "function_name": "ExecMakeFunctionResultNoSets"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6072085
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1877781
, "function_name": "ExecEvalFuncArgs"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6078477
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1884173
, "function_name": "ExecMakeTableFunctionResult"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6167306
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1973002
, "function_name": "FunctionNext"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6085562
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1891258
, "function_name": "ExecScan"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6057000
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1862696
, "function_name": "ExecProcNode"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6185217
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1990913
, "function_name": "ExecSetParamPlan"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6070245
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1875941
, "function_name": "ExecEvalParamExec"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6084414
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1890110
, "function_name": "ExecProject"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6170466
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1976162
, "function_name": "ExecResult"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6057192
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1862888
, "function_name": "ExecProcNode"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6041495
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1847191
, "function_name": "standard_ExecutorRun"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6098781
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1904477
, "function_name": "fmgr_sql"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6061074
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1866770
, "function_name": "ExecMakeFunctionResultNoSets"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 140071953746626
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 80578
, "function_name": "exec_eval_expr"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 140071953754130
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 88082
, "function_name": "exec_assign_expr"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 140071953762964
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 96916
, "function_name": "exec_stmts"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 140071953771739
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 105691
, "function_name": "exec_stmt_block"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 140071953774511
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 108463
, "function_name": "plpgsql_exec_trigger"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 140071953726986
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 60938
, "function_name": "plpgsql_call_handler"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 5930759
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1736455
, "function_name": "ExecCallTriggerFunc"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 5953638
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1759334
, "function_name": "ExecIRUpdateTriggers"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6157240
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1962936
, "function_name": "ExecUpdate"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6158887
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1964583
, "function_name": "ExecModifyTable"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6057176
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1862872
, "function_name": "ExecProcNode"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6041495
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1847191
, "function_name": "standard_ExecutorRun"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 7181774
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 2987470
, "function_name": "ProcessQuery"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 7182349
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 2988045
, "function_name": "PortalRunMulti"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 7185135
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 2990831
, "function_name": "PortalRun"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 7176254
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 2981950
, "function_name": "PostgresMain"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 4653007
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 458703
, "function_name": "ServerLoop"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6790855
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 2596551
, "function_name": "PostmasterMain"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 4656222
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 461918
, "function_name": "main"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
} ]
} ]
}
, "executable": "/usr/pgsql-9.6/bin/postgres"
, "stacktrace":
[ { "crash_thread": true
, "frames":
[ { "address": 7322026
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 3127722
, "function_name": "EA_get_flat_size"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 4907451
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 713147
, "function_name": "heap_tuple_fetch_attr"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 7322617
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 3128313
, "function_name": "expand_array"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 140071953772724
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 106676
, "function_name": "plpgsql_exec_function"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 140071953726871
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 60823
, "function_name": "plpgsql_call_handler"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 6061074
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1866770
, "function_name": "ExecMakeFunctionResultNoSets"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6072085
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1877781
, "function_name": "ExecEvalFuncArgs"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6078477
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1884173
, "function_name": "ExecMakeTableFunctionResult"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6167306
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1973002
, "function_name": "FunctionNext"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6085562
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1891258
, "function_name": "ExecScan"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6057000
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1862696
, "function_name": "ExecProcNode"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6185217
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1990913
, "function_name": "ExecSetParamPlan"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6070245
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1875941
, "function_name": "ExecEvalParamExec"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6084414
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1890110
, "function_name": "ExecProject"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6170466
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1976162
, "function_name": "ExecResult"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6057192
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1862888
, "function_name": "ExecProcNode"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6041495
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1847191
, "function_name": "standard_ExecutorRun"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6098781
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1904477
, "function_name": "fmgr_sql"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6061074
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1866770
, "function_name": "ExecMakeFunctionResultNoSets"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 140071953746626
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 80578
, "function_name": "exec_eval_expr"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 140071953754130
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 88082
, "function_name": "exec_assign_expr"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 140071953762964
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 96916
, "function_name": "exec_stmts"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 140071953771739
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 105691
, "function_name": "exec_stmt_block"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 140071953774511
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 108463
, "function_name": "plpgsql_exec_trigger"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 140071953726986
, "build_id": "996ebe9fbeefed4303106e90a098dfbe0d6814bb"
, "build_id_offset": 60938
, "function_name": "plpgsql_call_handler"
, "file_name": "/usr/pgsql-9.6/lib/plpgsql.so"
}
, { "address": 5930759
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1736455
, "function_name": "ExecCallTriggerFunc"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 5953638
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1759334
, "function_name": "ExecIRUpdateTriggers"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6157240
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1962936
, "function_name": "ExecUpdate"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6158887
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1964583
, "function_name": "ExecModifyTable"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6057176
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1862872
, "function_name": "ExecProcNode"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6041495
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 1847191
, "function_name": "standard_ExecutorRun"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 7181774
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 2987470
, "function_name": "ProcessQuery"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 7182349
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 2988045
, "function_name": "PortalRunMulti"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 7185135
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 2990831
, "function_name": "PortalRun"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 7176254
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 2981950
, "function_name": "PostgresMain"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 4653007
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 458703
, "function_name": "ServerLoop"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 6790855
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 2596551
, "function_name": "PostmasterMain"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
}
, { "address": 4656222
, "build_id": "b63f4a6e327a2b0a06679bc01acb88a5fa9df747"
, "build_id_offset": 461918
, "function_name": "main"
, "file_name": "/usr/pgsql-9.6/bin/postgres"
} ]
} ]
}
And i can show abrt-cli ls -d:
abrt-cli ls -d
id 7a7f74555fac734ada54c0299550e1f4ea7d870e
reason: postgres killed by SIGSEGV
time: Tue 22 Dec 2020 05:13:11 PM KRAT
cmdline: 'postgres: bars_web_edu bars_web_edu 172.50.21.7(56670) UPDATE'
package: postgresql96-server-9.6.20-1PGDG.rhel7
uid: 26 (postgres)
count: 1
Directory: /var/spool/abrt/ccpp-2020-12-22-17:13:11-55458
abrt_version: 2.1.11
analyzer: CCpp
architecture: x86_64
component: postgresql96
event_log:
executable: /usr/pgsql-9.6/bin/postgres
global_pid: 55458
hostname: escholldb
kernel: 3.10.0-327.4.5.el7.x86_64
last_occurrence: 1608631991
os_release: CentOS Linux release 7.2.1511 (Core)
pid: 55458
pkg_arch: x86_64
pkg_epoch: 0
pkg_fingerprint: 1F16 D2E1 442D F0F8
pkg_name: postgresql96-server
pkg_release: 1PGDG.rhel7
pkg_vendor: PostgreSQL Global Development Group
pkg_version: 9.6.20
pwd: /var/lib/pgsql/9.6/data
runlevel: N 3
type: CCpp
username: postgres
uuid: 8941f4720bd9f23c152fd765ef5cebef912066fb
core_backtrace: Text file, 11515 bytes
coredump: Binary file, 4427079680 bytes
dso_list: Text file, 4178 bytes
maps: Text file, 20796 bytes
open_fds: Text file, 5296 bytes
var_log_messages: Text file, 12664 bytes
cgroup:
:10:perf_event:/
:9:hugetlb:/
:8:blkio:/
:7:cpuset:/
:6:memory:/
:5:net_cls:/
:4:freezer:/
:3:devices:/
:2:cpuacct,cpu:/
:1:name=systemd:/system.slice/postgresql-9.6.service
environ:
:ATE
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
limits:
:Limit Soft Limit Hard Limit Units
:Max cpu time unlimited unlimited seconds
:Max file size unlimited unlimited bytes
:Max data size unlimited unlimited bytes
:Max stack size 8388608 unlimited bytes
:Max core file size 0 unlimited bytes
:Max resident set unlimited unlimited bytes
:Max processes 61932 61932 processes
:Max open files 1024 4096 files
:Max locked memory 65536 65536 bytes
:Max address space unlimited unlimited bytes
:Max file locks unlimited unlimited locks
:Max pending signals 61932 61932 signals
:Max msgqueue size 819200 819200 bytes
:Max nice priority 0 0
:Max realtime priority 0 0
:Max realtime timeout unlimited unlimited us
machineid:
:systemd=635f0b0b6a6e498b8a78a15cc6d0c6ed
:sosreport_uploader-dmidecode=9af711dcec36c909c7a3bfa74443f1430f371d29e8ebf8e9c12765f75c1a14c6
os_info:
:NAME="CentOS Linux"
:VERSION="7 (Core)"
:ID="centos"
:ID_LIKE="rhel fedora"
:VERSION_ID="7"
:PRETTY_NAME="CentOS Linux 7 (Core)"
:ANSI_COLOR="0;31"
:CPE_NAME="cpe:/o:centos:centos:7"
:HOME_URL="https://www.centos.org/"
:BUG_REPORT_URL="https://bugs.centos.org/"
:
:CENTOS_MANTISBT_PROJECT="CentOS-7"
:CENTOS_MANTISBT_PROJECT_VERSION="7"
:REDHAT_SUPPORT_PRODUCT="centos"
:REDHAT_SUPPORT_PRODUCT_VERSION="7"
:
proc_pid_status:
:Name: postmaster
:State: S (sleeping)
:Tgid: 55458
:Ngid: 0
:Pid: 55458
:PPid: 35588
:TracerPid: 0
:Uid: 26 26 26 26
:Gid: 26 26 26 26
:FDSize: 128
:Groups: 26
:VmPeak: 4537828 kB
:VmSize: 4537828 kB
:VmLck: 0 kB
:VmPin: 0 kB
:VmHWM: 13992 kB
:VmRSS: 13992 kB
:VmData: 4768 kB
:VmStk: 136 kB
:VmExe: 6272 kB
:VmLib: 13496 kB
:VmPTE: 428 kB
:VmSwap: 596 kB
:Threads: 1
:SigQ: 0/61932
:SigPnd: 0000000000000000
:ShdPnd: 0000000000000000
:SigBlk: 0000000000000000
:SigIgn: 0000000001301800
:SigCgt: 0000000180006287
:CapInh: 0000000000000000
:CapPrm: 0000000000000000
:CapEff: 0000000000000000
:CapBnd: 0000001fffffffff
:Seccomp: 0
:Cpus_allowed: ffffffff,ffffffff
:Cpus_allowed_list: 0-63
:Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
:Mems_allowed_list: 0
:voluntary_ctxt_switches: 27
:nonvoluntary_ctxt_switches: 0
The Autoreporting feature is disabled. Please consider enabling it by issuing
'abrt-auto-reporting enabled' as a user with root privileges
id 7a7f74555fac734ada54c0299550e1f4ea7d870e
reason: postgres killed by SIGSEGV
time: Tue 22 Dec 2020 05:13:11 PM KRAT
cmdline: 'postgres: bars_web_edu bars_web_edu 172.50.21.7(56670) UPDATE'
package: postgresql96-server-9.6.20-1PGDG.rhel7
uid: 26 (postgres)
count: 1
Directory: /var/spool/abrt/ccpp-2020-12-22-17:13:11-55458
abrt_version: 2.1.11
analyzer: CCpp
architecture: x86_64
component: postgresql96
event_log:
executable: /usr/pgsql-9.6/bin/postgres
global_pid: 55458
hostname: escholldb
kernel: 3.10.0-327.4.5.el7.x86_64
last_occurrence: 1608631991
os_release: CentOS Linux release 7.2.1511 (Core)
pid: 55458
pkg_arch: x86_64
pkg_epoch: 0
pkg_fingerprint: 1F16 D2E1 442D F0F8
pkg_name: postgresql96-server
pkg_release: 1PGDG.rhel7
pkg_vendor: PostgreSQL Global Development Group
pkg_version: 9.6.20
pwd: /var/lib/pgsql/9.6/data
runlevel: N 3
type: CCpp
username: postgres
uuid: 8941f4720bd9f23c152fd765ef5cebef912066fb
core_backtrace: Text file, 11515 bytes
coredump: Binary file, 4427079680 bytes
dso_list: Text file, 4178 bytes
maps: Text file, 20796 bytes
open_fds: Text file, 5296 bytes
var_log_messages: Text file, 12664 bytes
cgroup:
:10:perf_event:/
:9:hugetlb:/
:8:blkio:/
:7:cpuset:/
:6:memory:/
:5:net_cls:/
:4:freezer:/
:3:devices:/
:2:cpuacct,cpu:/
:1:name=systemd:/system.slice/postgresql-9.6.service
environ:
:ATE
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
limits:
:Limit Soft Limit Hard Limit Units
:Max cpu time unlimited unlimited seconds
:Max file size unlimited unlimited bytes
:Max data size unlimited unlimited bytes
:Max stack size 8388608 unlimited bytes
:Max core file size 0 unlimited bytes
:Max resident set unlimited unlimited bytes
:Max processes 61932 61932 processes
:Max open files 1024 4096 files
:Max locked memory 65536 65536 bytes
:Max address space unlimited unlimited bytes
:Max file locks unlimited unlimited locks
:Max pending signals 61932 61932 signals
:Max msgqueue size 819200 819200 bytes
:Max nice priority 0 0
:Max realtime priority 0 0
:Max realtime timeout unlimited unlimited us
machineid:
:systemd=635f0b0b6a6e498b8a78a15cc6d0c6ed
:sosreport_uploader-dmidecode=9af711dcec36c909c7a3bfa74443f1430f371d29e8ebf8e9c12765f75c1a14c6
os_info:
:NAME="CentOS Linux"
:VERSION="7 (Core)"
:ID="centos"
:ID_LIKE="rhel fedora"
:VERSION_ID="7"
:PRETTY_NAME="CentOS Linux 7 (Core)"
:ANSI_COLOR="0;31"
:CPE_NAME="cpe:/o:centos:centos:7"
:HOME_URL="https://www.centos.org/"
:BUG_REPORT_URL="https://bugs.centos.org/"
:
:CENTOS_MANTISBT_PROJECT="CentOS-7"
:CENTOS_MANTISBT_PROJECT_VERSION="7"
:REDHAT_SUPPORT_PRODUCT="centos"
:REDHAT_SUPPORT_PRODUCT_VERSION="7"
:
proc_pid_status:
:Name: postmaster
:State: S (sleeping)
:Tgid: 55458
:Ngid: 0
:Pid: 55458
:PPid: 35588
:TracerPid: 0
:Uid: 26 26 26 26
:Gid: 26 26 26 26
:FDSize: 128
:Groups: 26
:VmPeak: 4537828 kB
:VmSize: 4537828 kB
:VmLck: 0 kB
:VmPin: 0 kB
:VmHWM: 13992 kB
:VmRSS: 13992 kB
:VmData: 4768 kB
:VmStk: 136 kB
:VmExe: 6272 kB
:VmLib: 13496 kB
:VmPTE: 428 kB
:VmSwap: 596 kB
:Threads: 1
:SigQ: 0/61932
:SigPnd: 0000000000000000
:ShdPnd: 0000000000000000
:SigBlk: 0000000000000000
:SigIgn: 0000000001301800
:SigCgt: 0000000180006287
:CapInh: 0000000000000000
:CapPrm: 0000000000000000
:CapEff: 0000000000000000
:CapBnd: 0000001fffffffff
:Seccomp: 0
:Cpus_allowed: ffffffff,ffffffff
:Cpus_allowed_list: 0-63
:Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
:Mems_allowed_list: 0
:voluntary_ctxt_switches: 27
:nonvoluntary_ctxt_switches: 0
The Autoreporting feature is disabled. Please consider enabling it by issuing
'abrt-auto-reporting enabled' as a user with root privileges
This is log:
2020-12-22 10:13:18 UTC [55654]: [1-1] db=bars_web_edu,user=bars_web_edu СООБЩЕНИЕ: продолжительность: 4971.123 мс, оператор: SELECT "schedule_lesson"."date", "studytimecall"."begin", "fgos_discipline"."name" FROM "fgos_mark" INNER JOIN
"schoolchild" ON ("fgos_mark"."schoolchild_id" = "schoolchild"."id") INNER JOIN "pupil" ON ("schoolchild"."id" = "pupil"."schoolchild_id") INNER JOIN "fgos_schedulelessonmarktype" ON ("fgos_mark"."schedulelessonmarktype_id" = "fgos_sche
dulelessonmarktype"."id") INNER JOIN "schedule_lesson" ON ("fgos_schedulelessonmarktype"."schedulelesson_id" = "schedule_lesson"."id") INNER JOIN "studytimecall" ON ("schedule_lesson"."studycall_id" = "studytimecall"."id") INNER JOIN "fg
os_disciplinegroup" ON ("schedule_lesson"."discipline_group_id" = "fgos_disciplinegroup"."id") INNER JOIN "fgos_discipline" ON ("fgos_disciplinegroup"."discipline_id" = "fgos_discipline"."id") WHERE ("fgos_mark"."schoolchild_id" = 37040
AND "pupil"."class_year_id" = 13349 AND "fgos_mark"."is_point" = true)
2020-12-22 10:13:18 UTC [35588]: [254-1] db=,user= СООБЩЕНИЕ: процесс сервера (PID 55458) был завершён по сигналу 11: Ошибка сегментирования
2020-12-22 10:13:18 UTC [35588]: [255-1] db=,user= ПОДРОБНОСТИ: Завершившийся процесс выполнял действие: UPDATE "users_userprofile" SET "created" = '2016-01-21T12:58:51.710388'::timestamp, "modified" = '2020-12-22T15:12:16.163803'::time
stamp, "photo" = '', "user_id" = 56149, "school_id" = 244, "metarole" = 'pupil', "person_id" = 53415, "about_myself" = NULL, "is_ad_user" = false, "need_change_password" = false, "banner" = false, "public_photo" = '' WHERE "users_userpro
file"."id" = 53642
2020-12-22 10:13:18 UTC [35588]: [256-1] db=,user= СООБЩЕНИЕ: завершение всех остальных активных серверных процессов
2020-12-22 10:13:18 UTC [55817]: [1-1] db=bars_web_edu,user=bars_web_edu ПРЕДУПРЕЖДЕНИЕ: закрытие подключения из-за краха другого серверного процесса (символ 270)
2020-12-22 10:13:18 UTC [55817]: [2-1] db=bars_web_edu,user=bars_web_edu ПОДРОБНОСТИ: Управляющий процесс отдал команду этому серверному процессу откатить текущую транзакцию и завершиться, так как другой серверный процесс завершился аварийно и возможно разрушил разделяемую память.
"schoolchild" ON ("fgos_mark"."schoolchild_id" = "schoolchild"."id") INNER JOIN "pupil" ON ("schoolchild"."id" = "pupil"."schoolchild_id") INNER JOIN "fgos_schedulelessonmarktype" ON ("fgos_mark"."schedulelessonmarktype_id" = "fgos_sche
dulelessonmarktype"."id") INNER JOIN "schedule_lesson" ON ("fgos_schedulelessonmarktype"."schedulelesson_id" = "schedule_lesson"."id") INNER JOIN "studytimecall" ON ("schedule_lesson"."studycall_id" = "studytimecall"."id") INNER JOIN "fg
os_disciplinegroup" ON ("schedule_lesson"."discipline_group_id" = "fgos_disciplinegroup"."id") INNER JOIN "fgos_discipline" ON ("fgos_disciplinegroup"."discipline_id" = "fgos_discipline"."id") WHERE ("fgos_mark"."schoolchild_id" = 37040
AND "pupil"."class_year_id" = 13349 AND "fgos_mark"."is_point" = true)
2020-12-22 10:13:18 UTC [35588]: [254-1] db=,user= СООБЩЕНИЕ: процесс сервера (PID 55458) был завершён по сигналу 11: Ошибка сегментирования
2020-12-22 10:13:18 UTC [35588]: [255-1] db=,user= ПОДРОБНОСТИ: Завершившийся процесс выполнял действие: UPDATE "users_userprofile" SET "created" = '2016-01-21T12:58:51.710388'::timestamp, "modified" = '2020-12-22T15:12:16.163803'::time
stamp, "photo" = '', "user_id" = 56149, "school_id" = 244, "metarole" = 'pupil', "person_id" = 53415, "about_myself" = NULL, "is_ad_user" = false, "need_change_password" = false, "banner" = false, "public_photo" = '' WHERE "users_userpro
file"."id" = 53642
2020-12-22 10:13:18 UTC [35588]: [256-1] db=,user= СООБЩЕНИЕ: завершение всех остальных активных серверных процессов
2020-12-22 10:13:18 UTC [55817]: [1-1] db=bars_web_edu,user=bars_web_edu ПРЕДУПРЕЖДЕНИЕ: закрытие подключения из-за краха другого серверного процесса (символ 270)
2020-12-22 10:13:18 UTC [55817]: [2-1] db=bars_web_edu,user=bars_web_edu ПОДРОБНОСТИ: Управляющий процесс отдал команду этому серверному процессу откатить текущую транзакцию и завершиться, так как другой серверный процесс завершился аварийно и возможно разрушил разделяемую память.
Sorry fo russian language, i used google translate for this text to translate it to english:
2020-12-22 10:13:18 UTC [55654]: [1-1] db = bars_web_edu, user = bars_web_edu MESSAGE: duration: 4971.123 ms, statement: SELECT "schedule_lesson". "Date", "studytimecall". " begin "," fgos_discipline "." name "FROM" fgos_mark "INNER JOIN "schoolchild" ON ("fgos_mark". "schoolchild_id" = "schoolchild". "id") INNER JOIN "pupil" ON ("schoolchild". "id" = "pupil". "schoolchild_id") INNER JOIN "fgos_schedulelessonmarktype" ON ("fgos_mark". "schedulelessonmarktype_id" = "fgos_sche dulelessonmarktype "." id ") INNER JOIN" schedule_lesson "ON (" fgos_schedulelessonmarktype "." schedulelesson_id "=" schedule_lesson "." id ") INNER JOIN" studytimecall "ON (" schedule_lesson "." studycall_id "=" studytimecall " id ") INNER JOIN" fg os_disciplinegroup "ON (" schedule_lesson "." discipline_group_id "=" fgos_disciplinegroup "." id ") INNER JOIN" fgos_discipline "ON (" fgos_disciplinegroup "." discipline_id "=" fgos_disciplinegroup "." id " schoolchild_id "= 37040 AND "pupil". "Class_year_id" = 13349 AND "fgos_mark". "Is_point" = true) 2020-12-22 10:13:18 UTC [35588]: [254-1] db =, user = MESSAGE: Server process (PID 55458) was terminated by signal 11: Segment error 2020-12-22 10:13:18 UTC [35588]: [255-1] db =, user = DETAILS: The exited process performed the action: UPDATE "users_userprofile" SET "created" = '2016-01-21T12: 58: 51.710388 ':: timestamp, "modified" =' 2020-12-22T15: 12: 16.163803 ':: time stamp, "photo" = '', "user_id" = 56149, "school_id" = 244, "metarole" = 'pupil', "person_id" = 53415, "about_myself" = NULL, "is_ad_user" = false, "need_change_password" = false, "banner" = false, "public_photo" = '' WHERE "users_userpro file "." id "= 53642 2020-12-22 10:13:18 UTC [35588]: [256-1] db =, user = MESSAGE: All other active server processes have ended 2020-12-22 10:13:18 UTC [55817]: [1-1] db = bars_web_edu, user = bars_web_edu WARNING: The connection was closed due to the crash of another server process (character 270) 2020-12-22 10:13:18 UTC [55817]: [2-1] db = bars_web_edu, user = bars_web_edu DETAILS: The control process instructed this server process to rollback the current transaction and exit, since another server process has terminated abnormally and possibly corrupted shared memory.
=?UTF-8?B?0JDQu9C10LrRgdCw0L3QtNGAINCd0LjQutC40YLQuNC9?= <nikitin.alexandr.mail@gmail.com> writes:
> Hello! I got segfault error on on my PostgreSQL 9.6.20 on
> x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat
> 4.8.5-39), 64-bit
Can you make a self-contained test case that causes this?
The stack trace is suggestive but not enough to diagnose the
problem, and none of this other info is very useful at all.
regards, tom lane