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

Not able to import View as table from PostgreSQL #188

Open
manjunathkadrolli opened this issue Aug 10, 2020 · 1 comment
Open

Not able to import View as table from PostgreSQL #188

manjunathkadrolli opened this issue Aug 10, 2020 · 1 comment

Comments

@manjunathkadrolli
Copy link

Version
Version: 1.0.0-beta.1
Variant: !oss
Go version: go1.12.5
OS: linux

I am trying to import a view as table, upon which i am not seeing any warning/message on the CLI
Below are the logs with log enabled.

@* ~ % abc import --src_type=postgres --src_uri="postgresql://:@.:5442/” --src_filter="v_ETLOffer" "https://:-[email protected]" --log.level="info"
time="2020-08-10T12:26:28Z" level=info msg="Created temp file pipeline_1597062388589677100.js"
time="2020-08-10T12:26:28Z" level=info msg="postgres uri: postgresql://
:@..com:5442/?sslmode=disable"
time="2020-08-10T12:26:29Z" level=info msg="ES Version: 7.7.1"
time="2020-08-10T12:26:30Z" level=info msg="starting with metadata map[]" name=source path=source type=postgres
time="2020-08-10T12:26:30Z" level=info msg="adaptor Starting..." name=source path=source type=postgres
time="2020-08-10T12:26:30Z" level=info msg="boot map[sink:elasticsearch source:postgres]" ts=1597062390301761900
time="2020-08-10T12:26:30Z" level=info msg="adaptor Listening..." name=sink path=source/sink type=elasticsearch
time="2020-08-10T12:26:31Z" level=info msg="starting Read func" db=

time="2020-08-10T12:26:32Z" level=info msg="done iterating collections" db=*****
time="2020-08-10T12:26:32Z" level=info msg="Read completed" db=*****
time="2020-08-10T12:26:32Z" level=info msg="adaptor Start finished..." name=source path=source type=postgres
time="2020-08-10T12:26:32Z" level=info msg="adaptor Stopping..." name=source path=source type=postgres
time="2020-08-10T12:26:32Z" level=info msg="adaptor Stopped" name=source path=source type=postgres
time="2020-08-10T12:26:32Z" level=info msg="closing connection..." name=source path=source type=postgres
time="2020-08-10T12:26:32Z" level=info msg="connection closed..." name=source path=source type=postgres
time="2020-08-10T12:26:32Z" level=info msg="adaptor Stopping..." name=sink path=source/sink type=elasticsearch
time="2020-08-10T12:26:32Z" level=info msg="received stop, message buffer is empty, closing..."
time="2020-08-10T12:26:32Z" level=info msg="adaptor Listen closed..." name=sink path=source/sink type=elasticsearch
time="2020-08-10T12:26:32Z" level=info msg="adaptor Stopped" name=sink path=source/sink type=elasticsearch
time="2020-08-10T12:26:32Z" level=info msg="closing connection..." name=sink path=source/sink type=elasticsearch
time="2020-08-10T12:26:32Z" level=info msg="connection closed..." name=sink path=source/sink type=elasticsearch
time="2020-08-10T12:26:32Z" level=info msg="closing writer..." name=sink path=source/sink type=elasticsearch
time="2020-08-10T12:26:32Z" level=info msg="closing BulkService" version=7 writer=elasticsearch
time="2020-08-10T12:26:32Z" level=info msg="writer closed..." name=sink path=source/sink type=elasticsearch
time="2020-08-10T12:26:32Z" level=info msg="metrics source records: 0" path=source ts=1597062392087403600
time="2020-08-10T12:26:32Z" level=info msg="metrics source/sink records: 0" path=source/sink ts=1597062392087442400
time="2020-08-10T12:26:32Z" level=info msg="exit map[sink:elasticsearch source:postgres]" ts=1597062392087475600

@machty
Copy link

machty commented Nov 15, 2022

@manjunathkadrolli did you ever find a workaround for this?

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

2 participants