Re: Row pattern recognition
От | Erik Rijkers |
---|---|
Тема | Re: Row pattern recognition |
Дата | |
Msg-id | 8e48a089-1baf-09d5-0d33-a7b1d75e6a70@xs4all.nl обсуждение исходный текст |
Ответ на | Re: Row pattern recognition (Tatsuo Ishii <ishii@sraoss.co.jp>) |
Ответы |
Re: Row pattern recognition
(Tatsuo Ishii <ishii@sraoss.co.jp>)
|
Список | pgsql-hackers |
Op 9/2/23 om 08:52 schreef Tatsuo Ishii: > Attached is the v5 patch. Differences from previous patch include: > Hi, The patches compile & tests run fine but this statement from the documentation crashes an assert-enabled server: SELECT company, tdate, price, max(price) OVER w FROM stock WINDOW w AS ( PARTITION BY company ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING AFTER MATCH SKIP PAST LAST ROW INITIAL PATTERN (LOWPRICE UP+ DOWN+) DEFINE LOWPRICE AS price <= 100, UP AS price > PREV(price), DOWN AS price < PREV(price) ); server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. connection to server was lost Log file: TRAP: failed Assert("aggregatedupto_nonrestarted <= winstate->aggregatedupto"), File: "nodeWindowAgg.c", Line: 1054, PID: 68975 postgres: 17_rpr_d0ec_gulo: aardvark testdb ::1(34808) SELECT(ExceptionalCondition+0x54)[0x9b0824] postgres: 17_rpr_d0ec_gulo: aardvark testdb ::1(34808) SELECT[0x71ae8d] postgres: 17_rpr_d0ec_gulo: aardvark testdb ::1(34808) SELECT(standard_ExecutorRun+0x13a)[0x6def9a] /home/aardvark/pg_stuff/pg_installations/pgsql.rpr/lib/pg_stat_statements.so(+0x55e5)[0x7ff3798b95e5] /home/aardvark/pg_stuff/pg_installations/pgsql.rpr/lib/auto_explain.so(+0x2680)[0x7ff3798ab680] postgres: 17_rpr_d0ec_gulo: aardvark testdb ::1(34808) SELECT[0x88a4ff] postgres: 17_rpr_d0ec_gulo: aardvark testdb ::1(34808) SELECT(PortalRun+0x240)[0x88bb50] postgres: 17_rpr_d0ec_gulo: aardvark testdb ::1(34808) SELECT[0x887cca] postgres: 17_rpr_d0ec_gulo: aardvark testdb ::1(34808) SELECT(PostgresMain+0x14dc)[0x88958c] postgres: 17_rpr_d0ec_gulo: aardvark testdb ::1(34808) SELECT[0x7fb0da] postgres: 17_rpr_d0ec_gulo: aardvark testdb ::1(34808) SELECT(PostmasterMain+0xd2d)[0x7fc01d] postgres: 17_rpr_d0ec_gulo: aardvark testdb ::1(34808) SELECT(main+0x1e0)[0x5286d0] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7ff378e9dd0a] postgres: 17_rpr_d0ec_gulo: aardvark testdb ::1(34808) SELECT(_start+0x2a)[0x5289aa] 2023-09-02 19:59:05.329 CEST 46723 LOG: server process (PID 68975) was terminated by signal 6: Aborted 2023-09-02 19:59:05.329 CEST 46723 DETAIL: Failed process was running: SELECT company, tdate, price, max(price) OVER w FROM stock WINDOW w AS ( PARTITION BY company ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING AFTER MATCH SKIP PAST LAST ROW INITIAL PATTERN (LOWPRICE UP+ DOWN+) DEFINE LOWPRICE AS price <= 100, UP AS price > PREV(price), DOWN AS price < PREV(price) ); 2023-09-02 19:59:05.329 CEST 46723 LOG: terminating any other active server processes Erik Rijkers
В списке pgsql-hackers по дате отправления:
Предыдущее
От: Ted YuДата:
Сообщение: Re: Add tracking of backend memory allocated to pg_stat_activity