Re: [BUGS] 7.4: FATAL: unrecognized configuration parameter "show_statement_stats"
[EMAIL PROTECTED] writes: > Version: Release 7.4 (production) > Error message: psql: FATAL: unrecognized configuration parameter > "show_statement_stats" Looks like Bruce missed a couple places while renaming those config variables :-(. It's fixed in CVS tip, but the best workaround for the moment is to set log_statement_stats directly instead of using the -s shortcut. Thanks for the report! regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [BUGS] memory bug
"Alex Albarracin" <[EMAIL PROTECTED]> writes: > Hello, i have a problem related to the partition memory where > postgres is installed, this has increased so much that the partition > is full and postgres can not start up. The message postmaster sends > when i want to restart is insuficient disk space. Do you know if > postgres uses some disk space that may not releases. Unused disk space is released by VACUUM FULL. If I understand your situation correctly, I'd recommend temporarily adding some more disk space or moving some data to another partition to allow the postmaster to startup. Then you can reclaim some disk space using VACUUM FULL and/or REINDEX. In the future, run VACUUM more frequently (and perhaps bump max_fsm_pages). -Neil ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[BUGS] Fwd: Solaris build of 7.4 problem with --enable-thread-safety
Title: Fwd: Solaris build of 7.4 problem with --enable-thread Date: Mon, 24 Nov 2003 10:11:15 -0600 To: [EMAIL PROTECTED] From: Seum-Lim Gan <[EMAIL PROTECTED]> Subject: Solaris build of 7.4 problem with --enable-thread-safety Cc: Josh Berkus <[EMAIL PROTECTED]> Bcc: X-Attachments: Hi Josh, Is there someone could look into this ? I have narrowed down the problem. Thanks. Gan This problem will only occur if I configure to use the --enable-thread-safety option. Here is the configure options I used: MYCC=/opt/SUNWspro6.2/SUNWspro/bin/cc /bin/env CC=$MYCC CFLAGS='-C -mt -D_SVR4 ' ./configure \ --prefix=/platdb \ --with-pgport=5333 \ --without-readline \ --with-CXX \ --with-perl \ --with-java \ --with-pam \ --enable-syslog \ --enable-nls \ --enable-thread-safety Wihout the --enable-thread-safety option, everything compiled fine. With --enable-thread-safety, it failed while trying to compile the src/interfaces/ecpg/ecpglib I have already cut down my configure to have just the following and compile failed the same way: MYCC=/opt/SUNWspro6.2/SUNWspro/bin/cc /bin/env CC=$MYCC CFLAGS='-C -mt -D_SVR4 ' ./configure \ --prefix=/platdb \ --without-readline \ --enable-thread-safety Below is the make output: make[4]: Entering directory `/n/DBMS/edbteam/src/sol8/sparc64/postgresql-7.4/src/interfaces/ecpg/ecpglib' /opt/SUNWspro6.2/SUNWspro/bin/cc -Xa -G -h libecpg.so.4 execute.o typename.o descriptor.o data.o error.o prepare.o memory.o connect.o misc.o -L../../../../src/port -L../pgtypeslib -lpgtypes -L../../../../src/interfaces/libpq -lpq -lm -pthread -R/platdb/lib -o libecpg.so.4.0 cc: Warning: multiple use of -h option, previous one discarded. ld: fatal: recording name conflict: file `../../../../src/interfaces/libpq/libpq.so' and -h option provide identical dependency names: read ld: fatal: File processing errors. No output written to libecpg.so.4.0 make[4]: *** [libecpg.so.4.0] Error 1 make[4]: Leaving directory `/n/DBMS/edbteam/src/sol8/sparc64/postgresql-7.4/src/interfaces/ecpg/ecpglib' make[3]: *** [all] Error 2 make[3]: Leaving directory `/n/DBMS/edbteam/src/sol8/sparc64/postgresql-7.4/src/interfaces/ecpg' make[2]: *** [all] Error 2 make[2]: Leaving directory `/n/DBMS/edbteam/src/sol8/sparc64/postgresql-7.4/src/interfaces' make[1]: *** [all] Error 2 make[1]: Leaving directory `/n/DBMS/edbteam/src/sol8/sparc64/postgresql-7.4/src' make: *** [all] Error 2 At 2:44 pm -0600 2003/11/21, Seum-Lim Gan wrote: Hi, I did not get any respond to this build error. How should I proceed with this ? Is there anything in the makefile I need to change ? I did not get this build error when I way compiling the 7.4b4. Thanks. Gan At 11:45 am -0600 2003/11/20, Seum-Lim Gan wrote: Hi, I tried to compile the new 7.4 in Solaris 2.9 Sparc and Solaris 2.8 intel and got the same make error: Solaris 8 intel: /opt/SUNWspro6.2/SUNWspro/bin/cc -Xa -G -h libecpg.so.4 execute.o typename.o descriptor.o data.o error.o prepare.o memory.o connect.o misc.o -L../../../../src/port -L../pgtypeslib -lpgtypes -L../../../../src/interfaces/libpq -lpq -lm -pthread -R/platdb/lib -o libecpg.so.4.0 cc: Warning: multiple use of -h option, previous one discarded. ld: fatal: recording name conflict: file `../../../../src/interfaces/libpq/libpq.so' and -h option provide identical dependency names: read ld: fatal: File processing errors. No output written to libecpg.so.4.0 make[4]: *** [libecpg.so.4.0] Error 1 make[4]: Leaving directory `/n/DBMS/edbteam/src/sol8/intel32/postgresql-7.4/src/interfaces/ecpg/ecpglib' make[3]: *** [all] Error 2 make[3]: Leaving directory `/n/DBMS/edbteam/src/sol8/intel32/postgresql-7.4/src/interfaces/ecpg' make[2]: *** [all] Error 2 make[2]: Leaving directory `/n/DBMS/edbteam/src/sol8/intel32/postgresql-7.4/src/interfaces' make[1]: *** [all] Error 2 make[1]: Leaving directory `/n/DBMS/edbteam/src/sol8/intel32/postgresql-7.4/src' make: *** [all] Error 2 Solaris 9 Sparc: /opt/SUNWspro6.2/SUNWspro/bin/cc -Xa -G -h libecpg.so.4 execute.o typename.o descriptor.o data.o error.o prepare.o memory.o connect.o misc.o -L../../../../src/port -L../pgtypeslib -lpgtypes -L../../../../src/interfaces/libpq -lpq -lm -pthread -R/platdb/lib -o libecpg.so.4.0 cc: Warning: multiple use of -h option, previous one discarded. ld: fatal: recording name conflict: file `../../../../src/interfaces/libpq/libpq.so' and -h option provide identical dependency names: read ld: fatal: File processing errors. No output written to libecpg.so.4.0 make[4]: *** [libecpg.so.4.0] Error 1 make[4]: Leaving directory `/n/DBMS/edbteam/src/sol9/sparc64/postgresql-7.4/src/interfaces/ecpg/ecpglib' make[3]: *** [all] Error 2 make[3]: Leaving directory `/n/DBMS/edbteam/src/sol9/sparc64/postgresql-7.4/src/interfaces/ecpg' make[2]: *** [all] Error 2 make[2]: Leaving directory `/n/DBMS/edbteam/src/sol9/sparc64/postgresql-7.4/src/interfaces' make[1]: *** [all] Error 2 make[1]: Leaving directory `/n/DBMS/edbteam/src/sol9/sparc64/postgr
[BUGS] String index out of range - Postgresql 7.3.4, Resin & JDBC
Title: Message
HI,
We are getting the
following error through a JSP.
We received the same
error for both 7.3.1 through 7.3.4 and several JDBC driver changes (currently
running the latest).
The strange thing is
that this actual page was working fine, then, after we modified a different
separate page, this page started producing the following
error.
Is anyone else
receiving Out Of Bound errors?
Can anyone suggest
how I could get a more descriptive error?
I have included full
source code for the page (sorry it is so long), as well as the error that is
shown in Resin's Standard Error log whenever the page is
loaded.
Thanks for any
help.
Regards,
Antony
___
java.lang.StringIndexOutOfBoundsException: String
index out of range: 0 at
java.lang.String.charAt(String.java:444)
at
org.postgresql.jdbc1.AbstractJdbc1ResultSet.toBoolean(AbstractJdbc1ResultSet.java:684)
at
org.postgresql.jdbc1.AbstractJdbc1ResultSet.getBoolean(AbstractJdbc1ResultSet.java:102)
at
_ejb.com.nortelleads.LeadBean__QPersist._caucho_load(LeadBean__QPersist.java:2903)
at
_ejb.com.nortelleads.ManagerBean__QPersist.ejbSelectAllWithManager(ManagerBean__QPersist.java:2713)
at
com.nortelleads.ManagerBean.getAllWithManager(ManagerBean.java:169)
at
_ejb.com.nortelleads.ManagerBean__EJB$Local.getAllWithManager(ManagerBean__EJB.java:921)
at
_lead_0listing__jsp._jspService(_lead_0listing__jsp.java:373)
at
com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at
com.caucho.jsp.Page.subservice(Page.java:506)
at
com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at
com.caucho.server.http.Invocation.service(Invocation.java:315)
at
com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at
com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
at
com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
at
com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:534)
___
<%@ page import="com.nortelleads.*, javax.naming.*, java.util.*,
java.net.*, java.text.DateFormat" session="true" errorPage="error.jsp"%>
<%@ taglib uri="ejbtags" prefix="ejb" %>
<%!
private CountryHome countryHome = null;
private LeadHome leadHome = null;
private LanguageHome languageHome = null;
private CampaignHome campaignHome = null;
public void jspInit()
{
try
{
Context ejb = (Context) new
InitialContext().lookup("java:comp/env/nortel");
countryHome = (CountryHome)ejb.lookup("Country");
leadHome = (LeadHome)ejb.lookup("Lead");
languageHome = (LanguageHome)ejb.lookup("Language");
campaignHome = (CampaignHome)ejb.lookup("Campaign");
}
catch (NamingException ignore)
{
}
}
private String getDisplayForActions(Integer action)
{
if (action == null)
return null;
switch (action.intValue())
{
case 1: return "";
case 0: return "";
case -1: return "";
case -2: return "";
default: return null;
}
}
%>
<%
response.setHeader("Pragma", "no-cache");
response.setHeader("Cache-Control", "no-cache");
response.setDateHeader("Expires", 0);
Manager currentUser = (Manager)session.getAttribute("currentUser");
if (currentUser == null)
{
// If moving to archive change login.jsp to ../login.jsp
response.sendRedirect("login.jsp");
return;
}
// If moving to archive change false to true
CombinedPrivilege cp = currentUser.getPrivilege(false);
Hashtable pageInfo = (Hashtable)session.getAttribute("pageInfo");
Language language = (Language)pageInfo.get("language");
Campaign campaign = (Campaign)pageInfo.get("campaign");
Country country = (Country)pageInfo.get("country");
Vector managerFilter = (Vector)pageInfo.get("managerFilter");
String managerFocus = (String)pageInfo.get("managerFocus");
String managerFilterStatus = (String)pageInfo.get("managerFilterStatus");
Collection countryManagers = null;
boolean noManagers = true;
if (country == null)
countryManagers = currentUser.getCountryManagerLists();
else
countryManagers = currentUser.getCountryManagerLists(country);
%>
Lead Listing