Newbie and boost::bad_any_cast

[Prime_minister_of_fun]

Hi,

I'm trying to get a single pod running columnstore and got the following error on a query.

mariadb11-0 joblist[9326]: 13.053579 |156|0|0| C 05 CAL0000: CrossEngineStep::execute() caught Throw location unknown (consider using BOOST_THROW_EXCEPTION)#012Dynamic exception type: boost::wrapexcept<boost::bad_any_cast>#012std::exception::what: boost::bad_any_cast: failed conversion using boost::any_cast#012       

The sparse configure instructions here don't start a working instance. https://mariadb.com/docs/server/deploy/topologies/single-node/community-columnstore-cs10-6/

I had to manually start the worker, and I did it after running /usr/bin/mariadb-columnstore-start.sh.  The rsyslog configuration the script generates does not work, either.  Everything is logged to /var/log/syslog, and it isn't much.

Aug 11 20:59:35 mariadb11-0 joblist[9326]: 35.961933 |0|0|0| I 05 CAL0000: QUERY to foreign engine: SELECT `userid`, `nameprefix`, `namesuffix`, `firstname`, `lastname`, `title`, `email`, `extension`, `foobar` FROM `users`        
Aug 11 20:59:36 mariadb11-0 joblist[9326]: 36.058509 |156|0|0| C 05 CAL0000: CrossEngineStep::execute() caught Throw location unknown (consider using BOOST_THROW_EXCEPTION)#012Dynamic exception type: boost::wrapexcept<boost::bad_any_cast>#012std::exception::what: boost::bad_any_cast: failed conversion using boost::any_cast#012         

The remote user is set and the credentials work using the client.

There is so little documentation I cannot sort it out myself, and I don't know where to begin.

Thanks,
Michael
 

[drrtuy]

Hi,

As you know CrossEngineStep is called when you have a join with a non-Columnstore table. It uses boost::any type to cast a numeric SQL types into an internal integral type used by the CES code. In this case one of this fields has an unsupported value : `userid`, `nameprefix`, `namesuffix`, `firstname`, `lastname`, `title`, `email`, `extension`, `foobar` . The easiest way would be to run a simple query that takes only one column from a foreign table at a time. I will appreciate if you find and share the offending column/value.

Regards,
Roman

суббота, 12 августа 2023 г. в 00:12:24 UTC+3, Prime_minister_of_fun: