not sure in which circumstances "dbmail-util" still try to convert old physmessages from dbmail-2.x but in case it does not exist dbmail-3.x i guess should be happy - migration flag not set
/usr/sbin/dbmail-util -y -c -t -u -b -p -d -r 24h >> $LOGFILE -M migrate legacy 2.2.x messageblks to mimeparts table _____________________________________________________________________ Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+370): SQLException: Table 'dbmail.dbmail_messageblks' doesn't exist Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+371): failed query [SELECT b.messageblk, b.is_header, DATE_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO')) FROM dbmail_me Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[message] dbmail_message_retrieve(+1145): retrieval failed for physid [4110996] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Warning:[db] db_update_rfcsize(+1566): error retrieving physmessage: [4110996] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+370): SQLException: Table 'dbmail.dbmail_messageblks' doesn't exist Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+371): failed query [SELECT b.messageblk, b.is_header, DATE_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO')) FROM dbmail_me Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[message] dbmail_message_retrieve(+1145): retrieval failed for physid [4108924] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Warning:[db] db_update_rfcsize(+1566): error retrieving physmessage: [4108924] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+370): SQLException: Table 'dbmail.dbmail_messageblks' doesn't exist Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+371): failed query [SELECT b.messageblk, b.is_header, DATE_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO')) FROM dbmail_me Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[message] dbmail_message_retrieve(+1145): retrieval failed for physid [4108917] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+370): SQLException: Table 'dbmail.dbmail_messageblks' doesn't exist Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+371): failed query [SELECT b.messageblk, b.is_header, DATE_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO')) FROM dbmail_me Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[message] dbmail_message_retrieve(+1145): retrieval failed for physid [4110996] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Warning:[db] db_set_envelope(+1681): error retrieving physmessage: [4110996] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+370): SQLException: Table 'dbmail.dbmail_messageblks' doesn't exist Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+371): failed query [SELECT b.messageblk, b.is_header, DATE_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO')) FROM dbmail_me Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[message] dbmail_message_retrieve(+1145): retrieval failed for physid [4108924] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Warning:[db] db_set_envelope(+1681): error retrieving physmessage: [4108924] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+370): SQLException: Table 'dbmail.dbmail_messageblks' doesn't exist Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+371): failed query [SELECT b.messageblk, b.is_header, DATE_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO')) FROM dbmail_me Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[message] dbmail_message_retrieve(+1145): retrieval failed for physid [4108917] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Warning:[db] db_set_envelope(+1681): error retrieving physmessage: [4108917] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+370): SQLException: Table 'dbmail.dbmail_messageblks' doesn't exist Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+371): failed query [SELECT b.messageblk, b.is_header, DATE_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO')) FROM dbmail_me Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[message] dbmail_message_retrieve(+1145): retrieval failed for physid [4110996] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Warning:[db] db_set_headercache(+1612): error retrieving physmessage: [4110996] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+370): SQLException: Table 'dbmail.dbmail_messageblks' doesn't exist Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+371): failed query [SELECT b.messageblk, b.is_header, DATE_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO')) FROM dbmail_me Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[message] dbmail_message_retrieve(+1145): retrieval failed for physid [4108924] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Warning:[db] db_set_headercache(+1612): error retrieving physmessage: [4108924] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+370): SQLException: Table 'dbmail.dbmail_messageblks' doesn't exist Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[db] db_query(+371): failed query [SELECT b.messageblk, b.is_header, DATE_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO')) FROM dbmail_me Mar 31 15:51:29 mail dbmail/maintenance[6357]: Error:[message] dbmail_message_retrieve(+1145): retrieval failed for physid [4108917] Mar 31 15:51:29 mail dbmail/maintenance[6357]: Warning:[db] db_set_headercache(+1612): error retrieving physmessage: [4108917]
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
