Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Subscribe

I have recently migrated a client server which has started to produce this error in the mobilink logs. These deadlocks occur almost everyday.

'ml_database' locked (ODBC State = 40001, Native error code = -210) Unable to lock the remote ID '...', will try again

I copied the .db and .log files from the old server shut it down and pasted the files to new server. The network database server and mobilink server started back up just fine.

I have applied the latest EBF MobiLink 12 12.0.1.4086 which has not fixed the issue.

There are about 15 users syncing on the server.

Please let me know if you need more information. 

I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization AMessage (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization DataFormLine (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization DataFormLineEnum (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization DataFormRole (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization FS_DataFormRegion (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization FS_DataFormCustomer (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization FS_RoleItemFavourite (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization FS_UserRegion (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization FS_WorkOrderItemUserShortcut (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization FS_WorkOrderItemTemplateItemList (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization FS_CustomerSiteItemAccount (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization FS_UserItemFavourite (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization FS_TimeTypeBonus (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization FS_TimeTypeTrade (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization DataFormBusinessUnit (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization LicenseKeyType (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization DataFormResultLine (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_synchronization ParameterBusinessUnit (no script)
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) begin_publication <connection>
                        call asi_BeginPublication({ml s.publication_name}, {ml ui.statisticID}, {ml s.username})
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) System variable publication_name value: ul_default_pub
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) User variable statisticID value: fcac12c4-914b-4fa9-8c6c-e3b29d0fe873
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) System variable username value: rdhaliwal
I. 2014-05-07 00:24:43. <72> (,rdhaliwal) Translated SQL:
                        call asi_BeginPublication( ?,  ?,  ?)
I. 2014-05-07 00:24:52. <main> System event on shared administrative connection:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:24:52. <main> Translated SQL:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:25:26. <main> System event on shared administrative connection:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:25:26. <main> Translated SQL:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:25:53. <main> System event on shared administrative connection:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:25:53. <main> Translated SQL:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
E. 2014-05-07 00:26:00. <71> (,rnorton) [-10279] Connection was dropped due to lack of network activity
I. 2014-05-07 00:26:27. <main> System event on shared administrative connection:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:26:27. <main> Translated SQL:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:26:53. <main> System event on shared administrative connection:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:26:53. <main> Translated SQL:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:27:28. <main> System event on shared administrative connection:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:27:28. <main> Translated SQL:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:27:54. <main> System event on shared administrative connection:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:27:54. <main> Translated SQL:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:28:29. <main> System event on shared administrative connection:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:28:29. <main> Translated SQL:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:28:54. <main> System event on shared administrative connection:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:28:54. <main> Translated SQL:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:29:06. <main> System event on shared administrative connection:
                        select 1, property_name, cast(property_value as char(254)) from ml_property where component_name = 'MLS' AND property_set_name = 'ml_user_log_verbosity' union select 2, property_name, cast(property_value as char(254)) from ml_property where component_name = 'MLS' AND property_set_name = 'ml_remote_id_log_verbosity'
I. 2014-05-07 00:29:06. <main> Translated SQL:
                        select 1, property_name, cast(property_value as char(254)) from ml_property where component_name = 'MLS' AND property_set_name = 'ml_user_log_verbosity' union select 2, property_name, cast(property_value as char(254)) from ml_property where component_name = 'MLS' AND property_set_name = 'ml_remote_id_log_verbosity'
I. 2014-05-07 00:29:31. <main> System event on shared administrative connection:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:29:31. <main> Translated SQL:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:29:54. <main> System event on shared administrative connection:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:29:54. <main> Translated SQL:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:30:32. <main> System event on shared administrative connection:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:30:32. <main> Translated SQL:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:30:55. <main> System event on shared administrative connection:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:30:55. <main> Translated SQL:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:31:33. <main> System event on shared administrative connection:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:31:33. <main> Translated SQL:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:31:56. <main> System event on shared administrative connection:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:31:56. <main> Translated SQL:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:32:35. <main> System event on shared administrative connection:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:32:35. <main> Translated SQL:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:32:56. <main> System event on shared administrative connection:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:32:56. <main> Translated SQL:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:33:36. <main> System event on shared administrative connection:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:33:36. <main> Translated SQL:
                        SELECT count(*) FROM ml_passthrough_script
I. 2014-05-07 00:33:57. <main> System event on shared administrative connection:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:33:57. <main> Translated SQL:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2014-05-07 00:34:11. <main> System event on shared administrative connection:
                        select 1, property_name, cast(property_value as char(254)) from ml_property where component_name = 'MLS' AND property_set_name = 'ml_user_log_verbosity' union select 2, property_name, cast(property_value as char(254)) from ml_property where component_name = 'MLS' AND property_set_name = 'ml_remote_id_log_verbosity'
I. 2014-05-07 00:34:11. <main> Translated SQL:
                        select 1, property_name, cast(property_value as char(254)) from ml_property where component_name = 'MLS' AND property_set_name = 'ml_user_log_verbosity' union select 2, property_name, cast(property_value as char(254)) from ml_property where component_name = 'MLS' AND property_set_name = 'ml_remote_id_log_verbosity'
I. 2014-05-07 00:34:14. <73> (,rnorton) Request from "UL 12.0.1.3605" for: remote ID: b06d1b50-870a-11e3-8000-ec206ffcadef, user name: rnorton, version: FieldServiceV3_3_8
I. 2014-05-07 00:34:14. <73> (,rnorton) System event on shared administrative connection:
                        SELECT user_id FROM ml_user WHERE name = ?
I. 2014-05-07 00:34:14. <73> (,rnorton) Translated SQL:
                        SELECT user_id FROM ml_user WHERE name = ?
I. 2014-05-07 00:34:14. <73> (,rnorton) System event on shared administrative connection:
                        SET TEMPORARY OPTION blocking='off'
I. 2014-05-07 00:34:14. <73> (,rnorton) Translated SQL:
                        SET TEMPORARY OPTION blocking='off'
I. 2014-05-07 00:34:14. <73> (,rnorton) System event on shared administrative connection:
                        SELECT rid, sync_key FROM ml_database WHERE remote_id = ?
I. 2014-05-07 00:34:14. <73> (,rnorton) Translated SQL:
                        SELECT rid, sync_key FROM ml_database WHERE remote_id = ?
W. 2014-05-07 00:34:14. <73> (,rnorton) [10050] ODBC: [Sybase][ODBC Driver][SQL Anywhere]User 'AWADMIN' has the row in 'ml_database' locked (ODBC State = 40001, Native error code = -210)
I. 2014-05-07 00:34:14. <73> (,rnorton) System event on shared administrative connection:
                        SET TEMPORARY OPTION blocking='on'
I. 2014-05-07 00:34:14. <73> (,rnorton) Translated SQL:
                        SET TEMPORARY OPTION blocking='on'
W. 2014-05-07 00:34:14. <73> (,rnorton) [10106] Unable to lock the remote ID 'b06d1b50-870a-11e3-8000-ec206ffcadef', will try again
I. 2014-05-07 00:34:14. <73> (,rnorton) System event on shared administrative connection:
                        SELECT user_id FROM ml_user WHERE name = ?
I. 2014-05-07 00:34:14. <73> (,rnorton) Translated SQL:
                        SELECT user_id FROM ml_user WHERE name = ?
I. 2014-05-07 00:34:14. <73> (,rnorton) System event on shared administrative connection:
                        SET TEMPORARY OPTION blocking='off'
I. 2014-05-07 00:34:14. <73> (,rnorton) Translated SQL:
                        SET TEMPORARY OPTION blocking='off'
I. 2014-05-07 00:34:14. <73> (,rnorton) System event on shared administrative connection:
                        SELECT rid, sync_key FROM ml_database WHERE remote_id = ?
I. 2014-05-07 00:34:14. <73> (,rnorton) Translated SQL:
                        SELECT rid, sync_key FROM ml_database WHERE remote_id = ?
W. 2014-05-07 00:34:14. <73> (,rnorton) [10050] ODBC: [Sybase][ODBC Driver][SQL Anywhere]User 'AWADMIN' has the row in 'ml_database' locked (ODBC State = 40001, Native error code = -210)
I. 2014-05-07 00:34:14. <73> (,rnorton) System event on shared administrative connection:
                        SET TEMPORARY OPTION blocking='on'
I. 2014-05-07 00:34:14. <73> (,rnorton) Translated SQL:
                        SET TEMPORARY OPTION blocking='on'
W. 2014-05-07 00:34:14. <73> (,rnorton) [10106] Unable to lock the remote ID 'b06d1b50-870a-11e3-8000-ec206ffcadef', will try again
I. 2014-05-07 00:34:15. <73> (,rnorton) System event on shared administrative connection:
                        SELECT user_id FROM ml_user WHERE name = ?
I. 2014-05-07 00:34:15. <73> (,rnorton) Translated SQL:
                        SELECT user_id FROM ml_user WHERE name = ?
I. 2014-05-07 00:34:15. <73> (,rnorton) System event on shared administrative connection:
                        SET TEMPORARY OPTION blocking='off'
I. 2014-05-07 00:34:15. <73> (,rnorton) Translated SQL:
                        SET TEMPORARY OPTION blocking='off'
I. 2014-05-07 00:34:15. <73> (,rnorton) System event on shared administrative connection:
                        SELECT rid, sync_key FROM ml_database WHERE remote_id = ?
I. 2014-05-07 00:34:15. <73> (,rnorton) Translated SQL:
                        SELECT rid, sync_key FROM ml_database WHERE remote_id = ?
W. 2014-05-07 00:34:15. <73> (,rnorton) [10050] ODBC: [Sybase][ODBC Driver][SQL Anywhere]User 'AWADMIN' has the row in 'ml_database' locked (ODBC State = 40001, Native error code = -210)
I. 2014-05-07 00:34:15. <73> (,rnorton) System event on shared administrative connection:
                        SET TEMPORARY OPTION blocking='on'
I. 2014-05-07 00:34:15. <73> (,rnorton) Translated SQL:
                        SET TEMPORARY OPTION blocking='on'
W. 2014-05-07 00:34:15. <73> (,rnorton) [10106] Unable to lock the remote ID 'b06d1b50-870a-11e3-8000-ec206ffcadef', will try again
I. 2014-05-07 00:34:16. <73> (,rnorton) System event on shared administrative connection:
                        SELECT user_id FROM ml_user WHERE name = ?
I. 2014-05-07 00:34:16. <73> (,rnorton) Translated SQL:
                        SELECT user_id FROM ml_user WHERE name = ?
I. 2014-05-07 00:34:16. <73> (,rnorton) System event on shared administrative connection:
                        SET TEMPORARY OPTION blocking='off'
I. 2014-05-07 00:34:16. <73> (,rnorton) Translated SQL:
                        SET TEMPORARY OPTION blocking='off'
I. 2014-05-07 00:34:16. <73> (,rnorton) System event on shared administrative connection:
                        SELECT rid, sync_key FROM ml_database WHERE remote_id = ?
I. 2014-05-07 00:34:16. <73> (,rnorton) Translated SQL:
                        SELECT rid, sync_key FROM ml_database WHERE remote_id = ?

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
Breck_Carter
Participant
‎2014 May 06 3:34 PM
0 Likes

Please run mlsrv12 with the -o option to capture diagnostic information to a text file, and the -vcefhkmnopstuU option to increase verbosity. Then paste the file into your question (type <pre> and </pre> tags around the text to stop the formatting).

View Entire Topic
Former Member
‎2014 May 14 9:31 AM

The issue was with a batch file not using -nogui under sybase 12 causing the interactive sql window to remain open in the background and causing a lock when the over right process ran. I believe this switch is not required in sybase 11.

Show replies
Show replies
regdomaratzki
Product and Topic Expert
Product and Topic Expert
‎2014 May 14 9:55 AM
0 Likes

Thanks for sharing the solution.

Ask a Question