| Time |
Nick |
Message |
| 00:30 |
|
rhamby joined #evergreen |
| 00:32 |
|
book` joined #evergreen |
| 06:01 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 07:29 |
|
rjackson_isl_hom joined #evergreen |
| 08:39 |
|
mmorgan joined #evergreen |
| 08:46 |
|
rfrasur joined #evergreen |
| 08:55 |
|
Dyrcona joined #evergreen |
| 09:05 |
Dyrcona |
So here's a fun thing for going to Pg 14 with Evergreen: Specifically, array_append(), array_prepend(), array_cat(), array_position(), array_positions(), array_remove(), array_replace(), and width_bucket() used to take anyarray arguments but now take anycompatiblearray. Therefore, user-defined objects like aggregates and operators that reference those array function signatures must be dropped before upgrading, and |
| 09:05 |
Dyrcona |
d once the upgrade completes. |
| 09:06 |
Dyrcona |
Can we just drop the array_accum function and replace it array_append or even arrray_agg? |
| 09:18 |
Bmagic |
Do it on production and see |
| 09:18 |
Bmagic |
@coffee [Dyrcona] |
| 09:18 |
* pinesol |
brews and pours a cup of Colombia Hato Viejo Cup of Excellence, and sends it sliding down the bar to Evergreen Command Center http://apod.nasa.gov/apod/image/1204/EndeavourFlightDeck_cooper_1050.jpg |
| 09:20 |
Dyrcona |
Bmagic: Thanks for the coffee. |
| 09:20 |
Bmagic |
lol, I guess I got the syntax wrong |
| 09:21 |
mmorgan |
Looks about right to me ;-) |
| 09:24 |
Dyrcona |
@coffee Bmagic |
| 09:24 |
* pinesol |
brews and pours a cup of Panama El Burro Estate, and sends it sliding down the bar to Bmagic |
| 09:24 |
Dyrcona |
@coffee [who] |
| 09:24 |
* pinesol |
brews and pours a cup of La Esmeralda Panama, and sends it sliding down the bar to (who [<channel>] <question>) -- Answers <question> with a random nick from <channel>. <channel> is only necessary if the message isn't sent in the channel itself. |
| 09:24 |
Bmagic |
yeah, the brackets are only for "someone" |
| 09:25 |
Dyrcona |
Yeah, guess so... |
| 09:25 |
Dyrcona |
@someone |
| 09:25 |
pinesol |
jonadab |
| 09:25 |
Dyrcona |
@who |
| 09:25 |
pinesol |
Dyrcona: (who [<channel>] <question>) -- Answers <question> with a random nick from <channel>. <channel> is only necessary if the message isn't sent in the channel itself. |
| 09:25 |
Dyrcona |
I see. Maybe I do need that coffee. :) |
| 09:25 |
Bmagic |
haha |
| 09:25 |
rfrasur |
lol! |
| 09:26 |
Bmagic |
I've noticed that we are down about 20-30 nicks in the channel after we moved Evergreen to this IRC server |
| 09:26 |
* rfrasur |
offers cough drops and various types of tissues. |
| 09:26 |
Bmagic |
spies! |
| 09:26 |
Dyrcona |
Anyway, I'm opening a Lp bug about this aggregate issue. |
| 09:26 |
rfrasur |
There's only one spy in here. |
| 09:27 |
Dyrcona |
I'm always a spy, even when I'm resistance. :) |
| 09:27 |
Bmagic |
Oh really? And who would that be? |
| 09:27 |
rfrasur |
Oh, there are two spies in here. Hmm, if you tell people you're a spy, are you one? |
| 09:28 |
rfrasur |
It's you Bmagic. You're the spy. |
| 09:28 |
Bmagic |
Way to confuse us |
| 09:28 |
rfrasur |
Valid. |
| 09:28 |
* rfrasur |
is easily confused anyway. |
| 09:28 |
mmorgan |
rfrasur: If you tell people you're a spy, and you are one, you're probably not a very good one. |
| 09:28 |
Bmagic |
Oh, so valid is the spy? |
| 09:29 |
rfrasur |
Maybe. Maybe the spy is valid. |
| 09:29 |
rfrasur |
mmorgan++ |
| 09:30 |
Bmagic |
mmorgan: very good! articulating the thinking, and then we can go one step further: If you know that someone would be a bad spy by telling us they are a spy, and you know that they know that you would think that. What we have here is a classic Princess Bride situation |
| 09:30 |
Dyrcona |
@who is the spy? |
| 09:30 |
pinesol |
akilsdonk is the spy. |
| 09:31 |
rfrasur |
Oooh, that makes sense. |
| 09:31 |
mmorgan |
Bmagic++ |
| 09:32 |
rfrasur |
A parts column in item buckets would be amazing. Just sayin' |
| 09:32 |
Dyrcona |
What about a parts bucket? |
| 09:32 |
Bmagic |
rfrasur: We have a patch for that, but you wouldn't know about it because it was only given to the resistance |
| 09:32 |
Dyrcona |
Bucket O' Parts... |
| 09:33 |
|
collum joined #evergreen |
| 09:33 |
rfrasur |
Nah. Just a parts column. I mean, I have 130 parts buckets. But they're just item buckets. |
| 09:33 |
mmorgan |
rfrasur: Sounds like that would be an easier task than following Princess Bride logic on a Monday morning ;-) |
| 09:33 |
rfrasur |
mmorgan, my thoughts exactly. |
| 09:34 |
rfrasur |
I'm only part of the resistance when I don't have a cold. When I have a cold, just another toady for the empire. |
| 09:37 |
Bmagic |
rfrasur++ # sure you do |
| 09:38 |
rfrasur |
Bmagic++ # you're still a spy. |
| 09:39 |
Bmagic |
I'll keep your attitude in mind for the times when I'm a spy |
| 09:39 |
Bmagic |
Play a little Princess Bride on you |
| 09:39 |
collum |
Inconceivable! |
| 09:39 |
rfrasur |
Only if I don't have a cold. |
| 09:39 |
Bmagic |
collum++ |
| 09:41 |
Dyrcona |
Never go in against a movie when Wallace Shawn is in the cast. :) |
| 09:42 |
mmorgan |
:) |
| 09:43 |
Dyrcona |
So, I've managed to get the array_accum aggregate recreated in my Pg 14 database. I'm going to go ahead with my testing and see what happens. Also, Lp 1947595. |
| 09:43 |
Bmagic |
hahahaha. Side note: I signed up to listen to the cast perform a reading of the script live on zoom last year. That was really fun. Of course Andre the giant wasn't there but Josh Gadd did awesome as the giant |
| 09:43 |
pinesol |
Launchpad bug 1947595 in Evergreen "array_accum Aggregate and PostgreSQL 14" [Undecided,New] https://launchpad.net/bugs/1947595 |
| 09:43 |
Bmagic |
Dyrcona++ |
| 09:54 |
Dyrcona |
Eh, well, now I get this with an untested db upgrade script: psql:cwmars-3.5.3-master-8687ba82c-upgrade-db.sql:6414: ERROR: cannot ALTER TABLE "event_definition" because it has pending trigger events |
| 09:54 |
pinesol |
Dyrcona: [evergreen|Galen Charlton] Translation updates - newpot - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=8687ba8> |
| 09:54 |
Dyrcona |
Hah. |
| 09:54 |
Dyrcona |
I wasn't talking to you, pinesol. |
| 09:55 |
Bmagic |
I didn't know you would actually* try it on production |
| 09:59 |
Dyrcona |
Bmagic: That's not on production. It's a test db server. |
| 10:00 |
Dyrcona |
It is a copy of production data, though. |
| 10:00 |
|
alynn26 joined #evergreen |
| 10:01 |
Bmagic |
yeah, I was kidding ya |
| 10:03 |
Dyrcona |
Yeah, I realize that, but I, and the logs, are kinda autistic. |
| 10:05 |
Dyrcona |
I can either modify my previous upgrade script or use use one to get to a different revision on master, and then another to get the commit from the one that failed. I suspect that splits the updates enough to work. |
| 10:09 |
Dyrcona |
There are a lot of updates on event_definition since 3.5.3. |
| 10:15 |
Dyrcona |
1291 and 1293 look like they need their own transactons. |
| 10:18 |
Dyrcona |
Yeahp. Moving 1291 and 1293 to separate transactions after the rest of the updates works. |
| 10:31 |
Dyrcona |
Heh. Looks like my previous upgrade scripts split the event changes so that they don't cause problems with each other. |
| 10:31 |
Dyrcona |
There are no mistakes, only happy accidents. |
| 10:43 |
|
jvwoolf joined #evergreen |
| 11:27 |
|
jlundgren joined #evergreen |
| 11:33 |
|
jlundgren joined #evergreen |
| 11:36 |
|
jlundgren joined #evergreen |
| 11:49 |
|
jihpringle joined #evergreen |
| 12:49 |
* mmorgan |
needs to learn to stop kicking the surge suppressor switch. |
| 12:50 |
mmorgan |
Though it is slightly less annoying with a laptop. |
| 12:56 |
|
collum joined #evergreen |
| 13:05 |
|
tlittle joined #evergreen |
| 13:58 |
|
mmorgan left #evergreen |
| 15:51 |
|
jihpringle joined #evergreen |
| 16:57 |
|
jvwoolf left #evergreen |
| 18:00 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
