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