Comentoplusplus cannot initialize database properly about commentoplusplus HOT 5 CLOSED

Note that if I continually restart commentoplusplus it will eventually run anyway and I can attempt to sign up a user. However that doesn't actually work and gives an error. I can probably provide the additional syslog errors but there doesn't seem to be much point because I'm sure the errors are related to the initial database initialization failing

from commentoplusplus.

And when I try the devel build it works....

from commentoplusplus.

Thanks for the bug report! The errors you're getting appear to be due to the database not being set up by commentoplusplus correctly. The database setup happens by loading in all the migrations in the db/ folder one by one, which creates the appropriate tables, upgrades the database structure from previous commento versions, etc.

From the sound of things, since the make devel build works, it's unlikely to be an issue with the code. What is more likely from the logs is that the folder full of migrations at build/prod/db is incomplete for some reason (filesystem error?) and so the initialisation never quite finishes properly.

Can you please report back the results of ls -la build/prod/db and ls -la build/devel/db?

from commentoplusplus.

prod.txt
dev.txt
prod.txt is ls -la build/prod/db
dev.txt is ls -la build/devel/db

The prod files are all 0 length, which is undoubtedly the problem. I'll try a rebuild and I plan to mix and match binaries and directories today and see the prod binary works with everything else from devel. I'll let you know. The devel binary and scripts etc. seems to be working just fine for me now but I assume it's better to deploy the prod binary in production

from commentoplusplus.

Ah I see the issue, for some reason the file sizes for all of the database schemas are indeed 0 in the build/prod/db folder!

It looks like for some reason the file copy command partially failed? If you copy the schemas over manually it should hopefully fix this issue (or run a make clean && make prod!) Also I think microSD card write failures are quite common in raspberry Pis (I've certainly had a fair few from overuse) so please do check that yours hasn't been worn out!

The devel build process should work just fine but I would highly recommend using the prod build process if you are deploying as it should be getting rid of debug code, run faster and minify the JavaScript :)

from commentoplusplus.