Sync Process Terminated While Handling Large Databases - SIGKILL Error

[divin-kp]

The sync process fails while attempting to handle a database with a large number of tables and rows. The process terminates unexpectedly with the following message:

fish: Job 1, './bemidb --pg-database-url post…' terminated by signal SIGKILL (Forced quit)

It appears the sync process is unable to manage the extensive size and complexity of the database effectively, resulting in forced termination.

Steps to Reproduce:

1. Attempt to sync database with a large number of tables and rows.
2. Allow the process to continue through the syncing of tables.
3. Observe the process terminating abruptly with the SIGKILL message.

Expected Behavior:
The sync process should handle databases with a large number of tables and rows without errors or termination.

Actual Behavior:
The sync process is terminated by a SIGKILL signal when attempting to sync a database of significant size.

Request:
I request an investigation into the handling of large databases during the sync process. It would be helpful to:

• Identify and address performance bottlenecks or limitations causing the termination.
• Implement safeguards to ensure stability when syncing large databases.

Please prioritize this issue and provide updates as soon as possible.