Update database stucture timeout

Avatar

Avatar
Contributor
Level 3
saikatk2447661
Level 3

Likes

22 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Contributor
Level 3
saikatk2447661
Level 3

Likes

22 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile
saikatk2447661
Level 3

16-04-2021

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 5
Level 3
adithyacs86
Level 3

Likes

22 likes

Total Posts

110 posts

Correct reply

5 solutions
Top badges earned
Affirm 5
Validate 10
Validate 1
Give Back 5
Give Back 3
View profile

Avatar
Affirm 5
Level 3
adithyacs86
Level 3

Likes

22 likes

Total Posts

110 posts

Correct reply

5 solutions
Top badges earned
Affirm 5
Validate 10
Validate 1
Give Back 5
Give Back 3
View profile
adithyacs86
Level 3

16-04-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

 

 

Answers (1)

Answers (1)

Avatar

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

175 likes

Total Posts

934 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

175 likes

Total Posts

934 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
Sukrity_Wadhwa
Employee

22-04-2021

Hi @saikatk2447661,

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

Thanks!