Search doesn’t work with ‘relation’ => ‘OR’

There is nothing obviously wrong with the code, assuming you are pushing those arguments through WP_Query, but the query you are trying to run is not going to be very efficient.

You have 6 meta values in an ‘OR’ relationship, which is not terribly efficient in itself as all of those rows have to be checked for matches, and all of your meta values are matched on a LIKE, which is a kind of regex, and >= or <= which require all of the rows to be read in order for the comparison to be made.

I’d be surprised if this failed with only 5 records in the table. It might but I’d be surprised, and it won’t be efficient in any circumstances. I notice that you have set posts_per_page to 5. That is not the same as the number of records in the table and that is going to reflect the number of $wpdb->post records, not the number of $wpdb->postmeta` records that have to be scanned.