5.0b36 // MAC, Vserver Prefs Panel,
Bart Pietercil
bart.pietercil at cognosis.be
Tue Jul 10 11:09:14 CDT 2012
Hi William,
the unregistered has no meaning to you. It is the database that registers (and unregisters) with the server. Just for your information this is an excerpt from the log of one of our servers; you'll notice that it begins with the database registering and ends with unregistering
Tue Jul 10 2012 18:02:32.961284 (TID 4083719024): (UID 51) Database 'core_bb_training_philips.vdb' remoteID 176325528 registered.
Tue Jul 10 2012 18:02:32.961401 (TID 4083719024): (UID 51) Database 'core_bb_training_philips' has been successfully opened.
Tue Jul 10 2012 18:02:32.961720 (TID 4108884848): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'SELECT version FROM _schema_version'.
Tue Jul 10 2012 18:02:33.120009 (TID 4100496240): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'CALL cm_SetConnectionVars(1)'.
Tue Jul 10 2012 18:02:33.172423 (TID 4083719024): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'SELECT `vw_input_languages_lst`.* FROM `vw_input_languages_lst`'.
Tue Jul 10 2012 18:02:33.184296 (TID 4108884848): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'CALL cm_php_GetTypelistvalue('AssignmentStatusList',NULL,NULL)'.
Tue Jul 10 2012 18:02:33.222085 (TID 4100496240): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'SELECT `vw_input_languages_lst`.* FROM `vw_input_languages_lst`'.
Tue Jul 10 2012 18:02:33.224765 (TID 4083719024): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'SELECT `vw_input_languages_lst`.* FROM `vw_input_languages_lst` WHERE (pkid NOT IN (SELECT `vw_training_assignments_translations_tab`.`language_id` FROM `vw_training_assignments_translations_tab` WHERE (assignment_default_id = 3463))) ORDER BY `language_name` ASC'.
Tue Jul 10 2012 18:02:33.230757 (TID 4108884848): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'SELECT `vw_training_assignments_parts_tab`.* FROM `vw_training_assignments_parts_tab` WHERE (assignment_id = '3463')'.
Tue Jul 10 2012 18:02:33.254504 (TID 4108884848): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'SELECT `vw_training_assignments_lst`.* FROM `vw_training_assignments_lst` WHERE (((`vw_training_assignments_lst`.`pkid` = '3463')))'.
Tue Jul 10 2012 18:02:33.342309 (TID 4108884848): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'SELECT `vw_training_certificates_lst`.* FROM `vw_training_certificates_lst` WHERE (((`vw_training_certificates_lst`.`pkid` = 0)))'.
Tue Jul 10 2012 18:02:33.348262 (TID 4108884848): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'CALL cm_php_GetTypelistvalue('CertificateTypes',NULL,NULL)'.
Tue Jul 10 2012 18:02:33.370983 (TID 4108884848): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'select COUNT(tbl_event_participant.RecID) as 'count' from tbl_event_participant
where objptr_course_event -> objptr_assignment = 3463
AND objptr_participant_status->listvalue = '5'
AND objptr_jobticket_holder -> objptr_jobticket_holder IN
(
SELECT objptr_user
FROM mm_certificates_users
WHERE objptr_certificate = 0
);'.
Tue Jul 10 2012 18:02:33.373139 (TID 4108884848): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'CALL cm_php_GetTypelistvalue('AssignmentStatusList',NULL,NULL)'.
Tue Jul 10 2012 18:02:33.399997 (TID 4100496240): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'SET @some_assignment_id = 3463'.
Tue Jul 10 2012 18:02:33.411860 (TID 4083719024): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'SELECT `vw_training_assignments_classroom_course_event_tab`.* FROM `vw_training_assignments_classroom_course_event_tab` WHERE (assignment_id = '3463')'.
Tue Jul 10 2012 18:02:33.508286 (TID 4108884848): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'SELECT `vw_training_assignments_lst`.* FROM `vw_training_assignments_lst` WHERE (((`vw_training_assignments_lst`.`pkid` = '3463')))'.
Tue Jul 10 2012 18:02:33.587063 (TID 4108884848): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'SELECT No_Name1 as rsID from (CALL cm_GetNoRatingSystemRS_ID()); '.
Tue Jul 10 2012 18:02:33.595417 (TID 4100496240): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'SELECT `vw_training_assignments_access_tab`.* FROM `vw_training_assignments_access_tab` WHERE (assignment_id = '3463') ORDER BY pkid asc LIMIT 5'.
Tue Jul 10 2012 18:02:33.599575 (TID 4083719024): (UID 51) I_SqlDatabase 'core_bb_training_philips.vdb' SqlQuery 'select count(*) from `vw_training_assignments_access_tab` WHERE (assignment_id = '3463')'.
Tue Jul 10 2012 18:02:33.615837 (TID 4108884848): (UID 51) Ping OK.
Tue Jul 10 2012 18:02:33.615896 (TID 4108884848): (UID 51) Database: core_bb_training_philips; User: sa: OK
Tue Jul 10 2012 18:02:33.617687 (TID 4100496240): (UID 51) Database 'core_bb_training_philips' has been successfully closed.
Tue Jul 10 2012 18:02:33.617906 (TID 4083719024): (UID 51) Ping OK.
Tue Jul 10 2012 18:02:33.617935 (TID 4083719024): (UID 51) Database: core_bb_training_philips; User: sa: OK
Tue Jul 10 2012 18:02:33.618112 (TID 4108884848): (UID 51) Database 'core_bb_training_philips.vdb' remoteID 176325528 unregistered.
Tue Jul 10 2012 18:02:33.618140 (TID 4108884848): (UID 51) Closing database 'core_bb_training_philips': OK
This is an excerpt from what happens when a detail page in our application is loaded. As you can see, it takes WAY to much time , so back to refactoring….
hth,
--
Bart Pietercil
CTO Cognosis NV
Dorpstraat 28
3560 Lummen
On Tuesday 10 July 2012 at 17:42, william humphrey wrote:
> OK - I realize that I am not as knowledgable as everyone else here so please bear that in mind.
>
> I need a simple LiveCode/RunRev command for flush database as this is the third time with the latest beta that all my data was lost after rebooting the computer. After this flush command I need a "result" that shows it was actually done or that there was an error and what that error was.
>
> This includes the data in my backup so obviously it is all in RAM but not being written to the database. In the logs
>
> 2012-07-10 11:40:31.136 AM com.paradigmasoft.vserver_x64: Tue Jul 10 2012 11:40:31.136059 (TID 4328050688): (UID 18) Database 'b_l_database.vdb' remoteID 29133584 unregistered.
> 2012-07-10 11:40:31.136 AM com.paradigmasoft.vserver_x64: Tue Jul 10 2012 11:40:31.136081 (TID 4328050688): (UID 18) Closing database 'b_l_database': OK
> 2012-07-10 11:40:31.136 AM com.paradigmasoft.vserver_x64: Tue Jul 10 2012 11:40:31.136098 (TID 4328050688): (UID 18) Database 'b_l_database.vdb' object memory released.
> 2012-07-10 11:40:31.156 AM com.paradigmasoft.vserver_x64: Tue Jul 10 2012 11:40:31.156387 (TID 4326977536): (UID 18) Closing connection. ( Connections available: '5')
>
>
>
> I DON'T KNOW WHAT "UNREGISTERED" MEANS! The only other solution I can think of is to go back to an earlier version that doesn't lose my data.
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net (mailto:Valentina-beta at lists.macserve.net)
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina-beta/attachments/20120710/16e56dce/attachment-0001.html>
More information about the Valentina-beta
mailing list