Re: [BUGS] BUG #8241: submisson
Hi! There was a bug in the website code caused by an upgrade. This was fixed yesterday, so please try again now. /Magnus On Jun 20, 2013 5:09 PM, luk...@novosoft.net wrote: The following bug has been logged on the website: Bug reference: 8241 Logged by: Oksana Email address: luk...@novosoft.net PostgreSQL version: 9.2.4 Operating system: windows Description: Hi! Could you please help me with submission, I can`t add an organization and a product. because of «Server Error An internal server error occurred». My data: Novosoft h4ndYb4ckuP This is the info: About Novosoft LLC Novosoft has accumulated an extensive experience in IT-consulting and custom software development over the last 20 years. Nowadays Novosoft delivers its own IT-solutions for home and corporate users. The expertise of the company’s specialists allows Novosoft to create software products of high demand and to stay ahead of the competitors. http://www.novosoft-us.com/ About Handy Backup Handy Backup is a powerful backup tool for Windows 8/7/Vista/XP and Windows Server 2012/2008/2003. The program allows protecting local and remote files, HDD images, MySQL, MS SQL, PostgreSQL, MS Exchange, Oracle, DB2 and other data. Handy Backup is available in several editions suitable for different needs of home and corporate users. http://www.handybackup.net Thank you in advance! Best regards, Oksana http://www.novosoft-us.com Handy Backup http://handybackup.net/ http://handybackup.net/ Email: luk...@novosoft.net Blog: Handy Backup Blog http://blog.handybackup.net/ http://blog.handybackup.net/ Twitter: @Handy_Backup http://twitter.com/Handy_Backup http://twitter.com/Handy_Backup http://www.handybackup.net/templates/handy/images/logo_4.png -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8242: No way to debug subquery must return only one column error
Tom, suppose you haven't understood what the problem I'm facing with. Let me explain deeper. Try to execute the following 2 queries. select (select generate_series(1,2)); select (select generate_series(1,1)); They differ only in data, both of them are well-written, so there is not the problem in parsing. But first query gives (even in psql) *ERROR: more than one row returned by a subquery used as an expression* Certainly - instead of generate_series I could write any usual query that fetches some data from database. And if this query returns one row - everything is correct. And certainly, instead of* *selecting from dual (that is how it is called in Oracle) - I could construct more complex external query such that subquery could return more than one row for just in some exact row (not in each row) of external record set. Example select id, (select friend.id from user friend where friend.id = user.id) user from user This query fetches all users with their friends assuming that every user has only one friend. But if some of them will have 2 friends - this query will fail with *ERROR: more than one row returned by a subquery used as an expression* And I will have no chance to guess - which user exactly this happened for. 2013/6/20 Tom Lane t...@sss.pgh.pa.us boraldomas...@gmail.com writes: When I get this message I cannot guess from it's description what really causes this error. I would like to see exactly the subquery that returned more than one column and the row where this happened. That's a parse-time error, so it's nonsensical to ask for the row where it happened. AFAICS, the parser should give back a syntax-error pointer for this error; for example, when I try to provoke the error in psql, I get =# select * from table1 where id = any(array(select c1,c2 from table2)); ERROR: subquery must return only one column LINE 1: select * from table1 where id = any(array(select c1,c2 ... ^ which shows me that the problem is associated with the ARRAY() construct not accepting multiple input columns. If you're not seeing such an error pointer, it's the fault of whatever client-side software you're working in. regards, tom lane
Re: [BUGS] BUG #8242: No way to debug subquery must return only one column error
I just realized that I wanted to ask about another error. *more than one row returned by a subquery used as an expression * not about *subquery must return only one column* 2013/6/21 Борис Ромашов boraldomas...@gmail.com Tom, suppose you haven't understood what the problem I'm facing with. Let me explain deeper. Try to execute the following 2 queries. select (select generate_series(1,2)); select (select generate_series(1,1)); They differ only in data, both of them are well-written, so there is not the problem in parsing. But first query gives (even in psql) *ERROR: more than one row returned by a subquery used as an expression* Certainly - instead of generate_series I could write any usual query that fetches some data from database. And if this query returns one row - everything is correct. And certainly, instead of* *selecting from dual (that is how it is called in Oracle) - I could construct more complex external query such that subquery could return more than one row for just in some exact row (not in each row) of external record set. Example select id, (select friend.id from user friend where friend.id = user.id) user from user This query fetches all users with their friends assuming that every user has only one friend. But if some of them will have 2 friends - this query will fail with *ERROR: more than one row returned by a subquery used as an expression* And I will have no chance to guess - which user exactly this happened for. 2013/6/20 Tom Lane t...@sss.pgh.pa.us boraldomas...@gmail.com writes: When I get this message I cannot guess from it's description what really causes this error. I would like to see exactly the subquery that returned more than one column and the row where this happened. That's a parse-time error, so it's nonsensical to ask for the row where it happened. AFAICS, the parser should give back a syntax-error pointer for this error; for example, when I try to provoke the error in psql, I get =# select * from table1 where id = any(array(select c1,c2 from table2)); ERROR: subquery must return only one column LINE 1: select * from table1 where id = any(array(select c1,c2 ... ^ which shows me that the problem is associated with the ARRAY() construct not accepting multiple input columns. If you're not seeing such an error pointer, it's the fault of whatever client-side software you're working in. regards, tom lane
[BUGS] BUG #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559
The following bug has been logged on the website: Bug reference: 8245 Logged by: Kim Applegate Email address: kappleg...@apsalar.com PostgreSQL version: 9.2.4 Operating system: OpenIndiana Description: One of our queries has started failing randomly on our slaves with invalid memory alloc request size 18446744073709537559 This is eventually repeatable on any slave that has failed. Of the 64 slaves it will fail on 1-5 of them for any given run. The stored procedure that is failing queries on a partition with 64 children and only returns rows from 4 of the child tables. Turning Debug on in the logs only gives this Jun 20 06:50:53 * postgres[14825]: [ID 748848 local2.warning] [27-1] ERROR: invalid memory alloc request size 18446744073709532101 Jun 20 06:50:53 * postgres[14825]: [ID 748848 local2.warning] [27-2] CONTEXT: SQL function events_args_top500_week statement 1 Jun 20 06:50:53 * postgres[14825]: [ID 748848 local2.debug] [28-1] DEBUG: shmem_exit(0): 7 callbacks to make Jun 20 06:50:53 * postgres[14825]: [ID 748848 local2.debug] [29-1] DEBUG: proc_exit(0): 3 callbacks to make Jun 20 06:50:53 * postgres[14825]: [ID 748848 local2.debug] [30-1] DEBUG: exit(0) Jun 20 06:50:53 * postgres[14825]: [ID 748848 local2.debug] [31-1] DEBUG: shmem_exit(-1): 0 callbacks to make Jun 20 06:50:53 * postgres[14825]: [ID 748848 local2.debug] [32-1] DEBUG: proc_exit(-1): 0 callbacks to make apsalar=# select version(); PostgreSQL 9.2.4 on x86_64-pc-solaris2.11, compiled by gcc (GCC) 4.7.2, 64-bit (1 row) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8247: Duplicate database names - pg_dump backup fails
The following bug has been logged on the website: Bug reference: 8247 Logged by: Paul Macdonald Email address: paul.macdon...@ssc-spc.gc.ca PostgreSQL version: Unsupported/Unknown Operating system: Debian Sarge Description: Postgres version: 7.4.7-6sarge1 Issue: pg_dump fails due to unexpected duplication of database name (avipads). Dropdb will remove one instance of the database name, but unable to remove the second instance. Scope: This specific database is used on multiple servers nationally. Three of our servers have this issue, the majority do not. The issue only affects our ability to locally backup the avipads database. The servers having the problem are clustered pair systems. The other cluster pair servers do not have the problem. Name| Owner | Encoding ---+-+--- avipads | | SQL_ASCII avipads | avimgr | SQL_ASCII rtadb | rtafbackend | SQL_ASCII rtafdb| rtafbackend | SQL_ASCII template0 | postgres| SQL_ASCII template1 | postgres| SQL_ASCII When a new version of the database is available for installation, the installation script does the following steps a) remove the old database su - avimgr -c dropdb --quiet --username=avimgr avipads || true b) remove the avimgr user su - postgres -c dropuser --quiet avimgr || true c) create the avimgr Posgresql user su - postgres -c createuser avimgr --no-adduser --createdb --quiet; true 2 /dev/null d) install the new database su - avimgr -c /apps/avipads/voicedb/restorevoice /apps/avipads/voicedb/vdb2.5.1.pg I would like details on how to successfully remove both avipads databases, in order to have the pg_dump be functional again. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8247: Duplicate database names - pg_dump backup fails
paul.macdon...@ssc-spc.gc.ca writes: Postgres version: 7.4.7-6sarge1 Egad. Not only has 7.4 been EOL for years, but the last release in that series was 7.4.30. You are missing many years' worth of bug fixes. You really, really, really need to get off of that PG version ASAP. Issue: pg_dump fails due to unexpected duplication of database name (avipads). Dropdb will remove one instance of the database name, but unable to remove the second instance. I suspect this is evidence of transaction ID wraparound in the pg_database catalog. See if VACUUM FULL pg_database makes things any saner. (Delete the one database that you're able to get rid of first.) regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559
kappleg...@apsalar.com writes: One of our queries has started failing randomly on our slaves with invalid memory alloc request size 18446744073709537559 It's hard to say much with that amount of information. Is it always the exact same number? The root cause is probably either corrupted data (that is, a trashed length word for some variable-width field) or some internal logic bug that's causing the server to miscompute how much memory it needs for some transient allocation. You could confirm or refute the corrupt-data hypothesis by seeing if you can pg_dump each of the tables referenced by the failing procedure. If pg_dump fails with the same error then it's corrupt data, else not. If it's a bug, though, we'd still be needing more info to track it down. Don't suppose you'd want to change that specific ERROR to a PANIC so we could get a stack trace :-( regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8246: Delete Cascade causing performance issues
The following bug has been logged on the website: Bug reference: 8246 Logged by: sandeep Email address: msandee...@gmail.com PostgreSQL version: 8.4.17 Operating system: windows 7 Description: Hi All, I have a database containing 10 tables say as t1 ,t2,t3,t4..t10.There is a column in t1 which is primary key and that primary key to other tables (i.e t2 t3 t10). Now when ingesting data i am able to ingest it around nearly able 1 lakh rows in secs. now i want to delete the primary key from t1 so that the data other tables data get deleted.But since the data is huge approx 1.5 rows get affected its taking 6 minutes to delete it. Is there something that can be done . -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8248: se presenta una excepcion cuando intento realizar consultas des la aplicacion en netbeasns
The following bug has been logged on the website: Bug reference: 8248 Logged by: Jefferson Velasco Email address: javelasc...@misena.edu.co PostgreSQL version: 8.4.0 Operating system: windows Description: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.0.v20110202-r8913): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.postgresql.util.PSQLException: ERROR: no están implementadas las referencias entre bases de datos: «farmacia.public.usuario» Error Code: 0 Call: SELECT idusuario, clave, nombreusuario, rol, idpersona FROM Farmacia.public.usuario WHERE ((nombreusuario = ?) AND (clave = ?)) bind = [2 parameters bound] Query: ReadAllQuery(referenceClass=Usuario sql=SELECT idusuario, clave, nombreusuario, rol, idpersona FROM Farmacia.public.usuario WHERE ((nombreusuario = ?) AND (clave = ?))) javax.faces.el.EvaluationException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.0.v20110202-r8913): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.postgresql.util.PSQLException: ERROR: no están implementadas las referencias entre bases de datos: «farmacia.public.usuario» Error Code: 0 Call: SELECT idusuario, clave, nombreusuario, rol, idpersona FROM Farmacia.public.usuario WHERE ((nombreusuario = ?) AND (clave = ?)) bind = [2 parameters bound] Query: ReadAllQuery(referenceClass=Usuario sql=SELECT idusuario, clave, nombreusuario, rol, idpersona FROM Farmacia.public.usuario WHERE ((nombreusuario = ?) AND (clave = ?))) at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102) at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) at javax.faces.component.UICommand.broadcast(UICommand.java:315) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259) at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81) at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:409) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.0.v20110202-r8913): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.postgresql.util.PSQLException: ERROR: no están implementadas las referencias entre bases de datos: «farmacia.public.usuario» Error Code: 0 Call: SELECT idusuario, clave, nombreusuario, rol, idpersona FROM Farmacia.public.usuario WHERE ((nombreusuario = ?) AND (clave = ?)) bind = [2 parameters bound] Query: ReadAllQuery(referenceClass=Usuario sql=SELECT idusuario, clave, nombreusuario, rol, idpersona FROM Farmacia.public.usuario WHERE ((nombreusuario = ?) AND (clave = ?))) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1729) at
Re: [BUGS] BUG #8248: se presenta una excepcion cuando intento realizar consultas des la aplicacion en netbeasns
On Fri, Jun 21, 2013 at 2:06 PM, javelasc...@misena.edu.co wrote: The following bug has been logged on the website: Bug reference: 8248 Logged by: Jefferson Velasco Email address: javelasc...@misena.edu.co PostgreSQL version: 8.4.0 Operating system: windows Description: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.0.v20110202-r8913): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.postgresql.util.PSQLException: ERROR: no están implementadas las referencias entre bases de datos: «farmacia.public.usuario» Error Code: 0 Call: SELECT idusuario, clave, nombreusuario, rol, idpersona FROM Farmacia.public.usuario WHERE ((nombreusuario = ?) AND (clave = ?)) bind = [2 parameters bound] Query: ReadAllQuery(referenceClass=Usuario sql=SELECT idusuario, clave, nombreusuario, rol, idpersona FROM Farmacia.public.usuario WHERE ((nombreusuario = ?) AND (clave = ?))) This is not actually a bug but a well known postgresql limitation, you can't use database references in the from. I answered to the OP, explaining that and redirecting him to pgsql-es-ayuda@ -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs