Few problems after upgrade

[archived]

Hi,

I'm having few problems that showed after upgrade and some changes I made:

- I'm getting screen full of messages with mysql base - I've caught messages that pluto-system-database is unconfigured - and it seems connected with adding some devices to floorplan with floorplan wizard...

I get this:

Code: [Select]


10      05/15/05 21:02:07.818           Executed query UPDATE `DeviceCategory_DeviceData` SET  `FK_DeviceCategory`='5', `FK_DeviceData`='58', `IK_DeviceData`='0', `Required`='0', `SetByDevice`='0', `AllowedToModify`='1', `Description`='The maximum size of the graphics files stored (MB)', `ShowInWizard`='1', `ShortDescription`='1', `psc_id`='20', `psc_batch`='1', `psc_user`=NULL, `psc_frozen`='0', `psc_mod`='0' WHERE psc_id=20 AND (psc_batch is NULL OR psc_batch=0 OR (psc_batch>0 AND psc_batch<=206)) (0 rows)
10      05/15/05 21:02:07.820           Executed query UPDATE `DeviceCategory_DeviceData` SET  `FK_DeviceCategory`='76', `FK_DeviceData`='37', `IK_DeviceData`=NULL, `Required`='0', `SetByDevice`='0', `AllowedToModify`='1', `Description`='A/V equipment port.', `ShowInWizard`='1', `ShortDescription`='1', `psc_id`='21', `psc_batch`='1', `psc_user`=NULL, `psc_frozen`='0', `psc_mod`='0' WHERE psc_id=21 AND (psc_batch is NULL OR psc_batch=0 OR (psc_batch>0 AND psc_batch<=206)) (0 rows)
10      05/15/05 21:02:07.821           Executed query UPDATE `DeviceCategory_DeviceData` SET  `FK_DeviceCategory`='5', `FK_DeviceData`='64', `IK_DeviceData`='0', `Required`='0', `SetByDevice`='0', `AllowedToModify`='0', `Description`='If true, use Pluto\'s proprietary format for faster loading', `ShowInWizard`='1', `ShortDescription`='1', `psc_id`='22', `psc_batch`='1', `psc_user`=NULL, `psc_frozen`='0', `psc_mod`='0' WHERE psc_id=22 AND (psc_batch is NULL OR psc_batch=0 OR (psc_batch>0 AND psc_batch<=206)) (0 rows)
10      05/15/05 21:02:07.822           Executed query UPDATE `DeviceCategory_DeviceData` SET  `FK_DeviceCategory`='5', `FK_DeviceData`='72', `IK_DeviceData`='200', `Required`='0', `SetByDevice`='0', `AllowedToModify`='1', `Description`='', `ShowInWizard`='1', `ShortDescription`='1', `psc_id`='23', `psc_batch`='135', `psc_user`='33129', `psc_frozen`='0', `psc_mod`='0' WHERE psc_id=23 AND (psc_batch is NULL OR psc_batch=0 OR (psc_batch>0 AND psc_batch<=206)) (0 rows)
10      05/15/05 21:02:07.823           Executed query UPDATE `DeviceCategory_DeviceData` SET  `FK_DeviceCategory`='5', `FK_DeviceData`='75', `IK_DeviceData`='70', `Required`='1', `SetByDevice`='0', `AllowedToModify`='1', `Description`='The quality of the jpeg files sent to PlutoMO. This is only used by BluetoothDongle.', `ShowInWizard`='1', `ShortDescription`='1', `psc_id`='24', `psc_batch`='175', `psc_user`='33129', `psc_frozen`='0', `psc_mod`='0' WHERE psc_id=24 AND (psc_batch is NULL OR psc_batch=0 OR (psc_batch>0 AND psc_batch<=206)) (0 rows)
01      05/15/05 21:02:07.824           Query failed (Duplicate entry '93-11' for key 1): INSERT INTO `DeviceCategory_DeviceData` VALUES( '93','11',NULL,'0','0','1','Floorplan object type','1','1','25','206','33129','0','0' ) (-1)
05      05/15/05 21:02:07.824           Resetting mysql connection
10      05/15/05 21:02:07.824           Executed query INSERT INTO `DeviceCategory_DeviceData` VALUES( '93','11',NULL,'0','0','1','Floorplan object type','1','1','25','206','33129','0','0' ) (0 rows)
SQL Failed: INSERT INTO `DeviceCategory_DeviceData` VALUES( '93','11',NULL,'0','0','1','Floorplan object type','1','1','25','206','33129','0','0' )
Caught exception: Database error
dpkg: error processing pluto-system-database (--configure):
 subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
 pluto-system-database



The sad thing is that when processing all those errors (whole process starts at each dpkg use) - network is not working (Pluto is my home ADSL-Firewall device). It would be nice if pluto handles such situations better - like network to be functional before Pluto and other things get started and messed if something goes wrong...

After upgrade to rel .18 I cannot see Xine anymore - audio is heard, but blank screen is seen. I get this in Xine player log:

Code: [Select]



