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
