From: Larry M. <lar...@ro...> - 2006-10-30 12:59:10
|
> display_errors Ah, I was looking in 'php.ini', where it is already set to 'on'. > the problem seems to be a DB2 / LOB issue That much is pretty obvious, even to me. > What's the explanation for that? I'd tell you if I could. The question marks for line numbers are completely unhelpful. Some might say even useless. So I debugged it as best I know how, and now I'm stuck at those timestamps... that third one doesn't look right to me, and since it's so much bigger than the others, that could be why the cache records are being nullified (the ' g_timestamp < ...' in the WHERE clause). It just occurred to me that I should be able to at least dump the sql from in 'adodb-db2.inc', but that'll have to wait until tonight. Hopefully that'll at least explain the DB2/LOB thing, if not the whole timestamp thing. I wonder if setting a CLOB to NULL is not supported? Gotta go to work now, will continue tonight. -------------------- Larry Menard "Defender of Geese and of All Things Natural" E-mail and MSN Messenger: lar...@ro... Web: http://ca.geocities.com/lar...@ro... ----- Original Message ----- From: "Andy Staudacher" <an...@ee...> To: <gal...@li...> Sent: Monday, October 30, 2006 4:07 AM Subject: Re: [Gallery-devel] Failure in DataCacheTest::testCleanPageDataCache > See the warning for " display_errors 0" in the upper right corner of > the unittest page? Please change this in config.php. > > Apart from that, the problem seems to be a DB2 / LOB issue: > PHP ERROR: db2_fetch_array() [function.db2-fetch-array]: Cannot Determine > LOB Size in ?? (PHPUnit_error_handler) at line ?? > in C:\MyServer\gallery2\lib\adodb\drivers\adodb-db2.inc.php > (db2_fetch_array) at line 811 > in C:\MyServer\gallery2\lib\adodb\adodb.inc.php (ADORecordSet_db2::_fetch) > at line 2763 > in C:\MyServer\gallery2\lib\adodb\adodb.inc.php (ADORecordSet::Init) at > line > 922 > in C:\MyServer\gallery2\lib\adodb\adodb.inc.php (ADOConnection::_Execute) > at > line 882 > in C:\MyServer\gallery2\modules\core\classes\GalleryStorage.class > (ADOConnection::Execute) at line 468 > in C:\MyServer\gallery2\modules\core\classes\Gallery.class > (GalleryStorage::search) at line 202 > in C:\MyServer\gallery2\modules\core\test\phpunit\DataCacheTest.class > (Gallery::search) at line 678 > in C:\MyServer\gallery2\lib\tools\phpunit\phpunit.inc > (DataCacheTest::testCleanPageDataCache) at line 295 > in C:\MyServer\gallery2\lib\tools\phpunit\phpunit.inc (TestCase::runTest) > at > line 383 > in C:\MyServer\gallery2\lib\tools\phpunit\phpunit.inc (TestCase::runBare) > at > line 556 > in C:\MyServer\gallery2\lib\tools\phpunit\phpunit.inc (TestResult::run) at > line 261 > in C:\MyServer\gallery2\lib\tools\phpunit\phpunit.inc (TestCase::run) at > line 465 > in C:\MyServer\gallery2\lib\tools\phpunit\phpunit.inc (TestSuite::run) at > line 465 > in C:\MyServer\gallery2\lib\tools\phpunit\index.tpl (TestSuite::run) at > line > 250 > in C:\MyServer\gallery2\lib\tools\phpunit\index.php (include) at line 349 > > What's the explanation for that? > > - Andy > > Larry Menard wrote: >> Folks, >> >> I'm debugging the failure I'm getting in the subject unit >> test. Here's the debug output: >> >> >> http://cpe0013102da23b-cm0f0079804905.cpe.net.cable.rogers.com >> /misc/Gallery2/oct%2029%202006/DataCacheTest.testCleanPageData >> Cache.html >> <http://cpe0013102da23b-cm0f0079804905.cpe.net.cable.rogers.co >> m/misc/Gallery2/oct 29 >> 2006/DataCacheTest.testCleanPageDataCache.html> >> >> I've determined that the number of cache entries changes >> from 4 (good) to 0 (bad) when updateMapEntry() is called from >> inside _cleanPageDataCache(), but only when it is called by >> putPageData('third'), not 'first' or 'second'. >> >> Since the unit test is expecting '4', I presume the UPDATE >> statement is not supposed to be updating any rows. The only >> real variable in the WHERE clause is the timestamp. And when >> you compare the timestamps, they are definitely different: >> >> putPageData('first'): timestamp = 70 >> putPageData('second'): timestamp = 95 >> putPageData('third'): timestamp = 1162174232 >> >> Obviously the timestamp for putPageData('third') is >> considerably different from the other two, and I presume this >> is why the cache map entries are being deleted. Can anyone >> suggest why this might be? >> >> Thanks. >> -------------------- >> Larry Menard >> "Defender of Geese and of All Things Natural" >> E-mail and MSN Messenger: lar...@ro... >> Web: http://ca.geocities.com/lar...@ro... >> > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > __[ g a l l e r y - d e v e l ]_________________________ > > [ list info/archive --> http://gallery.sf.net/lists.php ] > [ gallery info/FAQ/download --> http://gallery.sf.net ] > |