Hi,
It's not the difference between Windows and Linux.
There is an option *Level of rollback on errors* to specify either nop, transaction or statement.
regards,
Hiroshi Inoue
On 2016/02/18 15:45, Venkatesan, Sekhar wrote:
Hi Takayuki,
One thing I wanted to point out is that I didn’t see this issue in Linux OS. The application code is the same for both windows and Linux. In both the cases, we are in a transaction and an error occurred.
In linux, inserts are getting committed. In Windows, inserts are not getting committed. I will fix the application code to resolve the error. But just want to know the reason for different behavior.
When I enabled tracing in both, I see this difference:
Windows (After insert statements in tables):
2016-02-17 16:47:10 GMT ERROR: relation "dm_job_request_s" does not exist at character 24
2016-02-17 16:47:10 GMT STATEMENT: SELECT 1 AS total FROM dm_job_request_s S, dm_job_request_r R WHERE S.r_object_id = R.r_object_id AND arguments_keys = 'OldUserName' and arguments_values = $1 AND request_completed = 0 AND job_name = 'dm_UserRename'
2016-02-17 16:47:10 GMT LOG: statement: ROLLBACK
2016-02-17 16:47:10 GMT LOG: statement: BEGIN
Linux (After insert statements in tables):
< 2016-02-18 01:17:53.173 EST >ERROR: relation "dm_job_request_s" does not exist at character 24
< 2016-02-18 01:17:53.173 EST >STATEMENT: SELECT 1 AS total FROM dm_job_request_s S, dm_job_request_r R WHERE S.r_object_id = R.r_object_id AND arguments_keys = 'OldUserName' and arguments_values = $1 AND request_completed = 0 AND job_name = 'dm_UserRename'
< 2016-02-18 01:17:53.173 EST >LOG: statement: ROLLBACK to _EXEC_SVP_0x35fa4b0
< 2016-02-18 01:17:53.173 EST >LOG: statement: RELEASE _EXEC_SVP_0x35fa4b0
In linux, there is one extra call to release the savepoint which is not the case in windows.
Is this causing the behavior change in windows when compared to linux?
What is the expected behavior when “Release” savepoint is called?
Note: In linux, we are talking to linux PostgreSQL server. In Windows, We are talking to windows PostgreSQL server.
Thanks,
Sekhar