Skip to Content
0

Sybase Unwired Platform 2.3 - SQL Anywhere Error -306: Deadlock detected

Aug 29, 2017 at 02:20 PM

50

avatar image
Former Member

Hi, All

I had changed type of MBO attributes and deploy application on SUP server.

Now, I have error in mobile device log In synchronization process

Sync failed: -1305 (MOBILINK_COMMUNICATIONS_ERROR) %1:86 %2:500 %3:0;Parameter 1:86;Parameter 2:500;Parameter 3:0})

In server log

com.sybase.vader.ai.impl.SPSQLException: "JDBC call to getMoreResults failed for procedure d1_mobcrm_2_12_problem.mergeProcessor.previousQuery: {1}.
SQL Anywhere Error -306: Deadlock detected

Please tell me how solve this problem.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Akos Grabecz
Aug 30, 2017 at 01:23 PM
1

Hi Sergey,

For the deadlock issue here's the explanation.

The -1305 means that the synchronization wasn't successful.

The parameter 86 means that the second parameter is an HTTP status code.

The second parameter is 500 so the problem is 500 internal server error. That's pretty generic so the root is the deadlock or something else.

For the deadlock detection check this wiki.

If it still doesn't help then you should check the logs for other error messages and check your infrastructure. I think the problem is not with the SMP and not with the app, but that's just a hunch.

Ákos

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi, Ákos.

Thanks for the your answer.

I already read Wiki. I tried delete connection, rebooted server, redeploeid application, but it all not solved this problem.

This problem have been observed on production server, but test sever is OK.

I'm analyzing logs )

0
Former Member

It's a mystics. After another deploy - synchronization is successful

Recipe - delete app->reboot server->deploy app->reboot server )

Many Thanks

1