Re: Re: IBM-AIX 4.3 MySQL Binnary Installation Problem: libz ismissing.

2002-07-27 Thread Rick Flower
Francisco writes: >Also, when I try to compile mysql-3.23.51.tar.gz, I >get the following error executing the make command: >"my_gethostbyname.c", line 81.5: 1506-068 (S) >Operation between types "struct hostent*" and "int" is >not allowed. You need to modify the config file, since you are usin

Re: Innodb startup hangs on AIX 4.3.3 when built with IBM'sVisualAge C/C++ compiler 5.0.x

2002-07-18 Thread Rick Flower
[ MySQL ] Here's some additional data now that I've rebuilt using "--enable-debug" or whatever the configure option is. Here's what GDB is claiming is happening after it ran for about 2 minutes (after initial startup when NO files needed to be created) (gdb) where #0 thr_local_get (id=60) at

Innodb startup hangs on AIX 4.3.3 when built with IBM's VisualAgeC/C++ compiler 5.0.x

2002-07-18 Thread Rick Flower
Hi.. I recently built MySQL 3.23.51 on two different AIX 4.3 boxes using the VisualAge C/C++ compiler 5 only to find that that MySQL daemon is unable to properly start itself.. Below is the excerpt from the "err" file.. I waited until it was done with writing out the large InnoDB log/data file

What's up with MyODBC-3.51.03...????

2002-07-12 Thread Rick Flower
Ok.. Bug #2.. (yes, I'm getting a bit cranky!).. The "copy_if_not_empty()" routine is whacking my username (and it would my password if it was also set). In my case, the routine gets the following args : copy_if_not_empty (to=0x7f7f41b0 "rflower", max_length=64, from=0x7f7f0980 "", length=-3

MyODBC-3.51.03 crashes in SQLError with Bus Error

2002-07-12 Thread Rick Flower
I've found a nasty in SQLError.. I'm guessing it is a causualty of cut-n-paste.. Notice that the CLEAR_STMT_ERROR macro is being used to clear the error of "hstmt" when it's null.. Not only is the macro name wrong, but the argument as well.. In my case, hstmt was null, and it was dereferencing

Stupid libtool & MyODBC on HP-UX 11i

2002-07-12 Thread Rick Flower
Sorry about the rant.. I've been spending the last two days trying to install gcc, MySQL, MyODBC and UnixODBC on several AIX and HP boxes with varying degrees of success and lots of aggravation (much of it due to braindead configure scripts that ALWAYS want to leave gcc arguments around when N

MyODBC windows driver "auto" setup..

2002-06-26 Thread Rick Flower
When trying to use the "/auto" feature of the Windows MyODBC driver setup program, it wants to use read a "odbcinst.ini" file. Anyone have any info on the format of this file and what should be in it? Many thanks in advance... -- Rick MySQL spam killer strikes again.. (not) ---

Building MySQL 3.23.51 on AIX using VisualAge compiler rev 5020

2002-06-23 Thread Rick Flower
I'm trying in vain to build the latest version of MySQL 3.23.51 (downloaded today) on a new AIX box we've recently setup. It has the latest IBM patches for the VisualAge C++ compiler v5, bringing it up to rev 5020. When building, there are two problems.. One is that the configure script impro

Re: Re: memory leaks in libmysqlclient.

2002-04-25 Thread Rick Flower
dOMi writes: >However, after only a week the memory usage ocf this process >has been grown to 40 - 50 MB so there's have to leakage somewhere. What you *may* be seeing is standard memory fragmentation that many Unix' systems have with the standard allocator.. You don't mention what platform you'

Inserting records with null foreign keys?

2002-03-20 Thread Rick Flower
Hi all.. I noticed that the current version of InnoDB that is part of MySQL 3.23.47 does not allow using null foreign keys when doing inserts.. Is this intentional or a bug? This is allowed by SQL Server as a minimum (a test is being done by a co-worker currently against Oracle 8i to see how

Re: constraints in InnoDB, or is 3.23.43b _really_ < 4.0.1?

2002-03-13 Thread Rick Flower
Tomasz writes: >> >From section 16 of http://www.innodb.com/ibman.html you find detailed >>information about every InnoDB version. For example, 4.0.1 == 3.23.47. >> >>Foreign keys should work in 4.0.1. >Hmmm... That's what I read, too. And after several unsuccesful attempts >to create my ow

AW: InnoDB frightens me...

2002-03-04 Thread Rick Flower
Christian Rabe writes: >Are there plans on creating more than on tablesspace plus making them >selectable ? >So that I can tell the DB: >- in which datafiles to store the tablespace X >- in which tablespace to store table Y This is one of the things I was wondering about.. If I have multiple Inn

Innodb tables lose foreign keys after creating an index...

2002-02-28 Thread Rick Flower
Hi all.. Are any of you aware of a way to get indexes to work at all with Innodb tables containing foreign keys? I'm finding that after doing a "create index" on a table which *had* foreign keys, after the create, the foreign keys are gone.. I've included a simple test below which shows off t

Exceeding 4.2GB data files on Solaris8...?

2002-02-18 Thread Rick Flower
By chance, is it at all possible to exceed the 4.2GB file size barrier on Solaris 8 with MySQL 3.23.47? I've got one built with both GCC and another one with the Solaris Workshop 6 compiler.. Neither can exceed that magical number for some reason.. Both were built with large-files enabled.. In fa