API tools faq
paste
Guest User

Untitled

a guest
Apr 16th, 2012
97
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 40.56 KB | None | 0 0
raw download clone embed print report
  1. 2012-04-16 12:10:15,491 API GET /main/tag/lookup/ {u'__limit': u'25', u'__start': u'0', u'__page': u'1', u'_dc': u'1334563814574', u'__format': u'ext', u'__query': u''}
  2. 2012-04-16 12:10:15,497 SQL SELECT "auth_user"."id", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."password", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."is
  3. _superuser", "auth_user"."last_login", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1 0.004s
  4. 2012-04-16 12:10:15,497 SQL SELECT COUNT(*) FROM "tagging_tag" 0.001s
  5. 2012-04-16 12:10:15,497 SQL SELECT "tagging_tag"."id", "tagging_tag"."name" FROM "tagging_tag" ORDER BY "tagging_tag"."name" ASC LIMIT 25 0.001s
  6. 2012-04-16 12:10:15,498 SQL statements: 3 (SELECT: 3)
  7. 2012-04-16 12:10:15,499 200 GET /main/tag/lookup/?_dc=1334563814574&__query=&__format=ext&__page=1&__start=0&__limit=25 (127.0.0.1) 28.12ms
  8. 2012-04-16 12:10:16,653 API GET /vc/vc/ {u'__limit': u'37', u'tags__tags': u'delete', u'__start': u'0', u'__page': u'1', u'_dc': u'1334563815789', u'__format': u'ext'}
  9. 2012-04-16 12:10:16,722 UNHANDLED EXCEPTION (2012-04-16 12:10:16.696958)
  10. Working directory: /usr/local/noc
  11. <class 'django.db.utils.DatabaseError'>
  12. column reference "id" is ambiguous
  13. LINE 2: (id IN (
  14. ^
  15.  
  16. START OF TRACEBACK
  17. ------------------------------------------------------------------------
  18. File: /usr/local/noc/contrib/lib/django/db/backends/postgresql_psycopg2/base.py (Line: 44)
  19. Function: execute
  20. 37 """
  21. 38
  22. 39 def __init__(self, cursor):
  23. 40 self.cursor = cursor
  24. 41
  25. 42 def execute(self, query, args=None):
  26. 43 try:
  27. 44 ==> return self.cursor.execute(query, args)
  28. 45 except Database.IntegrityError, e:
  29. 46 raise utils.IntegrityError, utils.IntegrityError(*tuple(e)), sys.exc_info()[2]
  30. 47 except Database.DatabaseError, e:
  31. 48 raise utils.DatabaseError, utils.DatabaseError(*tuple(e)), sys.exc_info()[2]
  32. 49
  33. 50 def executemany(self, query, args):
  34. Variables:
  35. query = 'SELECT "vc_vc"."id", "vc_vc"."vc_domain_id", "vc_vc"."name", "vc_vc"."l1", "vc_vc"."l2", "vc_vc"."description", "vc_vc"."style_id", "vc_vc"."tags", "vc_vcdomain"."id", "vc_vcdomain"."name", "vc_vcdomain"."descript
  36. ion", "vc_vcdomain"."type_id", "vc_vcdomain"."enable_provisioning", "vc_vcdomain"."enable_vc_bind_filter", "vc_vcdomain"."selector_id", "vc_vcdomain"."style_id", "vc_vctype"."id", "vc_vctype"."name", "vc_vctype"."min_labels", "vc_vctype"
  37. ."label1_min", "vc_vctype"."label1_max", "vc_vctype"."label2_min", "vc_vctype"."label2_max" FROM "vc_vc" INNER JOIN "vc_vcdomain" ON ("vc_vc"."vc_domain_id" = "vc_vcdomain"."id") INNER JOIN "vc_vctype" ON ("vc_vcdomain"."type_id" = "vc_v
  38. ctype"."id") WHERE \n (id IN (\n SELECT object_id\n FROM tagging_taggeditem\n WHERE\n content_type_id = 84\n AND tag_id
  39. in (7)\n GROUP BY object_id\n HAVING COUNT(object_id) = 1\n )) ORDER BY "vc_vc"."vc_domain_id" ASC, "vc_vc"."l1" ASC, "vc_vc"."l2" ASC LIMIT 37'
  40. self = <django.db.backends.postgresql_psycopg2.base.CursorWrapper object at 0x2a83fecc>
  41. args = ()
  42. e = ProgrammingError('column reference "id" is ambiguous\nLINE 2: (id IN (\n ^\n',)
  43. ------------------------------------------------------------------------
  44. File: /usr/local/noc/contrib/lib/django/db/backends/util.py (Line: 34)
  45. Function: execute
  46. 27
  47. 28
  48. 29 class CursorDebugWrapper(CursorWrapper):
  49. 30
  50. 31 def execute(self, sql, params=()):
  51. 32 start = time()
  52. 33 try:
  53. 34 ==> return self.cursor.execute(sql, params)
  54. 35 finally:
  55. 36 stop = time()
  56. 37 duration = stop - start
  57. 38 sql = self.db.ops.last_executed_query(self.cursor, sql, params)
  58. 39 self.db.queries.append({
  59. 40 'sql': sql,
  60. Variables:
  61. self = <django.db.backends.util.CursorDebugWrapper object at 0x2a83fe4c>
  62. stop = 1334563816.67217
  63. start = 1334563816.669982
  64. params = ()
  65. sql = 'SELECT "vc_vc"."id", "vc_vc"."vc_domain_id", "vc_vc"."name", "vc_vc"."l1", "vc_vc"."l2", "vc_vc"."description", "vc_vc"."style_id", "vc_vc"."tags", "vc_vcdomain"."id", "vc_vcdomain"."name", "vc_vcdomain"."descript
  66. ion", "vc_vcdomain"."type_id", "vc_vcdomain"."enable_provisioning", "vc_vcdomain"."enable_vc_bind_filter", "vc_vcdomain"."selector_id", "vc_vcdomain"."style_id", "vc_vctype"."id", "vc_vctype"."name", "vc_vctype"."min_labels", "vc_vctype"
  67. ."label1_min", "vc_vctype"."label1_max", "vc_vctype"."label2_min", "vc_vctype"."label2_max" FROM "vc_vc" INNER JOIN "vc_vcdomain" ON ("vc_vc"."vc_domain_id" = "vc_vcdomain"."id") INNER JOIN "vc_vctype" ON ("vc_vcdomain"."type_id" = "vc_v
  68. ctype"."id") WHERE \n (id IN (\n SELECT object_id\n FROM tagging_taggeditem\n WHERE\n content_type_id = 84\n AND tag_id
  69. in (7)\n GROUP BY object_id\n HAVING COUNT(object_id) = 1\n )) ORDER BY "vc_vc"."vc_domain_id" ASC, "vc_vc"."l1" ASC, "vc_vc"."l2" ASC LIMIT 37'
  70. duration = 0.002187967300415039
  71. ------------------------------------------------------------------------
  72. File: /usr/local/noc/contrib/lib/django/db/models/sql/compiler.py (Line: 735)
  73. Function: execute_sql
  74. 728 except EmptyResultSet:
  75. 729 if result_type == MULTI:
  76. 730 return empty_iter()
  77. 731 else:
  78. 732 return
  79. 733
  80. 734 cursor = self.connection.cursor()
  81. 735 ==> cursor.execute(sql, params)
  82. 736
  83. 737 if not result_type:
  84. 738 return cursor
  85. 739 if result_type == SINGLE:
  86. 740 if self.query.ordering_aliases:
  87. 741 return cursor.fetchone()[:-len(self.query.ordering_aliases)]
  88. Variables:
  89. cursor = <django.db.backends.util.CursorDebugWrapper object at 0x2a83fe4c>
  90. self = <django.db.models.sql.compiler.SQLCompiler object at 0x2a83f4ec>
  91. params = ()
  92. result_type = 'multi'
  93. sql = 'SELECT "vc_vc"."id", "vc_vc"."vc_domain_id", "vc_vc"."name", "vc_vc"."l1", "vc_vc"."l2", "vc_vc"."description", "vc_vc"."style_id", "vc_vc"."tags", "vc_vcdomain"."id", "vc_vcdomain"."name", "vc_vcdomain"."descript
  94. ion", "vc_vcdomain"."type_id", "vc_vcdomain"."enable_provisioning", "vc_vcdomain"."enable_vc_bind_filter", "vc_vcdomain"."selector_id", "vc_vcdomain"."style_id", "vc_vctype"."id", "vc_vctype"."name", "vc_vctype"."min_labels", "vc_vctype"
  95. ."label1_min", "vc_vctype"."label1_max", "vc_vctype"."label2_min", "vc_vctype"."label2_max" FROM "vc_vc" INNER JOIN "vc_vcdomain" ON ("vc_vc"."vc_domain_id" = "vc_vcdomain"."id") INNER JOIN "vc_vctype" ON ("vc_vcdomain"."type_id" = "vc_v
  96. ctype"."id") WHERE \n (id IN (\n SELECT object_id\n FROM tagging_taggeditem\n WHERE\n content_type_id = 84\n AND tag_id
  97. in (7)\n GROUP BY object_id\n HAVING COUNT(object_id) = 1\n )) ORDER BY "vc_vc"."vc_domain_id" ASC, "vc_vc"."l1" ASC, "vc_vc"."l2" ASC LIMIT 37'
  98. ------------------------------------------------------------------------
  99. File: /usr/local/noc/contrib/lib/django/db/models/sql/compiler.py (Line: 680)
  100. Function: results_iter
  101. 673 def results_iter(self):
  102. 674 """
  103. 675 Returns an iterator over the results from executing this query.
  104. 676 """
  105. 677 resolve_columns = hasattr(self, 'resolve_columns')
  106. 678 fields = None
  107. 679 has_aggregate_select = bool(self.query.aggregate_select)
  108. 680 ==> for rows in self.execute_sql(MULTI):
  109. 681 for row in rows:
  110. 682 if resolve_columns:
  111. 683 if fields is None:
  112. 684 # We only set this up here because
  113. 685 # related_select_fields isn't populated until
  114. 686 # execute_sql() has been called.
  115. Variables:
  116. fields = None
  117. self = <django.db.models.sql.compiler.SQLCompiler object at 0x2a83f4ec>
  118. has_aggregate_select = False
  119. resolve_columns = False
  120. ------------------------------------------------------------------------
  121. File: /usr/local/noc/contrib/lib/django/db/models/query.py (Line: 273)
  122. Function: iterator
  123. 266 init_list.append(field.attname)
  124. 267 model_cls = deferred_class_factory(self.model, skip)
  125. 268
  126. 269 # Cache db and model outside the loop
  127. 270 db = self.db
  128. 271 model = self.model
  129. 272 compiler = self.query.get_compiler(using=db)
  130. 273 ==> for row in compiler.results_iter():
  131. 274 if fill_cache:
  132. 275 obj, _ = get_cached_row(model, row,
  133. 276 index_start, using=db, max_depth=max_depth,
  134. 277 requested=requested, offset=len(aggregate_select),
  135. 278 only_load=only_load)
  136. 279 else:
  137. Variables:
  138. requested = None
  139. fill_cache = True
  140. aggregate_select = []
  141. skip = None
  142. self = []
  143. load_fields = []
  144. db = 'default'
  145. index_start = 0
  146. extra_select = []
  147. aggregate_start = 8
  148. model = <class 'noc.vc.models.VC'>
  149. only_load = {}
  150. max_depth = 5
  151. compiler = <django.db.models.sql.compiler.SQLCompiler object at 0x2a83f4ec>
  152. ------------------------------------------------------------------------
  153. File: /usr/local/noc/contrib/lib/django/db/models/query.py (Line: 772)
  154. Function: _fill_cache
  155. 765 """
  156. 766 Fills the result cache with 'num' more entries (or until the results
  157. 767 iterator is exhausted).
  158. 768 """
  159. 769 if self._iter:
  160. 770 try:
  161. 771 for i in range(num or ITER_CHUNK_SIZE):
  162. 772 ==> self._result_cache.append(self._iter.next())
  163. 773 except StopIteration:
  164. 774 self._iter = None
  165. 775
  166. 776 def _next_is_sticky(self):
  167. 777 """
  168. 778 Indicates that the next filter call and the one following that should
  169. Variables:
  170. i = 0
  171. self = []
  172. num = None
  173. File: /usr/local/noc/contrib/lib/django/db/models/query.py (Line: 107)
  174. Function: _result_iter
  175. 100 upper = len(self._result_cache)
  176. 101 while pos < upper:
  177. 102 yield self._result_cache[pos]
  178. 103 pos = pos + 1
  179. 104 if not self._iter:
  180. 105 raise StopIteration
  181. 106 if len(self._result_cache) <= pos:
  182. 107 ==> self._fill_cache()
  183. 108
  184. 109 def __nonzero__(self):
  185. 110 if self._result_cache is not None:
  186. 111 return bool(self._result_cache)
  187. 112 try:
  188. 113 iter(self).next()
  189. Variables:
  190. upper = 0
  191. self = []
  192. pos = 0
  193. ------------------------------------------------------------------------
  194. File: /usr/local/noc/lib/app/extmodelapplication.py (Line: 259)
  195. Function: list_data
  196. 252 # Apply sorting
  197. 253 if ordering:
  198. 254 data = data.order_by(*ordering)
  199. 255 if format == "ext":
  200. 256 total = data.count()
  201. 257 if start is not None and limit is not None:
  202. 258 data = data[int(start):int(start) + int(limit)]
  203. 259 ==> out = [formatter(o) for o in data]
  204. 260 if format == "ext":
  205. 261 out = {
  206. 262 "total": total,
  207. 263 "success": True,
  208. 264 "data": out
  209. 265 }
  210. Variables:
  211. formatter = <bound method VCApplication.instance_to_dict of <noc.vc.apps.vc.views.VCApplication object at 0x2adf088c>>
  212. format = u'ext'
  213. ordering = []
  214. self = <noc.vc.apps.vc.views.VCApplication object at 0x2adf088c>
  215. request = <WSGIRequest
  216. GET:<QueryDict: {u'__limit': [u'37'], u'tags__tags': [u'delete'], u'__start': [u'0'], u'__page': [u'1'], u'_dc': [u'1334563815789'], u'__format': [u'ext']}>,
  217. POST:<QueryDict: {}>,
  218. COOKIES:{'csrftoken': 'be8b13c68edc98f74583ad21ed92a08e',
  219. 'sessionid': '899932577f4c961b279b7975c3f3c51f'},
  220. META:{'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
  221. 'HTTP_ACCEPT_LANGUAGE': 'ru-ru,ru;q=0.8,en-us;q=0.5,en;q=0.3',
  222. 'HTTP_CONNECTION': 'close',
  223. 'HTTP_COOKIE': 'sessionid=899932577f4c961b279b7975c3f3c51f; csrftoken=be8b13c68edc98f74583ad21ed92a08e',
  224. 'HTTP_HOST': '127.0.0.1:8000',
  225. 'HTTP_REFERER': 'http://192.168.10.152/main/desktop/',
  226. 'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 6.1; rv:11.0) Gecko/20100101 Firefox/11.0',
  227. 'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest',
  228. 'PATH_INFO': u'/vc/vc/',
  229. 'QUERY_STRING': '_dc=1334563815789&tags__tags=delete&__format=ext&__page=1&__start=0&__limit=37',
  230. 'REMOTE_ADDR': '127.0.0.1',
  231. 'REQUEST_METHOD': 'GET',
  232. 'SCRIPT_NAME': u'',
  233. 'SERVER_NAME': '127.0.0.1',
  234. 'SERVER_PORT': '8000',
  235. 'SERVER_PROTOCOL': 'HTTP/1.0',
  236. 'wsgi.errors': <open file '/dev/null', mode 'a+' at 0x29227128>,
  237. 'wsgi.input': <_io.BytesIO object at 0x2a81420c>,
  238. 'wsgi.multiprocess': True,
  239. 'wsgi.multithread': False,
  240. 'wsgi.run_once': False,
  241. 'wsgi.url_scheme': 'http',
  242. 'wsgi.version': (1, 0)}>
  243. q = {}
  244. start = u'0'
  245. limit = u'37'
  246. query = None
  247. ew = ['\n (id IN (\n SELECT object_id\n FROM tagging_taggeditem\n WHERE\n content_type_id = 84\n AND
  248. tag_id in (7)\n GROUP BY object_id\n HAVING COUNT(object_id) = 1\n ))']
  249. total = 48
  250. data = []
  251. ------------------------------------------------------------------------
  252. File: /usr/local/noc/lib/app/extmodelapplication.py (Line: 300)
  253. Function: api_list
  254. 293 if None in q:
  255. 294 q[None] += [s]
  256. 295 else:
  257. 296 q[None] = [s]
  258. 297
  259. 298 @view(method=["GET"], url="^$", access="read", api=True)
  260. 299 def api_list(self, request):
  261. 300 ==> return self.list_data(request, self.instance_to_dict)
  262. 301
  263. 302 @view(method=["GET"], url=r"^lookup/$", access="lookup", api=True)
  264. 303 def api_lookup(self, request):
  265. 304 return self.list_data(request, self.instance_to_lookup)
  266. 305
  267. 306 @view(method=["POST"], url="^$", access="create", api=True)
  268. Variables:
  269. self = <noc.vc.apps.vc.views.VCApplication object at 0x2adf088c>
  270. request = <WSGIRequest
  271. GET:<QueryDict: {u'__limit': [u'37'], u'tags__tags': [u'delete'], u'__start': [u'0'], u'__page': [u'1'], u'_dc': [u'1334563815789'], u'__format': [u'ext']}>,
  272. POST:<QueryDict: {}>,
  273. COOKIES:{'csrftoken': 'be8b13c68edc98f74583ad21ed92a08e',
  274. 'sessionid': '899932577f4c961b279b7975c3f3c51f'},
  275. META:{'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
  276. 'HTTP_ACCEPT_LANGUAGE': 'ru-ru,ru;q=0.8,en-us;q=0.5,en;q=0.3',
  277. 'HTTP_CONNECTION': 'close',
  278. 'HTTP_COOKIE': 'sessionid=899932577f4c961b279b7975c3f3c51f; csrftoken=be8b13c68edc98f74583ad21ed92a08e',
  279. 'HTTP_HOST': '127.0.0.1:8000',
  280. 'HTTP_REFERER': 'http://192.168.10.152/main/desktop/',
  281. 'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 6.1; rv:11.0) Gecko/20100101 Firefox/11.0',
  282. 'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest',
  283. 'PATH_INFO': u'/vc/vc/',
  284. 'QUERY_STRING': '_dc=1334563815789&tags__tags=delete&__format=ext&__page=1&__start=0&__limit=37',
  285. 'REMOTE_ADDR': '127.0.0.1',
  286. 'REQUEST_METHOD': 'GET',
  287. 'SCRIPT_NAME': u'',
  288. 'SERVER_NAME': '127.0.0.1',
  289. 'SERVER_PORT': '8000',
  290. 'SERVER_PROTOCOL': 'HTTP/1.0',
  291. 'wsgi.errors': <open file '/dev/null', mode 'a+' at 0x29227128>,
  292. 'wsgi.input': <_io.BytesIO object at 0x2a81420c>,
  293. 'wsgi.multiprocess': True,
  294. 'wsgi.multithread': False,
  295. 'wsgi.run_once': False,
  296. 'wsgi.url_scheme': 'http',
  297. 'wsgi.version': (1, 0)}>
  298. ------------------------------------------------------------------------
  299. File: /usr/local/noc/lib/app/site.py (Line: 225)
  300. Function: inner
  301. 218 for k, v in request.POST.lists())
  302. 219 elif request.method == "GET":
  303. 220 a = dict((k, v[0] if len(v) == 1 else v)
  304. 221 for k, v in request.GET.lists())
  305. 222 logging.debug("API %s %s %s" % (request.method,
  306. 223 request.path, a))
  307. 224 # Call handler
  308. 225 ==> r = v(request, *args, **kwargs)
  309. 226 # Dump SQL statements
  310. 227 if self.log_sql_statements:
  311. 228 from django.db import connections
  312. 229 tsc = 0
  313. 230 sc = defaultdict(int)
  314. 231 for conn in connections.all():
  315. Variables:
  316. a = {u'__limit': u'37', u'tags__tags': u'delete', u'__start': u'0', u'__page': u'1', u'_dc': u'1334563815789', u'__format': u'ext'}
  317. args = ()
  318. view_map = {'POST': <bound method VCApplication.api_create of <noc.vc.apps.vc.views.VCApplication object at 0x2adf088c>>, 'GET': <bound method VCApplication.api_list of <noc.vc.apps.vc.views.VCApplication object at 0x2adf088c
  319. >>}
  320. Form = <class 'django.forms.forms.Form'>
  321. DictParameter = <class 'noc.sa.interfaces.base.DictParameter'>
  322. self = <noc.lib.app.site.Site object at 0x29b6298c>
  323. v = <bound method VCApplication.api_list of <noc.vc.apps.vc.views.VCApplication object at 0x2adf088c>>
  324. request = <WSGIRequest
  325. GET:<QueryDict: {u'__limit': [u'37'], u'tags__tags': [u'delete'], u'__start': [u'0'], u'__page': [u'1'], u'_dc': [u'1334563815789'], u'__format': [u'ext']}>,
  326. POST:<QueryDict: {}>,
  327. COOKIES:{'csrftoken': 'be8b13c68edc98f74583ad21ed92a08e',
  328. 'sessionid': '899932577f4c961b279b7975c3f3c51f'},
  329. META:{'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
  330. 'HTTP_ACCEPT_LANGUAGE': 'ru-ru,ru;q=0.8,en-us;q=0.5,en;q=0.3',
  331. 'HTTP_CONNECTION': 'close',
  332. 'HTTP_COOKIE': 'sessionid=899932577f4c961b279b7975c3f3c51f; csrftoken=be8b13c68edc98f74583ad21ed92a08e',
  333. 'HTTP_HOST': '127.0.0.1:8000',
  334. 'HTTP_REFERER': 'http://192.168.10.152/main/desktop/',
  335. 'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 6.1; rv:11.0) Gecko/20100101 Firefox/11.0',
  336. 'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest',
  337. 'PATH_INFO': u'/vc/vc/',
  338. 'QUERY_STRING': '_dc=1334563815789&tags__tags=delete&__format=ext&__page=1&__start=0&__limit=37',
  339. 'REMOTE_ADDR': '127.0.0.1',
  340. 'REQUEST_METHOD': 'GET',
  341. 'SCRIPT_NAME': u'',
  342. 'SERVER_NAME': '127.0.0.1',
  343. 'SERVER_PORT': '8000',
  344. 'SERVER_PROTOCOL': 'HTTP/1.0',
  345. 'wsgi.errors': <open file '/dev/null', mode 'a+' at 0x29227128>,
  346. 'wsgi.input': <_io.BytesIO object at 0x2a81420c>,
  347. 'wsgi.multiprocess': True,
  348. 'wsgi.multithread': False,
  349. 'wsgi.run_once': False,
  350. 'wsgi.url_scheme': 'http',
  351. 'wsgi.version': (1, 0)}>
  352. InterfaceTypeError = <class 'noc.sa.interfaces.base.InterfaceTypeError'>
  353. to_log_api_call = True
  354. kwargs = {}
  355. PermissionDenied = <class 'noc.lib.app.access.PermissionDenied'>
  356. tb = u'UNHANDLED EXCEPTION (2012-04-16 12:10:16.672267)\nWorking directory: /usr/local/noc\n<class \'django.db.utils.DatabaseError\'>\ncolumn reference "id" is ambiguous\nLINE 2: (id IN (\n
  357. ^\n\nSTART OF TRACEBACK\n------------------------------------------------------------------------\nFile: /usr/local/noc/contrib/lib/django/db/backends/postgresql_psycopg2/base.py (Line: 44)\nFunction: execute\n 37 ""
  358. "\n 38 \n 39 def __init__(self, cursor):\n 40 self.cursor = cursor\n 41 \n 42 def execute(self, query, args=None):\n 43 try:\n 44 ==> return self.cursor.execute(qu
  359. ery, args)\n 45 except Database.IntegrityError, e:\n 46 raise utils.IntegrityError, utils.IntegrityError(*tuple(e)), sys.exc_info()[2]\n 47 except Database.DatabaseError, e:\n 48
  360. raise utils.DatabaseError, utils.DatabaseError(*tuple(e)), sys.exc_info()[2]\n 49 \n 50 def executemany(self, query, args):\nVariables:\n query = \'SELECT "vc_vc"."id", "vc_vc"."vc_domain_id", "vc_vc".
  361. "name", "vc_vc"."l1", "vc_vc"."l2", "vc_vc"."description", "vc_vc"."style_id", "vc_vc"."tags", "vc_vcdomain"."id", "vc_vcdomain"."name", "vc_vcdomain"."description", "vc_vcdomain"."type_id", "vc_vcdomain"."enable_provisioning", "vc_vcdom
  362. ain"."enable_vc_bind_filter", "vc_vcdomain"."selector_id", "vc_vcdomain"."style_id", "vc_vctype"."id", "vc_vctype"."name", "vc_vctype"."min_labels", "vc_vctype"."label1_min", "vc_vctype"."label1_max", "vc_vctype"."label2_min", "vc_vctype
  363. "."label2_max" FROM "vc_vc" INNER JOIN "vc_vcdomain" ON ("vc_vc"."vc_domain_id" = "vc_vcdomain"."id") INNER JOIN "vc_vctype" ON ("vc_vcdomain"."type_id" = "vc_vctype"."id") WHERE \\n (id IN (\\n SELECT o
  364. bject_id\\n FROM tagging_taggeditem\\n WHERE\\n content_type_id = 84\\n AND tag_id in (7)\\n GROUP BY object_id\\n
  365. HAVING COUNT(object_id) = 1\\n )) ORDER BY "vc_vc"."vc_domain_id" ASC, "vc_vc"."l1" ASC, "vc_vc"."l2" ASC LIMIT 37\'\n self = <django.db.backends.postgresql_psycopg2.base.CursorWrapper object at 0x2a83fecc>\
  366. n args = ()\n e = ProgrammingError(\'column reference "id" is ambiguous\\nLINE 2: (id IN (\\n ^\\n\',)\n------------------------------------------------------------
  367. ------------\nFile: /usr/local/noc/contrib/lib/django/db/backends/util.py (Line: 34)\nFunction: execute\n 27 \n 28 \n 29 class CursorDebugWrapper(CursorWrapper):\n 30 \n 31 def execute(self, sql, params=
  368. ()):\n 32 start = time()\n 33 try:\n 34 ==> return self.cursor.execute(sql, params)\n 35 finally:\n 36 stop = time()\n 37 duration = stop - start
  369. \n 38 sql = self.db.ops.last_executed_query(self.cursor, sql, params)\n 39 self.db.queries.append({\n 40 \'sql\': sql,\nVariables:\n self = <django.db.backends.util
  370. .CursorDebugWrapper object at 0x2a83fe4c>\n stop = 1334563816.67217\n start = 1334563816.669982\n params = ()\n sql = \'SELECT "vc_vc"."id", "vc_vc"."vc_domain_id", "vc_vc"."name"
  371. , "vc_vc"."l1", "vc_vc"."l2", "vc_vc"."description", "vc_vc"."style_id", "vc_vc"."tags", "vc_vcdomain"."id", "vc_vcdomain"."name", "vc_vcdomain"."description", "vc_vcdomain"."type_id", "vc_vcdomain"."enable_provisioning", "vc_vcdomain"."
  372. enable_vc_bind_filter", "vc_vcdomain"."selector_id", "vc_vcdomain"."style_id", "vc_vctype"."id", "vc_vctype"."name", "vc_vctype"."min_labels", "vc_vctype"."label1_min", "vc_vctype"."label1_max", "vc_vctype"."label2_min", "vc_vctype"."lab
  373. el2_max" FROM "vc_vc" INNER JOIN "vc_vcdomain" ON ("vc_vc"."vc_domain_id" = "vc_vcdomain"."id") INNER JOIN "vc_vctype" ON ("vc_vcdomain"."type_id" = "vc_vctype"."id") WHERE \\n (id IN (\\n SELECT object_
  374. id\\n FROM tagging_taggeditem\\n WHERE\\n content_type_id = 84\\n AND tag_id in (7)\\n GROUP BY object_id\\n HAVING
  375. COUNT(object_id) = 1\\n )) ORDER BY "vc_vc"."vc_domain_id" ASC, "vc_vc"."l1" ASC, "vc_vc"."l2" ASC LIMIT 37\'\n duration = 0.002187967300415039\n-----------------------------------------------------------------
  376. -------\nFile: /usr/local/noc/contrib/lib/django/db/models/sql/compiler.py (Line: 735)\nFunction: execute_sql\n 728 except EmptyResultSet:\n 729 if result_type == MULTI:\n 730 return emp
  377. ty_iter()\n 731 else:\n 732 return\n 733 \n 734 cursor = self.connection.cursor()\n 735 ==> cursor.execute(sql, params)\n 736 \n 737 if not result_type:\n
  378. 738 return cursor\n 739 if result_type == SINGLE:\n 740 if self.query.ordering_aliases:\n 741 return cursor.fetchone()[:-len(self.query.ordering_aliases)]\nVariables:\n
  379. cursor = <django.db.backends.util.CursorDebugWrapper object at 0x2a83fe4c>\n self = <django.db.models.sql.compiler.SQLCompiler object at 0x2a83f4ec>\n params = ()\n result_type = \'multi\
  380. '\n sql = \'SELECT "vc_vc"."id", "vc_vc"."vc_domain_id", "vc_vc"."name", "vc_vc"."l1", "vc_vc"."l2", "vc_vc"."description", "vc_vc"."style_id", "vc_vc"."tags", "vc_vcdomain"."id", "vc_vcdomain"."name", "vc_vcdomain"."desc
  381. ription", "vc_vcdomain"."type_id", "vc_vcdomain"."enable_provisioning", "vc_vcdomain"."enable_vc_bind_filter", "vc_vcdomain"."selector_id", "vc_vcdomain"."style_id", "vc_vctype"."id", "vc_vctype"."name", "vc_vctype"."min_labels", "vc_vct
  382. ype"."label1_min", "vc_vctype"."label1_max", "vc_vctype"."label2_min", "vc_vctype"."label2_max" FROM "vc_vc" INNER JOIN "vc_vcdomain" ON ("vc_vc"."vc_domain_id" = "vc_vcdomain"."id") INNER JOIN "vc_vctype" ON ("vc_vcdomain"."type_id" = "
  383. vc_vctype"."id") WHERE \\n (id IN (\\n SELECT object_id\\n FROM tagging_taggeditem\\n WHERE\\n content_type_id = 84\\n
  384. AND tag_id in (7)\\n GROUP BY object_id\\n HAVING COUNT(object_id) = 1\\n )) ORDER BY "vc_vc"."vc_domain_id" ASC, "vc_vc"."l1" ASC, "vc_vc"."l2" ASC LIMIT 37\'\n-----------------------
  385. -------------------------------------------------\nFile: /usr/local/noc/contrib/lib/django/db/models/sql/compiler.py (Line: 680)\nFunction: results_iter\n 673 def results_iter(self):\n 674 """\n 675 Ret
  386. urns an iterator over the results from executing this query.\n 676 """\n 677 resolve_columns = hasattr(self, \'resolve_columns\')\n 678 fields = None\n 679 has_aggregate_select = bool(s
  387. elf.query.aggregate_select)\n 680 ==> for rows in self.execute_sql(MULTI):\n 681 for row in rows:\n 682 if resolve_columns:\n 683 if fields is None:\n 684
  388. # We only set this up here because\n 685 # related_select_fields isn\'t populated until\n 686 # execute_sql() has been called.\nVariables:\n fields
  389. = None\n self = <django.db.models.sql.compiler.SQLCompiler object at 0x2a83f4ec>\nhas_aggregate_select = False\n resolve_columns = False\n------------------------------------------------------------------------\nFile:
  390. /usr/local/noc/contrib/lib/django/db/models/query.py (Line: 273)\nFunction: iterator\n 266 init_list.append(field.attname)\n 267 model_cls = deferred_class_factory(self.model, skip)\n 268 \
  391. n 269 # Cache db and model outside the loop\n 270 db = self.db\n 271 model = self.model\n 272 compiler = self.query.get_compiler(using=db)\n 273 ==> for row in compiler.results
  392. _iter():\n 274 if fill_cache:\n 275 obj, _ = get_cached_row(model, row,\n 276 index_start, using=db, max_depth=max_depth,\n 277 reque
  393. sted=requested, offset=len(aggregate_select),\n 278 only_load=only_load)\n 279 else:\nVariables:\n requested = None\n fill_cache = True\n aggregate_select = []\n
  394. skip = None\n self = []\n load_fields = []\n db = \'default\'\n index_start = 0\n extra_select = []\n aggregate_start = 8\n model = <class \'noc.vc.mode
  395. ls.VC\'>\n only_load = {}\n max_depth = 5\n compiler = <django.db.models.sql.compiler.SQLCompiler object at 0x2a83f4ec>\n------------------------------------------------------------------------\nFile: /usr/
  396. local/noc/contrib/lib/django/db/models/query.py (Line: 772)\nFunction: _fill_cache\n 765 """\n 766 Fills the result cache with \'num\' more entries (or until the results\n 767 iterator is exhausted)
  397. .\n 768 """\n 769 if self._iter:\n 770 try:\n 771 for i in range(num or ITER_CHUNK_SIZE):\n 772 ==> self._result_cache.append(self._iter.next())\n 773
  398. except StopIteration:\n 774 self._iter = None\n 775 \n 776 def _next_is_sticky(self):\n 777 """\n 778 Indicates that the next filter call and the one following
  399. that should\nVariables:\n i = 0\n self = []\n num = None\n------------------------------------------------------------------------\nFile: /usr/local/noc/contrib/lib/django/db/models/query.
  400. py (Line: 107)\nFunction: _result_iter\n 100 upper = len(self._result_cache)\n 101 while pos < upper:\n 102 yield self._result_cache[pos]\n 103 pos = pos + 1\n
  401. 104 if not self._iter:\n 105 raise StopIteration\n 106 if len(self._result_cache) <= pos:\n 107 ==> self._fill_cache()\n 108 \n 109 def __nonzero__(self
  402. ):\n 110 if self._result_cache is not None:\n 111 return bool(self._result_cache)\n 112 try:\n 113 iter(self).next()\nVariables:\n upper = 0\n self
  403. = []\n pos = 0\n------------------------------------------------------------------------\nFile: /usr/local/noc/lib/app/extmodelapplication.py (Line: 259)\nFunction: list_data\n 252 # Apply sorting\n 253
  404. if ordering:\n 254 data = data.order_by(*ordering)\n 255 if format == "ext":\n 256 total = data.count()\n 257 if start is not None and limit is not None:\n 258
  405. data = data[int(start):int(start) + int(limit)]\n 259 ==> out = [formatter(o) for o in data]\n 260 if format == "ext":\n 261 out = {\n 262 "total": total,\n 263
  406. "success": True,\n 264 "data": out\n 265 }\nVariables:\n formatter = <bound method VCApplication.instance_to_dict of <noc.vc.apps.vc.views.VCApplication object at 0x2adf088c>>\
  407. n format = u\'ext\'\n ordering = []\n self = <noc.vc.apps.vc.views.VCApplication object at 0x2adf088c>\n request = <WSGIRequest\nGET:<QueryDict: {u\'__limit\': [u\'37\'], u\'tags__tags\'
  408. : [u\'delete\'], u\'__start\': [u\'0\'], u\'__page\': [u\'1\'], u\'_dc\': [u\'1334563815789\'], u\'__format\': [u\'ext\']}>,\nPOST:<QueryDict: {}>,\nCOOKIES:{\'csrftoken\': \'be8b13c68edc98f74583ad21ed92a08e\',\n \'sessionid\': \'8999325
  409. 77f4c961b279b7975c3f3c51f\'},\nMETA:{\'HTTP_ACCEPT\': \'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8\',\n \'HTTP_ACCEPT_LANGUAGE\': \'ru-ru,ru;q=0.8,en-us;q=0.5,en;q=0.3\',\n \'HTTP_CONNECTION\': \'close\',\n \'HTTP_CO
  410. OKIE\': \'sessionid=899932577f4c961b279b7975c3f3c51f; csrftoken=be8b13c68edc98f74583ad21ed92a08e\',\n \'HTTP_HOST\': \'127.0.0.1:8000\',\n \'HTTP_REFERER\': \'http://192.168.10.152/main/desktop/\',\n \'HTTP_USER_AGENT\': \'Mozilla/5.0 (W
  411. indows NT 6.1; rv:11.0) Gecko/20100101 Firefox/11.0\',\n \'HTTP_X_REQUESTED_WITH\': \'XMLHttpRequest\',\n \'PATH_INFO\': u\'/vc/vc/\',\n \'QUERY_STRING\': \'_dc=1334563815789&tags__tags=delete&__format=ext&__page=1&__start=0&__limit=37\'
  412. ,\n \'REMOTE_ADDR\': \'127.0.0.1\',\n \'REQUEST_METHOD\': \'GET\',\n \'SCRIPT_NAME\': u\'\',\n \'SERVER_NAME\': \'127.0.0.1\',\n \'SERVER_PORT\': \'8000\',\n \'SERVER_PROTOCOL\': \'HTTP/1.0\',\n \'wsgi.errors\': <open file \'/dev/null\',
  413. mode \'a+\' at 0x29227128>,\n \'wsgi.input\': <_io.BytesIO object at 0x2a81420c>,\n \'wsgi.multiprocess\': True,\n \'wsgi.multithread\': False,\n \'wsgi.run_once\': False,\n \'wsgi.url_scheme\': \'http\',\n \'wsgi.version\': (1, 0)}>\n
  414. q = {}\n start = u\'0\'\n limit = u\'37\'\n query = None\n ew = [\'\\n (id IN (\\n SELECT object_id\\n FROM
  415. tagging_taggeditem\\n WHERE\\n content_type_id = 84\\n AND tag_id in (7)\\n GROUP BY object_id\\n HAVING COUNT(object_id) = 1\\n
  416. ))\']\n total = 48\n data = []\n------------------------------------------------------------------------\nFile: /usr/local/noc/lib/app/extmodelapplication.py (Line: 300)\nFunction: api_list\n 293
  417. if None in q:\n 294 q[None] += [s]\n 295 else:\n 296 q[None] = [s]\n 297 \n 298 @view(method=["GET"], url="^$", access="read", api=True)\n 299 def api_list
  418. (self, request):\n 300 ==> return self.list_data(request, self.instance_to_dict)\n 301 \n 302 @view(method=["GET"], url=r"^lookup/$", access="lookup", api=True)\n 303 def api_lookup(self, request):\n 304
  419. return self.list_data(request, self.instance_to_lookup)\n 305 \n 306 @view(method=["POST"], url="^$", access="create", api=True)\nVariables:\n self = <noc.vc.apps.vc.views.VCApplication object at
  420. 0x2adf088c>\n request = <WSGIRequest\nGET:<QueryDict: {u\'__limit\': [u\'37\'], u\'tags__tags\': [u\'delete\'], u\'__start\': [u\'0\'], u\'__page\': [u\'1\'], u\'_dc\': [u\'1334563815789\'], u\'__format\': [u\'ext\']}>,\nPOST
  421. :<QueryDict: {}>,\nCOOKIES:{\'csrftoken\': \'be8b13c68edc98f74583ad21ed92a08e\',\n \'sessionid\': \'899932577f4c961b279b7975c3f3c51f\'},\nMETA:{\'HTTP_ACCEPT\': \'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8\',\n \'HTT
  422. P_ACCEPT_LANGUAGE\': \'ru-ru,ru;q=0.8,en-us;q=0.5,en;q=0.3\',\n \'HTTP_CONNECTION\': \'close\',\n \'HTTP_COOKIE\': \'sessionid=899932577f4c961b279b7975c3f3c51f; csrftoken=be8b13c68edc98f74583ad21ed92a08e\',\n \'HTTP_HOST\': \'127.0.0.1:8
  423. 000\',\n \'HTTP_REFERER\': \'http://192.168.10.152/main/desktop/\',\n \'HTTP_USER_AGENT\': \'Mozilla/5.0 (Windows NT 6.1; rv:11.0) Gecko/20100101 Firefox/11.0\',\n \'HTTP_X_REQUESTED_WITH\': \'XMLHttpRequest\',\n \'PATH_INFO\': u\'/vc/vc
  424. /\',\n \'QUERY_STRING\': \'_dc=1334563815789&tags__tags=delete&__format=ext&__page=1&__start=0&__limit=37\',\n \'REMOTE_ADDR\': \'127.0.0.1\',\n \'REQUEST_METHOD\': \'GET\',\n \'SCRIPT_NAME\': u\'\',\n \'SERVER_NAME\': \'127.0.0.1\',\n \
  425. 'SERVER_PORT\': \'8000\',\n \'SERVER_PROTOCOL\': \'HTTP/1.0\',\n \'wsgi.errors\': <open file \'/dev/null\', mode \'a+\' at 0x29227128>,\n \'wsgi.input\': <_io.BytesIO object at 0x2a81420c>,\n \'wsgi.multiprocess\': True,\n \'wsgi.multith
  426. read\': False,\n \'wsgi.run_once\': False,\n \'wsgi.url_scheme\': \'http\',\n \'wsgi.version\': (1, 0)}>\n------------------------------------------------------------------------\nFile: /usr/local/noc/lib/app/site.py (Line: 225)\nFunctio
  427. n: inner\n 218 for k, v in request.POST.lists())\n 219 elif request.method == "GET":\n 220 a = dict((k, v[0] if len(v) == 1 else v)\n 221
  428. for k, v in request.GET.lists())\n 222 logging.debug("API %s %s %s" % (request.method,\n 223 request.path, a))\n 224
  429. # Call handler\n 225 ==> r = v(request, *args, **kwargs)\n 226 # Dump SQL statements\n 227 if self.log_sql_statements:\n 228 from dja
  430. ngo.db import connections\n 229 tsc = 0\n 230 sc = defaultdict(int)\n 231 for conn in connections.all():\nVariables:\n a = {u\'__limit\': u\'37\
  431. ', u\'tags__tags\': u\'delete\', u\'__start\': u\'0\', u\'__page\': u\'1\', u\'_dc\': u\'1334563815789\', u\'__format\': u\'ext\'}\n args = ()\n view_map = {\'POST\': <bound method VCApplication.api_create of <n
  432. oc.vc.apps.vc.views.VCApplication object at 0x2adf088c>>, \'GET\': <bound method VCApplication.api_list of <noc.vc.apps.vc.views.VCApplication object at 0x2adf088c>>}\n Form = <class \'django.forms.forms.Form\'>\n Di
  433. ctParameter = <class \'noc.sa.interfaces.base.DictParameter\'>\n self = <noc.lib.app.site.Site object at 0x29b6298c>\n v = <bound method VCApplication.api_list of <noc.vc.apps.vc.views.VCApplication objec
  434. t at 0x2adf088c>>\n request = <WSGIRequest\nGET:<QueryDict: {u\'__limit\': [u\'37\'], u\'tags__tags\': [u\'delete\'], u\'__start\': [u\'0\'], u\'__page\': [u\'1\'], u\'_dc\': [u\'1334563815789\'], u\'__format\': [u\'ext\']}>,
  435. \nPOST:<QueryDict: {}>,\nCOOKIES:{\'csrftoken\': \'be8b13c68edc98f74583ad21ed92a08e\',\n \'sessionid\': \'899932577f4c961b279b7975c3f3c51f\'},\nMETA:{\'HTTP_ACCEPT\': \'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8\',\n
  436. \'HTTP_ACCEPT_LANGUAGE\': \'ru-ru,ru;q=0.8,en-us;q=0.5,en;q=0.3\',\n \'HTTP_CONNECTION\': \'close\',\n \'HTTP_COOKIE\': \'sessionid=899932577f4c961b279b7975c3f3c51f; csrftoken=be8b13c68edc98f74583ad21ed92a08e\',\n \'HTTP_HOST\': \'127.0
  437. .0.1:8000\',\n \'HTTP_REFERER\': \'http://192.168.10.152/main/desktop/\',\n \'HTTP_USER_AGENT\': \'Mozilla/5.0 (Windows NT 6.1; rv:11.0) Gecko/20100101 Firefox/11.0\',\n \'HTTP_X_REQUESTED_WITH\': \'XMLHttpRequest\',\n \'PATH_INFO\': u\'
  438. /vc/vc/\',\n \'QUERY_STRING\': \'_dc=1334563815789&tags__tags=delete&__format=ext&__page=1&__start=0&__limit=37\',\n \'REMOTE_ADDR\': \'127.0.0.1\',\n \'REQUEST_METHOD\': \'GET\',\n \'SCRIPT_NAME\': u\'\',\n \'SERVER_NAME\': \'127.0.0.1\
  439. ',\n \'SERVER_PORT\': \'8000\',\n \'SERVER_PROTOCOL\': \'HTTP/1.0\',\n \'wsgi.errors\': <open file \'/dev/null\', mode \'a+\' at 0x29227128>,\n \'wsgi.input\': <_io.BytesIO object at 0x2a81420c>,\n \'wsgi.multiprocess\': True,\n \'wsgi.m
  440. ultithread\': False,\n \'wsgi.run_once\': False,\n \'wsgi.url_scheme\': \'http\',\n \'wsgi.version\': (1, 0)}>\n InterfaceTypeError = <class \'noc.sa.interfaces.base.InterfaceTypeError\'>\n to_log_api_call = True\n kwar
  441. gs = {}\n PermissionDenied = <class \'noc.lib.app.access.PermissionDenied\'>\n app = <noc.vc.apps.vc.views.VCApplication object at 0x2adf088c>\n------------------------------------------------------------------------\n
  442. END OF TRACEBACK'
  443. app = <noc.vc.apps.vc.views.VCApplication object at 0x2adf088c>
  444. ------------------------------------------------------------------------
  445. END OF TRACEBACK
  446. 2012-04-16 12:10:16,728 500 GET /vc/vc/?_dc=1334563815789&tags__tags=delete&__format=ext&__page=1&__start=0&__limit=37 (127.0.0.1) 93.38ms
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!