gitlab upgrade failed during db migration from 10.2.6 to 104.1
we use mysql 5.6, ruby is on 2.3.6. I have followed mysql guide to update necessary tables to utf8mb4. however, I am still getting the error below. I tried to do an incremental upgrade to 10.3.0. it failed with the same error. notice the referenced row is "('Updated according to CR\n', '2016-03-13 02:35:00.000000', 'Abinay', 'a.bandari@STA124468.sisa.samsung.com', '2016-03-13 02:35:00.000000', 'Abinay', 'a.bandari@STA124468.sisa.samsung.com', 4008, 0, x'18304afca37b0222d89c2b1c94e7ea9ca516f25d'),". I can insert this directly into mysql w/o any issue.
Any idea what is going on?
Caused by:
ActiveRecord::StatementInvalid: Mysql2::Error: Incorrect datetime value: '2016-03-13 02:35:00.000000' for column 'authored_date' at row 11: INSERT INTO merge_request_diff_commits (`message`, `authored_date`, `author_name`, `author_email`, `committed_date`, `committer_name`, `committer_email`, `merge_request_diff_id`, `relative_order`, `sha`)
VALUES ('MSCASDE-2926: favorite feature - need to clear on logout\n', '2016-03-13 00:12:51.000000', 'David Tran', 'd.tran@partner.samsung.com', '2016-03-13 00:12:51.000000', 'David Tran', 'd.tran@partner.samsung.com', 4004, 0, x'f9cf26ccf745b6495652589839f682694b6c4025'), ('v9.0.2.0\n', '2016-03-13 01:09:10.000000', 'David Tran', 'd.tran@partner.samsung.com', '2016-03-13 01:09:10.000000', 'David Tran', 'd.tran@partner.samsung.com', 4005, 0, x'842a673a1fbc01aac4ecf7f0a1d010fd85d9d6d1'), ('MSCASDE-2972 -- account related events\n', '2016-03-13 01:42:44.000000', 'Shree Rajakumar', 'shree.r@samsung.com', '2016-03-13 01:43:12.000000', 'Shree Rajakumar', 'shree.r@samsung.com', 4006, 0, x'1a413907912529b0e292f8b83ace7357a2759df1'), ('Merge branch \'dev/shree\' into \'samsungmaster\'\r\n\r\nMSCASDE-2972 -- account related events\r\n\r\n@d.tran , can you review?\r\n\r\nSee merge request !390', '2016-03-13 01:55:35.000000', 'Shree Rajakumar', 'shree.r@samsung.com', '2016-03-13 01:55:35.000000', 'Shree Rajakumar', 'shree.r@samsung.com', 4007, 0, x'14ebc2ea6806e8ec8b374347f23bd29cd88696c4'), ('Merge branch \'samsungmaster\' of http://git.mspot.com/samsungplus/loyalty-android-client into samsungmaster\n', '2016-03-13 01:53:42.000000', 'Raghurami Reddy', 'r.reddy2@partner.samsung.com', '2016-03-13 01:53:42.000000', 'Raghurami Reddy', 'r.reddy2@partner.samsung.com', 4007, 1, x'9b46fa600123ef787fd8499b1d7b3458c5aad9ad'), ('Toolbar title was missing for Workshops & settings\n', '2016-03-13 01:53:19.000000', 'Raghurami Reddy', 'r.reddy2@partner.samsung.com', '2016-03-13 01:53:19.000000', 'Raghurami Reddy', 'r.reddy2@partner.samsung.com', 4007, 2, x'50162a63f59fe937a7393eae7b1482e4630684f2'), ('MSCASDE-2972 -- account related events\n', '2016-03-13 01:42:44.000000', 'Shree Rajakumar', 'shree.r@samsung.com', '2016-03-13 01:43:12.000000', 'Shree Rajakumar', 'shree.r@samsung.com', 4007, 3, x'1a413907912529b0e292f8b83ace7357a2759df1'), ('Merge branch \'dev/dtran\' into \'samsungmaster\'\r\n\r\nv9.0.2.0\r\n\r\n\r\n\r\nSee merge request !389', '2016-03-13 01:09:22.000000', 'David Tran', 'd.tran@partner.samsung.com', '2016-03-13 01:09:22.000000', 'David Tran', 'd.tran@partner.samsung.com', 4007, 4, x'57e614cbe9c13dd9cb390cf952b6afb6d04f2401'), ('v9.0.2.0\n', '2016-03-13 01:09:10.000000', 'David Tran', 'd.tran@partner.samsung.com', '2016-03-13 01:09:10.000000', 'David Tran', 'd.tran@partner.samsung.com', 4007, 5, x'842a673a1fbc01aac4ecf7f0a1d010fd85d9d6d1'), ('Merge branch \'dev/abandari\' into \'samsungmaster\'\r\n\r\nfix for mixpanel track for mysamsung v2_device_selection, v2_device_view v2_product_registration,v2_workshop_selection\r\n\r\n\r\n\r\nSee merge request !384', '2016-03-13 01:02:28.000000', 'Abinay Bandari', 'a.bandari@partner.samsung.com', '2016-03-13 01:02:28.000000', 'Abinay Bandari', 'a.bandari@partner.samsung.com', 4007, 6, x'b2b508ffc8d3350a2488106c3a4ab463d5a7355c'), ('Updated according to CR\n', '2016-03-13 02:35:00.000000', 'Abinay', 'a.bandari@STA124468.sisa.samsung.com', '2016-03-13 02:35:00.000000', 'Abinay', 'a.bandari@STA124468.sisa.samsung.com', 4008, 0, x'18304afca37b0222d89c2b1c94e7ea9ca516f25d'), ('fix for property\n', '2016-03-13 02:32:29.000000', 'Abinay', 'a.bandari@STA124468.sisa.samsung.com', '2016-03-13 02:32:29.000000', 'Abinay', 'a.bandari@STA124468.sisa.samsung.com', 4008, 1, x'9d8ce2f51aacfb1ac1be26a27a8c36543d971fb8'), ('Fix for mix panel events for settings and location\n', '2016-03-13 02:28:07.000000', 'Abinay', 'a.bandari@STA124468.sisa.samsung.com', '2016-03-13 02:28:07.000000', 'Abinay', 'a.bandari@STA124468.sisa.samsung.com', 4008, 2, x'7142fc62c0510b6ca8db8f3f2370873abc65df17'), ('Merge branch \'samsungmaster\' into \'dev/abandari\'\r\n\r\nSamsungmaster\r\n\r\n\r\n\r\nSee merge request !391', '2016-03-13 02:21:58.000000', 'Abinay Bandari', 'a.bandari@partner.samsung.com', '2016-03-13 02:21:58.000000', 'Abinay Bandari', 'a.bandari@partner.samsung.com', 4008, 3, x'9632804db96c0a59eb27cbcc196708915ec55bc8'), ('updated mixpanel spec\n', '2016-03-13 02:42:57.000000', 'Shree Rajakumar', 'shree.r@samsung.com', '2016-03-13 02:43:30.000000', 'Shree Rajakumar', 'shree.r@samsung.com', 4009, 0, x'fbd2c27decb6466a970d3c57b4098a067f61e655'), ('Merge branch \'dev/shree\' into \'samsungmaster\'\r\n\r\nupdated mixpanel spec\r\n\r\n\r\n\r\nSee merge request !393', '2016-03-13 02:44:27.000000', 'Shree Rajakumar', 'shree.r@samsung.com', '2016-03-13 02:44:27.000000', 'Shree Rajakumar', 'shree.r@samsung.com', 4010, 0, x'f346f0cea2362e6d1a6bd7212c20c3d364925bf5'), ('updated mixpanel spec\n', '2016-03-13 02:42:57.000000', 'Shree Rajakumar', 'shree.r@samsung.com', '2016-03-13 02:43:30.000000', 'Shree Rajakumar', 'shree.r@samsung.com', 4010, 1, x'fbd2c27decb6466a970d3c57b4098a067f61e655'), ('Merge branch \'dev/abandari\' into \'samsungmaster\'\r\n\r\nDev/abandari\r\n\r\n\r\n\r\nSee merge request !392', '2016-03-13 02:37:16.000000', 'Abinay Bandari', 'a.bandari@partner.samsung.com', '2016-03-13 02:37:16.000000', 'Abinay Bandari', 'a.bandari@partner.samsung.com', 4010, 2, x'573d201d7d669f61737f11cce8a725acc36a62a7'),Edited by Stan Hu