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