I'm new to node-oracledb but not new to Oracle, and running into a similar segfault issue when executing SELECT queries including CLOB columns. Using [email protected] and [email protected] here, on Amazon Linux 2016.09 using Oracle InstantClient 11.2.0.4.0, connecting to Oracle 11g 11.2.0.4.0, using node v6.9.5.
I am getting the following error' Segmentation fault' when i type 'sqlplus'.i am running oracle 8i on Red Hat Linux release 7.3 (Valhalla). Please assist!! Report message to a moderator.
Here's the gdb backtrace of the segfault: Program received signal SIGABRT, Aborted. I guess my problem is essentially the same. I'm using oracledb vs 1.12.2 instant client: Client Shared Library 64-bit - 12.1.0.2.0 node: 6.4.0 My local OS: Ubuntu 16.04 Oracle DB: Enterprise Edition Release 12.1.0.2.0 (On another Linux server, accessed via a SSH tunnel) NLSCHARACTERSET: AL32UTF8 I attach a project sample. I don't touch maxRows, but then I need more than a couple of rows to get the problem. I inserted 40 rows into a dummy table with this structure: CREATE TABLE TABLE1 ( COL1 CLOB, ID NUMBER(22,0) ); NOTE: When I remove (oracledb as any).fetchAsString = oracledb.CLOB; the problem disappears in my case (I haven't tested dossy's case)!
Let's see: create table issue609 (id number, data clob); begin for i in 1.200 loop insert into issue609 (id, data) values (i, i); end loop; end; Running the same issue609.js I provided earlier except removing the db.maxRows = 1; line, I get: $ node issue609.js 1, '1' 2, '2'. Output elided for brevity. 98, '98' 99, '99' 100, '100' Segmentation fault If I set db.maxRows to a value greater than or equal to 200 (the number of rows in the table, all of which are returned by the SELECT query with no WHERE clause), it runs fine. If I set it to 199 or less, it segfaults. Also, my issue609.js needs a small tweak for correctness's sake, modifying this line: stream.on('end', conn.close); to be: stream.on('end', conn.close.bind(conn)).
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |