[ZODB-Dev] Ape and ConflictError's

Rocky Burt rocky.burt@bricsnet.com
10 Apr 2003 10:30:11 -0400


--=-G36SvdU9XjmpZBn8qFj4
Content-Type: text/plain
Content-Transfer-Encoding: 7bit


I've changed scenarios somewhat.  I just realized that I haven't been
getting the error from using PostgreSQL but rather Oracle8i (my Ape
modifications have been for making Ape work with other RDBMS').

I log all SQL occurring.  And I'm noticing that there are some updates
occurring even though I'm simply viewing /MySite/Data (getting the Plone
UI in my browser as a result of course).

I've attached my log as a gzipped text file.  Would someone (Shane?)
mind helping me diagnose this a little further?

If at any time I'm asking a bit too much from the list, please someone
let me know.

Thanks again,
Rocky


On Thu, 2003-04-10 at 10:05, Shane Hathaway wrote:
> Rocky Burt wrote:
> > One question, specifically is... what, exactly, does "(3L,) already
> > exists" mean?  It shouldn't be inserting anything into the database (I
> > don't think), since I'm just viewing my /MySite/Data site to get these
> > errors.
> 
> It means your application is writing to the database unintentionally. 
> To troubleshoot unintentional writes, I usually add a call to 
> "traceback.print_stack()" to the Transaction.register() method in 
> ZODB/Transactions.py.
> 
> Now, you probably shouldn't be getting that kind of conflict, so there's 
> still some other mystery here.
> 
> Shane
-- 
__________________________________________________________________________

Rocky Burt
Development, Director

Bricsnet FM Americas            -    office: +1 (603) 559-2527
53 Green St                     -    mobile: +1 (603) 512-9832
Portsmouth                      -    fax:    +1 (603) 436-5760
NH  03801  USA                  -    email:  rocky.burt@bricsnet.com
__________________________________________________________________________

--=-G36SvdU9XjmpZBn8qFj4
Content-Disposition: attachment; filename=stdout.log.gz
Content-Type: application/x-gzip; name=stdout.log.gz
Content-Transfer-Encoding: base64

