Project

General

Profile

Bug #1322

Postgres prepared statement does not exist.

Added by Lugoues over 9 years ago. Updated almost 2 years ago.

Status:
New
Priority:
High
Assignee:
-
Category:
Quassel Core
Target version:
Start date:
11/03/2014
Due date:
% Done:

0%

Estimated time:
Version:
0.11-pre
OS:
Linux

Description

Quassel IRC: v0.12-pre (0.11.0+12 git-bd295c0)

I am getting the following errors from postgresql starting a few days ago. This ends up causing postgresql to shutdown with this message `
2014-11-01 00:19:43 EDT [15132-1] quassel@quassel FATAL: terminating connection due to administrator command`.

l don't see any errors in the quassel log itself.

postgres-log

2014-11-02 22:25:14 EST [22189-1] quassel@quassel ERROR:  prepared statement "quassel_select_senderid" does not exist                                                                                                             
2014-11-02 22:25:14 EST [22189-2] quassel@quassel STATEMENT:  EXECUTE quassel_select_senderid ('')
2014-11-02 22:25:14 EST [22189-3] quassel@quassel ERROR:  prepared statement "quassel_insert_message" does not exist 
2014-11-02 22:25:27 EST [22189-5] quassel@quassel ERROR:  prepared statement "quassel_select_messages" does not exist   
2014-11-02 22:25:27 EST [22189-6] quassel@quassel STATEMENT:  EXECUTE quassel_select_messages (203, 500)
2014-11-02 22:48:58 EST [25436-1] postgres@quassel ERROR:  function get_raw_page(unknown, integer) does not exist at character 31 
2014-11-02 22:48:58 EST [25436-2] postgres@quassel HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2014-11-02 22:48:58 EST [25436-3] postgres@quassel STATEMENT:  SELECT * FROM heap_page_items(get_raw_page('pg_prepared_statements', 1)); 
2014-11-02 22:54:34 EST [22189-7] quassel@quassel ERROR:  prepared statement "quassel_insert_sender" does not exist

History

#1 Updated by jjakob almost 2 years ago

This is normal and can be safely ignored.
https://github.com/quassel/quassel/blob/4251006ea8f4433e1c139d380cd6c748b0dfcc84/src/core/postgresqlstorage.cpp#L2169

    // Query preparing is done lazily. That means that instead of always checking if the query is already prepared
    // we just EXECUTE and catch the error

#2 Updated by jjakob almost 2 years ago

Your log also contains an unrelated error that was not caused by quassel

2014-11-02 22:48:58 EST [25436-1] postgres@quassel ERROR:  function get_raw_page(unknown, integer) does not exist at character 31 
2014-11-02 22:48:58 EST [25436-2] postgres@quassel HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2014-11-02 22:48:58 EST [25436-3] postgres@quassel STATEMENT:  SELECT * FROM heap_page_items(get_raw_page('pg_prepared_statements', 1)); 

The connecting user is postgres, not quassel, so it may have been caused by something else on your system.
It is also unrelated to the "prepared statement does not exist" error that this bug is titled from.

Also available in: Atom PDF