API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 10th, 2013
62
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 37.06 KB | None | 0 0
raw download clone embed print report
  1. 2013-06-10 15:31:29,776 API POST /dns/dnszone/1/records/ {'content': '10.255.255.253', 'name': 'noc', 'tags': '', 'priority': None, 'ttl': None, 'type': 'A', 'id': 0}
  2. 2013-06-10 15:31:29,918 UNHANDLED EXCEPTION (2013-06-10 15:31:29.889645)
  3. Working directory: /opt/noc
  4. <class 'django.db.utils.DatabaseError'>
  5. array value must start with "{" or dimension information
  6. LINE 1: ..."."zone_id" = 1 AND "dns_dnszonerecord"."tags" = E'' AND "...
  7. ^
  8.  
  9. START OF TRACEBACK
  10. ------------------------------------------------------------------------
  11. File: /opt/noc/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py (Line: 52)
  12. Function: execute
  13. 45 """
  14. 46
  15. 47 def __init__(self, cursor):
  16. 48 self.cursor = cursor
  17. 49
  18. 50 def execute(self, query, args=None):
  19. 51 try:
  20. 52 ==> return self.cursor.execute(query, args)
  21. 53 except Database.IntegrityError, e:
  22. 54 raise utils.IntegrityError, utils.IntegrityError(*tuple(e)), sys.exc_info()[2]
  23. 55 except Database.DatabaseError, e:
  24. 56 raise utils.DatabaseError, utils.DatabaseError(*tuple(e)), sys.exc_info()[2]
  25. 57
  26. 58 def executemany(self, query, args):
  27. Variables:
  28. query =
  29. 'SELECT "dns_dnszonerecord"."id", "dns_dnszonerecord"."zone_id", "dns_dnszonerecord"."name", "dns_dnszonerecord"."ttl", "dns_dnszonerecord"."type", "dns_dnszonerecord"."priority", "dns_dnszonerecord"."content", "dns_dnszonerecord"."tags" FROM "dns_dnszonerecord" WHERE ("dns_dnszonerecord"."content" = %s AND "dns_dnszonerecord"."name" = %s AND "dns_dnszonerecord"."zone_id" = %s AND "dns_dnszonerecord"."tags" = %s AND "dns_dnszonerecord"."priority" IS NULL AND "dns_dnszonerecord"."ttl" IS NULL AND "dns_dnszonerecord"."type" = %s )'
  30. self =
  31. <django.db.backends.postgresql_psycopg2.base.CursorWrapper object at 0x80f0c4d90>
  32. args = ('10.255.255.253', 'noc', 1, '', 'A')
  33. e =
  34. DataError('array value must start with "{" or dimension information\nLINE 1: ..."."zone_id" = 1 AND "dns_dnszonerecord"."tags" = E\'\' AND "...\n ^\n',)
  35. ------------------------------------------------------------------------
  36. File: /opt/noc/lib/python2.7/site-packages/django/db/backends/util.py (Line: 40)
  37. Function: execute
  38. 33
  39. 34 class CursorDebugWrapper(CursorWrapper):
  40. 35
  41. 36 def execute(self, sql, params=()):
  42. 37 self.set_dirty()
  43. 38 start = time()
  44. 39 try:
  45. 40 ==> return self.cursor.execute(sql, params)
  46. 41 finally:
  47. 42 stop = time()
  48. 43 duration = stop - start
  49. 44 sql = self.db.ops.last_executed_query(self.cursor, sql, params)
  50. 45 self.db.queries.append({
  51. 46 'sql': sql,
  52. Variables:
  53. self = <django.db.backends.util.CursorDebugWrapper object at 0x80f0c8190>
  54. stop = 1370867489.817686
  55. start = 1370867489.781857
  56. params = ('10.255.255.253', 'noc', 1, '', 'A')
  57. sql =
  58. 'SELECT "dns_dnszonerecord"."id", "dns_dnszonerecord"."zone_id", "dns_dnszonerecord"."name", "dns_dnszonerecord"."ttl", "dns_dnszonerecord"."type", "dns_dnszonerecord"."priority", "dns_dnszonerecord"."content", "dns_dnszonerecord"."tags" FROM "dns_dnszonerecord" WHERE ("dns_dnszonerecord"."content" = E\'10.255.255.253\' AND "dns_dnszonerecord"."name" = E\'noc\' AND "dns_dnszonerecord"."zone_id" = 1 AND "dns_dnszonerecord"."tags" = E\'\' AND "dns_dnszonerecord"."priority" IS NULL AND "dns_dnszonerecord"."ttl" IS NULL AND "dns_dnszonerecord"."type" = E\'A\' )'
  59. duration = 0.03582906723022461
  60. ------------------------------------------------------------------------
  61. File: /opt/noc/lib/python2.7/site-packages/django/db/models/sql/compiler.py (Line: 818)
  62. Function: execute_sql
  63. 811 except EmptyResultSet:
  64. 812 if result_type == MULTI:
  65. 813 return empty_iter()
  66. 814 else:
  67. 815 return
  68. 816
  69. 817 cursor = self.connection.cursor()
  70. 818 ==> cursor.execute(sql, params)
  71. 819
  72. 820 if not result_type:
  73. 821 return cursor
  74. 822 if result_type == SINGLE:
  75. 823 if self.query.ordering_aliases:
  76. 824 return cursor.fetchone()[:-len(self.query.ordering_aliases)]
  77. Variables:
  78. cursor = <django.db.backends.util.CursorDebugWrapper object at 0x80f0c8190>
  79. self = <django.db.models.sql.compiler.SQLCompiler object at 0x80f0c4e90>
  80. params = ('10.255.255.253', 'noc', 1, '', 'A')
  81. result_type = 'multi'
  82. sql =
  83. 'SELECT "dns_dnszonerecord"."id", "dns_dnszonerecord"."zone_id", "dns_dnszonerecord"."name", "dns_dnszonerecord"."ttl", "dns_dnszonerecord"."type", "dns_dnszonerecord"."priority", "dns_dnszonerecord"."content", "dns_dnszonerecord"."tags" FROM "dns_dnszonerecord" WHERE ("dns_dnszonerecord"."content" = %s AND "dns_dnszonerecord"."name" = %s AND "dns_dnszonerecord"."zone_id" = %s AND "dns_dnszonerecord"."tags" = %s AND "dns_dnszonerecord"."priority" IS NULL AND "dns_dnszonerecord"."ttl" IS NULL AND "dns_dnszonerecord"."type" = %s )'
  84. ------------------------------------------------------------------------
  85. File: /opt/noc/lib/python2.7/site-packages/django/db/models/sql/compiler.py (Line: 763)
  86. Function: results_iter
  87. 756 fields = None
  88. 757 has_aggregate_select = bool(self.query.aggregate_select)
  89. 758 # Set transaction dirty if we're using SELECT FOR UPDATE to ensure
  90. 759 # a subsequent commit/rollback is executed, so any database locks
  91. 760 # are released.
  92. 761 if self.query.select_for_update and transaction.is_managed(self.using):
  93. 762 transaction.set_dirty(self.using)
  94. 763 ==> for rows in self.execute_sql(MULTI):
  95. 764 for row in rows:
  96. 765 if resolve_columns:
  97. 766 if fields is None:
  98. 767 # We only set this up here because
  99. 768 # related_select_fields isn't populated until
  100. 769 # execute_sql() has been called.
  101. Variables:
  102. fields = None
  103. self = <django.db.models.sql.compiler.SQLCompiler object at 0x80f0c4e90>
  104. has_aggregate_select = False
  105. resolve_columns = False
  106. ------------------------------------------------------------------------
  107. File: /opt/noc/lib/python2.7/site-packages/django/db/models/query.py (Line: 291)
  108. Function: iterator
  109. 284 # Cache db and model outside the loop
  110. 285 db = self.db
  111. 286 model = self.model
  112. 287 compiler = self.query.get_compiler(using=db)
  113. 288 if fill_cache:
  114. 289 klass_info = get_klass_info(model, max_depth=max_depth,
  115. 290 requested=requested, only_load=only_load)
  116. 291 ==> for row in compiler.results_iter():
  117. 292 if fill_cache:
  118. 293 obj, _ = get_cached_row(row, index_start, db, klass_info,
  119. 294 offset=len(aggregate_select))
  120. 295 else:
  121. 296 if skip:
  122. 297 row_data = row[index_start:aggregate_start]
  123. Variables:
  124. requested = None
  125. fill_cache = False
  126. aggregate_select = []
  127. fields =
  128. [<django.db.models.fields.AutoField: id>,
  129. <django.db.models.fields.related.ForeignKey: zone>,
  130. <django.db.models.fields.CharField: name>,
  131. <django.db.models.fields.IntegerField: ttl>,
  132. <django.db.models.fields.CharField: type>,
  133. <django.db.models.fields.IntegerField: priority>,
  134. <django.db.models.fields.CharField: content>,
  135. <noc.lib.fields.TagsField: tags>]
  136. skip = None
  137. self = repr() failed
  138. load_fields = []
  139. db = 'default'
  140. index_start = 0
  141. extra_select = []
  142. aggregate_start = 8
  143. model = <class 'noc.dns.models.dnszonerecord.DNSZoneRecord'>
  144. only_load = {}
  145. max_depth = 5
  146. compiler = <django.db.models.sql.compiler.SQLCompiler object at 0x80f0c4e90>
  147. ------------------------------------------------------------------------
  148. File: /opt/noc/lib/python2.7/site-packages/django/db/models/query.py (Line: 85)
  149. Function: __len__
  150. 78 # Since __len__ is called quite frequently (for example, as part of
  151. 79 # list(qs), we make some effort here to be as efficient as possible
  152. 80 # whilst not messing up any existing iterators against the QuerySet.
  153. 81 if self._result_cache is None:
  154. 82 if self._iter:
  155. 83 self._result_cache = list(self._iter)
  156. 84 else:
  157. 85 ==> self._result_cache = list(self.iterator())
  158. 86 elif self._iter:
  159. 87 self._result_cache.extend(self._iter)
  160. 88 if self._prefetch_related_lookups and not self._prefetch_done:
  161. 89 self._prefetch_related_objects()
  162. 90 return len(self._result_cache)
  163. 91
  164. Variables:
  165. self = repr() failed
  166. ------------------------------------------------------------------------
  167. File: /opt/noc/lib/python2.7/site-packages/django/db/models/query.py (Line: 361)
  168. Function: get
  169. 354 """
  170. 355 Performs the query and returns a single object matching the given
  171. 356 keyword arguments.
  172. 357 """
  173. 358 clone = self.filter(*args, **kwargs)
  174. 359 if self.query.can_filter():
  175. 360 clone = clone.order_by()
  176. 361 ==> num = len(clone)
  177. 362 if num == 1:
  178. 363 return clone._result_cache[0]
  179. 364 if not num:
  180. 365 raise self.model.DoesNotExist("%s matching query does not exist."
  181. 366 % self.model._meta.object_name)
  182. 367 raise self.model.MultipleObjectsReturned("get() returned more than one %s -- it returned %s! Lookup parameters were %s"
  183. Variables:
  184. clone = repr() failed
  185. args = ()
  186. self = repr() failed
  187. kwargs =
  188. {'content': '10.255.255.253',
  189. 'name': 'noc',
  190. 'priority': None,
  191. 'tags': '',
  192. 'ttl': None,
  193. 'type': 'A',
  194. 'zone': <DNSZone: mcd.net.ua>}
  195. ------------------------------------------------------------------------
  196. File: /opt/noc/lib/app/modelinline.py (Line: 366)
  197. Function: api_create
  198. 359 try:
  199. 360 # Exclude callable values from query
  200. 361 # (Django raises exception on pyRules)
  201. 362 # @todo: Check unique fields only?
  202. 363 qattrs = dict((k, attrs[k])
  203. 364 for k in attrs if not callable(attrs[k]))
  204. 365 # Check for duplicates
  205. 366 ==> self.queryset(request).get(**qattrs)
  206. 367 return self.app.render_json(
  207. 368 {
  208. 369 "status": False,
  209. 370 "message": "Duplicated record"
  210. 371 },
  211. 372 status=self.CONFLICT)
  212. Variables:
  213. qattrs =
  214. {'content': '10.255.255.253',
  215. 'name': 'noc',
  216. 'priority': None,
  217. 'tags': '',
  218. 'ttl': None,
  219. 'type': 'A',
  220. 'zone': <DNSZone: mcd.net.ua>}
  221. self = <noc.lib.app.modelinline.ModelInline object at 0x80f245fd0>
  222. request =
  223. <WSGIRequest
  224. path:/dns/dnszone/1/records/,
  225. GET:<QueryDict: {u'_dc': [u'1370867068721'], u'__format': [u'ext']}>,
  226. POST:<QueryDict: {u'{"id":0,"name":"noc","ttl":null,"priority":null,"type":"A","content":"10.255.255.253","tags":""}': [u'']}>,
  227. COOKIES:{'IV': 'QL3j0DJ%2BVxj2DLT6j%2Bp0tqwWxkiEl0BI6iU%2BK1Dxj6g%3D',
  228. 'Key': 'mg%2FpCJ31oIG%2B1%2BqOiJuMUXywqpS2p%2BPV7dQBR8dcySY%3D',
  229. 'PHPSESSID': '7613c322a5e7ac22bca1bb869e5e0d31',
  230. 'csrftoken': '4b6vE1ZFHEP78vgvbgVvtROdGcqVDox7',
  231. 'sessionid': 'e29cda43485e524eb74db8eeaa05abfc'},
  232. META:{'CONTENT_LENGTH': '96',
  233. 'CONTENT_TYPE': 'application/json',
  234. 'HTTP_ACCEPT': '*/*',
  235. 'HTTP_ACCEPT_CHARSET': 'windows-1251,utf-8;q=0.7,*;q=0.3',
  236. 'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch',
  237. 'HTTP_ACCEPT_LANGUAGE': 'ru-RU,ru;q=0.8,en-US;q=0.6,en;q=0.4',
  238. 'HTTP_AUTHORIZATION': 'Basic emFpa2E6KEIwNjBESEVF',
  239. 'HTTP_CONNECTION': 'Keep-Alive',
  240. 'HTTP_COOKIE': 'PHPSESSID=7613c322a5e7ac22bca1bb869e5e0d31; Key=mg%2FpCJ31oIG%2B1%2BqOiJuMUXywqpS2p%2BPV7dQBR8dcySY%3D; IV=QL3j0DJ%2BVxj2DLT6j%2Bp0tqwWxkiEl0BI6iU%2BK1Dxj6g%3D; sessionid=e29cda43485e524eb74db8eeaa05abfc; csrftoken=4b6vE1ZFHEP78vgvbgVvtROdGcqVDox7',
  241. 'HTTP_HOST': 'localhost:8000',
  242. 'HTTP_ORIGIN': 'https://noc.mcd.net.ua',
  243. 'HTTP_REFERER': 'https://noc.mcd.net.ua/main/desktop/',
  244. 'HTTP_REMOTE_USER': 'zaika',
  245. 'HTTP_USER_AGENT': 'Mozilla/5.0 (X11; FreeBSD amd64) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.97 Safari/537.22',
  246. 'HTTP_X_FORWARDED_FOR': '193.254.232.25',
  247. 'HTTP_X_FORWARDED_HOST': 'noc.mcd.net.ua',
  248. 'HTTP_X_FORWARDED_SERVER': 'noc.mcd.net.ua',
  249. 'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest',
  250. 'PATH_INFO': u'/dns/dnszone/1/records/',
  251. 'QUERY_STRING': '_dc=1370867068721&__format=ext',
  252. 'REMOTE_ADDR': '127.0.0.1',
  253. 'REQUEST_METHOD': 'POST',
  254. 'SCRIPT_NAME': u'',
  255. 'SERVER_NAME': 'localhost',
  256. 'SERVER_PORT': '8000',
  257. 'SERVER_PROTOCOL': 'HTTP/1.1',
  258. 'wsgi.errors': <open file '/dev/null', mode 'a+' at 0x8074b5030>,
  259. 'wsgi.input': <_io.BytesIO object at 0x80f05e770>,
  260. 'wsgi.multiprocess': True,
  261. 'wsgi.multithread': False,
  262. 'wsgi.run_once': False,
  263. 'wsgi.url_scheme': 'http',
  264. 'wsgi.version': (1, 0)}>
  265. attrs =
  266. {'content': '10.255.255.253',
  267. 'name': 'noc',
  268. 'priority': None,
  269. 'tags': '',
  270. 'ttl': None,
  271. 'type': 'A',
  272. 'zone': <DNSZone: mcd.net.ua>}
  273. parent = <DNSZone: mcd.net.ua>
  274. ------------------------------------------------------------------------
  275. File: /opt/noc/lib/app/site.py (Line: 232)
  276. Function: inner
  277. 225 for k, v in request.POST.lists())
  278. 226 elif request.method == "GET":
  279. 227 a = dict((k, v[0] if len(v) == 1 else v)
  280. 228 for k, v in request.GET.lists())
  281. 229 logging.debug("API %s %s %s" % (request.method,
  282. 230 request.path, a))
  283. 231 # Call handler
  284. 232 ==> r = v(request, *args, **kwargs)
  285. 233 # Dump SQL statements
  286. 234 if self.log_sql_statements:
  287. 235 from django.db import connections
  288. 236 tsc = 0
  289. 237 sc = defaultdict(int)
  290. 238 for conn in connections.all():
  291. Variables:
  292. a =
  293. {'content': '10.255.255.253',
  294. 'id': 0,
  295. 'name': 'noc',
  296. 'priority': None,
  297. 'tags': '',
  298. 'ttl': None,
  299. 'type': 'A'}
  300. v = <functools.partial object at 0x80f249520>
  301. view_map =
  302. {'GET': <functools.partial object at 0x80f2494c8>,
  303. 'POST': <functools.partial object at 0x80f249520>}
  304. Form = <class 'django.forms.forms.Form'>
  305. args = ()
  306. DictParameter = <class 'noc.sa.interfaces.base.DictParameter'>
  307. self = <noc.lib.app.site.Site object at 0x80b394390>
  308. to_log_api_call = True
  309. request =
  310. <WSGIRequest
  311. path:/dns/dnszone/1/records/,
  312. GET:<QueryDict: {u'_dc': [u'1370867068721'], u'__format': [u'ext']}>,
  313. POST:<QueryDict: {u'{"id":0,"name":"noc","ttl":null,"priority":null,"type":"A","content":"10.255.255.253","tags":""}': [u'']}>,
  314. COOKIES:{'IV': 'QL3j0DJ%2BVxj2DLT6j%2Bp0tqwWxkiEl0BI6iU%2BK1Dxj6g%3D',
  315. 'Key': 'mg%2FpCJ31oIG%2B1%2BqOiJuMUXywqpS2p%2BPV7dQBR8dcySY%3D',
  316. 'PHPSESSID': '7613c322a5e7ac22bca1bb869e5e0d31',
  317. 'csrftoken': '4b6vE1ZFHEP78vgvbgVvtROdGcqVDox7',
  318. 'sessionid': 'e29cda43485e524eb74db8eeaa05abfc'},
  319. META:{'CONTENT_LENGTH': '96',
  320. 'CONTENT_TYPE': 'application/json',
  321. 'HTTP_ACCEPT': '*/*',
  322. 'HTTP_ACCEPT_CHARSET': 'windows-1251,utf-8;q=0.7,*;q=0.3',
  323. 'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch',
  324. 'HTTP_ACCEPT_LANGUAGE': 'ru-RU,ru;q=0.8,en-US;q=0.6,en;q=0.4',
  325. 'HTTP_AUTHORIZATION': 'Basic emFpa2E6KEIwNjBESEVF',
  326. 'HTTP_CONNECTION': 'Keep-Alive',
  327. 'HTTP_COOKIE': 'PHPSESSID=7613c322a5e7ac22bca1bb869e5e0d31; Key=mg%2FpCJ31oIG%2B1%2BqOiJuMUXywqpS2p%2BPV7dQBR8dcySY%3D; IV=QL3j0DJ%2BVxj2DLT6j%2Bp0tqwWxkiEl0BI6iU%2BK1Dxj6g%3D; sessionid=e29cda43485e524eb74db8eeaa05abfc; csrftoken=4b6vE1ZFHEP78vgvbgVvtROdGcqVDox7',
  328. 'HTTP_HOST': 'localhost:8000',
  329. 'HTTP_ORIGIN': 'https://noc.mcd.net.ua',
  330. 'HTTP_REFERER': 'https://noc.mcd.net.ua/main/desktop/',
  331. 'HTTP_REMOTE_USER': 'zaika',
  332. 'HTTP_USER_AGENT': 'Mozilla/5.0 (X11; FreeBSD amd64) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.97 Safari/537.22',
  333. 'HTTP_X_FORWARDED_FOR': '193.254.232.25',
  334. 'HTTP_X_FORWARDED_HOST': 'noc.mcd.net.ua',
  335. 'HTTP_X_FORWARDED_SERVER': 'noc.mcd.net.ua',
  336. 'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest',
  337. 'PATH_INFO': u'/dns/dnszone/1/records/',
  338. 'QUERY_STRING': '_dc=1370867068721&__format=ext',
  339. 'REMOTE_ADDR': '127.0.0.1',
  340. 'REQUEST_METHOD': 'POST',
  341. 'SCRIPT_NAME': u'',
  342. 'SERVER_NAME': 'localhost',
  343. 'SERVER_PORT': '8000',
  344. 'SERVER_PROTOCOL': 'HTTP/1.1',
  345. 'wsgi.errors': <open file '/dev/null', mode 'a+' at 0x8074b5030>,
  346. 'wsgi.input': <_io.BytesIO object at 0x80f05e770>,
  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. PermissionDenied = <class 'noc.lib.app.access.PermissionDenied'>
  354. kwargs = {'parent': u'1'}
  355. tb =
  356. u'UNHANDLED EXCEPTION (2013-06-10 15:31:29.817736)\nWorking directory: /opt/noc\n<class \'django.db.utils.DatabaseError\'>\narray value must start with "{" or dimension information\nLINE 1: ..."."zone_id" = 1 AND "dns_dnszonerecord"."tags" = E\'\' AND "...\n ^\n\nSTART OF TRACEBACK\n------------------------------------------------------------------------\nFile: /opt/noc/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py (Line: 52)\nFunction: execute\n 45 """\n 46 \n 47 def __init__(self, cursor):\n 48 self.cursor = cursor\n 49 \n 50 def execute(self, query, args=None):\n 51 try:\n 52 ==> return self.cursor.execute(query, args)\n 53 except Database.IntegrityError, e:\n 54 raise utils.IntegrityError, utils.IntegrityError(*tuple(e)), sys.exc_info()[2]\n 55 except Database.DatabaseError, e:\n 56 raise utils.DatabaseError, utils.DatabaseError(*tuple(e)), sys.exc_info()[2]\n 57 \n 58 def executemany(self, query, args):\nVariables:\n query = \n\'SELECT "dns_dnszonerecord"."id", "dns_dnszonerecord"."zone_id", "dns_dnszonerecord"."name", "dns_dnszonerecord"."ttl", "dns_dnszonerecord"."type", "dns_dnszonerecord"."priority", "dns_dnszonerecord"."content", "dns_dnszonerecord"."tags" FROM "dns_dnszonerecord" WHERE ("dns_dnszonerecord"."content" = %s AND "dns_dnszonerecord"."name" = %s AND "dns_dnszonerecord"."zone_id" = %s AND "dns_dnszonerecord"."tags" = %s AND "dns_dnszonerecord"."priority" IS NULL AND "dns_dnszonerecord"."ttl" IS NULL AND "dns_dnszonerecord"."type" = %s )\'\n self = \n<django.db.backends.postgresql_psycopg2.base.CursorWrapper object at 0x80f0c4d90>\n args = (\'10.255.255.253\', \'noc\', 1, \'\', \'A\')\n e = \nDataError(\'array value must start with "{" or dimension information\\nLINE 1: ..."."zone_id" = 1 AND "dns_dnszonerecord"."tags" = E\\\'\\\' AND "...\\n ^\\n\',)\n------------------------------------------------------------------------\nFile: /opt/noc/lib/python2.7/site-packages/django/db/backends/util.py (Line: 40)\nFunction: execute\n 33 \n 34 class CursorDebugWrapper(CursorWrapper):\n 35 \n 36 def execute(self, sql, params=()):\n 37 self.set_dirty()\n 38 start = time()\n 39 try:\n 40 ==> return self.cursor.execute(sql, params)\n 41 finally:\n 42 stop = time()\n 43 duration = stop - start\n 44 sql = self.db.ops.last_executed_query(self.cursor, sql, params)\n 45 self.db.queries.append({\n 46 \'sql\': sql,\nVariables:\n self = <django.db.backends.util.CursorDebugWrapper object at 0x80f0c8190>\n stop = 1370867489.817686\n start = 1370867489.781857\n params = (\'10.255.255.253\', \'noc\', 1, \'\', \'A\')\n sql = \n\'SELECT "dns_dnszonerecord"."id", "dns_dnszonerecord"."zone_id", "dns_dnszonerecord"."name", "dns_dnszonerecord"."ttl", "dns_dnszonerecord"."type", "dns_dnszonerecord"."priority", "dns_dnszonerecord"."content", "dns_dnszonerecord"."tags" FROM "dns_dnszonerecord" WHERE ("dns_dnszonerecord"."content" = E\\\'10.255.255.253\\\' AND "dns_dnszonerecord"."name" = E\\\'noc\\\' AND "dns_dnszonerecord"."zone_id" = 1 AND "dns_dnszonerecord"."tags" = E\\\'\\\' AND "dns_dnszonerecord"."priority" IS NULL AND "dns_dnszonerecord"."ttl" IS NULL AND "dns_dnszonerecord"."type" = E\\\'A\\\' )\'\n duration = 0.03582906723022461\n------------------------------------------------------------------------\nFile: /opt/noc/lib/python2.7/site-packages/django/db/models/sql/compiler.py (Line: 818)\nFunction: execute_sql\n 811 except EmptyResultSet:\n 812 if result_type == MULTI:\n 813 return empty_iter()\n 814 else:\n 815 return\n 816 \n 817 cursor = self.connection.cursor()\n 818 ==> cursor.execute(sql, params)\n 819 \n 820 if not result_type:\n 821 return cursor\n 822 if result_type == SINGLE:\n 823 if self.query.ordering_aliases:\n 824 return cursor.fetchone()[:-len(self.query.ordering_aliases)]\nVariables:\n cursor = <django.db.backends.util.CursorDebugWrapper object at 0x80f0c8190>\n self = <django.db.models.sql.compiler.SQLCompiler object at 0x80f0c4e90>\n params = (\'10.255.255.253\', \'noc\', 1, \'\', \'A\')\n result_type = \'multi\'\n sql = \n\'SELECT "dns_dnszonerecord"."id", "dns_dnszonerecord"."zone_id", "dns_dnszonerecord"."name", "dns_dnszonerecord"."ttl", "dns_dnszonerecord"."type", "dns_dnszonerecord"."priority", "dns_dnszonerecord"."content", "dns_dnszonerecord"."tags" FROM "dns_dnszonerecord" WHERE ("dns_dnszonerecord"."content" = %s AND "dns_dnszonerecord"."name" = %s AND "dns_dnszonerecord"."zone_id" = %s AND "dns_dnszonerecord"."tags" = %s AND "dns_dnszonerecord"."priority" IS NULL AND "dns_dnszonerecord"."ttl" IS NULL AND "dns_dnszonerecord"."type" = %s )\'\n------------------------------------------------------------------------\nFile: /opt/noc/lib/python2.7/site-packages/django/db/models/sql/compiler.py (Line: 763)\nFunction: results_iter\n 756 fields = None\n 757 has_aggregate_select = bool(self.query.aggregate_select)\n 758 # Set transaction dirty if we\'re using SELECT FOR UPDATE to ensure\n 759 # a subsequent commit/rollback is executed, so any database locks\n 760 # are released.\n 761 if self.query.select_for_update and transaction.is_managed(self.using):\n 762 transaction.set_dirty(self.using)\n 763 ==> for rows in self.execute_sql(MULTI):\n 764 for row in rows:\n 765 if resolve_columns:\n 766 if fields is None:\n 767 # We only set this up here because\n 768 # related_select_fields isn\'t populated until\n 769 # execute_sql() has been called.\nVariables:\n fields = None\n self = <django.db.models.sql.compiler.SQLCompiler object at 0x80f0c4e90>\nhas_aggregate_select = False\n resolve_columns = False\n------------------------------------------------------------------------\nFile: /opt/noc/lib/python2.7/site-packages/django/db/models/query.py (Line: 291)\nFunction: iterator\n 284 # Cache db and model outside the loop\n 285 db = self.db\n 286 model = self.model\n 287 compiler = self.query.get_compiler(using=db)\n 288 if fill_cache:\n 289 klass_info = get_klass_info(model, max_depth=max_depth,\n 290 requested=requested, only_load=only_load)\n 291 ==> for row in compiler.results_iter():\n 292 if fill_cache:\n 293 obj, _ = get_cached_row(row, index_start, db, klass_info,\n 294 offset=len(aggregate_select))\n 295 else:\n 296 if skip:\n 297 row_data = row[index_start:aggregate_start]\nVariables:\n requested = None\n fill_cache = False\n aggregate_select = []\n fields = \n[<django.db.models.fields.AutoField: id>,\n <django.db.models.fields.related.ForeignKey: zone>,\n <django.db.models.fields.CharField: name>,\n <django.db.models.fields.IntegerField: ttl>,\n <django.db.models.fields.CharField: type>,\n <django.db.models.fields.IntegerField: priority>,\n <django.db.models.fields.CharField: content>,\n <noc.lib.fields.TagsField: tags>]\n skip = None\n self = repr() failed\n load_fields = []\n db = \'default\'\n index_start = 0\n extra_select = []\n aggregate_start = 8\n model = <class \'noc.dns.models.dnszonerecord.DNSZoneRecord\'>\n only_load = {}\n max_depth = 5\n compiler = <django.db.models.sql.compiler.SQLCompiler object at 0x80f0c4e90>\n------------------------------------------------------------------------\nFile: /opt/noc/lib/python2.7/site-packages/django/db/models/query.py (Line: 85)\nFunction: __len__\n 78 # Since __len__ is called quite frequently (for example, as part of\n 79 # list(qs), we make some effort here to be as efficient as possible\n 80 # whilst not messing up any existing iterators against the QuerySet.\n 81 if self._result_cache is None:\n 82 if self._iter:\n 83 self._result_cache = list(self._iter)\n 84 else:\n 85 ==> self._result_cache = list(self.iterator())\n 86 elif self._iter:\n 87 self._result_cache.extend(self._iter)\n 88 if self._prefetch_related_lookups and not self._prefetch_done:\n 89 self._prefetch_related_objects()\n 90 return len(self._result_cache)\n 91 \nVariables:\n self = repr() failed\n------------------------------------------------------------------------\nFile: /opt/noc/lib/python2.7/site-packages/django/db/models/query.py (Line: 361)\nFunction: get\n 354 """\n 355 Performs the query and returns a single object matching the given\n 356 keyword arguments.\n 357 """\n 358 clone = self.filter(*args, **kwargs)\n 359 if self.query.can_filter():\n 360 clone = clone.order_by()\n 361 ==> num = len(clone)\n 362 if num == 1:\n 363 return clone._result_cache[0]\n 364 if not num:\n 365 raise self.model.DoesNotExist("%s matching query does not exist."\n 366 % self.model._meta.object_name)\n 367 raise self.model.MultipleObjectsReturned("get() returned more than one %s -- it returned %s! Lookup parameters were %s"\nVariables:\n clone = repr() failed\n args = ()\n self = repr() failed\n kwargs = \n{\'content\': \'10.255.255.253\',\n \'name\': \'noc\',\n \'priority\': None,\n \'tags\': \'\',\n \'ttl\': None,\n \'type\': \'A\',\n \'zone\': <DNSZone: mcd.net.ua>}\n------------------------------------------------------------------------\nFile: /opt/noc/lib/app/modelinline.py (Line: 366)\nFunction: api_create\n 359 try:\n 360 # Exclude callable values from query\n 361 # (Django raises exception on pyRules)\n 362 # @todo: Check unique fields only?\n 363 qattrs = dict((k, attrs[k])\n 364 for k in attrs if not callable(attrs[k]))\n 365 # Check for duplicates\n 366 ==> self.queryset(request).get(**qattrs)\n 367 return self.app.render_json(\n 368 {\n 369 "status": False,\n 370 "message": "Duplicated record"\n 371 },\n 372 status=self.CONFLICT)\nVariables:\n qattrs = \n{\'content\': \'10.255.255.253\',\n \'name\': \'noc\',\n \'priority\': None,\n \'tags\': \'\',\n \'ttl\': None,\n \'type\': \'A\',\n \'zone\': <DNSZone: mcd.net.ua>}\n self = <noc.lib.app.modelinline.ModelInline object at 0x80f245fd0>\n request = \n<WSGIRequest\npath:/dns/dnszone/1/records/,\nGET:<QueryDict: {u\'_dc\': [u\'1370867068721\'], u\'__format\': [u\'ext\']}>,\nPOST:<QueryDict: {u\'{"id":0,"name":"noc","ttl":null,"priority":null,"type":"A","content":"10.255.255.253","tags":""}\': [u\'\']}>,\nCOOKIES:{\'IV\': \'QL3j0DJ%2BVxj2DLT6j%2Bp0tqwWxkiEl0BI6iU%2BK1Dxj6g%3D\',\n \'Key\': \'mg%2FpCJ31oIG%2B1%2BqOiJuMUXywqpS2p%2BPV7dQBR8dcySY%3D\',\n \'PHPSESSID\': \'7613c322a5e7ac22bca1bb869e5e0d31\',\n \'csrftoken\': \'4b6vE1ZFHEP78vgvbgVvtROdGcqVDox7\',\n \'sessionid\': \'e29cda43485e524eb74db8eeaa05abfc\'},\nMETA:{\'CONTENT_LENGTH\': \'96\',\n \'CONTENT_TYPE\': \'application/json\',\n \'HTTP_ACCEPT\': \'*/*\',\n \'HTTP_ACCEPT_CHARSET\': \'windows-1251,utf-8;q=0.7,*;q=0.3\',\n \'HTTP_ACCEPT_ENCODING\': \'gzip,deflate,sdch\',\n \'HTTP_ACCEPT_LANGUAGE\': \'ru-RU,ru;q=0.8,en-US;q=0.6,en;q=0.4\',\n \'HTTP_AUTHORIZATION\': \'Basic emFpa2E6KEIwNjBESEVF\',\n \'HTTP_CONNECTION\': \'Keep-Alive\',\n \'HTTP_COOKIE\': \'PHPSESSID=7613c322a5e7ac22bca1bb869e5e0d31; Key=mg%2FpCJ31oIG%2B1%2BqOiJuMUXywqpS2p%2BPV7dQBR8dcySY%3D; IV=QL3j0DJ%2BVxj2DLT6j%2Bp0tqwWxkiEl0BI6iU%2BK1Dxj6g%3D; sessionid=e29cda43485e524eb74db8eeaa05abfc; csrftoken=4b6vE1ZFHEP78vgvbgVvtROdGcqVDox7\',\n \'HTTP_HOST\': \'localhost:8000\',\n \'HTTP_ORIGIN\': \'https://noc.mcd.net.ua\',\n \'HTTP_REFERER\': \'https://noc.mcd.net.ua/main/desktop/\',\n \'HTTP_REMOTE_USER\': \'zaika\',\n \'HTTP_USER_AGENT\': \'Mozilla/5.0 (X11; FreeBSD amd64) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.97 Safari/537.22\',\n \'HTTP_X_FORWARDED_FOR\': \'193.254.232.25\',\n \'HTTP_X_FORWARDED_HOST\': \'noc.mcd.net.ua\',\n \'HTTP_X_FORWARDED_SERVER\': \'noc.mcd.net.ua\',\n \'HTTP_X_REQUESTED_WITH\': \'XMLHttpRequest\',\n \'PATH_INFO\': u\'/dns/dnszone/1/records/\',\n \'QUERY_STRING\': \'_dc=1370867068721&__format=ext\',\n \'REMOTE_ADDR\': \'127.0.0.1\',\n \'REQUEST_METHOD\': \'POST\',\n \'SCRIPT_NAME\': u\'\',\n \'SERVER_NAME\': \'localhost\',\n \'SERVER_PORT\': \'8000\',\n \'SERVER_PROTOCOL\': \'HTTP/1.1\',\n \'wsgi.errors\': <open file \'/dev/null\', mode \'a+\' at 0x8074b5030>,\n \'wsgi.input\': <_io.BytesIO object at 0x80f05e770>,\n \'wsgi.multiprocess\': True,\n \'wsgi.multithread\': False,\n \'wsgi.run_once\': False,\n \'wsgi.url_scheme\': \'http\',\n \'wsgi.version\': (1, 0)}>\n attrs = \n{\'content\': \'10.255.255.253\',\n \'name\': \'noc\',\n \'priority\': None,\n \'tags\': \'\',\n \'ttl\': None,\n \'type\': \'A\',\n \'zone\': <DNSZone: mcd.net.ua>}\n parent = <DNSZone: mcd.net.ua>\n------------------------------------------------------------------------\nFile: /opt/noc/lib/app/site.py (Line: 232)\nFunction: inner\n 225 for k, v in request.POST.lists())\n 226 elif request.method == "GET":\n 227 a = dict((k, v[0] if len(v) == 1 else v)\n 228 for k, v in request.GET.lists())\n 229 logging.debug("API %s %s %s" % (request.method,\n 230 request.path, a))\n 231 # Call handler\n 232 ==> r = v(request, *args, **kwargs)\n 233 # Dump SQL statements\n 234 if self.log_sql_statements:\n 235 from django.db import connections\n 236 tsc = 0\n 237 sc = defaultdict(int)\n 238 for conn in connections.all():\nVariables:\n a = \n{\'content\': \'10.255.255.253\',\n \'id\': 0,\n \'name\': \'noc\',\n \'priority\': None,\n \'tags\': \'\',\n \'ttl\': None,\n \'type\': \'A\'}\n v = <functools.partial object at 0x80f249520>\n view_map = \n{\'GET\': <functools.partial object at 0x80f2494c8>,\n \'POST\': <functools.partial object at 0x80f249520>}\n Form = <class \'django.forms.forms.Form\'>\n args = ()\n DictParameter = <class \'noc.sa.interfaces.base.DictParameter\'>\n self = <noc.lib.app.site.Site object at 0x80b394390>\n to_log_api_call = True\n request = \n<WSGIRequest\npath:/dns/dnszone/1/records/,\nGET:<QueryDict: {u\'_dc\': [u\'1370867068721\'], u\'__format\': [u\'ext\']}>,\nPOST:<QueryDict: {u\'{"id":0,"name":"noc","ttl":null,"priority":null,"type":"A","content":"10.255.255.253","tags":""}\': [u\'\']}>,\nCOOKIES:{\'IV\': \'QL3j0DJ%2BVxj2DLT6j%2Bp0tqwWxkiEl0BI6iU%2BK1Dxj6g%3D\',\n \'Key\': \'mg%2FpCJ31oIG%2B1%2BqOiJuMUXywqpS2p%2BPV7dQBR8dcySY%3D\',\n \'PHPSESSID\': \'7613c322a5e7ac22bca1bb869e5e0d31\',\n \'csrftoken\': \'4b6vE1ZFHEP78vgvbgVvtROdGcqVDox7\',\n \'sessionid\': \'e29cda43485e524eb74db8eeaa05abfc\'},\nMETA:{\'CONTENT_LENGTH\': \'96\',\n \'CONTENT_TYPE\': \'application/json\',\n \'HTTP_ACCEPT\': \'*/*\',\n \'HTTP_ACCEPT_CHARSET\': \'windows-1251,utf-8;q=0.7,*;q=0.3\',\n \'HTTP_ACCEPT_ENCODING\': \'gzip,deflate,sdch\',\n \'HTTP_ACCEPT_LANGUAGE\': \'ru-RU,ru;q=0.8,en-US;q=0.6,en;q=0.4\',\n \'HTTP_AUTHORIZATION\': \'Basic emFpa2E6KEIwNjBESEVF\',\n \'HTTP_CONNECTION\': \'Keep-Alive\',\n \'HTTP_COOKIE\': \'PHPSESSID=7613c322a5e7ac22bca1bb869e5e0d31; Key=mg%2FpCJ31oIG%2B1%2BqOiJuMUXywqpS2p%2BPV7dQBR8dcySY%3D; IV=QL3j0DJ%2BVxj2DLT6j%2Bp0tqwWxkiEl0BI6iU%2BK1Dxj6g%3D; sessionid=e29cda43485e524eb74db8eeaa05abfc; csrftoken=4b6vE1ZFHEP78vgvbgVvtROdGcqVDox7\',\n \'HTTP_HOST\': \'localhost:8000\',\n \'HTTP_ORIGIN\': \'https://noc.mcd.net.ua\',\n \'HTTP_REFERER\': \'https://noc.mcd.net.ua/main/desktop/\',\n \'HTTP_REMOTE_USER\': \'zaika\',\n \'HTTP_USER_AGENT\': \'Mozilla/5.0 (X11; FreeBSD amd64) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.97 Safari/537.22\',\n \'HTTP_X_FORWARDED_FOR\': \'193.254.232.25\',\n \'HTTP_X_FORWARDED_HOST\': \'noc.mcd.net.ua\',\n \'HTTP_X_FORWARDED_SERVER\': \'noc.mcd.net.ua\',\n \'HTTP_X_REQUESTED_WITH\': \'XMLHttpRequest\',\n \'PATH_INFO\': u\'/dns/dnszone/1/records/\',\n \'QUERY_STRING\': \'_dc=1370867068721&__format=ext\',\n \'REMOTE_ADDR\': \'127.0.0.1\',\n \'REQUEST_METHOD\': \'POST\',\n \'SCRIPT_NAME\': u\'\',\n \'SERVER_NAME\': \'localhost\',\n \'SERVER_PORT\': \'8000\',\n \'SERVER_PROTOCOL\': \'HTTP/1.1\',\n \'wsgi.errors\': <open file \'/dev/null\', mode \'a+\' at 0x8074b5030>,\n \'wsgi.input\': <_io.BytesIO object at 0x80f05e770>,\n \'wsgi.multiprocess\': True,\n \'wsgi.multithread\': 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 PermissionDenied = <class \'noc.lib.app.access.PermissionDenied\'>\n kwargs = {\'parent\': u\'1\'}\n app = <noc.dns.apps.dnszone.views.DNSZoneApplication object at 0x80f24f510>\n ct = \'application/json\'\n------------------------------------------------------------------------\nEND OF TRACEBACK'
  357. app = <noc.dns.apps.dnszone.views.DNSZoneApplication object at 0x80f24f510>
  358. ct = 'application/json'
  359. ------------------------------------------------------------------------
  360. END OF TRACEBACK
  361. 2013-06-10 15:31:29,920 500 POST /dns/dnszone/1/records/?_dc=1370867068721&__format=ext (127.0.0.1) 316.19ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!