Welcome,
Guest
.
Please
login
or
register
.
Did you miss your
activation email
?
News:
IOS Hotels
and
IOS Rentals
online booking systems for Elxis CMS.
Home
Help
Login
Register
Elxis CMS Forum
»
Support
»
Database
»
not connections to the Database closed
« previous
next »
Print
Pages: [
1
]
Author
Topic: not connections to the Database closed (Read 8160 times)
theprincy
PowerPcweb
Jr. Member
Posts: 93
Notelseit Web Hosting Services
not connections to the Database closed
«
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
Logged
Notelseit Srls
Sviluppo Software - Hosting - Siti Web
www.notelseit.com
CREATIVE Options
Authorized Elxis Professional
Elxis Community
Hero Member
Posts: 2334
Professional services for Elxis CMS
Re: not connections to the Database closed
«
Reply #1 on:
June 04, 2007, 16:35:19 »
Check your database list for a db with "gal_****" table.
Logged
theprincy
PowerPcweb
Jr. Member
Posts: 93
Notelseit Web Hosting Services
Re: not connections to the Database closed
«
Reply #2 on:
June 04, 2007, 16:55:29 »
does it check once what I must do more? it seems all in order in the db
Logged
Notelseit Srls
Sviluppo Software - Hosting - Siti Web
www.notelseit.com
datahell
Elxis Team
Hero Member
Posts: 10356
Re: not connections to the Database closed
«
Reply #3 on:
June 04, 2007, 17:58:36 »
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.
«
Last Edit: June 04, 2007, 18:01:20 by datahell
»
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
Print
Pages: [
1
]
« previous
next »
Elxis CMS Forum
»
Support
»
Database
»
not connections to the Database closed