Update database stucture timeout | Community
Skip to main content
saikatk2447661
Level 4
April 16, 2021
Solved

Update database stucture timeout

  • April 16, 2021
  • 2 replies
  • 1412 views

Hi All,

 

Facing this problem after v7 upgrade. Update database structure is showing timeout error most of the time. The error is coming before showing the list of tables that has any change.

 

Can anyone provide some info on what kind of sql/other back end job is executed during this database update? Do we have too many tables? Is it a issue with DB server memory?

 

Thanks,

Saikat

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by adithyacs86

Hi Saikat, 

 

We faced this issue for one of our projects - if we have stage tables getting created and the tables are not purging the way we are seeing and getting pilled up will timeout in the database updates. 

 

So, it is good to check from the backend (database) if you have the same number of tables present which is equal to the schemas showing in your instance. if there are more in the database - then I believe these tables are not purged from the Database. 

 

Thanks,
Adithya

 

 

2 replies

adithyacs86
adithyacs86Accepted solution
Level 5
April 16, 2021

Hi Saikat, 

 

We faced this issue for one of our projects - if we have stage tables getting created and the tables are not purging the way we are seeing and getting pilled up will timeout in the database updates. 

 

So, it is good to check from the backend (database) if you have the same number of tables present which is equal to the schemas showing in your instance. if there are more in the database - then I believe these tables are not purged from the Database. 

 

Thanks,
Adithya

 

 

Sukrity_Wadhwa
Community Manager
Community Manager
April 22, 2021

Hi @saikatk2447661,

Were you able to resolve this query or do you still need more help here? Do let us know.

Thanks!

Sukrity Wadhwa