Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pipelinedb and pg_pathman clash #2058

Open
darrkz opened this issue Sep 18, 2019 · 0 comments
Open

pipelinedb and pg_pathman clash #2058

darrkz opened this issue Sep 18, 2019 · 0 comments

Comments

@darrkz
Copy link

darrkz commented Sep 18, 2019

pipelinedb and pg_pathman clash

pipelinedb version: complie from github master version code
pg_pathman version: 1.5
postgresql version: 11.3

stream table:

CREATE FOREIGN TABLE ad_click ( ad_id int8, iuin int8, ts timestamp ) SERVER pipelinedb; 

view:

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...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant