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'") > >> >> >> > > >> >> >> > >> >> > >> >
