The data is not syncing automatically from CouchDB to RDBMS

binod · September 20, 2023, 8:37am

Continuing the discussion from Cannot Login using medic account:

Marcelo_De_Guzman · September 20, 2023, 11:57am

Thanks @binod for separating the issues,.

Do you have any idea on this one?

binod · September 20, 2023, 4:53pm

We need to check why your Couch2PG is not syncing automatically after first run. Is it set to run periodically?

Can you please check the Couch2PG logs for any error?

docker logs cht-couch2pg_cht-couch2pg_1

Also, please share the following environment variables from your couch2pg.env:

COUCH2PG_SLEEP_MINS
COUCH2PG_RETRY_COUNT

mrjones · September 20, 2023, 6:36pm

Binod’s logs call is a great start! As well I’d also want to confirm that the compose file referenced in /srv/cht-couch2pg has restart: always which will ensure the container tries to stay up.

Marcelo_De_Guzman · September 20, 2023, 11:13pm

Hi,

This is the result from the command you request to be executed.

And for the
COUCH2PG_SLEEP_MINS
COUCH2PG_RETRY_COUNT

Marcelo_De_Guzman · September 21, 2023, 12:06am

HI @binod ,

Joy mentioned that there were two version of couch2pg on this:

First is on the docker and the other one is on the node.

Is the version 3.17.x can’t handle the dual version of couch2pg or just select only one from docker or the node one ?

binod · September 21, 2023, 7:28am

Logs

The image above shows the logs from postgres. Logs from couch2pg could be more helpful in identifying the problem.

Auto restart

As suggested by @mrjones, please consider adding restart: always, if it’s not already there in the compose file. It’s not there in the docker-compose file available in the cht-couch2pg repo, but you can find an example here:

github.com

medic/cht-sync/blob/478164f1565f10146f35d0795546e6288911956e/docker-compose.yml#L7


      
          version: '3.7'
          
          services:
            logstash:
              image: medicmobile/cht-logstash-couchdb:latest
              build: ./logstash/
              restart: always
              environment:
                - COUCHDB_USER=${COUCHDB_USER}
                - COUCHDB_PASSWORD=${COUCHDB_PASSWORD}
                - COUCHDB_HOST=${COUCHDB_HOST}
                - COUCHDB_PORT=${COUCHDB_PORT}
                - COUCHDB_SEQ=/tmp/couchdb/sequence_path.txt
                - COUCHDB_SECURE=${COUCHDB_SECURE:-true}
                - HTTP_ENDPOINT=postgrest:3000
          
            superset:

Running multiple Couch2PG versions

I think 3.17.x should be able to handle both versions at the same time as long as the destination databases are different. However, it might be a good idea to keep only one to save resources unless you need both. @yuv can you please suggest here?

Marcelo_De_Guzman · September 22, 2023, 3:18am

Hi @binod ,

this is the logs for cht-couch2pg_cht-couch2pg_1 (part_1 for the data)

