Re: Conglomerate could not be created?

2012-06-21 Thread John English
On 20/06/2012 15:25, Kristian Waagan wrote: Logged as DERBY-5823 [1]. The bug is data dependent in that it requires a certain number of rows to be inserted, so that may be what's causing your repro to fail triggering the bug. OK, many thanks. -- John English

Re: Conglomerate could not be created?

2012-06-20 Thread Kristian Waagan
On 19.06.2012 09:45, John English wrote: On 05/06/2012 18:45, Dag H. Wanvik wrote: Looks like a bug to me. The error XSCH4 Conglomerate could not be created isn't being tested for in the Derby tests as far as I can see. I also searched the bug tracker (https://issues.apache.org/jira/browse

Re: Conglomerate could not be created?

2012-06-20 Thread Kristian Waagan
On 20.06.2012 13:05, John English wrote: On 20/06/2012 11:45, Kristian Waagan wrote: Hi John, I believe your assumptions are correct. This is a bug in Derby where the temporary row holder, used to hold generated keys, overflows and a temporary backing conglomerate is attempted created with a

Re: Conglomerate could not be created?

2012-06-19 Thread John English
On 05/06/2012 18:45, Dag H. Wanvik wrote: Looks like a bug to me. The error XSCH4 Conglomerate could not be created isn't being tested for in the Derby tests as far as I can see. I also searched the bug tracker (https://issues.apache.org/jira/browse/DERBY) in vain for this particular error

Re: Conglomerate could not be created?

2012-06-19 Thread Dag H. Wanvik
John English john.fore...@gmail.com writes: dbInsert lines 1056/1057 look like this: stat.executeUpdate(); ResultSet r = stat.getGeneratedKeys(); so the failure happens when the prepared statement is executed, just before the call to getGeneratedKeys(). I tried this sample, but saw no

Re: Conglomerate could not be created?

2012-06-06 Thread John English
On 05/06/2012 18:45, Dag H. Wanvik wrote: Looks like a bug to me. The error XSCH4 Conglomerate could not be created isn't being tested for in the Derby tests as far as I can see. I also searched the bug tracker (https://issues.apache.org/jira/browse/DERBY) in vain for this particular error

Re: Conglomerate could not be created?

2012-06-05 Thread John English
resource_usage WHERE itemid=? AND itemtype=?)) Query parameters: 1='24' 2='final' 3='18' 4='temp' 5='24' 6='final'): Here's the resulting stack trace from the point just before I rethrow: java.sql.SQLException: Conglomerate could not be created. at org.apache.derby.impl.jdbc.SQLExceptionFactory40

Re: Conglomerate could not be created?

2012-06-05 Thread Dag H. Wanvik
Looks like a bug to me. The error XSCH4 Conglomerate could not be created isn't being tested for in the Derby tests as far as I can see. I also searched the bug tracker (https://issues.apache.org/jira/browse/DERBY) in vain for this particular error. Looking in the code where the error

Re: Conglomerate could not be created?

2012-06-04 Thread Rick Hillegas
On 6/2/12 3:18 AM, John English wrote: On 01/06/2012 15:19, John English wrote: I'm having trouble with the following error: Conglomerate could not be created. It happens when I do this: INSERT INTO resource_usage (resid,itemid,itemtype) (SELECT resid,?,? FROM resource_usage WHERE itemid

Re: Conglomerate could not be created?

2012-06-04 Thread Kristian Waagan
On 04.06.12 14:52, Rick Hillegas wrote: On 6/2/12 3:18 AM, John English wrote: On 01/06/2012 15:19, John English wrote: I'm having trouble with the following error: Conglomerate could not be created. It happens when I do this: INSERT INTO resource_usage (resid,itemid,itemtype) (SELECT resid

Re: Conglomerate could not be created?

