I have a panel showing these messages in the logs and returning emails to some users sporadically. 2024-03-25T12:32:14.071677-03:00 painel postfix/proxymap[725607]: warning: mysql:/etc/postfix/mysql-virtual_transports.cf: query failed: Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' 2024-03-25T12:32:14.071867-03:00 painel postfix/trivial-rewrite[725813]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "[email protected]" 2024-03-25T12:32:14.071907-03:00 painel postfix/trivial-rewrite[725813]: warning: transport_maps lookup failure 2024-03-25T12:32:14.072926-03:00 painel postfix/trivial-rewrite[725813]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "[email protected]" 2024-03-25T12:32:14.072970-03:00 painel postfix/trivial-rewrite[725813]: warning: transport_maps lookup failure
Comparing with another panel I realized that this database was created in utf8mb3_general_ci, different from the other two that are in utf8mb4_general_ci, what could have caused this?
