DBI:ODBC "File size limit exceeded"

[Floyd-ATC]

Problem:
Perl DBI with FreeTDS ODBC suddenly stopped working with the curious error message "File size limit exceeded".

Solution:
FreeTDS logs to a file /var/log/odbc.log which has to be rotated. If the log file size reaches 2 Gbytes, FreeTDS crashes.

Rename the logfile to "/var/log/odbc.log.1" (or simply rename/delete it), then create a file "/etc/logrotate.d/freetds" with the following settings:

Kode: [Velg]

/var/log/odbc.log {
    daily
    rotate 3
    missingok
    sharedscripts
    postrotate
    endscript
}