Net Packets out of order : received[0], expected[1]

[kenny]

Hi,
I'm now using MyDac v3.30.2.15 Delphi 5.
Sometimes I encountered the error when open the query. Why?

Net Packets out of order : received[0], expected[1]

Thanks

[Ikar]

Please send us complete small sample to demonstrate it and include script to create server objects.

[ramajana]

I also have this error with your newest build. Do you still need sample?

[ebangert]

Dear all,

I also this error with last version 3.30.2.15 under Builder C++ 5.0.
This occured apparently only on Win98 client but not under XP.

I try also to uncheck compressed protocol but no result.


Serveur Mysql 4-0-16-standard log under linux.

Thanks for your support


Query :

INSERT INTO TUB (DESIGNATION, REF_FOUR, REF_SEIHE, FOURN, `PRIX U_HT`, CONDT, DELAIS, PAIEMENT) values(
'COLONNE D EXHAURE INOX DN150 DE 50ML AVEC DECHARDE DE 6ML A BRIDE/BRIDE + PLATEAU DN300',
'DEVIS W04/GC/0096',
'TUB-DEVIS W04/GC/0096',
'JOHNSON SCREENS DIVISION TUBAFOR',
5930.00,
'1',
'15',
'60JFDM'
)



CREATE TABLE `TUB` (
`DESIGNATION` char(255) NOT NULL default '',
`REF_FOUR` char(255) NOT NULL default '',
`REF_SEIHE` char(255) NOT NULL default '',
`FOURN` char(255) NOT NULL default '',
`PRIX U_HT` decimal(14,4) NOT NULL default '0.0000',
`CONDT` float NOT NULL default '0',
`DELAIS` smallint(6) NOT NULL default '0',
`PAIEMENT` char(50) NOT NULL default '',
PRIMARY KEY (`DESIGNATION`)
) TYPE=MyISAM

[Paul]

Sorry, we cannot reproduce this problem. Small Delphi project will be appreciated.

[Ikar]

We couldn't reproduce the problem. It seems its appearance depends on transfering data. Please follow the next steps:

1. Stop the server and create a reserve copy of mysql\data\test\TUB.* at the server.
2. Send us these files. If data volume is too large or it is impossible by some reasons, try to decrease a number of records.
3. Send us your configuration file of MySQL Server (my.ini).
4. Attach simplest Delphi-project to demonstrate the problem.

[applemac]

Dear ALL
I also got this type of error.

the following TMyQuery sould work without problem
but as [Alias] add in SQL.String SQL Statement this problem will be trigger.

SQL.Strings = (
'SELECT'
' *'
'FROM RVS'
'reference_van_sales'
'ORDER BY Ref_Prefix'
'')

object sReferenceCounterSQL: TMyQuery
SQLInsert.Strings = (
'INSERT INTO referenceCounter'
' (Itemno, CASH, DO, INV, SIN, SOT, IsLOCK, Timestamp_)'
'VALUES'
' (:Itemno, :CASH, :DO, :INV, :SIN, :SOT, :IsLOCK, :Timestamp_)')
SQLDelete.Strings = (
'DELETE FROM referenceCounter'
'WHERE'
' Itemno = :Old_Itemno')
SQLUpdate.Strings = (
'UPDATE referenceCounter'
'SET'

' Itemno = :Itemno, CASH = :CASH, DO = :DO, INV = :INV, SIN = :S' +
'IN, SOT = :SOT, IsLOCK = :IsLOCK, Timestamp_ = :Timestamp_'
'WHERE'
' Itemno = :Old_Itemno')
SQLRefresh.Strings = (

'SELECT referenceCounter.Itemno, referenceCounter.CASH, reference' +
'Counter.DO, referenceCounter.INV, referenceCounter.SIN, referenc' +
'eCounter.SOT, referenceCounter.IsLOCK, referenceCounter.Timestam' +
'p_ FROM referenceCounter'
'WHERE'
' referenceCounter.Itemno = :Old_Itemno')
Connection = nData.dConnection
SQL.Strings = (
'select * from referenceCounter')
CachedUpdates = True
FetchAll = True
CommandTimeout = 30
Left = 16
Top = 88
end
object sRef_VanSalesSQL: TMyQuery
SQLInsert.Strings = (
'INSERT INTO reference_van_sales'

' (Ref_Prefix, Ref_Number, Reference_Type, Saleman_ID, Descripti' +
'ons, Status, Locked)'
'SELECT'
' :Ref_Prefix,'
' :Ref_Number, '
' RPT.Reference_Type, '
' :Saleman_ID, '
' :Descriptions, '
' :Status, '
' :Locked'
'FROM'
' reference_prefix_type RPT'
'WHERE'
' RPT.Ref_Prefix = :Ref_Prefix')
SQLDelete.Strings = (
'DELETE FROM reference_van_sales'
'WHERE'
' Ref_Prefix = :Old_Ref_Prefix')
SQLUpdate.Strings = (
'UPDATE reference_van_sales RVS, reference_prefix_type RPT'
'SET'
' RVS.Ref_Prefix = :Ref_Prefix, '
' RVS.Ref_Number = :Ref_Number, '
' RVS.Reference_Type = RPT.Reference_Type, '
' RVS.Saleman_ID = :Saleman_ID, '
' RVS.Descriptions = :Descriptions, '
' RVS.Status = :Status, '
' RVS.Locked = :Locked'
'WHERE'
' RVS.Ref_Prefix = :Old_Ref_Prefix AND'
' RPT.Ref_Prefix = :Ref_Prefix')
SQLRefresh.Strings = (

'SELECT reference_van_sales.Ref_Prefix, reference_van_sales.Ref_N' +
'umber, reference_van_sales.Reference_Type, reference_van_sales.S' +
'aleman_ID, reference_van_sales.Descriptions, reference_van_sales' +
'.Status, reference_van_sales.Locked FROM reference_van_sales'
'WHERE'
' reference_van_sales.Ref_Prefix = :Old_Ref_Prefix')
Connection = nData.dConnection
SQL.Strings = (
'SELECT'
' *'
'FROM'
'reference_van_sales'
'ORDER BY Ref_Prefix'
'')
FetchRows = 1
CachedUpdates = True
FetchAll = True
CommandTimeout = 30
Left = 56
Top = 88
end

[Ikar]

The example you sent us doesn't make any sense without a script to create and fill tables. Beside that we need to know the next:

1. Do you use compression (MyConnection.Options.Compress)?
2. What MyDAC version (3.XX.XX.XX) do you use?
3. What MySQL version (4.X.XX) do you use?

[blindber]

Hi,
Just checking if the cause of this problem has been found, as I am intermittently getting it with MyDac 3.50.0.16 under BCB 6 and mysql 3.23.55 running on win 2k

[peterviau]

Are you using multiple threads in your application?
I ran into this issue because I was running multiple threads using the same Connections/Tables

[Jeffl]

Having just updated to 3.50.20 for D7 I now get the net packets out of sequence using a project and database that were working previously.
Not server version (4.17 and 5.03), not compression. My platform win2k

[Ikar]

What is the previous version of MyDAC that you use?

[StoneWeasel (guest)]

I also had this problem. Was caused by a thread and a form using the same connection. I created a new connection in the thread instead and this seemed to solve the problem.