Index Corrupt |
Oscar San Martin |
2011-04-02 13:32:52 |
Sometimes, under many transactions.....HXTT service under SCO Unix collapses and return index error like :
02-04-2011 12:30:48 >> grabarTrxFox2() 1 : UPDATE movimien SET valepreven = ndoc, refe = '186', refe1 = '186', llave = '02/04/2011186', clave = '9 1862186', nlocal = 2 WHERE ndoc = '8559491' AND tpref = '9' AND valepreven = '' AND preventa = 'S'
02-04-2011 12:30:49 >> Error ejecutaQuery : Failed to update Record 116322 because of corrupted index file. For more information, please use SQLException.getNextException().
02-04-2011 12:30:49 >> com.hxtt.global.SQLState.SQLException(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.dbf.i.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.cq.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.ej.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.ej.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.df.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.bn.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.ah.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.ah.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.CallInterface.response(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.server.c.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.server.c.for(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.server.c.run(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.global.b.run(Unknown Source)
How can I determine why occurs this error ??, how can I prevent ??
How tablas are fox for unix with idx index....
Thanks in advance....
|
Re:Index Corrupt |
HXTT Support |
2011-04-02 15:59:44 |
>How can I determine why occurs this error ?
For older version, you should use SQLException.getNextException() to know. For new versio, you can see detailed message directly.
>how can I prevent ?
What's your JDBC url? You can use "reindex all on movimien" once to reindex it.
|
Re:Re:Index Corrupt |
Oscar San Martin |
2011-04-02 20:21:29 |
JDBC url (client): "jdbc:dbf://200.100.200.2:4444//u/gestion";
JDBC url (server): "server=jdbc\:dbf\://200.100.200.2\:4444//u/gestion?lockType\=FOXPRO4UNIX"
We use foxpro tool in order to reindex movimien table.....this table have many records and all clients must wait a long time while this operation ends
|
Re:Re:Re:Index Corrupt |
HXTT Support |
2011-04-03 04:18:38 |
>>How can I determine why occurs this error ?
>For older version, you should use SQLException.getNextException() to know. For >new versio, you can see detailed message directly.
How to know the detailed version information of HXTT DBF package?
1st way: "java com.hxtt.sql.dbf.DBFDriver" will print that information.
2nd way: check that MANIFEST.MF file in jar file.
The latest version is v4.2.212.
A code for order version or simple latest message prompt can help locating what's the issue.
>We use foxpro tool in order to reindex movimien table
"Reindex all on movimien" through server console, remote server control, or client code, can reindex it too.
>this table have many records and all clients must wait a long time
>while this operation ends
Yeah. REINDEX need exclusive use
|
Re:Re:Re:Re:Index Corrupt |
Oscar San Martin |
2011-04-04 06:35:45 |
Ok, this is my MANIFEST.MF file in jar :
Manifest-Version: 1.0
Created-By: HXTT Version Robot
Main-Class: com.hxtt.sql.admin.Admin
Name: com/hxtt/sql/dbf/
Specification-Title: HXTT DBF JDBC 3.0 Package
Implementation-Title: com.hxtt.sql.dbf
Specification-Version: 4.2.058 on May 06, 2009
Specification-Vendor: Hongxin Technology & Trade Ltd.
Comment: JDBC 3.0 Package for Xbase database
Implementation-Version: 4.2.058 on May 06, 2009
Implementation-Vendor: Hongxin Technology & Trade Ltd.
Implementation-URL: http://www.hxtt.com/dbf.html
Name: com/hxtt/sql/admin/
Specification-Title: HXTT Database Admin
Implementation-Title: com.hxtt.sql.admin
Specification-Vendor: Hongxin Technology & Trade Ltd.
Specification-Version: 0.5 on May 06, 2009
Comment: HXTT Database Admin
Implementation-Version: 0.5 on May 06, 2009
Implementation-Vendor: Hongxin Technology & Trade Ltd.
Implementation-URL: http://www.hxtt.com/dbf/dbadmin.html
|
Re:Re:Re:Re:Re:Index Corrupt |
HXTT Support |
2011-04-04 07:11:37 |
|
It seems that you're using a very old version. Please consider renewing your license so that we can provide support based on latest version.
|
Re:Re:Re:Re:Re:Re:Index Corrupt |
Oscar San Martin |
2011-04-04 07:14:41 |
Ok, but what mean "Please consider renewing your license" in order to receive support ??
Thanks,
|
Re:Re:Re:Re:Re:Re:Re:Index Corrupt |
HXTT Support |
2011-04-04 23:56:08 |
|
HXTT promise one year free version upgrade and technical support. You should login hxtt site, and order Renew license/support through a link at download page. We can't solve your issue through latest version.
|
Re:Re:Re:Re:Re:Re:Re:Re:Index Corrupt |
Oscar San Martin |
2011-04-05 08:13:43 |
|
Ok, but, new version give support to JDBC30..., we have SCO JVM 1.4 and cannot upgrade to JVM 1.6.....
|
Re:Re:Re:Re:Re:Re:Re:Re:Index Corrupt |
HXTT Support |
2011-04-05 08:23:45 |
>new version give support to JDBC30
>SCO JVM 1.4 and cannot upgrade to JVM 1.6.....
HXTT DBF v5.0 support JVM1.1, JVM1.2, JVM1.3, JVM1.4, JVM1.5, and JVM1.6 . You can use JDBC3.0 package of v5.0 .
|
Main
webmaster@hxtt.com