Unable to delete a table

Bug
1

Application ID: 820FBB35-552C-F405-FFB9-B4D60982E100
Error UID: 7B0574CD-25AD-E1A4-FFDF-EDE2A095F000

Backendless encountered an error while handling the request. An internal trouble ticket with ID 7B0574CD-25AD-E1A4-FFDF-EDE2A095F000 has been created and we will be investigating the issue.
java.sql.SQLSyntaxErrorException: Unknown table '820FBB35-552C-F405-FFB9-B4D60982E100.udt.User_answer'
java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: Unknown table '820FBB35-552C-F405-FFB9-B4D60982E100.udt.User_answer'
	at com.backendless.services.persistence.schema.DatabaseOperation.handleDdlException(DatabaseOperation.java:199)
	at com.backendless.services.persistence.schema.DatabaseOperation.lambda$doExecute$2(DatabaseOperation.java:176)
	at com.backendless.datamodel.application.dao.AppJpaTransaction.executeSync(AppJpaTransaction.java:139)
	at com.backendless.datamodel.application.dao.AppJpaTransaction.executeSync(AppJpaTransaction.java:208)
	at com.backendless.datamodel.application.dao.AppJpaTransaction.lambda$execute$0(AppJpaTransaction.java:52)
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:829)
	Suppressed: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: Unknown table '820FBB35-552C-F405-FFB9-B4D60982E100.udt.User_answer'
		at java.base/java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:395)
		at java.base/java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1999)
		at com.backendless.async.UncheckedCompletableFuture.getUnchecked(UncheckedCompletableFuture.java:25)
		at com.backendless.async.UncheckedCompletableFutureImpl.getUnchecked(UncheckedCompletableFutureImpl.java:29)
		at com.backendless.services.persistence.schema.DatabaseOperation.doExecute(DatabaseOperation.java:183)
		at com.backendless.services.persistence.schema.DatabaseOperation.lambda$execute$0(DatabaseOperation.java:135)
		at com.backendless.util.sync.RedisSync.execute(RedisSync.java:108)
		at com.backendless.util.SyncUtil.execute(SyncUtil.java:45)
		at com.backendless.util.sync.ISync.execute(ISync.java:33)
		at com.backendless.services.persistence.schema.DatabaseOperation.execute(DatabaseOperation.java:138)
		at com.backendless.services.persistence.common.TablesService.removeTableByName(TablesService.java:244)
		a

Problem description

Describe what you did in console that led to the error. Please provide a description of what actually happens. Be descriptive: “it doesn’t work” does not describe what the behavior actually is. This will help us with reproducing the problem.

Steps to reproduce

Please describe steps to reproduce starting from the first action.

2

Hello @Ayaz_Khan,

What table are you trying to delete?

3

Hello @olhadanylova,

I’m trying to delete ‘User_answer’ table but here i got some internal error please try to resolve it soon.

image
image1920×1080 229 KB

4

Hi @Ayaz_Khan ,

Could you please describe your actions with this table before you tried to delete it?
Several days ago you had similar problem with another table because server didn’t finish renaming of that table. It looks like there can be some bug on our side since similar situation occurred again in your app.

UPD.
Table was removed from your app. It looks like you tried to rename it first. Have you got any error messages during renaming process?

Regards, Andriy

5

Hi @Andriy_Konoz ,

After renaming the table, then I tried to delete the table, but it was giving an internal server error and I didn’t get any other error.
Thank you for resolving the issues.

6

@Ayaz_Khan ,

Maybe you remember time interval between renaming and removal of the table?

Regards, Andriy

7

Hi @Andriy_Konoz,

No, I didn’t find any other error at that time. If I face the same issue in the future, I will tell you.

8

@Ayaz_Khan ,

It seems that you misunderstood my question.
How long did you waited after table renaming before you tried to delete table?

Regards, Andriy

9

@Andriy_Konoz

almost around 15 minutes.