[2023-09-21T02:13:39.259Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-21T02:13:39.307Z DEBUG]: Pulled 50 results from couchdb
[2023-09-21T02:13:39.307Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-21T02:13:39.517Z DEBUG]: Inserting 50 results into postgresql
[2023-09-21T02:13:39.660Z DEBUG]: Pulled 50 results from couchdb
[2023-09-21T02:13:39.660Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-21T02:13:39.866Z DEBUG]: Inserting 50 results into postgresql
[2023-09-21T02:13:39.970Z DEBUG]: Batch completed with 100 changes
[2023-09-21T02:13:39.970Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-21T02:13:39.972Z DEBUG]: Downloading CouchDB changes feed from 11243-g1AAAAJ7eJyd0UsOgjAQANCJn-jWE-gJDLTYwkqu4UqYAiEEceVaj-FObyJLb6E3wYFiiAkxKWkyTaaZl5lpDgDzdBzBQh1PKo3Qt5lcW3TsnJ5GIeCyqqosHSPAtDxQbqY8N5Es6av5I-GKIm47bNdgLFGxQmaK-TW277Bng6EIN4LHplhQY-cOC3RnGDIplCFWTCjChS7ybi14bUCHS4e8QeBdg48WLHSHzI5FJAeBpQZfPyBakeTc9Gc1-Nbgd4dCj4yuw7nXV5p9APyoozg
[2023-09-21T02:13:40.051Z INFO]: There are 100 changes to process
[2023-09-21T02:13:40.051Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-21T02:13:40.108Z DEBUG]: Pulled 50 results from couchdb
[2023-09-21T02:13:40.108Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-21T02:13:40.322Z DEBUG]: Inserting 50 results into postgresql
[2023-09-21T02:13:40.457Z DEBUG]: Pulled 50 results from couchdb
[2023-09-21T02:13:40.457Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-21T02:13:40.697Z DEBUG]: Inserting 50 results into postgresql
[2023-09-21T02:13:40.734Z DEBUG]: Batch completed with 100 changes
[2023-09-21T02:13:40.734Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-21T02:13:40.735Z DEBUG]: Downloading CouchDB changes feed from 11343-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYWM_kAsXYky0t0syN0rDpwWNSkgKQTLJHGJYDNswoLTk1OcmIVMMcQIbFIwy7ADYsySzR1Mw4lVTDEkCG1SMMK4C4LCnRyNwsmUTD8liAJEMDkAKaNx9q4CqwgSbG5iZA88gycAHEwP1QA8sgLjQyTDVLMSfLwAMQA-9DDSyFhJ9BirmxMakxCzHwAcRAWBg6QbycZGFibGyJTWsWAICio5w
[2023-09-21T02:13:40.823Z INFO]: There are 50 changes to process
[2023-09-21T02:13:40.823Z DEBUG]: There are 0 deletions and 50 new / changed documents
[2023-09-21T02:13:40.896Z DEBUG]: Pulled 50 results from couchdb
[2023-09-21T02:13:40.896Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-21T02:13:41.103Z DEBUG]: Inserting 50 results into postgresql
[2023-09-21T02:13:41.192Z DEBUG]: Batch completed with 50 changes
[2023-09-21T02:13:41.192Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-21T02:13:41.192Z DEBUG]: Downloading CouchDB changes feed from 11393-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYWM_lAsXYky0t0syN0rDpwWNSkgKQTLJHGJYPNswoLTk1OcmIVMMcQIbFIwy7ADYsySzR1Mw4lVTDEkCG1SMMK4G4LCnRyNwsmUTD8liAJEMDkAKaNx9q4CqwgSbG5iZA88gycAHEwP1QAyshLjQyTDVLMSfLwAMQA-9DDeyDhJ9BirmxMakxCzHwAcRAWBj6Q7ycZGFibGyJTWsWAKAVo84
[2023-09-21T02:13:41.207Z INFO]: There are 0 changes to process
[2023-09-21T02:13:41.209Z DEBUG]: Import loop complete, 250 changes total
[2023-09-21T02:13:41.209Z INFO]: Refreshing materialised views
[2023-09-21T02:13:45.925Z ERROR]: XMLForms support failed
[2023-09-21T02:13:45.925Z ERROR]: { error: must be owner of materialized view useview_telemetry
at Parser.parseErrorMessage (/app/node_modules/pg-protocol/dist/parser.js:287:98)
at Parser.handlePacket (/app/node_modules/pg-protocol/dist/parser.js:126:29)
at Parser.parse (/app/node_modules/pg-protocol/dist/parser.js:39:38)
at Socket.stream.on (/app/node_modules/pg-protocol/dist/index.js:11:42)
at Socket.emit (events.js:198:13)
at addChunk (_stream_readable.js:288:12)
at readableAddChunk (_stream_readable.js:269:11)
at Socket.Readable.push (_stream_readable.js:224:10)
at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
length: 242,
name: ‘error’,
severity: ‘ERROR’,
code: ‘42501’,
detail: undefined,
hint: undefined,
position: undefined,
internalPosition: undefined,
internalQuery: undefined,
where:
‘SQL statement “REFRESH MATERIALIZED VIEW CONCURRENTLY useview_telemetry”\nPL/pgSQL function refresh_matviews() line 15 at EXECUTE’,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: ‘aclchk.c’,
line: ‘3696’,
routine: ‘aclcheck_error’ }
[2023-09-21T02:13:45.926Z ERROR]: An unrecoverable error occurred
[2023-09-21T02:13:45.926Z ERROR]: TypeError: Assignment to constant variable.
at Object.run (/app/libs/medic/runner.js:55:20)
at process._tickCallback (internal/process/next_tick.js:68:7)
[2023-09-21T02:13:45.926Z ERROR]: exiting
Starting couch2pg process
Set postgres URL to …
START Checking for cht couchdb at …
couchdb is ready
check_if_postgres_is_ready with “pg_isready -q -h… -U couch2pg --d postgres”
Postgres is ready moving on …
Launching couch2pg
[2023-09-22T03:14:33.815Z DEBUG]: { debug: true,
v4Mode: false,
couchdbUrl: ‘Medic Mobile’,
postgresqlUrl:
…
docLimit: 1000,
changesLimit: 100,
retryCount: 5,
sleepMins: 60,
couchdbUsersMetaDocLimit: 50 }
[3:14:33 AM] version of database is: 201803202020
[3:14:33 AM] migrating up to 201803202020
[3:14:33 AM] verifying checksum of migration 201606091247.do.2318-standardise-schema.sql
[3:14:33 AM] verifying checksum of migration 201606091248.do.2124-support-edit-and-delete-of-documents.sql
[3:14:33 AM] verifying checksum of migration 201607132040.do.2506-unique-id-constraint.sql
[3:14:33 AM] verifying checksum of migration 201607210832.do.2523-remove-unused-index.sql
[3:14:33 AM] verifying checksum of migration 201611271809.do.2923-couch2-support.sql
[3:14:33 AM] verifying checksum of migration 201803202020.do.3423-multiple-db-support.sql
[2023-09-22T03:14:33.876Z INFO]: Adapter is running in NORMAL mode
Package pg version 8.x.x not tested
Please raise issue to support pg > 7.x.x
Package pg version 8.x.x not tested
Please raise issue to support pg > 7.x.x
[2023-09-22T03:14:33.947Z INFO]: Beginning couch2pg and xmlforms run at Fri Sep 22 2023 03:14:33 GMT+0000 (Coordinated Universal Time)
[2023-09-22T03:14:33.949Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:33.960Z DEBUG]: Downloading CouchDB changes feed from 691571-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYg17nAsXY00yTjIxSU7HpwWNSkgKQTLKHGxagCDYsydzUzMCSZMMcQIbFww0L_A02zDIxxTLFzIJUwxJAhtXDDfOPABtmkWpinJRsSaJheSxAkqEBSAHNmw91XTDYwOREA1PTtDSyDFwAMXA_NOwWgQ00NzSzTEk1I8vAAxAD70MMDJkMNtDYMsUyNdmALAMfQAyEJZUeSBgmmaWkJWJ1YRYADpWm3A
[2023-09-22T03:14:34.175Z INFO]: There are 100 changes to process
[2023-09-22T03:14:34.177Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:34.216Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:34.216Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:34.223Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:34.290Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:34.290Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:34.298Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:34.328Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:34.328Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:34.328Z DEBUG]: Downloading CouchDB changes feed from 691693-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYg_7mAsXY00yTjIxSU7HpwWNSkgKQTLKHGxZgCDYsydzUzMCSZMMcQIbFI1zGCzbMMjHFMsXMglTDEkCG1cMN888AG2aRamKclGxJomF5LECSoQFIAc2bDzEwMBVsYHKigalpWhpZBi6AGLgfGnbrwAaaG5pZpqSakWXgAYiB9yEGhiwEG2hsmWKZmmxAloEPIAbCImQaJAyTzFLSErG6MAsA_9OmVw
[2023-09-22T03:14:34.460Z INFO]: There are 100 changes to process
[2023-09-22T03:14:34.460Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:34.496Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:34.496Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:34.503Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:34.628Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:34.628Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:34.636Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:34.657Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:34.657Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:34.658Z DEBUG]: Downloading CouchDB changes feed from 691802-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYg3lzgWLsaaZJRkapqdj04DEpSQFIJtnDDQtwBBuWZG5qZmBJsmEOIMPi4YYFSYENs0xMsUwxsyDVsASQYfVww_xLwIZZpJoYJyVbkmhYHguQZGgAUkDz5kMMDIQYmJxoYGqalkaWgQsgBu6Hht1OsIHmhmaWKalmZBl4AGLgfYiBIRvBBhpbplimJhuQZeADiIGwCFkACcMks5S0RKwuzAIAQeylxQ
[2023-09-22T03:14:34.808Z INFO]: There are 100 changes to process
[2023-09-22T03:14:34.808Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:34.860Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:34.860Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:34.867Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:34.943Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:34.943Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:34.953Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:34.980Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:34.980Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:34.981Z DEBUG]: Downloading CouchDB changes feed from 691922-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYgxVygWLsaaZJRkapqdj04DEpSQFIJtnDDQsIBBuWZG5qZmBJsmEOIMPi4YYF6YMNs0xMsUwxsyDVsASQYfVww_zrwIZZpJoYJyVbkmhYHguQZGgAUkDz5kMMDGwDG5icaGBqmpZGloELIAbuh4bdEbCB5oZmlimpZmQZeABi4H2IgSGHwQYaW6ZYpiYbkGXgA4iBsAhZDgnDJLOUtESsLswCAOQ4pj0
[2023-09-22T03:14:35.127Z INFO]: There are 100 changes to process
[2023-09-22T03:14:35.127Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:35.211Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:35.211Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:35.219Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:35.285Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:35.285Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:35.292Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:35.310Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:35.311Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:35.312Z DEBUG]: Downloading CouchDB changes feed from 692061-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYg41ygWLsaaZJRkapqdj04DEpSQFIJtnDDQtIAhuWZG5qZmBJsmEOIMPi4YYFuYMNs0xMsUwxsyDVsASQYfVww_x7wYZZpJoYJyVbkmhYHguQZGgAUkDz5kMMDJwONjA50cDUNC2NLAMXQAzcDw27y2ADzQ3NLFNSzcgy8ADEwPsQA0Mugg00tkyxTE02IMvABxADYRGyCxKGSWYpaYlYXZgFAJQkpsg
[2023-09-22T03:14:35.462Z INFO]: There are 100 changes to process
[2023-09-22T03:14:35.463Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:35.515Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:35.515Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:35.520Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:35.587Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:35.587Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:35.594Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:35.618Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:35.618Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:35.619Z DEBUG]: Downloading CouchDB changes feed from 692207-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYg31ygWLsaaZJRkapqdj04DEpSQFIJtnDDQsoBBuWZG5qZmBJsmEOIMPi4YYFRYANs0xMsUwxsyDVsASQYfVww_zngQ2zSDUxTkq2JNGwPBYgydAApIDmzYcYGLgObGByooGpaVoaWQYugBi4Hxp2t8EGmhuaWaakmpFl4AGIgfchBoY8BRtobJlimZpsQJaBDyAGwiLkHCQMk8xS0hKxujALAE1Vp1o
[2023-09-22T03:14:35.753Z INFO]: There are 100 changes to process
[2023-09-22T03:14:35.754Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:35.826Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:35.826Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:35.837Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:35.920Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:35.920Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:35.926Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:35.960Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:35.960Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:35.960Z DEBUG]: Downloading CouchDB changes feed from 692332-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYgxNygWLsaaZJRkapqdj04DEpSQFIJtnDDQtoAxuWZG5qZmBJsmEOIMPi4YYFpYMNs0xMsUwxsyDVsASQYfVww_zXgg2zSDUxTkq2JNGwPBYgydAApIDmzYcYGLgfbGByooGpaVoaWQYugBi4Hxp2z8EGmhuaWaakmpFl4AGIgfchBoa8BxtobJlimZpsQJaBDyAGwiLkLiQMk8xS0hKxujALAPXhp9c
[2023-09-22T03:14:36.132Z INFO]: There are 100 changes to process
[2023-09-22T03:14:36.133Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:36.176Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:36.177Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:36.182Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:36.249Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:36.249Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:36.257Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:36.277Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:36.277Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:36.278Z DEBUG]: Downloading CouchDB changes feed from 692450-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYg4tzgWLsaaZJRkapqdj04DEpSQFIJtnDDQuYATYsydzUzMCSZMMcQIbFww0LqgIbZpmYYpliZkGqYQkgw-rhhvnvBRtmkWpinJRsSaJheSxAkqEBSAHNmw8xMPA02MDkRANT07Q0sgxcADFwPzTsvoENNDc0s0xJNSPLwAMQA-9DDAz5DTbQ2DLFMjXZgCwDH0AMhEXIE0gYJpmlpCVidWEWAJsaqE0
[2023-09-22T03:14:36.411Z INFO]: There are 100 changes to process
[2023-09-22T03:14:36.411Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:36.478Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:36.478Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:36.485Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:36.539Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:36.539Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:36.551Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:36.659Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:36.659Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:36.660Z DEBUG]: Downloading CouchDB changes feed from 692565-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYg6tzgWLsaaZJRkapqdj04DEpSQFIJtnDDQtYCjYsydzUzMCSZMMcQIbFww0LmgA2zDIxxTLFzIJUwxJAhtXDDfM_DzbMItXEOCnZkkTD8liAJEMDkAKaNx9iYOA9sIHJiQampmlpZBm4AGLgfqiBbGADzQ3NLFNSzcgy8ADEwPsQA0OZwAYaW6ZYpiYbkGXgA4iBsAj5AAnDJLOUtESsLswCAPXGpsI
[2023-09-22T03:14:36.777Z INFO]: There are 100 changes to process
[2023-09-22T03:14:36.778Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:36.816Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:36.816Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:36.823Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:36.901Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:36.901Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:36.907Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:36.930Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:36.930Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:36.931Z DEBUG]: Downloading CouchDB changes feed from 692691-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYg3tygWLsaaZJRkapqdj04DEpSQFIJtnDDQvYCDYsydzUzMCSZMMcQIbFww0LWgI2zDIxxTLFzIJUwxJAhtXDDfO_DzbMItXEOCnZkkTD8liAJEMDkAKaNx9iYOBnsIHJiQampmlpZBm4AGLgfqiBEmADzQ3NLFNSzcgy8ADEwPsQA0N5wAYaW6ZYpiYbkGXgA4iBsAj5AwnDJLOUtESsLswCAJflp0A
[2023-09-22T03:14:37.053Z INFO]: There are 100 changes to process
[2023-09-22T03:14:37.054Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:37.092Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:37.093Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:37.107Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:37.176Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:37.176Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:37.180Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:37.195Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:37.195Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:37.196Z DEBUG]: Downloading CouchDB changes feed from 692818-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYgxfkAsXY00yTjIxSU7HpwWNSkgKQTLKHGxZwFGxYkrmpmYElyYY5gAyLhxsWtAFsmGViimWKmQWphiWADKuHG-b_BWyYRaqJcVKyJYmG5bEASYYGIAU0bz7UdSxgA5MTDUxN09LIMnABxMD9EAMDNcEGmhuaWaakmpFl4AGIgfchBoaKgA00tkyxTE02IMvABxADYUmFAxKGSWYpaYlYXZgFAA59pcE
[2023-09-22T03:14:37.358Z INFO]: There are 100 changes to process
[2023-09-22T03:14:37.358Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:37.407Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:37.407Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:37.415Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:37.473Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:37.473Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:37.487Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:37.504Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:37.504Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:37.505Z DEBUG]: Downloading CouchDB changes feed from 692945-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYg7fmAsXY00yTjIxSU7HpwWNSkgKQTLKHGxZwHWxYkrmpmYElyYY5gAyLhxsWtAtsmGViimWKmQWphiWADKtHuIwdbJhFqolxUrIliYblsQBJhgYgBTRvPtR1QmADkxMNTE3T0sgycAHEwP0QAwONwQaaG5pZpqSakWXgAYiB9yEGhmqADTS2TLFMTTYgy8AHEANhSUUcEoZJZilpiVhdmAUAS36lQQ
[2023-09-22T03:14:37.603Z INFO]: There are 100 changes to process
[2023-09-22T03:14:37.603Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:37.645Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:37.645Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:37.650Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:37.730Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:37.730Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:37.736Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:37.758Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:37.758Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:37.759Z DEBUG]: Downloading CouchDB changes feed from 693078-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYg8_mAsXY00yTjIxSU7HpwWNSkgKQTLKHGxbwHGxYkrmpmYElyYY5gAyLhxsWdAZsmGViimWKmQWphiWADKtHuEwWbJhFqolxUrIliYblsQBJhgYgBTRvPtR1cmADkxMNTE3T0sgycAHEwP0QAwMdwAaaG5pZpqSakWXgAYiB9yEGhlqBDTS2TLFMTTYgy8AHEANhSUUREoZJZilpiVhdmAUAAHmlxg
[2023-09-22T03:14:37.862Z INFO]: There are 100 changes to process
[2023-09-22T03:14:37.862Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:37.905Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:37.905Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:37.910Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:37.966Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:37.966Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:37.972Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:37.990Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:37.990Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:37.990Z DEBUG]: Downloading CouchDB changes feed from 693211-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYg2_nAsXY00yTjIxSU7HpwWNSkgKQTLKHGxbwE2xYkrmpmYElyYY5gAyLhxsWdBdsmGViimWKmQWphiWADKtHuEwDbJhFqolxUrIliYblsQBJhgYgBTRvPtR1hmADkxMNTE3T0sgycAHEwP0QAwMDwQaaG5pZpqSakWXgAYiB9yEGhvqADTS2TLFMTTYgy8AHEANhScUEEoZJZilpiVhdmAUAnSOmSw
[2023-09-22T03:14:38.097Z INFO]: There are 100 changes to process
[2023-09-22T03:14:38.097Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:38.140Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:38.140Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:38.149Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:38.211Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:38.211Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:38.216Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:38.233Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:38.233Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:38.233Z DEBUG]: Downloading CouchDB changes feed from 693345-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYg9_mAsXY00yTjIxSU7HpwWNSkgKQTLKHGxbIAzYsydzUzMCSZMMcQIbFww0LgrjMMjHFMsXMglTDEkCG1cMNCzAHG2aRamKclGxJomF5LECSoQFIAc2bD3WdK9jA5EQDU9O0NLIMXAAxcD807NLBBpobmlmmpJqRZeABiIH3IQaGRoINNLZMsUxNNiDLwAcQA2FJxR4ShklmKWmJWF2YBQBMcqXS[2023-09-22T03:14:38.332Z INFO]: There are 100 changes to process
[2023-09-22T03:14:38.332Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:38.379Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:38.379Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:38.384Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:38.454Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:38.454Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:38.462Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:38.483Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:38.483Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:38.483Z DEBUG]: Downloading CouchDB changes feed from 693470-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYg__nAsXY00yTjIxSU7HpwWNSkgKQTLKHGxYoDTYsydzUzMCSZMMcQIbFww0L-g02zDIxxTLFzIJUwxJAhtXDDQtwAxtmkWpinJRsSaJheSxAkqEBSAHNmw91XQTYwOREA1PTtDSyDFwAMXA_NOxKwAaaG5pZpqSakWXgAYiB9yEGhuaADTS2TLFMTTYgy8AHEANhScUbEoZJZilpiVhdmAUA6USmTw
[2023-09-22T03:14:38.574Z INFO]: There are 100 changes to process
[2023-09-22T03:14:38.575Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:38.619Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:38.619Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:38.626Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:38.698Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:38.698Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:38.710Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:38.738Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:38.738Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:38.739Z DEBUG]: Downloading CouchDB changes feed from 693587-g1AAAAJ7eJyd0UsKwjAQANBoBd2JJ9ATSD8mbVb2Bv7BnXbyoZSqK9ftTfQmehO9SU0T7aoILYEJzDCPYSZFCA1ii6MRu1xZzCF0XH9qq-ekqtSNEIyLokhiC1BnOzypXF9icF0h6nr-SDBREeYVtnI0Bj4mNm2MhSV2qLDNQGM04pSToCl2LLGswpYLjQVi5gGjDbFzT0WUq095NwOuhQZZZGMsZSvwbsDHd3eZBn2HUC5IK_BpwJcBd7kGPcqpYHYr8G3A30H2ZodAuIxqJ0w-gcmkxg
[2023-09-22T03:14:38.877Z INFO]: There are 100 changes to process
[2023-09-22T03:14:38.877Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:38.921Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:38.921Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:38.929Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:38.997Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:38.997Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:39.009Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:39.025Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:39.025Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:39.026Z DEBUG]: Downloading CouchDB changes feed from 693697-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ2RygWLsaaZJRkapqdj04DEpSQFIJtnDDQt0BhuWZG5qZmBJsmEOIMPi4YYFi4ENs0xMsUwxyDVsASQYfVwwwISwIZZpJoYJyVbkmhYHguQZGgAUkDz5kMMDCoDG5icaGBqmpZGloELIAbuh4ZdD9hAc0Mzy5RUM7IMPAAx8D7EwNAusIHGlimWqckGZBn4AGIgLEKgYZhklpKWiNWFWQAVOKU0
[2023-09-22T03:14:39.149Z INFO]: There are 100 changes to process
[2023-09-22T03:14:39.149Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:39.187Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:39.188Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:39.195Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:39.266Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:39.266Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:39.272Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:39.289Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:39.289Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:39.289Z DEBUG]: Downloading CouchDB changes feed from 693816-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ3RygWLsaaZJRkapqdj04DEpSQFIJtnDDQuMABuWZG5qZmBJsmEOIMPi4YYFq4ANs0xMsUwxsyDVsASQYfVwwwJywIZZpJoYJyVbkmhYHguQZGgAUkDz5kMMDGoCG5icaGBqmpZGloELIAbuh4bdHLCB5oZmlimpZmQZeABi4H2IgaEzwQYaW6ZYpiYbkGXgA4iBsAjJhYRhkllKWiJWF2YBAK5Npas

