on-rev reliability ?

[Pierre Sahores]

jbv,

Le 9 juil. 2013 à 20:32, jbv at souslelogo.com a écrit :

> Meanwhile, one of our accounts was moved to a new server (pancake) but it
> appeared that
> something went wrong during the move, because we experienced random bugs
> in some
> scripts that lead to corrupted data in DBs and random errors in
> automatically generated
> pdf files (invoices for instance)... To solve this problem, I had to move
> all scripts, files and
> DBs to another account of ours still on thor…

AFAIK, the PostgreSQL version installed on pancake (8.4.13) > the one i relied before on Loki (8.1.x) needed me to update some of my revDB calls to get my LC-Server apps OK. Was not a LC problem but a PostgreSQL one. If your LC-Server powered apps don't rely on a PostgreSQL backend, the problem should be elsewhere (MySQL ?) but in case of yes, see below what revDB call update went needed on my side, very simple to the end (all the statements containing a WHERE close have to be updated) :

What worked fine before against PostgreSQL 8.1.x :

>  put "SELECT * FROM" && CustArticles && "WHERE article_chemin = '" & tparam2 & "'" into sqlStatement
>  put revQueryDatabase(myDatabaseID,sqlStatement) into dbCursorID


need to become against PostgreSQL 8.4.13 :

>  put "SELECT * FROM" && CustArticles && "WHERE CAST(article_chemin as TEXT) = '" & tparam2 & "'" into sqlStatement
>  put revQueryDatabase(myDatabaseID,sqlStatement) into dbCursorID

Same kind of pg syntax update are needed against the DELETE … WHERE and UPDATE … WHERE statements.

That said, pancake is against my own LC-Server/PostgreSQL production apps (previously installed on loki) a very trustable and reliable platform with no down time at all (alike this seems to happen, time to time, against some other on-rev servers even if my own apps went running perfectly fine too when they went hosted on loki).

> widestep
> 
> Uptime	Outages	Response time
> 100.00%	1	462 ms
> 
> Downtimes
> 
> From	To	Downtime
> 2013-06-12 12:13:27	2013-06-12 12:14:27	0h 01m 00s
> 
> This is a scheduled report from Pingdom. If you wish to no longer receive this report you can unsubscribe by logging in to My Pingdom and update your email report settings.
> 
> 
> Copyright © 2013 Pingdom AB

HTH,
--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.com