model_service.log.2020-10-09 169 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057
  1. 10/09/2020 10:05:35 AM INFO simhash similarity service started at 2020-10-09 10:05:35
  2. 10/09/2020 10:05:35 AM INFO simhash similarity service started successfully at 2020-10-09 10:05:35
  3. 10/09/2020 10:05:56 AM INFO ******************************************** NEW REQUEST ********************************************
  4. 10/09/2020 10:05:56 AM INFO the md5 of request script is 123
  5. 10/09/2020 10:05:56 AM ERROR Traceback (most recent call last):
  6. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  7. cursor, statement, context
  8. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  9. cursor.execute(statement)
  10. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  11. result = self._query(query)
  12. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  13. conn.query(q)
  14. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  15. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  16. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  17. result.read()
  18. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  19. first_packet = self.connection._read_packet()
  20. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  21. packet.check_error()
  22. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  23. err.raise_mysql_exception(self._data)
  24. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  25. raise errorclass(errno, errval)
  26. pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
  27. The above exception was the direct cause of the following exception:
  28. Traceback (most recent call last):
  29. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
  30. inst.parse_content()
  31. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
  32. df = pd.read_sql(sql, engine)
  33. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  34. chunksize=chunksize,
  35. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  36. result = self.execute(*args)
  37. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  38. *args, **kwargs
  39. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  40. return connection.execute(statement, *multiparams, **params)
  41. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  42. return self._execute_text(object_, multiparams, params)
  43. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  44. parameters,
  45. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  46. e, statement, parameters, cursor, context
  47. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  48. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  49. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  50. raise exception
  51. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  52. cursor, statement, context
  53. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  54. cursor.execute(statement)
  55. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  56. result = self._query(query)
  57. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  58. conn.query(q)
  59. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  60. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  61. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  62. result.read()
  63. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  64. first_packet = self.connection._read_packet()
  65. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  66. packet.check_error()
  67. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  68. err.raise_mysql_exception(self._data)
  69. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  70. raise errorclass(errno, errval)
  71. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
  72. [SQL: select * from ctop_script_file where id = self.script_md5 ]
  73. (Background on this error at: http://sqlalche.me/e/13/2j85)
  74. 10/09/2020 10:06:22 AM INFO simhash similarity service started at 2020-10-09 10:06:22
  75. 10/09/2020 10:06:22 AM INFO simhash similarity service started successfully at 2020-10-09 10:06:22
  76. 10/09/2020 10:06:45 AM INFO simhash similarity service started at 2020-10-09 10:06:45
  77. 10/09/2020 10:06:45 AM INFO simhash similarity service started successfully at 2020-10-09 10:06:45
  78. 10/09/2020 10:07:04 AM INFO simhash similarity service started at 2020-10-09 10:07:04
  79. 10/09/2020 10:07:04 AM INFO simhash similarity service started successfully at 2020-10-09 10:07:04
  80. 10/09/2020 10:07:09 AM INFO ******************************************** NEW REQUEST ********************************************
  81. 10/09/2020 10:07:09 AM INFO the md5 of request script is 12323
  82. 10/09/2020 10:07:09 AM ERROR Traceback (most recent call last):
  83. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  84. cursor, statement, context
  85. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  86. cursor.execute(statement)
  87. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  88. result = self._query(query)
  89. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  90. conn.query(q)
  91. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  92. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  93. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  94. result.read()
  95. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  96. first_packet = self.connection._read_packet()
  97. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  98. packet.check_error()
  99. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  100. err.raise_mysql_exception(self._data)
  101. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  102. raise errorclass(errno, errval)
  103. pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
  104. The above exception was the direct cause of the following exception:
  105. Traceback (most recent call last):
  106. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
  107. inst.parse_content()
  108. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
  109. df = pd.read_sql(sql, engine)
  110. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  111. chunksize=chunksize,
  112. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  113. result = self.execute(*args)
  114. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  115. *args, **kwargs
  116. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  117. return connection.execute(statement, *multiparams, **params)
  118. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  119. return self._execute_text(object_, multiparams, params)
  120. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  121. parameters,
  122. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  123. e, statement, parameters, cursor, context
  124. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  125. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  126. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  127. raise exception
  128. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  129. cursor, statement, context
  130. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  131. cursor.execute(statement)
  132. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  133. result = self._query(query)
  134. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  135. conn.query(q)
  136. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  137. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  138. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  139. result.read()
  140. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  141. first_packet = self.connection._read_packet()
  142. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  143. packet.check_error()
  144. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  145. err.raise_mysql_exception(self._data)
  146. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  147. raise errorclass(errno, errval)
  148. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
  149. [SQL: select * from ctop_script_file where id = self.script_md5 ]
  150. (Background on this error at: http://sqlalche.me/e/13/2j85)
  151. 10/09/2020 10:08:21 AM INFO simhash similarity service started at 2020-10-09 10:08:21
  152. 10/09/2020 10:08:21 AM INFO simhash similarity service started successfully at 2020-10-09 10:08:21
  153. 10/09/2020 10:14:06 AM INFO simhash similarity service started at 2020-10-09 10:14:06
  154. 10/09/2020 10:14:06 AM INFO simhash similarity service started successfully at 2020-10-09 10:14:06
  155. 10/09/2020 10:14:22 AM INFO simhash similarity service started at 2020-10-09 10:14:22
  156. 10/09/2020 10:14:22 AM INFO simhash similarity service started successfully at 2020-10-09 10:14:22
  157. 10/09/2020 10:15:32 AM INFO simhash similarity service started at 2020-10-09 10:15:32
  158. 10/09/2020 10:15:32 AM INFO simhash similarity service started successfully at 2020-10-09 10:15:32
  159. 10/09/2020 10:17:48 AM INFO simhash similarity service started at 2020-10-09 10:17:48
  160. 10/09/2020 10:17:48 AM INFO simhash similarity service started successfully at 2020-10-09 10:17:48
  161. 10/09/2020 10:17:52 AM INFO ******************************************** NEW REQUEST ********************************************
  162. 10/09/2020 10:17:52 AM INFO the md5 of request script is 12323
  163. 10/09/2020 10:17:52 AM ERROR Traceback (most recent call last):
  164. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  165. cursor, statement, context
  166. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  167. cursor.execute(statement)
  168. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  169. result = self._query(query)
  170. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  171. conn.query(q)
  172. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  173. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  174. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  175. result.read()
  176. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  177. first_packet = self.connection._read_packet()
  178. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  179. packet.check_error()
  180. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  181. err.raise_mysql_exception(self._data)
  182. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  183. raise errorclass(errno, errval)
  184. pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
  185. The above exception was the direct cause of the following exception:
  186. Traceback (most recent call last):
  187. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
  188. inst.parse_content()
  189. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
  190. df = pd.read_sql(sql, engine)
  191. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  192. chunksize=chunksize,
  193. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  194. result = self.execute(*args)
  195. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  196. *args, **kwargs
  197. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  198. return connection.execute(statement, *multiparams, **params)
  199. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  200. return self._execute_text(object_, multiparams, params)
  201. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  202. parameters,
  203. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  204. e, statement, parameters, cursor, context
  205. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  206. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  207. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  208. raise exception
  209. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  210. cursor, statement, context
  211. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  212. cursor.execute(statement)
  213. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  214. result = self._query(query)
  215. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  216. conn.query(q)
  217. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  218. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  219. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  220. result.read()
  221. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  222. first_packet = self.connection._read_packet()
  223. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  224. packet.check_error()
  225. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  226. err.raise_mysql_exception(self._data)
  227. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  228. raise errorclass(errno, errval)
  229. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
  230. [SQL: select * from ctop_script_file where id = self.script_md5 ]
  231. (Background on this error at: http://sqlalche.me/e/13/2j85)
  232. 10/09/2020 10:18:02 AM INFO simhash similarity service started at 2020-10-09 10:18:02
  233. 10/09/2020 10:18:02 AM INFO simhash similarity service started successfully at 2020-10-09 10:18:02
  234. 10/09/2020 10:18:03 AM INFO ******************************************** NEW REQUEST ********************************************
  235. 10/09/2020 10:18:03 AM INFO the md5 of request script is 12323
  236. 10/09/2020 10:18:03 AM ERROR Traceback (most recent call last):
  237. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  238. cursor, statement, context
  239. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  240. cursor.execute(statement)
  241. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  242. result = self._query(query)
  243. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  244. conn.query(q)
  245. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  246. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  247. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  248. result.read()
  249. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  250. first_packet = self.connection._read_packet()
  251. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  252. packet.check_error()
  253. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  254. err.raise_mysql_exception(self._data)
  255. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  256. raise errorclass(errno, errval)
  257. pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
  258. The above exception was the direct cause of the following exception:
  259. Traceback (most recent call last):
  260. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
  261. inst.parse_content()
  262. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
  263. df = pd.read_sql(sql, engine)
  264. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  265. chunksize=chunksize,
  266. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  267. result = self.execute(*args)
  268. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  269. *args, **kwargs
  270. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  271. return connection.execute(statement, *multiparams, **params)
  272. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  273. return self._execute_text(object_, multiparams, params)
  274. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  275. parameters,
  276. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  277. e, statement, parameters, cursor, context
  278. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  279. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  280. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  281. raise exception
  282. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  283. cursor, statement, context
  284. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  285. cursor.execute(statement)
  286. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  287. result = self._query(query)
  288. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  289. conn.query(q)
  290. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  291. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  292. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  293. result.read()
  294. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  295. first_packet = self.connection._read_packet()
  296. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  297. packet.check_error()
  298. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  299. err.raise_mysql_exception(self._data)
  300. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  301. raise errorclass(errno, errval)
  302. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
  303. [SQL: select * from ctop_script_file where id = self.script_md5 ]
  304. (Background on this error at: http://sqlalche.me/e/13/2j85)
  305. 10/09/2020 10:18:14 AM INFO ******************************************** NEW REQUEST ********************************************
  306. 10/09/2020 10:18:14 AM INFO the md5 of request script is 12323a
  307. 10/09/2020 10:18:14 AM ERROR Traceback (most recent call last):
  308. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  309. cursor, statement, context
  310. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  311. cursor.execute(statement)
  312. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  313. result = self._query(query)
  314. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  315. conn.query(q)
  316. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  317. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  318. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  319. result.read()
  320. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  321. first_packet = self.connection._read_packet()
  322. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  323. packet.check_error()
  324. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  325. err.raise_mysql_exception(self._data)
  326. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  327. raise errorclass(errno, errval)
  328. pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
  329. The above exception was the direct cause of the following exception:
  330. Traceback (most recent call last):
  331. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
  332. inst.parse_content()
  333. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
  334. df = pd.read_sql(sql, engine)
  335. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  336. chunksize=chunksize,
  337. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  338. result = self.execute(*args)
  339. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  340. *args, **kwargs
  341. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  342. return connection.execute(statement, *multiparams, **params)
  343. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  344. return self._execute_text(object_, multiparams, params)
  345. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  346. parameters,
  347. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  348. e, statement, parameters, cursor, context
  349. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  350. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  351. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  352. raise exception
  353. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  354. cursor, statement, context
  355. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  356. cursor.execute(statement)
  357. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  358. result = self._query(query)
  359. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  360. conn.query(q)
  361. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  362. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  363. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  364. result.read()
  365. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  366. first_packet = self.connection._read_packet()
  367. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  368. packet.check_error()
  369. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  370. err.raise_mysql_exception(self._data)
  371. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  372. raise errorclass(errno, errval)
  373. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
  374. [SQL: select * from ctop_script_file where id = self.script_md5 ]
  375. (Background on this error at: http://sqlalche.me/e/13/2j85)
  376. 10/09/2020 10:18:19 AM INFO ******************************************** NEW REQUEST ********************************************
  377. 10/09/2020 10:18:19 AM INFO the md5 of request script is 12323ab
  378. 10/09/2020 10:18:19 AM ERROR Traceback (most recent call last):
  379. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  380. cursor, statement, context
  381. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  382. cursor.execute(statement)
  383. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  384. result = self._query(query)
  385. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  386. conn.query(q)
  387. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  388. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  389. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  390. result.read()
  391. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  392. first_packet = self.connection._read_packet()
  393. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  394. packet.check_error()
  395. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  396. err.raise_mysql_exception(self._data)
  397. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  398. raise errorclass(errno, errval)
  399. pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
  400. The above exception was the direct cause of the following exception:
  401. Traceback (most recent call last):
  402. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
  403. inst.parse_content()
  404. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
  405. df = pd.read_sql(sql, engine)
  406. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  407. chunksize=chunksize,
  408. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  409. result = self.execute(*args)
  410. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  411. *args, **kwargs
  412. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  413. return connection.execute(statement, *multiparams, **params)
  414. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  415. return self._execute_text(object_, multiparams, params)
  416. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  417. parameters,
  418. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  419. e, statement, parameters, cursor, context
  420. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  421. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  422. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  423. raise exception
  424. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  425. cursor, statement, context
  426. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  427. cursor.execute(statement)
  428. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  429. result = self._query(query)
  430. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  431. conn.query(q)
  432. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  433. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  434. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  435. result.read()
  436. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  437. first_packet = self.connection._read_packet()
  438. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  439. packet.check_error()
  440. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  441. err.raise_mysql_exception(self._data)
  442. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  443. raise errorclass(errno, errval)
  444. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
  445. [SQL: select * from ctop_script_file where id = self.script_md5 ]
  446. (Background on this error at: http://sqlalche.me/e/13/2j85)
  447. 10/09/2020 10:18:23 AM INFO ******************************************** NEW REQUEST ********************************************
  448. 10/09/2020 10:18:23 AM INFO the md5 of request script is 12323abccc
  449. 10/09/2020 10:18:23 AM ERROR Traceback (most recent call last):
  450. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  451. cursor, statement, context
  452. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  453. cursor.execute(statement)
  454. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  455. result = self._query(query)
  456. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  457. conn.query(q)
  458. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  459. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  460. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  461. result.read()
  462. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  463. first_packet = self.connection._read_packet()
  464. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  465. packet.check_error()
  466. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  467. err.raise_mysql_exception(self._data)
  468. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  469. raise errorclass(errno, errval)
  470. pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
  471. The above exception was the direct cause of the following exception:
  472. Traceback (most recent call last):
  473. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
  474. inst.parse_content()
  475. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
  476. df = pd.read_sql(sql, engine)
  477. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  478. chunksize=chunksize,
  479. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  480. result = self.execute(*args)
  481. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  482. *args, **kwargs
  483. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  484. return connection.execute(statement, *multiparams, **params)
  485. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  486. return self._execute_text(object_, multiparams, params)
  487. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  488. parameters,
  489. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  490. e, statement, parameters, cursor, context
  491. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  492. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  493. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  494. raise exception
  495. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  496. cursor, statement, context
  497. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  498. cursor.execute(statement)
  499. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  500. result = self._query(query)
  501. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  502. conn.query(q)
  503. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  504. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  505. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  506. result.read()
  507. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  508. first_packet = self.connection._read_packet()
  509. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  510. packet.check_error()
  511. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  512. err.raise_mysql_exception(self._data)
  513. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  514. raise errorclass(errno, errval)
  515. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
  516. [SQL: select * from ctop_script_file where id = self.script_md5 ]
  517. (Background on this error at: http://sqlalche.me/e/13/2j85)
  518. 10/09/2020 10:18:58 AM INFO ******************************************** NEW REQUEST ********************************************
  519. 10/09/2020 10:18:58 AM INFO the md5 of request script is 12323abccc
  520. 10/09/2020 10:18:58 AM ERROR Traceback (most recent call last):
  521. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  522. cursor, statement, context
  523. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  524. cursor.execute(statement)
  525. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  526. result = self._query(query)
  527. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  528. conn.query(q)
  529. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  530. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  531. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  532. result.read()
  533. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  534. first_packet = self.connection._read_packet()
  535. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  536. packet.check_error()
  537. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  538. err.raise_mysql_exception(self._data)
  539. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  540. raise errorclass(errno, errval)
  541. pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
  542. The above exception was the direct cause of the following exception:
  543. Traceback (most recent call last):
  544. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
  545. inst.parse_content()
  546. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
  547. df = pd.read_sql(sql, engine)
  548. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  549. chunksize=chunksize,
  550. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  551. result = self.execute(*args)
  552. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  553. *args, **kwargs
  554. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  555. return connection.execute(statement, *multiparams, **params)
  556. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  557. return self._execute_text(object_, multiparams, params)
  558. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  559. parameters,
  560. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  561. e, statement, parameters, cursor, context
  562. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  563. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  564. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  565. raise exception
  566. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  567. cursor, statement, context
  568. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  569. cursor.execute(statement)
  570. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  571. result = self._query(query)
  572. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  573. conn.query(q)
  574. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  575. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  576. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  577. result.read()
  578. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  579. first_packet = self.connection._read_packet()
  580. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  581. packet.check_error()
  582. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  583. err.raise_mysql_exception(self._data)
  584. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  585. raise errorclass(errno, errval)
  586. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
  587. [SQL: select * from ctop_script_file where id = self.script_md5 ]
  588. (Background on this error at: http://sqlalche.me/e/13/2j85)
  589. 10/09/2020 10:19:05 AM INFO ******************************************** NEW REQUEST ********************************************
  590. 10/09/2020 10:19:05 AM INFO the md5 of request script is 12323abccc
  591. 10/09/2020 10:19:05 AM ERROR Traceback (most recent call last):
  592. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  593. cursor, statement, context
  594. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  595. cursor.execute(statement)
  596. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  597. result = self._query(query)
  598. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  599. conn.query(q)
  600. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  601. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  602. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  603. result.read()
  604. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  605. first_packet = self.connection._read_packet()
  606. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  607. packet.check_error()
  608. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  609. err.raise_mysql_exception(self._data)
  610. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  611. raise errorclass(errno, errval)
  612. pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
  613. The above exception was the direct cause of the following exception:
  614. Traceback (most recent call last):
  615. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
  616. inst.parse_content()
  617. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
  618. df = pd.read_sql(sql, engine)
  619. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  620. chunksize=chunksize,
  621. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  622. result = self.execute(*args)
  623. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  624. *args, **kwargs
  625. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  626. return connection.execute(statement, *multiparams, **params)
  627. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  628. return self._execute_text(object_, multiparams, params)
  629. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  630. parameters,
  631. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  632. e, statement, parameters, cursor, context
  633. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  634. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  635. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  636. raise exception
  637. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  638. cursor, statement, context
  639. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  640. cursor.execute(statement)
  641. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  642. result = self._query(query)
  643. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  644. conn.query(q)
  645. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  646. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  647. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  648. result.read()
  649. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  650. first_packet = self.connection._read_packet()
  651. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  652. packet.check_error()
  653. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  654. err.raise_mysql_exception(self._data)
  655. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  656. raise errorclass(errno, errval)
  657. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
  658. [SQL: select * from ctop_script_file where id = self.script_md5 ]
  659. (Background on this error at: http://sqlalche.me/e/13/2j85)
  660. 10/09/2020 10:19:09 AM INFO ******************************************** NEW REQUEST ********************************************
  661. 10/09/2020 10:19:09 AM INFO the md5 of request script is 12323abccc123
  662. 10/09/2020 10:19:09 AM ERROR Traceback (most recent call last):
  663. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  664. cursor, statement, context
  665. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  666. cursor.execute(statement)
  667. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  668. result = self._query(query)
  669. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  670. conn.query(q)
  671. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  672. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  673. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  674. result.read()
  675. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  676. first_packet = self.connection._read_packet()
  677. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  678. packet.check_error()
  679. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  680. err.raise_mysql_exception(self._data)
  681. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  682. raise errorclass(errno, errval)
  683. pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
  684. The above exception was the direct cause of the following exception:
  685. Traceback (most recent call last):
  686. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
  687. inst.parse_content()
  688. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
  689. df = pd.read_sql(sql, engine)
  690. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  691. chunksize=chunksize,
  692. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  693. result = self.execute(*args)
  694. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  695. *args, **kwargs
  696. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  697. return connection.execute(statement, *multiparams, **params)
  698. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  699. return self._execute_text(object_, multiparams, params)
  700. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  701. parameters,
  702. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  703. e, statement, parameters, cursor, context
  704. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  705. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  706. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  707. raise exception
  708. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  709. cursor, statement, context
  710. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  711. cursor.execute(statement)
  712. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  713. result = self._query(query)
  714. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  715. conn.query(q)
  716. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  717. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  718. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  719. result.read()
  720. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  721. first_packet = self.connection._read_packet()
  722. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  723. packet.check_error()
  724. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  725. err.raise_mysql_exception(self._data)
  726. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  727. raise errorclass(errno, errval)
  728. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
  729. [SQL: select * from ctop_script_file where id = self.script_md5 ]
  730. (Background on this error at: http://sqlalche.me/e/13/2j85)
  731. 10/09/2020 10:19:22 AM INFO simhash similarity service started at 2020-10-09 10:19:22
  732. 10/09/2020 10:19:22 AM INFO simhash similarity service started successfully at 2020-10-09 10:19:22
  733. 10/09/2020 10:19:30 AM INFO simhash similarity service started at 2020-10-09 10:19:30
  734. 10/09/2020 10:19:30 AM INFO simhash similarity service started successfully at 2020-10-09 10:19:30
  735. 10/09/2020 10:19:32 AM INFO ******************************************** NEW REQUEST ********************************************
  736. 10/09/2020 10:19:32 AM INFO the md5 of request script is 12323abccc123
  737. 10/09/2020 10:19:33 AM ERROR Traceback (most recent call last):
  738. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  739. cursor, statement, context
  740. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  741. cursor.execute(statement)
  742. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  743. result = self._query(query)
  744. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  745. conn.query(q)
  746. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  747. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  748. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  749. result.read()
  750. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  751. first_packet = self.connection._read_packet()
  752. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  753. packet.check_error()
  754. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  755. err.raise_mysql_exception(self._data)
  756. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  757. raise errorclass(errno, errval)
  758. pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
  759. The above exception was the direct cause of the following exception:
  760. Traceback (most recent call last):
  761. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
  762. inst.parse_content()
  763. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
  764. df = pd.read_sql(sql, engine)
  765. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  766. chunksize=chunksize,
  767. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  768. result = self.execute(*args)
  769. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  770. *args, **kwargs
  771. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  772. return connection.execute(statement, *multiparams, **params)
  773. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  774. return self._execute_text(object_, multiparams, params)
  775. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  776. parameters,
  777. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  778. e, statement, parameters, cursor, context
  779. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  780. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  781. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  782. raise exception
  783. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  784. cursor, statement, context
  785. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  786. cursor.execute(statement)
  787. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  788. result = self._query(query)
  789. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  790. conn.query(q)
  791. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  792. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  793. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  794. result.read()
  795. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  796. first_packet = self.connection._read_packet()
  797. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  798. packet.check_error()
  799. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  800. err.raise_mysql_exception(self._data)
  801. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  802. raise errorclass(errno, errval)
  803. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
  804. [SQL: select * from ctop_script_file where id = self.script_md5 ]
  805. (Background on this error at: http://sqlalche.me/e/13/2j85)
  806. 10/09/2020 10:55:14 AM INFO simhash similarity service started at 2020-10-09 10:55:14
  807. 10/09/2020 10:55:14 AM INFO simhash similarity service started successfully at 2020-10-09 10:55:14
  808. 10/09/2020 10:55:21 AM INFO ******************************************** NEW REQUEST ********************************************
  809. 10/09/2020 10:55:21 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  810. 10/09/2020 10:55:21 AM ERROR Traceback (most recent call last):
  811. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  812. cursor, statement, context
  813. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  814. cursor.execute(statement)
  815. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  816. result = self._query(query)
  817. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  818. conn.query(q)
  819. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  820. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  821. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  822. result.read()
  823. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  824. first_packet = self.connection._read_packet()
  825. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  826. packet.check_error()
  827. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  828. err.raise_mysql_exception(self._data)
  829. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  830. raise errorclass(errno, errval)
  831. pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
  832. The above exception was the direct cause of the following exception:
  833. Traceback (most recent call last):
  834. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
  835. inst.parse_content()
  836. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 86, in parse_content
  837. df = pd.read_sql(sql, engine)
  838. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  839. chunksize=chunksize,
  840. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  841. result = self.execute(*args)
  842. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  843. *args, **kwargs
  844. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  845. return connection.execute(statement, *multiparams, **params)
  846. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  847. return self._execute_text(object_, multiparams, params)
  848. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  849. parameters,
  850. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  851. e, statement, parameters, cursor, context
  852. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  853. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  854. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  855. raise exception
  856. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  857. cursor, statement, context
  858. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  859. cursor.execute(statement)
  860. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  861. result = self._query(query)
  862. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  863. conn.query(q)
  864. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  865. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  866. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  867. result.read()
  868. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  869. first_packet = self.connection._read_packet()
  870. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  871. packet.check_error()
  872. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  873. err.raise_mysql_exception(self._data)
  874. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  875. raise errorclass(errno, errval)
  876. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
  877. [SQL: select * from ctop_script_file where id = self.script_md5 ]
  878. (Background on this error at: http://sqlalche.me/e/13/2j85)
  879. 10/09/2020 10:57:15 AM INFO simhash similarity service started at 2020-10-09 10:57:15
  880. 10/09/2020 10:57:15 AM INFO simhash similarity service started successfully at 2020-10-09 10:57:15
  881. 10/09/2020 10:57:20 AM INFO ******************************************** NEW REQUEST ********************************************
  882. 10/09/2020 10:57:20 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  883. 10/09/2020 10:57:20 AM ERROR Traceback (most recent call last):
  884. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  885. cursor, statement, context
  886. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  887. cursor.execute(statement)
  888. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  889. result = self._query(query)
  890. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  891. conn.query(q)
  892. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  893. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  894. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  895. result.read()
  896. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  897. first_packet = self.connection._read_packet()
  898. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  899. packet.check_error()
  900. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  901. err.raise_mysql_exception(self._data)
  902. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  903. raise errorclass(errno, errval)
  904. pymysql.err.InternalError: (1054, "Unknown column '3996ca5cb3957e624c10e996af155837' in 'where clause'")
  905. The above exception was the direct cause of the following exception:
  906. Traceback (most recent call last):
  907. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
  908. inst.parse_content()
  909. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 86, in parse_content
  910. df = pd.read_sql(sql, engine)
  911. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  912. chunksize=chunksize,
  913. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  914. result = self.execute(*args)
  915. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  916. *args, **kwargs
  917. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  918. return connection.execute(statement, *multiparams, **params)
  919. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  920. return self._execute_text(object_, multiparams, params)
  921. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  922. parameters,
  923. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  924. e, statement, parameters, cursor, context
  925. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  926. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  927. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  928. raise exception
  929. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  930. cursor, statement, context
  931. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  932. cursor.execute(statement)
  933. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  934. result = self._query(query)
  935. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  936. conn.query(q)
  937. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  938. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  939. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  940. result.read()
  941. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  942. first_packet = self.connection._read_packet()
  943. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  944. packet.check_error()
  945. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  946. err.raise_mysql_exception(self._data)
  947. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  948. raise errorclass(errno, errval)
  949. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column '3996ca5cb3957e624c10e996af155837' in 'where clause'")
  950. [SQL: select * from ctop_script_file where id = 3996ca5cb3957e624c10e996af155837 ]
  951. (Background on this error at: http://sqlalche.me/e/13/2j85)
  952. 10/09/2020 11:00:23 AM INFO simhash similarity service started at 2020-10-09 11:00:23
  953. 10/09/2020 11:00:23 AM INFO simhash similarity service started successfully at 2020-10-09 11:00:23
  954. 10/09/2020 11:00:26 AM INFO ******************************************** NEW REQUEST ********************************************
  955. 10/09/2020 11:00:26 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  956. 10/09/2020 11:00:26 AM ERROR Traceback (most recent call last):
  957. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  958. cursor, statement, context
  959. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  960. cursor.execute(statement)
  961. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  962. result = self._query(query)
  963. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  964. conn.query(q)
  965. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  966. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  967. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  968. result.read()
  969. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  970. first_packet = self.connection._read_packet()
  971. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  972. packet.check_error()
  973. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  974. err.raise_mysql_exception(self._data)
  975. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  976. raise errorclass(errno, errval)
  977. pymysql.err.InternalError: (1054, "Unknown column '3996ca5cb3957e624c10e996af155837' in 'where clause'")
  978. The above exception was the direct cause of the following exception:
  979. Traceback (most recent call last):
  980. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
  981. inst.parse_content()
  982. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
  983. df = pd.read_sql(sql, engine)
  984. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  985. chunksize=chunksize,
  986. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  987. result = self.execute(*args)
  988. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  989. *args, **kwargs
  990. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  991. return connection.execute(statement, *multiparams, **params)
  992. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  993. return self._execute_text(object_, multiparams, params)
  994. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  995. parameters,
  996. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  997. e, statement, parameters, cursor, context
  998. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  999. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  1000. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  1001. raise exception
  1002. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  1003. cursor, statement, context
  1004. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  1005. cursor.execute(statement)
  1006. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  1007. result = self._query(query)
  1008. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  1009. conn.query(q)
  1010. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  1011. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1012. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  1013. result.read()
  1014. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  1015. first_packet = self.connection._read_packet()
  1016. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  1017. packet.check_error()
  1018. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  1019. err.raise_mysql_exception(self._data)
  1020. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  1021. raise errorclass(errno, errval)
  1022. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column '3996ca5cb3957e624c10e996af155837' in 'where clause'")
  1023. [SQL: select * from ctop_script_file where id = 3996ca5cb3957e624c10e996af155837 ]
  1024. (Background on this error at: http://sqlalche.me/e/13/2j85)
  1025. 10/09/2020 11:00:48 AM INFO simhash similarity service started at 2020-10-09 11:00:48
  1026. 10/09/2020 11:00:48 AM INFO simhash similarity service started successfully at 2020-10-09 11:00:48
  1027. 10/09/2020 11:00:52 AM INFO ******************************************** NEW REQUEST ********************************************
  1028. 10/09/2020 11:00:52 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1029. 10/09/2020 11:00:53 AM ERROR Traceback (most recent call last):
  1030. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
  1031. inst.parse_content()
  1032. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 91, in parse_content
  1033. with open('file_cache/%s' % self.file_name, 'wb') as code:
  1034. FileNotFoundError: [Errno 2] No such file or directory: 'file_cache/脚本模板-时间+客户+功能点.docx'
  1035. 10/09/2020 11:01:59 AM INFO simhash similarity service started at 2020-10-09 11:01:59
  1036. 10/09/2020 11:01:59 AM INFO simhash similarity service started successfully at 2020-10-09 11:01:59
  1037. 10/09/2020 11:02:02 AM INFO ******************************************** NEW REQUEST ********************************************
  1038. 10/09/2020 11:02:02 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1039. 10/09/2020 11:02:02 AM ERROR Traceback (most recent call last):
  1040. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
  1041. inst.parse_content()
  1042. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 90, in parse_content
  1043. with open('file_cache/%s' % self.file_name, 'wb') as code:
  1044. FileNotFoundError: [Errno 2] No such file or directory: 'file_cache/脚本模板-时间+客户+功能点.docx'
  1045. 10/09/2020 11:03:50 AM INFO simhash similarity service started at 2020-10-09 11:03:50
  1046. 10/09/2020 11:03:50 AM INFO simhash similarity service started successfully at 2020-10-09 11:03:50
  1047. 10/09/2020 11:03:55 AM INFO ******************************************** NEW REQUEST ********************************************
  1048. 10/09/2020 11:03:55 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1049. 10/09/2020 11:03:55 AM ERROR Traceback (most recent call last):
  1050. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
  1051. inst.parse_content()
  1052. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 90, in parse_content
  1053. with open('file_cache/%s' % self.file_name, 'w') as code:
  1054. FileNotFoundError: [Errno 2] No such file or directory: 'file_cache/脚本模板-时间+客户+功能点.docx'
  1055. 10/09/2020 11:04:27 AM INFO simhash similarity service started at 2020-10-09 11:04:27
  1056. 10/09/2020 11:04:27 AM INFO simhash similarity service started successfully at 2020-10-09 11:04:27
  1057. 10/09/2020 11:04:30 AM INFO ******************************************** NEW REQUEST ********************************************
  1058. 10/09/2020 11:04:30 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1059. 10/09/2020 11:04:30 AM ERROR Traceback (most recent call last):
  1060. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
  1061. inst.parse_content()
  1062. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 91, in parse_content
  1063. with open('file_cache/%s' % self.file_name, 'w') as code:
  1064. FileNotFoundError: [Errno 2] No such file or directory: 'file_cache/脚本模板-时间+客户+功能点.docx'
  1065. 10/09/2020 11:04:55 AM INFO simhash similarity service started at 2020-10-09 11:04:55
  1066. 10/09/2020 11:04:55 AM INFO simhash similarity service started successfully at 2020-10-09 11:04:55
  1067. 10/09/2020 11:05:00 AM INFO ******************************************** NEW REQUEST ********************************************
  1068. 10/09/2020 11:05:00 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1069. 10/09/2020 11:05:01 AM ERROR Traceback (most recent call last):
  1070. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
  1071. inst.parse_content()
  1072. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 91, in parse_content
  1073. with open('./file_cache/%s' % self.file_name, 'w') as code:
  1074. FileNotFoundError: [Errno 2] No such file or directory: './file_cache/脚本模板-时间+客户+功能点.docx'
  1075. 10/09/2020 11:08:35 AM INFO simhash similarity service started at 2020-10-09 11:08:35
  1076. 10/09/2020 11:08:35 AM INFO simhash similarity service started successfully at 2020-10-09 11:08:35
  1077. 10/09/2020 11:08:42 AM INFO ******************************************** NEW REQUEST ********************************************
  1078. 10/09/2020 11:08:42 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1079. 10/09/2020 11:08:43 AM ERROR Traceback (most recent call last):
  1080. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
  1081. inst.parse_content()
  1082. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 91, in parse_content
  1083. with open('.\file_cache\%s' % self.file_name, 'w') as code:
  1084. OSError: [Errno 22] Invalid argument: '.\x0cile_cache\\脚本模板-时间+客户+功能点.docx'
  1085. 10/09/2020 11:10:43 AM INFO simhash similarity service started at 2020-10-09 11:10:43
  1086. 10/09/2020 11:10:43 AM INFO simhash similarity service started successfully at 2020-10-09 11:10:43
  1087. 10/09/2020 11:10:46 AM INFO ******************************************** NEW REQUEST ********************************************
  1088. 10/09/2020 11:10:46 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1089. 10/09/2020 11:10:46 AM ERROR Traceback (most recent call last):
  1090. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
  1091. inst.parse_content()
  1092. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 90, in parse_content
  1093. with open('./file_cache/%s' % self.file_name, 'wb') as code:
  1094. FileNotFoundError: [Errno 2] No such file or directory: './file_cache/脚本模板-时间+客户+功能点.docx'
  1095. 10/09/2020 11:14:00 AM INFO simhash similarity service started at 2020-10-09 11:14:00
  1096. 10/09/2020 11:14:00 AM INFO simhash similarity service started successfully at 2020-10-09 11:14:00
  1097. 10/09/2020 11:14:02 AM INFO ******************************************** NEW REQUEST ********************************************
  1098. 10/09/2020 11:14:02 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1099. 10/09/2020 11:14:02 AM ERROR Traceback (most recent call last):
  1100. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
  1101. inst.parse_content()
  1102. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 92, in parse_content
  1103. with open('./file_cache/%s' % self.file_name, 'wb') as code:
  1104. FileNotFoundError: [Errno 2] No such file or directory: './file_cache/脚本模板-时间+客户+功能点.docx'
  1105. 10/09/2020 11:16:18 AM INFO simhash similarity service started at 2020-10-09 11:16:18
  1106. 10/09/2020 11:16:18 AM INFO simhash similarity service started successfully at 2020-10-09 11:16:18
  1107. 10/09/2020 11:16:20 AM INFO ******************************************** NEW REQUEST ********************************************
  1108. 10/09/2020 11:16:20 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1109. 10/09/2020 11:16:21 AM ERROR Traceback (most recent call last):
  1110. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
  1111. inst.parse_content()
  1112. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 94, in parse_content
  1113. doc = docx.Document('file_cache/%s' % self.file_name)
  1114. File "D:\anaconda3\envs\simhash\lib\site-packages\docx\api.py", line 25, in Document
  1115. document_part = Package.open(docx).main_document_part
  1116. File "D:\anaconda3\envs\simhash\lib\site-packages\docx\opc\package.py", line 128, in open
  1117. pkg_reader = PackageReader.from_file(pkg_file)
  1118. File "D:\anaconda3\envs\simhash\lib\site-packages\docx\opc\pkgreader.py", line 32, in from_file
  1119. phys_reader = PhysPkgReader(pkg_file)
  1120. File "D:\anaconda3\envs\simhash\lib\site-packages\docx\opc\phys_pkg.py", line 31, in __new__
  1121. "Package not found at '%s'" % pkg_file
  1122. docx.opc.exceptions.PackageNotFoundError: Package not found at 'file_cache/脚本模板-时间+客户+功能点.docx'
  1123. 10/09/2020 11:16:56 AM INFO simhash similarity service started at 2020-10-09 11:16:56
  1124. 10/09/2020 11:16:56 AM INFO simhash similarity service started successfully at 2020-10-09 11:16:56
  1125. 10/09/2020 11:17:07 AM INFO ******************************************** NEW REQUEST ********************************************
  1126. 10/09/2020 11:17:07 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1127. 10/09/2020 11:17:08 AM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1128. 10/09/2020 11:17:08 AM ERROR Traceback (most recent call last):
  1129. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 42, in post
  1130. inst.get_simhash()
  1131. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 99, in get_simhash
  1132. sim = SimHash(self.content, self.topK)
  1133. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 121, in __init__
  1134. self.sim_hash()
  1135. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 132, in sim_hash
  1136. keyword_weight = jieba.analyse.extract_tags("|".join(seg_list), 30, withWeight=True)
  1137. AttributeError: module 'jieba' has no attribute 'analyse'
  1138. 10/09/2020 11:41:30 AM INFO simhash similarity service started at 2020-10-09 11:41:30
  1139. 10/09/2020 11:41:30 AM INFO simhash similarity service started successfully at 2020-10-09 11:41:30
  1140. 10/09/2020 11:41:33 AM INFO ******************************************** NEW REQUEST ********************************************
  1141. 10/09/2020 11:41:33 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1142. 10/09/2020 11:41:33 AM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1143. 10/09/2020 11:41:34 AM INFO the simhash is 1100011010010011110110111101110011010001001100101000100111111000
  1144. 10/09/2020 11:41:34 AM INFO the keyword and weight is [('看车', 0.5475466031862595), ('3d', 0.5475466031862595), ('懂车帝', 0.3650310687908397), ('车帝', 0.18251553439541984), ('懂车分', 0.18251553439541984), ('录屏', 0.18251553439541984), ('明天', 0.14698989454396946), ('图片', 0.14598088714419846), ('爱车', 0.1453229162946565), ('底价', 0.1410265428680916), ('点击', 0.13483623587419846), ('这里', 0.10247685700419848), ('太帅', 0.10082084329312978), ('手机', 0.09422628745221373), ('音效', 0.09382625755343511), ('选车', 0.09125776719770992), ('选买', 0.09125776719770992), ('连车', 0.09125776719770992), ('我用', 0.09125776719770992), ('懂车', 0.09125776719770992)]
  1145. 10/09/2020 11:41:34 AM ERROR Traceback (most recent call last):
  1146. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  1147. cursor, statement, parameters, context
  1148. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  1149. cursor.execute(statement, parameters)
  1150. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  1151. result = self._query(query)
  1152. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  1153. conn.query(q)
  1154. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  1155. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1156. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  1157. result.read()
  1158. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  1159. first_packet = self.connection._read_packet()
  1160. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  1161. packet.check_error()
  1162. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  1163. err.raise_mysql_exception(self._data)
  1164. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  1165. raise errorclass(errno, errval)
  1166. pymysql.err.InternalError: (1054, "Unknown column 'file_name' in 'field list'")
  1167. The above exception was the direct cause of the following exception:
  1168. Traceback (most recent call last):
  1169. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 48, in post
  1170. inst.write_db()
  1171. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 113, in write_db
  1172. res_df.to_sql(name='ctop_script_fingerprint', con=engine, if_exists='append', index=False)
  1173. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 2612, in to_sql
  1174. method=method,
  1175. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 598, in to_sql
  1176. method=method,
  1177. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1406, in to_sql
  1178. raise err
  1179. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1398, in to_sql
  1180. table.insert(chunksize, method=method)
  1181. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 830, in insert
  1182. exec_insert(conn, keys, chunk_iter)
  1183. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 747, in _execute_insert
  1184. conn.execute(self.table.insert(), data)
  1185. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
  1186. return meth(self, multiparams, params)
  1187. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
  1188. return connection._execute_clauseelement(self, multiparams, params)
  1189. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
  1190. distilled_params,
  1191. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  1192. e, statement, parameters, cursor, context
  1193. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  1194. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  1195. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  1196. raise exception
  1197. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  1198. cursor, statement, parameters, context
  1199. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  1200. cursor.execute(statement, parameters)
  1201. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  1202. result = self._query(query)
  1203. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  1204. conn.query(q)
  1205. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  1206. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1207. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  1208. result.read()
  1209. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  1210. first_packet = self.connection._read_packet()
  1211. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  1212. packet.check_error()
  1213. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  1214. err.raise_mysql_exception(self._data)
  1215. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  1216. raise errorclass(errno, errval)
  1217. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'file_name' in 'field list'")
  1218. [SQL: INSERT INTO ctop_script_fingerprint (id, file_name, finger_print, create_time) VALUES (%(id)s, %(file_name)s, %(finger_print)s, %(create_time)s)]
  1219. [parameters: {'id': '3996ca5cb3957e624c10e996af155837', 'file_name': '脚本模板-时间+客户+功能点.docx', 'finger_print': '1100011010010011110110111101110011010001001100101000100111111000', 'create_time': datetime.datetime(2020, 10, 9, 11, 41, 34, 310166)}]
  1220. (Background on this error at: http://sqlalche.me/e/13/2j85)
  1221. 10/09/2020 11:44:27 AM INFO simhash similarity service started at 2020-10-09 11:44:27
  1222. 10/09/2020 11:44:27 AM INFO simhash similarity service started successfully at 2020-10-09 11:44:27
  1223. 10/09/2020 11:44:32 AM INFO ******************************************** NEW REQUEST ********************************************
  1224. 10/09/2020 11:44:32 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1225. 10/09/2020 11:44:33 AM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1226. 10/09/2020 11:44:34 AM INFO the simhash is 1100011010010011110110111101110011010001001100101000100111111000
  1227. 10/09/2020 11:44:34 AM INFO the keyword and weight is [('看车', 0.5475466031862595), ('3d', 0.5475466031862595), ('懂车帝', 0.3650310687908397), ('车帝', 0.18251553439541984), ('懂车分', 0.18251553439541984), ('录屏', 0.18251553439541984), ('明天', 0.14698989454396946), ('图片', 0.14598088714419846), ('爱车', 0.1453229162946565), ('底价', 0.1410265428680916), ('点击', 0.13483623587419846), ('这里', 0.10247685700419848), ('太帅', 0.10082084329312978), ('手机', 0.09422628745221373), ('音效', 0.09382625755343511), ('选车', 0.09125776719770992), ('选买', 0.09125776719770992), ('连车', 0.09125776719770992), ('我用', 0.09125776719770992), ('懂车', 0.09125776719770992)]
  1228. 10/09/2020 11:44:34 AM INFO write to database has completed !
  1229. 10/09/2020 11:53:43 AM INFO simhash similarity service started at 2020-10-09 11:53:43
  1230. 10/09/2020 11:53:43 AM INFO simhash similarity service started successfully at 2020-10-09 11:53:43
  1231. 10/09/2020 11:53:46 AM INFO ******************************************** NEW REQUEST ********************************************
  1232. 10/09/2020 11:53:46 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1233. 10/09/2020 11:53:47 AM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1234. 10/09/2020 11:53:48 AM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1235. 10/09/2020 11:53:48 AM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1236. 10/09/2020 11:53:48 AM ERROR Traceback (most recent call last):
  1237. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  1238. cursor, statement, parameters, context
  1239. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  1240. cursor.execute(statement, parameters)
  1241. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  1242. result = self._query(query)
  1243. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  1244. conn.query(q)
  1245. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  1246. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1247. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  1248. result.read()
  1249. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  1250. first_packet = self.connection._read_packet()
  1251. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  1252. packet.check_error()
  1253. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  1254. err.raise_mysql_exception(self._data)
  1255. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  1256. raise errorclass(errno, errval)
  1257. pymysql.err.IntegrityError: (1062, "Duplicate entry '3996ca5cb3957e624c10e996af155837' for key 'ctop_script_fingerprint.PRIMARY'")
  1258. The above exception was the direct cause of the following exception:
  1259. Traceback (most recent call last):
  1260. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 50, in post
  1261. inst.write_db()
  1262. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 115, in write_db
  1263. res_df.to_sql(name='ctop_script_fingerprint', con=engine, if_exists='append', index=False)
  1264. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 2612, in to_sql
  1265. method=method,
  1266. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 598, in to_sql
  1267. method=method,
  1268. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1406, in to_sql
  1269. raise err
  1270. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1398, in to_sql
  1271. table.insert(chunksize, method=method)
  1272. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 830, in insert
  1273. exec_insert(conn, keys, chunk_iter)
  1274. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 747, in _execute_insert
  1275. conn.execute(self.table.insert(), data)
  1276. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
  1277. return meth(self, multiparams, params)
  1278. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
  1279. return connection._execute_clauseelement(self, multiparams, params)
  1280. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
  1281. distilled_params,
  1282. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  1283. e, statement, parameters, cursor, context
  1284. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  1285. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  1286. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  1287. raise exception
  1288. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  1289. cursor, statement, parameters, context
  1290. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  1291. cursor.execute(statement, parameters)
  1292. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  1293. result = self._query(query)
  1294. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  1295. conn.query(q)
  1296. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  1297. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1298. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  1299. result.read()
  1300. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  1301. first_packet = self.connection._read_packet()
  1302. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  1303. packet.check_error()
  1304. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  1305. err.raise_mysql_exception(self._data)
  1306. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  1307. raise errorclass(errno, errval)
  1308. sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError) (1062, "Duplicate entry '3996ca5cb3957e624c10e996af155837' for key 'ctop_script_fingerprint.PRIMARY'")
  1309. [SQL: INSERT INTO ctop_script_fingerprint (id, file_name, finger_print, create_time) VALUES (%(id)s, %(file_name)s, %(finger_print)s, %(create_time)s)]
  1310. [parameters: {'id': '3996ca5cb3957e624c10e996af155837', 'file_name': '脚本模板-时间+客户+功能点.docx', 'finger_print': '1101011000010011110110111101110111010001001100101000010111111001', 'create_time': datetime.datetime(2020, 10, 9, 11, 53, 48, 180377)}]
  1311. (Background on this error at: http://sqlalche.me/e/13/gkpj)
  1312. 10/09/2020 03:58:45 PM INFO simhash similarity service started at 2020-10-09 15:58:45
  1313. 10/09/2020 03:58:45 PM INFO simhash similarity service started successfully at 2020-10-09 15:58:45
  1314. 10/09/2020 03:58:51 PM INFO ******************************************** NEW REQUEST ********************************************
  1315. 10/09/2020 03:58:51 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1316. 10/09/2020 03:58:51 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1317. 10/09/2020 03:58:52 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1318. 10/09/2020 03:58:52 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1319. 10/09/2020 03:58:52 PM INFO write to database has completed !
  1320. 10/09/2020 03:59:12 PM ERROR Traceback (most recent call last):
  1321. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1322. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1323. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__
  1324. self.get_similarity_scripts()
  1325. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 191, in get_similarity_scripts
  1326. df['distance'] = df['finger_print'].apply(lambda x: self.hamming_dis(x))
  1327. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\series.py", line 4200, in apply
  1328. mapped = lib.map_infer(values, f, convert=convert_dtype)
  1329. File "pandas\_libs\lib.pyx", line 2401, in pandas._libs.lib.map_infer
  1330. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 191, in <lambda>
  1331. df['distance'] = df['finger_print'].apply(lambda x: self.hamming_dis(x))
  1332. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 203, in hamming_dis
  1333. h2 = '0b' + another_finger_print
  1334. TypeError: can only concatenate str (not "bytes") to str
  1335. 10/09/2020 05:59:27 PM INFO simhash similarity service started at 2020-10-09 17:59:27
  1336. 10/09/2020 05:59:27 PM INFO simhash similarity service started successfully at 2020-10-09 17:59:27
  1337. 10/09/2020 05:59:33 PM INFO ******************************************** NEW REQUEST ********************************************
  1338. 10/09/2020 05:59:33 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1339. 10/09/2020 05:59:33 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1340. 10/09/2020 05:59:34 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1341. 10/09/2020 05:59:34 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1342. 10/09/2020 05:59:34 PM ERROR Traceback (most recent call last):
  1343. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  1344. cursor, statement, parameters, context
  1345. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  1346. cursor.execute(statement, parameters)
  1347. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  1348. result = self._query(query)
  1349. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  1350. conn.query(q)
  1351. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  1352. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1353. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  1354. result.read()
  1355. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  1356. first_packet = self.connection._read_packet()
  1357. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  1358. packet.check_error()
  1359. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  1360. err.raise_mysql_exception(self._data)
  1361. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  1362. raise errorclass(errno, errval)
  1363. pymysql.err.IntegrityError: (1062, "Duplicate entry '3996ca5cb3957e624c10e996af155837' for key 'ctop_script_fingerprint.PRIMARY'")
  1364. The above exception was the direct cause of the following exception:
  1365. Traceback (most recent call last):
  1366. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 50, in post
  1367. inst.write_db()
  1368. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 115, in write_db
  1369. res_df.to_sql(name='ctop_script_fingerprint', con=engine, if_exists='append', index=False)
  1370. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 2612, in to_sql
  1371. method=method,
  1372. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 598, in to_sql
  1373. method=method,
  1374. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1406, in to_sql
  1375. raise err
  1376. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1398, in to_sql
  1377. table.insert(chunksize, method=method)
  1378. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 830, in insert
  1379. exec_insert(conn, keys, chunk_iter)
  1380. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 747, in _execute_insert
  1381. conn.execute(self.table.insert(), data)
  1382. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
  1383. return meth(self, multiparams, params)
  1384. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
  1385. return connection._execute_clauseelement(self, multiparams, params)
  1386. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
  1387. distilled_params,
  1388. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  1389. e, statement, parameters, cursor, context
  1390. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  1391. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  1392. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  1393. raise exception
  1394. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  1395. cursor, statement, parameters, context
  1396. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  1397. cursor.execute(statement, parameters)
  1398. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  1399. result = self._query(query)
  1400. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  1401. conn.query(q)
  1402. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  1403. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1404. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  1405. result.read()
  1406. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  1407. first_packet = self.connection._read_packet()
  1408. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  1409. packet.check_error()
  1410. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  1411. err.raise_mysql_exception(self._data)
  1412. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  1413. raise errorclass(errno, errval)
  1414. sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError) (1062, "Duplicate entry '3996ca5cb3957e624c10e996af155837' for key 'ctop_script_fingerprint.PRIMARY'")
  1415. [SQL: INSERT INTO ctop_script_fingerprint (id, file_name, finger_print, create_time) VALUES (%(id)s, %(file_name)s, %(finger_print)s, %(create_time)s)]
  1416. [parameters: {'id': '3996ca5cb3957e624c10e996af155837', 'file_name': '脚本模板-时间+客户+功能点.docx', 'finger_print': '1101011000010011110110111101110111010001001100101000010111111001', 'create_time': datetime.datetime(2020, 10, 9, 17, 59, 34, 153183)}]
  1417. (Background on this error at: http://sqlalche.me/e/13/gkpj)
  1418. 10/09/2020 06:02:50 PM INFO simhash similarity service started at 2020-10-09 18:02:50
  1419. 10/09/2020 06:02:50 PM INFO simhash similarity service started successfully at 2020-10-09 18:02:50
  1420. 10/09/2020 06:02:54 PM INFO ******************************************** NEW REQUEST ********************************************
  1421. 10/09/2020 06:02:54 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1422. 10/09/2020 06:02:55 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1423. 10/09/2020 06:02:55 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1424. 10/09/2020 06:02:55 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1425. 10/09/2020 06:02:55 PM INFO write to database has completed !
  1426. 10/09/2020 06:03:04 PM ERROR Traceback (most recent call last):
  1427. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1428. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1429. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
  1430. self.get_similarity_scripts()
  1431. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 190, in get_similarity_scripts
  1432. df['distance'] = df['finger_print'].apply(lambda x: self.hamming_dis(x))
  1433. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\series.py", line 4200, in apply
  1434. mapped = lib.map_infer(values, f, convert=convert_dtype)
  1435. File "pandas\_libs\lib.pyx", line 2401, in pandas._libs.lib.map_infer
  1436. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 190, in <lambda>
  1437. df['distance'] = df['finger_print'].apply(lambda x: self.hamming_dis(x))
  1438. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 205, in hamming_dis
  1439. h2 = '0b' + another_finger_print
  1440. TypeError: can only concatenate str (not "NoneType") to str
  1441. 10/09/2020 06:05:15 PM INFO simhash similarity service started at 2020-10-09 18:05:15
  1442. 10/09/2020 06:05:15 PM INFO simhash similarity service started successfully at 2020-10-09 18:05:15
  1443. 10/09/2020 06:07:50 PM INFO simhash similarity service started at 2020-10-09 18:07:50
  1444. 10/09/2020 06:07:50 PM INFO simhash similarity service started successfully at 2020-10-09 18:07:50
  1445. 10/09/2020 06:07:55 PM INFO ******************************************** NEW REQUEST ********************************************
  1446. 10/09/2020 06:07:55 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1447. 10/09/2020 06:07:56 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1448. 10/09/2020 06:07:56 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1449. 10/09/2020 06:07:56 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1450. 10/09/2020 06:07:56 PM INFO write to database has completed !
  1451. 10/09/2020 06:08:05 PM ERROR Traceback (most recent call last):
  1452. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
  1453. return self._engine.get_loc(casted_key)
  1454. File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  1455. File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
  1456. File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
  1457. File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
  1458. KeyError: 0
  1459. The above exception was the direct cause of the following exception:
  1460. Traceback (most recent call last):
  1461. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1462. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1463. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
  1464. self.get_similarity_scripts()
  1465. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 196, in get_similarity_scripts
  1466. self.similarity_scripts.append((sim_df.loc[i, 'file_name'],
  1467. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
  1468. return self._getitem_tuple(key)
  1469. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
  1470. return self._getitem_lowerdim(tup)
  1471. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
  1472. section = self._getitem_axis(key, axis=i)
  1473. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
  1474. return self._get_label(key, axis=axis)
  1475. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
  1476. return self.obj.xs(label, axis=axis)
  1477. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
  1478. loc = self.index.get_loc(key)
  1479. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
  1480. raise KeyError(key) from err
  1481. KeyError: 0
  1482. 10/09/2020 06:08:58 PM INFO simhash similarity service started at 2020-10-09 18:08:58
  1483. 10/09/2020 06:08:58 PM INFO simhash similarity service started successfully at 2020-10-09 18:08:58
  1484. 10/09/2020 06:09:11 PM INFO simhash similarity service started at 2020-10-09 18:09:11
  1485. 10/09/2020 06:09:11 PM INFO simhash similarity service started successfully at 2020-10-09 18:09:11
  1486. 10/09/2020 06:09:14 PM INFO ******************************************** NEW REQUEST ********************************************
  1487. 10/09/2020 06:09:14 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1488. 10/09/2020 06:09:15 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1489. 10/09/2020 06:09:16 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1490. 10/09/2020 06:09:16 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1491. 10/09/2020 06:09:16 PM INFO write to database has completed !
  1492. 10/09/2020 06:09:29 PM ERROR Traceback (most recent call last):
  1493. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
  1494. return self._engine.get_loc(casted_key)
  1495. File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  1496. File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
  1497. File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
  1498. File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
  1499. KeyError: 0
  1500. The above exception was the direct cause of the following exception:
  1501. Traceback (most recent call last):
  1502. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1503. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1504. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
  1505. self.get_similarity_scripts()
  1506. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 196, in get_similarity_scripts
  1507. self.similarity_scripts.append((sim_df.loc[i, 'file_name'],
  1508. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
  1509. return self._getitem_tuple(key)
  1510. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
  1511. return self._getitem_lowerdim(tup)
  1512. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
  1513. section = self._getitem_axis(key, axis=i)
  1514. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
  1515. return self._get_label(key, axis=axis)
  1516. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
  1517. return self.obj.xs(label, axis=axis)
  1518. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
  1519. loc = self.index.get_loc(key)
  1520. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
  1521. raise KeyError(key) from err
  1522. KeyError: 0
  1523. 10/09/2020 06:10:03 PM INFO simhash similarity service started at 2020-10-09 18:10:03
  1524. 10/09/2020 06:10:03 PM INFO simhash similarity service started successfully at 2020-10-09 18:10:03
  1525. 10/09/2020 06:25:50 PM INFO simhash similarity service started at 2020-10-09 18:25:50
  1526. 10/09/2020 06:25:50 PM INFO simhash similarity service started successfully at 2020-10-09 18:25:50
  1527. 10/09/2020 06:26:15 PM INFO ******************************************** NEW REQUEST ********************************************
  1528. 10/09/2020 06:26:15 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1529. 10/09/2020 06:26:15 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1530. 10/09/2020 06:26:16 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1531. 10/09/2020 06:26:16 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1532. 10/09/2020 06:26:16 PM INFO write to database has completed !
  1533. 10/09/2020 06:27:42 PM ERROR Traceback (most recent call last):
  1534. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
  1535. return self._engine.get_loc(casted_key)
  1536. File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  1537. File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
  1538. File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
  1539. File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
  1540. KeyError: 0
  1541. The above exception was the direct cause of the following exception:
  1542. Traceback (most recent call last):
  1543. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1544. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1545. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
  1546. self.get_similarity_scripts()
  1547. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 196, in get_similarity_scripts
  1548. self.similarity_scripts.append((sim_df.loc[i, 'file_name'],
  1549. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
  1550. return self._getitem_tuple(key)
  1551. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
  1552. return self._getitem_lowerdim(tup)
  1553. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
  1554. section = self._getitem_axis(key, axis=i)
  1555. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
  1556. return self._get_label(key, axis=axis)
  1557. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
  1558. return self.obj.xs(label, axis=axis)
  1559. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
  1560. loc = self.index.get_loc(key)
  1561. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
  1562. raise KeyError(key) from err
  1563. KeyError: 0
  1564. 10/09/2020 06:30:12 PM INFO simhash similarity service started at 2020-10-09 18:30:12
  1565. 10/09/2020 06:30:12 PM INFO simhash similarity service started successfully at 2020-10-09 18:30:12
  1566. 10/09/2020 06:30:46 PM INFO simhash similarity service started at 2020-10-09 18:30:46
  1567. 10/09/2020 06:30:46 PM INFO simhash similarity service started successfully at 2020-10-09 18:30:46
  1568. 10/09/2020 06:30:48 PM INFO ******************************************** NEW REQUEST ********************************************
  1569. 10/09/2020 06:30:48 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1570. 10/09/2020 06:30:49 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1571. 10/09/2020 06:30:49 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1572. 10/09/2020 06:30:49 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1573. 10/09/2020 06:30:49 PM INFO write to database has completed !
  1574. 10/09/2020 06:30:58 PM ERROR Traceback (most recent call last):
  1575. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
  1576. return self._engine.get_loc(casted_key)
  1577. File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  1578. File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
  1579. File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
  1580. File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
  1581. KeyError: 0
  1582. The above exception was the direct cause of the following exception:
  1583. Traceback (most recent call last):
  1584. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1585. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1586. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
  1587. self.get_similarity_scripts()
  1588. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 196, in get_similarity_scripts
  1589. self.similarity_scripts.append((sim_df.loc[i, 'file_name'],
  1590. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
  1591. return self._getitem_tuple(key)
  1592. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
  1593. return self._getitem_lowerdim(tup)
  1594. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
  1595. section = self._getitem_axis(key, axis=i)
  1596. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
  1597. return self._get_label(key, axis=axis)
  1598. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
  1599. return self.obj.xs(label, axis=axis)
  1600. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
  1601. loc = self.index.get_loc(key)
  1602. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
  1603. raise KeyError(key) from err
  1604. KeyError: 0
  1605. 10/09/2020 06:34:08 PM INFO simhash similarity service started at 2020-10-09 18:34:08
  1606. 10/09/2020 06:34:08 PM INFO simhash similarity service started successfully at 2020-10-09 18:34:08
  1607. 10/09/2020 06:34:15 PM INFO ******************************************** NEW REQUEST ********************************************
  1608. 10/09/2020 06:34:15 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1609. 10/09/2020 06:34:16 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1610. 10/09/2020 06:34:16 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1611. 10/09/2020 06:34:16 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1612. 10/09/2020 06:34:16 PM INFO write to database has completed !
  1613. 10/09/2020 06:34:25 PM ERROR Traceback (most recent call last):
  1614. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
  1615. return self._engine.get_loc(casted_key)
  1616. File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  1617. File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
  1618. File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
  1619. File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
  1620. KeyError: 0
  1621. The above exception was the direct cause of the following exception:
  1622. Traceback (most recent call last):
  1623. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1624. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1625. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
  1626. self.get_similarity_scripts()
  1627. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 197, in get_similarity_scripts
  1628. sim_list.append((sim_df.loc[i, 'file_name'],
  1629. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
  1630. return self._getitem_tuple(key)
  1631. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
  1632. return self._getitem_lowerdim(tup)
  1633. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
  1634. section = self._getitem_axis(key, axis=i)
  1635. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
  1636. return self._get_label(key, axis=axis)
  1637. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
  1638. return self.obj.xs(label, axis=axis)
  1639. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
  1640. loc = self.index.get_loc(key)
  1641. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
  1642. raise KeyError(key) from err
  1643. KeyError: 0
  1644. 10/09/2020 06:36:54 PM INFO simhash similarity service started at 2020-10-09 18:36:54
  1645. 10/09/2020 06:36:54 PM INFO simhash similarity service started successfully at 2020-10-09 18:36:54
  1646. 10/09/2020 06:37:00 PM INFO ******************************************** NEW REQUEST ********************************************
  1647. 10/09/2020 06:37:00 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1648. 10/09/2020 06:37:01 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1649. 10/09/2020 06:37:01 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1650. 10/09/2020 06:37:01 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1651. 10/09/2020 06:37:01 PM INFO write to database has completed !
  1652. 10/09/2020 06:37:16 PM ERROR Traceback (most recent call last):
  1653. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
  1654. return self._engine.get_loc(casted_key)
  1655. File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  1656. File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
  1657. File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
  1658. File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
  1659. KeyError: 0
  1660. The above exception was the direct cause of the following exception:
  1661. Traceback (most recent call last):
  1662. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1663. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1664. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
  1665. self.get_similarity_scripts()
  1666. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 197, in get_similarity_scripts
  1667. sim_list.append((sim_df.loc[i, 'file_name'],
  1668. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
  1669. return self._getitem_tuple(key)
  1670. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
  1671. return self._getitem_lowerdim(tup)
  1672. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
  1673. section = self._getitem_axis(key, axis=i)
  1674. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
  1675. return self._get_label(key, axis=axis)
  1676. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
  1677. return self.obj.xs(label, axis=axis)
  1678. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
  1679. loc = self.index.get_loc(key)
  1680. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
  1681. raise KeyError(key) from err
  1682. KeyError: 0
  1683. 10/09/2020 06:40:36 PM INFO simhash similarity service started at 2020-10-09 18:40:36
  1684. 10/09/2020 06:40:36 PM INFO simhash similarity service started successfully at 2020-10-09 18:40:36
  1685. 10/09/2020 06:40:37 PM INFO ******************************************** NEW REQUEST ********************************************
  1686. 10/09/2020 06:40:37 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1687. 10/09/2020 06:40:38 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1688. 10/09/2020 06:40:38 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1689. 10/09/2020 06:40:38 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1690. 10/09/2020 06:40:38 PM INFO write to database has completed !
  1691. 10/09/2020 06:40:47 PM ERROR Traceback (most recent call last):
  1692. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
  1693. return self._engine.get_loc(casted_key)
  1694. File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  1695. File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
  1696. File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
  1697. File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
  1698. KeyError: 0
  1699. The above exception was the direct cause of the following exception:
  1700. Traceback (most recent call last):
  1701. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1702. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1703. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
  1704. self.get_similarity_scripts()
  1705. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 197, in get_similarity_scripts
  1706. sim_list.append((sim_df.loc[i, 'file_name'],
  1707. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
  1708. return self._getitem_tuple(key)
  1709. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
  1710. return self._getitem_lowerdim(tup)
  1711. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
  1712. section = self._getitem_axis(key, axis=i)
  1713. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
  1714. return self._get_label(key, axis=axis)
  1715. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
  1716. return self.obj.xs(label, axis=axis)
  1717. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
  1718. loc = self.index.get_loc(key)
  1719. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
  1720. raise KeyError(key) from err
  1721. KeyError: 0
  1722. 10/09/2020 06:45:06 PM INFO simhash similarity service started at 2020-10-09 18:45:06
  1723. 10/09/2020 06:45:06 PM INFO simhash similarity service started successfully at 2020-10-09 18:45:06
  1724. 10/09/2020 06:45:27 PM INFO ******************************************** NEW REQUEST ********************************************
  1725. 10/09/2020 06:45:27 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1726. 10/09/2020 06:45:27 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1727. 10/09/2020 06:45:28 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1728. 10/09/2020 06:45:28 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1729. 10/09/2020 06:45:28 PM INFO write to database has completed !
  1730. 10/09/2020 06:46:58 PM ERROR Traceback (most recent call last):
  1731. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
  1732. return self._engine.get_loc(casted_key)
  1733. File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  1734. File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
  1735. File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
  1736. File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
  1737. KeyError: 0
  1738. The above exception was the direct cause of the following exception:
  1739. Traceback (most recent call last):
  1740. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1741. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1742. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__
  1743. self.get_similarity_scripts()
  1744. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts
  1745. sim_list.append((sim_df.loc[i, 'file_name'],
  1746. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
  1747. return self._getitem_tuple(key)
  1748. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
  1749. return self._getitem_lowerdim(tup)
  1750. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
  1751. section = self._getitem_axis(key, axis=i)
  1752. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
  1753. return self._get_label(key, axis=axis)
  1754. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
  1755. return self.obj.xs(label, axis=axis)
  1756. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
  1757. loc = self.index.get_loc(key)
  1758. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
  1759. raise KeyError(key) from err
  1760. KeyError: 0
  1761. 10/09/2020 06:47:51 PM INFO simhash similarity service started at 2020-10-09 18:47:51
  1762. 10/09/2020 06:47:51 PM INFO simhash similarity service started successfully at 2020-10-09 18:47:51
  1763. 10/09/2020 06:47:58 PM INFO ******************************************** NEW REQUEST ********************************************
  1764. 10/09/2020 06:47:58 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1765. 10/09/2020 06:47:59 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1766. 10/09/2020 06:48:00 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1767. 10/09/2020 06:48:00 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1768. 10/09/2020 06:48:00 PM INFO write to database has completed !
  1769. 10/09/2020 06:48:47 PM ERROR Traceback (most recent call last):
  1770. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
  1771. return self._engine.get_loc(casted_key)
  1772. File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  1773. File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
  1774. File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
  1775. File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
  1776. KeyError: 0
  1777. The above exception was the direct cause of the following exception:
  1778. Traceback (most recent call last):
  1779. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1780. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1781. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__
  1782. self.get_similarity_scripts()
  1783. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts
  1784. sim_list.append((sim_df.loc[i, 'file_name'],
  1785. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
  1786. return self._getitem_tuple(key)
  1787. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
  1788. return self._getitem_lowerdim(tup)
  1789. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
  1790. section = self._getitem_axis(key, axis=i)
  1791. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
  1792. return self._get_label(key, axis=axis)
  1793. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
  1794. return self.obj.xs(label, axis=axis)
  1795. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
  1796. loc = self.index.get_loc(key)
  1797. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
  1798. raise KeyError(key) from err
  1799. KeyError: 0
  1800. 10/09/2020 06:50:58 PM INFO simhash similarity service started at 2020-10-09 18:50:58
  1801. 10/09/2020 06:50:58 PM INFO simhash similarity service started successfully at 2020-10-09 18:50:58
  1802. 10/09/2020 06:50:59 PM INFO ******************************************** NEW REQUEST ********************************************
  1803. 10/09/2020 06:50:59 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1804. 10/09/2020 06:51:00 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1805. 10/09/2020 06:51:00 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1806. 10/09/2020 06:51:00 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1807. 10/09/2020 06:51:00 PM INFO write to database has completed !
  1808. 10/09/2020 06:51:35 PM ERROR Traceback (most recent call last):
  1809. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
  1810. return self._engine.get_loc(casted_key)
  1811. File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  1812. File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
  1813. File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
  1814. File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
  1815. KeyError: 0
  1816. The above exception was the direct cause of the following exception:
  1817. Traceback (most recent call last):
  1818. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1819. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1820. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__
  1821. self.get_similarity_scripts()
  1822. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts
  1823. sim_list.append((sim_df.loc[i, 'file_name'],
  1824. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
  1825. return self._getitem_tuple(key)
  1826. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
  1827. return self._getitem_lowerdim(tup)
  1828. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
  1829. section = self._getitem_axis(key, axis=i)
  1830. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
  1831. return self._get_label(key, axis=axis)
  1832. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
  1833. return self.obj.xs(label, axis=axis)
  1834. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
  1835. loc = self.index.get_loc(key)
  1836. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
  1837. raise KeyError(key) from err
  1838. KeyError: 0
  1839. 10/09/2020 06:55:45 PM INFO simhash similarity service started at 2020-10-09 18:55:45
  1840. 10/09/2020 06:55:45 PM INFO simhash similarity service started successfully at 2020-10-09 18:55:45
  1841. 10/09/2020 06:55:46 PM INFO ******************************************** NEW REQUEST ********************************************
  1842. 10/09/2020 06:55:46 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1843. 10/09/2020 06:55:47 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1844. 10/09/2020 06:55:47 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1845. 10/09/2020 06:55:47 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1846. 10/09/2020 06:55:47 PM INFO write to database has completed !
  1847. 10/09/2020 06:56:59 PM ERROR Traceback (most recent call last):
  1848. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
  1849. return self._engine.get_loc(casted_key)
  1850. File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  1851. File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
  1852. File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
  1853. File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
  1854. KeyError: 0
  1855. The above exception was the direct cause of the following exception:
  1856. Traceback (most recent call last):
  1857. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1858. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1859. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__
  1860. self.get_similarity_scripts()
  1861. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts
  1862. print((sim_df.loc[i, 'file_name'],
  1863. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
  1864. return self._getitem_tuple(key)
  1865. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
  1866. return self._getitem_lowerdim(tup)
  1867. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
  1868. section = self._getitem_axis(key, axis=i)
  1869. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
  1870. return self._get_label(key, axis=axis)
  1871. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
  1872. return self.obj.xs(label, axis=axis)
  1873. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
  1874. loc = self.index.get_loc(key)
  1875. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
  1876. raise KeyError(key) from err
  1877. KeyError: 0
  1878. 10/09/2020 06:58:04 PM INFO simhash similarity service started at 2020-10-09 18:58:04
  1879. 10/09/2020 06:58:04 PM INFO simhash similarity service started successfully at 2020-10-09 18:58:04
  1880. 10/09/2020 06:58:04 PM INFO ******************************************** NEW REQUEST ********************************************
  1881. 10/09/2020 06:58:04 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1882. 10/09/2020 06:58:05 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1883. 10/09/2020 06:58:05 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1884. 10/09/2020 06:58:05 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1885. 10/09/2020 06:58:05 PM INFO write to database has completed !
  1886. 10/09/2020 06:59:19 PM ERROR Traceback (most recent call last):
  1887. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
  1888. return self._engine.get_loc(casted_key)
  1889. File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  1890. File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
  1891. File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
  1892. File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
  1893. KeyError: 0
  1894. The above exception was the direct cause of the following exception:
  1895. Traceback (most recent call last):
  1896. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1897. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1898. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__
  1899. self.get_similarity_scripts()
  1900. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts
  1901. print((sim_df.loc[i, 'file_name'],
  1902. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
  1903. return self._getitem_tuple(key)
  1904. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
  1905. return self._getitem_lowerdim(tup)
  1906. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
  1907. section = self._getitem_axis(key, axis=i)
  1908. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
  1909. return self._get_label(key, axis=axis)
  1910. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
  1911. return self.obj.xs(label, axis=axis)
  1912. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
  1913. loc = self.index.get_loc(key)
  1914. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
  1915. raise KeyError(key) from err
  1916. KeyError: 0
  1917. 10/09/2020 07:01:20 PM INFO simhash similarity service started at 2020-10-09 19:01:20
  1918. 10/09/2020 07:01:20 PM INFO simhash similarity service started successfully at 2020-10-09 19:01:20
  1919. 10/09/2020 07:01:37 PM INFO ******************************************** NEW REQUEST ********************************************
  1920. 10/09/2020 07:01:37 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
  1921. 10/09/2020 07:01:38 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
  1922. 10/09/2020 07:01:39 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
  1923. 10/09/2020 07:01:39 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)]
  1924. 10/09/2020 07:01:39 PM INFO write to database has completed !
  1925. 10/09/2020 07:05:18 PM ERROR Traceback (most recent call last):
  1926. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
  1927. return self._engine.get_loc(casted_key)
  1928. File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  1929. File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
  1930. File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
  1931. File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
  1932. KeyError: 0
  1933. The above exception was the direct cause of the following exception:
  1934. Traceback (most recent call last):
  1935. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
  1936. simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
  1937. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__
  1938. self.get_similarity_scripts()
  1939. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts
  1940. print((sim_df.loc[i, 'file_name']))
  1941. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
  1942. return self._getitem_tuple(key)
  1943. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
  1944. return self._getitem_lowerdim(tup)
  1945. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
  1946. section = self._getitem_axis(key, axis=i)
  1947. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
  1948. return self._get_label(key, axis=axis)
  1949. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
  1950. return self.obj.xs(label, axis=axis)
  1951. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
  1952. loc = self.index.get_loc(key)
  1953. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
  1954. raise KeyError(key) from err
  1955. KeyError: 0