Final 1.0.0 errors and crash report....

[jkandasa]

@skywatch Looks like your database corrupted. You may need to restore from your backup.

[skywatch]

I can't get a http connection so how to do this manually? The api only shows how to do it from the console and I cannot access that at all!

Thanks

[jkandasa]

@skywatch do a fresh installation. then restore from your backup

[Tag]

@skywatch

I looked at the data base backup, it seems to be one giant sql file....
(it is a zip in the backup zip file, you can extract it with the unzip command)

Still wondering why your database can get corrupted, it might be that if you restore your database, you restore the corruption also. Just for testing purpouses, you could start with a completely fresh install.

• Are you 100% sure that the medium you use (sdcard/harddrive) is in good condition?
• Which version of Java are you using? (I use the oracle one and that works fine)

[skywatch]

@jkandasa

Now I feel stupid!

@Tag

Media was new for this project and passed h2testw no issues (sandisk)...

Java is.....

 apt list --installed | grep java

WARNING: apt does not have a stable CLI interface yet. Use with caution in scripts.

java-common/oldstable,now 0.52 all [installed]
javascript-common/oldstable,now 11 all [installed,automatic]
libhsqldb1.8.0-java/oldstable,now 1.8.0.10+dfsg-3 all [installed,automatic]
libjavascriptcoregtk-3.0-0/stable,now 1:2.4.1-1rpi53rpi1g armhf [installed,automatic]
libreoffice-java-common/stable,now 1:4.3.3-2+rpi4 all [installed]
libservlet2.5-java/oldstable,now 6.0.45+dfsg-1~deb8u1 all [installed]
oracle-java8-jdk/stable,now 8u65 armhf [installed]

So looks OK to me.

Back running on backup image again and will see what happens. The 240v is from a filtered and spike protected distribution, nothing else power from this has any problem. Maybe I'll swap out the 5V 3A psu and see if that helps, but I don't think that is the issue here.

[Tag]

@skywatch

Dont feel stupid, not asking is stupid

So we assume the media is okay, good!!

Looking into java...seems your java is a bit older... 8u65, below is the version I use..

apt list --installed | grep java

WARNING: apt does not have a stable CLI interface yet. Use with caution in scripts.

java-common/oldstable,now 0.52 all [installed,automatic]
oracle-java8-installer/xenial,now 8u151-1~webupd8~0 all [installed]

Some time ago i created this topic about java on the RPI
It would be intersting to see how the issue evolves if you update to the latest java version...

[skywatch]

@Tag
Thanks for the response. Good idea, although I update/upgrade the pi often I guess if apt doesn't install it then it doesn't know to update it!
I have upgraded and now have....

 $ apt list --installed | grep java

WARNING: apt does not have a stable CLI interface yet. Use with caution in scripts.

java-common/oldstable,now 0.52 all [installed]
javascript-common/oldstable,now 11 all [installed,automatic]
libhsqldb1.8.0-java/oldstable,now 1.8.0.10+dfsg-3 all [installed,automatic]
libjavascriptcoregtk-3.0-0/stable,now 1:2.4.1-1rpi53rpi1g armhf [installed,automatic]
libreoffice-java-common/stable,now 1:4.3.3-2+rpi4 all [installed]
libservlet2.5-java/oldstable,now 6.0.45+dfsg-1~deb8u1 all [installed]
oracle-java8-jdk/stable,now 8u65 armhf [installed]

@jkandasa

May I suggest it would be a good idea to add to the documentation @tags java upgrade instructions with a reminder to check this manually at regular intervals? - It might help reduce the number of suport requests.

You guys are brilliant!

[skywatch]

Hmmmm.....Seems that after d/l and un-packing and installing the new '151' java I still show 8u65......

On config I get a choice as below....

There are 3 choices for the alternative javac (providing /usr/bin/javac).

  Selection    Path                                                Priority   Status
------------------------------------------------------------
  0            /usr/lib/jvm/jdk-8-oracle-arm32-vfp-hflt/bin/javac   318       auto mode
  1            /opt/jdk1.8.0_131/bin/javac                          1         manual mode
* 2            /opt/jdk1.8.0_151/bin/javac                          1         manual mode
  3            /usr/lib/jvm/jdk-8-oracle-arm32-vfp-hflt/bin/javac   318       manual mode

Press enter to keep the current choice[*], or type selection number:

I choose '2' and yet still don't see 151....any ideas?

[jkandasa]

@skywatch What is the result of java -version command?

[skywatch]

Haha - Just as I finished trying again with '152' this time....now I get....

/opt $  java -version
java version "1.8.0_152"
Java(TM) SE Runtime Environment (build 1.8.0_152-b16)
Java HotSpot(TM) Client VM (build 25.152-b16, mixed mode)
pi@HAMASS:/opt $ javac -version
javac 1.8.0_152

But....

pi@HAMASS:/opt $  apt list --installed | grep java

WARNING: apt does not have a stable CLI interface yet. Use with caution in scripts.

java-common/oldstable,now 0.52 all [installed]
javascript-common/oldstable,now 11 all [installed,automatic]
libhsqldb1.8.0-java/oldstable,now 1.8.0.10+dfsg-3 all [installed,automatic]
libjavascriptcoregtk-3.0-0/oldstable,now 1:2.4.1-1rpi53rpi1g armhf [installed,automatic]
libreoffice-java-common/oldstable,now 1:4.3.3-2+rpi4 all [installed]
libservlet2.5-java/oldstable,now 6.0.45+dfsg-1~deb8u1 all [installed]
oracle-java8-jdk/oldstable,now 8u65 armhf [installed]

So confusing, no?

[skywatch]

So on Friday I moved the sd card to a pi3 and attached the gw and rtc to that. So far no problems. Maybe it was the older Java, maybe it was the pi2. The reason for the move is to try and avoid problems with the sd card by having it boot directly from usb. I have not decided whether to use a spare usb stick or to go for a pi drive, I'll look into options more this week I hope.

Thanks for the support gents!

[Tag]

Good!, Welcome!
Hope the issues are fixed now!

[skywatch]

@Tag
See update here....

https://forum.mycontroller.org/topic/224/booting-rpi3-mycontroller-from-usb-only