"connection is closed" err logged w Postgresql/Tomcat/Quercus

d.bradley

Joined: 2008-09-12
Posts: 6
Posted: Fri, 2008-09-26 15:45


Gallery version: 2.3-RC1 (09/13/2008)
PHP version: 5.2.0 (Quercus)
PHPInfo Link: (attached PHPInfo.txt)
Webserver: Apache Tomcat/6.0.18
Database: Postgresql 8.3
Activated toolkits:
Operating system : Windows Server 2003 R2 SP2
Browser: Firefox 3.0.1

I get to the point where the BIT_OR function is successfully created in the pg_proc table, then there is some problem with creating the DB tables and such.

Here is the stack trace:

Quote:
Error (ERROR_STORAGE_FAILURE)

* in /C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/gallery2/modules/core/classes/GalleryStorage.class at line 927 (PostgreSqlStorage::beginTransaction)
* in /C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/gallery2/modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 75 (PostgreSqlStorage::_guaranteeTransaction)
* in /C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/gallery2/modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1243 (GalleryStorageExtras::_dbInit)
* in /C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/gallery2/modules/core/classes/GalleryStorage.class at line 768 (GalleryStorageExtras::configureStore)
* in /C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/gallery2/modules/core/classes/GalleryModule.class at line 156 (PostgreSqlStorage::configureStore)
* in /C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/gallery2/install/steps/InstallCoreModuleStep.class at line 138 (CoreModule::installOrUpgrade)

Error (ERROR_STORAGE_FAILURE) : Error reading schema table

* in /C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/gallery2/modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1475 (GalleryStorageExtras::_loadTableVersions)
* in /C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/gallery2/modules/core/classes/GalleryStorage.class at line 1468 (GalleryStorageExtras::_updateTableInfo)
* in /C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/gallery2/modules/core/classes/GalleryModule.class at line 405 (PostgreSqlStorage::updateTableInfo)
* in /C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/gallery2/install/steps/InstallCoreModuleStep.class at line 153 (CoreModule::activate)
* in /C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/gallery2/install/index.php at line 164 (InstallCoreModuleStep::processRequest)

Error (ERROR_STORAGE_FAILURE)

* in /C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/gallery2/install/steps/InstallCoreModuleStep.class at line 168 (PostgreSqlStorage::commitTransaction)
* in /C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/gallery2/install/index.php at line 164 (InstallCoreModuleStep::processRequest)

PHPinfo:

Quote:
Quercus

PHP Version => 5.2.0
System => Windows 2003 5.2 x86
Build Date => 20070628T2777
Configure Command => n/a
Server API => CGI
Virtual Directory Support => disabled
Configuration File (php.ini) Path => WEB-INF/php.ini
PHP API => 20031224
PHP Extension => 20041030
Debug Build => no
Thread Safety => enabled
Registered PHP Streams => php, file, http, https

PHP Variables
Variable Value
_REQUEST["G2SETUPSID"] cc05a868561f99a6a21e4ab3bf87394c
_SERVER["USERPROFILE"] C:\Documents and Settings\Default User
_SERVER["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
_SERVER["TMP"] C:\WINDOWS\TEMP
_SERVER["JAVA_HOME"] C:\Program Files\Java\jdk1.6.0_07
_SERVER["CLASSPATH"] .;C:\Program Files\Apache Software Foundation\Tomcat 6.0\lib\servlet-api.jar;C:\Program Files\Apache Software Foundation\Tomcat 6.0\lib\jsp-api.jar;C:\Program Files\Apache Software Foundation\Tomcat 6.0\lib\postgresql-8.3-603.jdbc4.jar
_SERVER["CommonProgramFiles"] C:\Program Files\Common Files
_SERVER["PROCESSOR_ARCHITECTURE"] x86
_SERVER["FP_NO_HOST_CHECK"] NO
_SERVER["OS"] Windows_NT
_SERVER["TEMP"] C:\WINDOWS\TEMP
_SERVER["SystemDrive"] C:
_SERVER["PROCESSOR_LEVEL"] 6
_SERVER["ProgramFiles"] C:\Program Files
_SERVER["Path"] c:\program files\imagemagick-6.4.3-q16;C:\Perl\site\bin;C:\Perl\bin;C:\Program Files\Windows Resource Kits\Tools\;C:\Program Files\Support Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Java\jdk1.6.0_07\bin\;C:\php;C:\php\ext
_SERVER["PROCESSOR_REVISION"] 0f08
_SERVER["ClusterLog"] C:\WINDOWS\Cluster\cluster.log
_SERVER["COMPUTERNAME"] CAY-APP01
_SERVER["windir"] C:\WINDOWS
_SERVER["SystemRoot"] C:\WINDOWS
_SERVER["ALLUSERSPROFILE"] C:\Documents and Settings\All Users
_SERVER["NUMBER_OF_PROCESSORS"] 1
_SERVER["PROCESSOR_IDENTIFIER"] x86 Family 6 Model 15 Stepping 8, GenuineIntel
_SERVER["ComSpec"] C:\WINDOWS\system32\cmd.exe
_SERVER["SERVER_NAME"] [snip]
_SERVER["SERVER_PORT"]

string(4) "8080"

_SERVER["REMOTE_HOST"] 10.12.32.150
_SERVER["REMOTE_ADDR"] 10.12.32.150
_SERVER["REMOTE_PORT"]

string(4) "1937"

_SERVER["SERVER_SOFTWARE"] Apache PHP Quercus(Open Source 3.1.6)
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["DOCUMENT_ROOT"] /C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/testPHP/
_SERVER["SCRIPT_NAME"] /testPHP/test.php
_SERVER["REQUEST_URI"] /testPHP/test.php
_SERVER["SCRIPT_FILENAME"] C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\testPHP\test.php
_SERVER["PHP_SELF"] /testPHP/test.php
_SERVER["HTTP_HOST"] [snip]
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.2) Gecko/2008091620 Firefox/3.0.2
_SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us
_SERVER["HTTP_ACCEPT_ENCODING"] gzip,deflate
_SERVER["HTTP_ACCEPT_CHARSET"] ISO-8859-1,utf-8;q=0.7,*;q=0.7
_SERVER["HTTP_KEEP_ALIVE"] 300
_SERVER["HTTP_CONNECTION"] keep-alive
_SERVER["HTTP_COOKIE"] G2SETUPSID=cc05a868561f99a6a21e4ab3bf87394c

The error that worries me is:

Quote:
2008-09-26 10:35:10 [TMP_SESSION_ID_DI_NOISSES_PMT] postgres7 error: [-1: Connection is closed.] in EXECUTE("SELECT g_name, g_major, g_minor FROM g2_Schema")

So...if the BIT_OR function is created, G2 must be successfully accessing the database, right? So the question is why it can't create the tables.

I was getting a "session.save_path writable" failure from running the "ghcc.php" script which won't go away...could this be an issue?

AttachmentSize
install_log.zip2.02 KB