Table too big from module EventBus in PS 1.7.8.5

[jvicente1971]

Hello

I was cleaning "house" of my database prestashop and noticed a big table ps_eventbus_incremental_sync (see atached image) from eventbus module.

Is it safe to truncate this table? What the implications?

Thanks

[fmoreira86]

I have the same question...

 

Can someone please explain if it's ok to truncate this table from times to times?

[AddWeb Solution]

Hi,

It's generally safe to truncate the "ps_eventbus_incremental_sync" table from time to time, especially if you have verified that there are no critical synchronization tasks in progress. However, it's always a good practice to take a backup of your database before making any significant changes, just in case any unexpected issues arise.

Thanks!

[fmoreira86]

1 hour ago, AddWeb Solution said:

Hi,

It's generally safe to truncate the "ps_eventbus_incremental_sync" table from time to time, especially if you have verified that there are no critical synchronization tasks in progress. However, it's always a good practice to take a backup of your database before making any significant changes, just in case any unexpected issues arise.

Thanks!

Thanks for your reply!

What's the goal of this table?

[AddWeb Solution]

21 hours ago, fmoreira86 said:

Thanks for your reply!

What's the goal of this table?

Hi,

The goal of this table is to keep track of the changes that occur in the system and ensure that all relevant modules or systems are updated accordingly. It allows different components of PrestaShop or external systems to communicate and stay synchronized.

For example: When an event occurs, such as a product update or a new order, the Eventbus module captures that event and records it in the "ps_eventbus_incremental_sync" table. Other modules or systems can then listen to these events and perform their own actions or updates based on the changes.

By truncating this table, you essentially remove all the recorded events, indicating that they have been processed or are no longer relevant.

Thanks!

[fmoreira86]

On 7/11/2023 at 7:03 AM, AddWeb Solution said:

Hi,

The goal of this table is to keep track of the changes that occur in the system and ensure that all relevant modules or systems are updated accordingly. It allows different components of PrestaShop or external systems to communicate and stay synchronized.

For example: When an event occurs, such as a product update or a new order, the Eventbus module captures that event and records it in the "ps_eventbus_incremental_sync" table. Other modules or systems can then listen to these events and perform their own actions or updates based on the changes.

By truncating this table, you essentially remove all the recorded events, indicating that they have been processed or are no longer relevant.

Thanks!

Thank you!

So it's perfectly safe to truncate from times to times right with the store in maintenance mode, right?

[AddWeb Solution]

On 7/14/2023 at 10:19 PM, fmoreira86 said:

So it's perfectly safe to truncate from times to times right with the store in maintenance mode, right?

Yes it is.

But it's still important to take a backup of your database before truncating the table, just in case any unexpected issues arise.

And if you have any custom modules or integrations that rely on the Eventbus module or the events recorded in the table, make sure to test their functionality after truncating the table to ensure they continue to work as expected.

Thanks!

[fmoreira86]

6 hours ago, AddWeb Solution said:

Yes it is.

But it's still important to take a backup of your database before truncating the table, just in case any unexpected issues arise.

And if you have any custom modules or integrations that rely on the Eventbus module or the events recorded in the table, make sure to test their functionality after truncating the table to ensure they continue to work as expected.

Thanks!

Based on the module description:

Quote

 

Here is the list of modules affected by the dependency with the PS EventBus module:

PS Metrics

PS Facebook

PS Marketing with Google

PS Capital with Riverbank

PS EventBus

 

 

So, if we don't use any of these, it's probably safe to truncate I would say...