Mantis Bugtracker
  

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0003003 [Quercus] major always 10-11-08 23:24 12-25-08 08:36
Reporter damjan View Status public  
Assigned To
Priority normal Resolution open  
Status new   Product Version 3.2.1
Summary 0003003: PostgreSQL support for Gallery
Description I tried with the latest snapshot resin-pro-3.2.s081008 if [0002506] had been really fixed. I don't get that exception anymore, but gallery still doesn't work as there is a new problem with pgsql database. I tried with 2.2.1 and 2.2.6 and both end up at the same query. Log trace is below.
Additional Information [00:15:37.999]jdbc/Gallery2DS.2.1:getResultSet() -> org.postgresql.jdbc3g.Jdbc3gResultSet
[00:15:38.000] {http--8080-3} jdbc/Gallery2DS.2.1:getResultSet() -> org.postgresql.jdbc3g.Jdbc3gResultSet
[00:15:38.006]jdbc/Gallery2DS.2.2:createStatement(type=1004,concurrency=1007)
[00:15:38.006] {http--8080-3} jdbc/Gallery2DS.2.2:createStatement(type=1004,concurrency=1007)
[00:15:38.006]jdbc/Gallery2DS.2.2:setEscapeProcessing(false)
[00:15:38.006] {http--8080-3} jdbc/Gallery2DS.2.2:setEscapeProcessing(false)
[00:15:38.015]jdbc/Gallery2DS.2.2:execute(SELECT g_userId, g_remoteIdentifier, g_creationTimestamp, g_modificationTimestamp, g_data FROM g2_SessionMap WHERE g_id='Postgres[localhost]') -> true
[00:15:38.015] {http--8080-3} jdbc/Gallery2DS.2.2:execute(SELECT g_userId, g_remoteIdentifier, g_creationTimestamp, g_modificationTimestamp, g_data FROM g2_SessionMap WHERE g_id='Postgres[localhost]') -> true
[00:15:38.015]jdbc/Gallery2DS.2.2:getResultSet() -> org.postgresql.jdbc3g.Jdbc3gResultSet
[00:15:38.015] {http--8080-3} jdbc/Gallery2DS.2.2:getResultSet() -> org.postgresql.jdbc3g.Jdbc3gResultSet
[00:15:38.047]jdbc/Gallery2DS.2.3:createStatement(type=1004,concurrency=1007)
[00:15:38.048] {http--8080-3} jdbc/Gallery2DS.2.3:createStatement(type=1004,concurrency=1007)
[00:15:38.048]jdbc/Gallery2DS.2.3:setEscapeProcessing(false)
[00:15:38.048] {http--8080-3} jdbc/Gallery2DS.2.3:setEscapeProcessing(false)
[00:15:38.060]jdbc/Gallery2DS.2.3:execute(
[00:15:38.060] SELECT
[00:15:38.060] g2_Group.g_id,
[00:15:38.060] g2_Group.g_groupName
[00:15:38.060] FROM
[00:15:38.060] g2_UserGroupMap, g2_Group
[00:15:38.060] WHERE
[00:15:38.060] g2_Group.g_id = g2_UserGroupMap.g_groupId
[00:15:38.060] AND
[00:15:38.060] g2_UserGroupMap.g_userId = 5
[00:15:38.060] ORDER BY
[00:15:38.060] g2_Group.g_groupName
[00:15:38.060] ) -> true
[00:15:38.062] {http--8080-3} jdbc/Gallery2DS.2.3:execute(
[00:15:38.062] {http--8080-3} SELECT
[00:15:38.062] {http--8080-3} g2_Group.g_id,
[00:15:38.062] {http--8080-3} g2_Group.g_groupName
[00:15:38.062] {http--8080-3} FROM
[00:15:38.062] {http--8080-3} g2_UserGroupMap, g2_Group
[00:15:38.062] {http--8080-3} WHERE
[00:15:38.062] {http--8080-3} g2_Group.g_id = g2_UserGroupMap.g_groupId
[00:15:38.062] {http--8080-3} AND
[00:15:38.062] {http--8080-3} g2_UserGroupMap.g_userId = 5
[00:15:38.062] {http--8080-3} ORDER BY
[00:15:38.062] {http--8080-3} g2_Group.g_groupName
[00:15:38.062] {http--8080-3} ) -> true
[00:15:38.064]jdbc/Gallery2DS.2.3:getResultSet() -> org.postgresql.jdbc3g.Jdbc3gResultSet
[00:15:38.064] {http--8080-3} jdbc/Gallery2DS.2.3:getResultSet() -> org.postgresql.jdbc3g.Jdbc3gResultSet
[00:15:38.066]jdbc/Gallery2DS.2.4:createStatement(type=1004,concurrency=1007)
[00:15:38.066] {http--8080-3} jdbc/Gallery2DS.2.4:createStatement(type=1004,concurrency=1007)
[00:15:38.067]jdbc/Gallery2DS.2.4:setEscapeProcessing(false)
[00:15:38.067] {http--8080-3} jdbc/Gallery2DS.2.4:setEscapeProcessing(false)
[00:15:38.071]jdbc/Gallery2DS.2.4:execute(SELECT g_module, g_permission, g_description, g_bits, g_flags FROM g2_PermissionSetMap) -> true
[00:15:38.071] {http--8080-3} jdbc/Gallery2DS.2.4:execute(SELECT g_module, g_permission, g_description, g_bits, g_flags FROM g2_PermissionSetMap) -> true
[00:15:38.072]jdbc/Gallery2DS.2.4:getResultSet() -> org.postgresql.jdbc3g.Jdbc3gResultSet
[00:15:38.072] {http--8080-3} jdbc/Gallery2DS.2.4:getResultSet() -> org.postgresql.jdbc3g.Jdbc3gResultSet
[00:15:38.096]jdbc/Gallery2DS.2.5:createStatement(type=1004,concurrency=1007)
[00:15:38.096] {http--8080-3} jdbc/Gallery2DS.2.5:createStatement(type=1004,concurrency=1007)
[00:15:38.096]jdbc/Gallery2DS.2.5:setEscapeProcessing(false)
[00:15:38.097] {http--8080-3} jdbc/Gallery2DS.2.5:setEscapeProcessing(false)
[00:15:38.099]jdbc/Gallery2DS.2.5:exn-execute(
[00:15:38.099] SELECT DISTINCT
[00:15:38.099] g2_AccessMap.g_accessListId
[00:15:38.099] FROM
[00:15:38.099] g2_AccessMap
[00:15:38.099] WHERE
[00:15:38.099] g2_AccessMap.g_userOrGroupId IN (5,4)
[00:15:38.099] AND
[00:15:38.099] g2_AccessMap.g_permission & 'Postgres[localhost]' = 'Postgres[localhost]'
[00:15:38.099] ) -> org.postgresql.util.PSQLException: ERROR: "P" is not a valid binary digit
[00:15:38.100] {http--8080-3} jdbc/Gallery2DS.2.5:exn-execute(
[00:15:38.100] {http--8080-3} SELECT DISTINCT
[00:15:38.100] {http--8080-3} g2_AccessMap.g_accessListId
[00:15:38.100] {http--8080-3} FROM
[00:15:38.100] {http--8080-3} g2_AccessMap
[00:15:38.100] {http--8080-3} WHERE
[00:15:38.100] {http--8080-3} g2_AccessMap.g_userOrGroupId IN (5,4)
[00:15:38.100] {http--8080-3} AND
[00:15:38.100] {http--8080-3} g2_AccessMap.g_permission & 'Postgres[localhost]' = 'Postgres[localhost]'
[00:15:38.100] {http--8080-3} ) -> org.postgresql.util.PSQLException: ERROR: "P" is not a valid binary digit
[00:15:38.103]com.caucho.quercus.QuercusException: Query failed: ERROR: "P" is not a valid binary digit
[00:15:38.103] at com.caucho.quercus.env.Env.warning(Env.java:4493)
[00:15:38.103] at com.caucho.quercus.lib.db.PostgresModule.pg_query_impl(PostgresModule.java:2796)
[00:15:38.103] at com.caucho.quercus.lib.db.PostgresModule.pg_query(PostgresModule.java:2757)
[00:15:38.103] at com.caucho.quercus.lib.db.PostgresModule.pg_exec(PostgresModule.java:2772)
[00:15:38.103] at _quercus._gallery2._lib._adodb._drivers._adodb_22dpostgres64__inc__php$quercus_ADODB_postgres64_0$fun__query_26.callMethod(_adodb_22dpostgres64__inc__php.java:912)
[00:15:38.103] at com.caucho.quercus.env.QuercusClass.callMethod(QuercusClass.java:1180)
[00:15:38.103] at _quercus._gallery2._lib._adodb._drivers._adodb_22dpostgres7__inc__php$quercus_ADODB_postgres7_0$fun__query_3.callMethod(_adodb_22dpostgres7__inc__php.java:299)
[00:15:38.103] at com.caucho.quercus.env.ObjectExtValue.callMethod(ObjectExtValue.java:782)
[00:15:38.103] at _quercus._gallery2._lib._adodb._adodb__inc__php$quercus_ADOConnection_1$fun__Execute_39.callMethodRef(_adodb__inc__php.java:4882)
[00:15:38.103] at com.caucho.quercus.program.CompiledMethodRef_2.callMethodRef(CompiledMethodRef_2.java:91)
[00:15:38.103] at com.caucho.quercus.program.AbstractFunction.callMethodRef(AbstractFunction.java:593)
[00:15:38.103] at com.caucho.quercus.env.ObjectExtValue.callMethodRef(ObjectExtValue.java:982)
[00:15:38.103] at _quercus._gallery2._lib._adodb._adodb__inc__php$quercus_ADOConnection_1$fun_Execute_38.callMethodRef(_adodb__inc__php.java:6856)
[00:15:38.103] at com.caucho.quercus.program.CompiledFunctionRef.callMethod(CompiledFunctionRef.java:101)
[00:15:38.103] at com.caucho.quercus.env.ObjectExtValue.callMethod(ObjectExtValue.java:782)
[00:15:38.103] at _quercus._gallery2._modules._core._classes._GalleryStorage__class$quercus_GalleryStorage_0$fun_search_19.callMethod(_GalleryStorage__class.java:620)
[00:15:38.103] at com.caucho.quercus.env.ObjectExtValue.callMethod(ObjectExtValue.java:813)
[00:15:38.103] at com.caucho.quercus.env.Var.callMethod(Var.java:1402)
[00:15:38.103] at _quercus._gallery2._modules._core._classes._Gallery__class$quercus_Gallery_0$fun_search_1.callMethod(_Gallery__class.java:717)
[00:15:38.103] at com.caucho.quercus.program.CompiledMethod_3.callMethod(CompiledMethod_3.java:122)
[00:15:38.103] at com.caucho.quercus.env.ObjectExtValue.callMethod(ObjectExtValue.java:782)
[00:15:38.103] at com.caucho.quercus.env.Var.callMethod(Var.java:1390)
[00:15:38.103] at _quercus._gallery2._modules._core._classes._helpers._GalleryPermissionHelper_0simple__class$quercus_GalleryPermissionHelper_simple_0$fun_fetchAccessListIds_0.callMethod(_GalleryPermissionHelper_0simple__class.java:251)
[00:15:38.103] at com.caucho.quercus.env.QuercusClass.callMethod(QuercusClass.java:1210)
[00:15:38.103] at _quercus._gallery2._modules._core._classes._GalleryCoreApi__class$quercus_GalleryCoreApi_0$fun_fetchAccessListIds_24.callMethod(_GalleryCoreApi__class.java:1575)
[00:15:38.103] at com.caucho.quercus.program.CompiledMethod_3.callMethod(CompiledMethod_3.java:122)
[00:15:38.103] at com.caucho.quercus.env.QuercusClass.callMethod(QuercusClass.java:1180)
[00:15:38.103] at _quercus._gallery2._modules._core._classes._GalleryDataCache__class$quercus_GalleryDataCache_0$fun_getPageData_22.callMethod(_GalleryDataCache__class.java:1486)
[00:15:38.103] at com.caucho.quercus.env.QuercusClass.callMethod(QuercusClass.java:1180)
[00:15:38.103] at _quercus._gallery2._main__php$fun__GalleryMain_1.call(_main__php.java:570)
[00:15:38.103] at _quercus._gallery2._main__php$fun_GalleryMain_0.call(_main__php.java:134)
[00:15:38.103] at _quercus._gallery2._main__php.execute(_main__php.java:104)
[00:15:38.103] at com.caucho.quercus.page.QuercusPage.executeTop(QuercusPage.java:119)
[00:15:38.103] at com.caucho.quercus.servlet.ResinQuercusServlet.service(ResinQuercusServlet.java:152)
[00:15:38.103] at com.caucho.quercus.servlet.QuercusServlet.service(QuercusServlet.java:407)
[00:15:38.103] at javax.servlet.http.HttpServlet.service(HttpServlet.java:91)
[00:15:38.103] at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103)
[00:15:38.103] at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:201)
[00:15:38.103] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:189)
[00:15:38.103] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:266)
[00:15:38.103] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:292)
[00:15:38.103] at com.caucho.server.port.TcpConnection.handleRequests(TcpConnection.java:577)
[00:15:38.103] at com.caucho.server.port.TcpConnection$AcceptTask.doAccept(TcpConnection.java:1211)
[00:15:38.103] at com.caucho.server.port.TcpConnection$AcceptTask.run(TcpConnection.java:1152)
[00:15:38.103] at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:759)
[00:15:38.103] at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:681)
[00:15:38.103] at java.lang.Thread.run(Thread.java:619)
[00:15:38.109] {http--8080-3} com.caucho.quercus.QuercusException: Query failed: ERROR: "P" is not a valid binary digit
[00:15:38.109] {http--8080-3} at com.caucho.quercus.env.Env.warning(Env.java:4493)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.lib.db.PostgresModule.pg_query_impl(PostgresModule.java:2796)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.lib.db.PostgresModule.pg_query(PostgresModule.java:2757)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.lib.db.PostgresModule.pg_exec(PostgresModule.java:2772)
[00:15:38.109] {http--8080-3} at _quercus._gallery2._lib._adodb._drivers._adodb_22dpostgres64__inc__php$quercus_ADODB_postgres64_0$fun__query_26.callMethod(_adodb_22dpostgres64__inc__php.java:912)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.env.QuercusClass.callMethod(QuercusClass.java:1180)
[00:15:38.109] {http--8080-3} at _quercus._gallery2._lib._adodb._drivers._adodb_22dpostgres7__inc__php$quercus_ADODB_postgres7_0$fun__query_3.callMethod(_adodb_22dpostgres7__inc__php.java:299)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.env.ObjectExtValue.callMethod(ObjectExtValue.java:782)
[00:15:38.109] {http--8080-3} at _quercus._gallery2._lib._adodb._adodb__inc__php$quercus_ADOConnection_1$fun__Execute_39.callMethodRef(_adodb__inc__php.java:4882)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.program.CompiledMethodRef_2.callMethodRef(CompiledMethodRef_2.java:91)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.program.AbstractFunction.callMethodRef(AbstractFunction.java:593)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.env.ObjectExtValue.callMethodRef(ObjectExtValue.java:982)
[00:15:38.109] {http--8080-3} at _quercus._gallery2._lib._adodb._adodb__inc__php$quercus_ADOConnection_1$fun_Execute_38.callMethodRef(_adodb__inc__php.java:6856)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.program.CompiledFunctionRef.callMethod(CompiledFunctionRef.java:101)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.env.ObjectExtValue.callMethod(ObjectExtValue.java:782)
[00:15:38.109] {http--8080-3} at _quercus._gallery2._modules._core._classes._GalleryStorage__class$quercus_GalleryStorage_0$fun_search_19.callMethod(_GalleryStorage__class.java:620)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.env.ObjectExtValue.callMethod(ObjectExtValue.java:813)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.env.Var.callMethod(Var.java:1402)
[00:15:38.109] {http--8080-3} at _quercus._gallery2._modules._core._classes._Gallery__class$quercus_Gallery_0$fun_search_1.callMethod(_Gallery__class.java:717)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.program.CompiledMethod_3.callMethod(CompiledMethod_3.java:122)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.env.ObjectExtValue.callMethod(ObjectExtValue.java:782)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.env.Var.callMethod(Var.java:1390)
[00:15:38.109] {http--8080-3} at _quercus._gallery2._modules._core._classes._helpers._GalleryPermissionHelper_0simple__class$quercus_GalleryPermissionHelper_simple_0$fun_fetchAccessListIds_0.callMethod(_GalleryPermissionHelper_0simple__class.java:251)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.env.QuercusClass.callMethod(QuercusClass.java:1210)
[00:15:38.109] {http--8080-3} at _quercus._gallery2._modules._core._classes._GalleryCoreApi__class$quercus_GalleryCoreApi_0$fun_fetchAccessListIds_24.callMethod(_GalleryCoreApi__class.java:1575)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.program.CompiledMethod_3.callMethod(CompiledMethod_3.java:122)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.env.QuercusClass.callMethod(QuercusClass.java:1180)
[00:15:38.109] {http--8080-3} at _quercus._gallery2._modules._core._classes._GalleryDataCache__class$quercus_GalleryDataCache_0$fun_getPageData_22.callMethod(_GalleryDataCache__class.java:1486)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.env.QuercusClass.callMethod(QuercusClass.java:1180)
[00:15:38.109] {http--8080-3} at _quercus._gallery2._main__php$fun__GalleryMain_1.call(_main__php.java:570)
[00:15:38.109] {http--8080-3} at _quercus._gallery2._main__php$fun_GalleryMain_0.call(_main__php.java:134)
[00:15:38.109] {http--8080-3} at _quercus._gallery2._main__php.execute(_main__php.java:104)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.page.QuercusPage.executeTop(QuercusPage.java:119)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.servlet.ResinQuercusServlet.service(ResinQuercusServlet.java:152)
[00:15:38.109] {http--8080-3} at com.caucho.quercus.servlet.QuercusServlet.service(QuercusServlet.java:407)
[00:15:38.109] {http--8080-3} at javax.servlet.http.HttpServlet.service(HttpServlet.java:91)
[00:15:38.109] {http--8080-3} at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103)
[00:15:38.109] {http--8080-3} at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:201)
[00:15:38.109] {http--8080-3} at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:189)
[00:15:38.109] {http--8080-3} at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:266)
[00:15:38.109] {http--8080-3} at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:292)
[00:15:38.109] {http--8080-3} at com.caucho.server.port.TcpConnection.handleRequests(TcpConnection.java:577)
[00:15:38.109] {http--8080-3} at com.caucho.server.port.TcpConnection$AcceptTask.doAccept(TcpConnection.java:1211)
[00:15:38.109] {http--8080-3} at com.caucho.server.port.TcpConnection$AcceptTask.run(TcpConnection.java:1152)
[00:15:38.109] {http--8080-3} at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:759)
[00:15:38.109] {http--8080-3} at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:681)
[00:15:38.109] {http--8080-3} at java.lang.Thread.run(Thread.java:619)
[00:15:38.310]ProEnv[] Query failed: ERROR: "P" is not a valid binary digit
[00:15:38.311] {http--8080-3} ProEnv[] Query failed: ERROR: "P" is not a valid binary digit
[00:15:38.366]jdbc/Gallery2DS.2.6:createStatement(type=1004,concurrency=1007)
[00:15:38.366] {http--8080-3} jdbc/Gallery2DS.2.6:createStatement(type=1004,concurrency=1007)
[00:15:38.367]jdbc/Gallery2DS.2.6:setEscapeProcessing(false)
[00:15:38.367] {http--8080-3} jdbc/Gallery2DS.2.6:setEscapeProcessing(false)
[00:15:38.369]jdbc/Gallery2DS.2.6:execute(SELECT g_userId FROM g2_UserGroupMap WHERE g_userId=5 AND g_groupId=3 LIMIT 1) -> true
[00:15:38.369] {http--8080-3} jdbc/Gallery2DS.2.6:execute(SELECT g_userId FROM g2_UserGroupMap WHERE g_userId=5 AND g_groupId=3 LIMIT 1) -> true
[00:15:38.369]jdbc/Gallery2DS.2.6:getResultSet() -> org.postgresql.jdbc3g.Jdbc3gResultSet
[00:15:38.369] {http--8080-3} jdbc/Gallery2DS.2.6:getResultSet() -> org.postgresql.jdbc3g.Jdbc3gResultSet
[00:15:38.404]jdbc/Gallery2DS.2.0:close()
[00:15:38.404] {http--8080-3} jdbc/Gallery2DS.2.0:close()
[00:15:38.405]jdbc/Gallery2DS.2.1:close()
[00:15:38.405] {http--8080-3} jdbc/Gallery2DS.2.1:close()
[00:15:38.405]jdbc/Gallery2DS.2.2:close()
[00:15:38.405] {http--8080-3} jdbc/Gallery2DS.2.2:close()
[00:15:38.406]jdbc/Gallery2DS.2.3:close()
[00:15:38.406] {http--8080-3} jdbc/Gallery2DS.2.3:close()
[00:15:38.406]jdbc/Gallery2DS.2.4:close()
[00:15:38.406] {http--8080-3} jdbc/Gallery2DS.2.4:close()
[00:15:38.406]jdbc/Gallery2DS.2.5:close()
[00:15:38.407] {http--8080-3} jdbc/Gallery2DS.2.5:close()
[00:15:38.407]jdbc/Gallery2DS.2.6:close()
[00:15:38.407] {http--8080-3} jdbc/Gallery2DS.2.6:close()
[00:15:38.407]connection pool destroy PoolItem[jdbc/Gallery2DS,4,null]
[00:15:38.407] {http--8080-3} connection pool destroy PoolItem[jdbc/Gallery2DS,4,null]
[00:15:38.408]destroy ManagedConnectionImpl[jdbc/Gallery2DS.2]
[00:15:38.408] {http--8080-3} destroy ManagedConnectionImpl[jdbc/Gallery2DS.2]
[00:15:38.408]jdbc/Gallery2DS.2:close()
[00:15:38.408] {http--8080-3} jdbc/Gallery2DS.2:close()
[00:15:38.409]Http[3] HTTP/1.1 500 Internal Server Error
[00:15:38.409] {http--8080-3} Http[3] HTTP/1.1 500 Internal Server Error
[00:15:38.409]Http[3] Set-Cookie: GALLERYSID=; expires=Fri, 12 Oct 2007 22:15:37 GMT; path=/gallery2/; HttpOnly=1
[00:15:38.409] {http--8080-3} Http[3] Set-Cookie: GALLERYSID=; expires=Fri, 12 Oct 2007 22:15:37 GMT; path=/gallery2/; HttpOnly=1
[00:15:38.410]Http[3] Content-Type: text/html
[00:15:38.410] {http--8080-3} Http[3] Content-Type: text/html
[00:15:38.410]Http[3] Content-Length: 795
[00:15:38.410] {http--8080-3} Http[3] Content-Length: 795
[00:15:38.411]Http[3] write-chunk(795)
[00:15:38.411] {http--8080-3} Http[3] write-chunk(795)
[00:15:38.411]Http[3] finish/keepalive
[00:15:38.411] {http--8080-3} Http[3] finish/keepalive
[00:15:38.412] {http--8080-3} Http[3] keepalive
[00:15:38.412] {http--8080-3} TcpConnection[id=3,] keepalive (thread)
[00:15:38.412] {http--8080-3} TcpConnection[id=3,] closing connection TcpConnection[id=http--8080-3,http://*:8080,CLOSED], [^] total=6
[00:15:38.450] {http--8080-2} TcpConnection[id=2,] starting connection TcpConnection[id=http--8080-2,http://*:8080,ACCEPT], [^] total=6
[00:15:38.451] {http--8080-2} Http[2] GET /gallery2/lib/javascript/BlockToggle.js HTTP/1.1
[00:15:38.451] {http--8080-2} Http[2] Remote-IP: 192.168.123.11:35291
[00:15:38.451] {http--8080-2} Http[2] Proxy-agent: Sun-Java-System-Web-Proxy-Server/4.0
[00:15:38.452] {http--8080-2} Http[2] Host: gallery.epilog.net:8080
[00:15:38.452] {http--8080-2} Http[2] User-agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.0.3) Gecko/2008092414 Firefox/3.0.3
[00:15:38.452] {http--8080-2} Http[2] Accept: */*
[00:15:38.452] {http--8080-2} Http[2] Accept-language: en-us,en;q=0.5
[00:15:38.453] {http--8080-2} Http[2] Accept-encoding: gzip,deflate
[00:15:38.453] {http--8080-2} Http[2] Accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
[00:15:38.453] {http--8080-2} Http[2] Referer: http://gallery.epilog.net:8080/gallery2/main.php [^]
[00:15:38.453] {http--8080-2} Http[2] Cookie: GALLERYSID=0df04b625ba5a8e82b2fbfe8df690f3a; G2SETUPSID=5b89a2ac54872202e218261558ada0c4; JSESSIONID=abcej1NCftlLQgYRj0TZr
[00:15:38.454] {http--8080-2} Http[2] If-none-match: "6Z4YOZfNIjc"
[00:15:38.454] {http--8080-2} Http[2] Cache-control: max-age=0
[00:15:38.454] {http--8080-2} Http[2] If-modified-since: Wed, 20 Dec 2006 00:24:57 GMT
[00:15:38.454] {http--8080-2} Http[2] Via: 1.1 proxy-server1
[00:15:38.455] {http--8080-2} Http[2] Connection: keep-alive
[00:15:38.463] {http--8080-2} Dispatch '/gallery2/lib/javascript/BlockToggle.js' to WebAppFilterChain[http://default, [^] next=CacheFilterChain[null?null, next=ServletFilterChain[resin-file]]]
[00:15:38.488]Http[2] HTTP/1.1 304 Not Modified
[00:15:38.488] {http--8080-2} Http[2] HTTP/1.1 304 Not Modified
[00:15:38.489]Http[2] ETag: "6Z4YOZfNIjc"
[00:15:38.489] {http--8080-2} Http[2] ETag: "6Z4YOZfNIjc"
[00:15:38.489]Http[2] Expires: Sat, 11 Oct 2008 22:15:43 GMT
[00:15:38.489] {http--8080-2} Http[2] Expires: Sat, 11 Oct 2008 22:15:43 GMT
[00:15:38.489]Http[2] Content-Length: 0
[00:15:38.490] {http--8080-2} Http[2] Content-Length: 0
[00:15:38.490]Http[2] finish/keepalive
[00:15:38.490] {http--8080-2} Http[2] finish/keepalive
[00:15:38.491] {http--8080-2} Http[2] keepalive
[00:15:38.491] {http--8080-2} TcpConnection[id=2,] keepalive (thread)
Attached Files

- Relationships

- Notes
(0003675)
damjan
12-25-08 08:36

A tried it again using java 1.5, 1.6 jdbc 3 and jdbc 4. In all cases it fails at above query.

[00:15:38.099]jdbc/Gallery2DS.2.5:exn-execute(
[00:15:38.099] SELECT DISTINCT
[00:15:38.099] g2_AccessMap.g_accessListId
[00:15:38.099] FROM
[00:15:38.099] g2_AccessMap
[00:15:38.099] WHERE
[00:15:38.099] g2_AccessMap.g_userOrGroupId IN (5,4)
[00:15:38.099] AND
[00:15:38.099] g2_AccessMap.g_permission & 'Postgres[localhost]' = 'Postgres[localhost]'
[00:15:38.099] ) -> org.postgresql.util.PSQLException: ERROR: "P" is not a valid binary digit
[00:15:38.100] {http--8080-3} jdbc/Gallery2DS.2.5:exn-execute(
[00:15:38.100] {http--8080-3} SELECT DISTINCT
[00:15:38.100] {http--8080-3} g2_AccessMap.g_accessListId
[00:15:38.100] {http--8080-3} FROM
[00:15:38.100] {http--8080-3} g2_AccessMap
[00:15:38.100] {http--8080-3} WHERE
[00:15:38.100] {http--8080-3} g2_AccessMap.g_userOrGroupId IN (5,4)
[00:15:38.100] {http--8080-3} AND
[00:15:38.100] {http--8080-3} g2_AccessMap.g_permission & 'Postgres[localhost]' = 'Postgres[localhost]'
[00:15:38.100] {http--8080-3} ) -> org.postgresql.util.PSQLException: ERROR: "P" is not a valid binary digit
 

- Issue History
Date Modified Username Field Change
10-11-08 23:24 damjan New Issue
12-25-08 08:36 damjan Note Added: 0003675


Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
29 total queries executed.
26 unique queries executed.
Powered by Mantis Bugtracker