logo

The ConnectWise Control forum has moved to ConnectWise University! This forum has been locked and is in read-only mode. Click here for instructions on how to access the new forum.

Welcome Guest! You can not login or register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Pepijn  
#1 Posted : Thursday, May 11, 2017 1:02:06 PM(UTC)
Pepijn


Rank: Guest

Joined: 5/11/2017(UTC)
Posts: 2
Belgium

Hello,

We are using screenconnect v6.0.11622.6115 and have a problem restoring a corrupt db.
This is a 500MB DB. Surfing the web I found that I should dump the db to a sql file and then create a db file from the sql file.
The problem is that when creating the db file from the sql file I get the error "Error: near line 1198886: Expression tree is too large (maximum depth 1000)"

Is there any way I can get around this without having to compile my own sqlite binary?
Or is there another way I can repair my database?

For now we got it up and running again by just deleting the db and restarting the services.
All of the active clients are reconnecting again, but the "Company" property is not set for most of the agents for some reason.
So It would be really helpful if we get the old DB up and running again.
(Our backups of the db all seem to be in an inconsistent state)

Kr,
Pepijn

Scott  
#2 Posted : Monday, May 22, 2017 1:14:38 PM(UTC)
Scott


Rank: Administration

Medals: Level 4: Wise Old Owl! Received 100 Thanks!

Joined: 3/28/2014(UTC)
Posts: 2,862
United States

Thanks: 3 times
Was thanked: 351 time(s) in 303 post(s)
Against the corrupted database, what does the integrity check return?

Code:
PRAGMA integrity_check;
ScreenConnect Team
Pepijn  
#3 Posted : Tuesday, May 23, 2017 7:23:07 AM(UTC)
Pepijn


Rank: Guest

Joined: 5/11/2017(UTC)
Posts: 2
Belgium

sqlite> pragma integrity_check;
*** in database main ***
On tree page 53765 cell 4: 2nd reference to page 90062
On tree page 90869 cell 0: 2nd reference to page 93843
On tree page 89743 cell 0: 2nd reference to page 116484
On tree page 80160 cell 0: 2nd reference to page 108728
On tree page 78488 cell 0: 2nd reference to page 108733
On tree page 60334 cell 0: 20 of 24 pages missing from overflow list starting at
90902
On tree page 59777 cell 0: 2nd reference to page 114920
On tree page 71714 cell 0: 18 of 20 pages missing from overflow list starting at
107453
On tree page 64550 cell 0: 9 of 14 pages missing from overflow list starting at
116426
On tree page 52378 cell 0: 2 of 26 pages missing from overflow list starting at
95927
On tree page 33097 cell 0: 12 of 17 pages missing from overflow list starting at
105014
On tree page 31044 cell 0: 19 of 23 pages missing from overflow list starting at
116558
On tree page 28400 cell 0: 2nd reference to page 101499
On tree page 21912 cell 0: 2nd reference to page 100823
On tree page 28242 cell 0: 6 of 26 pages missing from overflow list starting at
117019
On tree page 26005 cell 0: 2nd reference to page 116472
On tree page 19390 cell 0: 2nd reference to page 100813
On tree page 18839 cell 0: 2nd reference to page 104986
On tree page 19497 cell 0: 2nd reference to page 107453
On tree page 14039 cell 0: 2nd reference to page 104075
On tree page 11035 cell 0: 2nd reference to page 100646
On tree page 10538 cell 0: 7 of 16 pages missing from overflow list starting at
102109
On tree page 10430 cell 0: 2nd reference to page 108103
On tree page 8852 cell 0: 2nd reference to page 116484
On tree page 7084 cell 0: 2nd reference to page 93740
On tree page 4484 cell 0: 9 of 16 pages missing from overflow list starting at 1
16066
On tree page 4007 cell 0: 2 of 16 pages missing from overflow list starting at 9
6784
On tree page 3830 cell 0: 2nd reference to page 92555
On tree page 3552 cell 0: 2nd reference to page 115971
On tree page 3426 cell 0: 2nd reference to page 116443
On tree page 2921 cell 0: 2nd reference to page 93723
On tree page 2954 cell 0: 1 of 22 pages missing from overflow list starting at 1
00234
On tree page 2719 cell 0: 2nd reference to page 115446
On tree page 2197 cell 0: 3 of 4 pages missing from overflow list starting at 11
6496
On tree page 1970 cell 0: 9 of 13 pages missing from overflow list starting at 1
16081
On tree page 1937 cell 0: 2nd reference to page 108110
On tree page 784 cell 0: 2nd reference to page 115963
On tree page 760 cell 0: 2nd reference to page 101847
On tree page 154 cell 0: 2nd reference to page 105014
On tree page 104 cell 0: 7 of 12 pages missing from overflow list starting at 10
9224
On tree page 91 cell 0: 2nd reference to page 101058
Page 90483 is never used
Page 90793 is never used
Page 90796 is never used
Page 90798 is never used
Page 90802 is never used
Page 90846 is never used
Page 90848 is never used
Page 90850 is never used
Page 90857 is never used
Page 90860 is never used
Page 90867 is never used
Page 90870 is never used
Page 90876 is never used
Page 90878 is never used
Page 90879 is never used
Page 90880 is never used
Page 90881 is never used
Page 90888 is never used
Page 90892 is never used
Page 90901 is never used
Page 92363 is never used
Page 92364 is never used
Page 92374 is never used
Page 92377 is never used
Page 93631 is never used
Page 93634 is never used
Page 93664 is never used
Page 93716 is never used
Page 93766 is never used
Page 93770 is never used
Page 93781 is never used
Page 93787 is never used
Page 93791 is never used
Page 93792 is never used
Page 93798 is never used
Page 93799 is never used
Page 93829 is never used
Page 93911 is never used
Page 93914 is never used
Page 93918 is never used
Page 93919 is never used
Page 93937 is never used
Page 93941 is never used
Page 94591 is never used
Page 94595 is never used
Page 94992 is never used
Page 94998 is never used
Page 94999 is never used
Page 95014 is never used
Page 95017 is never used
Page 95414 is never used
Page 95417 is never used
Page 95421 is never used
Page 95900 is never used
Page 95916 is never used
Page 96652 is never used
Page 96653 is never used
Page 100290 is never used
Page 100591 is never used
sqlite>
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.