Hi,
after upgrading, I had two problems:
/usr/local/mysql/bin/mysqld: ERROR: unknown variable 'query_buffer_size=32M'
I had to comment out this variable, it seems it got renamed. I have to
figure out what's the new name.
020828 17:30:12 mysqld started
020828 17:30:12 Can't find messagefil
mp;
# Make lock for RedHat / SuSE
if test -w /var/lock/subsys
then
On Wed, 17 Jul 2002, Alexander Keremidarski wrote:
> > Martin MOKREJŠ wrote:
> > How-To-Repeat:
> >
> > /usr/local/mysql/log# cp /dev/null jerboas.log
> > /usr/local/mysql/log# cp
Hi,
I've observed some table corruption:
How-To-Repeat: no idea, but maybe you might have one ;)
$ mysql -hxxx Escherichia_coli_O157_H7
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in t
Hi,
Victoria Reznichenko wrote:
VR> Martin,
VR> Wednesday, April 03, 2002, 5:45:00 PM, you wrote:
VR>
VR> MM> would anyone please explain me what are these error messages?
VR>
VR> MM> 020327 12:29:26 mysqld started
VR> MM> 020327 12:29:26 Warning: listen() on TCP/IP failed with error 98
V
Hi,
would anyone please explain me what are these error messages?
020327 12:29:26 mysqld started
020327 12:29:26 Warning: listen() on TCP/IP failed with error 98
/usr/local/mysql/bin/mysqld: ready for connections
/usr/local/mysql/bin/mysqld: ready for connections
020327 12:29:26 Error in ac
Hi,
sorry to bother you with this, but one thing one might look into is:
When table was dumped with --extended-insert option, that the server importing
the table does NOT perform well. In the output from `vmstat 1` each
second there's a lot of I/O, and at least on linux 2.4.19-pre1 it runs more
Hi, I've really interresting topic this time:
our application stopped getting data. It turned out these queries were
unexpectedly slow while operating on MyISAM tables:
++---+---+--+-+--++--
> On Mon, 28 Jan 2002, Sinisa Milivojevic wrote:
> > =?iso-8859-2?Q?Martin MOKREJ=A9?= writes:
> > > On Mon, 28 Jan 2002, Sinisa Milivojevic wrote:
Hi,
I am retrying to an answer to my question from January. Could please
someone from the developers have a look into this?
http://lists.mysql.com
Hi,
we have 3.23.42 official binaries running on Linux 2.4.17. It seems
mysqld does not read in from /etc/my.cnf the value for net_buffer_length.
When having in the config file:
[mysqld]
set-variable= net_buffer_length=16M
set-variable= max_allowed_packet=16M
[...]
I get
| net_buffer_l
On Mon, 28 Jan 2002, Sinisa Milivojevic wrote:
> =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> > On Mon, 28 Jan 2002, Sinisa Milivojevic wrote:
> >
> > Hi,
> >
> > Hmm, well because that's just a mysqldump of a database which already
> > exists in mysql and it turned out that I cannot reimport it
On Mon, 28 Jan 2002, Sinisa Milivojevic wrote:
> Are you sure that the above is the output from mysqldump ??
>
> What server version ??
Look into the original posting on Jan 9 2002 for complete description. ;-)
--
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / In
On Mon, 28 Jan 2002, Sinisa Milivojevic wrote:
Hi,
> This is not OK according to syntax as PRIMARY is a reserved word.
>
> UNIQUE KEY PRIMARY (id)
>
> Why don't you just say PRIMARY KEY (id) ??
Hmm, well because that's just a mysqldump of a database which already
exists in mysql and it turned
]
Cc: Martin MOKREJŠ <[EMAIL PROTECTED]>
Subject: RE: Cannot import mysql dump
* Martin MOKREJŠ
> I have a problem to re-import sql dump from Linux 2.2.19 running
> mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686)
> into the same mysqld under different database.
>
> whil
On Fri, 25 Jan 2002, Sinisa Milivojevic wrote:
Hi,
sorry, I didn't get it. As far as I know there's no way yet how to
uncompress table my using SQL command. I have to uncompress using
`myisamchk --unpack *.MYI`, right?
> =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> > Hi,
> > when I'm trying
Hi,
when I'm trying to lock multiple tables and some of the are Compressed,
mysql warn's me only about the first-one being Compressed. It either
reports the first Compressed table only from the list, or it checks
only the first-one in the list of tables to be locked:
mysql> use Escherichia_coli
Hi,
I have a problem to re-import sql dump from Linux 2.2.19 running
mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686)
into the same mysqld under different database.
while running the same commandline on the source at least.
$ mysqldump --extended-insert Bordetella_pertussis_Tohama_
Hi,
I have another example of this strange behaviour. I've managed to dump
most of the table and then after certain row got the error 127. This
machine is linux 2.2.17 in this particular example operating on table
close to the 2GB limit.
mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686)
Hi,
I'm using INSERT DELAYED to insert about 120GB of data into mysql from mysqldumpped
data from remote server. After the weekend I've found such output from our perl script
(after was dumped let's say 60GB):
Just dumping Mthermoautotrophicum.orf
Just dumping Mthermoautotrophicum.orf_data
Just
On Thu, 20 Dec 2001, Almar van Pel wrote:
> I believe this error is assigned to a crashed table.
>
> try repair table and afterwards optimize.
Eh, I forgot to mention that I've done CHECK TABLE a bit too late, when
the user came and said that the problem got fixed itself, and asked me
what I di
Hi,
once I've reported here problems that somehow randomly we get these
errors in mysql's log file. It looks, that when user drops a table, a
table isn't dropped or somehow remains in cache. The when user tries to
create the table again from scratch, he get's the error 127.
Please note that the
On Thu, 20 Dec 2001, Martin MOKREJŠ wrote:
> Hi,
> did someone manage to compile mysql on OSF1 4.0[D-F] series using
> Digital's cc and cxx compilers? Please Cc: me in reply, thanks.
>
> CC=cc CXX=cxx CFLAGS='-non_shared -O3 -tune-host' CXXFLAGS='-non_s
Hi,
did someone manage to compile mysql on OSF1 4.0[D-F] series using
Digital's cc and cxx compilers? Please Cc: me in reply, thanks.
CC=cc CXX=cxx CFLAGS='-non_shared -O3 -tune-host' CXXFLAGS='-non_shared
-O3 -tune-host' ./configure --with-libwrap
--with-mysqld-ldflags=-all-static --enable-ass
Hi,
I tried to compress some very big table on Linux and it seems to me that
myisampack does not properly remove temporary files after abort.
After myisampack cannot write to a file (because the filesystem is
full), it should at least remove the .TMD file after itself, I hope. :(
Since then,
On Tue, 13 Nov 2001, Gerald Clark wrote:
> Looks correct to me.
> What do you think is the problem?
>
> 2 rows were affected by the replace.
> One row was deleted, and one was inserted,
> Both rows had a value of 'test' for column 'Tab'.
Cool, thanks to Jeremy Zawodny and you, now I know even mo
Hello,
I think I've found a bug. Just by playing with REPLACE and INSERT, the
following happened. I'm including full log, demonstrating that I don't
understand sql at all. ;-) Can someone explain me what "2 rows affected"
means? How can I select the second row from the table? How can I delete it
Hi,
I've found there are missing binaries at least in
mysql-3.23.42-pc-linux-gnu-i686.tar.gz
Those are: isamlog, myisamlog, mysql_install_db, mysqlbinlog
I've checked that in the tar archive again, but not luck. Am I totally
blind? ;-)
--
Martin Mokrejs - PGP5.0i key is at http://www.natur.
Hi,
so I've tried the binary distribution for linux and I have these errors
in logfile (I've seen them already under 3.23.41, under which I compressed
the tables):
010910 18:12:20 mysqld started
/usr/local/mysql/bin/mysqld: ready for connections
010910 18:13:52 read_const: Got error 127 when
On Sun, 2 Sep 2001, Michael Widenius wrote:
Hi,
> > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
>
> Sinisa> =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> >> And should say that
> >>
> >> update rep set low='0.00' where id=148;
> >>
> >> solved my problem for command:
> >> mys
On Fri, 31 Aug 2001, Sinisa Milivojevic wrote:
> =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> > Hi again,
> > I have the following problem:
> >
> > "mysqldump -# --socket=/tmp/mysql.sock --add-drop-table -f --extended-insert
>--quick Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum"
> >
On Fri, 31 Aug 2001, Sinisa Milivojevic wrote:
> May be you used some special chars in column names. In that case you
> should use instruct mysqldump to use backticks for table and column
> names.
Ehh, now I know what you meant: - to use -Q option to mysqldump , ok
but it anyway did not hel
And should say that
update rep set low='0.00' where id=148;
solved my problem for command:
mysqldump -f --socket=/tmp/mysql.sock --add-drop-table --extended-insert
--quick --databases Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum
... to be complete. ;)
--
Martin Mokrejs - PGP5.0i key i
Hi again,
I have the following problem:
"mysqldump -# --socket=/tmp/mysql.sock --add-drop-table -f --extended-insert --quick
Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum"
ERROR 1054 at line 52: Unknown column 'nan' in 'field list'
I have even tried "OPTIMIZE TABLE REP; REPAIR TABL
On Fri, 31 Aug 2001, Michael Widenius wrote:
> > "mmokrejs" == mmokrejs writes:
>
> mmokrejs> On Thu, 30 Aug 2001, Michael Widenius wrote:
> mmokrejs> Hi,
> mmokrejs> yes this patch *fixes* all of my problems, except one table which is/was
> mmokrejs> probably too big? I haven't found an
On Thu, 30 Aug 2001, Michael Widenius wrote:
Hi,
yes this patch *fixes* all of my problems, except one table which is/was
probably too big? I haven't found any options that would make myisamchk to
ask for less memory.
/usr/local/mysql/bin/myisamchk: Out of memory (Needed 4294922813 bytes)
/usr
On Wed, 29 Aug 2001, Sasha Pachev wrote:
> On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote:
> > >Description:
> > I have on Linux running 3.23.41 the following problem:
> >
> > $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp
> /data/mysql/Aactinomycetemcomitans/blimps.MYI
> >
>Description:
I have on Linux running 3.23.41 the following problem:
$ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp
/data/mysql/Aactinomycetemcomitans/blimps.MYI
Compressing /data/mysql/Aactinomycetemcomitans/blimps.MYD: (1443 records)
- Calculating statistics
normal: 7 empty-
>
> Sorry about that - we have now fixed the problems with our anonymous FTP
> upload, and it should be working.
lokk in pub/mysql/secret/ for:
15593452(size) cogs_data.tgz
But same file should be accessible already via the 2 web links I've sent
to you via personal e-mail. Thanks.
--
Martin
On Mon, 27 Aug 2001, Martin MOKREJŠ wrote:
> > ftp://support.mysql.com/pub/mysql/secret
Hmm, I can already login as ftp, but can only chdir to /pub/mysql, there's
no secret directory. ;(
> http://pednew.gsf.de/cogs_data.tgz
Hmm, try out http://kulan.gsf.de/cogs_data.tgz , bu
+0200 (MET DST)
From: Martin MOKREJŠ <[EMAIL PROTECTED]>
To: Sinisa Milivojevic <[EMAIL PROTECTED]>
Subject: Re: repairing MyISAM table kills mysqld with SIG11
On Mon, 27 Aug 2001, Sinisa Milivojevic wrote:
> Please try out our binary distro. I guess that you would not like
> eithe
On Mon, 27 Aug 2001, Sinisa Milivojevic wrote:
Hi!
> Try to repair the same table with 3.23.41.
>
> If it fails, please let us know, so that we can give you upload
> instructions.
kulan$ ls -la /home/mysql/Mbovis/cogs_data*
-rw-rw1 pedant users54195408 Jul 4 03:52
/home/mysql/M
Hi,
I have a problem with one machine running Debian kernels 2.4.7 (2.4.9)
on Intel EtherExperssPro100 and mysql-3.23.39. When I try to upload data
into database, I get the error in %Subj%. The command used is:
bioadmin@caribou$ cat apernix.contig.sql | mysql --host=pednew ApernixK1
ERROR 2006
Hi,
some more notes:
when using strace to trace the startup, I see some strange errors:
read(198, " test -z \"$defaults\"\n then\n"..., 1024) = 1024
xstat(2, "/usr/local/mysql/var/data/mysql", 0xe0a31d0) = -1 ENOENT (No such file or
directory)
xstat(2, "./share/mysql/english/errmsg.sys", 0xe0
>Description:
While starting mysqld, mysqld stops with default values from
support-files/my-medium.cnf.
I'm not sure if it's really a bug or just inadequate buffer settings. Anyway, you
asked
in the $hostname.err to make a bug report. ;-) My compile time flags you have in my
previous
pos
43 matches
Mail list logo