On 2012-10-18, at 18:45 , Chuck Hill <[email protected]> wrote:
> > On 2012-10-18, at 3:30 PM, Louis Demers wrote: > >> Wow, >> 1) turned on sql loggin (which I hsould have tought of by mayself , head in >> shame) > > LOL I thought that would be your reaction. :-) > > >> 2) setup the crash >> 3) cut and pasted the sql and now crashed Mail because the request was so >> f****** big ! here is the start > <snip> >> >> 200:18574(id), 201:6284(id), 202:10381(id), 203:6282(id), 204:6283(id), >> 205:10376(id), 206:6281(id), .......... >> >> that line has 2059805 characters in it !!!! > > My guess is that the line is too long for Postgres and is causing a buffer > overflow or something. That IS a rather long line. :-) > > So the next interesting question is, >>>> If i first put a small number, then I can ask any number including 0 and >>>> it works... > > > what SQL is sent if you set the batch size to 10 and then to 0"? My guess is > that it is not actually fetching everything in that case. > when I do it with exactly the same input I get only one line (which is also what I should be getting no matter the batch size,) Here is hte sql if I use a batch size of 20 Oct 18 18:46:56 DEBUG NSLog - === Begin Internal Transaction Oct 18 18:46:56 DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.PostgresqlExpression: "select count(*) FROM Transaction t0 WHERE (t0.dateEnd > ?::timestamp AND (t0.dateEnd < ?::timestamp AND t0.transactionTypeID = ?::int4))" withBindings: 1:2012-10-01 00:00:00.0(dateEnd), 2:2012-10-03 00:00:00.0(dateEnd), 3:1(transactionTypeID)> Oct 18 18:46:56 DEBUG NSLog - 1 row(s) processed Oct 18 18:46:56 DEBUG NSLog - === Commit Internal Transaction Oct 18 18:46:56 DEBUG NSLog - === Begin Internal Transaction Oct 18 18:46:56 DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.PostgresqlExpression: "SELECT t0.id FROM Transaction t0 WHERE (t0.dateEnd > ?::timestamp AND (t0.dateEnd < ?::timestamp AND t0.transactionTypeID = ?::int4)) LIMIT 1 OFFSET 0" withBindings: 1:2012-10-01 00:00:00.0(dateEnd), 2:2012-10-03 00:00:00.0(dateEnd), 3:1(transactionTypeID)> Oct 18 18:46:56 DEBUG NSLog - 1 row(s) processed Oct 18 18:46:56 DEBUG NSLog - === Commit Internal Transaction Oct 18 18:46:56 DEBUG NSLog - === Begin Internal Transaction Oct 18 18:46:56 DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.PostgresqlExpression: "SELECT t0.assemblyTransaction_id, t0.averageCost, t0.billNumber, t0.contact_id, t0.cost, t0.dateEnd, t0.dateStart, t0.id, t0.location_id, t0.locked, t0.note, t0.part_id, (t0.id), t0.project_id, t0.purchaseOrder, t0.quantity, t0.receptionNumber, t0.reversedTransaction_id, t0.runningTotalCost, t0.runningTotalQty, t0.transactionTypeID FROM Transaction t0 WHERE t0.id = ?::int4" withBindings: 1:156712(id)> Oct 18 18:46:57 DEBUG NSLog - 1 row(s) processed Oct 18 18:46:57 DEBUG NSLog - === Commit Internal Transaction Oct 18 18:46:57 DEBUG NSLog - === Begin Internal Transaction Oct 18 18:46:57 DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.PostgresqlExpression: "SELECT t0.createdOn, t0.id, t0.name, t0.quantity, t0.serialNumber, t0.spec_id FROM Part t0 WHERE t0.id = ?::int4" withBindings: 1:16082(id)> Oct 18 18:46:57 DEBUG NSLog - 1 row(s) processed Oct 18 18:46:57 DEBUG NSLog - === Commit Internal Transaction Oct 18 18:46:57 DEBUG NSLog - === Begin Internal Transaction Oct 18 18:46:57 DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.PostgresqlExpression: "SELECT t0.category_id, t0.costLabor, t0.costMaterial, t0.deprecatedObzervNumber, t0.description, t0.explode, t0.hsCode, t0.id, t0.inventoryType_id, t0.leadTime, t0.level, t0.manufacturer, t0.manufacturerPartNumber, t0.minimumQuantity, t0.name, t0.number, t0.origin_id, t0.productionStep, t0.refSpec_id, t0.revision, t0.scratchPad, t0.specStatus_id, t0.unitWeight FROM Spec t0 WHERE t0.id = ?::int4" withBindings: 1:5417(id)> Oct 18 18:46:57 DEBUG NSLog - 1 row(s) processed Oct 18 18:46:57 DEBUG NSLog - === Commit Internal Transaction Oct 18 18:46:57 DEBUG NSLog - === Begin Internal Transaction Oct 18 18:46:57 DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.PostgresqlExpression: "SELECT t0.dotOrder, t0.id, t0.name, t0.sequencePrefix, t0.sortOrder FROM SpecCategory t0 WHERE t0.id = ?::int4" withBindings: 1:7(id)> Oct 18 18:46:57 DEBUG NSLog - 1 row(s) processed Oct 18 18:46:57 DEBUG NSLog - === Commit Internal Transaction Oct 18 18:46:57 DEBUG NSLog - === Begin Internal Transaction Oct 18 18:46:57 DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.PostgresqlExpression: "SELECT t0.birthdate, t0.company, t0.division, t0.id, t0.initials, t0.isCustomer, t0.isEmployee, t0.isSupplier, t0.isWIPLocation, t0.login, t0.nameFirst, t0.nameLast, t0.number, t0.password, t0.payRollNumber, t0.title FROM Contact t0 WHERE t0.id = ?::int4" withBindings: 1:16(id)> Oct 18 18:46:57 DEBUG NSLog - 1 row(s) processed Oct 18 18:46:57 DEBUG NSLog - === Commit Internal Transaction > > > > Louis Demers eng. www.obzerv.com _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
