rgriebl / brickstore

An offline BrickLink inventory management tool.
https://www.brickstore.dev/
GNU General Public License v3.0
116 stars 26 forks source link

Brickstore database update time out #813

Closed wiaone87 closed 8 months ago

wiaone87 commented 8 months ago

There is problem with database update, with new version of application.

image

BrickStore 2024.1.2 (build: 1143)

rgriebl commented 8 months ago

The version doesn't matter - the datacenter hosting the server with the database has routing problems. Nothing I can do about it, but should hopefully be up and running again shortly.

wheeliegal commented 8 months ago

this is so upsetting I can't use BrickStore since the new update.

rgriebl commented 8 months ago

UPDATE: Just had a call with the datacenter support: the general routing problem on their side was fixed hours ago, but somehow my server instance still has problems. They are working on it now.

wouterslager commented 8 months ago

Thanks for the update, I just encountered this in the app as well

Brick-Slayer commented 8 months ago

Brick Store worked great yesterday with the newest updated version but now mine is having this issue. I don't think it has been resolved?

RedWolves commented 8 months ago

Brick Store worked great yesterday with the newest updated version but now mine is having this issue. I don't think it has been resolved?

Read the whole message: "but somehow my server instance still has problems. They are working on it now."

Jeremy-Back2BackBrix commented 8 months ago

I'm having the same problem with my Brickstore, I updated it yesterday and it worked fine but today its saying "Socket operation timed out"

froqzy commented 8 months ago

While there's obviously not much that can be done about server issues outside Brickstore, it might be possible to make Brickstore less dependent on having a connection. Currently, the main issue is that after a Brickstore update it apparently needs a fresh database download otherwise Brickstore doesn't function. Possible solution: store the old database locally during the update process, so that Brickstore will always work after updating, even if Bricklink or its servers are down.

froqzy commented 8 months ago

At the risk of going off topic: in general I think that it would be best if Brickstore is able to work offline and use all data from the last available download. This does not just concern the database update, but at least also the "Import Bricklink Order". Each time Brickstore starts up it needs the Bricklink password to access it and if Bricklink either there is something wrong with the password or if Bricklink is down you're not able to access the Order overview. At least if I'm not missing something ;-)

rgriebl commented 8 months ago

The tagline for BrickStore is An offline BrickLink inventory management tool. and that's exactly what it does.

  1. BrickStore only needs a DB update when the DB format changes. Unfortunately that's exactly what happened between 2023.11.2 and 2024.1.2. (just for reference: the DB format changed 10 times during the last 20 years). Reading the old database is not possible, as there is vital information missing.

  2. The BrickLink orders are NOT updated every time you start BrickStore. Everything is stored in an SQL database for later (offline) retrieval. The order list is only updated when you click the update button, OR when BrickStore hasn't retrieved any orders yet and you open the import order dialog.

  3. Even when an update fails, all order data is available offline. This has been like that since forever.

froqzy commented 8 months ago

Thanks for clarifying, and for all your efforts in general - you've made an amazing LEGO inventory tool!

Only point 2 (which is off topic - sorry) is not clear to me: every time I open Brickstore and click the Import / Bricklink Order button it asks for a password. So, without password I cannot access the orders, or am I missing something? I was also under the impression that because of the password request it also initiates a download or is the password request processed offline and if so, why is that needed?

Thanks again!

rgriebl commented 8 months ago

Now I got your (off topic) point: fixed in 6a97e7d

rgriebl commented 8 months ago

UPDATE regarding the DB download: the datacenter guys were hopeful to get it fixed until this evening (CET), but it's (obviously) still not working. Let's hope they get to it tomorrow morning...

froqzy commented 8 months ago

Awesome work and thanks for the updates!

rgriebl commented 8 months ago

The server is reachable again now.