Menu
What's new

OpenALPR Webhook Processor for IP Cameras

IReallyLikePizza2

IReallyLikePizza2

Known around here
Joined
May 14, 2019
Messages
1,918
Reaction score
4,503
Location
Houston
I ended up reverting the snapshot, running on the old version again. On the newer version for some reason I have no docker container logs, so I can't really even tell what its doing

With it being a VM, if I increase the disk size even more to do the migration, there is no nice easy way to shrink it back down again

I think the plan now is to increase the size of the current VM, hopefully let it finish the migration and then move it all to a new VM with a reasonable about of space
 
C

CamCrazy

Pulling my weight
Joined
Aug 23, 2017
Messages
485
Reaction score
201
Location
UK
IReallyLikePizza2 said:
I ended up reverting the snapshot, running on the old version again. On the newer version for some reason I have no docker container logs, so I can't really even tell what its doing

With it being a VM, if I increase the disk size even more to do the migration, there is no nice easy way to shrink it back down again

I think the plan now is to increase the size of the current VM, hopefully let it finish the migration and then move it all to a new VM with a reasonable about of space
Click to expand...
Sounds like a good plan, mine is ticking over fine today on Windows 11 machine, not decided whether to retain existing database or start fresh.
 
IReallyLikePizza2

IReallyLikePizza2

Known around here
Joined
May 14, 2019
Messages
1,918
Reaction score
4,503
Location
Houston
Still no logs for the container for some reason, but the phase of 100% CPU usage on 1 core while the DB increases in size seems to have completed, and now we're onto some kind of part where its multithreaded

Still no Web UI yet, hopefully it comes up eventually
 
IReallyLikePizza2

IReallyLikePizza2

Known around here
Joined
May 14, 2019
Messages
1,918
Reaction score
4,503
Location
Houston
It finished! And now I also have Docker logs

So far, so good! I'm on 5.2.0 as going to 5.3.0 gave me an error, so now I'm on 5.2.0 I'm going to make sure its all good before moving to 5.3.0
 
IReallyLikePizza2

IReallyLikePizza2

Known around here
Joined
May 14, 2019
Messages
1,918
Reaction score
4,503
Location
Houston
Going to 5.3.0 seems to work, and the Webhooks are getting through because I see the HTTP 405 errors since I never updated the URL, but logging in gives me "Internal Server Error" in the top left

I reverted the snap back to 5.2.0, and will try again tomorrow. Very happy to finally be on 5.2.0
 
IReallyLikePizza2

IReallyLikePizza2

Known around here
Joined
May 14, 2019
Messages
1,918
Reaction score
4,503
Location
Houston
mlapaglia said:
sqlite doesn't handle drop/create operations very well. while your db size has double, half of it is "unused" sqlite doesn't give up storage space unless you run a vacuum. you can run it yourself if you want to shrink the db
https://stackoverflow.com/questions/18126997/how-to-vacuum-sqlite-database
Try running a browser incognito and see if it works then, you might have some frontend code cached.
Click to expand...
Should I be running this from within the container? I tried and get an error that sqlite3 is not found

# sqlite3 /app/config/processor.db 'VACUUM;'
sh: 11: sqlite3: not found
 
IReallyLikePizza2

IReallyLikePizza2

Known around here
Joined
May 14, 2019
Messages
1,918
Reaction score
4,503
Location
Houston
Ended up taking about 11 hours in total, back down to 164GB, so what it was before the upgrade

So now I'm on 5.2.0 with a compacted DB. Maybe later on I will be pushing forward to 5.3.0
 
IReallyLikePizza2

IReallyLikePizza2

Known around here
Joined
May 14, 2019
Messages
1,918
Reaction score
4,503
Location
Houston
Ah shoot! I have a problem

Currently on 5.2.0, and its getting new plates, and I get the little alert for every new plate with the WebUI up, however the plate doesn't show unless I refresh the page

