additional info: that 3 messages appear everytime dbmail-util runs
[root@mail:~]$ /usr/sbin/dbmail-util -y -c -t -u -b -p -d -r 24h Ok. Found [4] missing rfcsize values. EEEEOk. Found [4] missing envelope values. EEEEOk. Found [4] un-cached physmessages. Am 02.04.2014 11:54, schrieb Reindl Harald: > that is really strange, i created that table as below but > there are still errors i don't understand :-( > > Apr 2 11:51:28 mail dbmail/maintenance[11468]: Warning:[db] > db_set_headercache(+1612): error retrieving > physmessage: [4114056] > Apr 2 11:51:28 mail dbmail/maintenance[11468]: Error:[message] > dbmail_message_retrieve(+1145): retrieval failed > for physid [4110996] > Apr 2 11:51:28 mail dbmail/maintenance[11468]: Warning:[db] > db_set_headercache(+1612): error retrieving > physmessage: [4110996] > Apr 2 11:51:28 mail dbmail/maintenance[11468]: Error:[message] > dbmail_message_retrieve(+1145): retrieval failed > for physid [4108924] > Apr 2 11:51:28 mail dbmail/maintenance[11468]: Warning:[db] > db_set_headercache(+1612): error retrieving > physmessage: [4108924] > Apr 2 11:51:28 mail dbmail/maintenance[11468]: Error:[message] > dbmail_message_retrieve(+1145): retrieval failed > for physid [4108917] > Apr 2 11:51:28 mail dbmail/maintenance[11468]: Warning:[db] > db_set_headercache(+1612): error retrieving > physmessage: [4108917 > > CREATE TABLE `dbmail_messageblks` (`messageblk_idnr` bigint(20) unsigned NOT > NULL AUTO_INCREMENT, `physmessage_id` > bigint(20) unsigned NOT NULL DEFAULT '0', `messageblk` longblob NOT NULL, > `blocksize` bigint(20) unsigned NOT NULL > DEFAULT '0', `is_header` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY > KEY (`messageblk_idnr`), KEY > `physmessage_id_index` (`physmessage_id`), KEY > `physmessage_id_is_header_index` (`physmessage_id`,`is_header`), > CONSTRAINT `dbmail_messageblks_ibfk_1` FOREIGN KEY (`physmessage_id`) > REFERENCES `dbmail_physmessage` (`id`) ON > DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8 > ROW_FORMAT=COMPRESSED; > > > Am 31.03.2014 15:59, schrieb Reindl Harald: >> 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
