[users at bb.net] Splitting master folder into config and log folders

[Francesco Di Mizio]

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/20160218/0b7b8db1/attachment.html>