vbz Posted August 2, 2011 Report Share Posted August 2, 2011 Labdien! Ir uzrakstīta sistēma ar php un db PostgreSql, izmantots php freimworks codeigniter. Uz viena hosta, kur uzlikta sistēma , neregulāri, bet brīžiem izmet kļūdu pie jebkura veida querija: ERROR - 2011-08-02 11:48:05 --> Query error: FATAL: terminating connection due to administrator command server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Tajā pašā laikā uz cita hosta strādā kā pulkstenis. php.ini pgsql konfigurācijas identiskas, db versijas atšķirās. Varbūt kāds saskāries ar līdzīgu problēmu. Quote Link to comment Share on other sites More sharing options...
Faks Posted August 2, 2011 Report Share Posted August 2, 2011 (edited) Izskatas ka hostinga cpu usage laikam 100% tāpec automātiski taisa drop tavam connect un teu ir errors :) iesaku convertēt PostgreSql uz mysql ! varbūt noder http://www.lightbox.ca/pg2mysql.php Edited August 2, 2011 by Faks Quote Link to comment Share on other sites More sharing options...
daGrevis Posted August 2, 2011 Report Share Posted August 2, 2011 PostgreSql jau nav slikts... kā M$ Access (tas vispār skaitās kā SQL?). Quote Link to comment Share on other sites More sharing options...
vbz Posted August 2, 2011 Author Report Share Posted August 2, 2011 nu neder nekādas konvertācijas, nevar atrast problēmas sakni:), kļūda izmetās neregulāri, var uztaisīt 10x refresh, 11 izmetīsies kl'jūda Quote Link to comment Share on other sites More sharing options...
daGrevis Posted August 2, 2011 Report Share Posted August 2, 2011 Nu uztaisi 'exception' ja nevar savienoties un izvadi smuku paziņojumu - 'We have temporary problems... Check back after a few seconds.'. Škiet, ka ir tā, kā Faks saka. Quote Link to comment Share on other sites More sharing options...
rpr Posted August 3, 2011 Report Share Posted August 3, 2011 iesaku convertēt PostgreSql uz mysql ! varbūt noder ar ko tu vari pamatot savu ieteikumu? es ieteiktu parunāt ar savu hostētāju. Quote Link to comment Share on other sites More sharing options...
vbz Posted September 1, 2011 Author Report Share Posted September 1, 2011 (edited) vaina bija tur, ka tajā momentā, kad pazūd konekcija, postgresql izpilda autovacuum procesu Varbūt nākotnē kādam tas var noderēt ... Edited September 1, 2011 by vbz Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.