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

[former_member322151]

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.

[grabz]

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

[former_member322151]

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 )

[former_member322151]

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

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

Many Thanks