Custom Query (18300 matches)


Show under each result:

Results (133 - 135 of 18300)

Ticket Resolution Summary Owner Reporter
#13081 worksforme OperationalError: (1213, 'Deadlock found when trying to get lock; try restarting transaction') rchady Anuarbek

How to Reproduce

While doing a GET operation on /login, Trac issued an internal error.

(please provide additional details here)

User Agent was: Mozilla/5.0 (Windows NT 5.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1

System Information

Trac 0.11b2
Python 2.5.1 (r251:54863, Sep 22 2007, 01:43:31)
[GCC 4.2.1 (SUSE Linux)]
setuptools 0.6c3
MySQL server: "5.0.45-log", client: "5.0.45", thread-safe: 0
MySQLdb 1.2.1_p2
Genshi 0.6dev-r895
Pygments 1.0
RPC 1.0.6
Subversion 1.4.4 (r25188)
jQuery: 1.2.3

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/web/", line 419, in _dispatch_request
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/web/", line 196, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/web/", line 104, in process_request
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/web/", line 205, in _redirect_back
    req.redirect(referer or req.abs_href())
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/web/", line 266, in redirect # has to be done before the redirect is sent
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/web/", line 209, in save
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/db/", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/db/", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.5/site-packages/MySQLdb/", line 163, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.5/site-packages/MySQLdb/", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1213, 'Deadlock found when trying to get lock; try restarting transaction')

#17396 invalid defect dojox/geo/openlayers/WidgetFeature ApostolDk ApostolDk

As you move around the map with the mouse button pressed, the objects crawl away. defect visible, if the map layer with some object in map will redraw() after some time.

Fixed function attached in file

#8302 fixed Dynamic dojox.image.LightboxDialog causes invalid GET requests to server in IE6 dante Aleksey Rechinskiy

During page load or while processing .show(), dojox.image.LightboxDialog? causes Internet Explorer 6 (WinXP) to emit invalid GET requests to the server that hosts page. Say you have a page that uses dojox.image.LightboxDialog? at http://your_site/test/test.html. During dojox.image.LightboxDialog? usage in IE you may observe an http GET requests to http://your_site/test. Most of them will be aborted very soon by IE, but some will succeed possibly causing your server to overload.

I) To reproduce invalid GET requests on page load do the folling: 1) create test html file with the content: ============= start of bad_lightbox_in_IE.html ============== <!DOCTYPE HTML PUBLIC "-W3CDTD HTML 4.01EN"


<html> <head>

<title>dojox.image.LightboxDialog? causes bad GET requests in IE</title>

<!-- required: a default theme file --> <link rel="stylesheet" id="themeStyles" href="/js/dojo/dijit/themes/tundra/tundra.css"> <link rel="stylesheet" href="/js/dojo/dojox/image/resources/image.css">

<style type="text/css">

@import "/js/dojo/dojo/resources/dojo.css"; @import "/js/dojo/dijit/tests/css/dijitTests.css"; body, html { width:100%; height:100%; margin:0; padding:0; }


<!-- required: dojo.js --> <script type="text/javascript" src="/js/dojo/dojo/dojo.js" djConfig="isDebug:true, parseOnLoad: true"></script>

<!-- for debugging: --> <script type="text/javascript" src="/js/dojo/dojox/image/Lightbox.js"></script> <script type="text/javascript">



<script type="text/javascript">


function init(){

lightbox = new dojox.image.LightboxDialog?; lightbox.startup(); lightbox.addImage({title: 'image', href: ''}, 'test');

} dojo.addOnLoad(init);

showlb = function(){{title: 'image', href: ''});



</head> <body class="tundra"> <div onclick='showlb();'>Click me to open Lightbox!</div> </body> </html> ============= end of bad_lightbox_in_IE.html ============== Dojo should be located in /js/dojo subdirectory of your htdocs. 2) upload the html to your web server 3) open IE, open HTTP monitor (I use IEWebDeveloperV2). 4) type the page address to IE address bar and press enter 5) see during the page load requests: GET 200 1.05 K text/html http://your_site/js/dojo/dojox/image/resources/Lightbox.html GET Aborted 0 (None) http://your_site/test/ GET Aborted 0 (None) http://your_site/test/ GET 200 6.24 K text/html http://your_site/test/

I think, thats is happening because LightboxDialog?.imgUrl property is defined as "" (empty string) and when it gets inserted in Lightbox template, and the template gets inserted into DOM, IE tries to load image with src= and it leads to http://your_site/test/ request. To prove it, please, change line 147 of .\dojo\dojox\image\Lightbox.js from

imgUrl: "",


imgUrl: dojo.moduleUrl("dojox.image","resources/images/warning.png"),

and reload the page (remember to upload it to server and to clean IE cache before). You will not see any GET http://your_site/test/ requests then. (They will be changed to GET http://your_site/js/dojo/dojox/resources/images/warning.png)

II) There is at least one similar error in dojox.image.LightboxDialog?, but I failed to reproduce it in test page though it exists on my production site. The problem is in LightboxDialog?.show() function - it causes the same GET http://your_site/test/ request on every but first execution. The problem hides in the following code starting at line 211 of .\dojo\dojox\image\Lightbox.js:


ugly fix for IE being stupid: dojo._destroyElement(_t.imgNode); _t.imgNode = dojo.clone(_t._clone);,_t.imageContainer,"first"); _t._makeAnims(); _t._wasStyled = false;


_t._imageReady = false; _t.imgNode.src = groupData.href;

If the cloning node (_t._clone) don't have src attribute specified, then after it get inserted to DOM with, IE will generate invalid GET http://your_site/test/ that can be completed before execution of _t.imgNode.src = groupData.href; on slow PCs in some rare cases.

So, I would advice to correct this code at least to

_t._imageReady = false; if(this._wasStyled){

ugly fix for IE being stupid: dojo._destroyElement(_t.imgNode); _t.imgNode = dojo.clone(_t._clone); _t.imgNode.src = groupData.href;,_t.imageContainer,"first"); _t._makeAnims(); _t._wasStyled = false;


_t.imgNode.src = groupData.href;


I hope all correction I offered are clean & easy to be included in the very next Dojo minor release.

Please, feel free to contact me over email arech2004 at mail dot ru, if any assistance needed.

Note: See TracQuery for help on using queries.