SEQUENCE jumping 19 values after database restart... 2006-07-04 - By Martin Cordova
Back
Hello:
I have a sequence that jumps 19 values when used the first time after
a database restart.
Normally it works fine, until a Db restart, then jumps 19 values.
Basically there is a transaction that executes:
1.- select seq_corresp.nextval corresp_id from dual
2.- insert into TABLE (....) values (seq_corresp.CURRVAL,.....)
I am using latest MAXDB (KERNEL 7.6.00 BUILD 027-123-124-939)
with correspoding JDBC driver. This instance was updated from
7.6.0.16.
After the first jump it works normal again.
jdbc trace below:
---- Thread 5d50e1d9 tcpConnection-80 (See http://ion-80.ora-code.com)-3 Timestamp: 2006-07-04 01:34:53.562
com.sap.dbtech.jdbc.ConnectionSapDB@(protected) ()
com.sap.dbtech.jdbc.ConnectionSapDB@(protected) (false)
com.sap.dbtech.jdbc.ConnectionSapDB@(protected) ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected)
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> SAP DB
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> KERNEL 7.6.00 BUILD 027-123-124-939
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> SAP DB
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> package com.sap.dbtech.jdbc, MaxDB JDBC Driver, MySQL MaxDB, 7.6.0
Build 024-000-005-241
com.sap.dbtech.jdbc.ConnectionSapDB@(protected) ()
=> com.sap.dbtech.jdbc.StatementSapDB@(protected)
com.sap.dbtech.jdbc.StatementSapDB@(protected) (select
seq_corresp.nextval corresp_id from dual
)
=> com.sap.dbtech.jdbc.ResultSetSapDB@(protected)
com.sap.dbtech.jdbc.ResultSetSapDB@(protected) ()
=> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@(protected)
com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@(protected) ()
=> 1
com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@(protected) (1)
=> CORRESP_ID
com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@(protected) (1)
=> FIXED
com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@(protected) (1)
=> 3
com.sap.dbtech.jdbc.ResultSetSapDB@(protected) ()
=> true
com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@(protected) (1)
=> CORRESP_ID
com.sap.dbtech.jdbc.ResultSetSapDB@(protected) (1)
=> 1201
com.sap.dbtech.jdbc.ResultSetSapDB@(protected) ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@(protected) ()
com.sap.dbtech.jdbc.StatementSapDB@(protected) ()
com.sap.dbtech.jdbc.ConnectionSapDB@(protected) ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected)
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> SAP DB
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> KERNEL 7.6.00 BUILD 027-123-124-939
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> SAP DB
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> package com.sap.dbtech.jdbc, MaxDB JDBC Driver, MySQL MaxDB, 7.6.0
Build 024-000-005-241
com.sap.dbtech.jdbc.ConnectionSapDB@(protected) ()
=> com.sap.dbtech.jdbc.StatementSapDB@(protected)
com.sap.dbtech.jdbc.StatementSapDB@(protected) (insert into CORRESP
(
corresp_id,
nro_doc,
fec_doc,
remitente,
asunto,
destino,
fec_creacion,
fec_actualiza,
user_creacion,
user_actualiza,
hora_creacion,
hora_actualiza,
fec_recep,
instruccion,
status
)
values
(
seq_corresp.CURRVAL,
'65445',
{d '2006-07-04'},
'Mart?n C?rdova',
'sdasd',
'asdasd',
{d '2006-07-04'},
{d '2006-07-04'},
'mcordova',
'mcordova',
'01:34:53',
'01:34:53',
{d '2006-07-04'},
NULL,
NULL
)
)
=> 1
com.sap.dbtech.jdbc.StatementSapDB@(protected) ()
com.sap.dbtech.jdbc.ConnectionSapDB@(protected) ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected)
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> SAP DB
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> KERNEL 7.6.00 BUILD 027-123-124-939
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> SAP DB
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> package com.sap.dbtech.jdbc, MaxDB JDBC Driver, MySQL MaxDB, 7.6.0
Build 024-000-005-241
com.sap.dbtech.jdbc.ConnectionSapDB@(protected) ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected)
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> SAP DB
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> KERNEL 7.6.00 BUILD 027-123-124-939
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> SAP DB
com.sap.dbtech.jdbc.DatabaseMetaDataMaxDB@(protected) ()
=> package com.sap.dbtech.jdbc, MaxDB JDBC Driver, MySQL MaxDB, 7.6.0
Build 024-000-005-241
com.sap.dbtech.jdbc.ConnectionSapDB@(protected) ()
=> false
com.sap.dbtech.jdbc.ConnectionSapDB@(protected) ()
com.sap.dbtech.jdbc.StatementSapDB@(protected) ()
com.sap.dbtech.jdbc.StatementSapDB@(protected) ()
com.sap.dbtech.jdbc.ConnectionSapDB@(protected) ()
com.sap.dbtech.jdbc.ConnectionSapDB@(protected) (true)
com.sap.dbtech.jdbc.ConnectionSapDB@(protected) ()
Any help will be appreciated.
Regards,
Martin
--
Dinamica - RADical J2EE framework
open source, easy and powerful
http://www.martincordova.com
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
|
|
