| Anonymous | Login | Signup for a new account | 11-21-2024 16:23 PST |
| Main | My View | View Issues | Change Log | Docs |
| 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. |  |
