Georg Faerber via Postfix-users:
>   postfix/trivial-rewrite[1041973]: fatal: dict_sqlite_lookup: 
> /etc/postfix/schleuder_domain_sqlite.cf: SQL prepare failed: disk I/O error?
>   postfix/smtpd[1041595]: warning: problem talking to service rewrite: 
> Application error
> 
> which is thrown via postfix/src/global/dict_sqlite.c:206,

        msg_fatal("%s: %s: SQL prepare failed: %s\n",
                  myname, dict_sqlite->parser->name,
                  sqlite3_errmsg(dict_sqlite->db));

This is after sqlite3_prepare_v2() fails, and sqlite3_errmsg()
returns "disk I/O error".

There are many scenarios where SQLIte can fail with a "disk I/O
error". The one you cite happens when people change a database
password with Roundcube.

Note that Postfix programs open the database with SQLITE_OPEN_READONLY,
and that any attempt to make a change is guaranteed to fail.

To figure out what databases setting needs to be fixed, you can test
the Postfix SQLIte cliebt with:

    postmap -q whatever sqlite:/etc/postfix/schleuder_domain_sqlite.cf

and then turn on SQLIte debug logging.

        Wietse
_______________________________________________
Postfix-users mailing list -- postfix-users@postfix.org
To unsubscribe send an email to postfix-users-le...@postfix.org

Reply via email to