long2ice / meilisync

Realtime sync data from MySQL/PostgreSQL/MongoDB to Meilisearch
https://github.com/long2ice/meilisync
Apache License 2.0
247 stars 37 forks source link

the database is not syncing #32

Closed rsymodo closed 9 months ago

rsymodo commented 9 months ago

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 7 months ago

@rsymodo I'm running into the same thing – what was the fix?