Marcelo_De_Guzman · September 22, 2023, 3:18am

For part_2

[2023-09-22T03:14:39.384Z INFO]: There are 100 changes to process
[2023-09-22T03:14:39.384Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:39.442Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:39.442Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:39.452Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:39.514Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:39.515Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:39.521Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:39.539Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:39.539Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:39.540Z DEBUG]: Downloading CouchDB changes feed from 693929-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ6xzgWLsaaZJRkapqdj04DEpSQFIJtnDDQvMAhuWZG5qZmBJsmEOIMPi4YYF64ENs0xMsUwxsyDVsASQYfVwwwJqwYZZpJoYJyVbkmhYHguQZGgAUkDz5kMMDOoHG5icaGBqmpZGloELIAbuh4bdCrCB5oZmlimpZmQZeABi4H2IgaGLwQYaW6ZYpiYbkGXgA4iBsAiph4RhkllKWiJWF2YBADvGphw
[2023-09-22T03:14:39.625Z INFO]: There are 100 changes to process
[2023-09-22T03:14:39.626Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:39.674Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:39.674Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:39.681Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:39.744Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:39.744Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:39.751Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:39.766Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:39.766Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:39.767Z DEBUG]: Downloading CouchDB changes feed from 694033-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ_xygWLsaaZJRkapqdj04DEpSQFIJtnDDQssBxuWZG5qZmBJsmEOIMPi4YYFW4MNs0xMsUwxsyDVsASQYfVwwwJ6wIZZpJoYJyVbkmhYHguQZGgAUkDz5kMMDJoFNjA50cDUNC2NLAMXQAzcDw27DWADzQ3NLFNSzcgy8ADEwPsQA0M3gw00tkyxTE02IMvABxADYRHSAQnDJLOUtESsLswCAMb3poQ
[2023-09-22T03:14:39.856Z INFO]: There are 100 changes to process
[2023-09-22T03:14:39.857Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:39.908Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:39.908Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:39.921Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:39.999Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:39.999Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:40.030Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:40.060Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:40.060Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:40.062Z DEBUG]: Downloading CouchDB changes feed from 694137-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ-JzgWLsaaZJRkapqdj04DEpSQFIJtnDDQtsAhuWZG5qZmBJsmEOIMPi4YYF-4ENs0xMsUwxsyDVsASQYfVwwwLmgw2zSDUxTkq2JNGwPBYgydAApIDmzYcYGLQYbGByooGpaVoaWQYugBi4Hxp2O8AGmhuaWaakmpFl4AGIgfchBobuARtobJlimZpsQJaBDyAGwiJkCiQMk8xS0hKxujALAFR-puw
[2023-09-22T03:14:40.188Z INFO]: There are 100 changes to process
[2023-09-22T03:14:40.188Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:40.228Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:40.229Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:40.242Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:40.305Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:40.305Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:40.312Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:40.332Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:40.332Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:40.333Z DEBUG]: Downloading CouchDB changes feed from 694241-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ_JygWLsaaZJRkapqdj04DEpSQFIJtnDDQucDDYsydzUzMCSZMMcQIbFww0LjgQbZpmYYpliZkGqYQkgw-rhhgWsAxtmkWpinJRsSaJheSxAkqEBSAHNmw8xMAhiYHKigalpWhpZBi6AGLgfGnaHwQaaG5pZpqSakWXgAYiB9yEGhp4FG2hsmWKZmmxAloEPIAbCImQ2JAyTzFLSErG6MAsA3ZCnVA
[2023-09-22T03:14:40.472Z INFO]: There are 100 changes to process
[2023-09-22T03:14:40.473Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:40.529Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:40.529Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:40.537Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:40.607Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:40.607Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:40.617Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:40.637Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:40.637Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:40.638Z DEBUG]: Downloading CouchDB changes feed from 694349-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ-pygWLsaaZJRkapqdj04DEpSQFIJtnDDQtcADYsydzUzMCSZMMcQIbFww0LTgUbZpmYYpliZkGqYQkgw-rhhgXsBhtmkWpinJRsSaJheSxAkqEBSAHNmw8xMAhiYHKigalpWhpZBi6AGLgfGnbXwAaaG5pZpqSakWXgAYiB9yEGht4GG2hsmWKZmmxAloEPIAbCImQxJAyTzFLSErG6MAsAZvinwA
[2023-09-22T03:14:40.744Z INFO]: There are 100 changes to process
[2023-09-22T03:14:40.744Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:40.786Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:40.787Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:40.798Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:40.857Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:40.857Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:40.864Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:40.882Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:40.882Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:40.882Z DEBUG]: Downloading CouchDB changes feed from 694463-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQyblAsXY00yTjIxSU7HpwWNSkgKQTLKHGxa4FmxYkrmpmYElyYY5gAyLhxsWXAA2zDIxxTLFzIJUwxJAhtXDDQs4BjbMItXEOCnZkkTD8liAJEMDkAKaNx9iYNAJsIHJiQampmlpZBm4AGLgfmjYPQMbaG5oZpmSakaWgQcgBt6HGBj6FGygsWWKZWqyAVkGPoAYCIuQ7ZAwTDJLSUvE6sIsAPKGqDI
[2023-09-22T03:14:40.993Z INFO]: There are 100 changes to process
[2023-09-22T03:14:40.993Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:41.064Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:41.064Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:41.070Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:41.143Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:41.143Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:41.150Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:41.166Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:41.166Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:41.167Z DEBUG]: Downloading CouchDB changes feed from 694579-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ1bmAsXY00yTjIxSU7HpwWNSkgKQTLKHGxa4B2xYkrmpmYElyYY5gAyLhxsW3Aw2zDIxxTLFzIJUwxJAhtXDDQu4AjbMItXEOCnZkkTD8liAJEMDkAKaNx9iYNBVsIHJiQampmlpZBm4AGLgfmjYfQIbaG5oZpmSakaWgQcgBt6HGBgKMdDYMsUyNdmALAMfQAyERcg-SBgmmaWkJWJ1YRYAl2Oopg
[2023-09-22T03:14:41.285Z INFO]: There are 100 changes to process
[2023-09-22T03:14:41.286Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:41.320Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:41.320Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:41.327Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:41.380Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:41.380Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:41.388Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:41.406Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:41.406Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:41.408Z DEBUG]: Downloading CouchDB changes feed from 694698-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQw7mAsXY00yTjIxSU7HpwWNSkgKQTLKHGxZ4HGxYkrmpmYElyYY5gAyLhxsWPBlsmGViimWKmQWphiWADKuHGxbwHGyYRaqJcVKyJYmG5bEASYYGIAU0bz7EwKAnYAOTEw1MTdPSyDJwAcTA_VADWcAGmhuaWaakmpFl4AGIgfchBob-AxtobJlimZpsQJaBDyAGwiLkECQMk8xS0hKxujALAHsRqB4
[2023-09-22T03:14:41.503Z INFO]: There are 100 changes to process
[2023-09-22T03:14:41.503Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:41.548Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:41.548Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:41.554Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:41.607Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:41.607Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:41.613Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:41.629Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:41.630Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:41.630Z DEBUG]: Downloading CouchDB changes feed from 694818-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ67kAsXY00yTjIxSU7HpwWNSkgKQTLKHGxZ4B2xYkrmpmYElyYY5gAyLhxsWvBBsmGViimWKmQWphiWADKuHGxbwEWyYRaqJcVKyJYmG5bEASYYGIAU0bz7EwKCfYAOTEw1MTdPSyDJwAcTA_VADhcAGmhuaWaakmpFl4AGIgfchBoZxgg00tkyxTE02IMvABxADYRFyBhKGSWYpaYlYXZgFAKu4p5c
[2023-09-22T03:14:41.748Z INFO]: There are 100 changes to process
[2023-09-22T03:14:41.748Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:41.791Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:41.791Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:41.798Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:41.856Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:41.856Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:41.860Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:41.874Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:41.874Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:41.874Z DEBUG]: Downloading CouchDB changes feed from 694946-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ57nAsXY00yTjIxSU7HpwWNSkgKQTLKHGxb4BWxYkrmpmYElyYY5gAyLhxsWvANsmGViimWKmQWphiWADKuHGxbwG2yYRaqJcVKyJYmG5bEASYYGIAU0bz7UdexgA5MTDUxN09LIMnABxMD9EAODZMAGmhuaWaakmpFl4AGIgfchBobJgg00tkyxTE02IMvABxADYRFyBRKGSWYpaYlYXZgFAElwpxg
[2023-09-22T03:14:41.963Z INFO]: There are 100 changes to process
[2023-09-22T03:14:41.963Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:42.004Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:42.004Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:42.027Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:42.106Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:42.106Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:42.112Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:42.130Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:42.130Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:42.132Z DEBUG]: Downloading CouchDB changes feed from 695092-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ77mAsXY00yTjIxSU7HpwWNSkgKQTLKHGxbEDTYsydzUzMCSZMMcQIbFww0LvgQ2zDIxxTLFzIJUwxJAhtXDDQvkARtmkWpinJRsSaJheSxAkqEBSAHNmw91nSLYwOREA1PTtDSyDFwAMXA_NOx0wAaaG5pZpqSakWXgAYiB9yEGhmmADTS2TLFMTTYgy8AHEANhEfIQEoZJZilpiVhdmAUAp-KlrA
[2023-09-22T03:14:42.239Z INFO]: There are 100 changes to process
[2023-09-22T03:14:42.240Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:42.290Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:42.290Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:42.295Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:42.377Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:42.377Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:42.383Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:42.397Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:42.397Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:42.398Z DEBUG]: Downloading CouchDB changes feed from 695213-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ37kAsXY00yTjIxSU7HpwWNSkgKQTLKHGxYkDTYsydzUzMCSZMMcQIbFww0LfgQ2zDIxxTLFzIJUwxJAhtXDDQuUABtmkWpinJRsSaJheSxAkqEBSAHNmw91nQ3YwOREA1PTtDSyDFwAMXA_NOzMwQaaG5pZpqSakWXgAYiB9yEGhlmBDTS2TLFMTTYgy8AHEANhEfIZEoZJZilpiVhdmAUAKu2mJQ
[2023-09-22T03:14:42.519Z INFO]: There are 100 changes to process
[2023-09-22T03:14:42.519Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:42.558Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:42.558Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:42.562Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:42.629Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:42.629Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:42.634Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:42.647Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:42.647Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:42.647Z DEBUG]: Downloading CouchDB changes feed from 695339-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ37kAsXY00yTjIxSU7HpwWNSkgKQTLKHGxakADYsydzUzMCSZMMcQIbFww0L_gQ2zDIxxTLFzIJUwxJAhtXDDQs0BhtmkWpinJRsSaJheSxAkqEBSAHNmw91XRjYwOREA1PTtDSyDFwAMXA_NOw8wAaaG5pZpqSakWXgAYiB9yEGhnmBDTS2TLFMTTYgy8AHEANhSYUNEoZJZilpiVhdmAUAht6lpA
[2023-09-22T03:14:42.766Z INFO]: There are 100 changes to process
[2023-09-22T03:14:42.766Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:42.812Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:42.812Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:42.818Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:42.886Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:42.886Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:42.891Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:42.911Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:42.911Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:42.912Z DEBUG]: Downloading CouchDB changes feed from 695463-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ37kAsXY00yTjIxSU7HpwWNSkgKQTLKHGxakADYsydzUzMCSZMMcQIbFI1zGAzbMMjHFMsXMglTDEkCG1cMNCwwCG2aRamKclGxJomF5LECSoQFIAc2bDzEwOBVsYHKigalpWhpZBi6AGLgfGnaRYAPNDc0sU1LNyDLwAMTA-xADw5LBBhpbplimJhuQZeADiIGwCBGAhGGSWUpaIlYXZgEAVtmlIQ
[2023-09-22T03:14:42.987Z INFO]: There are 100 changes to process
[2023-09-22T03:14:42.988Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:43.038Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:43.038Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:43.043Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:43.101Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:43.101Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:43.108Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:43.126Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:43.126Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:43.127Z DEBUG]: Downloading CouchDB changes feed from 695586-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ37kAsXY00yTjIxSU7HpwWNSkgKQTLKHGxakADYsydzUzMCSZMMcQIbFI1zGAzbMMjHFMsXMglTDEkCG1cMNCywCG2aRamKclGxJomF5LECSoQFIAc2bDzEwOBVsYHKigalpWhpZBi6AGLgfGnYVYAPNDc0sU1LNyDLwAMTA-xADwxrABhpbplimJhuQZeADiIGwCNGHhGGSWUpaIlYXZgEArHqlnA
[2023-09-22T03:14:43.217Z INFO]: There are 100 changes to process
[2023-09-22T03:14:43.217Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:43.253Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:43.253Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:43.257Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:43.320Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:43.321Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:43.324Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:43.342Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:43.342Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:43.343Z DEBUG]: Downloading CouchDB changes feed from 695729-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ37kAsXY00yTjIxSU7HpwWNSkgKQTLKHGxakADYsydzUzMCSZMMcQIbFI1zGAzbMMjHFMsXMglTDEkCG1cMNCywCG2aRamKclGxJomF5LECSoQFIAc2bDzEwOBVsYHKigalpWhpZBi6AGLgfGnZLwQaaG5pZpqSakWXgAYiB9yEGhu0CG2hsmWKZmmxAloEPIAbCIiQcEoZJZilpiVhdmAUA7kymKw
[2023-09-22T03:14:43.424Z INFO]: There are 100 changes to process
[2023-09-22T03:14:43.424Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:43.460Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:43.460Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:43.462Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:43.517Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:43.517Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:43.521Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:43.542Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:43.542Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:43.542Z DEBUG]: Downloading CouchDB changes feed from 695875-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ37kAsXY00yTjIxSU7HpwWNSkgKQTLKHGxakADYsydzUzMCSZMMcQIbFI1zGAzbMMjHFMsXMglTDEkCG1cMNCywCG2aRamKclGxJomF5LECSoQFIAc2bDzEwOBVsYHKigalpWhpZBi6AGLgfGnavwQaaG5pZpqSakWXgAYiB9yEGhp0BG2hsmWKZmmxAloEPIAbCImQiJAyTzFLSErG6MAsAM72mvQ
[2023-09-22T03:14:43.559Z INFO]: There are 6 changes to process
[2023-09-22T03:14:43.559Z DEBUG]: There are 0 deletions and 6 new / changed documents
[2023-09-22T03:14:43.578Z DEBUG]: Pulled 6 results from couchdb
[2023-09-22T03:14:43.578Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:43.579Z DEBUG]: Inserting 6 results into postgresql
[2023-09-22T03:14:43.583Z DEBUG]: Batch completed with 6 changes
[2023-09-22T03:14:43.583Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:43.584Z DEBUG]: Downloading CouchDB changes feed from 695882-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxgYQ37kAsXY00yTjIxSU7HpwWNSkgKQTLKHGxakADYsydzUzMCSZMMcQIbFI1zGAzbMMjHFMsXMglTDEkCG1cMNCywCG2aRamKclGxJomF5LECSoQFIAc2bDzEwOBVsYHKigalpWhpZBi6AGLgfGnafwAaaG5pZpqSakWXgAYiB9yEGhp0BG2hsmWKZmmxAloEPIAbCImQiJAyTzFLSErG6MAsAORmmxA
[2023-09-22T03:14:43.598Z INFO]: There are 0 changes to process
[2023-09-22T03:14:43.600Z DEBUG]: Import loop complete, 3506 changes total
[2023-09-22T03:14:43.600Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:43.601Z DEBUG]: Downloading CouchDB changes feed from 1073915-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxiYePNzgWLsSYbGxmZmptj04DEpSQFIJtnDDRPoBRtmnmZsZm6ZSqphDiDD4hEu2wZ1mbmxqVEKqYYlgAyrhxvGthFsmGlSmqmJpSWJhuWxAEmGBiAFNG8-xECOWWADE02ME40tLcgycAHEwP0QA3n-gg1MTjU3NLNIIsvAAxAD70PDrwFsoEWaUWpiYhpZBj6AGAiLkEaICy0MDYySjbBpzQIAupakCQ
[2023-09-22T03:14:43.713Z INFO]: There are 100 changes to process
[2023-09-22T03:14:43.713Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:43.742Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:43.742Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:43.747Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:43.792Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:43.792Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:43.797Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:43.806Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:43.806Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:43.807Z DEBUG]: Downloading CouchDB changes feed from 1074127-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxiYeHtygWLsSYbGxmZmptj04DEpSQFIJtnDDRNYBzbMPM3YzNwylVTDHECGxSNcdhHqMnNjU6MUUg1LABlWDzeM7RTYMNOkNFMTS0sSDctjAZIMDUAKaN58iIEcq8EGJpoYJxpbWpBl4AKIgfuh3pUFG5icam5oZpFEloEHIAbehxo4D2ygRZpRamJiGlkGPoAYCIuQKRAXWhgaGCUbYdOaBQAH36Pe
[2023-09-22T03:14:43.931Z INFO]: There are 100 changes to process
[2023-09-22T03:14:43.931Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:43.976Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:43.976Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:43.981Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:44.025Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:44.026Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:44.032Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:44.038Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:44.038Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:44.039Z DEBUG]: Downloading CouchDB changes feed from 1074293-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxiYeFfmAsXYkwyNjc3MTLHpwWNSkgKQTLKHGyZwFGyYeZqxmbllKqmGOYAMi0e47BnUZebGpkYppBqWADKsHm4Y2z2wYaZJaaYmlpYkGpbHAiQZGoAU0Lz5EAM5joANTDQxTjS2tCDLwAUQA_dDvasDNjA51dzQzCKJLAMPQAy8DzVwE9hAizSj1MTENLIMfAAxEBYhCyEutDA0MEo2wqY1CwDpfqSE
[2023-09-22T03:14:44.147Z INFO]: There are 100 changes to process
[2023-09-22T03:14:44.147Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:44.196Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:44.196Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:44.202Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:44.259Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:44.259Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:44.263Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:44.271Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:44.271Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:44.271Z DEBUG]: Downloading CouchDB changes feed from 1074475-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxiYeI_nAsXYkwyNjc3MTLHpwWNSkgKQTLKHGybwEGyYeZqxmbllKqmGOYAMi0e47AfUZebGpkYppBqWADKsHm4Y2x-wYaZJaaYmlpYkGpbHAiQZGoAU0Lz5EAM5roANTDQxTjS2tCDLwAUQA_dDvesENjA51dzQzCKJLAMPQAy8DzXwENhAizSj1MTENLIMfAAxEBYh2yEutDA0MEo2wqY1CwDbYaU6
[2023-09-22T03:14:44.361Z INFO]: There are 100 changes to process
[2023-09-22T03:14:44.361Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:44.397Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:44.397Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:44.403Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:44.453Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:44.453Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:44.458Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:44.472Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:44.472Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:44.473Z DEBUG]: Downloading CouchDB changes feed from 1074693-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxiYeJ_nAsXYkwyNjc3MTLHpwWNSkgKQTLKHGybwHWyYeZqxmbllKqmGOYAMi4cbxicFdZm5salRCqmGJYAMq4cbxs4JNsw0Kc3UxNKSRMPyWIAkQwOQApo3H2Igxw-wgYkmxonGlhZkGbgAYuB-aEREgg1MTjU3NLNIIsvAAxAD70MNvAU20CLNKDUxMY0sAx9ADIQllZsQF1oYGhglG2HTmgUAzs6kFg

