| Time |
Nick |
Message |
| 06:01 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 07:27 |
|
rjackson_isl_hom joined #evergreen |
| 07:55 |
|
collum joined #evergreen |
| 08:08 |
|
Dyrcona joined #evergreen |
| 08:35 |
|
mantis joined #evergreen |
| 08:36 |
|
jonadab joined #evergreen |
| 08:40 |
|
mmorgan joined #evergreen |
| 08:42 |
|
jonadab joined #evergreen |
| 09:05 |
|
Dyrcona joined #evergreen |
| 09:07 |
|
rfrasur joined #evergreen |
| 09:10 |
|
jonadab joined #evergreen |
| 09:17 |
|
alynn26 joined #evergreen |
| 09:17 |
|
jonadab joined #evergreen |
| 09:28 |
|
jonadab joined #evergreen |
| 09:36 |
|
jvwoolf joined #evergreen |
| 11:18 |
|
alynn26 joined #evergreen |
| 11:20 |
|
alynn26 joined #evergreen |
| 12:09 |
mantis |
I am installing via ansible to a new test environment. After running sudo ansible-playbook playbook.yml, I get this error when downloading websocketd |
| 12:10 |
mantis |
changed, true "cmd": "cd/tmp/ && wget --quiet https://github.com/joewalnes/websocketd/releases/download/v0.3.1/websocketd-0.3.1-linux_amd64.zip", "delta".... |
| 12:10 |
|
jihpringle joined #evergreen |
| 12:11 |
berick |
mantis: which branch? |
| 12:11 |
mantis |
20.04 |
| 12:13 |
berick |
mantis: what's the rest of the error output? |
| 12:14 |
berick |
"cd/tmp/" looks odd, but i'm guessing that's a typo |
| 12:16 |
mantis |
https://drive.google.com/file/d/1rb4VhKNP8JKsag9HAp1Ksf2DVEOz7LAl/view?usp=sharing |
| 12:17 |
mantis |
hope a screenshot is fine |
| 12:17 |
mantis |
that's my typo; meant to be cd /tmp/ |
| 12:18 |
|
tlittle joined #evergreen |
| 12:21 |
berick |
mantis: hm, not sure. can you try those commands by hand? |
| 12:21 |
berick |
cd /tmp/ && wget --quiet https://github.com/joewalnes/websocketd/releases/download/v0.3.1/websocketd-0.3.1-linux_amd64.zip |
| 12:31 |
jeff_ |
(might want to remove the --quiet argument when running by hand) |
| 12:31 |
mantis |
I ran the command it returned |
| 12:33 |
mantis |
So I have apache2, ejabberd, fwupd.servicec, memcached, systemd-logind, systemd-resolved, systemd-timesynchd, and upower.service |
| 12:34 |
mantis |
Wasn't sure if that is complete |
| 12:36 |
jeff |
mantis: any errors/diagnostic messages from wget for why it may be failing are going to be omitted when you run it with the --quiet argument. I'd recommend running without the --quiet argument as part of your troubleshooting. |
| 12:46 |
mantis |
ok I got a ERROR 403: Forbidden when trying to connect to github-releases.githubusercontent.com | 185.199.108.154 |
| 12:48 |
mantis |
and a bunch of time outs |
| 12:48 |
Dyrcona |
Funny. It works for me. Maybe you're temporarily blocked for trying too many times? |
| 12:48 |
mantis |
Sorry that last IP I sent I was able to connect to |
| 12:49 |
Dyrcona |
BTW, I've been using Websocketd 0.4.1 and it works. |
| 12:50 |
mantis |
I can give that a try |
| 12:50 |
Dyrcona |
Did you say you were able to get it after all? |
| 12:50 |
mantis |
I got into that particular IP but for the rest I got connections failed |
| 12:51 |
mantis |
I was using websocketd 0.3.1 |
| 12:51 |
Dyrcona |
I don't think that will matter. A 403 means that your client is forbidden from connecting to a particular URL. |
| 12:52 |
Dyrcona |
What happens when you do this: wget https://github.com/joewalnes/websocketd/releases/download/v0.3.1/websocketd-0.3.1-linux_amd64.zip |
| 12:55 |
mantis |
didn't finish yet but looks like connection time outs so far |
| 12:57 |
Dyrcona |
mantis: Since it works for me, I suspect that github are blocking you or you have some network issue preventing you from accessing github. It could be that they don't like you using wget at the moment. Have you tried accessing the URL with a browser? |
| 12:57 |
mantis |
it's allowing me to open and save the file |
| 12:58 |
Dyrcona |
I assume your browser's IP is different from the IP where you're running wget, right? |
| 12:58 |
mantis |
Yeah it would be different |
| 12:59 |
mantis |
running via VB |
| 12:59 |
Dyrcona |
VirtualBox on your local machine or remote? |
| 12:59 |
mantis |
local machine |
| 12:59 |
Dyrcona |
Then your IP as github sees it is likely the same. |
| 13:03 |
* Dyrcona |
is trying to get Net::SFTP::Foreign to work from a cron job. I suspect the issue is that it can't fine the known hosts file. |
| 13:10 |
Dyrcona |
Also, you just have to love it when your remote connections hang. |
| 13:13 |
Dyrcona |
mantis: I'm not sure what's going on, but I suspect either your VB networking is not quite right or github are temporarily blocking wget from your IP for some reason. |
| 13:16 |
Dyrcona |
Also, it helps not to make typos in the configuration file of the program that you're testing. RE: my issue with Net::SFTP::Foreign. |
| 13:24 |
Dyrcona |
Looks like the typo was my problem all along. :( |
| 13:24 |
mmorgan |
typos-- |
| 13:29 |
mantis |
Dyrcona++ |
| 13:29 |
mantis |
typos-- |
| 13:37 |
|
jvwoolf joined #evergreen |
| 14:15 |
* Dyrcona |
removes Pg 9.6 from the test db server and configures Pg 14 to use the port that Pg 9.6 was listening on. |
| 14:38 |
|
mantis joined #evergreen |
| 14:48 |
Dyrcona |
So, the 1288 upgrade script blows up on my data: psql:Open-ILS/src/sql/Pg/upgrade/1288.schema.note_and_message_consolidation.sql:297: ERROR: null value in column "create_date" violates not-null constraint |
| 14:50 |
Dyrcona |
Yeah, we have 94,011 actor.usr_note entries with a null create date. |
| 14:52 |
Dyrcona |
Interesting: our actor.usr_note table allows null for create_date. |
| 14:54 |
Dyrcona |
OK, so why can't I find the table definition in the base schema files? |
| 14:55 |
Dyrcona |
Oh, 'cause I'm looking at master and it was dropped.... |
| 14:57 |
Dyrcona |
So, yeah, create_date allows null with a default of now(), which I think means you get NULL if you insert null. To get NOW(), you have to insert NOW() or change the definition to add NOT NULL. |
| 14:57 |
Dyrcona |
So, looks like 1288 should have a coalesce added for actor.usr_note.create_date.... |
| 14:59 |
Dyrcona |
Think I'll file a Lp bug. |
| 15:00 |
mmorgan |
Dyrcona: FWIW, just checked our production system and we have no actor.usr_notes with NULL create_date, but I agree there should be an lp bug. |
| 15:01 |
Dyrcona |
mmorgan: What does the line for create_date look like in your database from \d actor.usr_note |
| 15:01 |
Dyrcona |
It could be we missed an upgrade script somewhere. |
| 15:02 |
Dyrcona |
Ours looks like: create_date | timestamp with time zone | | | now() |
| 15:03 |
Dyrcona |
For the default to work with an insert of NULL, it should look like: create_date | timestamp with time zone | | not null | now() |
| 15:03 |
Dyrcona |
The latter is from actor.usr_message. |
| 15:05 |
berick |
Dyrcona: null-able here as well, though we have no null entries |
| 15:06 |
Dyrcona |
We're always the special ones.... |
| 15:07 |
Dyrcona |
I'm gonna wait to open a bug anyway. Don't want it to get lost in the tag churn. |
| 15:07 |
berick |
bug_wranglers++ mark_all_as_read++ |
| 15:07 |
Dyrcona |
Heh. |
| 15:07 |
Dyrcona |
Right-click...Mark Folder Read... |
| 15:09 |
Dyrcona |
Hm.. Looks like we have more usr notes with Null create dates than not. |
| 15:10 |
Dyrcona |
Based on some with dates, it looks like they were all migrated. |
| 15:14 |
Dyrcona |
All of the ones with create_date not null are post migration. |
| 15:14 |
Dyrcona |
So, looks like a migration issue. I'll just update the null ones to the date of the migration, roughly. |
| 15:26 |
pinesol |
[evergreen|Andrea Buntz Neiman] Docs: 3.8 Release Notes updates - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=3eeaacf> |
| 15:29 |
|
mantis1 joined #evergreen |
| 15:33 |
mmorgan |
Dyrcona: Sorry got pulled away. |
| 15:37 |
Dyrcona |
No problem, mmorgan. |
| 15:37 |
mmorgan |
Dyrcona: Our create_date looks the same as yours, nulls are allowed. We just don't have any :) |
| 15:41 |
Dyrcona |
Yeah, I mentioned above that I think it's a migration issue. Looks like a large batch of migrated notes got a NULL create date, some others didn't. I'm going to just update these to all have the same date as the oldest batch of migrated notes. |
| 15:54 |
Dyrcona |
After updating the notes, the rest of the upgrade script succeeds. |
| 15:54 |
Dyrcona |
We may end up deleting a lot of these old notes at some point. |
| 17:40 |
|
mmorgan left #evergreen |
| 18:01 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 18:29 |
jeffdavis |
tag_updaters++ |
| 22:08 |
|
troy joined #evergreen |
| 22:08 |
|
Christineb_ joined #evergreen |
| 22:22 |
|
degraafk joined #evergreen |
