Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
5.5.47-galera
-
None
-
Ubuntu 14.04.4 LTS
Description
Running from a Java 8 environment, I execute a SQL update against a table (definition given below). Most of the time, the row updates correctly. But sporadically (10%, but sometimes as high as 70% of the time), only some of the columns in the row update.
First, here is the update statement (Java prepared statement syntax):
UPDATE train SET dt_comp=NOW(), status=?, error=?, location=? WHERE id=? |
The table definition is given below. The location column always updates. However, dt_comp (which isn't even set by my program, but rather uses the built-in NOW() function) and status will sporadically fail to update as indicated previously.
I've tried all manner of fiddling with auto-commit settings. I tried removing column dt_comp from the update query, but then, as before, status would sporadically fail to update.
As far as I can tell, this is a (serious) issue on the server side.
CREATE TABLE IF NOT EXISTS `train` ( |
`id` int(10) NOT NULL AUTO_INCREMENT, |
`install_id` int(10) unsigned NOT NULL DEFAULT '0', |
`dt_req` datetime DEFAULT NULL, |
`dt_comp` datetime DEFAULT NULL, |
`total_downloads` smallint(5) unsigned DEFAULT '0', |
`dt_last_accessed` datetime DEFAULT NULL, |
`status` enum('SUCCESS','FAILED','QUEUE','IN_PROCESS','WRITE_QUEUE') DEFAULT NULL, |
`error` text,
|
`location` varchar(256) DEFAULT NULL, |
`estimated_f1` float DEFAULT NULL, |
`train_ms` int(10) unsigned DEFAULT NULL, |
`zipped_size` int(10) unsigned DEFAULT NULL, |
PRIMARY KEY (`id`), |
KEY `FK_train_install` (`install_id`), |
KEY `IDX_req_date` (`dt_req`,`status`,`install_id`) USING BTREE, |
CONSTRAINT `FK_train_install` FOREIGN KEY (`install_id`) REFERENCES `install` (`id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |