Community discussions

MikroTik App
 
User avatar
Safety1st
just joined
Topic Author
Posts: 4
Joined: Wed May 15, 2019 1:17 am
Location: Moscow, Russia

Objects dissapears

Thu Oct 27, 2022 4:11 pm

Hi there! Since a few days we've noticed that newly created objects disappear from the maps after dude (or system) rebooting. If they are selected from the Devices tab and Copy button is pressed, they appear again. We use v6.49.7, clean database with only objects is 3MB. We've found out that the problem is located inside the 'objs' SQLite3 table. But we don't know that object should we change to fix that.
 
User avatar
Safety1st
just joined
Topic Author
Posts: 4
Joined: Wed May 15, 2019 1:17 am
Location: Moscow, Russia

Re: Objects dissapears

Fri Oct 28, 2022 5:49 pm

We've found the record that made objects disappear. After deleting it from the base everything works like a charm.
 
User avatar
jigsaw
just joined
Posts: 9
Joined: Mon Jul 19, 2021 2:44 pm

Re: Objects dissapears

Thu May 11, 2023 5:24 pm

Do you have more info on this?

I have the same problem and that is exactly the idea I had - that one of the objects is somehow damaged which prevents any objects added after it from being placed on a map.
How did you find which object was it?
I'm looking at the blob field in 'objs' table with no clue how to go about reading it properly :(
 
User avatar
jigsaw
just joined
Posts: 9
Joined: Mon Jul 19, 2021 2:44 pm

Re: Objects dissapears

Fri May 12, 2023 1:22 pm

Image
 
User avatar
normis
MikroTik Support
MikroTik Support
Posts: 26287
Joined: Fri May 28, 2004 11:04 am
Location: Riga, Latvia

Re: Objects dissapears

Fri May 12, 2023 2:47 pm

Perfection :D unfortunately, I can't help. No idea which bad object caused the issue for OP
 
User avatar
rextended
Forum Guru
Forum Guru
Posts: 11967
Joined: Tue Feb 25, 2014 12:49 pm
Location: Italy
Contact:

Re: Objects dissapears

Fri May 12, 2023 2:58 pm

@jigsaw
Simply reload your latest working backup.

Because you have one latest working backup, right?
 
User avatar
jigsaw
just joined
Posts: 9
Joined: Mon Jul 19, 2021 2:44 pm

Re: Objects dissapears

Sat May 13, 2023 1:23 pm

Backups had not been tested for a while and turned out to be unusable. When I launch import-db it almost immediately fails with "import failed" without any more details.
So unfortunately no - I have no working backups from before this issue started :(

Besides - turns out that it started at least 3 weeks ago. Probably even more. I'd really like to not lose all those changes made during this time because of one bad entry.

There are some scripts around here that can supposedly decode object data. I'll try those and see if I can spot the damaged object.

Who is online

Users browsing this forum: No registered users and 9 guests