Marcelo_De_Guzman · September 22, 2023, 3:19am

For part_3

[2023-09-22T03:14:44.569Z INFO]: There are 100 changes to process
[2023-09-22T03:14:44.569Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:44.627Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:44.627Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:44.632Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:44.673Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:44.673Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:44.678Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:44.688Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:44.689Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:44.690Z DEBUG]: Downloading CouchDB changes feed from 1074912-g1AAAAJ7eJyd0MEKgkAQBuBFA-1g4BPUsVO4u-qup3yT2lEXEatT56IXqTepN6lH6NLZVlfsIoGyMAMzzMfPlgghOzdT5CaHY5KnEGPCVp56uFQrQyCYV1VV5CYgY2bv1MwCTGkYBn03fyRYqArrDnM1xiQNWZQNxeIa2_ySeW0yRgOSDsW2NXbqMGvZYAHIwI-igdh-oio6q6a8qwanbgMKnwoa8VHgTYN3DTqXBkwyhkMOo8CHBp8t-GlALkkmhBwFvjTY_qHz1gk59khC-k6LL3pAofQ[2023-09-22T03:14:44.811Z INFO]: There are 100 changes to process
[2023-09-22T03:14:44.811Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:44.864Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:44.864Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:44.870Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:44.912Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:44.912Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:44.917Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:44.927Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:44.927Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:44.928Z DEBUG]: Downloading CouchDB changes feed from 1075122-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxiY-KRzgWLsSYbGxmZmptj04DEpSQFIJtnDDRPUARtmnmZsZm6ZSqphDiDD4hEuC4S6zNzY1CiFVMMSQIbVww1jdwQbZpqUZmpiaUmiYXksQJKhAUgBzZsPMZBTF2xgoolxorGlBVkGLoAYuB9iIG8_2MDkVHNDM4sksgw8ADHwPjT8uMAGWqQZpSYmppFl4AOIgbAIEYa40MLQwCjZCJvWLADq7KDI
[2023-09-22T03:14:45.443Z INFO]: There are 100 changes to process
[2023-09-22T03:14:45.443Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:45.476Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:45.476Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:45.481Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:45.530Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:45.530Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:45.536Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:45.545Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:45.545Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:45.546Z DEBUG]: Downloading CouchDB changes feed from 1075322-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxiY-MxygWLsSYbGxmZmptj04DEpSQFIJtnDDRN0BhtmnmZsZm6ZSqphDiDD4hEuS4C6zNzY1CiFVMMSQIbVww1jDwMbZpqUZmpiaUmiYXksQJKhAUgBzZsPMZDTH2xgoolxorGlBVkGLoAYuB9iIO9SsIHJqeaGZhZJZBl4AGLgfWj4GYANtEgzSk1MTCPLwAcQA2ERog5xoYWhgVGyETatWQDXUaGQ
[2023-09-22T03:14:45.637Z INFO]: There are 100 changes to process
[2023-09-22T03:14:45.637Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:45.668Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:45.668Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:45.673Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:45.712Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:45.712Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:45.717Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:45.725Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:45.725Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:45.725Z DEBUG]: Downloading CouchDB changes feed from 1075481-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxiY-HxygWLsSYbGxmZmptj04DEpSQFIJtnDDRP0BxtmnmZsZm6ZSqphDiDD4hEua4a6zNzY1CiFVMMSQIbVww1jzwQbZpqUZmpiaUmiYXksQJKhAUgBzZsPMZAzDmxgoolxorGlBVkGLoAYuB9iIO92sIHJqeaGZhZJZBl4AGLgfWj4uYANtEgzSk1MTCPLwAcQA2ERYglxoYWhgVGyETatWQChbKIv
[2023-09-22T03:14:45.811Z INFO]: There are 100 changes to process
[2023-09-22T03:14:45.812Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:45.847Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:45.847Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:45.854Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:45.897Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:45.897Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:45.901Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:45.909Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:45.909Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:45.910Z DEBUG]: Downloading CouchDB changes feed from 1075653-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxiY-LJzgWLsSYbGxmZmptj04DEpSQFIJtnDDRPMABtmnmZsZm6ZSqphDiDD4hEumwV1mbmxqVEKqYYlgAyrhxvGXg82zDQpzdTE0pJEw_JYgCRDA5ACmjcfYiBnEdjARBPjRGNLC7IMXAAxcD_EQN7DYAOTU80NzSySyDLwAMTA-9DwCwIbaJFmlJqYmEaWgQ8gBv5HMTDZwtDAKNkIm9YsAIkXots[2023-09-22T03:14:45.988Z INFO]: There are 100 changes to process
[2023-09-22T03:14:45.988Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:46.021Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:46.021Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:46.025Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:46.072Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:46.072Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:46.077Z DEBUG]: Inserting 50 reults into postgresql
[2023-09-22T03:14:46.088Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:46.088Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:46.089Z DEBUG]: Downloading CouchDB changes feed from 1075858-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxiY-BpzgWLsSYbGxmZmptj04DEpSQFIJtnDDRNsBhtmnmZsZm6ZSqphDiDD4hEu2wl1mbmxqVEKqYYlgAyrhxvGPglsmGlSmqmJpSWJhuWxAEmGBiAFNG8-xEDOPrCBiSbGicaWFmQZuABi4H6Igbx3wQYmp5obmlkkkWXgAYiB96HhlwI20CLNKDUxMY0sAx9ADIRFSAnEhRaGBkbJRti0ZgEAf9GjqA
[2023-09-22T03:14:46.179Z INFO]: There are 100 changes to process
[2023-09-22T03:14:46.179Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:46.215Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:46.215Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:46.220Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:46.259Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:46.259Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:46.264Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:46.271Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:46.271Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:46.271Z DEBUG]: Downloading CouchDB changes feed from 1076053-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxiY-GbnAsXYkwyNjc3MTLHpwWNSkgKQTLKHGya4AGyYeZqxmbllKqmGOYAMi0e47DLUZebGpkYppBqWADKsHm4Y-wqwYaZJaaYmlpYkGpbHAiQZGoAU0Lz5EAM5l4ENTDQxTjS2tCDLwAUQA_dDDOT9AjYwOdXc0MwiiSwDD0AMvA8Nv1KwgRZpRqmJiWlkGfgAYiAsQiZAXGhhaGCUbIRNaxYAd5Okaw
[2023-09-22T03:14:46.363Z INFO]: There are 100 changes to process
[2023-09-22T03:14:46.363Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:46.392Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:46.392Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:46.397Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:46.442Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:46.442Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:46.447Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:46.456Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:46.456Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:46.457Z DEBUG]: Downloading CouchDB changes feed from 1076256-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxiY-PblAsXYkwyNjc3MTLHpwWNSkgKQTLKHGya4BWyYeZqxmbllKqmGOYAMi0e47AvUZebGpkYppBqWADKsHm4Y-16wYaZJaaYmlpYkGpbHAiQZGoAU0Lz5EAM5D4INTDQxTjS2tCDLwAUQA_dDvcsLNjA51dzQzCKJLAMPQAy8DzWwB2ygRZpRamJiGlkGPoAYCIuQxRAXWhgaGCUbYdOaBQC_hqQ3
[2023-09-22T03:14:46.549Z INFO]: There are 100 changes to process
[2023-09-22T03:14:46.549Z DEBUG]: There are 0 deletions and 100 new / changed documents
[2023-09-22T03:14:46.594Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:46.594Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:46.600Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:46.644Z DEBUG]: Pulled 50 results from couchdb
[2023-09-22T03:14:46.644Z DEBUG]: Clearing any existing documents from postgresql
[2023-09-22T03:14:46.648Z DEBUG]: Inserting 50 results into postgresql
[2023-09-22T03:14:46.658Z DEBUG]: Batch completed with 100 changes
[2023-09-22T03:14:46.658Z DEBUG]: Performing an import batch of up to 100 changes
[2023-09-22T03:14:46.658Z DEBUG]: Downloading CouchDB changes feed from 1076462-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxiY-K7nAsXYkwyNjc3MTLHpwWNSkgKQTLKHGyZ4CmyYeZqxmbllKqmGOYAMi4cbxi8GdZm5salRCqmGJYAMq4cbxn4LbJhpUpqpiaUliYblsQBJhgYgBTRvPsRAzttgAxNNjBONLS3IMnABxMD90IhQAxuYnGpuaGaRRJaBByAG3ocaOBdsoEWaUWpiYhpZBj6AGAhLKvshLrQwNDBKNsKmNQsAELSkBg

