Thomas,
I'm running 2.6.0 with most of the mentioned patches in production
since a while, no issues right now. The small cluster is currently
hit by peaks of nearly 6 million delivery attempts a day. Most of
them fortunately do NOT hit Amavis, but there are still a few million
mails in
Mark Martinec wrote:
As reported by Leonardo Rodrigues, there is a mismatch on data types
on foreign keys, which is why a table msgs (and subsequent ones) can not
be built, because msgs.sid is referencing maddr.id of a different type.
Please try the schema in:
5 rows in set (0.00 sec)
mysql CREATE TABLE quarantine (
- mail_idvarchar(12) NOT NULL,-- long-term unique mail id
- chunk_ind integer unsigned NOT NULL, -- chunk number, starting
with 1
- mail_text blob NOT NULL, -- store mail as chunks
of
On Thu, June 26, 2008 14:20, Michael Scheidell wrote:
ERROR 1005 (HY000): Can't create table './amavisd/quarantine.frm'
(errno: 150)
It looks like you did not build innodb support into mysql, and/or did not
read and edit the my.cnf to enable the innodb values.
i have seen this error # with
Hi
Zhang Huangbin skrev:
Leonardo Rodrigues Magalhães wrote:
Mark Martinec escreveu:
A release candidate of amavisd-new-2.6.1 is available at:
http://www.ijs.si/software/amavisd/amavisd-new-2.6.1-rc1.tar.gz
Release notes:
http://www.ijs.si/software/amavisd/release-notes.txt
The
Max Matslofva wrote:
Hi
Zhang Huangbin skrev:
Leonardo Rodrigues Magalhães wrote:
Mark Martinec escreveu:
A release candidate of amavisd-new-2.6.1 is available at:
http://www.ijs.si/software/amavisd/amavisd-new-2.6.1-rc1.tar.gz
Release notes:
Zhang Huangbin skrev:
Max Matslofva wrote:
Hi
Zhang Huangbin skrev:
Leonardo Rodrigues Magalhães wrote:
Mark Martinec escreveu:
A release candidate of amavisd-new-2.6.1 is available at:
http://www.ijs.si/software/amavisd/amavisd-new-2.6.1-rc1.tar.gz
Release notes:
Max Matslofva wrote:
Zhang Huangbin skrev:
Max Matslofva wrote:
Hi
Zhang Huangbin skrev:
Leonardo Rodrigues Magalhães wrote:
Mark Martinec escreveu:
A release candidate of amavisd-new-2.6.1 is available at:
Zhang Huangbin skrev:
Hi, Max.
I deleted all 'ENGINE=InnoDB' in README.sql-mysql and use 'SOURCE' to
import it, it works.
What's wrong with it? Am i missing something?
Test if you can create anything using InnoDB
mysql CREATE TABLE noInnoDB ( test varchar(10)) ENGINE=MyISAM;
Query OK,
Max Matslofva schrieb:
mysql CREATE TABLE quarantine (
- ...
- FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE
- ) ENGINE=InnoDB;
ERROR 1005 (HY000): Can't create table './maxtest/quarantine.frm' (errno: 150)
mysql CREATE TABLE msgs (
- ...
Thomas Gelf skrev:
Max Matslofva schrieb:
mysql CREATE TABLE quarantine (
- ...
- FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE
- ) ENGINE=InnoDB;
ERROR 1005 (HY000): Can't create table './maxtest/quarantine.frm' (errno:
150)
mysql CREATE TABLE msgs
Max Matslofva wrote:
Zhang Huangbin skrev:
Hi, Max.
I deleted all 'ENGINE=InnoDB' in README.sql-mysql and use 'SOURCE' to
import it, it works.
What's wrong with it? Am i missing something?
Test if you can create anything using InnoDB
mysql CREATE TABLE noInnoDB ( test
Zhang Huangbin skrev:
Hi, Max.
They all worked :(
mysql CREATE TABLE noInnoDB ( test varchar(10)) ENGINE=MyISAM;
Query OK, 0 rows affected (0.08 sec)
mysql drop table noInnoDB;
Query OK, 0 rows affected (0.00 sec)
mysql CREATE TABLE testInnoDB ( test varchar(10)) ENGINE=InnoDB;
Max Matslofva wrote:
Hi Zhang
Can you send the output from
mysql show tables;
and
mysql CREATE TABLE quarantine (
mail_idvarchar(12) NOT NULL,-- long-term unique mail id
chunk_ind integer unsigned NOT NULL, -- chunk number, starting with 1
mail_text blob NOT NULL,
A release candidate of amavisd-new-2.6.1 is available at:
http://www.ijs.si/software/amavisd/amavisd-new-2.6.1-rc1.tar.gz
Release notes:
http://www.ijs.si/software/amavisd/release-notes.txt
The 2.6.1 is a maintenance release, fixing known problems over 2.6.0
and meeting needs for MySQL
Mark Martinec escreveu:
A release candidate of amavisd-new-2.6.1 is available at:
http://www.ijs.si/software/amavisd/amavisd-new-2.6.1-rc1.tar.gz
Release notes:
http://www.ijs.si/software/amavisd/release-notes.txt
The 2.6.1 is a maintenance release, fixing known problems over 2.6.0
Leonardo,
I must confess that I didn't read your message really careful. And as
I'm using a partitioned db scheme since a little while your statement
doesn't directly meet my scenario. Foreign keys are no longer required
in a partitioned setup - you are even unable to use them (this is true
at
As we are talking about better default db schemas here some other
suggestions:
In current MySQL releases the following statements are true when using
CHAR datatypes:
v = V
BINARY(v) != BINARY(V)
As functions usually make all SQL searches on indexed fields slower I
decided to use
Mark Martinec schrieb:
A release candidate of amavisd-new-2.6.1 is available at:
...
The 2.6.1 is a maintenance release, fixing known problems over 2.6.0
and meeting needs for MySQL table partitioning.
Please try it out, the final release is due by the end of the week.
I'm running 2.6.0
Leonardo Rodrigues Magalhães wrote:
Mark Martinec escreveu:
A release candidate of amavisd-new-2.6.1 is available at:
http://www.ijs.si/software/amavisd/amavisd-new-2.6.1-rc1.tar.gz
Release notes:
http://www.ijs.si/software/amavisd/release-notes.txt
The 2.6.1 is a maintenance
20 matches
Mail list logo
