Aha, so this is a MySQL 7 issue, not a Windows issue. That is good to know, because we already know about the MySQL issue and are working on fixes. --------- Matt Taylor OS Community Flag-Bearer Numenta
On Wed, Feb 24, 2016 at 1:12 AM, Richard Crowder <[email protected]> wrote: > Hi Phil, > > Good to hear that you've overcome the issue that you faced with using MySQL > 5.7 with NuPIC. A change occurred between 5.6 and 5.7 that affects the > 'sql-mode', in this case the use of the default STRICT_TRANS_TABLES entry > [1, 2]. > > As you've seen this affects the handling of zero default datetime fields, as > well as other errors associated with a more robust strict mode now available > in version 5.7 [3]. > > Best regards, Richard. > > 1 http://dev.mysql.com/worklog/task/?id=7467 > 2 > https://www.digitalocean.com/community/tutorials/how-to-prepare-for-your-mysql-5-7-upgrade > 3 http://mysqlserverteam.com/improvements-to-strict-mode-in-mysql/ > > On Wed, Feb 24, 2016 at 3:11 AM, Phil Goddard <[email protected]> wrote: >> >> >> OK, got swarming to work. >> >> I had to edit .../nupic/database/ClientJobsDAO.py, replacing all instances >> of "DATETIME DEFAULT 0" with just "DATETIME". >> (There are 5 of them.) >> It seems there is an issue with specifying a default value for a DATETIME >> variable in the database (MySQL 5.7). >> >> Phil. >> >> ________________________________ >> From: [email protected] >> Subject: RE: Installation issues >> Date: Wed, 24 Feb 2016 00:50:15 +0000 >> To: [email protected] >> >> >> >> I'm not wholly surprised to hear that. >> Unfortunately I do need to use it. >> >> Any help from anyone who have tried windows would be appreciated. >> (Even if only to say, yes you have got it to work.) >> >> Phil >> >> > From: [email protected] >> > Date: Tue, 23 Feb 2016 15:52:55 -0800 >> > Subject: Re: Installation issues >> > To: [email protected] >> > >> > Honestly, I am surprised that works on Windows. We do not yet >> > "officially" support Windows, and none of us at Numenta currently run >> > that OS. You might need to try to get help from others on the list who >> > run Windows. >> > >> > Can any Windows people help Phil? What is your experience today >> > getting NuPIC running on Windows? >> > >> > Thanks, >> > --------- >> > Matt Taylor >> > OS Community Flag-Bearer >> > Numenta >> > >> > >> > On Tue, Feb 23, 2016 at 3:00 PM, Phil Goddard <[email protected]> >> > wrote: >> > > Did the install with "pip install nupic" >> > > >> > > Phil. >> > > >> > >> From: [email protected] >> > >> Date: Tue, 23 Feb 2016 14:57:11 -0800 >> > > >> > >> Subject: Re: Installation issues >> > >> To: [email protected] >> > >> >> > >> Hmm.... it could be something specific to Windows. How exactly did >> > >> you >> > >> install? >> > >> --------- >> > >> Matt Taylor >> > >> OS Community Flag-Bearer >> > >> Numenta >> > >> >> > >> >> > >> On Tue, Feb 23, 2016 at 2:40 PM, Phil Goddard <[email protected]> >> > >> wrote: >> > >> > Matt, >> > >> > >> > >> > pretty much the same problem... the first few lines of the trace >> > >> > are >> > >> > >> > >> > ================================================= >> > >> > = Swarming on rec-center-hourly data... >> > >> > = Medium swarm. Sit back and relax, this could take awhile. >> > >> > ================================================= >> > >> > Generating experiment files in directory: Q:\My >> > >> > >> > >> > >> > >> > Documents\\NuPIC\nupic-master\examples\opf\clients\hotgym\prediction\one_gym_test\swarm... >> > >> > Writing 313 lines... >> > >> > Writing 114 lines... >> > >> > done. >> > >> > None >> > >> > ERROR:nupic.database.ClientJobsDAO:Unhandled exception >> > >> > InternalError(1067, >> > >> > u"Invalid default value for 'start_time'") from <function >> > >> > _initTables at >> > >> > 0x00000000033A94A8>. Caller stack: >> > >> > File "swarm.py", line 109, in <module> >> > >> > swarm(INPUT_FILE) >> > >> > File "swarm.py", line 101, in swarm >> > >> > modelParams = swarmForBestModelParams(SWARM_DESCRIPTION, name) >> > >> > >> > >> > The input file csv file is the one that ships with the example. >> > >> > >> > >> > Also tried the sine wave tracking demo, with the same results. >> > >> > >> > >> > Phil. >> > >> > >> > >> > >> > >> >> From: [email protected] >> > >> >> Date: Tue, 23 Feb 2016 14:23:58 -0800 >> > >> > >> > >> >> Subject: Re: Installation issues >> > >> >> To: [email protected] >> > >> >> >> > >> >> Phil, I'm not sure that is the best example to use anymore. My >> > >> >> apologies. Can you instead try the swarming example in the >> > >> >> examples/opf/clients/hotgym/prediction/one_gym tutorial? The >> > >> >> README >> > >> >> explains it. The method of swarming is a bit different, but it is >> > >> >> a >> > >> >> bit simpler to follow what is actually going on. >> > >> >> --------- >> > >> >> Matt Taylor >> > >> >> OS Community Flag-Bearer >> > >> >> Numenta >> > >> >> >> > >> >> >> > >> >> On Tue, Feb 23, 2016 at 2:10 PM, Phil Goddard >> > >> >> <[email protected]> >> > >> >> wrote: >> > >> >> > >> > >> >> > Matt, >> > >> >> > I'm not aware that there is a csv file -- there isn't one >> > >> >> > initially >> > >> >> > and >> > >> >> > I >> > >> >> > can't see one that's auto generated. >> > >> >> > The input search_def.json file is the standard one from the >> > >> >> > examples\swarm\simple directory. >> > >> >> > Phil. >> > >> >> > >> > >> >> > >> > >> >> >> From: [email protected] >> > >> >> >> Date: Tue, 23 Feb 2016 13:50:37 -0800 >> > >> >> >> Subject: Re: Installation issues >> > >> >> >> To: [email protected] >> > >> >> > >> > >> >> >> >> > >> >> >> Phil, can you show me the first few data lines in the input CSV >> > >> >> >> file? >> > >> >> >> --------- >> > >> >> >> Matt Taylor >> > >> >> >> OS Community Flag-Bearer >> > >> >> >> Numenta >> > >> >> >> >> > >> >> >> >> > >> >> >> On Tue, Feb 23, 2016 at 1:20 PM, Phil Goddard >> > >> >> >> <[email protected]> >> > >> >> >> wrote: >> > >> >> >> > I've just installed nupic and am trying to get swarming to >> > >> >> >> > work, >> > >> >> >> > however >> > >> >> >> > I'm >> > >> >> >> > having a few issues and am hoping someone might know what >> > >> >> >> > set-up I >> > >> >> >> > am >> > >> >> >> > missing, or things I might try. >> > >> >> >> > >> > >> >> >> > Firstly "python test_db.py" works as per the swarming >> > >> >> >> > prerequisites >> > >> >> >> > instructions. >> > >> >> >> > (And I have no problem working with MySQL from other >> > >> >> >> > applications.) >> > >> >> >> > >> > >> >> >> > However, when I try to run the swarming example I get the >> > >> >> >> > errors: >> > >> >> >> > - No handlers could be found for logger >> > >> >> >> > "nupic.database.ClientJobsDAO" >> > >> >> >> > - Invalid default value for 'start_time' >> > >> >> >> > >> > >> >> >> > The full trace is shown below. >> > >> >> >> > >> > >> >> >> > Should also note that I'm doing this on Windows 10. >> > >> >> >> > >> > >> >> >> > Phil. >> > >> >> >> > >> > >> >> >> > Q:\My Documents>python run_swarm.py "Q:\My >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > Documents\NuPIC\nupic-master\examples\swarm\simple\search_def.json" >> > >> >> >> > --maxWorkers 6 --overwrite >> > >> >> >> > Generating experiment files in directory: Q:\My >> > >> >> >> > Documents\NuPIC\nupic-master\examples\swarm\simple... >> > >> >> >> > Writing 313 lines... >> > >> >> >> > Writing 114 lines... >> > >> >> >> > done. >> > >> >> >> > None >> > >> >> >> > No handlers could be found for logger >> > >> >> >> > "nupic.database.ClientJobsDAO" >> > >> >> >> > Traceback (most recent call last): >> > >> >> >> > File "run_swarm.py", line 187, in <module> >> > >> >> >> > runPermutations(sys.argv[1:]) >> > >> >> >> > File "run_swarm.py", line 178, in runPermutations >> > >> >> >> > fileArgPath, optionsDict, outputLabel, permWorkDir) >> > >> >> >> > File >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > "C:\Software\Python27\lib\site-packages\nupic\swarming\permutations_runner.py", >> > >> >> >> > line 310, in runWithJsonFile >> > >> >> >> > verbosity=verbosity) >> > >> >> >> > File >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > "C:\Software\Python27\lib\site-packages\nupic\swarming\permutations_runner.py", >> > >> >> >> > line 277, in runWithConfig >> > >> >> >> > return _runAction(runOptions) >> > >> >> >> > File >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > "C:\Software\Python27\lib\site-packages\nupic\swarming\permutations_runner.py", >> > >> >> >> > line 218, in _runAction >> > >> >> >> > returnValue = _runHyperSearch(runOptions) >> > >> >> >> > File >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > "C:\Software\Python27\lib\site-packages\nupic\swarming\permutations_runner.py", >> > >> >> >> > line 147, in _runHyperSearch >> > >> >> >> > search = _HyperSearchRunner(runOptions) >> > >> >> >> > File >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > "C:\Software\Python27\lib\site-packages\nupic\swarming\permutations_runner.py", >> > >> >> >> > line 418, in __init__ >> > >> >> >> > self.__cjDAO = _clientJobsDB() >> > >> >> >> > File >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > "C:\Software\Python27\lib\site-packages\nupic\swarming\permutations_runner.py", >> > >> >> >> > line 382, in _clientJobsDB >> > >> >> >> > return cjdao.ClientJobsDAO.get() >> > >> >> >> > File >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > "C:\Software\Python27\lib\site-packages\nupic\support\decorators.py", >> > >> >> >> > line 56, in exceptionLoggingWrap >> > >> >> >> > return func(*args, **kwargs) >> > >> >> >> > File >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > "C:\Software\Python27\lib\site-packages\nupic\database\ClientJobsDAO.py", >> > >> >> >> > line 548, in get >> > >> >> >> > cjDAO.connect() >> > >> >> >> > File >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > "C:\Software\Python27\lib\site-packages\nupic\support\decorators.py", >> > >> >> >> > line 56, in exceptionLoggingWrap >> > >> >> >> > return func(*args, **kwargs) >> > >> >> >> > File >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > "C:\Software\Python27\lib\site-packages\nupic\support\decorators.py", >> > >> >> >> > line 208, in retryWrap >> > >> >> >> > result = func(*args, **kwargs) >> > >> >> >> > File >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > "C:\Software\Python27\lib\site-packages\nupic\database\ClientJobsDAO.py", >> > >> >> >> > line 636, in connect >> > >> >> >> > recreate=recreate) >> > >> >> >> > File >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > "C:\Software\Python27\lib\site-packages\nupic\support\decorators.py", >> > >> >> >> > line 56, in exceptionLoggingWrap >> > >> >> >> > return func(*args, **kwargs) >> > >> >> >> > File >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > >> > >> >> >> > "C:\Software\Python27\lib\site-packages\nupic\database\ClientJobsDAO.py", >> > >> >> >> > line 802, in _initTables >> > >> >> >> > cursor.execute(query) >> > >> >> >> > File >> > >> >> >> > "C:\Software\Python27\lib\site-packages\DBUtils\SteadyDB.py", >> > >> >> >> > line >> > >> >> >> > 631, in tough_method >> > >> >> >> > raise error # reraise the original error again >> > >> >> >> > pymysql.err.InternalError: (1067, u"Invalid default value for >> > >> >> >> > 'start_time'") >> > >> >> >> > >> > >> >> >> >> > >> >> >> > >> >> > > >
