Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
6.3.1, 6.4.5-dompe
-
None
Description
DMLProc starts ROLLBACK when SELECT part of UPDATE fails b/c EM facility in PP were restarted. Unfortunately this ROLLBACK stuck if EM/PP are not yet available. DMLProc must have a t/o with re-try doing ROLLBACK.
Here is the log except to describe the moment when DMLProc stuck trying to rollback an update that fails b/c EM restarts.
Oct 12 05:02:41 pixid-csx3 dmlpackageproc[25196]: 41.662215 |16896900|240438|0| D 21 CAL0001: End SQL statement with error
|
Oct 12 05:02:41 pixid-csx3 messagequeue[25187]: 41.689404 |0|0|0| W 31 CAL0000: MessageQueueClient::write: error writing 70 bytes to IOSocket: sd: 15 inet: 10.10.1.93 port: 8620. Socket error was InetStreamSocket::write error: Broken pipe -- write from InetStreamSocket: sd: 15 inet: 10.10.1.93 port: 8620
|
Oct 12 05:02:41 pixid-csx3 joblist[25187]: 41.700286 |2147724086|0|0| C 05 CAL0000: st: 0 TupleBPS::sendPrimitiveMessages() caught DistributedEngineComm::write: Broken Pipe error
|
Oct 12 05:02:41 pixid-csx3 dmlpackageproc[25196]: 41.745564 |0|0|0| E 21 ClientRotator caught exception: InetStreamSocket::write error: Broken pipe -- write from InetStreamSocket: sd: 24 inet: 10.10.1.93 port: 8601
|
Oct 12 05:02:41 pixid-csx3 dmlpackageproc[25196]: 41.850234 |16896900|240438|0| D 21 CAL0001: Start SQL statement: ROLLBACK
|
Oct 12 05:02:41 pixid-csx3 messagequeue[24776]: 41.977122 |0|0|0| W 31 CAL0000: MessageQueueClient::write: error writing 4 bytes to IOSocket: sd: 142 inet: 10.10.1.93 port: 8601. Socket error was InetStreamSocket::write error: Broken pipe -- write from InetStreamSocket: sd: 142 inet: 10.10.1.93 port: 8601
|
At the same time both EM and PP were restarted.