•  
      request #23453 Fix DB migration bucket b202109291736_correct_request_method_to_allow_patch of the userlog plugin
    Infos
    #23453
    Thomas Gerbet (tgerbet)
    2021-10-20 09:59
    2021-10-19 18:16
    25003
    Details
    Fix DB migration bucket b202109291736_correct_request_method_to_allow_patch of the userlog plugin

    request #23389 has fixed an issue where the verb of some HTTP requests was truncated.

    A migration bucket was also added to fix the existing logs: while correct this can take a while on production instances where the plugin_userlog_request has a lot of rows. Fixing the existing logs requires to go through the whole table because it works on a column that does not have an index. Ultimately it is not worth it, broken logged queries will stay as is, new ones will be correctly saved.

    If someone want to fix them, they can run the following queries manually:

    UPDATE plugin_userlog_request SET http_request_method='PATCH' WHERE http_request_method='PATC';
    UPDATE plugin_userlog_request SET http_request_method='TRACE' WHERE http_request_method='TRAC';
    UPDATE plugin_userlog_request SET http_request_method='DELETE' WHERE http_request_method='DELE';
    UPDATE plugin_userlog_request SET http_request_method='CONNECT' WHERE http_request_method='CONN';
    UPDATE plugin_userlog_request SET http_request_method='OPTIONS' WHERE http_request_method='OPTI';
    
    Other
    Empty
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Thomas Gerbet (tgerbet)
    Closed
    2021-10-20
    Attachments
    Empty
    References

    Follow-ups