Also, the search does not work, and if I try and add a new user, it doesn't save. Anyone got any ideas of the problem? Tried clearing cache and all that jazz, nothing

If I upgrade to 5.3.0, I got an error in the Docker logs about user auth, so I'm thinking there may be an issue with the user account, I was going to make a temp user to test, but can't save it
 
Last edited:
IReallyLikePizza2

IReallyLikePizza2

Known around here
Joined
May 14, 2019
Messages
1,918
Reaction score
4,503
Location
Houston
Well, I don't know what fixed it. I was getting frustrated and moved to 5.1.1, still broken. Move to 5.1.0, still broken, 5.0.0. Back to 5.2.0, still broken

Now, it just works...

Still can't edit users, maybe I'll wait a few more hours and that will fix itself too!
 
C

CamCrazy

Pulling my weight
Joined
Aug 23, 2017
Messages
485
Reaction score
201
Location
UK
IReallyLikePizza2 said:
@CamCrazy did you say you have an issue with plates being counted twice? Because now with my fully working setup, I have the same issue!


View attachment 196456

View attachment 196457
Click to expand...
Sorry, been tied up with work, yes, I did have duplicate plates but that was due to me running the system on original machine at the same time, once disabled on original machine, duplicates stop. Sorry, that wasn't helpful for you. With the latest release, in theory you may need to check permissions on the db file also.

I tried moving my original db to the new install (should that just work!?) and docker fails to run, logs show SQLite Error 11: 'malformed database schema (RawPlateGroups) - invalid rootpage. IP address on the new machine is different, all else identical, I checked permissions on the db file.

Sorry for slow reply :(
 
IReallyLikePizza2

IReallyLikePizza2

Known around here
Joined
May 14, 2019
Messages
1,918
Reaction score
4,503
Location
Houston
CamCrazy said:
Sorry, been tied up with work, yes, I did have duplicate plates but that was due to me running the system on original machine at the same time, once disabled on original machine, duplicates stop. Sorry, that wasn't helpful for you. With the latest release, in theory you may need to check permissions on the db file also.

I tried moving my original db to the new install (should that just work!?) and docker fails to run, logs show SQLite Error 11: 'malformed database schema (RawPlateGroups) - invalid rootpage. IP address on the new machine is different, all else identical, I checked permissions on the db file.

Sorry for slow reply :(
Click to expand...
Interesting, did the original count on all the existing plates go back down?

Are you sure that was the cause? I can't see how running 2 completely independent systems would double the count on one

I'm starting to wonder if I should just roll back before all of this back to a v4 release
 
IReallyLikePizza2

IReallyLikePizza2

Known around here
Joined
May 14, 2019
Messages
1,918
Reaction score
4,503
Location
Houston
CamCrazy said:
Do both duplicates show the image or a ? symbol??
Click to expand...
Its the other way around for me, for example I see 11 entries which is correct, but it reports that the plate has been seen 22 times

If I find a net new plate, it reports that its been here 2 times, but when I search, it only brings back 1 time
 
C

CamCrazy

Pulling my weight
Joined
Aug 23, 2017
Messages
485
Reaction score
201
Location
UK
IReallyLikePizza2 said:
Interesting, did the original count on all the existing plates go back down?

Are you sure that was the cause? I can't see how running 2 completely independent systems would double the count on one

I'm starting to wonder if I should just roll back before all of this back to a v4 release
Click to expand...
Yes, it was the cause, sorry, just seen your comment about 11 captures but 22 times! that is bizarre? how is that happening.
 
C

CamCrazy

Pulling my weight
Joined
Aug 23, 2017
Messages
485
Reaction score
201
Location
UK
I am wondering if I need to upgrade my original version 4.x.x to newer release before moving the database? wonder if that would help, thought I was winning there for a minute :)

**Update, dropped back to release 5.0.0 and on running the container it is sitting at 18-20% CPU so hopefully doing its thing now...will wait for CPU to drop then try opening.
 
Last edited:
You must log in or register to reply here.
Top