You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE VIEW ad_click_result WITH (action=materialize ) AS
select ad_id, min(ts) first_view, max(ts) last_view, count(distinct iuin) as uv, count(*) as pv
from ad_click
group by ad_id;
psql commandline return:
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
postgresql server log content:
Segmentation fault (PID 30695)
PostgreSQL version: 11.3
PipelineDB version: unknown at revision unknown
query: CREATE VIEW ad_click_result WITH (action=materialize ) AS
select ad_id, min(ts) first_view, max(ts) last_view, count(distinct iuin) as uv, count(*) as pv
from ad_click
group by ad_id;
backtrace:
/data/app/postgresql/lib/pipelinedb.so(debug_segfault+0x18)[0x7fe209542308]
/lib64/libc.so.6(+0x32570)[0x7fe20f9ab570]
/data/app/postgresql/lib/pipelinedb.so(+0xb81fd)[0x7fe2095611fd]
postgres: mysql dh [local] CREATE VIEW[0x690728]
postgres: mysql dh [local] CREATE VIEW[0x68f68b]
postgres: mysql dh [local] CREATE VIEW[0x692571]
postgres: mysql dh [local] CREATE VIEW[0x68f19f]
postgres: mysql dh [local] CREATE VIEW(create_plan+0x29)[0x6904f9]
postgres: mysql dh [local] CREATE VIEW(standard_planner+0x155)[0x69dcc5]
/data/app/postgresql/lib/pipelinedb.so(PipelinePlanner+0x18e)[0x7fe2095448de]
/data/app/postgresql/lib/pg_pathman.so(pathman_planner_hook+0xa1)[0x7fe20871c0a1]
postgres: mysql dh [local] CREATE VIEW(pg_plan_query+0x1a)[0x743caa]
/data/app/postgresql/lib/pipelinedb.so(+0x9bbec)[0x7fe209544bec]
/data/app/postgresql/lib/pipelinedb.so(GetContPlan+0x9a)[0x7fe209544d8a]
/data/app/postgresql/lib/pipelinedb.so(ExecCreateContViewStmt+0x1377)[0x7fe20953eb87]
/data/app/postgresql/lib/pipelinedb.so(PipelineProcessUtility+0xb05)[0x7fe20956ecc5]
/data/app/postgresql/lib/pg_pathman.so(pathman_process_utility_hook+0x83)[0x7fe20871b953]
/data/app/postgresql/lib/pg_stat_statements.so(+0x4a18)[0x7fe207d16a18]
/data/app/postgresql/lib/cstore_fdw.so(+0x7d90)[0x7fe2078ced90]
postgres: mysql dh [local] CREATE VIEW[0x746739]
postgres: mysql dh [local] CREATE VIEW[0x74760d]
postgres: mysql dh [local] CREATE VIEW(PortalRun+0x230)[0x747d70]
postgres: mysql dh [local] CREATE VIEW[0x74431d]
postgres: mysql dh [local] CREATE VIEW(PostgresMain+0x581)[0x7452f1]
postgres: mysql dh [local] CREATE VIEW(PostmasterMain+0x1ac3)[0x6d5c63]
postgres: mysql dh [local] CREATE VIEW(main+0x3f0)[0x64ad60]
/lib64/libc.so.6(__libc_start_main+0x100)[0x7fe20f997d20]
postgres: mysql dh [local] CREATE VIEW[0x4771d9]
after I drop the pg_pathman, every thing go ok...
The text was updated successfully, but these errors were encountered:
pipelinedb and pg_pathman clash
pipelinedb version: complie from github master version code
pg_pathman version: 1.5
postgresql version: 11.3
stream table:
view:
psql commandline return:
postgresql server log content:
after I drop the pg_pathman, every thing go ok...
The text was updated successfully, but these errors were encountered: