Re: ConnectorMXJObjectTestExample

On Mon, 2006-09-25 at 09:49 +0200, tech wrote:
> Each and every time I run ConnectorMXJObjectTestExample (paragraph 27.4.3.2
> of the online manual for Connector/MXJ) 
> 
> I got the error message: "InnoDB: Database was not shut down normally!"
> 
> I cannot understand why, since each and every time the last message in the
> console output is: [MysqldResource] shutdown complete. 

Unfortunately, this is not very unusual on Windows machines using
Connector/MXJ. 

Connector/MXJ works by creating a separate process which runs the
"mysqld" or "mysqld-nt.exe" program. When Connector/MXJ is instructed to
shutdown the mysqld, it sometimes must forcibly terminate the process.
In those cases, when restarted, InnoDB will issue that message.

To date, we have not seen any cases where this results in any data
corruption. 

However, to be on the extra safe side, always be absolutely sure to
close all JDBC connections prior to shutting down the database.

> 
>  
> 
> Can anyone give me some hint on how to fix that ?

We hope that a future version may deal with this situation more
gracefully, but addressing that issue is not currently scheduled.

> 
>  
> 
> Thanks a lot. 

I hope I was able to answer you question, and I hope you're making good
progress with Connector/MXJ in your testing.

Cheers,
 - Eric

> 
> Roberto Regazzoni
> 
>  
> 
> 
> 
> 
> 
> Below you can find two console outputs: 
> 
>  
> 
> 
> 
> 
> 
> [MysqldResource] launching mysqld (getOptions)
> 
> [C:\Documents and Settings\Roberto\Impostazioni
> locali\Temp\mysql-mxj\bin\mysqld-nt.exe][--no-defaults][--console][--pid-fil
> e=C:\Documents and Settings\Roberto\Impostazioni
> locali\Temp\mysql-mxj\data\MysqldResource.pid][--socket=mysql.sock][--datadi
> r=C:\Documents and Settings\Roberto\Impostazioni
> locali\Temp\mysql-mxj\data][--basedir=C:\Documents and
> Settings\Roberto\Impostazioni locali\Temp\mysql-mxj][--port=3336]
> 
> [MysqldResource] launching mysqld (test-mysqld-thread)
> 
> 060925  9:35:29  InnoDB: Database was not shut down normally!
> 
> InnoDB: Starting crash recovery.
> 
> InnoDB: Reading tablespace information from the .ibd files...
> 
> InnoDB: Restoring possible half-written data pages from the doublewrite
> 
> InnoDB: buffer...
> 
> 060925  9:35:29  InnoDB: Starting log scan based on checkpoint at
> 
> InnoDB: log sequence number 0 43655.
> 
> InnoDB: Doing recovery: scanned up to log sequence number 0 43655
> 
> 060925  9:35:29  InnoDB: Started; log sequence number 0 43655
> 
> 060925  9:35:29 [Note] C:\Documents and Settings\Roberto\Impostazioni
> locali\Temp\mysql-mxj\bin\mysqld-nt.exe: ready for connections.
> 
> Version: '5.0.22-community-nt'  socket: ''  port: 3336  MySQL Community
> Edition (GPL)
> 
> [MysqldResource] mysqld running as process: 2664
> 
> MySQL is running.
> 
> ------------------------
> 
>  
> 
> 5.0.22-community-nt
> 
>  
> 
> ------------------------
> 
> [MysqldResource] stopping mysqld (process: 2664)
> 
> [MysqldResource] clearing options
> 
> [MysqldResource] shutdown complete 
> 
>  
> 
> 
> 
> 
> 
> 
> 
> 
> 
> [MysqldResource] launching mysqld (getOptions)
> 
> [C:\Documents and Settings\Roberto\Impostazioni
> locali\Temp\mysql-mxj\bin\mysqld-nt.exe][--no-defaults][--console][--pid-fil
> e=C:\Documents and Settings\Roberto\Impostazioni
> locali\Temp\mysql-mxj\data\MysqldResource.pid][--socket=mysql.sock][--datadi
> r=C:\Documents and Settings\Roberto\Impostazioni
> locali\Temp\mysql-mxj\data][--basedir=C:\Documents and
> Settings\Roberto\Impostazioni locali\Temp\mysql-mxj][--port=3336]
> 
> [MysqldResource] launching mysqld (test-mysqld-thread)
> 
> 060925  9:45:02  InnoDB: Database was not shut down normally!
> 
> InnoDB: Starting crash recovery.
> 
> InnoDB: Reading tablespace information from the .ibd files...
> 
> InnoDB: Restoring possible half-written data pages from the doublewrite
> 
> InnoDB: buffer...
> 
> 060925  9:45:02  InnoDB: Starting log scan based on checkpoint at
> 
> InnoDB: log sequence number 0 43655.
> 
> InnoDB: Doing recovery: scanned up to log sequence number 0 43655
> 
> 060925  9:45:03  InnoDB: Started; log sequence number 0 43655
> 
> 060925  9:45:03 [Note] C:\Documents and Settings\Roberto\Impostazioni
> locali\Temp\mysql-mxj\bin\mysqld-nt.exe: ready for connections.
> 
> Version: '5.0.22-community-nt'  socket: ''  port: 3336  MySQL Community
> Edition (GPL)
> 
> [MysqldResource] mysqld running as process: 1800
> 
> MySQL is running.
> 
> ------------------------
> 
>  
> 
> 5.0.22-community-nt
> 
>  
> 
> ------------------------
> 
> [MysqldResource] stopping mysqld (process: 1800)
> 
>  
> 
> 
> 
-- 
Eric Herman, Software Developer
MySQL AB, www.mysql.com
VoIP Ext: 6594   US: +1 408 213 6540  Europe: +46 18 174 400
Mobile: +31 [0]6-20719662
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]