| Subject | Internal gds software consistency check (cannot find tip page (165)) |
|---|---|
| Author | Niben M Singh |
| Post date | 2008-08-24T05:33:27Z |
I stress tested my firebird database by running a query that
returns about fair amount of data (like 200 rows) 20000 times in a loop. I
found that after running the query about half an hour the database hung
and became inaccessible. The database would not accept any connections. I had to restart the server in order to re-run
my queries. I looked into the firebird.log file and saw error message "Internal gds software consistency check (cannot find tip page (165))".
Upon googling the error message I came across this page
http://dn.codegear.com/article/30208
Just as stated in the page the user I was using had read-only access to the database. After modifying the user to have write permission the error seem to go away. I did not see the problem happening. Is this something we should be aware of before deploying database with read-only user? Or, is there something I have missed??
Niben
[Non-text portions of this message have been removed]
returns about fair amount of data (like 200 rows) 20000 times in a loop. I
found that after running the query about half an hour the database hung
and became inaccessible. The database would not accept any connections. I had to restart the server in order to re-run
my queries. I looked into the firebird.log file and saw error message "Internal gds software consistency check (cannot find tip page (165))".
Upon googling the error message I came across this page
http://dn.codegear.com/article/30208
Just as stated in the page the user I was using had read-only access to the database. After modifying the user to have write permission the error seem to go away. I did not see the problem happening. Is this something we should be aware of before deploying database with read-only user? Or, is there something I have missed??
Niben
[Non-text portions of this message have been removed]