H4sICA5/lT4CA3N0ZG91dC5sb2cA7Vzrb9rIFv+8+Rf6ZdQvIfcSMy+/qKJVt0naSGnJTdKttM0V
MmbSuPFrbdOG/PX3zNhAAoTAFR7Y3UStYIbxec35zeOcA6++Yhy9+orJG0ajsyzpD/wib73N/BtR
DFORt/wkLkRcdPtZ8ENkrY8XX5Ksb6TDrxT/t/3rziv5/LEXhKKPigQFUZpkBSpuBOqkIu5cXwe+
QGfDz586qKIkX4FSITJjB1V/5yIK4j6KhKTxMwsKgTzUT3yUxOgm+Sl7cyHJBjkapMjLUVDkMKQn
CqAzJjOmDCO9GP388cXLgBJQDmKUJ5HwvVzkSPwQMSoV2dlXfzsUY7aP+T7BlwS3GW1jjI7Ozzvn
DfhkD03sgT4lsdi5zDxf9Dz/FjWCOBZZlOQFCr282GuDMMdgDdQa5FkrCnK/dZ+kohXEeeHFPhi0
NwjCfhB/88EWYNAlbN7tBnFQdLtg9SYKg1gghptSpV+V5o1O77vwizYakTImpIzHpIyTyPsm9mqQ
MRMXlxP5SCXeiXKHoyxLsjZYDkVAB/jGXgTuAvM7KIJQypiJ0pFWcMQHRvnKnLErfo69XigeuKIU
bOx65bPN0pHgXzlvwa0Ih/KRfqIMChbJQXnlxSMhUTosbsAbU5h0MKGB3oM/eujd7xcIJPRvk0GB
rrMkQjdFkbZbrbFyeTLIfHGdZPBQLIrW0x5H0Mmn404D3O0w8Y8BDyI7AmmHP28EePHbNA0DsFrq
Ff4Ngv48AHGwwQ1iPE2Tjmn+0Tn8TWFSatb3Cq8HWEAgFxhhEBfQ20a7hFsOxyZ1ugRzx6TExpbh
Emxya3dpJh8lPTm/IyYLySKvQK1CRGn3OglB5afZ8AmbC5GBBdCHy8szWBjUe3DdTHIFcpc3AzBX
hghG40cluZ1fPsB8S+dro/vStY1eFvg5zAs4YbTzyxl4TBs52MGriHFckxSUrCLFxwTwANNZNRu/
E4OwvbFE0nclHhzsujtvU9E4fNeBVSwUdK+NJJQCLwzulXP0JF5iWFLAw3Yu/nP6aOjF0enRu0sU
i7uieyuG6Pi88xHdJ/2ebMF/kQLzLx+Ozo+Q7xXiW5IND3bV531x7Q3CYvcNyv8Mz7zMi/IDuZq+
QUUQiQNsgJI2Z/mbp3jeP+ZX+ksXNosorziqEQcIL2LBLb40i0xEngLi8vSp6y6vQqJW7q5Eygoc
HNdemkMkH1tFeu4sTTvNYNfIikDkqzCwydIMcuEP4DAwXGF2MV9+dgcA2pVEN5efWR9OA3kApx9P
omgVJmwBk5pQB1yf5hn0Yb+EHbipFvRyk5uafrVrPlKxTR7ya+DT5t4Dhpwz62mGaeDfwhY+YTRG
4ap8mEXo03z6AiYpU/PTLRW8z5IQXkArdQRI4iaSPiLXasV6ItJ8z3xGa8YXmFkyacJZAg5e3afX
uZUtYJsL8FwuDhOtVHt1I5vmAhai8CrrKkh0pZ4PWD7GybO8yRRvB1uLTfqA1Zz9YmLuZzmZ2KnF
Zckq1qzdZcm0yzq0dpedmVOn5tVoWknM146RaZ24yzeFEY4x1oURx9KDEUq2CSOmqx8j1NKMkUU7
9nowYnKqDSN02p4mrwkjdGYfcWvByDQfC29yH6HTBz5q1Y6RmTlddBVYB0amlcTO2vcROrOPWBvD
iEtcXRghXA9GuLVFGGHP7dN1YMTEmjGy6Kq5HoxYjGjDCJu2J6nrPsI07SPTfOxFXlk7Rqak4bZt
146RGQvUvY9MK4ltvG6MzHgPw9owwmfOrmZNGOEzwQ9SC0am+ViLbqy1Y2RKGm7x+vcRvkocZh0Y
4TOXWnPdGJnWybQ3dh/hcHjVddaiVNNZa5vuI2xRKL+esxYs647ms9b695HZk7om75kbFf18dvj2
8mge7YujMXtJew4/+ojf60Y/JVfxxW6U9MeolXk5sXsVp/QqbnwKDqF1CRIZozdX8eRdymBMP+WS
RvcmGWTyOfMqPnGv4hy6+rJtXcXHzGYmN0zTtC3myD+rHHAdJbEcY0sKb9MsCGXLKT8cCk8RBGIn
Mhdc9qbVIwRXzxiqRdSn0naqCcIf44cMTYe7pOLa94ZqEFA8kWRkXxSEYZCrblDnlGDuug52iIMx
Pi2HeKPnTMn58magGhXNQjVAj+PJo2NuyfV1LsoR0HnCRyzjQWlqUqpYdSdxcaMmAE/GppHqUbPl
le9p+QmsBEmsDE2Z5F5x9SozUV6ZSTXMyuyVJtSqNMnyUY9d8Ru1nWqEsjJ1R9KMJpvhyWwX96pH
yfj+4+U+V81KzBgmE0RVXWM5e7nRCFMGIhqvm4iePvR+i3O6TbEc29R/T3U131OphrWT8WfWtAld
uZ6VXJdazkrgmYQ5p9POxLCzuRCSg59TeQ4DpftIroM2eSjaQZvOEYI9EmK3UbpekN+gsuBib7eJ
dv81FB0Rfvsj7Jyat8fvD+Mk/37H3h4ctGFV9069och2Z4zHNMYWZs7YlqXr3lTTrj7Dxza36d5k
WtrvTXbduc6ZexOj9d+b7I1hxLW5JoxYWBNGNhqjno0tWBuILTiaMcJJ3RixVLzE6yVZ0QDasm7W
OOtcHN35IpWzabxL4usw8Ee104oA8sJMeP0hEndBXuQPq9BVIXMmfFVf74XhVDH660mlt5emeesP
sM0+NSyD7Idw9L6j+3eO1QqDXqssc25JgVpAP849VQZqpMPXVW03Zaaq7vaTKAoKpXlcvpdlpv8+
QLkIr41u2VVVOOaN6nWvDokYd5VEUzyVaN+9zCi7G0lTiTZPhGXL32GUlwoplZx71prUyT40kO1M
Gyg/6PfyIslEIwGHBTwGXthMm1UVd7OYqLVO6SRHWas+EY1YpaWULEqyzAtygZ52vcbOMp74VJky
cR+XhvsVLSQkMVX6/VulzbtSG3n2aqEGGQ/NUR6A2mUds/zuR4HmVEPvoQ0F6ijRFqhjREeohWNr
m5KipmvqD9RRpjlQZ9m1XzbNDSZ8HKztUGbqOZQRvEWHMltDMHs2tab94lJ/woc4G0v4LPxWylr3
EcckekL2DG9T0HKR1nUFLReFN2rZRxZWGa8p4WPr8R6LviR8XhI+/8yED2wG7jYly139a6dr6S5M
dDSsnVbdCR9O5iR8bGdzNcPP5u23POFDbLaxYlKXurqKSZmmYlK2TcWkFt9AMant6i0mpZjVXkxq
0s0VXLtYF0a4JowsuoXqxwg1tWOk9i8lzBRcE7t2jFhktYQPe0n4vCR8tiLhw1ZI+FD2fyZ86F8l
4cMtrClQt/CnG9YZaqHONgXqGNUfqLOo3ssmWX+Fwew3RZ3NXVwcbd+Cq+mHZLb7W3AW5foPZVj3
t+AoqftQxl13c5ERm+kqHOCa9hFOtiloyfnffx/Bpll/4YClxXvsudfrl4TPS8Lnn5DwIYt2dP1r
5yZ+rcUif7tkuTX3DL7ehI85J+HDNpfwmV+u/ldK+Kgf8fkfLbvhNxddAAA=

--=-G36SvdU9XjmpZBn8qFj4--