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"
} ]
} ]
}

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

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
ПОДРОБНОСТИ: Управляющий процесс отдал команду этому серверному процессу
откатить текущую транзакцию и завершиться, так как другой серверный процесс
завершился аварийно и возможно разрушил разделяемую память.

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.