| Time |
Nick |
Message |
| 00:26 |
|
Christineb joined #evergreen |
| 02:39 |
|
book` joined #evergreen |
| 05:01 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 07:10 |
|
rjackson_isl joined #evergreen |
| 08:06 |
|
Dyrcona joined #evergreen |
| 08:29 |
|
bos20k joined #evergreen |
| 08:45 |
|
mmorgan joined #evergreen |
| 09:07 |
|
tlittle joined #evergreen |
| 09:07 |
|
agoben joined #evergreen |
| 09:13 |
|
yboston joined #evergreen |
| 09:20 |
|
tlittle86 joined #evergreen |
| 09:34 |
|
nfBurton joined #evergreen |
| 09:48 |
|
yboston joined #evergreen |
| 09:48 |
|
sandbergja joined #evergreen |
| 10:19 |
csharp |
Bmagic: I just marked the bug as a duplicate - thanks! |
| 10:20 |
Bmagic |
groovy |
| 10:25 |
|
khuckins joined #evergreen |
| 10:28 |
|
Dyrcona joined #evergreen |
| 11:28 |
|
Christineb joined #evergreen |
| 11:28 |
|
gsams joined #evergreen |
| 11:57 |
|
aabbee joined #evergreen |
| 11:57 |
|
yboston joined #evergreen |
| 12:02 |
|
jihpringle joined #evergreen |
| 12:22 |
|
jwoodard joined #evergreen |
| 12:27 |
|
yboston joined #evergreen |
| 13:11 |
|
awitter joined #evergreen |
| 13:25 |
abowling |
upgrading an old-timey db (2.4.2) and i ran into this years ago, but a number of table constraint operations are failing with 'ALTER TABLE "foo_bar"' because it has pending trigger events'. any suggestions fresher than my memory? |
| 13:26 |
jeff |
the upgrade scripts are failing at various ALTER TABLE commands? |
| 13:26 |
abowling |
jeff: correct |
| 13:27 |
abowling |
to wit, 2.4.3-2.5.0... is what is failing here |
| 13:27 |
csharp |
abowling: add "COMMIT; BEGIN;" before where the error is happening |
| 13:27 |
jeff |
general solution is to avoid trying to modify data and ALTER table within the same transaction. break it into smaller logical chunks. |
| 13:28 |
csharp |
you might need to be strategic about where those are inserted, but that's the basic approach |
| 13:28 |
abowling |
csharp++ |
| 13:28 |
abowling |
jeff++ |
| 13:28 |
jeff |
commit fd32a6e is one example of that in practice. no claims as to it being a GOOD example, just the first I found. |
| 13:28 |
pinesol |
jeff: [evergreen|Jason Stephenson] LP 1497307: Fix 2.8.4 to 2.9.0 upgrade script. - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=fd32a6e> |
| 13:28 |
abowling |
csharp: jeff: so you're telling me i have to do work?! ;) |
| 13:29 |
abowling |
i think i've just been lucky in not having encountered such in a long time |
| 13:31 |
jeff |
simpler diff example in commit c9ee432 -- they're just moved after the transaction. |
| 13:31 |
pinesol |
jeff: [evergreen|Jason Stephenson] LP#1418164: Fix 0905.schema.user_currnet_normalize_heading.sql. - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=c9ee432> |
| 13:32 |
abowling |
csharp: jeff: have i told you lately that i love you? |
| 13:32 |
abowling |
success |
| 13:32 |
csharp |
abowling: I know for a fact we hit the same issue on that upgrade - I was looking for what I did, but my commit messages are not awesome |
| 13:32 |
jeff |
not since last week, probably. |
| 13:32 |
abowling |
ha |
| 13:32 |
csharp |
abowling: awww |
| 13:33 |
csharp |
abowling: https://git.evergreen-ils.org/?p=evergreen/pines.git;a=blob;f=Open-ILS/src/sql/Pg/version-upgrade/pines-2.4.3-2.5.0-upgrade-db.sql;h=435323fc9c9a8a2da636090c52f9ade30c79aefa;hb=refs/heads/rel_2_5_1 is the version I ran (probably) |
| 13:34 |
abowling |
csharp++ |
| 13:34 |
csharp |
note that I commented out sections we had already applied, and I'm not exactly sure where I broke it up, but you're probably on the right track :-) |
| 14:28 |
|
Dyrcona joined #evergreen |
| 14:48 |
|
kaffenkj joined #evergreen |
| 14:56 |
kaffenkj |
Keith "Always Votes Reject on Resistance missions" from Indiana here. It was great to meet so many of you fine folks at the EI Conference last week! Hoping I can pick some brains in the meantime to get my chops up for the Hack-a-way in Oct; |
| 14:58 |
Dyrcona |
kaffenkj: Welcome. It's better if you have specific questions to ask. It's hard to give general advice in IRC. |
| 14:59 |
kaffenkj |
Oh, certainly: I won't hesitate to ask questions when they arise, I just wanted to give a quick shoutout to the folks I met last week and see if I might put IRC handles to faces. |
| 15:02 |
* Dyrcona |
is always a spy... |
| 15:05 |
kaffenkj |
Even when he's not a spy? |
| 15:11 |
Dyrcona |
Yeahp. |
| 15:14 |
|
khuckins joined #evergreen |
| 15:24 |
csharp |
kaffenkj: might have missed meeting you, but welcome - I'm Chris Sharp from GPLS/PINES |
| 15:24 |
* csharp |
was resistance on all his turns this year |
| 15:24 |
|
Dyrcona joined #evergreen |
| 15:27 |
* Dyrcona |
was a spy in 3 out of 4 games of Resistance. |
| 15:39 |
bshum |
kaffenkj: Fwiw, in case it helps - this is a wiki page where some people have put their IRC nicks to their names and orgs respectively - https://wiki.evergreen-ils.org/doku.php?id=community:irc_channel |
| 15:58 |
kaffenkj |
That helps a great deal, in fact. Thanks! |
| 16:06 |
|
mmorgan1 joined #evergreen |
| 16:07 |
|
yboston joined #evergreen |
| 17:01 |
|
mmorgan1 left #evergreen |
| 17:09 |
|
kaffenkj joined #evergreen |
| 17:18 |
|
yboston joined #evergreen |
| 17:31 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 17:43 |
|
Dyrcona joined #evergreen |
