Hi John,
Actaually, after doing root cause analysis. I got where is the problem.
mysql-5.1.30 (server C) runs replication in two mode namely STRICT and
IDEMPOTANT. Both of these mode is catching the problem.
I believe replicaton has been enhanced on mysql version 5.1.30 . When ever
any update is
I think maybe in the default sql_mode 5.0 is more forgiving when it comes
to accepting invalid values, quietly converting them to the nearest
acceptable value and giving a warning whereas 5.1 gives an error.
Personally i would rather have the data rejected and an error returned
because if MySQL i
Yes, sql_mode is blank on all server A, B, C
On Wed, Jan 21, 2009 at 8:40 PM, John Daisley <
john.dais...@mypostoffice.co.uk> wrote:
> Is the sql_mode set the same on A/B/C?
>
> >
> > Why are A and B letting you cram NULL into a column declared NOT NULL?
> >
> >
> >
> > Are your schemas consisten
Is the sql_mode set the same on A/B/C?
>
> Why are A and B letting you cram NULL into a column declared NOT NULL?
>
>
>
> Are your schemas consistent on A/B/C?
>
>
>
> Perhaps 5.0.32 does not enforce NOT NULL properly?
>
> Some tweak to config may change this?
>
>
>
> I don't know the answer, but
Why are A and B letting you cram NULL into a column declared NOT NULL?
Are your schemas consistent on A/B/C?
Perhaps 5.0.32 does not enforce NOT NULL properly?
Some tweak to config may change this?
I don't know the answer, but with a bit of research in this direction, you
should be ther
ERROR: not null column cannot be updated with null value. This error is
catched by server C mysql 5.1.30 but not my server B mysql 5.0.32
In production we have three servers.
A> B -C
A is replicating to B. B is replicating to C
A mysql-5.0.32 (Write)
B
What error is shown by 'show slave status\G' on server C after you
issue that query?
There's all sorts of things that could break replication...
On Tue, Jan 20, 2009 at 7:21 AM, Krishna Chandra Prajapati
wrote:
> Hi Baron,
>
> In production we have three servers.
>
> A> B ---
Hi Baron,
In production we have three servers.
A> B -C
A is replicating to B. B is replicating to C
A mysql-5.0.32 (Write)
B mysql-5.0.32 (Read)
C mysql-5.1.30 (Report Server) Complex and big queries scanning all
data.
*ISSUE*: If any query
