ID:               39735
 User updated by:  roberto at spadim dot com dot br
 Reported By:      roberto at spadim dot com dot br
-Status:           Bogus
+Status:           Open
-Bug Type:         Unknown/Other Function
+Bug Type:         SQLite related
 Operating System: linux 2.6.10
 PHP Version:      5.2.0
 New Comment:

i got the error:
see sqlite_query():

COMMIT TRANSACTION;
begin transaction;
PRAGMA default_synchronous=NORMAL;
PRAGMA auto_vacuum=1;
PRAGMA synchronous=NORMAL;
PRAGMA default_temp_store=MEMORY;
PRAGMA temp_store=MEMORY;
PRAGMA case_sensitive_like=0;
PRAGMA encoding=\"UTF-8\";
COMMIT TRANSACTION; <-- here php(sqlite) crash

could we send this bug to sqlite team?


Previous Comments:
------------------------------------------------------------------------

[2006-12-04 21:11:54] [EMAIL PROTECTED]

Sorry, but your problem does not imply a bug in PHP itself.  For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system is not the
appropriate forum for asking support questions.  Due to the volume
of reports we can not explain in detail here why your report is not
a bug.  The support channels will be able to provide an explanation
for you.

Thank you for your interest in PHP.

You need to report this bug to sqlite devs, PHP uses stock 
sqlite library so any assertion failures would imply bugs in 
the lib itself.

------------------------------------------------------------------------

[2006-12-04 21:09:28] roberto at spadim dot com dot br

this occur after sqlite_query("COMMIT TRANSACTION",$LINK);

i didn't killed the process, neither kernel

COMMIT TRANSACTION
php: ./src/pager.c:1237: syncJournal: Assertion `pPg->needSync==0'
failed.
Aborted

------------------------------------------------------------------------

[2006-12-04 21:02:12] [EMAIL PROTECTED]

The error comes from SQLite, which means it didn't like the fact that
you killed the process, when it was syncing the data on the disk.
Not PHP problem.

------------------------------------------------------------------------

[2006-12-04 20:54:25] roberto at spadim dot com dot br

Description:
------------
PHP 5.1.6

php: ./src/pager.c:1237: syncJournal: Assertion `pPg->needSync==0'
failed.

this message never appeared before

after an error on my test php i get 1082M of memory use
i killed php process, swapoff and swapon
after this php any file got this message, i will reboot system to get
new messages

Reproduce code:
---------------
any code 
<?php
$a=10;
?>

i think that's an problem with memory allocation

Expected result:
----------------
continue script run

Actual result:
--------------
php: ./src/pager.c:1237: syncJournal: Assertion `pPg->needSync==0'
failed.
Aborted


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=39735&edit=1

Reply via email to