Hi,
I have some big problem with a paradox database. Im pretty sure my problem is that there is a corrupt index file (its normally the problem), but how can i see which file i need to do a "reindex" on ?
My problem come when i fire this SQL:
SELECT * FROM Gemtofh WHERE "DebKre nummer" = '0461999027' AND "Art (F,K,T,O,L)"='A' AND "Dato" ='20061114'
If i dont use the "AND "Dato" ='20061114'" part then it do return a lot of rows that contains ""Dato" ='20061114'", but when i use the part in my sql it return nothing.
Is there somehow where i can see which file to reindex ??
Bjarne
|
>but how can i see which file i need to do a "reindex" on ?
>Is there somehow where i can see which file to reindex ??
You can know all index expressions in those index files through most of JDBC tools, for instance, DbVisualizer, AquaDataStudio, Database Pilot, SQuirreL SQL Client, and so on.
But the simplest way is to run once "reindex all on Gemtofh;", and you can use java -Xmx256m ... if your Gemtofh table has a large number of data rows.
|
When i try "reindex all on Gemtofh" i this exception:
java.sql.SQLException: Failed to reindex file for Timeout Interrupted Exception: beyond 1000 msecs. to acquire table Gemtofh
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.execute(Unknown Source)
at com.hxtt.sql.admin.i.byte(Unknown Source)
at com.hxtt.sql.admin.i.access$000(Unknown Source)
at com.hxtt.sql.admin.i$1.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
|
My fault, sorry!
I forget the -Xmx256m.
It is now working.
Thank you for your help!
Bjarne
|
>java.sql.SQLException: Failed to reindex file for Timeout Interrupted
> Exception: beyond 1000 msecs. to acquire table Gemtofh
It hasn't relation with -Xmx256m. Because reindex need to open Gemtofh table exclusively, and Timeout exception means that Gemtofh table is holding by other objects:) After you restart Admin, it can hold Gemtofh exclusively.
|