Elxis CMS Forum
Support => Database => Topic started by: theprincy on June 04, 2007, 16:14:07
-
do I have this problems on a site hosting he has sent me an email telling me that on the site there are correctly " not connections to the Database closed" also giving me a log, but don't I believe that depend on elxis confirmed?
log :
SET TIMESTAMP=1180700116;
SET ONE_SHOT CHARACTER_SET_CLIENT=33,COLLATION_CONNECTION=33,COLLATION_DATABASE=33,COLLATION_SERVER=48;
# at 21920257
#070601 14:15:16 server id 1 log_pos 21920257 Query thread_id=35726 exec_time=0 error_code=0
SET TIMESTAMP=1180700116;
DELETE FROM gal_session
WHERE (time < 1180699216);
# at 21920350
--
use xxxxxxxxxx;
SET TIMESTAMP=1180700196;
SET ONE_SHOT CHARACTER_SET_CLIENT=33,COLLATION_CONNECTION=33,COLLATION_DATABASE=33,COLLATION_SERVER=48;
# at 22017163
#070601 14:16:36 server id 1 log_pos 22017163 Query thread_id=35933 exec_time=0 error_code=0
SET TIMESTAMP=1180700196;
DELETE FROM gal_session
WHERE (time < 1180699296);
# at 22017256
--
use xxxxxxxxxxxxxxx;
SET TIMESTAMP=1180700203;
SET ONE_SHOT CHARACTER_SET_CLIENT=33,COLLATION_CONNECTION=33,COLLATION_DATABASE=33,COLLATION_SERVER=48;
# at 22024204
#070601 14:16:43 server id 1 log_pos 22024204 Query thread_id=35959 exec_time=0 error_code=0
SET TIMESTAMP=1180700203;
DELETE FROM gal_session
WHERE (time < 1180699303);
# at 22024297
--
use xxxxxxxxxxxxxxx;
SET TIMESTAMP=1180700231;
SET ONE_SHOT CHARACTER_SET_CLIENT=33,COLLATION_CONNECTION=33,COLLATION_DATABASE=33,COLLATION_SERVER=48;
# at 22070261
#070601 14:17:11 server id 1 log_pos 22070261 Query thread_id=36037 exec_time=0 error_code=0
SET TIMESTAMP=1180700231;
DELETE FROM gal_session
WHERE (time < 1180699331);
# at 22070354
--
use xxxxxxxxxxxxxxx;
SET TIMESTAMP=1180700233;
SET ONE_SHOT CHARACTER_SET_CLIENT=33,COLLATION_CONNECTION=33,COLLATION_DATABASE=33,COLLATION_SERVER=48;
# at 22073129
#070601 14:17:13 server id 1 log_pos 22073129 Query thread_id=36044 exec_time=0 error_code=0
SET TIMESTAMP=1180700233;
DELETE FROM gal_session
WHERE (time < 1180699333);
# at 22073222
--
use xxxxxxxxxxxxxxxx;
SET TIMESTAMP=1180700245;
SET ONE_SHOT CHARACTER_SET_CLIENT=33,COLLATION_CONNECTION=33,COLLATION_DATABASE=33,COLLATION_SERVER=48;
# at 22103603
#070601 14:17:25 server id 1 log_pos 22103603 Query thread_id=33281 exec_time=0 error_code=0
SET TIMESTAMP=1180700245;
DELETE FROM gal_session
WHERE (time < 1180699345);
# at 22103696
--
use xxxxxxxxxxxxxxx;
SET TIMESTAMP=1180700247;
SET ONE_SHOT CHARACTER_SET_CLIENT=33,COLLATION_CONNECTION=33,COLLATION_DATABASE=33,COLLATION_SERVER=48;
# at 22107225
#070601 14:17:27 server id 1 log_pos 22107225 Query thread_id=36104 exec_time=0 error_code=0
SET TIMESTAMP=1180700247;
DELETE FROM gal_session
WHERE (time < 1180699347);
# at 22107318
--
use xxxxxxxxxxxx;
SET TIMESTAMP=1180700251;
SET ONE_SHOT CHARACTER_SET_CLIENT=33,COLLATION_CONNECTION=33,COLLATION_DATABASE=33,COLLATION_SERVER=48;
# at 22112468
#070601 14:17:31 server id 1 log_pos 22112468 Query thread_id=36123 exec_time=0 error_code=0
SET TIMESTAMP=1180700251;
DELETE FROM gal_session
WHERE (time < 1180699351);
# at 22112561
--
use xxxxxxxxxxxxxx;
SET TIMESTAMP=1180700253;
SET ONE_SHOT CHARACTER_SET_CLIENT=33,COLLATION_CONNECTION=33,COLLATION_DATABASE=33,COLLATION_SERVER=48;
# at 22118086
#070601 14:17:33 server id 1 log_pos 22118086 Query thread_id=36132 exec_time=0 error_code=0
SET TIMESTAMP=1180700253;
DELETE FROM gal_session
WHERE (time < 1180699353);
# at 22118179
--
use xxxxxxxxxxx;
SET TIMESTAMP=1180700254;
SET ONE_SHOT CHARACTER_SET_CLIENT=33,COLLATION_CONNECTION=33,COLLATION_DATABASE=33,COLLATION_SERVER=48;
# at 22120900
#070601 14:17:34 server id 1 log_pos 22120900 Query thread_id=36137 exec_time=0 error_code=0
SET TIMESTAMP=1180700254;
DELETE FROM gal_session
WHERE (time < 1180699354);
# at 22120993
--
excuse me for my English
-
Check your database list for a db with "gal_****" table.
-
does it check once what I must do more? it seems all in order in the db
-
This query comes from the session purge process. You can try close the database cursor pointer at the end of the query using $this->_db->_cursor->Close(); Join Elxis support (support.elxis.org) if you can not solve the problem yourself.