[MDEV-22227] Assertion `state_ == s_exec' failed in wsrep::client_state::start_transaction Created: 2020-04-12 Updated: 2022-07-08 Resolved: 2021-04-28 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Galera |
| Affects Version/s: | 10.4, 10.5 |
| Fix Version/s: | 10.4.19, 10.5.10 |
| Type: | Bug | Priority: | Critical |
| Reporter: | Elena Stepanova | Assignee: | Jan Lindström (Inactive) |
| Resolution: | Fixed | Votes: | 2 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
Reproducible on 10.4, 10.5. |
| Comments |
| Comment by Elton M. Labajo [ 2021-03-19 ] |
|
similar experience with galera 10.4 it crashed with the following error message. mysqld: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.18/wsrep-lib/include/wsrep/client_state.hpp:320: int wsrep::client_state::start_transaction(const wsrep::transaction_id&): Assertion `state_ == s_exec' failed. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help Server version: 10.4.18-MariaDB-log Thread pointer: 0x7f43840009a8 |
| Comment by Jaroslav [ 2021-04-15 ] |
|
Mario Karuza: Is there some workaround available? Maybe downgrading to some minor version? Or it affects 10.4/10.5 in general and we need to wait for hotfix? Thanks |
| Comment by Lisa Smith (Inactive) [ 2021-04-25 ] |
|
Repeat on instance that Elton Labajo had reported on 2021-03-19. Customer is waiting on fix. mysqld: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.18/wsrep-lib/include/wsrep/client_state.hpp:320: int wsrep::client_state::start_transaction(const wsrep::transaction_id&): Assertion `state_ == s_exec' failed. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help Server version: 10.4.18-MariaDB-log Thread pointer: 0x7f94540009a8 Trying to get some variables. , "RoutingProfile": {"RoutingType": 0, "VehicleType": 3, "TruckDimensions": 2, "UseAvoidFavors": true}, "PlannedStartLocation": {"Coords": {"Lat": 35.028430, "Lon": -81.907880}}, "Vehicle": {"TspVehicleId": "111249", "IsHighValue": "false"}, "Stops": [{"Location": {"Coords": {"Lat": 35.294400, "Lon": -80.762500}, "Label": "IKEA CHARLOTTE 067"}, "StopType": "Work", "PlannedDuration": 0, "EarliestArrivalTime": "2021-04-06T11:59:00.000000Z", "LatestArrivalTime": "2021-04-06T11:59:00.000000Z", "AtRiskThreshold": 15},{"Location": {"Coords": {"Lat": 35.028430, "Lon": -81.907880}, "Label": "BMW DC HUB SPARTANBURG"}, "StopType": "Origin", "PlannedDuration": 0, "EarliestArrivalTime": "2021-04-06T12:00:00.000000Z", "LatestArrivalTime": "2021-04-06T12:00:00.000000Z", "AtRiskThreshold": 15},{"Location": {"Coords": {"Lat": 40.722800, "Lon": -75.286300}, "Label": "BMW CONDC"}, "StopType": "Destination", "PlannedDuration": 0, "EarliestArrivalTime": "2021-04-08T18:00:00.000000Z", "LatestArrivalTime": "2021-04-08T18:00:00.000000Z", "AtRiskThreshold": 15}], "AfSetIds": [-1]}', `Tractor_number` = '111249', `Trip_actualStartDate` = timestamp('2021-04-06 12:00:00.000000'), `Trip_alk_Status` = 'InProgress', `Trip_Error_Description` = NULL, `TripId` = 56533620, `TripId_tms` = 8191536, `Trip_Other_Ord_hdrnumber` = NULL, `Trip_Request` = ' { "TripId": 56533620, "StopId": 1, "StopState": 2, "ActualArrivalTime": null, "ActualDepartureTime": "2021-04-06T11:59:00Z", "StopDuration": 0 }', `Trip_Response` = ' { "TripId": 56533620, "Success": true, "Message": null, "StackStrace": null, "ErrorType": null, "ErrorCode": null, "Description": null }', `Trip_Status` = 'STD', `Trip_tms_mov_number` = 8729210 Connection ID (thread ID): 2 Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains |
| Comment by chitimala Balaji [ 2022-07-08 ] |
|
We are using 10.4.19 Enterprise Version. on one of the galera node we got similar crash. Can you please check on this. mysqld: /home/jenkins/workspace/MariaDBE-Custom-RPM/label/rhel-7/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX_ON_ES_BACKUP_DEBUGSOURCE/wsrep-lib/include/wsrep/client_state.hpp:320: int wsrep::client_state::start_transaction(const wsrep::transaction_id&): Assertion `state_ == s_exec' failed. 220707 22:21:23 [ERROR] mysqld got signal 6 ; To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help Server version: 10.4.19-12-MariaDB-enterprise-log Thread pointer: 0x7e86ae812008 |