Community @ The Turning Gate

Support community for TTG plugins and products.

You are not logged in.

#1 2018-09-14 08:08:20

michilge
Member
From: Sprockhövel, Germany
Registered: 2013-04-15
Posts: 196
Website

Backlight 2 installation - Database update failed

Hello all,

I just started the Backlight installer. It seemed successful until I clicked "Proceed to Backlight".
After entering my credentials the database update started but seemingly did not finish.
I got this output:

Updating TTG Backlight from version 1.2.2 to 2.0.0
Backing up databases...
Backed up master.sq3
Upgrading to version 1.2.3...
Update to 1.2.3 completed
Upgrading to version 1.9.1...
Updating settings
Update to 1.9.1 completed
Upgrading to version 1.9.2...
Migrating settings
Unable to upgrade to version 1.9.2
Error message: SQLSTATE[HY000]: General error: 10 disk I/O errorSQLSTATE[HY000]: General error: 1 cannot rollback - no transaction is active|#0 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/helpers/GenericUpgradeHelper.php(111): PDO->rollBack() #1 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/helpers/GenericApplicationHelper.php(138): GenericUpgradeHelper->upgradeIfNeeded() #2 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/Framework.php(440): GenericApplicationHelper->checkUpgrade(Array) #3 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/Framework.php(151): Framework->initApplication() #4 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/Framework.php(41): Framework->init() #5 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/index.php(31): Framework->__construct('..', Array) #6 {main}|URL: /backlight/index.php

That's beyond my scope, I'm afraid.

As Ben might remember, there had been an SQLite issue with my provider recently. The essence was that SQLite3 did not have access to the temporary directory it tried to write to. The provider helped in the end by reluctantly setting the environment variable TMPDIR to a path that is writeable. According to phpinfo() this setting is still active.


The long story with all the try and error is here:
http://community.theturninggate.net/vie … hp?id=8723


Thank You in advance for Your help.
Michael

Offline

#2 2018-09-14 08:18:57

Matthew
Administrator
From: Seoul, South Korea
Registered: 2012-09-24
Posts: 5,390
Website

Re: Backlight 2 installation - Database update failed

Similar error in this post. Give it a look and let us know whether that gets you past the problem.
http://community.theturninggate.net/vie … hp?id=8909


Campagna Pictures, http://campagnapictures.com
The Turning Gate, http://theturninggate.net

Offline

#3 2018-09-14 08:28:48

michilge
Member
From: Sprockhövel, Germany
Registered: 2013-04-15
Posts: 196
Website

Re: Backlight 2 installation - Database update failed

Hi,

sorry, doesn't help. I already was at 1.2.2.
To do as Ben proposed, I must log into backlight. Whenever I try this, I get the output as above.

My PHP version is 7.1.
The provider announced to switch off 5.6 soon.

The ftp-account I created for Ben is still active. credentials in my mail from June, 7 2018.

Michael

Offline

#4 2018-09-14 12:59:33

Ben
Moderator
From: Melbourne, Australia
Registered: 2012-09-29
Posts: 3,709

Re: Backlight 2 installation - Database update failed

Matthew wrote:

Similar error in this post. Give it a look and let us know whether that gets you past the problem.
http://community.theturninggate.net/vie … hp?id=8909

Not all upgrade errors are the same.  You have to see what the reported error is. 

This one looks like an issue writing to the disk.  Michael, do you have a disk quota that you may have reached?

Offline

#5 2018-09-14 17:31:24

michilge
Member
From: Sprockhövel, Germany
Registered: 2013-04-15
Posts: 196
Website

Re: Backlight 2 installation - Database update failed

Hi Ben,

55% of my quota is unused.
I read something about a transaction. Can it have to do with journal settings?

When I open the log in backlight/data/admin/logs. I don't read about the I/O error. But in my browser I see both.

[14-Sep-2018 10:23:25] ERROR: SQLSTATE[HY000]: General error: 1 cannot rollback - no transaction is active|#0 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/helpers/GenericUpgradeHelper.php(111): PDO->rollBack()#1 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/helpers/GenericApplicationHelper.php(138): GenericUpgradeHelper->upgradeIfNeeded()#2 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/Framework.php(440): GenericApplicationHelper->checkUpgrade(Array)#3 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/Framework.php(151): Framework->initApplication()#4 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/Framework.php(41): Framework->init()#5 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/index.php(31): Framework->__construct('..', Array)#6 {main}|URL: /backlight/index.php

Offline

#6 2018-09-14 20:21:41

alfred
Member
Registered: 2013-06-08
Posts: 122

Re: Backlight 2 installation - Database update failed

Hi Michael, Ben,
same hoster same problem. Exactly the same error message. I will have to revert back to Backlight 1.
I am definitely out of my depth here. I had feared this would be the case, but thought I needed to give it a try to confirm it is something related to our hoster.

Alfred

Offline

#7 2018-09-14 20:45:12

michilge
Member
From: Sprockhövel, Germany
Registered: 2013-04-15
Posts: 196
Website

Re: Backlight 2 installation - Database update failed

Hi again,

