Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ianwooly0
Starting Member
8 Posts |
 Posted - 2015-01-15 : 10:35:05
|
| Good afternoon.I have a web app that writes data to several different tables. When I create a data set through the app all the data writes to the relevant tables without any problems. However 1 table completely at random seomtimes loses rows of data. I can see the data used to be there as the row id`s no longer exist however I cannot pinpoint when and why this data is being removed from the table. There are over 335,000 rows in this table and just 79 rows that have magically disappeared!!! Any ideas? |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-01-15 : 11:10:43
|
| Check your transactions and triggers and whether someone else may be updating your table. |
 |
|
|
ianwooly0
Starting Member
8 Posts |
Posted - 2015-01-16 : 03:51:59
|
| There is only one account that has access to the server with the database which uses windows authentication. And as I havent run any delete statements on this table I cant see another reason for the rows to go missing. Also, no triggers. Thank you though |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-01-16 : 07:03:40
|
| what sort of isolation level have you said in your transactions? I suspect it's a problem with transactions. It's as if some rows are not getting committed to the database. |
|
|
|
ianwooly0
Starting Member
8 Posts |
Posted - 2015-01-20 : 06:32:30
|
| The transaction isolation level is Read Committed. The table hints that the rows were created as the ID`s for the rows are missing which leads me to believe the data has been committed and then somehow removed. |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-01-20 : 07:01:03
|
| please post your code that updates |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2015-01-21 : 01:45:49
|
| Is it only one type of action you're completing through the web app? Or is their multiple actions from the web app?In other words, are you able to systematically go through one iteration and confirm the rows are available at the end .Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2015-01-21 : 12:12:58
|
| How do you know the rows were ever there in the first place? Are you using IDENTITY for the Row IDs? If so, it is possible to generate an identity value, have the insert fail for some reason and you have an unused identity value. Also while identity normally doesn't skip numbers it doesn't guarantee that it doesn't skip numbers.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
|
|
|
|
Random rows somehow leaving a table!!!