ydb-platform / ydb

YDB is an open source Distributed SQL Database that combines high availability and scalability with strong consistency and ACID transactions
https://ydb.tech
Apache License 2.0
3.83k stars 532 forks source link

[pg] Segfault after start zabbix #3122

Closed rekby closed 5 months ago

rekby commented 5 months ago

stacktraces: https://gist.github.com/rekby/0a29a2dd1bce2bb7f4c1bb4c6732f2e6

wget https://raw.githubusercontent.com/ydb-platform/postgres-compatibility-tests/bfedc0aa57a6a77198df777e4e32903237990ccd/manual-in-progress/zabbix/zabbix-scheme-ydb.sql
cat zabbix-scheme-ydb.sql | psql postgres://root:1234@localhost:5432/local

echo "select cc.corr_conditionid,cc.correlationid,cc.type,cct.tag,cctv.tag,cctv.value,cctv.operator, ccg.groupid,ccg.operator,cctp.oldtag,cctp.newtag from correlation c,corr_condition cc left join corr_condition_tag cct on cct.corr_conditionid=cc.corr_conditionid left join corr_condition_tagvalue cctv on cctv.corr_conditionid=cc.corr_conditionid left join corr_condition_group ccg on ccg.corr_conditionid=cc.corr_conditionid left join corr_condition_tagpair cctp on cctp.corr_conditionid=cc.corr_conditionid where c.correlationid=cc.correlationid and c.status=0" | psql postgres://root:1234@localhost:5432/local

Error:

server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
connection to server was lost

Expected result:

 corr_conditionid | correlationid | type | tag | tag | value | operator | groupid | operator | oldtag | newtag
------------------+---------------+------+-----+-----+-------+----------+---------+----------+--------+--------
(0 rows)
MrLolthe1st commented 5 months ago

3356

MrLolthe1st commented 5 months ago

Anyway crashes because of duplicated column