yuv · September 26, 2023, 9:36pm

Hi @Marcelo_De_Guzman , the error on couch2pg suggests that the user that is running couch2pg doesn’t have access to some objects. In this case its throwing error for useview_telemetry . You can change the ownership of these objects by using sql like below:

ALTER MATERIALIZED VIEW useview_telemetry OWNER TO user_group;

Here, you need to replace user_group by the user name or user group for a postgres user that you configured on couch2pg.

Marcelo_De_Guzman · September 27, 2023, 12:03am

@binod ,

for this docker-compose.yml file,

is the COUCHDB_URL is correct ?

or there are mistagging of credentials here, so that is why it was not working properly?

we have:

couch2pg.env and docker-compose.yml, what is the main file key to run the couchdb to be sync?

yuv · September 27, 2023, 2:09pm

Hi @Marcelo_De_Guzman ,

[2023-09-22T03:14:46.457Z DEBUG]: Downloading CouchDB changes feed from 1076256-g1AAAAJ7eJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____szKYkxiY-PblAsXYkwyNjc3MTLHpwWNSkgKQTLKHGya4BWyYeZqxmbllKqmGOYAMi0e47AvUZebGpkYppBqWADKsHm4Y-

If you’re seeing log like this that you posted, it means both your couchdb and postgres url are pointing right. Did you try making this change that I suggested above ?

Marcelo_De_Guzman · October 13, 2023, 7:52am

Hi @yuv ,

Still not syncing automatically.

Do you have any recommendations on this one?

Thanks

Marcelo_De_Guzman · October 19, 2023, 2:26am

Hi @yuv ,

Yes, I changed the owner and retried to run again and see the logs, and still getting the error.

So, now I don’t know who I will gonna set the owner if the postgres or the couch2pg or else ?

@binod
@diana

Marcelo_De_Guzman · October 19, 2023, 7:43am

Already fix this one.

Found out that the couch2pg.env file credentials is incorrect that is why it was not syncing correctly.

Thanks everyone for helping me to work on this.

@binod
@yuv
@mrjones

binod · October 19, 2023, 7:59am

Are there any specific changes you made for it to work?
Please share how you tested it.

Marcelo_De_Guzman · October 20, 2023, 1:05am

Upon checking the username and password of both couch2pg and postgres, I noticed that there is a mismatched that is why it doesn’t sync at the backend.

So, I used the username and password of couch2pg to postgres then I decrease the waiting time from 60 minutes to 5 minutes to see the effect when I change some data from the app to the database.