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

Reply via email to