Re: connector mxj can't init db on linux

On Tue, 2006-05-02 at 12:56 +0200, Andreas Schlicker wrote:
> Hi Eric,
> 
>  > Let me lead with the question: are we seeing failures on multiple CPU
>  > machines? Here is why I ask:
> 
> The failures occur on single and multi CPU machines. The workstations 
> are single Pentium 4 machines but I also tried cluster nodes with 2 
> Opterons.

Sounds like it isn't that simple. No surprise there.

> 
>  > So perhaps what we are seeing is a timing issue?
> The problem occurs even if I wait several days before launching the 
> second program.

Thus, not the timing issue referenced in that bug. However, I do think
that we might be looking at an issue that has to do with the server
("mysqld") and possibly totally independent of the Connector/MXJ
wrapper.

> 
> > If this is /not/ the issue, then obviously there is *something*
> > configuration dependent here. Let's get as much information as we can
> > about the failing systems and compare it to the working systems.
> > 
> > let's start with a couple of: 
> >  * Which versions of Debian? ("sarge?") ("stable?")
> sarge; we have an internal "distribution" from our computer support 
> group which includes, as far as I know, also some testing packages.

Okay, well that sounds like it may be pretty hard for me to duplicate.
But, I can certainly find a "stock" sarge/testing x86 machine to try to
duplicate this problem on. 

> 
> >  * What is the result of "uname -a"
> Linux mpiat3405 2.6.13.4.2.p4 #1 Thu Nov 17 12:23:31 UTC 2005 i686 GNU/Linux
> 
> >  * Which JVM? 
> java version "1.5.0_06"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)
> Java HotSpot(TM) Client VM (build 1.5.0_06-b05, mixed mode, sharing)
> 
> >  * For the record, which version of Connector/J? (This won't make any
> > difference for this issue, of course.)
> 3.1.11
> 
> >  * We aren't running as "root" are we?
> No, as normal user
> 
> >  * We're using Connector/MXJ 1.1.6, in all cases, correct?
> Exactly.
> 
> 
> My laptop uses exactly the same kernel and the same distribution but 
> everything runs smoothly.
> 

And this suggests it may be even more tricky to duplicate. Rats.


Let's see if we can confirm whether or not Connector/MXJ is directly
related to the issue. Let's start be removing Connector/MXJ from the
picture. 

My proposal is to alter the test programs to just use Connector/J and
JDBC ... and to move the starting and stopping of the database to the
command line between applications.

Now to start the server you'll need to run the same command that
Connector/MXJ constructs from the arguments which you provide. It will
look something like this:

/path/to/basedir/mysqld \
 --no-defaults \
 --pid-file=/path/to/basedir/MysqldResource.pid \
 --socket=/path/to/basedir/mysql.sock \
 --port=3336 \
 --datadir=/path/to/basedir/data \
 --basedir=/path/to/basedir

You can find out exactly what command line arguments are being used by
running your test program and viewing the Connector/MXJ output. You
should see a reconstruction of the command line with each command line
element encapsulated in square brackets.

Then, to terminate the database, use "kill <PID>". 
You can find the PID by looking at the screen output of the mysqld
command, or by reading the MysqldResource.pid file.

First, I'd like you to give this a go on your laptop where we expect
everything to succeed. Once it works there, second, I'd like to have you
give it a try with one of the machines on which we're experiencing the
"InnoDB: Unable to lock ./ibdata1, error: 11" problem.

With a little luck, this will tell us that we have a server platform
issue. If this is the case, then updating the linux mysqld in the
connector-mxj.jar file may be the solution.

Best of luck on the bug hunt, and please let me know what you learn. And
if you get stuck, please don't be shy about asking questions.

Cheers,
 -- Eric

> Regards,
> Andreas


-- 
Eric Herman, Software Developer
MySQL AB, www.mysql.com
Mobile: +1 206 913 8942

Are you MySQL certified?  www.mysql.com/certification


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]