cdr and call recording module not showing known recordings

Example of issue:

Output from CDR :

Output from: mysql -D asteriskcdrdb -e "select * from cdr "

ODBC ini:

 cat /etc/odbc.ini
[MySQL-asteriskcdrdb]
Description=MySQL connection to 'asteriskcdrdb' database
driver=MySQL
server=localhost
database=asteriskcdrdb
Port=3306
Socket=/var/lib/mysql/mysql.sock
option=3
Charset=utf8

asterisk -vvvrx "cdr show status"

Call Detail Record (CDR) settings
----------------------------------
Logging: Enabled
Mode: Simple
Log unanswered calls: No
Log congestion: No

• Registered Backends
  -------------------
  Adaptive ODBC 

The call recordings are present and where they should be:

 ls -Rl /var/spool/asterisk/monitor

 rw-rr- 1 asterisk asterisk 3536684 Oct 29 10:26 9703026618-1540822956-1540822956.108208.wav
rw-rr- 1 asterisk asterisk 2544364 Oct 29 11:59 9703026618-1540828600-1540828600.108918.wav
rw-rr- 1 asterisk asterisk 959084 Oct 29 12:20 9726707436-1540829972-1540829972.109058.wav

/var/spool/asterisk/monitor/2018/10/30:
total 1728
rw-rr- 1 asterisk asterisk 609964 Oct 30 06:54 18004179004-1540896839-1540896839.111791.wav
rw-rr- 1 asterisk asterisk 1158124 Oct 30 06:56 18004179004-1540896905-1540896905.111793.wav