Read database list error, INNODB problem?
Posted by: Ugo Bellavance
Date: March 07, 2012 11:38AM

Hi,

I've filled the filesystem where resides my mysql database a few days ago and all databases seem to have been OK with that (once I freed space) except one, which is INNODB.

This database is the database backend for the Talend Administration Console. Talend is an ETL product that is quite complex and the MySQL database is the backend for their console, which work fine, except when we want to play with ETL jobs. I won't go into details unless if I'm asked to because I think this may be a problem with MySQL. The DB is on our central MySQL server and Talend is installed on another server (both VMWare VMs, same network, same physical host).

Here are the two errors that I got at first:

Unexpected exception on: org.talend.administrator.common.exception.DBException: ???Cannot flush and commit transaction.???

Lock wait timeout exceeded; try restarting transaction

Since then I've backed up the DB, restored it but got this error once in a while. I didn't get this error since yesterday, noon, but here is the reason why I think I may have screwed something with my MySQL server:

When I use DBeaver to access my DBs (no error with MySQL Workbench), I get java.lang.NullPointerException (see full log at the bottom of this post)

One mistake that I did is to create a copy of the DB, then delete it directly on the filesystem. I guess by doing that, the information_scheme didn't get updated.

I did a check table and analyse table on all the tables on all databases on this server. But I can't do a repair on InnoDB tables because InnoDB doesn't support that.

It there a way I could perform a health check of my DBs?

Thanks in advance.

====
java.lang.NullPointerException
at org.jkiss.dbeaver.model.impl.AbstractObjectCache.getCachedObject(AbstractObjectCache.java:65)
at org.jkiss.dbeaver.ext.mysql.model.MySQLDataSource.getCatalog(MySQLDataSource.java:87)
at org.jkiss.dbeaver.ext.mysql.model.MySQLDataSource.getSelectedObject(MySQLDataSource.java:299)
at org.jkiss.dbeaver.ext.mysql.model.MySQLDataSource.getSelectedObject(MySQLDataSource.java:1)
at org.jkiss.dbeaver.ui.views.navigator.database.DatabaseNavigatorLabelProvider.isDefaultElement(DatabaseNavigatorLabelProvider.java:123)
at org.jkiss.dbeaver.ui.views.navigator.database.DatabaseNavigatorLabelProvider.getFont(DatabaseNavigatorLabelProvider.java:90)
at org.eclipse.jface.viewers.WrappedViewerLabelProvider.getFont(WrappedViewerLabelProvider.java:85)
at org.eclipse.jface.viewers.WrappedViewerLabelProvider.update(WrappedViewerLabelProvider.java:172)
at org.eclipse.jface.viewers.ViewerColumn.refresh(ViewerColumn.java:152)
at org.eclipse.jface.viewers.AbstractTreeViewer.doUpdateItem(AbstractTreeViewer.java:938)
at org.eclipse.jface.viewers.AbstractTreeViewer$UpdateItemSafeRunnable.run(AbstractTreeViewer.java:106)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)
at org.eclipse.jface.viewers.AbstractTreeViewer.doUpdateItem(AbstractTreeViewer.java:1018)
at org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1876)
at org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1840)
at org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1826)
at org.eclipse.jface.viewers.AbstractTreeViewer.createAddedElements(AbstractTreeViewer.java:341)
at org.eclipse.jface.viewers.AbstractTreeViewer.internalAdd(AbstractTreeViewer.java:273)
at org.eclipse.jface.viewers.TreeViewer.internalAdd(TreeViewer.java:662)
at org.eclipse.jface.viewers.AbstractTreeViewer.add(AbstractTreeViewer.java:148)
at org.jkiss.dbeaver.ui.views.navigator.database.load.TreeLoadVisualizer.completeLoading(TreeLoadVisualizer.java:66)
at org.jkiss.dbeaver.ui.views.navigator.database.load.TreeLoadVisualizer.completeLoading(TreeLoadVisualizer.java:1)
at org.jkiss.dbeaver.runtime.load.jobs.LoadingJob$LoadFinisher.run(LoadingJob.java:102)
at org.eclipse.ui.internal.UILockListener.doPendingWork(UILockListener.java:164)
at org.eclipse.ui.internal.UISynchronizer$3.run(UISynchronizer.java:158)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4140)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3757)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2696)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2660)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:667)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.jkiss.dbeaver.core.DBeaverApplication.start(DBeaverApplication.java:68)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
at org.eclipse.equinox.launcher.Main.run(Main.java:1410)

Options: ReplyQuote


Subject
Written By
Posted
Read database list error, INNODB problem?
March 07, 2012 11:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.