I got this strange situation, with 2 PC with win2000 and mysql 5.0.18 with
the replica enabled.
Apparently both the server and slave have no operation to do, but on the
slave were created more than 5000 relay-bin file in less than 45 minutes
I added some log, also they seems normal.
Is the
I forgot to add that the reset slave command worked properly , deleting all
the relay-bin files.
After the reset slave, I restart the slave and the realy files didn't grow
in number ( I got only ones of it ).
-Messaggio originale-
Da: AESYS S.p.A. [Enzo Arlati] [mailto:[EMAIL PROTECTED
I found out that when I run a query like 'show slave status' mysql I get
wrong size of the data field.
The component I using to read the field are using the field length by the db
to allocate the space for data, so the mismatch cause the read of truncated
data.
Is this bug already known, and if
?
-Messaggio originale-
Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Inviato: mercoledi 11 gennaio 2006 16.20
A: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] Mysql. Com (E-mail)
Oggetto: Re: wrong field size on query like 'show slave status'
AESYS S.p.A. [Enzo Arlati] [EMAIL PROTECTED] wrote on 01/11/2006
I already tried the option --slave-skip-errors, but i didn't work as
expected.
When this option is enabled, the slave didn't report the error message, but
the slave is stopped due the error.
The target I need to reech is to get two server A e B, each of them have its
own db server and a set of
I found a problem using stored procedure and bin-log enabled.
Suppose I stored procedure like this:
==
DELIMITER $$;
DROP PROCEDURE IF EXISTS `pmv_manager`.`pAggiornaStatusNotificaPMV`$$
CREATE PROCEDURE `pAggiornaStatusNotificaPMV`( ipAddrPMV
should skip.
sql_slave_skip_counter decrements each time the slave skips one event. Your
slave has already skipped 5 events, so the value of events that it should
skip is 0.
AESYS S.p.A. [Enzo Arlati] wrote: I'm trying to use teh parameter
sql_slave_skip_counter at run-time to
restore slave
Sorry, I didn't understand your replay.
Is not clear to me if you are talking about a mysql bug and there is some
solution available.
Please, Can you expand more on your answer.
Regards, Enzo
-Messaggio originale-
Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Inviato: giovedì 29
in two ways - using MySQL client or
native MySQL network protocol. Which of these two options are you using?
AESYS S.p.A. [Enzo Arlati] wrote: I'm using mysql 5.0.15 on windows 2000.
I connect to database using MYDAC component, which seems to work well
enough. I got a problem when I tried to load
are you using?
AESYS S.p.A. [Enzo Arlati] wrote: I'm using mysql 5.0.15 on windows 2000.
I connect to database using MYDAC component, which seems to work well
enough. I got a problem when I tried to load the resultset returned by a
query like 'show slave status'. In this case some of the fields
Is there in mysql 5 a datatype similar to the oracle rowtype ?
To better explain I include the following example which should be working on
oracle and don't run on mysql
CREATE PROCEDURE pTest()
BEGIN
declare c cursor for select * from table_test;
declare crec c%rowtype;
open c;
I'm trying to use teh parameter sql_slave_skip_counter at run-time to
restore slave replication.
When a slave replication broke due some errors in code, my be a duplicate
key, the only working way to restore the replica where to delete the
existing record which conflicts whith the ones inserted by
originale-
Da: Atle Veka [mailto:[EMAIL PROTECTED]
Inviato: mercoledi 28 dicembre 2005 20.47
A: AESYS S.p.A. [Enzo Arlati]
Cc: mysql@lists.mysql.com
Oggetto: Re: what about slave_skip_errors variables
Are you saying that from time to time it happens that data gets inserted
directly to the slave
I got the same problem.
In theory there should be some method to avoid duplicate entry during
replication, but in practise all that way seems to fail, mybe I'm not using
it properly ( see my threads on this topic ).
The only can help you go on , but is a dirty trick is remove the file from
the
I'm using mysql 5.0.15 on windows 2000.
I connect to database using MYDAC component, which seems to work well
enough.
I got a problem when I tried to load the resultset returned by a query like
'show slave status'.
In this case some of the fields are truncated.
As example the first field named
Hi,
I got some mysql server connectet with the replica enabled and from time to
time it appen that the replicated data are still be inserted in the slave,
so the replication server stop working due the duplicate entry error.
For my purpose there is no matter to ignore these errors so I try to use
on procedure test_procedure to '%'@localhost;
-Messaggio originale-
Da: AESYS S.p.A. [Enzo Arlati] [mailto:[EMAIL PROTECTED]
Inviato: venerdì 18 novembre 2005 14.37
A: mysql@lists.mysql.com
Oggetto: setup permission for stored procedure on mysql 5
If I defined I stored procedure as root I
If I defined I stored procedure as root I can't be able to call this
procedure from a normal user.
I tried to grant it the execute method but the sintax seems wrong
For example suppose a simple store procedure like this:
CREATE PROCEDURE `test_root`()
BEGIN
declare a int default 0;
END
if I
I need to pass to a stored procedure a var a table name.
But I don't known how use the variable in the sql statement.
If I use the method described belowe I get an error, the procedure use the
variable name as the name of the table.
Someone can help ?
CREATE FUNCTION `myFunc`( tbl_name
Hi, I'm trying to migrate from MySQL 4.1.11 to MySQL 5.0 and I get a problem
with the new release.
I have this table...
provasql CREATE TABLE `provasql`
`idrow` bigint(20) unsigned NOT NULL default '0',
`descr` varchar(50) default NULL,
PRIMARY KEY (`idrow`)
) ENGINE=InnoDB DEFAULT
Hi, I'm trying to migrate from MySQL 4.1.11 to MySQL 5.0 and I get a problem
with the new release.
I have this table...
provasql
CREATE TABLE `provasql`
`idrow` bigint(20) unsigned NOT NULL default '0',
`descr` varchar(50) default NULL,
PRIMARY KEY (`idrow`)
) ENGINE=InnoDB DEFAULT
2005 07:30 am, AESYS S.p.A. [Enzo Arlati] wrote:
Hi, I'm trying to migrate from MySQL 4.1.11 to MySQL 5.0 and I get a
problem with the new release.
I have this table...
provasql
CREATE TABLE `provasql`
`idrow` bigint(20) unsigned NOT NULL default '0',
`descr` varchar(50) default NULL
.AESYS S.p.A. [Enzo Arlati]
[EMAIL PROTECTED] wrote:I got this problem: I need to save in a
varchar field a string wich can have the ended part filled with blank
character, and I need to restore the string in the same way it was saved,
ie. with the right number of ended blank characters. Mysql
I got this problem:
I need to save in a varchar field a string wich can have the ended part
filled with blank character, and I need to restore the string in the same
way it was saved, ie. with the right number of ended blank characters.
Mysql truncate tha last blank characaters of a field
for
, it just die. It
is recreated by it master when required.
thanks
-Messaggio originale-
Da: Philippe Poelvoorde [mailto:[EMAIL PROTECTED]
Inviato: venerdi 18 febbraio 2005 18.11
A: AESYS S.p.A. [Enzo Arlati]
Cc: [EMAIL PROTECTED] Mysql. Com (E-mail)
Oggetto: Re: How remove the closed
I get an application with several thread , with each thread using it's own
connection.
What I mean is that the thread create a connection at the beginning and
close and detroy it before it close.
Under some circustances some of these threads close itself and reopen after
few minutes ( for example
26 matches
Mail list logo