Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • 03:59
    zzzeek milestoned #5984
  • 03:59
    zzzeek labeled #5984
  • 03:59
    zzzeek labeled #5984
  • 03:59
    zzzeek labeled #5984
  • 03:59
    zzzeek opened #5984
  • Feb 25 22:23
    sqlalchemy-bot closed #5967
  • Feb 25 22:23

    sqlalchemy-bot on master

    mutex asyncpg / aiomysql connec… (compare)

  • Feb 25 21:33
    zzzeek locked #5968
  • Feb 25 21:33
    zzzeek closed #5968
  • Feb 25 21:12
    zzzeek unlabeled #5981
  • Feb 25 21:12
    zzzeek milestoned #5981
  • Feb 25 21:12
    zzzeek labeled #5981
  • Feb 25 21:12
    zzzeek labeled #5981
  • Feb 25 21:12
    zzzeek labeled #5981
  • Feb 25 21:11
    zzzeek labeled #5981
  • Feb 25 21:11
    zzzeek opened #5981
  • Feb 25 18:04
    zzzeek labeled #804
  • Feb 25 18:04
    zzzeek unlabeled #804
  • Feb 25 17:03
    CaselIT locked #5976
  • Feb 25 17:03
    CaselIT closed #5976
mike bayer
@zzzeek
@gordthompson I put up a gerrit that should fix it
mike bayer
@zzzeek
just bought a $20 power meter. the d2 machine was drawing about 100W when idle (!!!!)
thats my oldest dell that I bought used
Federico Caselli
@CaselIT
that seems high
mike bayer
@zzzeek
yes!
its 40% of my whole rack here that has like 20 things plugged in!
Federico Caselli
@CaselIT
are you planning on replacing it?
mike bayer
@zzzeek
shrugs
i wish jenkins would fix that cloud bug so i could use digital ocean more reliably
im sad b.c. this was an old machine i bought,then it died and I went through all the trouble to buya new motherboard and do the whole fix and it worked
like i successfully diagnosed the issue
Federico Caselli
@CaselIT
I've always assembled my own desktop pcs, so it did happen to me a couple of times. My current one is a ~2014 vintage I think
mike bayer
@zzzeek
im going to hypotehsize that pcs running linux are lower power consumption when idle vs. a windows pc
Federico Caselli
@CaselIT
But I guess you could find some used amd zen pc for cheap as people upgrade to zen3. And they have 12-16 cores :)
I guees so. A lot less crap at idle. Also the graphic card consume a lot. You can remove it for a server if you only use it as headless
mike bayer
@zzzeek
@CaselIT Im chjanging the formatting of the examples in https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/2352/2/doc/build/changelog/migration_20.rst to be multi line
also changingt he format of hte links because they are blowing up vertically
Federico Caselli
@CaselIT
ok, feel free. Sorry but I don't have much spare time at the moment. a bit swamped at work :(
mike bayer
@zzzeek
no prob :)
Federico Caselli
@CaselIT
will try to move along a bit the alembic support for identity
mike bayer
@zzzeek
did you want that in for 1.5.0 ?
Federico Caselli
@CaselIT
if there is no particular rush to release it, yes
it would be nice to have it out so people can use it with sa1.4
also because in mssql it basically is always used when reflecting
Federico Caselli
@CaselIT
I think we could remove the testing/exclusions.py in alembic, since we target 1.3 that I believe already had it?
mike bayer
@zzzeek
@CaselIT yes that may be the case now
Federico Caselli
@CaselIT
added an issue, since I've noticed that alembic is also missing tests for sqlite computed
Federico Caselli
@CaselIT
@zzzeek i've got a problem I don't know how to best solve:
if I have a Column('foo', Integer, Identity()) this renders the default, but when reflecting I get back Identity(start=1, increment=1, minvalue=1, maxvalue=2147483647, cycle=False, cache=1)
how do I compare that and decide that they are the same?
mike bayer
@zzzeek
I just broke jenkins, fixing
@CaselIT with that kind of thing we look at the attributes and if an attribute is not set, we dont comapre it to the reflected one
we assume it's a DB default
the type comparison logic does this, actualy it does it in both directions which is probbly less than ideal
Federico Caselli
@CaselIT

I just broke jenkins, fixing

so you can check off the daily to do list:
[x] fight against the ci

@CaselIT with that kind of thing we look at the attributes and if an attribute is not set, we dont comapre it to the reflected one

that makes sense. thanks

Jonathan Vanasco
@jvanasco
@zzzeek if it's 100W when idle, you could test the power draw at a few lower load levels, to see if the power supply has a high minimum draw. you might be able to just swap out a more efficient power supply.
2 replies
mike bayer
@zzzeek
im still trying to find a way to not spin up 16 digital ocean instances at once
20 cents a pop this is an expensive way to debug
Federico Caselli
@CaselIT
why do you need 16?
mike bayer
@zzzeek
i dont
:)
i told it 4 and then put a bunch of jobs in
i have another theory what might help, about to try that
OK running it again :)
mike bayer
@zzzeek
fail
what a piece of shit
Federico Caselli
@CaselIT
I sense a zzzeek-jenkins-cloud-thingy in the future
mike bayer
@zzzeek
i added to the jira with more of what my theory is and if they have the decency to say "yup", I can try for a PR
have to get the java band back together
ugh
Federico Caselli
@CaselIT
Good luck, I guess