Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Brickstore database update time out #813

Closed
wiaone87 opened this issue Jan 16, 2024 · 15 comments
Closed

Brickstore database update time out #813

wiaone87 opened this issue Jan 16, 2024 · 15 comments

Comments

@wiaone87
Copy link

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

image

BrickStore 2024.1.2 (build: 1143)

  • brickstore.ldraw: 15 Oct 2023 09:19:54 +0200
  • brickstore.locale: pl
  • build.arch: x86_64
  • build.compiler: Microsoft Visual-C++2019 (192930153)
  • build.date: 2024-01-11T21:19:23.000
  • build.host: fv-az662-930
  • build.number: 1143
  • build.qt.version: 6.6.1
  • hw.cpu: AMD Ryzen 9 3900X 12-Core Processor
  • hw.cpu.arch: x86_64
  • hw.gpu: NVIDIA GeForce RTX 4070
  • hw.gpu.arch: nvidia
  • hw.memory.gb: 31.9
  • os.arch: x86_64
  • os.productname: Windows 11 Version 22H2
  • qt.debug: false
  • qt.platformname: windows
  • qt.version: 6.6.1
  • windows.tabletmode: false
@rgriebl
Copy link
Owner

rgriebl commented Jan 16, 2024

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.

@rgriebl rgriebl pinned this issue Jan 16, 2024
@wheeliegal
Copy link

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

@rgriebl
Copy link
Owner

rgriebl commented Jan 17, 2024

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
Copy link

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

@Brick-Slayer
Copy link

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
Copy link

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
Copy link

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
Copy link

froqzy commented Jan 17, 2024

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
Copy link

froqzy commented Jan 17, 2024

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
Copy link
Owner

rgriebl commented Jan 17, 2024

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
Copy link

froqzy commented Jan 17, 2024

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
Copy link
Owner

rgriebl commented Jan 17, 2024

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

@rgriebl
Copy link
Owner

rgriebl commented Jan 17, 2024

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
Copy link

froqzy commented Jan 17, 2024

Awesome work and thanks for the updates!

@rgriebl
Copy link
Owner

rgriebl commented Jan 18, 2024

The server is reachable again now.

@rgriebl rgriebl closed this as completed Jan 18, 2024
@rgriebl rgriebl unpinned this issue Jan 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

8 participants