Ben's question has something to it. My research also pointed in the direction of diskspace.
The user_tmp path is outside of the root I can access via ftp.
It might well be that ther is a separate quota that isn't shown in the customer admin panel.
Our hoster has a script that is claimed to show the content of the TEMPDIR.
That script gives no result as if the user_tmp where empty.
This may be true, but it can also be that the script doesn't work due to changes in permission settings. No way to verify.
I tried contacting the hoster with the question, if they could check my user_tmp.
First phone call was frustrating. They pointed me to the error logs, where I have masses of missing file errors. But they are due to the fact that I moved the old content of the Backlight folder out of the way.

Alfred: As soon as they send me a ticket number, I will tell them, that You have the problem too.

Let's hope it can be solved without their assistance.

Offline

#8 2018-09-17 22:50:59

michilge
Member
From: Sprockhövel, Germany
Registered: 2013-04-15
Posts: 196
Website

Re: Backlight 2 installation - Database update failed

Hi again,

I finally have an answer from Hosteurope. They have not set a separate space quota for the user_tmp. It is accounted on my regular quota. Since > 10 GB of my Webspace are free, space should not be the cause of the problem.
They put in place a test script that allows me to verifiy that my user tmp is indeed writeable and also that it is empty. No left over stuff cluttering around.

I had proposed them to point the environment variable TEMPDIR which SQLite uses to find a place for temporary stuff to a location within my webspace where I could monitor what is going on there.
They refused that and proposed I should change to a dedicated Server or vServer. 

@Ben: I would be glad if You could point out what steps it takes to switch back to Backlight 1:
Restoring the original content of the backlight directory is trivial. I already did that.
Which of the Database Backups must be reinstalled and what else has to be done to rollback the steps performed by the installer?

I want ot rollback and regret having applied the installer on my live site without testing.

@Alfred: Hosteurope weren't service oriented in my perception. They also weren't impressed by the fact that I'm not their only customer experiencing the problem. I have not yet decided what is best: switching to a virtual server or just trying another hoster. I feel like trying another shared hosting offer by all-inkl with a test domain first. I will keep You updated.

Cheers for now
Michael

Offline

#9 2018-09-17 23:04:34

Ben
Moderator
From: Melbourne, Australia
Registered: 2012-09-29
Posts: 3,709

Re: Backlight 2 installation - Database update failed

Hi Michael, sorry to hear that your hosting issues have continued.
The installer has likely made changes to your database files.  The database upgrade should have made copies of the previous versions within each respective database_backups directory.  To copy the main three back, see whether you have the files to make these copies (all paths assume you are in the backlight/data directory):

publisher/database_backups/master_3_2_3.sq3 to publisher/master.sq3
designer/database_backups/master_1_2_3.sq3 to designer/master.sq3
admin/database_backups/master_1_2_3.sq3 to admin/master.sq3

I am not sure if keeping any -journal files around will cause issues (e.g. admin/master.sq3-journal).  Perhaps make a copy of these and delete them

Offline

#10 2018-09-18 03:02:20

Daniel Leu
Moderator
Registered: 2012-10-11
Posts: 983
Website

Re: Backlight 2 installation - Database update failed

Ben wrote:

Hi Michael, sorry to hear that your hosting issues have continued.
The installer has likely made changes to your database files.  The database upgrade should have made copies of the previous versions within each respective database_backups directory.  To copy the main three back, see whether you have the files to make these copies (all paths assume you are in the backlight/data directory):

publisher/database_backups/master_3_2_3.sq3 to publisher/master.sq3
designer/database_backups/master_1_2_3.sq3 to designer/master.sq3
admin/database_backups/master_1_2_3.sq3 to admin/master.sq3

I am not sure if keeping any -journal files around will cause issues (e.g. admin/master.sq3-journal).  Perhaps make a copy of these and delete them

Michael, before rolling back to BL1, please make a backup of your /backlight/data directory!


Daniel Leu | Photography   
DanielLeu.com

Offline

#11 2018-09-18 20:25:07

alfred
Member
Registered: 2013-06-08
Posts: 122

Re: Backlight 2 installation - Database update failed

Michael, thanks for keeping me in the loop.
I have similar sentiments towards host europe and I might try to host my site with an old friend who runs a small hosting company as a second job. May not be the ideal solution in the long run, but like you, I need to try something different I am afraid. I will watch your case and keep you informed how my attempt goes.

Anyone else in this forum who hosts a Backlight site in Germany? If someone has a recommendation for a good hoster, please post it here or probably better send me a PM. I am happy to forward such info to Michael, as well and report back here once we have found a suitable alternative.

Alfred

Offline

#12 2018-09-19 00:24:42

kolohe280
Member
Registered: 2017-08-23
Posts: 13

Re: Backlight 2 installation - Database update failed

While I'm not in Germany, I use 1and1, which I believe is based in Germany.  I've been with them for close to 20 years and have never had any significant problems with their service, just a few little ones that most of the time were because I wasn't paying attention.  Backlight works great there.  Their prices are very reasonable for what you get, at least by US standards.

Offline

#13 2018-09-19 06:08:53

Rainer Goergen
Member
From: Trier, Germany
Registered: 2016-05-01
Posts: 278
Website

Re: Backlight 2 installation - Database update failed

One.com

Online

Board footer

Powered by FluxBB