the database is not syncing
rsymodo opened this issue · 1 comments
rsymodo commented
nothing happens after startup (including no synchronization with the database), there are no obvious errors either. What could be the problem?
user23@host_nl:~/meilisync$ docker-compose up
Creating meilisync_meilisync_1 ... done
Attaching to meilisync_meilisync_1
meilisync_1 | 2023-11-19 16:22:45.955 | DEBUG | meilisync.main:_:33 - plugins=None progress=Progress(type=<ProgressType.file: 'file'>) debug=True source=Source(type=<SourceType.postgres: 'postgres'>, database='pic_monitor', user='user23', host='my_host_ip', port=5432, password='my_db_password') meilisearch=MeiliSearch(api_url='http://my_host_ip:7700', api_key='meilisearch_api_key', insert_size=1000, insert_interval=10) sync=[Sync(plugins=None, table='photos', pk='id', full=True, index='photos', fields=None)] sentry=None
meilisync_1 | 2023-11-19 16:22:50.662 | INFO | meilisync.main:_:82 - Full data sync for table "pic_monitor.photos" done! 49281 documents added.
meilisync_1 | 2023-11-19 16:22:50.662 | INFO | meilisync.main:_:90 - Start increment sync data from "postgres" to MeiliSearch...
meilisync_1 | 2023-11-19 16:22:50.667 | DEBUG | meilisync.main:_:93 - progress={'start_lsn': '0/F10DEB0'}
my config.yml:
debug: true
progress:
type: file
source:
type: postgres
host: my_host_ip
port: 5432
user: user23
password: "my_db_password"
database: pic_monitor
meilisearch:
api_url: http://my_host_ip:7700
api_key: 'meilisearch_api_key'
insert_size: 1000
insert_interval: 10
sync:
- table: photos # my table name in database pic_monitor
index: photos # my index in meilisearch
full: true
Nickersoft commented
@rsymodo I'm running into the same thing – what was the fix?