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

Support and Discussion Database Server
1

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:

obraz
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 :smiley: )

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

1 Like
2

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.

1 Like
3

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

4

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.

5

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

1 Like
6

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?

7

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.

1 Like