View Issue Details

IDProjectCategoryView StatusLast Update
0000006Pgpool-IIBugpublic2012-02-23 19:50
ReporterzwyAssigned Tokitagawa 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionno change required 
PlatformOSRedHat 5.5OS Version
Product Version 
Target VersionFixed in Version 
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