Aah, apparently something in PHP/VirtuosoODBC really doesn't like
encountering DB_NULL as [a|the first] field in a resultset row.
Modifying the pl-sql function to prevent null values being returned
resolved the issue though something seems to be broken in the area of
allocating memory based on resultset field types.
On 21 November 2013 19:57, Quentin <quent...@clearbluewater.com.au> wrote:
> I'm trying to track down a memory issue with apache/php/odbc when talking
> to Virtuoso.
>
> The error is: "PHP Fatal error: Out of memory (allocated 3407872) (tried
> to allocate 18446744073709551613 bytes) in..."
> The actual line in PHP is: return (odbc_exec($this->db_link, $db_query));
>
> The db connection was opened with: $this->db_link =
> odbc_connect($this->dsn, $this->db_user, $this->db_pass,
> SQL_CUR_USE_DRIVER);
>
> The virtuoso odbc drivers in use were taken from the build of the database
> being accessed (same architecture/OS on both boxen):
> Virtuoso Open Source Edition (Column Store) (multi threaded)
> Version 7.0.1-dev.3203-pthreads as of Nov 11 2013
> Compiled for Linux (x86_64-unknown-linux-gnu)
>
> Are there any current issues I should be aware of or is there any advice
> you could offer about this?
>
> The actual resultset is about 7 rows from a result set thrown by an sql
> function via exec_result_names/exec_result but it seems to ask for quite a
> lot of memory and I'm not sure our budget extends to exabytes of ram.
>
> --
> Quentin | Clear Blue Water Pty Ltd
> quent...@clearbluewater.com.au
>
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
