[users at bb.net] Splitting master folder into config and log folders
Francesco Di Mizio
francescodimizio at gmail.com
Fri Feb 19 14:14:41 UTC 2016
Searching around it seems most people only get that error on Win. Kind of
strange I am also getting it as I am using Docker 5.7 images which is
Debian\Jesse.
Anyway adding sql_mode='MYSQL40' to my custom .cnf file. It now looks like:
[mysqld]
bind-address=0.0.0.0
default-storage-engine=MYISAM
sql_mode='MYSQL40'
Rather then being an error, it's now a warnign like you said it should be
Dustin.
I then bumped into the very same error I got before (it's up in this
thread) using postgres. Here's the mysql variant of the error:
xceptions.RuntimeError: value for column objects.name is greater than max
of 128 characters:
MailNotifier_builders_try_waf_win_x64_msvc_shipping+try_waf_win_x64_msvc_development+try_waf_linux_x64_gcc_shipping+try_waf_linux_x64_clang_shipping
Attached is the entire call stack.
As a test, by removing my mailnotifiers to work the above around I was
finally able to start the master ;)
On Fri, Feb 19, 2016 at 5:15 AM, Dustin J. Mitchell <dustin at v.igoro.us>
wrote:
> Hm, in our testing 5.7 worked, although it *warned* about that. Is
> there, by chance, a MySQL setting to control whether that's a warning
> or not?
>
> Dustin
>
> On Thu, Feb 18, 2016 at 1:30 PM, Francesco Di Mizio
> <francescodimizio at gmail.com> wrote:
> > Did some more testing with b07 and Mysql 5.7. I am failing to buildbot
> > upgrade-master /buildbot/master.
> >
> >
> > 2016-02-18 18:17:07+0000 [-] sqlalchemy.exc.OperationalError:
> > (_mysql_exceptions.OperationalError) (1101, "BLOB, TEXT, GEOMETRY or JSON
> > column 'state_string' can't have a default value") [SQL: u"\nCREATE TABLE
> > builds (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tnumber INTEGER NOT
> NULL,
> > \n\tbuilderid INTEGER, \n\tbuildrequestid INTEGER NOT NULL,
> \n\tbuildslaveid
> > INTEGER, \n\tmasterid INTEGER NOT NULL, \n\tstarted_at INTEGER NOT NULL,
> > \n\tcomplete_at INTEGER, \n\tstate_string TEXT NOT NULL DEFAULT '',
> > \n\tresults INTEGER, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(builderid)
> > REFERENCES builders (id), \n\tFOREIGN KEY(masterid) REFERENCES masters
> > (id)\n)CHARACTER SET utf8\n\n"]
> >
> > 5.7 does not seem to like
> > tate_string TEXT NOT NULL DEFAULT ''
> >
> > On Tue, Feb 9, 2016 at 9:14 AM, Francesco Di Mizio
> > <francescodimizio at gmail.com> wrote:
> >>
> >> Sure thing.
> >>
> >> I am using a config that works just well with sqlite.
> >>
> >> I then spun up a container whose image is provided directly by postgres.
> >> The setup look alright as I can connect from other containers and open a
> >> postgree console and run my commands against the DB.
> >>
> >> When I set bbot up to use that DB (bbot master in just an other
> container
> >> linking the postgres one) I get:
> >>
> >> sqlalchemy.exc.DataError: (DataError) value too long for type character
> >> varying(128)
> >> 'INSERT INTO objects (name, class_name) VALUES (%(name)s,
> %(class_name)s)
> >> RETURNING objects.id' {'class_name':
> 'buildbot.reporters.mail.MailNotifier',
> >> 'name':
> >>
> 'MailNotifier_builders_try_waf_win_x64_msvc_shipping+try_waf_win_x64_msvc_development+try_waf_linux_x64_gcc_shipping+try_waf_linux_x64_clang_shipping+try_server_x64_release'}
> >>
> >> those above are what my builders are named.
> >>
> >> On Sun, Feb 7, 2016 at 6:15 PM, Dustin J. Mitchell <dustin at v.igoro.us>
> >> wrote:
> >>>
> >>> Can you give some more context for that error?
> >>>
> >>> On Fri, Feb 5, 2016 at 12:42 PM, Francesco Di Mizio
> >>> <francescodimizio at gmail.com> wrote:
> >>>>
> >>>> After spending too much with MYSQL official docker images I gave e a
> try
> >>>> to postgres. This was much smoother to setup, I could at least
> connect from
> >>>> the cmd line in 5 mins.
> >>>>
> >>>> Sadlysqlalchemy.exc.DataError: (DataError) value too long for type
> >>>> character varying(128)
> >>>>
> >>>> All in Nine.
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> On Fri, Feb 5, 2016 at 12:18 AM, Pierre Tardy <tardyp at gmail.com>
> wrote:
> >>>>>
> >>>>> There are some legacy files that are actually unused (like the
> template
> >>>>> dir), and we did not have time yet to cleanup (help wanted!)
> >>>>>
> >>>>> Unless you are using sqlite, I swear there is no data in the basedir.
> >>>>> Everything is in the db..
> >>>>>
> >>>>> Pierre
> >>>>>
> >>>>> Le jeu. 4 févr. 2016 à 23:01, Francesco Di Mizio
> >>>>> <francescodimizio at gmail.com> a écrit :
> >>>>>>
> >>>>>> you mean Nine does not generate anything in the Master folder when
> >>>>>> running? I swear to have seen something, I'll double check tomorrow!
> >>>>>>
> >>>>>> On Thu, Feb 4, 2016 at 9:15 PM, Pierre Tardy <tardyp at gmail.com>
> wrote:
> >>>>>>>
> >>>>>>> What I do with my eight instance is just to make a symlink of the
> >>>>>>> master.cfg to your pickle dir.
> >>>>>>>
> >>>>>>> What I would really do is switch to nine :-p
> >>>>>>> bye bye pickle!
> >>>>>>>
> >>>>>>> Pierre
> >>>>>>>
> >>>>>>> Le jeu. 4 févr. 2016 à 21:03, Francesco Di Mizio
> >>>>>>> <francescodimizio at gmail.com> a écrit :
> >>>>>>>>
> >>>>>>>> Hello Pierre,
> >>>>>>>>
> >>>>>>>> what I meant was more about having a folder with the config (i.e.
> >>>>>>>> master.cfg) and one with the stuff generated at runtime by the
> master
> >>>>>>>> itself.
> >>>>>>>>
> >>>>>>>> Chhers,
> >>>>>>>> Francesco
> >>>>>>>>
> >>>>>>>> On Thu, Feb 4, 2016 at 7:44 PM, Pierre Tardy <tardyp at gmail.com>
> >>>>>>>> wrote:
> >>>>>>>>>
> >>>>>>>>> Hi Francesco.
> >>>>>>>>> You can specify the master's basedir in the buildbot.tac file.
> >>>>>>>>>
> >>>>>>>>> HTH
> >>>>>>>>> Pierre
> >>>>>>>>>
> >>>>>>>>> Le jeu. 4 févr. 2016 à 14:59, Francesco Di Mizio
> >>>>>>>>> <francescodimizio at gmail.com> a écrit :
> >>>>>>>>>>
> >>>>>>>>>> Is there any way to do this?
> >>>>>>>>>>
> >>>>>>>>>> In a context where the master is dockerized, being able to tell
> >>>>>>>>>> buildbot to use a specific folder (either mounted or a docker
> volume) would
> >>>>>>>>>> allow to persist logs/pickles when the container hosting the
> master gets
> >>>>>>>>>> killed and recreated.
> >>>>>>>>>>
> >>>>>>>>>> The db side is not a problem, plenty of solutions there.
> >>>>>>>>>>
> >>>>>>>>>> Any thoughts?
> >>>>>>>>>> _______________________________________________
> >>>>>>>>>> users mailing list
> >>>>>>>>>> users at buildbot.net
> >>>>>>>>>> https://lists.buildbot.net/mailman/listinfo/users
> >>>>>>>>
> >>>>>>>>
> >>>>>>
> >>>>
> >>>>
> >>>> _______________________________________________
> >>>> users mailing list
> >>>> users at buildbot.net
> >>>> https://lists.buildbot.net/mailman/listinfo/users
> >>>
> >>>
> >>
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.buildbot.net/pipermail/users/attachments/20160219/395f0949/attachment.html>
-------------- next part --------------
2016-02-19 14:00:09+0000 [-] while starting BuildMaster
Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/twisted/internet/defer.py", line 588, in _runCallbacks
current.result = callback(current.result, *args, **kw)
File "/usr/local/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1184, in gotResult
_inlineCallbacks(r, g, deferred)
File "/usr/local/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1126, in _inlineCallbacks
result = result.throwExceptionIntoGenerator(g)
File "/usr/local/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator
return g.throw(self.type, self.value, self.tb)
--- <exception caught here> ---
File "/usr/local/lib/python2.7/dist-packages/buildbot/master.py", line 277, in startService
yield self.reconfigServiceWithBuildbotConfig(self.config)
File "/usr/local/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1126, in _inlineCallbacks
result = result.throwExceptionIntoGenerator(g)
File "/usr/local/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator
return g.throw(self.type, self.value, self.tb)
File "/usr/local/lib/python2.7/dist-packages/buildbot/util/service.py", line 46, in reconfigServiceWithBuildbotConfig
yield svc.reconfigServiceWithBuildbotConfig(new_config)
File "/usr/local/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1126, in _inlineCallbacks
result = result.throwExceptionIntoGenerator(g)
File "/usr/local/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator
return g.throw(self.type, self.value, self.tb)
File "/usr/local/lib/python2.7/dist-packages/buildbot/util/service.py", line 395, in reconfigServiceWithBuildbotConfig
child.name, class_name)
File "/usr/local/lib/python2.7/dist-packages/twisted/python/threadpool.py", line 246, in inContext
result = inContext.theWork()
File "/usr/local/lib/python2.7/dist-packages/twisted/python/threadpool.py", line 262, in <lambda>
inContext.theWork = lambda: context.call(ctx, func, *args, **kw)
File "/usr/local/lib/python2.7/dist-packages/twisted/python/context.py", line 118, in callWithContext
return self.currentContext().callWithContext(ctx, func, *args, **kw)
File "/usr/local/lib/python2.7/dist-packages/twisted/python/context.py", line 81, in callWithContext
return func(*args,**kw)
File "/usr/local/lib/python2.7/dist-packages/buildbot/db/pool.py", line 192, in __thd
rv = callable(arg, *args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/buildbot/db/state.py", line 45, in thd
return self.thdGetObjectId(conn, name, class_name)
File "/usr/local/lib/python2.7/dist-packages/buildbot/db/state.py", line 51, in thdGetObjectId
self.checkLength(objects_tbl.c.name, name)
File "/usr/local/lib/python2.7/dist-packages/buildbot/db/base.py", line 64, in checkLength
% (col, col.type.length, value))
exceptions.RuntimeError: value for column objects.name is greater than max of 128 characters: MailNotifier_builders_try_waf_win_x64_msvc_shipping+try_waf_win_x64_msvc_development+try_waf_linux_x64_gcc_shipping+try_waf_linux_x64_clang_shipping
More information about the users
mailing list