2012-06-04 Thread John English
On 04/06/2012 16:35, Kristian Waagan wrote: On 04.06.12 14:52, Rick Hillegas wrote: On 6/2/12 3:18 AM, John English wrote: On 01/06/2012 15:19, John English wrote: I'm having trouble with the following error: Conglomerate could not be created. It happens when I do this: INSERT

Re: Conglomerate could not be created?

2012-06-04 Thread Katherine Marsden
On 6/4/2012 9:29 AM, John English wrote: I'm on 10.8, and I only have about a dozen matching rows at the moment. No stack trace that goes further than my own code; all I have is stuff like this: Check the derby.log for the error and full stack trace. If the derby.log doesn't show the error,

Re: Conglomerate could not be created?

2012-06-02 Thread John English
On 01/06/2012 16:36, Knut Anders Hatlen wrote: John Englishcheckpoint...@gmail.com writes: I'm having trouble with the following error: Conglomerate could not be created. It happens when I do this: INSERT INTO resource_usage (resid,itemid,itemtype) (SELECT resid,?,? FROM

Re: Conglomerate could not be created?

2012-06-02 Thread John English
On 01/06/2012 15:19, John English wrote: I'm having trouble with the following error: Conglomerate could not be created. It happens when I do this: INSERT INTO resource_usage (resid,itemid,itemtype) (SELECT resid,?,? FROM resource_usage WHERE itemid=? AND itemtype

Conglomerate could not be created?

2012-06-01 Thread John English
I'm having trouble with the following error: Conglomerate could not be created. It happens when I do this: INSERT INTO resource_usage (resid,itemid,itemtype) (SELECT resid,?,? FROM resource_usage WHERE itemid=? AND itemtype=? AND NOT EXISTS (SELECT resid FROM

Re: Conglomerate could not be created?

2012-06-01 Thread Tim Watts
On Fri, 2012-06-01 at 15:19 +0300, John English wrote: I'm having trouble with the following error: Conglomerate could not be created. It happens when I do this: INSERT INTO resource_usage (resid,itemid,itemtype) (SELECT resid,?,? FROM resource_usage WHERE itemid

Re: Conglomerate could not be created?

2012-06-01 Thread Knut Anders Hatlen
John English checkpoint...@gmail.com writes: I'm having trouble with the following error: Conglomerate could not be created. It happens when I do this: INSERT INTO resource_usage (resid,itemid,itemtype) (SELECT resid,?,? FROM resource_usage WHERE itemid=? AND itemtype

Re: Conglomerate could not be created?

2012-06-01 Thread John English
On 01/06/2012 16:36, Knut Anders Hatlen wrote: Does the insert statement work if you rewrite it to INSERT INTO resource_usage (resid,itemid,itemtype) (SELECT resid, CAST(? AS INT), CAST(? AS VARCHAR(32672)) FROM resource_usage WHERE itemid=? AND itemtype=? AND

XSCH4, Conglomerate could not be created?

2010-12-07 Thread John English
Can anyone explain what this means? It occurs when I issue what should be a straightforward insert: INSERT INTO resource_usage (resid,xmlid,xmltable) (SELECT resid,?,? FROM resource_usage WHERE xmlid=? AND xmltable=?) The select returns 64 results, but the ibsert fails.

Re: XSCH4, Conglomerate could not be created?

2010-12-07 Thread Dag H. Wanvik
John English j...@brighton.ac.uk writes: Can anyone explain what this means? It occurs when I issue what should be a straightforward insert: INSERT INTO resource_usage (resid,xmlid,xmltable) (SELECT resid,?,? FROM resource_usage WHERE xmlid=? AND xmltable=?) I think we had a similar

Re: XSCH4, Conglomerate could not be created?

2010-12-07 Thread Bryan Pendleton
On 12/07/2010 12:15 PM, John English wrote: Can anyone explain what this means? It occurs when I issue what should be a straightforward insert: INSERT INTO resource_usage (resid,xmlid,xmltable) (SELECT resid,?,? FROM resource_usage WHERE xmlid=? AND xmltable=?) The select returns 64 results,