You are not logged in.
- Topics: Active | Unanswered
Announcement
Download last stable version of GLPI - What can you do for GLPI ? : Contribute
#1 2010-03-02 20:35:25
- billylebegue
- Member
- Registered: 2009-04-09
- Posts: 76
Sauvegarde manuelle - le nom de fichier existe déjà
Bonsoir,
Auparavant, en version 0.72.3, lorsque je tentais un backup manuel, toute première tentative se soldait par un backup partiel, suivi du message "le nom de fichier existe déjà". Généralement un second backup dans la foulée passait sans aucun problème.
Depuis la mise à jour en 0.72.4, il semblerait que ce comportement aie quelque peu changé. Je viens de faire un backup, je suis arrivé à une progression aux alentours de 42%, j'ai eu une sorte de refresh ("clignotement"), puis le backup a abouti. Seulement, je retrouve une trace d'un backup partiel
Le problème pourrait très bien venir de ma base de données (non optimisée, cela dépasse mes compétences malheureusement) ou des plugins installés, je souhaiterais juste savoir si certains d'entre vous ont déjà rencontré le problème.
Détail du mode debug
SQL REQUEST : 10 Queries took 0.003s N° Queries Time Errors
1 SELECT *
FROM `glpi_plugins`
WHERE (directory = 'customfields') 0.000
2 SELECT device_type, enabled
FROM glpi_plugin_customfields
WHERE device_type > 0; 0.000
3 SELECT *
FROM glpi_plugin_customfields_dropdowns
WHERE has_entities=1 OR is_tree=1 0.000
4 SELECT *
FROM `glpi_plugins`
WHERE (directory = 'geninventorynumber') 0.000
5 SELECT *
FROM `glpi_plugins`
WHERE (directory = 'geninventorynumber') 0.000
6 SELECT *
FROM `glpi_plugins`
WHERE (directory = 'data_injection') 0.000
7 SELECT *
FROM `glpi_plugins`
WHERE (directory = 'data_injection') 0.000
8 SELECT *
FROM `glpi_plugins`
WHERE (directory = 'genericobject') 0.000
9 SELECT *
FROM `glpi_plugins`
WHERE (directory = 'order') 0.000
10 SHOW TABLES LIKE 'glpi_%' 0.003
POST VARIABLE
GET VARIABLEKEY => VALUE
dump => 1
duree => 28
rowlimit => 5
offsetrow => -1
offsettable => -1
cpt => 10390
fichier => ../files/_dumps/glpi-0.72.4-2010-03-02-19-28.sql
SESSION VARIABLEKEY => VALUE
glpi_currenttime => 2010-03-02 19:29:12
glpi_use_mode => 2
glpiID => 29
glpiname => [...]
glpirealname => [...]
glpifirstname => [...]
glpidefault_entity => 0
glpiauthorisation => 1
glpiextauth => 1
glpiauth_method => 4
glpisearchcount => KEY => VALUE
1 => 1
4400 => 1
glpisearchcount2 => KEY => VALUE
1 => 0
4400 => 0
glpiroot => /glpi
glpicrontimer => 1267554425
glpi_tab => customfields_1
glpilanguage => fr_FR
glpilist_limit => 50
glpidateformat => 1
glpinumberformat => 0
glpiview_ID => 0
glpidropdown_limit => 50
glpiflat_dropdowntree => 0
glpinum_of_events => 50
glpinextprev_item => name
glpijobs_at_login => 0
glpipriority_1 => #fff2f2
glpipriority_2 => #ffe0e0
glpipriority_3 => #ffcece
glpipriority_4 => #ffbfbf
glpipriority_5 => #ffadad
glpiexpand_soft_categorized => 1
glpiexpand_soft_not_categorized => 1
glpitracking_order => 0
glpifollowup_private => 0
glpiprofiles => KEY => VALUE
10 => KEY => VALUE
name => operator-inv-all
entities => KEY => VALUE
90 => KEY => VALUE
ID => 0
name =>
recursive => 0
4 => KEY => VALUE
name => super-admin
entities => KEY => VALUE
51 => KEY => VALUE
ID => 0
name =>
recursive => 1
13 => KEY => VALUE
name => super-operator
entities => KEY => VALUE
89 => KEY => VALUE
ID => 0
name =>
recursive => 0
glpiactiveprofile => KEY => VALUE
ID => 4
name => super-admin
interface => central
is_default => 0
computer => w
monitor => w
software => w
networking => w
printer => w
peripheral => w
cartridge => w
consumable => w
phone => w
notes => w
contact_enterprise => w
document => w
contract => w
infocom => w
knowbase => w
faq => w
reservation_helpdesk => 1
reservation_central => w
reports => r
ocsng => w
view_ocsng => r
sync_ocsng => w
dropdown => w
entity_dropdown => w
device => w
typedoc => w
link => w
config => w
rule_tracking => w
rule_ocs => w
rule_ldap => w
rule_softwarecategories => w
search_config => w
search_config_global => w
check_update => r
profile => w
user => w
user_auth_method => w
group => w
entity => w
transfer => w
logs => r
reminder_public => w
bookmark_public => w
backup => w
create_ticket => 1
delete_ticket => 1
comment_ticket => 1
comment_all_ticket => 1
update_ticket => 1
own_ticket => 1
steal_ticket => 1
assign_ticket => 1
show_all_ticket => 1
show_assign_ticket => 1
show_full_ticket => 1
observe_ticket => 1
update_followups => 1
show_planning => 1
show_group_planning => 1
show_all_planning => 1
statistic => 1
password_update => 1
helpdesk_hardware => 3
helpdesk_hardware_type => 8388674
show_group_ticket => 0
show_group_hardware => 0
rule_dictionnary_software => w
rule_dictionnary_dropdown => w
entities => KEY => VALUE
51 => KEY => VALUE
ID => 0
name =>
recursive => 1
glpiactiveentities => KEY => VALUE
0 => 0
glpiactiveentities_string => '0'
glpiparententities =>
glpiparententities_string =>
glpiactive_entity => 0
glpiactive_entity_name => Entité Racine (arborescence)
glpiactive_entity_shortname => Entité Racine (arborescence)
glpishowallentities => 1
glpigroups =>
glpi_plugin_connections_profile => KEY => VALUE
ID => 4
name => super-admin
connections => w
glpi_plugin_domain_profile => KEY => VALUE
ID => 4
name => super-admin
domain => w
open_ticket =>
glpi_plugin_reports_profile => KEY => VALUE
ID => 4
profile => super-admin
location => r
rules => r
equipmentbylocation => r
equipmentbygroups => r
doublons =>
histoinst =>
licensesexpires => r
pcsbyentity => r
listgroups => r
histohard => r
licenses => r
infocom => r
statnightticketsbypriority => r
globalhisto => r
statticketsbypriority => r
glpi_plugin_rack_profile => KEY => VALUE
ID => 4
name => super-admin
rack => w
model => w
glpi_plugin_geninventorynumber_profile => KEY => VALUE
ID => 4
name => super-admin
interface => geninventorynumber
is_default => 0
generate => w
generate_overwrite => w
glpi_plugin_data_injection_profile => KEY => VALUE
ID => 4
name => super-admin
is_default => 0
model => w
glpi_plugin_order_profile => KEY => VALUE
ID => 4
name => super-admin
order => w
reference => w
budget => w
validation => w
cancel => w
undo_validation => w
glpi_plugins => KEY => VALUE
18 => connections
17 => domain
19 => reports
20 => rack
21 => customfields
23 => geninventorynumber
25 => data_injection
26 => order
MESSAGE_AFTER_REDIRECT =>
glpi_multientitiesmode => 0
glpisearch => KEY => VALUE
1 => KEY => VALUE
start => 0
order => ASC
deleted => 0
distinct => N
link =>
field => KEY => VALUE
0 => view
contains => KEY => VALUE
0 =>
link2 =>
field2 => KEY => VALUE
0 => view
contains2 => KEY => VALUE
0 =>
type2 =>
sort => 1
4400 => KEY => VALUE
start => 0
order => ASC
deleted => 0
distinct => N
link =>
field => KEY => VALUE
0 => view
contains => KEY => VALUE
0 =>
link2 =>
field2 => KEY => VALUE
0 => view
contains2 => KEY => VALUE
0 =>
type2 =>
sort => 1
glpilisttitle => KEY => VALUE
1 => Liste
4400 => Liste
glpilistitems => KEY => VALUE
1 => KEY => VALUE
0 => 900
1 => 1067
2 => 1222
3 => 1223
4 => 1230
5 => 1232
6 => 1463
7 => 1741
8 => 1747
9 => 1759
10 => 1760
11 => 1761
12 => 1762
13 => 1763
14 => 1764
15 => 1785
16 => 1787
17 => 1788
18 => 1795
19 => 1819
20 => 1832
21 => 1833
22 => 1834
23 => 1836
24 => 1837
25 => 1838
26 => 1839
27 => 1841
28 => 1842
29 => 1843
30 => 1844
31 => 1845
32 => 1846
33 => 1847
34 => 1848
35 => 1849
36 => 1856
37 => 1860
38 => 1861
39 => 1862
40 => 1863
41 => 1864
42 => 1865
43 => 1867
44 => 793
45 => 794
46 => 795
47 => 796
48 => 797
49 => 798
4400 => KEY => VALUE
0 => 6
1 => 7
2 => 8
3 => 9
4 => 11
5 => 12
6 => 13
7 => 14
8 => 15
9 => 16
10 => 17
11 => 18
12 => 2
13 => 19
14 => 20
15 => 21
16 => 196
17 => 195
18 => 22
19 => 23
20 => 24
21 => 206
22 => 25
23 => 26
24 => 29
25 => 30
26 => 31
27 => 32
28 => 33
29 => 34
30 => 35
31 => 36
32 => 38
33 => 40
34 => 41
35 => 42
36 => 205
37 => 45
38 => 46
39 => 48
40 => 49
41 => 50
42 => 51
43 => 52
44 => 53
45 => 55
46 => 56
47 => 57
48 => 58
49 => 201
glpilisturl => KEY => VALUE
1 => /glpi/front/computer.php
4400 => /glpi/plugins/domain/index.php
glpimassiveactionselected =>(désolé si ce n'est pas très lisible)
Last edited by billylebegue (2010-03-02 20:37:34)
GLPI 0.72.4 ~ environ 600 matériels réseaux et 2200 serveurs gérés.
Apache/2.2.8 (Ubuntu)
Offline
#2 2010-03-08 19:55:19
- yllen
- GLPI-DEV
- From: Sillery (51)
- Registered: 2008-01-14
- Posts: 15,278
Re: Sauvegarde manuelle - le nom de fichier existe déjà
Il nous faudrait le mode debug lorsque cela ne semble pas complet, là vous avez mis celui du 28 (fichier => ../files/_dumps/glpi-0.72.4-2010-03-02-19-28.sql)
CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6 - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)
Offline
#3 2010-03-09 13:06:41
- billylebegue
- Member
- Registered: 2009-04-09
- Posts: 76
Re: Sauvegarde manuelle - le nom de fichier existe déjà
Le problème est que je n'arrive plus à obtenir le message en 0.72.4.
Je viens de retenter un backup, j'ai une sorte de refresh de la page (difficile à expliquer clairement désolé) puis la barre de défilement passe à 42% (toujours pas de debug) puis 100% et j'ai :
glpi-0.72.4-2010-03-09-11-59.sql 8134 kB 09-03-2010 12:00 Supprimer Restaurer Voir/Télécharger
glpi-0.72.4-2010-03-09-11-58.sql 3971 kB 09-03-2010 11:59 Supprimer Restaurer Voir/Télécharger
En gros pas (plus ?) de mode debug possible puisque le backup ne s'interrompt plus comme auparavant où j'avais le message "le fichier existe déjà" et où je devais recliquer sur le bouton pour sauvegarder. Encore une fois le problème pourrait venir de notre base de données, je ne peux pas exclure ce risque.
GLPI 0.72.4 ~ environ 600 matériels réseaux et 2200 serveurs gérés.
Apache/2.2.8 (Ubuntu)
Offline