[SOLVED] MariaDB Connet to Oracle@ODBC stop woking after update 2.1.1 --> 2.1.2

Hi,
yesterday my CyberPanel has ben updated. And today i have a problem with my PrestaShop.

Products and prices are imported form Oracle to MariaDB it worked for 2 years, today at 2. AM stooped.

I have created 8 simple views, each one gets data from Oracle (special intermediate limited schema for additional security).

Now, when I try to select data form any of these views i get error:

obraz544×824 24.7 KB

1296 HY000 ER_GET_ERRMSG Got error %d ‘%s’ from %s

That’s an general code, arguments don’t tell me anything.

Connection outside of MaridaDB is working. I can connect by SSH to my serwer, i can log in to db

2

And i can retrive data from view:

3

Screenshot combined in to one media (forum noob limiter workaround )

Is there any log/trace that can help me to pinpoint this problem?

Something depreciated OPTION_LIST=‘Memory=2’;

...
ENGINE = CONNECT TABLE_TYPE = ODBC TABNAME = 'B2C_V_MANUFACTURERS' CONNECTION = 'DSN=XXXXXXXX;UID=XXXXXX;PWD=XXXXXX;CHARSET=UTF8' CHARSET = UTF8 DATA_CHARSET = UTF8 `OPTION_LIST`='Memory=2';

after removal OPTION_LIST=‘Memory=2’, and regeneration of all views all works fine.

Glad that its all fine now. We are marking your information as solution for anyone else encountering the same issue.

Not exactly fine.

After removal of memory=2 option. I can select data from table in PHPMyAdmin but we use these tables in cursors. I get this error form my Presta admin:

#1031 - This action requires Memory setting or a scrollable cursor

Now i recreated only one table “product_prices” with option memory=1. I is working in PHP My Admin, i’m waiting on feedback from Presta Admin if it works in cursors.

Title of this post will require update if MEMORY=2 had been deprecated in that update.

ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION=‘DSN=CENTROWET;UID=hapi;PWD=hapi;charset=utf8’ TABLE_TYPE=ODBC TABNAME=‘B2B_V_PRICE’ OPTION_LIST=‘Memory=1,Scrollable=Yes’ DATA_CHARSET=utf8;

— #1296 - Got error 174 ‘Scrollable: [Oracle][ODBC]Driver not capable.’ from CONNECT

ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION=‘DSN=CENTROWET;UID=hapi;PWD=hapi;charset=utf8’ TABLE_TYPE=ODBC TABNAME=‘B2B_V_PRICE’ OPTION_LIST=‘Memory=2,Scrollable=Yes’ DATA_CHARSET=utf8;

— #1296 - Got error 174 ‘Get result size: Scrollable: [Oracle][ODBC]Driver not capable. (rc=-1)’ from CONNECT

ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION=‘DSN=CENTROWET;UID=hapi;PWD=hapi;charset=utf8’ TABLE_TYPE=ODBC TABNAME=‘B2B_V_PRICE’ OPTION_LIST=‘Memory=1’ DATA_CHARSET=utf8;

— PHP My Admin recives data PrestaShop not

ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION=‘DSN=CENTROWET;UID=hapi;PWD=hapi;charset=utf8’ TABLE_TYPE=ODBC TABNAME=‘B2B_V_PRICE’ OPTION_LIST=‘Memory=2’ DATA_CHARSET=utf8;

— #1296 - Got error 174 ‘Get result size: [Oracle][ODBC]Invalid column number <0>. (rc=-3)’ from CONNECT

ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION=‘DSN=CENTROWET;UID=hapi;PWD=hapi;charset=utf8’ TABLE_TYPE=ODBC TABNAME=‘B2B_V_PRICE’ OPTION_LIST=‘Scrollable=Yes’ DATA_CHARSET=utf8;

— #1296 - Got error 174 ‘Scrollable: [Oracle][ODBC]Driver not capable.’ from CONNECT

ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION=‘DSN=CENTROWET;UID=hapi;PWD=hapi;charset=utf8’ TABLE_TYPE=ODBC TABNAME=‘B2B_V_PRICE’ OPTION_LIST=‘Scrollable=No’ DATA_CHARSET=utf8;

— PHP My Admin recives data PrestaShop not

ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION=‘DSN=CENTROWET;UID=hapi;PWD=hapi;charset=utf8’ TABLE_TYPE=ODBC TABNAME=‘B2B_V_PRICE’ DATA_CHARSET=utf8;

— PHP My Admin recives data PrestaShop not

The above post will leed google to this errors if someone else will have this problem.

I need option 2, but it clearly not working.

What files compose ODBC driver in Linux?

Final solution!

Downgrade of MariaDB 10.5.13 → 10.5.12

@MOD please update title to:

[Solved] MariaDB 10.5.13 brakes OBDC Connector OPTION_LIST Memory=2 parameter.