Warning (2): pg_pconnect() [function.pg-pconnect]: Unable to connect to PostgreSQL server: FATAL: remaining connection slots are reserved for non-replication superuser connections [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 122]
pg_pconnect - [internal], line ??
DboPostgres::connect() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 122
DboSource::__construct() - CORE/cake/libs/model/datasources/dbo_source.php, line 144
ConnectionManager::getDataSource() - CORE/cake/libs/model/connection_manager.php, line 114
Model::setDataSource() - CORE/cake/libs/model/model.php, line 2863
Model::__construct() - CORE/cake/libs/model/model.php, line 478
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Warning (2): pg_set_client_encoding() expects parameter 1 to be resource, boolean given [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 987]
*/ function setEncoding($enc) { return pg_set_client_encoding($this->connection, $enc) == 0;
$enc = "utf8"
pg_set_client_encoding - [internal], line ??
DboPostgres::setEncoding() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 987
DboPostgres::connect() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 131
DboSource::__construct() - CORE/cake/libs/model/datasources/dbo_source.php, line 144
ConnectionManager::getDataSource() - CORE/cake/libs/model/connection_manager.php, line 114
Model::setDataSource() - CORE/cake/libs/model/model.php, line 2863
Model::__construct() - CORE/cake/libs/model/model.php, line 478
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
Warning (2): pg_query() expects parameter 1 to be resource, boolean given [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 169]
*/ function _execute($sql) { return pg_query($this->connection, $sql);
$sql = "SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'hkldb' OR table_schema = 'pepdb' OR table_schema = 'xtaldb' OR table_schema = 'public';"
pg_query - [internal], line ??
DboPostgres::_execute() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 169
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 254
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 411
DboPostgres::listSources() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 187
Model::setSource() - CORE/cake/libs/model/model.php, line 777
Model::__construct() - CORE/cake/libs/model/model.php, line 483
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
Warning (2): pg_last_error() expects parameter 1 to be resource, boolean given [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 462]
*/ function lastError() { $error = pg_last_error($this->connection);
pg_last_error - [internal], line ??
DboPostgres::lastError() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 462
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 258
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 411
DboPostgres::listSources() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 187
Model::setSource() - CORE/cake/libs/model/model.php, line 777
Model::__construct() - CORE/cake/libs/model/model.php, line 483
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/cakephp-1.3-git/cake/libs/debugger.php:686) [CORE/cake/libs/controller/controller.php, line 742]
header - [internal], line ??
Controller::header() - CORE/cake/libs/controller/controller.php, line 742
ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 254
Object::dispatchMethod() - CORE/cake/libs/object.php, line 112
ErrorHandler::__construct() - CORE/cake/libs/error.php, line 125
Object::cakeError() - CORE/cake/libs/object.php, line 201
Model::setSource() - CORE/cake/libs/model/model.php, line 783
Model::__construct() - CORE/cake/libs/model/model.php, line 483
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_ActionsHelper::create() - /var/www/unitrack/views/helpers/unitrack_actions.php, line 236
include - APP/views/layouts/default.ctp, line 81
View::_render() - CORE/cake/libs/view/view.php, line 736
View::renderLayout() - CORE/cake/libs/view/view.php, line 494
View::render() - CORE/cake/libs/view/view.php, line 440
Controller::render() - CORE/cake/libs/controller/controller.php, line 909
ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 458
ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 261
Object::dispatchMethod() - CORE/cake/libs/object.php, line 112
ErrorHandler::__construct() - CORE/cake/libs/error.php, line 125
Object::cakeError() - CORE/cake/libs/object.php, line 201
Model::setSource() - CORE/cake/libs/model/model.php, line 783
Model::__construct() - CORE/cake/libs/model/model.php, line 483
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Error:
Database table person for model LabdbUser was not found.
Trace:
include - /var/www/unitrack/views/errors/unitrack_missing_table.ctp, line 9
include - APP/views/errors/missing_table.ctp, line 1
View::_render() - CORE/cake/libs/view/view.php, line 736
View::render() - CORE/cake/libs/view/view.php, line 431
Controller::render() - CORE/cake/libs/controller/controller.php, line 909
ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 458
ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 261
Object::dispatchMethod() - CORE/cake/libs/object.php, line 112
ErrorHandler::__construct() - CORE/cake/libs/error.php, line 125
Object::cakeError() - CORE/cake/libs/object.php, line 201
Model::setSource() - CORE/cake/libs/model/model.php, line 783
Model::__construct() - CORE/cake/libs/model/model.php, line 483
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 667
Model::__createLinks() - CORE/cake/libs/model/model.php, line 638
Model::__construct() - CORE/cake/libs/model/model.php, line 491
Unitrack_AppModel::__construct() - /var/www/unitrack/unitrack_app_model.php, line 69
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Controller::loadModel() - CORE/cake/libs/controller/controller.php, line 637
Controller::constructClasses() - CORE/cake/libs/controller/controller.php, line 502
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 186
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
(default) 32 queries took 57 ms
Nr
Query
Error
Affected
Num. rows
Took (ms)
1
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
8
2
SELECT matviewname as name FROM pg_matviews;
0
0
1
3
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
2
4
SELECT matviewname as name FROM pg_matviews;
0
0
0
5
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
2
6
SELECT matviewname as name FROM pg_matviews;
0
0
0
7
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
2
8
SELECT matviewname as name FROM pg_matviews;
0
0
0
9
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
2
10
SELECT matviewname as name FROM pg_matviews;
0
0
0
11
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
2
12
SELECT matviewname as name FROM pg_matviews;
0
0
0
13
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
2
14
SELECT matviewname as name FROM pg_matviews;
0
0
14
15
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
2
16
SELECT matviewname as name FROM pg_matviews;
0
0
0
17
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
2
18
SELECT matviewname as name FROM pg_matviews;
0
0
0
19
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
2
20
SELECT matviewname as name FROM pg_matviews;
0
0
0
21
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
2
22
SELECT matviewname as name FROM pg_matviews;
0
0
0
23
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
2
24
SELECT matviewname as name FROM pg_matviews;
0
0
0
25
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
2
26
SELECT matviewname as name FROM pg_matviews;
0
0
0
27
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
2
28
SELECT matviewname as name FROM pg_matviews;
0
0
0
29
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
2
30
SELECT matviewname as name FROM pg_matviews;
0
0
1
31
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';
109
109
4
32
SELECT matviewname as name FROM pg_matviews;
0
0
1
(labdb) 2 queries took 1 ms
Nr
Query
Error
Affected
Num. rows
Took (ms)
1
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'hkldb' OR table_schema = 'pepdb' OR table_schema = 'xtaldb' OR table_schema = 'public';