java - removing deadlock issue with sql server 2008 while reading and writing data -

-


java - removing deadlock issue with sql server 2008 while reading and writing data -

java.sql.batchupdateexception: transaction (process id 58) deadlocked on lock resources process , has been chosen deadlock victim. rerun transaction.

i have 2 java application 1 reading info sybase , writing sql server 2008 , reading info sql server 2008 table , writing other table. 2 application works fine. have many people accessing info mssql table sec application updates info every 30 sec. above exception. saw similar thread here in stackoverflow help deadlock in sql server 2008 have problem solution presented here

row versioning

can user rowversioning avoid dead locks in situation , how utilize it?

edit

string selectallquery = "select new_site_id gis.map.ro"; string selectquery = "select siteid gis.map.status alarmcode in ('1','2','3') , localnodealias 'flm%'"; string updatequery = "update gis.map.ro set active_site_status = ? new_site_id = ?"; string updateallquery = "update gis.map.ro set active_site_status = site_status new_site_id = ?";

so, select gis.map.status table , update update gis.map.ro table. gis.map.status table update every 30 sec(the whole table deleted , inserted 2 task

inserting gis.map.status goes first , transaction committed updating gis.map.ro table goes sec , transaction committed finally, info gis.map.ro accessed many user 3rd party application. actually deadlock occours @ instance.

in cases deadlocks indicate there's wrong implementation - there's problem query order, locking order or bring together order. i'd suggest collecting , analyzing deadlocks (msdn: analyzing deadlocks sql server profiler) may find exact places in code deadlocks occur , prepare them.

java sql sql-server sql-server-2008

Comments

Post a Comment

Popular posts from this blog

How do I check if an insert was successful with MySQLdb in Python? -

-
How do I check if an insert was successful with MySQLdb in Python? - i have code: cursor = conn.cursor() cursor.execute(("insert new_files (videos_id, filename, " "is_processing) values (%s,%s,1)"), (id, filename)) logging.warn("%d", cursor.rowcount) if (cursor.rowcount == 1): logging.info("inserted values %d, %s", id, filename) else: logging.warn("failed insert values %d, %s", id, filename) cursor.close() fun is, cursor.rowcount always one, though updated database create videos_id unique key. is, insert fails because in tests same videos_id going appear (and when check database, nil inserted). whatever reason, rowcount 1 - logging.warn have spits out rowcount of 1. so, question: can utilize rowcount work out if insert went fine? if so, (presumably) doing wrong? otherwise, how check if insert went fine? your code not commit after modifications (your modifications rolled back). should...
Read more

delphi - blogger via idHTTP : error 400 bad request -

-
delphi - blogger via idHTTP : error 400 bad request - i'm trying post blogger using idhttp component, however, i'm getting "http/1.0 400 bad request" error. procedure tform1.button1click(sender: tobject); var request,response,req : tstringlist; auth,blogid : string; begin blogid := '00000000000000000000000'; request := tstringlist.create; response := tstringlist.create; req := tstringlist.create; idhttp1.request.connection := 'keep-alive'; idhttp1.request.contenttype := 'application/x-www-form-urlencoded'; idssliohandlersocket1.ssloptions.method := sslvsslv23; request.clear(); request.values['accounttype'] := 'google'; request.values['email'] := 'xxx@gmail.com'; request.values['passwd'] := 'yyy'; request.values['service'] := 'blogger'; response.text :=idhttp1.post('https://www.google.com/accounts/clientlogin',request); auth := resp...
Read more

postgresql - ERROR: operator is not unique: unknown + unknown -

-
postgresql - ERROR: operator is not unique: unknown + unknown - i have postgis database , have compute new values rows in new column. these values should average of values of several columns. query: insert bdps (da_m) values (avg('da_1'+'da_2'+'da_3'+'da_4'+'da_5'+'da_6'+'da_7')); in query bdps database, da_m new column , da_1 da_7 existing columns have double precision type. da_m created using alter table bdps add together column da_m double precision; i next error: error: operator not unique: unknown + unknown line 2: values (avg('da_1'+'da_2'+'da_3'+'da_4'+'da_5'+'da_6'+'da_7... ^ hint: not take best candidate operator. might need add together explicit type casts. ********** error ********** error: operator not unique: unknown + unknown sql state: 42725 hint: not take best candidate operator. might need add togethe...
Read more