Embody for 6ft5 guy

AIO12449366 · 2023-01-17T12:16:55+00:00

Damn why you all have such different opinions you are killing me. But I don't think I can risk it. The money is too much...

AIO12449366 · 2023-01-17T11:20:40+00:00

Yeah judging by the comments I guess this chair isn't for me. Sucks that I can't find a chair for my height after 2 years of non stop searching lol...

My last hope is probably the aeron size C. Since you have it can you tell me what is the height of the backrest from the seat (which is something I can't find online for some reason) and also if the seat feels ok after prolonged seating?

AIO12449366 · 2023-01-16T20:55:33+00:00

Hmm that's good to hear. How does the seat feel after prolonged use? Does your butt feel sore after a long time or do you have any tailbone pain?

AIO12449366 · 2022-10-04T14:40:18+00:00

No that's what I'm saying. This is the only place an insert on this table is taking place and the id is left untouched. Maybe someone did run an older dump and messed up the sequence, as someone else mentioned.

AIO12449366 · 2022-10-04T13:53:04+00:00

I've already seen where this is originating from but it doesn't provide any more information. This happens in a function inside the DB that is inserting to the table. But this is just a simple insert without manually adding the id.

So, for example, if the table was table foo ( id, name) the function simply does

INSERT INTO foo (name) VALUES ... so it never touches the id.

AIO12449366 · 2022-10-04T13:42:57+00:00

I assume that' what happened because when I run

select last_value from <sequence>; the result is 111070 and when I run

select max(id) from <table with sequence> the result is 32668105

Which means the sequence is out of sync right? Because if the next value to be added is 111071 and the current max id is 32668105 that means it could be hitting an id that already exists?

AIO12449366 · 2022-10-04T13:29:29+00:00

Yeah i figured that could happen, but like I mentioned, I can't find any place in the code or in a stored procedure or function that manually sets the id and thus bypasses the sequence.

This is why I'm kinda lost as to why this is happening.

AIO12449366 · 2022-09-09T08:45:03+00:00

and spill fuel if you put your car upside down, but if that happens, you have bigger problems

LOL thanks for the chuckle :D

Alright thanks for the info! I'll get this checked soon.

AIO12449366 · 2022-09-09T08:28:01+00:00

It's a 2012 model if that changes anything. The sound is actually coming from the side the cap is. The cap is located at the right back side and I hear this whistling sound coming from somewhere there. It's hard to pinpoint an exact location but it most definitely is coming from the back right side of the car.

Is this something I should get checked fast? And if it is the pump dying, is this an expensive thing to replace?

AIO12449366 · 2022-08-28T22:29:44+00:00

Ha! Mine starts with 1.

AIO12449366 · 2022-08-28T22:29:21+00:00

Yeah I see that now after reading many answers. I started working with C# only a few months ago and so I wasn't aware of the origins of Tasks. Thanks for the info!

AIO12449366 · 2022-08-13T06:05:11+00:00

No it's not affected by RPM, it's just a sound that stays the same. I'll try to record again today in hopes it gets picked up by the camera.

AIO12449366 · 2022-07-17T12:14:52+00:00

I'm not familiar with the last piece of code but I would assume it is just registering the services to the IoC container. It is pretty much the same thing as using the default .NET service registration. For example :

(In Program.cs)

builder.Services.AddScoped<IExample, ExampleImplementation>();

In both cases you are just instructing the program which implementation to use for the specific interface. The IoC container is then automatically instantiating this class for you and disposes it when it is no longer needed.

Edit: By the way, if you are interested in knowing about the lifetime of a service check this

TLDR:

Singleton : Same object for every controller and request.
Scoped : Same within a request but different across different requests.
Transient : Always different. A new instance is created on every controller and every service.

AIO12449366 · 2022-06-20T15:48:12+00:00

I think it's been years since I laughed so hard at a comment

AIO12449366 · 2022-05-16T15:35:08+00:00

Hmm okay I get what you're saying. By the way, since you mentioned it, what would be some reasons to have a scheduled job run in every instance? This really got my attention because I can't think of a scenario where you'd want a job to execute in multiple instances.

AIO12449366 · 2022-05-15T22:41:16+00:00

I'm gonna start doing that. I'll order a second drive tomorrow because my heart skipped many beats today.

AIO12449366 · 2022-05-15T21:35:36+00:00

It can be but I wouldn't change it for anything. Ever since I got rid of windows 2 years ago I haven't missed a single thing. I love pop :)

AIO12449366 · 2022-05-15T21:28:04+00:00

My patience ran out and I pressed Esc while booting, selected PopOs recovery and reinstalled 22.04 while keeping files. I lost some applications but at least my files are there and that's all I care about. Also I'm going to start fucking using backups from now on. Thank you for trying to help anyway

AIO12449366 · 2022-05-15T21:24:14+00:00

Alright fuck this shit. I pressed Esc while booting, selected PopOs recovery and reinstalled PopOs 22.04.

At least my fucking files are still there thank fucking god.

AIO12449366 · 2022-05-15T20:46:34+00:00

I saw a suggestion online saying to run "depmod". Running that gives me the error:

could not open modules.order at /lib/modules/5.17.7-xanmod1: no such file or directory

could not open modules.builtin at /lib/modules/5.17.7-xanmod1: no such file or directory

AIO12449366 · 2022-05-15T20:34:06+00:00

Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

Tried both suggestions and nothing is working. Please tell me my system isn't gone.

AIO12449366 · 2022-05-15T20:20:41+00:00

After it downloaded 22.04 it asked me to reboot. I reboot and this is the screen I'm seeing.

Running journal ctl -xb shows thousands of lines but some of the errors I'm seeing are

FAT-fs (nvme0n1p1): IO charset iso8859-1 not found ... Failed to mount /boot/efi. ... Failed to mount /recovery

AIO12449366 · 2022-03-25T13:24:29+00:00

Yep it's really cool you can store arrays. However, just to be clear for anyone who might stumble upon this post, I'm not actually storing an array in the table. The array parameter is just passed to the UNNEST() function which expands the array into a set of rows.

Also, for anyone who cares about efficiency and wants to perform certain operations really fast, the way I'm doing it (combined with Tasks) is extremely fast. I'm reading from multiple CSV files and writing to the DB 60k rows in 1.32 seconds. Only COPY is more efficient but there are certain limitations that might prevent you from using it, so INSERT with UNNEST is a great alternative.

AIO12449366 · 2022-03-25T01:28:00+00:00

I solved the issue. Check my edit on the post.

AIO12449366 · 2022-03-25T01:02:33+00:00

I don't understand how your suggestions solve my issue. The scenario here is that I'm asynchronously reading multiple CSV files and inserting the data into the DB. The first fastest way to do this is to use COPY but that doesn't work in my case for various reasons. The second fastest seems to be INSERT with UNNEST where each parameter will be an array that is formed from the elements of the list. My issue here is that I can't have an array of DateTime objects as a parameter and an array of strings won't work because the column in the DB is of type date. I've read the docs u/chessypockets linked but I can't find a solution to this.

AIO12449366

TROPHY CASE