db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4027) An attempt was made to access an out of range slot on a page
Date Wed, 04 Feb 2009 23:59:59 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4027?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kathey Marsden updated DERBY-4027:
----------------------------------

    Attachment: Derby4027Repro.java

I was able to reproduce the error with the attached program Derby4027Repro.java.  To reproduce,
create a database wombat and run the schema.sql script to set up the schema, then run the
program.  It will fail with
[C:/kmarsden/repro/derby-4027] java Derby4027Repro
Exception in thread "main" java.sql.SQLException: An attempt was made to access an out of
range slot on a page
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
        at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1323)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1648)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:294)
        at Derby4027Repro.main(Derby4027Repro.java:15)
Caused by: java.sql.SQLException: An attempt was made to access an out of range slot on a
page
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:11
9)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
        ... 9 more
Caused by: ERROR XSDA1: An attempt was made to access an out of range slot on a page
        at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:276)
        at org.apache.derby.impl.store.raw.data.BasePage.checkSlotOnPage(BasePage.java:1830)
        at org.apache.derby.impl.store.raw.data.BasePage.fetchFromSlot(BasePage.java:431)
        at org.apache.derby.impl.store.access.btree.BTreeController.compareNextRecord(BTreeController.java:455)
        at org.apache.derby.impl.store.access.btree.BTreeController.compareLeftAndRightSiblings(BTreeController.java:556
)
        at org.apache.derby.impl.store.access.btree.BTreeController.doIns(BTreeController.java:813)
        at org.apache.derby.impl.store.access.btree.BTreeController.insert(BTreeController.java:1261)
        at org.apache.derby.impl.store.access.btree.index.B2IController.insert(B2IController.java:210)
        at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(IndexChanger.java:439)
        at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(IndexChanger.java:383)
        at org.apache.derby.impl.sql.execute.IndexChanger.insert(IndexChanger.java:589)
        at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(IndexSetChanger.java:267)
        at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(RowChangerImpl.java:453)
        at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java:1022)
        at org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:495)
        at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:416)
        at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:297)
        at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)
        ... 3 more




> An attempt was made to access an out of range slot on a page
> ------------------------------------------------------------
>
>                 Key: DERBY-4027
>                 URL: https://issues.apache.org/jira/browse/DERBY-4027
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.4.2.0
>         Environment: Fedora 10 and Ubuntu 8.04
> Sun Java 1.6.0_07 and 1.6.0_11
> derby 10.4.2.0
>            Reporter: Uwe Kubosch
>            Priority: Blocker
>         Attachments: derby.log, derby.log, derby.log, Derby4027Repro.java, schema.sql
>
>
> When running our application we get the following error message:
> An attempt was made to access an out of range slot on a page:
> INSERT INTO orders (operation, receptacle, vehicle_id, iata_origin, icao_origin, sta,
eta, ata, pta, onb, arr_stand_id, arr_gate, arr_flight_no, arr_remarks, flight_no, icao_flight_no,
icao_callsign, iata_destination, icao_destination, std, etd, atd, ofb, stand_id, pit_code,
gate, aircraft_subtype_code, aircraft_registration, fuel_request, canceled, delay_ind, remarks,
ptd, slot_request_code, slot_request, slot_granted, terminal, customer_name, customer_type,
supplier_id, carnet_no, carnet_expiry, contract_id, authorization_reference, service_level,
standby_at, started_at, completed_at, status, comment, meter1_start_volume_automatic, meter1_start_volume_manual,
meter1_stop_volume_automatic, meter1_stop_volume_manual, meter2_start_volume_automatic, meter2_start_volume_manual,
meter2_stop_volume_automatic, meter2_stop_volume_manual, temperature, density, created_at,
updated_at, fuel_on_board, id) VALUES('FUELLING', NULL, NULL, NULL, NULL, '2009-01-22 07:25:00',
'2009-01-22 07:30:00', '2009-01-22 07:27:00', '2009-01-22 07:27:00', '2009-01-22 07:29:46',
'anAEBO3yqr3zaaabxfoB_Q', NULL, 'DY 0201', NULL, 'DY 0242', 'NAX0242', 'NAX242', 'TOS', 'ENTC',
'2009-01-22 07:50:00', NULL, '2009-01-22 08:13:00', '2009-01-22 08:06:08', 'anAEBO3yqr3zaaabxfoB_Q',
NULL, '18', '733', 'LNKHA', 7200, 0, 'X', NULL, '2009-01-22 08:13:00', NULL, NULL, NULL, '1',
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-01-21 08:04:54', '2009-01-22 13:24:59',
0, 'aV9HYQ55ir3B9DabxfoB_Q')
> The error occurs several times per day on different systems.  It started yesterday

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message