StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POWeb service SocketTimeOutException causes database inconsistency
primarykey
Id
14603642
data
AcceptedAnswerId
0
AnswerCount
3
ClosedDate
CommentCount
7
CommunityOwnedDate
CreationDate
2013-01-30T12:07:37.823
FavoriteCount
2
LastActivityDate
2013-03-04T15:45:23.013
LastEditDate
2013-02-25T19:33:15.870
LastEditorUserId
801437
OwnerUserId
801437
ParentId
0
PostTypeId
1
Score
7
ViewCount
459
LastEditorDisplayName
text
Body
I want to overcome the following scenario when calling a Rails Web service from Android device with the help of Apache HTTP Client library Scenario : Client (Android) : Initiates HTTP POST request (Using Apache HTTP Client, JSON as exchange format) to inserts few records into the server database (MySQL). Server (Web service in Rails) : Process the request and inserts records into the database successfully BUT at the same moment time out <code>(SocketTimeOutException)</code> occurs at the client side. Client (Android) : On time out, retries to execute the same HTTP POST request and once again the same records get's inserted into the database and Database INCONSISTENCY occurs. Can any one please help me to overcome this situation. Thanks in advance EDIT: My current scenario: 1) User tries to register using the Android app by filling and submitting data. So basically POST service contains all the required user into which is sent to the server (Rails and MySql) 2) POST request is processed by server and this process is basically responsible for inserting records into the database and providing response to client with the USER_ID for which data is inserted. 3) BOOM!! The data is inserted in the MySql database but for some reason there is <code>SocketTimeOutException</code> on the Android side and because of which there is no USER_ID on Android side and user tries to register again........ Data base inconsistency and I am SAD :( NOTE : Occurrence of step 3) is very rare.. BUT it is frequent when server is too busy or is having some processing load on it..
Tags
<android><web-services><ruby-on-rails-3.2><http-post><httpclient>
Title
Web service SocketTimeOutException causes database inconsistency
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USVishal Vyas
UserOwnerUserId
1. USVishal Vyas
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POWeb service SocketTimeOutException causes database inconsistency
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POWeb service SocketTimeOutException causes database inconsistency
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 POWeb service SocketTimeOutException causes database inconsistency
 UserUserId
 USmandar.gokhale
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.