10 05/15/05 21:23:28.112 Receive string: MESSAGE 85            
10 05/15/05 21:23:28.153 Got a stop media for stream ID 1
10 05/15/05 21:23:28.380 Got those numbers: 1638000, 7278600
10 05/15/05 21:23:28.380 Stream paused at time: 1638000 from 7278600
10 05/15/05 21:23:28.380 After pause media 1
10 05/15/05 21:23:28.380 Got those numbers: 1638000, 7278600
10 05/15/05 21:23:28.380 position 1638000
10 05/15/05 21:23:28.380 Stopping event thread.
10 05/15/05 21:23:28.679 Done.
10 05/15/05 21:23:28.679 Disposing the event queue
10 05/15/05 21:23:28.679 Stream was disposed
10 05/15/05 21:23:28.689 Calling xine_stop for stream with id: 1
10 05/15/05 21:23:28.730 Calling xine_close for stream with id: 1
10 05/15/05 21:23:28.771 Calling xine_dispose for stream with id: 1
10 05/15/05 21:23:29.240 Calling xine_close_audio_driver for stream with id: 1
10 05/15/05 21:23:29.900 Calling xine_close_video_driver for stream with id: 1
10 05/15/05 21:23:30.063 Cleanup completed
10 05/15/05 21:23:30.063 The stream playback should be stopped at this moment and the resources should be freed!
10 05/15/05 21:23:30.382 Receive string: MESSAGE 70            
10 05/15/05 21:23:30.382 Could not find a handler for message - from 6613 to 6626 Type: 1 ID: 193 (device: 6626) Command_Impl1 Dev #6626
10 05/15/05 21:23:36.994 Receive string: MESSAGE 145          
05 05/15/05 21:23:36.994 Xine_Player::CMD_Play_Media() called.
10 05/15/05 21:23:36.994 Instructing ratpoison to do this: ":select pluto-xine-playback-window"
10 05/15/05 21:23:37.180 Command result: ""
10 05/15/05 21:23:37.180 Exiting rat poison command
10 05/15/05 21:23:37.217 Got a play media command for /home/public/data/videos/Godba_Hramse/godba_hramse_2005.avi
10 05/15/05 21:23:37.217
10 05/15/05 21:23:37.217 Testing to see if we can reuse the stream.
10 05/15/05 21:23:37.217 Nope .. making a new one
xine: found input plugin  : file input plugin
load_plugins: probing demux 'asf'
load_plugins: probing demux 'aud'
load_plugins: probing demux 'aiff'
load_plugins: probing demux 'cdda'
load_plugins: probing demux 'flac'
load_plugins: probing demux 'nsf'
load_plugins: probing demux 'realaudio'
load_plugins: probing demux 'snd'
load_plugins: probing demux 'voc'
load_plugins: probing demux 'vox'
load_plugins: probing demux 'wav'
load_plugins: probing demux 'mod'
TEST mod decode
load_plugins: probing demux 'aac'
load_plugins: probing demux 'ac3'
load_plugins: probing demux 'mp3'
load_plugins: probing demux 'avi'
failed to read 8 bytes at pos 754919424
demux_avi: 181965 frames
xine: found demuxer plugin: AVI/RIFF demux plugin
demux_avi: audio format[0] = 0x55
demux_avi: audio type MPEG layer 2/3 (wFormatTag 0x55)
info_helper: can't find out current locale character set
info_helper: can't find out current locale character set
demux_avi: video codec is 'DivX 5 format'
video discontinuity #1, type is 0, disc_off 0
waiting for audio discontinuity #1
audio discontinuity #1, type is 0, disc_off 0
waiting for in_discontinuity update #1
vpts adjusted with prebuffer to 1138637472
load_plugins: plugin ffmpegvideo will be used for video streamtype 1c.
load_plugins: plugin mad will be used for audio streamtype 01.
10 05/15/05 21:23:40.360 Stream info audio channels 1
audio_alsa_out:open pause_resume=1
output sample rate 24000
10 05/15/05 21:23:40.957 Opened.....
10 05/15/05 21:23:40.957 Got image dimensions: 1x1
10 05/15/05 21:23:40.958 Creating event processor
10 05/15/05 21:23:40.958 Event processor started
10 05/15/05 21:23:41.190 Playing... The command took 4 seconds to complete:
10 05/15/05 21:23:41.190 Starting audio stream from position: 0
10 05/15/05 21:23:41.401 Receive string: MESSAGE 74            
10 05/15/05 21:23:41.401 Could not find a handler for message - from 6613 to 6626 Type: 1 ID: 192 (device: 6626) Command_Impl1 Dev #6626



Before upgrade this situation occured only occasionaly, but now it stays without exception - I cannot see Xine on screen anymore....

Also: I have Nvidia graphic card with two outputs - is there any way to have Orbiter running on VGA output (for touchscreen) and MD running on Video output on my TV (Xv should be active on this screen) ?


Remote access is still opened...

HTH,

regards,

Rob.

[archived]

We solved this.  A record had been added locally to the system tables that used the same foreign keys as one we added on our side.  when you run sqlCVS interactively, it will tell you this and ask you if you want to revert your local changes.  However, when it's run in the post install script with the -n (no prompts) option, it just aborts.