uiDivStats Hanging at: Creating database table and enabling write-ahead logging...

[CMc]

hey @Jack Yaz, having issues with hanging at the following when opening or trying to reinstall:

uiDivStats: Creating database table and enabling write-ahead logging...

Any suggestions? Have looked through previous threads and tried the other proposed. All ep are upto date.

Have tried:

# /usr/sbin/curl --retry 3 "https://raw.githubusercontent.com/jackyaz/uiDivStats/master/uiDivStats.sh" -o "/jffs/scripts/uiDivS
tats" && chmod 0755 /jffs/scripts/uiDivStats && /jffs/scripts/uiDivStats install

(Hangs at creating database... but got me updated and off amtm pending update list)

# opkg update && opkg remove --autoremove sqlite3-cli && opkg install sqlite3-cli

OUTPUTS;

Downloading http://bin.entware.net/aarch64-k3.10/Packages.gz
Updated list of available packages in /opt/var/opkg-lists/entware
Removing package sqlite3-cli from root...
Installing sqlite3-cli (3330000-1) to root...
Downloading http://bin.entware.net/aarch64-k3.10/sqlite3-cli_3330000-1_aarch64-3.10.ipk
Configuring sqlite3-cli.

Not sure where next to try

RT-AC86U (aarch64) FW-384.19

 

[JaimeZX]

How long did you wait? I've had it take 5+ minutes to generate the table.

 

[CMc]

How long did you wait? I've had it take 5+ minutes to generate the table.

15+

 

[JaimeZX]

Hm. Dunno then. Sorry.

 

[Jack Yaz]

Check if the db exists in /opt/share/uiDivStats.d

If it does, delete it then relaunch uiDivStats

 

[CMc]

Thanks, it worked.

For others having issues/not sure of code- I used:

Checked that "dnsqueries.db" was listed

# ls /opt/share/uiDivStats.d

then to remove

# rm /opt/share/uiDivStats.d/dnsqueries.db

Took about 10 mins after that

 

[Jack Yaz]

Thanks, it worked.

For others having issues/not sure of code- I used:

Checked that "dnsqueries.db" was listed

# ls /opt/share/uiDivStats.d

then to remove

# rm /opt/share/uiDivStats.d/dnsqueries.db

Took about 10 mins after that

10mins is rather long when the db doesn't already exist... I'd be ready with a replacement USB, perhaps