Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-2752

LP:628780 - Connection loss on SELECT from empty table

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Not a Bug
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          Description

          I'm using oqgraph trunk (revision 10) from launchpad with MariaDB 5.1.47. When executing the queries in the attached testcase, I get following response after the SELECT:

          ERROR 2013 (HY000): Lost connection to MySQL server during query

              • Note from Arjen: this only happens when using code from the oqgraph repo, the bug not does not appear when building MariaDB 5.2 which includes oqgraph.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                heinzwiesinger Heinz Wiesinger added a comment -

                oqgraph_testcase.sql
                LPexportBug628780_oqgraph_testcase.sql

                Show
                heinzwiesinger Heinz Wiesinger added a comment - oqgraph_testcase.sql LPexportBug628780_oqgraph_testcase.sql
                Hide
                Permalink
                heinzwiesinger Heinz Wiesinger added a comment -

                Re: Connection loss on SELECT from empty table

                Show
                heinzwiesinger Heinz Wiesinger added a comment - Re: Connection loss on SELECT from empty table
                Hide
                Permalink
                arjenlentz Arjen Lentz added a comment -

                Re: Connection loss on SELECT from empty table
                Heinz, since you're building from source anyway, can you please try this in MariaDB 5.2 which has OQGRAPH in the trunk already? I think you might be tripping over a bug that's already been fixed since, but not quite sure because of the different repos. thanks.

                Show
                arjenlentz Arjen Lentz added a comment - Re: Connection loss on SELECT from empty table Heinz, since you're building from source anyway, can you please try this in MariaDB 5.2 which has OQGRAPH in the trunk already? I think you might be tripping over a bug that's already been fixed since, but not quite sure because of the different repos. thanks.
                Hide
                Permalink
                heinzwiesinger Heinz Wiesinger added a comment -

                Re: Connection loss on SELECT from empty table
                I tried with latest 5.2 code. After some issues with xtradb vs. innodb I have it up and running just fine, but when trying to load the oqgraph engine I get an error:

                [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/oqgraph_engine.so' (errno: 0 undefined symbol: ZTVN10cxxabiv120_si_class_type_infoE)

                I tried to google and found that it might have something to do with libstdc++. But that's about it :-/

                Show
                heinzwiesinger Heinz Wiesinger added a comment - Re: Connection loss on SELECT from empty table I tried with latest 5.2 code. After some issues with xtradb vs. innodb I have it up and running just fine, but when trying to load the oqgraph engine I get an error: [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/oqgraph_engine.so' (errno: 0 undefined symbol: ZTVN10 cxxabiv120 _si_class_type_infoE) I tried to google and found that it might have something to do with libstdc++. But that's about it :-/
                Hide
                Permalink
                heinzwiesinger Heinz Wiesinger added a comment -

                Re: Connection loss on SELECT from empty table
                Ok, apparently that's an issue with oqgraph_engine.so not linking with libstdc++ in some cases. I had to specify g++ as my compiler instead of gcc to fix it.

                Anyway, with the engine now loading I can verify that I no longer get that error on the oqgraph version included in MariaDB 5.2.

                Show
                heinzwiesinger Heinz Wiesinger added a comment - Re: Connection loss on SELECT from empty table Ok, apparently that's an issue with oqgraph_engine.so not linking with libstdc++ in some cases. I had to specify g++ as my compiler instead of gcc to fix it. Anyway, with the engine now loading I can verify that I no longer get that error on the oqgraph version included in MariaDB 5.2.
                Hide
                Permalink
                arjenlentz Arjen Lentz added a comment -

                Re: Connection loss on SELECT from empty table
                Yep you need to build with g++. The scripts in BUILD/ do that, so please do use those.

                Ok, thanks for verifying that indeed that issues has been fixed in the MariaDB oqgraph codebase. Will need to see why it's not in the oqgraph bzr repo... to prevent others from tripping over it.

                Show
                arjenlentz Arjen Lentz added a comment - Re: Connection loss on SELECT from empty table Yep you need to build with g++. The scripts in BUILD/ do that, so please do use those. Ok, thanks for verifying that indeed that issues has been fixed in the MariaDB oqgraph codebase. Will need to see why it's not in the oqgraph bzr repo... to prevent others from tripping over it.
                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 628780

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 628780

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    heinzwiesinger Heinz Wiesinger
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: