12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057 |
- 10/09/2020 10:05:35 AM INFO simhash similarity service started at 2020-10-09 10:05:35
- 10/09/2020 10:05:35 AM INFO simhash similarity service started successfully at 2020-10-09 10:05:35
- 10/09/2020 10:05:56 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 10:05:56 AM INFO the md5 of request script is 123
- 10/09/2020 10:05:56 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
- df = pd.read_sql(sql, engine)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
- chunksize=chunksize,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
- result = self.execute(*args)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
- *args, **kwargs
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
- return connection.execute(statement, *multiparams, **params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
- return self._execute_text(object_, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
- parameters,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
- [SQL: select * from ctop_script_file where id = self.script_md5 ]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 10:06:22 AM INFO simhash similarity service started at 2020-10-09 10:06:22
- 10/09/2020 10:06:22 AM INFO simhash similarity service started successfully at 2020-10-09 10:06:22
- 10/09/2020 10:06:45 AM INFO simhash similarity service started at 2020-10-09 10:06:45
- 10/09/2020 10:06:45 AM INFO simhash similarity service started successfully at 2020-10-09 10:06:45
- 10/09/2020 10:07:04 AM INFO simhash similarity service started at 2020-10-09 10:07:04
- 10/09/2020 10:07:04 AM INFO simhash similarity service started successfully at 2020-10-09 10:07:04
- 10/09/2020 10:07:09 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 10:07:09 AM INFO the md5 of request script is 12323
- 10/09/2020 10:07:09 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
- df = pd.read_sql(sql, engine)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
- chunksize=chunksize,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
- result = self.execute(*args)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
- *args, **kwargs
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
- return connection.execute(statement, *multiparams, **params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
- return self._execute_text(object_, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
- parameters,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
- [SQL: select * from ctop_script_file where id = self.script_md5 ]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 10:08:21 AM INFO simhash similarity service started at 2020-10-09 10:08:21
- 10/09/2020 10:08:21 AM INFO simhash similarity service started successfully at 2020-10-09 10:08:21
- 10/09/2020 10:14:06 AM INFO simhash similarity service started at 2020-10-09 10:14:06
- 10/09/2020 10:14:06 AM INFO simhash similarity service started successfully at 2020-10-09 10:14:06
- 10/09/2020 10:14:22 AM INFO simhash similarity service started at 2020-10-09 10:14:22
- 10/09/2020 10:14:22 AM INFO simhash similarity service started successfully at 2020-10-09 10:14:22
- 10/09/2020 10:15:32 AM INFO simhash similarity service started at 2020-10-09 10:15:32
- 10/09/2020 10:15:32 AM INFO simhash similarity service started successfully at 2020-10-09 10:15:32
- 10/09/2020 10:17:48 AM INFO simhash similarity service started at 2020-10-09 10:17:48
- 10/09/2020 10:17:48 AM INFO simhash similarity service started successfully at 2020-10-09 10:17:48
- 10/09/2020 10:17:52 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 10:17:52 AM INFO the md5 of request script is 12323
- 10/09/2020 10:17:52 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
- df = pd.read_sql(sql, engine)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
- chunksize=chunksize,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
- result = self.execute(*args)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
- *args, **kwargs
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
- return connection.execute(statement, *multiparams, **params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
- return self._execute_text(object_, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
- parameters,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
- [SQL: select * from ctop_script_file where id = self.script_md5 ]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 10:18:02 AM INFO simhash similarity service started at 2020-10-09 10:18:02
- 10/09/2020 10:18:02 AM INFO simhash similarity service started successfully at 2020-10-09 10:18:02
- 10/09/2020 10:18:03 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 10:18:03 AM INFO the md5 of request script is 12323
- 10/09/2020 10:18:03 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
- df = pd.read_sql(sql, engine)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
- chunksize=chunksize,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
- result = self.execute(*args)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
- *args, **kwargs
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
- return connection.execute(statement, *multiparams, **params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
- return self._execute_text(object_, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
- parameters,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
- [SQL: select * from ctop_script_file where id = self.script_md5 ]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 10:18:14 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 10:18:14 AM INFO the md5 of request script is 12323a
- 10/09/2020 10:18:14 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
- df = pd.read_sql(sql, engine)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
- chunksize=chunksize,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
- result = self.execute(*args)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
- *args, **kwargs
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
- return connection.execute(statement, *multiparams, **params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
- return self._execute_text(object_, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
- parameters,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
- [SQL: select * from ctop_script_file where id = self.script_md5 ]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 10:18:19 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 10:18:19 AM INFO the md5 of request script is 12323ab
- 10/09/2020 10:18:19 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
- df = pd.read_sql(sql, engine)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
- chunksize=chunksize,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
- result = self.execute(*args)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
- *args, **kwargs
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
- return connection.execute(statement, *multiparams, **params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
- return self._execute_text(object_, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
- parameters,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
- [SQL: select * from ctop_script_file where id = self.script_md5 ]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 10:18:23 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 10:18:23 AM INFO the md5 of request script is 12323abccc
- 10/09/2020 10:18:23 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
- df = pd.read_sql(sql, engine)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
- chunksize=chunksize,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
- result = self.execute(*args)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
- *args, **kwargs
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
- return connection.execute(statement, *multiparams, **params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
- return self._execute_text(object_, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
- parameters,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
- [SQL: select * from ctop_script_file where id = self.script_md5 ]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 10:18:58 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 10:18:58 AM INFO the md5 of request script is 12323abccc
- 10/09/2020 10:18:58 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
- df = pd.read_sql(sql, engine)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
- chunksize=chunksize,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
- result = self.execute(*args)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
- *args, **kwargs
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
- return connection.execute(statement, *multiparams, **params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
- return self._execute_text(object_, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
- parameters,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
- [SQL: select * from ctop_script_file where id = self.script_md5 ]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 10:19:05 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 10:19:05 AM INFO the md5 of request script is 12323abccc
- 10/09/2020 10:19:05 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
- df = pd.read_sql(sql, engine)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
- chunksize=chunksize,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
- result = self.execute(*args)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
- *args, **kwargs
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
- return connection.execute(statement, *multiparams, **params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
- return self._execute_text(object_, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
- parameters,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
- [SQL: select * from ctop_script_file where id = self.script_md5 ]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 10:19:09 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 10:19:09 AM INFO the md5 of request script is 12323abccc123
- 10/09/2020 10:19:09 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
- df = pd.read_sql(sql, engine)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
- chunksize=chunksize,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
- result = self.execute(*args)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
- *args, **kwargs
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
- return connection.execute(statement, *multiparams, **params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
- return self._execute_text(object_, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
- parameters,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
- [SQL: select * from ctop_script_file where id = self.script_md5 ]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 10:19:22 AM INFO simhash similarity service started at 2020-10-09 10:19:22
- 10/09/2020 10:19:22 AM INFO simhash similarity service started successfully at 2020-10-09 10:19:22
- 10/09/2020 10:19:30 AM INFO simhash similarity service started at 2020-10-09 10:19:30
- 10/09/2020 10:19:30 AM INFO simhash similarity service started successfully at 2020-10-09 10:19:30
- 10/09/2020 10:19:32 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 10:19:32 AM INFO the md5 of request script is 12323abccc123
- 10/09/2020 10:19:33 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
- df = pd.read_sql(sql, engine)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
- chunksize=chunksize,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
- result = self.execute(*args)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
- *args, **kwargs
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
- return connection.execute(statement, *multiparams, **params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
- return self._execute_text(object_, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
- parameters,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
- [SQL: select * from ctop_script_file where id = self.script_md5 ]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 10:55:14 AM INFO simhash similarity service started at 2020-10-09 10:55:14
- 10/09/2020 10:55:14 AM INFO simhash similarity service started successfully at 2020-10-09 10:55:14
- 10/09/2020 10:55:21 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 10:55:21 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 10/09/2020 10:55:21 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 86, in parse_content
- df = pd.read_sql(sql, engine)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
- chunksize=chunksize,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
- result = self.execute(*args)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
- *args, **kwargs
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
- return connection.execute(statement, *multiparams, **params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
- return self._execute_text(object_, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
- parameters,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
- [SQL: select * from ctop_script_file where id = self.script_md5 ]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 10:57:15 AM INFO simhash similarity service started at 2020-10-09 10:57:15
- 10/09/2020 10:57:15 AM INFO simhash similarity service started successfully at 2020-10-09 10:57:15
- 10/09/2020 10:57:20 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 10:57:20 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 10/09/2020 10:57:20 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column '3996ca5cb3957e624c10e996af155837' in 'where clause'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 86, in parse_content
- df = pd.read_sql(sql, engine)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
- chunksize=chunksize,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
- result = self.execute(*args)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
- *args, **kwargs
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
- return connection.execute(statement, *multiparams, **params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
- return self._execute_text(object_, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
- parameters,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column '3996ca5cb3957e624c10e996af155837' in 'where clause'")
- [SQL: select * from ctop_script_file where id = 3996ca5cb3957e624c10e996af155837 ]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 11:00:23 AM INFO simhash similarity service started at 2020-10-09 11:00:23
- 10/09/2020 11:00:23 AM INFO simhash similarity service started successfully at 2020-10-09 11:00:23
- 10/09/2020 11:00:26 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 11:00:26 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 10/09/2020 11:00:26 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column '3996ca5cb3957e624c10e996af155837' in 'where clause'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
- df = pd.read_sql(sql, engine)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
- chunksize=chunksize,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
- result = self.execute(*args)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
- *args, **kwargs
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
- return connection.execute(statement, *multiparams, **params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
- return self._execute_text(object_, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
- parameters,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
- cursor, statement, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
- cursor.execute(statement)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column '3996ca5cb3957e624c10e996af155837' in 'where clause'")
- [SQL: select * from ctop_script_file where id = 3996ca5cb3957e624c10e996af155837 ]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 11:00:48 AM INFO simhash similarity service started at 2020-10-09 11:00:48
- 10/09/2020 11:00:48 AM INFO simhash similarity service started successfully at 2020-10-09 11:00:48
- 10/09/2020 11:00:52 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 11:00:52 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 10/09/2020 11:00:53 AM ERROR Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 91, in parse_content
- with open('file_cache/%s' % self.file_name, 'wb') as code:
- FileNotFoundError: [Errno 2] No such file or directory: 'file_cache/脚本模板-时间+客户+功能点.docx'
- 10/09/2020 11:01:59 AM INFO simhash similarity service started at 2020-10-09 11:01:59
- 10/09/2020 11:01:59 AM INFO simhash similarity service started successfully at 2020-10-09 11:01:59
- 10/09/2020 11:02:02 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 11:02:02 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 10/09/2020 11:02:02 AM ERROR Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 90, in parse_content
- with open('file_cache/%s' % self.file_name, 'wb') as code:
- FileNotFoundError: [Errno 2] No such file or directory: 'file_cache/脚本模板-时间+客户+功能点.docx'
- 10/09/2020 11:03:50 AM INFO simhash similarity service started at 2020-10-09 11:03:50
- 10/09/2020 11:03:50 AM INFO simhash similarity service started successfully at 2020-10-09 11:03:50
- 10/09/2020 11:03:55 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 11:03:55 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 10/09/2020 11:03:55 AM ERROR Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 90, in parse_content
- with open('file_cache/%s' % self.file_name, 'w') as code:
- FileNotFoundError: [Errno 2] No such file or directory: 'file_cache/脚本模板-时间+客户+功能点.docx'
- 10/09/2020 11:04:27 AM INFO simhash similarity service started at 2020-10-09 11:04:27
- 10/09/2020 11:04:27 AM INFO simhash similarity service started successfully at 2020-10-09 11:04:27
- 10/09/2020 11:04:30 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 11:04:30 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 10/09/2020 11:04:30 AM ERROR Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 91, in parse_content
- with open('file_cache/%s' % self.file_name, 'w') as code:
- FileNotFoundError: [Errno 2] No such file or directory: 'file_cache/脚本模板-时间+客户+功能点.docx'
- 10/09/2020 11:04:55 AM INFO simhash similarity service started at 2020-10-09 11:04:55
- 10/09/2020 11:04:55 AM INFO simhash similarity service started successfully at 2020-10-09 11:04:55
- 10/09/2020 11:05:00 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 11:05:00 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 10/09/2020 11:05:01 AM ERROR Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 91, in parse_content
- with open('./file_cache/%s' % self.file_name, 'w') as code:
- FileNotFoundError: [Errno 2] No such file or directory: './file_cache/脚本模板-时间+客户+功能点.docx'
- 10/09/2020 11:08:35 AM INFO simhash similarity service started at 2020-10-09 11:08:35
- 10/09/2020 11:08:35 AM INFO simhash similarity service started successfully at 2020-10-09 11:08:35
- 10/09/2020 11:08:42 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 11:08:42 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 10/09/2020 11:08:43 AM ERROR Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 91, in parse_content
- with open('.\file_cache\%s' % self.file_name, 'w') as code:
- OSError: [Errno 22] Invalid argument: '.\x0cile_cache\\脚本模板-时间+客户+功能点.docx'
- 10/09/2020 11:10:43 AM INFO simhash similarity service started at 2020-10-09 11:10:43
- 10/09/2020 11:10:43 AM INFO simhash similarity service started successfully at 2020-10-09 11:10:43
- 10/09/2020 11:10:46 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 11:10:46 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 10/09/2020 11:10:46 AM ERROR Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 90, in parse_content
- with open('./file_cache/%s' % self.file_name, 'wb') as code:
- FileNotFoundError: [Errno 2] No such file or directory: './file_cache/脚本模板-时间+客户+功能点.docx'
- 10/09/2020 11:14:00 AM INFO simhash similarity service started at 2020-10-09 11:14:00
- 10/09/2020 11:14:00 AM INFO simhash similarity service started successfully at 2020-10-09 11:14:00
- 10/09/2020 11:14:02 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 11:14:02 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 10/09/2020 11:14:02 AM ERROR Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 92, in parse_content
- with open('./file_cache/%s' % self.file_name, 'wb') as code:
- FileNotFoundError: [Errno 2] No such file or directory: './file_cache/脚本模板-时间+客户+功能点.docx'
- 10/09/2020 11:16:18 AM INFO simhash similarity service started at 2020-10-09 11:16:18
- 10/09/2020 11:16:18 AM INFO simhash similarity service started successfully at 2020-10-09 11:16:18
- 10/09/2020 11:16:20 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 11:16:20 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 10/09/2020 11:16:21 AM ERROR Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post
- inst.parse_content()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 94, in parse_content
- doc = docx.Document('file_cache/%s' % self.file_name)
- File "D:\anaconda3\envs\simhash\lib\site-packages\docx\api.py", line 25, in Document
- document_part = Package.open(docx).main_document_part
- File "D:\anaconda3\envs\simhash\lib\site-packages\docx\opc\package.py", line 128, in open
- pkg_reader = PackageReader.from_file(pkg_file)
- File "D:\anaconda3\envs\simhash\lib\site-packages\docx\opc\pkgreader.py", line 32, in from_file
- phys_reader = PhysPkgReader(pkg_file)
- File "D:\anaconda3\envs\simhash\lib\site-packages\docx\opc\phys_pkg.py", line 31, in __new__
- "Package not found at '%s'" % pkg_file
- docx.opc.exceptions.PackageNotFoundError: Package not found at 'file_cache/脚本模板-时间+客户+功能点.docx'
- 10/09/2020 11:16:56 AM INFO simhash similarity service started at 2020-10-09 11:16:56
- 10/09/2020 11:16:56 AM INFO simhash similarity service started successfully at 2020-10-09 11:16:56
- 10/09/2020 11:17:07 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 11:17:07 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 11:17:08 AM ERROR Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 42, in post
- inst.get_simhash()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 99, in get_simhash
- sim = SimHash(self.content, self.topK)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 121, in __init__
- self.sim_hash()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 132, in sim_hash
- keyword_weight = jieba.analyse.extract_tags("|".join(seg_list), 30, withWeight=True)
- AttributeError: module 'jieba' has no attribute 'analyse'
- 10/09/2020 11:41:30 AM INFO simhash similarity service started at 2020-10-09 11:41:30
- 10/09/2020 11:41:30 AM INFO simhash similarity service started successfully at 2020-10-09 11:41:30
- 10/09/2020 11:41:33 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 11:41:33 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 11:41:34 AM INFO the simhash is 1100011010010011110110111101110011010001001100101000100111111000
- 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)]
- 10/09/2020 11:41:34 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1054, "Unknown column 'file_name' in 'field list'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 48, in post
- inst.write_db()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 113, in write_db
- res_df.to_sql(name='ctop_script_fingerprint', con=engine, if_exists='append', index=False)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 2612, in to_sql
- method=method,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 598, in to_sql
- method=method,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1406, in to_sql
- raise err
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1398, in to_sql
- table.insert(chunksize, method=method)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 830, in insert
- exec_insert(conn, keys, chunk_iter)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 747, in _execute_insert
- conn.execute(self.table.insert(), data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
- return meth(self, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
- return connection._execute_clauseelement(self, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
- distilled_params,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'file_name' in 'field list'")
- [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)]
- [parameters: {'id': '3996ca5cb3957e624c10e996af155837', 'file_name': '脚本模板-时间+客户+功能点.docx', 'finger_print': '1100011010010011110110111101110011010001001100101000100111111000', 'create_time': datetime.datetime(2020, 10, 9, 11, 41, 34, 310166)}]
- (Background on this error at: http://sqlalche.me/e/13/2j85)
- 10/09/2020 11:44:27 AM INFO simhash similarity service started at 2020-10-09 11:44:27
- 10/09/2020 11:44:27 AM INFO simhash similarity service started successfully at 2020-10-09 11:44:27
- 10/09/2020 11:44:32 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 11:44:32 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 11:44:34 AM INFO the simhash is 1100011010010011110110111101110011010001001100101000100111111000
- 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)]
- 10/09/2020 11:44:34 AM INFO write to database has completed !
- 10/09/2020 11:53:43 AM INFO simhash similarity service started at 2020-10-09 11:53:43
- 10/09/2020 11:53:43 AM INFO simhash similarity service started successfully at 2020-10-09 11:53:43
- 10/09/2020 11:53:46 AM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 11:53:46 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 11:53:48 AM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 11:53:48 AM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.IntegrityError: (1062, "Duplicate entry '3996ca5cb3957e624c10e996af155837' for key 'ctop_script_fingerprint.PRIMARY'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 50, in post
- inst.write_db()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 115, in write_db
- res_df.to_sql(name='ctop_script_fingerprint', con=engine, if_exists='append', index=False)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 2612, in to_sql
- method=method,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 598, in to_sql
- method=method,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1406, in to_sql
- raise err
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1398, in to_sql
- table.insert(chunksize, method=method)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 830, in insert
- exec_insert(conn, keys, chunk_iter)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 747, in _execute_insert
- conn.execute(self.table.insert(), data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
- return meth(self, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
- return connection._execute_clauseelement(self, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
- distilled_params,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError) (1062, "Duplicate entry '3996ca5cb3957e624c10e996af155837' for key 'ctop_script_fingerprint.PRIMARY'")
- [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)]
- [parameters: {'id': '3996ca5cb3957e624c10e996af155837', 'file_name': '脚本模板-时间+客户+功能点.docx', 'finger_print': '1101011000010011110110111101110111010001001100101000010111111001', 'create_time': datetime.datetime(2020, 10, 9, 11, 53, 48, 180377)}]
- (Background on this error at: http://sqlalche.me/e/13/gkpj)
- 10/09/2020 03:58:45 PM INFO simhash similarity service started at 2020-10-09 15:58:45
- 10/09/2020 03:58:45 PM INFO simhash similarity service started successfully at 2020-10-09 15:58:45
- 10/09/2020 03:58:51 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 03:58:51 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 03:58:52 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 03:58:52 PM INFO write to database has completed !
- 10/09/2020 03:59:12 PM ERROR Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 191, in get_similarity_scripts
- df['distance'] = df['finger_print'].apply(lambda x: self.hamming_dis(x))
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\series.py", line 4200, in apply
- mapped = lib.map_infer(values, f, convert=convert_dtype)
- File "pandas\_libs\lib.pyx", line 2401, in pandas._libs.lib.map_infer
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 191, in <lambda>
- df['distance'] = df['finger_print'].apply(lambda x: self.hamming_dis(x))
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 203, in hamming_dis
- h2 = '0b' + another_finger_print
- TypeError: can only concatenate str (not "bytes") to str
- 10/09/2020 05:59:27 PM INFO simhash similarity service started at 2020-10-09 17:59:27
- 10/09/2020 05:59:27 PM INFO simhash similarity service started successfully at 2020-10-09 17:59:27
- 10/09/2020 05:59:33 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 05:59:33 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 05:59:34 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 05:59:34 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.IntegrityError: (1062, "Duplicate entry '3996ca5cb3957e624c10e996af155837' for key 'ctop_script_fingerprint.PRIMARY'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 50, in post
- inst.write_db()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 115, in write_db
- res_df.to_sql(name='ctop_script_fingerprint', con=engine, if_exists='append', index=False)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 2612, in to_sql
- method=method,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 598, in to_sql
- method=method,
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1406, in to_sql
- raise err
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1398, in to_sql
- table.insert(chunksize, method=method)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 830, in insert
- exec_insert(conn, keys, chunk_iter)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 747, in _execute_insert
- conn.execute(self.table.insert(), data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
- return meth(self, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
- return connection._execute_clauseelement(self, multiparams, params)
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
- distilled_params,
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
- conn.query(q)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
- packet.check_error()
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError) (1062, "Duplicate entry '3996ca5cb3957e624c10e996af155837' for key 'ctop_script_fingerprint.PRIMARY'")
- [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)]
- [parameters: {'id': '3996ca5cb3957e624c10e996af155837', 'file_name': '脚本模板-时间+客户+功能点.docx', 'finger_print': '1101011000010011110110111101110111010001001100101000010111111001', 'create_time': datetime.datetime(2020, 10, 9, 17, 59, 34, 153183)}]
- (Background on this error at: http://sqlalche.me/e/13/gkpj)
- 10/09/2020 06:02:50 PM INFO simhash similarity service started at 2020-10-09 18:02:50
- 10/09/2020 06:02:50 PM INFO simhash similarity service started successfully at 2020-10-09 18:02:50
- 10/09/2020 06:02:54 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 06:02:54 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 06:02:55 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 06:02:55 PM INFO write to database has completed !
- 10/09/2020 06:03:04 PM ERROR Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 190, in get_similarity_scripts
- df['distance'] = df['finger_print'].apply(lambda x: self.hamming_dis(x))
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\series.py", line 4200, in apply
- mapped = lib.map_infer(values, f, convert=convert_dtype)
- File "pandas\_libs\lib.pyx", line 2401, in pandas._libs.lib.map_infer
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 190, in <lambda>
- df['distance'] = df['finger_print'].apply(lambda x: self.hamming_dis(x))
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 205, in hamming_dis
- h2 = '0b' + another_finger_print
- TypeError: can only concatenate str (not "NoneType") to str
- 10/09/2020 06:05:15 PM INFO simhash similarity service started at 2020-10-09 18:05:15
- 10/09/2020 06:05:15 PM INFO simhash similarity service started successfully at 2020-10-09 18:05:15
- 10/09/2020 06:07:50 PM INFO simhash similarity service started at 2020-10-09 18:07:50
- 10/09/2020 06:07:50 PM INFO simhash similarity service started successfully at 2020-10-09 18:07:50
- 10/09/2020 06:07:55 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 06:07:55 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 06:07:56 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 06:07:56 PM INFO write to database has completed !
- 10/09/2020 06:08:05 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
- return self._engine.get_loc(casted_key)
- File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
- File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
- KeyError: 0
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 196, in get_similarity_scripts
- self.similarity_scripts.append((sim_df.loc[i, 'file_name'],
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
- return self._getitem_tuple(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
- return self._getitem_lowerdim(tup)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
- section = self._getitem_axis(key, axis=i)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
- return self._get_label(key, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
- return self.obj.xs(label, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
- loc = self.index.get_loc(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
- raise KeyError(key) from err
- KeyError: 0
- 10/09/2020 06:08:58 PM INFO simhash similarity service started at 2020-10-09 18:08:58
- 10/09/2020 06:08:58 PM INFO simhash similarity service started successfully at 2020-10-09 18:08:58
- 10/09/2020 06:09:11 PM INFO simhash similarity service started at 2020-10-09 18:09:11
- 10/09/2020 06:09:11 PM INFO simhash similarity service started successfully at 2020-10-09 18:09:11
- 10/09/2020 06:09:14 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 06:09:14 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 06:09:16 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 06:09:16 PM INFO write to database has completed !
- 10/09/2020 06:09:29 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
- return self._engine.get_loc(casted_key)
- File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
- File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
- KeyError: 0
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 196, in get_similarity_scripts
- self.similarity_scripts.append((sim_df.loc[i, 'file_name'],
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
- return self._getitem_tuple(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
- return self._getitem_lowerdim(tup)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
- section = self._getitem_axis(key, axis=i)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
- return self._get_label(key, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
- return self.obj.xs(label, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
- loc = self.index.get_loc(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
- raise KeyError(key) from err
- KeyError: 0
- 10/09/2020 06:10:03 PM INFO simhash similarity service started at 2020-10-09 18:10:03
- 10/09/2020 06:10:03 PM INFO simhash similarity service started successfully at 2020-10-09 18:10:03
- 10/09/2020 06:25:50 PM INFO simhash similarity service started at 2020-10-09 18:25:50
- 10/09/2020 06:25:50 PM INFO simhash similarity service started successfully at 2020-10-09 18:25:50
- 10/09/2020 06:26:15 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 06:26:15 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 06:26:16 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 06:26:16 PM INFO write to database has completed !
- 10/09/2020 06:27:42 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
- return self._engine.get_loc(casted_key)
- File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
- File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
- KeyError: 0
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 196, in get_similarity_scripts
- self.similarity_scripts.append((sim_df.loc[i, 'file_name'],
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
- return self._getitem_tuple(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
- return self._getitem_lowerdim(tup)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
- section = self._getitem_axis(key, axis=i)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
- return self._get_label(key, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
- return self.obj.xs(label, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
- loc = self.index.get_loc(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
- raise KeyError(key) from err
- KeyError: 0
- 10/09/2020 06:30:12 PM INFO simhash similarity service started at 2020-10-09 18:30:12
- 10/09/2020 06:30:12 PM INFO simhash similarity service started successfully at 2020-10-09 18:30:12
- 10/09/2020 06:30:46 PM INFO simhash similarity service started at 2020-10-09 18:30:46
- 10/09/2020 06:30:46 PM INFO simhash similarity service started successfully at 2020-10-09 18:30:46
- 10/09/2020 06:30:48 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 06:30:48 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 06:30:49 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 06:30:49 PM INFO write to database has completed !
- 10/09/2020 06:30:58 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
- return self._engine.get_loc(casted_key)
- File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
- File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
- KeyError: 0
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 196, in get_similarity_scripts
- self.similarity_scripts.append((sim_df.loc[i, 'file_name'],
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
- return self._getitem_tuple(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
- return self._getitem_lowerdim(tup)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
- section = self._getitem_axis(key, axis=i)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
- return self._get_label(key, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
- return self.obj.xs(label, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
- loc = self.index.get_loc(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
- raise KeyError(key) from err
- KeyError: 0
- 10/09/2020 06:34:08 PM INFO simhash similarity service started at 2020-10-09 18:34:08
- 10/09/2020 06:34:08 PM INFO simhash similarity service started successfully at 2020-10-09 18:34:08
- 10/09/2020 06:34:15 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 06:34:15 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 06:34:16 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 06:34:16 PM INFO write to database has completed !
- 10/09/2020 06:34:25 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
- return self._engine.get_loc(casted_key)
- File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
- File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
- KeyError: 0
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 197, in get_similarity_scripts
- sim_list.append((sim_df.loc[i, 'file_name'],
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
- return self._getitem_tuple(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
- return self._getitem_lowerdim(tup)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
- section = self._getitem_axis(key, axis=i)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
- return self._get_label(key, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
- return self.obj.xs(label, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
- loc = self.index.get_loc(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
- raise KeyError(key) from err
- KeyError: 0
- 10/09/2020 06:36:54 PM INFO simhash similarity service started at 2020-10-09 18:36:54
- 10/09/2020 06:36:54 PM INFO simhash similarity service started successfully at 2020-10-09 18:36:54
- 10/09/2020 06:37:00 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 06:37:00 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 06:37:01 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 06:37:01 PM INFO write to database has completed !
- 10/09/2020 06:37:16 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
- return self._engine.get_loc(casted_key)
- File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
- File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
- KeyError: 0
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 197, in get_similarity_scripts
- sim_list.append((sim_df.loc[i, 'file_name'],
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
- return self._getitem_tuple(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
- return self._getitem_lowerdim(tup)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
- section = self._getitem_axis(key, axis=i)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
- return self._get_label(key, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
- return self.obj.xs(label, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
- loc = self.index.get_loc(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
- raise KeyError(key) from err
- KeyError: 0
- 10/09/2020 06:40:36 PM INFO simhash similarity service started at 2020-10-09 18:40:36
- 10/09/2020 06:40:36 PM INFO simhash similarity service started successfully at 2020-10-09 18:40:36
- 10/09/2020 06:40:37 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 06:40:37 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 06:40:38 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 06:40:38 PM INFO write to database has completed !
- 10/09/2020 06:40:47 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
- return self._engine.get_loc(casted_key)
- File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
- File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
- KeyError: 0
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 197, in get_similarity_scripts
- sim_list.append((sim_df.loc[i, 'file_name'],
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
- return self._getitem_tuple(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
- return self._getitem_lowerdim(tup)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
- section = self._getitem_axis(key, axis=i)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
- return self._get_label(key, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
- return self.obj.xs(label, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
- loc = self.index.get_loc(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
- raise KeyError(key) from err
- KeyError: 0
- 10/09/2020 06:45:06 PM INFO simhash similarity service started at 2020-10-09 18:45:06
- 10/09/2020 06:45:06 PM INFO simhash similarity service started successfully at 2020-10-09 18:45:06
- 10/09/2020 06:45:27 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 06:45:27 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 06:45:28 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 06:45:28 PM INFO write to database has completed !
- 10/09/2020 06:46:58 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
- return self._engine.get_loc(casted_key)
- File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
- File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
- KeyError: 0
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts
- sim_list.append((sim_df.loc[i, 'file_name'],
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
- return self._getitem_tuple(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
- return self._getitem_lowerdim(tup)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
- section = self._getitem_axis(key, axis=i)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
- return self._get_label(key, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
- return self.obj.xs(label, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
- loc = self.index.get_loc(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
- raise KeyError(key) from err
- KeyError: 0
- 10/09/2020 06:47:51 PM INFO simhash similarity service started at 2020-10-09 18:47:51
- 10/09/2020 06:47:51 PM INFO simhash similarity service started successfully at 2020-10-09 18:47:51
- 10/09/2020 06:47:58 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 06:47:58 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 06:48:00 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 06:48:00 PM INFO write to database has completed !
- 10/09/2020 06:48:47 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
- return self._engine.get_loc(casted_key)
- File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
- File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
- KeyError: 0
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts
- sim_list.append((sim_df.loc[i, 'file_name'],
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
- return self._getitem_tuple(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
- return self._getitem_lowerdim(tup)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
- section = self._getitem_axis(key, axis=i)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
- return self._get_label(key, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
- return self.obj.xs(label, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
- loc = self.index.get_loc(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
- raise KeyError(key) from err
- KeyError: 0
- 10/09/2020 06:50:58 PM INFO simhash similarity service started at 2020-10-09 18:50:58
- 10/09/2020 06:50:58 PM INFO simhash similarity service started successfully at 2020-10-09 18:50:58
- 10/09/2020 06:50:59 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 06:50:59 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 06:51:00 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 06:51:00 PM INFO write to database has completed !
- 10/09/2020 06:51:35 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
- return self._engine.get_loc(casted_key)
- File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
- File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
- KeyError: 0
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts
- sim_list.append((sim_df.loc[i, 'file_name'],
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
- return self._getitem_tuple(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
- return self._getitem_lowerdim(tup)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
- section = self._getitem_axis(key, axis=i)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
- return self._get_label(key, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
- return self.obj.xs(label, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
- loc = self.index.get_loc(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
- raise KeyError(key) from err
- KeyError: 0
- 10/09/2020 06:55:45 PM INFO simhash similarity service started at 2020-10-09 18:55:45
- 10/09/2020 06:55:45 PM INFO simhash similarity service started successfully at 2020-10-09 18:55:45
- 10/09/2020 06:55:46 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 06:55:46 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 06:55:47 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 06:55:47 PM INFO write to database has completed !
- 10/09/2020 06:56:59 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
- return self._engine.get_loc(casted_key)
- File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
- File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
- KeyError: 0
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts
- print((sim_df.loc[i, 'file_name'],
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
- return self._getitem_tuple(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
- return self._getitem_lowerdim(tup)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
- section = self._getitem_axis(key, axis=i)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
- return self._get_label(key, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
- return self.obj.xs(label, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
- loc = self.index.get_loc(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
- raise KeyError(key) from err
- KeyError: 0
- 10/09/2020 06:58:04 PM INFO simhash similarity service started at 2020-10-09 18:58:04
- 10/09/2020 06:58:04 PM INFO simhash similarity service started successfully at 2020-10-09 18:58:04
- 10/09/2020 06:58:04 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 06:58:04 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 06:58:05 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 06:58:05 PM INFO write to database has completed !
- 10/09/2020 06:59:19 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
- return self._engine.get_loc(casted_key)
- File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
- File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
- KeyError: 0
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts
- print((sim_df.loc[i, 'file_name'],
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
- return self._getitem_tuple(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
- return self._getitem_lowerdim(tup)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
- section = self._getitem_axis(key, axis=i)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
- return self._get_label(key, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
- return self.obj.xs(label, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
- loc = self.index.get_loc(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
- raise KeyError(key) from err
- KeyError: 0
- 10/09/2020 07:01:20 PM INFO simhash similarity service started at 2020-10-09 19:01:20
- 10/09/2020 07:01:20 PM INFO simhash similarity service started successfully at 2020-10-09 19:01:20
- 10/09/2020 07:01:37 PM INFO ******************************************** NEW REQUEST ********************************************
- 10/09/2020 07:01:37 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837
- 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看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。
- 10/09/2020 07:01:39 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001
- 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)]
- 10/09/2020 07:01:39 PM INFO write to database has completed !
- 10/09/2020 07:05:18 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc
- return self._engine.get_loc(casted_key)
- File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item
- File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item
- KeyError: 0
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post
- simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print)
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__
- self.get_similarity_scripts()
- File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts
- print((sim_df.loc[i, 'file_name']))
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__
- return self._getitem_tuple(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple
- return self._getitem_lowerdim(tup)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim
- section = self._getitem_axis(key, axis=i)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis
- return self._get_label(key, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label
- return self.obj.xs(label, axis=axis)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs
- loc = self.index.get_loc(key)
- File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc
- raise KeyError(key) from err
- KeyError: 0
|