View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000006Pgpool-IIBugpublic2012-02-23 11:432012-02-23 19:50
Reporterzwy Assigned Tokitagawa 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionno change required 
OSRedHat 5.5 
Summary0000006: Selects is not balanced among a session
DescriptionSelects is not balanced among a session. In the test case, it always gets the same result.
Steps To ReproduceConnection conn1 = DriverManager.getConnection(connstr1, username1,
                    pwd1);
            conn1.setAutoCommit(true);
            for (int i = 1; i <= 100; i++) {
                Statement stmt = conn1.createStatement();
                ResultSet rset = stmt.executeQuery("select inet_server_addr()");
                if (rset.next())
                    System.out.println(rset.getString(1));
            }
            conn1.close();
TagsNo tags attached.

Activities

kitagawa

2012-02-23 19:50

developer   ~0000014

Pgpool-II decides a destination backend every session.
If the client opens a single connection and execute a series of select queries,
they all get routed to the same backend except some cases.
If the client opens up multiple connections, both backends are used.

Issue History

Date Modified Username Field Change
2012-02-23 11:43 zwy New Issue
2012-02-23 19:50 kitagawa Note Added: 0000014
2012-02-23 19:50 kitagawa Status new => resolved
2012-02-23 19:50 kitagawa Resolution open => no change required
2012-02-23 19:50 kitagawa Assigned To => kitagawa