Database query failed. ERROR 1296

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
judan
Posts: 14
Joined: 14 Jan 2013, 18:26
Location: Georgetown, Guyana
Contact:

Database query failed. ERROR 1296

Post by judan »

Hi. We cannot login to MantisBT.

Running MantisBT 1.2.19 on IBMi

Getting the following error message:

APPLICATION ERROR #401
Database query failed. Error received from database was #1296: Got error 2095 'Error connecting to server job' from IBMDB2I for the query: SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC.

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.


Here is the detailed errors:

Full path: /www/ourwebsite/htdocs/mantisbt/core/database_api.php
Line: 405
Variable Value Type
p_query SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC string
p_limit -1 integer
p_offset -1 integer
g_db_log_queries 1 boolean
g_db_param_count 1 integer
t_db_type mysql string
s_check_params boolean
t_start 1475156629.4004 double
t_caller plugin_api.php:808 plugin_register_installed() string
i 1 integer
t_result boolean
t_elapsed 0.6750 string
lastoffset 78 integer
t_utf8_offset 76 integer
replace 1 double

arr_parms
Variable Value Type
0 1 integer

g_queries_array
Variable Value Type

1
Variable Value Type
0 SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC string
1 0.6750 string
2 plugin_api.php:808 plugin_register_installed() string

t_backtrace
Variable Value Type

1
Variable Value Type
file /www/ourwebsite/htdocs/mantisbt/core/plugin_api.php string
line 835 integer
function plugin_register_installed string

args
Variable Value Type

2
Variable Value Type
file /www/ourwebsite/htdocs/mantisbt/core.php string
line 234 integer
function plugin_init_installed string

args
Variable Value Type

3
Variable Value Type
file /www/ourwebsite/htdocs/mantisbt/index.php string
line 26 integer
function require_once string

args
Variable Value Type
0 /www/ourwebsite/htdocs/mantisbt/core.php string

matches
Variable Value Type
Filename Line Function Args
/www/ourwebsite/htdocs/mantisbt/core/database_api.php 405 - - trigger_error ( <string>'401', <integer>256 )
/www/ourwebsite/htdocs/mantisbt/core/plugin_api.php 808 - - db_query_bound ( <string>'SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=? ORDER BY priority DESC', <Array> { [0] => 1 } )
/www/ourwebsite/htdocs/mantisbt/core/plugin_api.php 835 - - plugin_register_installed -
/www/ourwebsite/htdocs/mantisbt/core.php 234 - - plugin_init_installed -
/www/ourwebsite/htdocs/mantisbt/index.php 26 - - require_once ( <string>'/www/ourwebsite/htdocs/mantisbt/core.php' )


Additional info:

I tried running the sql query from the MYSQL shell itself and got the following error message:

> SELECT basename, priority, protected FROM mantis_plugin_table WHERE
enabled=1 ORDER BY priority DESC;
ERROR 1296 (HY000): Got error 2043 'The associated QSQSRVR job was killed or
ended unexpectedly.' from IBMDB2I
mysql>


Note:

I am not able to do a MYSQL select on any of the tables. Can this mean that the Mantis database is corrupt?
~Jailall~
judan
Posts: 14
Joined: 14 Jan 2013, 18:26
Location: Georgetown, Guyana
Contact:

Re: Database query failed. ERROR 1296

Post by judan »

This issue has been resolved. The problem was with the IBMDB2I server.
~Jailall~
Post Reply