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