[jira] [Commented] (DERBY-6766) java.sql.SQLException: nospc.U Unexpected no space error while attempting to update a row on page
[
https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16064571#comment-16064571
]
Vamsavardhana Reddy commented on DERBY-6766:
I have tried the procedure given in
https://db.apache.org/derby/docs/10.7/adminguide/cadminspace21579.html to
release the unused space on all application tables. But the error occurred
again within a few hours!!
> java.sql.SQLException: nospc.U Unexpected no space error while attempting to
> update a row on page
> --
>
> Key: DERBY-6766
> URL: https://issues.apache.org/jira/browse/DERBY-6766
> Project: Derby
> Issue Type: Bug
> Components: Store
>Affects Versions: 10.10.2.0
> Environment: Derby 10.10.2.0 - (1582446), AIX 6.1.0.0
> (6100-08-03-1339), Hibernate 3.5.6-Final, Java 1.6.0 IBM J9 VM (build 2.4,
> JRE 1.6.0 IBM J9 2.4 AIX ppc64-64)
>Reporter: Kai Duckwitz
>Priority: Critical
> Labels: nospc
> Attachments: console.zip, derby.log, IDD.DDL
>
>
> We already had this error with version 10.8.2.2 an hoped that it would be
> fixed in 10.10.2.0 due to [DERBY-4923] - but it is not.
> This error occurs sporadically on updating or inserting objects via
> hibernate. The application runs for weeks without a problem (20-50 object
> updates/inserts per second) and then the error occures up to 10 times in 2
> hours; after that the error can be absent for days or weeks.
> We use only these data types:
> NUMERIC,SMALLINT,TIMESTAMP,VARCHAR
> Stacktrace:
> Caused by: java.sql.SQLException: Unexpected no space error while attempting
> to update a row on page Page(94,Container(0, 1632)). Values of internal
> fields at time of error are as follows: slot = 301, recordId = 28,
> newColumnList = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}, nextColumn = -1,
> mode = 0, nextPortionHandle = null, page dump =
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> ... 51 more
> Caused by: java.sql.SQLException: nospc.U
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> ... 48 more
> Caused by: ERROR nospc: nospc.U
> at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.UpdateOperation.(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
> at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown
> Source)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
> Source)
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Commented] (DERBY-6766) java.sql.SQLException: nospc.U Unexpected no space error while attempting to update a row on page
[
https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16031185#comment-16031185
]
Bryan Pendleton commented on DERBY-6766:
@Vamsarvardhana Reddy, were you able to collect any of the additional
information or try any of the additional experiments suggested in this comment?
https://issues.apache.org/jira/browse/DERBY-6766?focusedCommentId=14183610=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14183610
> java.sql.SQLException: nospc.U Unexpected no space error while attempting to
> update a row on page
> --
>
> Key: DERBY-6766
> URL: https://issues.apache.org/jira/browse/DERBY-6766
> Project: Derby
> Issue Type: Bug
> Components: Store
>Affects Versions: 10.10.2.0
> Environment: Derby 10.10.2.0 - (1582446), AIX 6.1.0.0
> (6100-08-03-1339), Hibernate 3.5.6-Final, Java 1.6.0 IBM J9 VM (build 2.4,
> JRE 1.6.0 IBM J9 2.4 AIX ppc64-64)
>Reporter: Kai Duckwitz
>Priority: Critical
> Labels: nospc
> Attachments: console.zip, derby.log, IDD.DDL
>
>
> We already had this error with version 10.8.2.2 an hoped that it would be
> fixed in 10.10.2.0 due to [DERBY-4923] - but it is not.
> This error occurs sporadically on updating or inserting objects via
> hibernate. The application runs for weeks without a problem (20-50 object
> updates/inserts per second) and then the error occures up to 10 times in 2
> hours; after that the error can be absent for days or weeks.
> We use only these data types:
> NUMERIC,SMALLINT,TIMESTAMP,VARCHAR
> Stacktrace:
> Caused by: java.sql.SQLException: Unexpected no space error while attempting
> to update a row on page Page(94,Container(0, 1632)). Values of internal
> fields at time of error are as follows: slot = 301, recordId = 28,
> newColumnList = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}, nextColumn = -1,
> mode = 0, nextPortionHandle = null, page dump =
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> ... 51 more
> Caused by: java.sql.SQLException: nospc.U
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> ... 48 more
> Caused by: ERROR nospc: nospc.U
> at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.UpdateOperation.(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
> at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown
> Source)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
> Source)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
[jira] [Commented] (DERBY-6766) java.sql.SQLException: nospc.U Unexpected no space error while attempting to update a row on page
[
https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16030712#comment-16030712
]
Vamsavardhana Reddy commented on DERBY-6766:
Does this database corruption happen due to load on the database or is it
because of specific data that is handled by the database? Anything specific
that causes this corruption and any suggestions to avoid this issue?
> java.sql.SQLException: nospc.U Unexpected no space error while attempting to
> update a row on page
> --
>
> Key: DERBY-6766
> URL: https://issues.apache.org/jira/browse/DERBY-6766
> Project: Derby
> Issue Type: Bug
> Components: Store
>Affects Versions: 10.10.2.0
> Environment: Derby 10.10.2.0 - (1582446), AIX 6.1.0.0
> (6100-08-03-1339), Hibernate 3.5.6-Final, Java 1.6.0 IBM J9 VM (build 2.4,
> JRE 1.6.0 IBM J9 2.4 AIX ppc64-64)
>Reporter: Kai Duckwitz
>Priority: Critical
> Labels: nospc
> Attachments: console.zip, derby.log, IDD.DDL
>
>
> We already had this error with version 10.8.2.2 an hoped that it would be
> fixed in 10.10.2.0 due to [DERBY-4923] - but it is not.
> This error occurs sporadically on updating or inserting objects via
> hibernate. The application runs for weeks without a problem (20-50 object
> updates/inserts per second) and then the error occures up to 10 times in 2
> hours; after that the error can be absent for days or weeks.
> We use only these data types:
> NUMERIC,SMALLINT,TIMESTAMP,VARCHAR
> Stacktrace:
> Caused by: java.sql.SQLException: Unexpected no space error while attempting
> to update a row on page Page(94,Container(0, 1632)). Values of internal
> fields at time of error are as follows: slot = 301, recordId = 28,
> newColumnList = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}, nextColumn = -1,
> mode = 0, nextPortionHandle = null, page dump =
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> ... 51 more
> Caused by: java.sql.SQLException: nospc.U
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> ... 48 more
> Caused by: ERROR nospc: nospc.U
> at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.UpdateOperation.(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
> at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown
> Source)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
> Source)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
[jira] [Commented] (DERBY-6766) java.sql.SQLException: nospc.U Unexpected no space error while attempting to update a row on page
[
https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15939362#comment-15939362
]
Rick Hillegas commented on DERBY-6766:
--
Hi Vamsavardhana,
Yes, this could indicate a db corruption. See Mike's original response for
advice about how to fix the corruption.
Hope this helps,
-Rick
> java.sql.SQLException: nospc.U Unexpected no space error while attempting to
> update a row on page
> --
>
> Key: DERBY-6766
> URL: https://issues.apache.org/jira/browse/DERBY-6766
> Project: Derby
> Issue Type: Bug
> Components: Store
>Affects Versions: 10.10.2.0
> Environment: Derby 10.10.2.0 - (1582446), AIX 6.1.0.0
> (6100-08-03-1339), Hibernate 3.5.6-Final, Java 1.6.0 IBM J9 VM (build 2.4,
> JRE 1.6.0 IBM J9 2.4 AIX ppc64-64)
>Reporter: Kai Duckwitz
>Priority: Critical
> Labels: nospc
> Attachments: console.zip, derby.log, IDD.DDL
>
>
> We already had this error with version 10.8.2.2 an hoped that it would be
> fixed in 10.10.2.0 due to [DERBY-4923] - but it is not.
> This error occurs sporadically on updating or inserting objects via
> hibernate. The application runs for weeks without a problem (20-50 object
> updates/inserts per second) and then the error occures up to 10 times in 2
> hours; after that the error can be absent for days or weeks.
> We use only these data types:
> NUMERIC,SMALLINT,TIMESTAMP,VARCHAR
> Stacktrace:
> Caused by: java.sql.SQLException: Unexpected no space error while attempting
> to update a row on page Page(94,Container(0, 1632)). Values of internal
> fields at time of error are as follows: slot = 301, recordId = 28,
> newColumnList = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}, nextColumn = -1,
> mode = 0, nextPortionHandle = null, page dump =
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> ... 51 more
> Caused by: java.sql.SQLException: nospc.U
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> ... 48 more
> Caused by: ERROR nospc: nospc.U
> at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.UpdateOperation.(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
> at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown
> Source)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
> Source)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
[jira] [Commented] (DERBY-6766) java.sql.SQLException: nospc.U Unexpected no space error while attempting to update a row on page
[
https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15939088#comment-15939088
]
Vamsavardhana Reddy commented on DERBY-6766:
I am seeing a similar error with Derby 10.8.3.3 and using hibernate for
persistence. Does this error indicate DB is corrupted?
Caused by: java.sql.SQLException: Unexpected no space error while attempting to
update a row on page Page(87,Container(0, 1328)). Values of internal fields at
time of error are as follows: slot = 0, recordId = 863, newColumnList = {3},
nextColumn = 3, mode = 24, nextPortionHandle = null, page dump =
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 49 more
Caused by: java.sql.SQLException: nospc.U
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
... 46 more
Caused by: ERROR nospc: nospc.U
at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.InsertOperation.writeOptionalDataToBuffer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.InsertOperation.(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.LoggableActions.actionInsert(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BasePage.insertAllowOverflow(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown
Source)
at
org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown
Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown
Source)
at
org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown
Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown
Source)
at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
... 42 more
java.sql.SQLException: nospc.U
> java.sql.SQLException: nospc.U Unexpected no space error while attempting to
> update a row on page
> --
>
> Key: DERBY-6766
> URL: https://issues.apache.org/jira/browse/DERBY-6766
> Project: Derby
> Issue Type: Bug
> Components: Store
>Affects Versions: 10.10.2.0
> Environment: Derby 10.10.2.0 - (1582446), AIX 6.1.0.0
> (6100-08-03-1339), Hibernate 3.5.6-Final, Java 1.6.0 IBM J9 VM (build 2.4,
> JRE 1.6.0 IBM J9 2.4 AIX ppc64-64)
>Reporter: Kai Duckwitz
>Priority: Critical
> Labels: nospc
> Attachments: console.zip, derby.log, IDD.DDL
>
>
> We already had this error with version 10.8.2.2 an hoped that it would be
> fixed in 10.10.2.0 due to [DERBY-4923] - but it is not.
> This error occurs sporadically on updating or inserting objects via
> hibernate. The application runs for weeks without a problem (20-50 object
> updates/inserts per second) and then the error occures up to 10 times in 2
> hours; after that the error can be absent for days or weeks.
> We use only these data types:
> NUMERIC,SMALLINT,TIMESTAMP,VARCHAR
> Stacktrace:
> Caused by: java.sql.SQLException: Unexpected no space error while attempting
> to update a row on page Page(94,Container(0, 1632)). Values of internal
> fields at time of error are as follows: slot = 301, recordId = 28,
> newColumnList = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}, nextColumn = -1,
> mode = 0, nextPortionHandle = null, page dump =
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> ... 51 more
> Caused by: java.sql.SQLException: nospc.U
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> at
[jira] [Commented] (DERBY-6766) java.sql.SQLException: nospc.U Unexpected no space error while attempting to update a row on page
[
https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14189699#comment-14189699
]
Kai Duckwitz commented on DERBY-6766:
-
the attached derby.log seems not to be very substantial regarding the problem.
Unfortunately there is no other logfile.
Mostly there are inserts and updates and only once a day there is a
delete-job about midnight. But you are right, quiet seldom there can also be
a few deletes on objects/rows in a normal transaction (where the error
occured), but in the same transaction there are always inserts and updates.
Unfortunately I don't know which query/object/row produced the error. The
biggest column is varchar (2000). The other datatypes are timestamp(29)
smallint(5) numeric(19) and varchar(2-2000)
java.sql.SQLException: nospc.U Unexpected no space error while attempting to
update a row on page
--
Key: DERBY-6766
URL: https://issues.apache.org/jira/browse/DERBY-6766
Project: Derby
Issue Type: Bug
Components: Store
Affects Versions: 10.10.2.0
Environment: Derby 10.10.2.0 - (1582446), AIX 6.1.0.0
(6100-08-03-1339), Hibernate 3.5.6-Final, Java 1.6.0 IBM J9 VM (build 2.4,
JRE 1.6.0 IBM J9 2.4 AIX ppc64-64)
Reporter: Kai Duckwitz
Priority: Critical
Labels: nospc
Attachments: console.zip, derby.log
We already had this error with version 10.8.2.2 an hoped that it would be
fixed in 10.10.2.0 due to [DERBY-4923] - but it is not.
This error occurs sporadically on updating or inserting objects via
hibernate. The application runs for weeks without a problem (20-50 object
updates/inserts per second) and then the error occures up to 10 times in 2
hours; after that the error can be absent for days or weeks.
We use only these data types:
NUMERIC,SMALLINT,TIMESTAMP,VARCHAR
Stacktrace:
Caused by: java.sql.SQLException: Unexpected no space error while attempting
to update a row on page Page(94,Container(0, 1632)). Values of internal
fields at time of error are as follows: slot = 301, recordId = 28,
newColumnList = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}, nextColumn = -1,
mode = 0, nextPortionHandle = null, page dump =
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 51 more
Caused by: java.sql.SQLException: nospc.U
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
... 48 more
Caused by: ERROR nospc: nospc.U
at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.UpdateOperation.init(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown
Source)
at
org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown
Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown
Source)
at
org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown
Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown
Source)
at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (DERBY-6766) java.sql.SQLException: nospc.U Unexpected no space error while attempting to update a row on page
[
https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14187564#comment-14187564
]
Mike Matrigali commented on DERBY-6766:
---
do you have a derby.log for this event, I am looking at console.log but it
seems to be client side logging
rather than server side? If so can you post?
can you post the exact ddl for the table involved?
can you post the query being executed when the error occurs?
java.sql.SQLException: nospc.U Unexpected no space error while attempting to
update a row on page
--
Key: DERBY-6766
URL: https://issues.apache.org/jira/browse/DERBY-6766
Project: Derby
Issue Type: Bug
Components: Store
Affects Versions: 10.10.2.0
Environment: Derby 10.10.2.0 - (1582446), AIX 6.1.0.0
(6100-08-03-1339), Hibernate 3.5.6-Final, Java 1.6.0 IBM J9 VM (build 2.4,
JRE 1.6.0 IBM J9 2.4 AIX ppc64-64)
Reporter: Kai Duckwitz
Priority: Critical
Labels: nospc
Attachments: console.zip
We already had this error with version 10.8.2.2 an hoped that it would be
fixed in 10.10.2.0 due to [DERBY-4923] - but it is not.
This error occurs sporadically on updating or inserting objects via
hibernate. The application runs for weeks without a problem (20-50 object
updates/inserts per second) and then the error occures up to 10 times in 2
hours; after that the error can be absent for days or weeks.
We use only these data types:
NUMERIC,SMALLINT,TIMESTAMP,VARCHAR
Stacktrace:
Caused by: java.sql.SQLException: Unexpected no space error while attempting
to update a row on page Page(94,Container(0, 1632)). Values of internal
fields at time of error are as follows: slot = 301, recordId = 28,
newColumnList = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}, nextColumn = -1,
mode = 0, nextPortionHandle = null, page dump =
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 51 more
Caused by: java.sql.SQLException: nospc.U
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
... 48 more
Caused by: ERROR nospc: nospc.U
at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.UpdateOperation.init(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown
Source)
at
org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown
Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown
Source)
at
org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown
Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown
Source)
at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (DERBY-6766) java.sql.SQLException: nospc.U Unexpected no space error while attempting to update a row on page
[
https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14187578#comment-14187578
]
Mike Matrigali commented on DERBY-6766:
---
there are a number of deleted rows on the pages in question. Is it
likely/possible that deletes are going on
at the same time the failed update happens?
java.sql.SQLException: nospc.U Unexpected no space error while attempting to
update a row on page
--
Key: DERBY-6766
URL: https://issues.apache.org/jira/browse/DERBY-6766
Project: Derby
Issue Type: Bug
Components: Store
Affects Versions: 10.10.2.0
Environment: Derby 10.10.2.0 - (1582446), AIX 6.1.0.0
(6100-08-03-1339), Hibernate 3.5.6-Final, Java 1.6.0 IBM J9 VM (build 2.4,
JRE 1.6.0 IBM J9 2.4 AIX ppc64-64)
Reporter: Kai Duckwitz
Priority: Critical
Labels: nospc
Attachments: console.zip
We already had this error with version 10.8.2.2 an hoped that it would be
fixed in 10.10.2.0 due to [DERBY-4923] - but it is not.
This error occurs sporadically on updating or inserting objects via
hibernate. The application runs for weeks without a problem (20-50 object
updates/inserts per second) and then the error occures up to 10 times in 2
hours; after that the error can be absent for days or weeks.
We use only these data types:
NUMERIC,SMALLINT,TIMESTAMP,VARCHAR
Stacktrace:
Caused by: java.sql.SQLException: Unexpected no space error while attempting
to update a row on page Page(94,Container(0, 1632)). Values of internal
fields at time of error are as follows: slot = 301, recordId = 28,
newColumnList = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}, nextColumn = -1,
mode = 0, nextPortionHandle = null, page dump =
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 51 more
Caused by: java.sql.SQLException: nospc.U
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
... 48 more
Caused by: ERROR nospc: nospc.U
at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.UpdateOperation.init(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown
Source)
at
org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown
Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown
Source)
at
org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown
Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown
Source)
at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (DERBY-6766) java.sql.SQLException: nospc.U Unexpected no space error while attempting to update a row on page
[
https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14187653#comment-14187653
]
Mike Matrigali commented on DERBY-6766:
---
can any of your varchar columns be bigger than 32000 (vs 32k)?
java.sql.SQLException: nospc.U Unexpected no space error while attempting to
update a row on page
--
Key: DERBY-6766
URL: https://issues.apache.org/jira/browse/DERBY-6766
Project: Derby
Issue Type: Bug
Components: Store
Affects Versions: 10.10.2.0
Environment: Derby 10.10.2.0 - (1582446), AIX 6.1.0.0
(6100-08-03-1339), Hibernate 3.5.6-Final, Java 1.6.0 IBM J9 VM (build 2.4,
JRE 1.6.0 IBM J9 2.4 AIX ppc64-64)
Reporter: Kai Duckwitz
Priority: Critical
Labels: nospc
Attachments: console.zip
We already had this error with version 10.8.2.2 an hoped that it would be
fixed in 10.10.2.0 due to [DERBY-4923] - but it is not.
This error occurs sporadically on updating or inserting objects via
hibernate. The application runs for weeks without a problem (20-50 object
updates/inserts per second) and then the error occures up to 10 times in 2
hours; after that the error can be absent for days or weeks.
We use only these data types:
NUMERIC,SMALLINT,TIMESTAMP,VARCHAR
Stacktrace:
Caused by: java.sql.SQLException: Unexpected no space error while attempting
to update a row on page Page(94,Container(0, 1632)). Values of internal
fields at time of error are as follows: slot = 301, recordId = 28,
newColumnList = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}, nextColumn = -1,
mode = 0, nextPortionHandle = null, page dump =
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 51 more
Caused by: java.sql.SQLException: nospc.U
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
... 48 more
Caused by: ERROR nospc: nospc.U
at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.UpdateOperation.init(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown
Source)
at
org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown
Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown
Source)
at
org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown
Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown
Source)
at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (DERBY-6766) java.sql.SQLException: nospc.U Unexpected no space error while attempting to update a row on page
[
https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14183610#comment-14183610
]
Mike Matrigali commented on DERBY-6766:
---
Unfortunately the info posted is not going to be enough to figure out what is
going on. These bugs tend to be
about the state the page has gotten to previously, rather than the line number
of the code that finally hits the
problem. Obviously the best thing would be reproducible test case, but seems
from your description you are
not sure what forces the issue.
any chance you have and can post the derby.log from when this error occurred.
It should have logged a page
dump which may help understand the issue. Previous changes for this issue
should have beefed up what is
logged in the case of the error so we have a better shot at tracking it down.
There have been a number of fixes in this area, and while they tend to have the
same error message symptom, they
have been different bugs in the code.
Some of the fixes in this area only help for new table created after the bug
fix. Can you run offline compress on the table, and then report back if you
still see the error after that. Running compress in this manner basically
recreates all the underlying files, thus making sure they are all created with
the latest fixed code.
Usually this is not an option due to security of the data, but if you could
provide a copy of the database with the
associated log files at the moment the error occurs (or soon after), one could
analyse the log and maybe see what change to the page caused the problem.
Often the problem is not the change that hits the error, it is a previous
change to the page or previous change to the row that was the actual problem.
java.sql.SQLException: nospc.U Unexpected no space error while attempting to
update a row on page
--
Key: DERBY-6766
URL: https://issues.apache.org/jira/browse/DERBY-6766
Project: Derby
Issue Type: Bug
Components: Store
Affects Versions: 10.10.2.0
Environment: Derby 10.10.2.0 - (1582446), AIX 6.1.0.0
(6100-08-03-1339), Hibernate 3.5.6-Final, Java 1.6.0 IBM J9 VM (build 2.4,
JRE 1.6.0 IBM J9 2.4 AIX ppc64-64)
Reporter: Kai Duckwitz
Priority: Critical
Labels: nospc
We already had this error with version 10.8.2.2 an hoped that it would be
fixed in 10.10.2.0 due to [DERBY-4923] - but it is not.
This error occurs sporadically on updating or inserting objects via
hibernate. The application runs for weeks without a problem (20-50 object
updates/inserts per second) and then the error occures up to 10 times in 2
hours; after that the error can be absent for days or weeks.
We use only these data types:
NUMERIC,SMALLINT,TIMESTAMP,VARCHAR
Stacktrace:
Caused by: java.sql.SQLException: Unexpected no space error while attempting
to update a row on page Page(94,Container(0, 1632)). Values of internal
fields at time of error are as follows: slot = 301, recordId = 28,
newColumnList = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}, nextColumn = -1,
mode = 0, nextPortionHandle = null, page dump =
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 51 more
Caused by: java.sql.SQLException: nospc.U
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
... 48 more
Caused by: ERROR nospc: nospc.U
at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.UpdateOperation.init(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown
Source)
at
org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown
Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown
Source)
at
[jira] [Commented] (DERBY-6766) java.sql.SQLException: nospc.U Unexpected no space error while attempting to update a row on page
[
https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14183620#comment-14183620
]
Mike Matrigali commented on DERBY-6766:
---
here is what is to be gathered from the posted information:
o The problem is on page 94 of container 1632 [Page(94,Container(0, 1632)) ] -
if necessary table name can be
gotten from the db using this containerid - see derby wiki
o I think the problem row is on slot = 301, recordId = 28. It would be
interesting to know when you hit this issue
multiple times if it is on same page or not, and same recordId or not.
o the problem is with a base page rather than a btree page (stack has nothing
that says Btree so must be heap).
java.sql.SQLException: nospc.U Unexpected no space error while attempting to
update a row on page
--
Key: DERBY-6766
URL: https://issues.apache.org/jira/browse/DERBY-6766
Project: Derby
Issue Type: Bug
Components: Store
Affects Versions: 10.10.2.0
Environment: Derby 10.10.2.0 - (1582446), AIX 6.1.0.0
(6100-08-03-1339), Hibernate 3.5.6-Final, Java 1.6.0 IBM J9 VM (build 2.4,
JRE 1.6.0 IBM J9 2.4 AIX ppc64-64)
Reporter: Kai Duckwitz
Priority: Critical
Labels: nospc
We already had this error with version 10.8.2.2 an hoped that it would be
fixed in 10.10.2.0 due to [DERBY-4923] - but it is not.
This error occurs sporadically on updating or inserting objects via
hibernate. The application runs for weeks without a problem (20-50 object
updates/inserts per second) and then the error occures up to 10 times in 2
hours; after that the error can be absent for days or weeks.
We use only these data types:
NUMERIC,SMALLINT,TIMESTAMP,VARCHAR
Stacktrace:
Caused by: java.sql.SQLException: Unexpected no space error while attempting
to update a row on page Page(94,Container(0, 1632)). Values of internal
fields at time of error are as follows: slot = 301, recordId = 28,
newColumnList = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}, nextColumn = -1,
mode = 0, nextPortionHandle = null, page dump =
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 51 more
Caused by: java.sql.SQLException: nospc.U
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
... 48 more
Caused by: ERROR nospc: nospc.U
at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.UpdateOperation.init(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown
Source)
at
org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown
Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown
Source)
at
org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown
Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown
Source)
at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (DERBY-6766) java.sql.SQLException: nospc.U Unexpected no space error while attempting to update a row on page
[
https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14183622#comment-14183622
]
Mike Matrigali commented on DERBY-6766:
---
you mention you were running older version of derby. Do you know if your
database is hard upgraded or soft
upgraded to 10.10?
java.sql.SQLException: nospc.U Unexpected no space error while attempting to
update a row on page
--
Key: DERBY-6766
URL: https://issues.apache.org/jira/browse/DERBY-6766
Project: Derby
Issue Type: Bug
Components: Store
Affects Versions: 10.10.2.0
Environment: Derby 10.10.2.0 - (1582446), AIX 6.1.0.0
(6100-08-03-1339), Hibernate 3.5.6-Final, Java 1.6.0 IBM J9 VM (build 2.4,
JRE 1.6.0 IBM J9 2.4 AIX ppc64-64)
Reporter: Kai Duckwitz
Priority: Critical
Labels: nospc
We already had this error with version 10.8.2.2 an hoped that it would be
fixed in 10.10.2.0 due to [DERBY-4923] - but it is not.
This error occurs sporadically on updating or inserting objects via
hibernate. The application runs for weeks without a problem (20-50 object
updates/inserts per second) and then the error occures up to 10 times in 2
hours; after that the error can be absent for days or weeks.
We use only these data types:
NUMERIC,SMALLINT,TIMESTAMP,VARCHAR
Stacktrace:
Caused by: java.sql.SQLException: Unexpected no space error while attempting
to update a row on page Page(94,Container(0, 1632)). Values of internal
fields at time of error are as follows: slot = 301, recordId = 28,
newColumnList = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}, nextColumn = -1,
mode = 0, nextPortionHandle = null, page dump =
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 51 more
Caused by: java.sql.SQLException: nospc.U
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
... 48 more
Caused by: ERROR nospc: nospc.U
at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.UpdateOperation.init(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown
Source)
at
org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown
Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown
Source)
at
org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown
Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown
Source)
at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
