Skip to content

Instantly share code, notes, and snippets.

@palash25
Last active December 23, 2022 07:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save palash25/ab651ab43eaed4e0da5efc98944fea35 to your computer and use it in GitHub Desktop.
Save palash25/ab651ab43eaed4e0da5efc98944fea35 to your computer and use it in GitHub Desktop.
# The adaptor worked fine without tail and indexed the data without any erorrs
# On using tail and inserting a new row in my DB I get the following error on an infinite loop
palash25@Lenovo-G50  ~/Dev/Projects/golang/gopath/src/github.com/appbaseio/abc   analytics-switch ●  ./abc import --src_type=postgres --src_uri="postgresql://palash25:psql@250497@127.0.0.1:5432/palash25" last-ride --tail
ERRO[0004] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
ERRO[0005] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
ERRO[0006] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
ERRO[0007] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
3 total data record(s) indexed
ERRO[0008] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
ERRO[0009] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
ERRO[0010] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
ERRO[0011] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
ERRO[0012] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
# Upon interuptting the errors and running index again and not adding any new row to the DB
# the newly added row that was addded during the last time tail was on finally gets indexed
# but the errors persist
✘ palash25@Lenovo-G50  ~/Dev/Projects/golang/gopath/src/github.com/appbaseio/abc   analytics-switch ●  ./abc import --src_type=postgres --src_uri="postgresql://palash25:psql@250497@127.0.0.1:5432/palash25" last-ride --tail
ERRO[0003] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
ERRO[0004] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
ERRO[0005] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
ERRO[0006] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
4 total data record(s) indexed
ERRO[0007] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
ERRO[0008] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
ERRO[0009] error plucking from logical decoding pq: replication slots can only be used if max_replication_slots > 0 db=palash25
^X^Creceived signal interrupt
# Upon using tail again and simultaneously deleteing a row from the table
# the errors stil show but only 3 rows are indexed, so it seemed that the
# tail switch is picking up deletions but when I deleted another row it did
# not read the deletion and more errors were thrown
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment